Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Get the ID Column Auto-Incremented
How To Get the ID Column Auto-Incremented? - PHP Script Tips - Working with MySQL Database
✍: FYIcenter.com
Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow MySQL server to automatically assign a new ID number for each new record, you can define the ID column with AUTO_INCREMENT and PRIMARY KEY attributes as shown in the following sample script:
<?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_users (" . " id INTEGER NOT NULL AUTO_INCREMENT" . ", name VARCHAR(80) NOT NULL" . ", email VARCHAR(80)" . ", time TIMESTAMP DEFAULT sysdate()" . ", PRIMARY KEY (id)" . ")"; if (mysql_query($sql, $con)) { print("Table fyi_links created.\n"); } else { print("Table creation failed.\n"); } mysql_close($con); ?>
If you run this script, a new table will be created with ID column defined as auto-increment. The sample script below inserts two records with ID values assigned by MySQL server:
<?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_users (name) VALUES ('John King')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } $sql = "INSERT INTO fyi_users (name) VALUES ('Nancy Greenberg')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } $sql = "SELECT id, name, time FROM fyi_users"; $rs = mysql_query($sql, $con); while ($row = mysql_fetch_assoc($rs)) { print($row['id'].", ".$row['name'].", ".$row['time']."\n"); } mysql_free_result($rs); mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows inserted. 1 rows inserted. 1, John King, 2006-02-26 23:02:39 2, Nancy Greenberg, 2006-02-26 23:02:39
2007-04-14, 5120👍, 0💬
Popular Posts:
How To Enter Characters as HEX Numbers? - MySQL FAQs - Introduction to SQL Basics If you want to ent...
Can you explain in brief how the ASP.NET authentication process works? ASP.NET does not run by itsel...
What is application domain? Explain. An application domain is the CLR equivalent of an operation sys...
How To Delete a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privilege...
If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...