European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: syntax of auto increment field
By: VB guy	Date: 05/11/2004 19:30:00	Points: 125	Status: Answered Quality : Excellent
hi, i want a column serial no. insert into table with auto increment. please tell me the syntax of this new field.
By: VGR	Date: 05/11/2004 19:51:00		Type : Answer
ALTER TABLE yourtable ADD serialno integer unique auto_increment; see CREATE TABLE syntax at www.mysql.com in the online Manual

By: Big_Red_Dog	Date: 05/11/2004 23:27:00		Type : Comment
In your CREATE TABLE, the syntax is something like: serial_number INT UNSIGNED NOT NULL AUTO_INCREMENT

By: Squibi	Date: 06/11/2004 03:58:00		Type : Comment
If you have created your table already and do not wish to delete it and start over, I would use VGR statement above, with the exception of integer, which should be INT :) FYI, there is 5 Integer types for MySQL: INT, TINYINT, SMALLINT, MEDIUMINT, BIGINT. This does not include ENUM either.

By: VGR	Date: 06/11/2004 04:24:00		Type : Comment
non non non MySQL supports all of the SQL-92 numeric data types. These types include the exact numeric data types (NUMERIC, DECIMAL, INTEGER, and SMALLINT), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keyword DEC is a synonym for DECIMAL. dtc

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 95.578910 milliseconds

Why Google AdSense ads ?

New Improved Search!