Hey there,
I know this might sound like a stupid question to a lot of you guys out
there but please keep in mind I come from an oracle background and am new to
this:

I am accessing MySql from PHP, I have two questions regarding Auto_Increment

1) how to create an auto_increment?

create table MyTestTable(cno int, name varchar(20));
works fine, but I want "cno" as an auto_increment, what statement to use?

2)to insert int  into my example I will use
insert into MyTestTable(555,'Ryan');
How would I do it if I was entering data and the cno was an auto increment?

I have glossed through the manual, but frankly after 6 hours of PHP
programming i'm feeling braindead so PLEASE dont ask me to RTFM, if you have
links to the specific topic in the manual no problem, just tired of
searching.

Cheers all,
-Ryan.



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to