Re: creating first table

2005-01-07 Thread SGreen
"Gerald Preston" <[EMAIL PROTECTED]> wrote on 01/07/2005 01:02:04 AM: > Hi! > Running mysql on a XP command line. Doing "dhow" databases" list the > following; > > Database > > Club > > Mysql > > Test > > I did a grant all user id; > > How can I list the rows and columns. One of these may he

RE: creating first table

2005-01-07 Thread Tom Crimmins
[snip] How can I list the rows and columns. [/snip] http://dev.mysql.com/doc/mysql/en/SELECT.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

creating first table

2005-01-06 Thread Gerald Preston
Hi! Running mysql on a XP command line. Doing "dhow" databases" list the following; Database Club Mysql Test I did a grant all user id; How can I list the rows and columns. I tried "alter table club add < ME varchar( 3));" and get : You have an error in your SQL syntax;