Re: mySQL GUI

2003-04-05 Thread Grgoire Dubois
MySQLCC crashed with me on redhat 7.3... Always at the same time. When I choose a data type for my first column in my first new table. Brian McCain wrote: MySQLCC is pretty popular, and it's probably the easiest to set up. http://www.mysql.com/products/mysqlcc/index.html I like MySQLTool

Re: Primary key

2003-04-04 Thread Grgoire Dubois
Victoria Reznichenko wrote: On Friday 04 April 2003 15:37, Grgoire Dubois wrote: In the following table, I declare ID as a PRIMARY KEY. Is it then necessary to add the parameters NOT NULL AUTO_INCREMENT? CREATE TABLE company ( ID INT NOT NULL AUTO_INCREMENT, name VARCHAR(30

Re: Primary key

2003-04-04 Thread Grgoire Dubois
Bruce Feist wrote: Grgoire Dubois wrote: Victoria Reznichenko wrote: On Friday 04 April 2003 15:37, Grgoire Dubois wrote: In the following table, I declare ID as a PRIMARY KEY. Is it then necessary to add the parameters NOT NULL AUTO_INCREMENT? CREATE TABLE company ( ID INT NOT NULL