Re: 2 questions on Auto Increment fields

2005-08-05 Thread Scott Noyes
> 1) For what I see on the MySQL manual you can have an Auto Increment not > null Field as the primary key. Say that you have a table with only > two columns the first being an Auto_Increment. How do I write an INSERT > or REPLACE SQL statement to insert data on this table? Can > I write it so that

2 questions on Auto Increment fields

2005-08-05 Thread C.F. Scheidecker Antunes
Hello all, I have two question on Auto Increment fields: 1) For what I see on the MySQL manual you can have an Auto Increment not null Field as the primary key. Say that you have a table with only two columns the first being an Auto_Increment. How do I write an INSERT or REPLACE SQL statement