PDA

View Full Version : MySQL newbie


tangy
10-10-2006, 09:30 AM
Hello all have installed MySql server 5.0, i am getting in ruby on rails for commerce pages. i have followed examples on the commands to use. So far all i can create databases within the mysql command prompt 'create database namehere;'
That works fine, its how do i create a table for that database, all the commands i try and use dont seem to work. have tryied 'use databasename', and 'connect database' then tryied to create tables. whats the best way to start and the best (program) for a newbie to use. I am using windowsXP.

Thanks

tangy :)

homerUK
10-13-2006, 02:13 PM
I'd recommend getting the mysql toolkit - http://dev.mysql.com/downloads/gui-tools/5.0.html - it has some good tools - I couldnt live without mysql Query Browser!!! (That also lets you create tables etc in a gui mode)