Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What's the correct SQL syntax for...
- Thread starter webIntern
- Start date
sleipnir214
Programmer
Assume:
Either of:
Would insert the value and cause MySQL to set the ID column to the auto_increment.
Want the best answers? Ask the best questions: TANSTAAFL!!
Code:
create table foo
(
ID int unsigned auto_increment primary key,
name varchar(10)
)Either of:
Code:
INSERT INTO foo (name) values ('foo')
INSERT INTO foo (ID, name) values (NULL, 'foo')Would insert the value and cause MySQL to set the ID column to the auto_increment.
Want the best answers? Ask the best questions: TANSTAAFL!!
- Status