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? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: 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 CURRENT_TIMESTAMP()" . ", PRIMARY KEY (id)" . ")"; if (mysql_query($sql, $con)) { print("Table fyi_users 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:
If you run this script, you will get something like this:
1 rows inserted. 1 rows inserted. 1, John King, 2006-07-01 23:02:39 2, Nancy Greenberg, 2006-07-01 23:02:39
2007-05-11, 5431👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - Can we use events with threading ? Yes, you can use events with thread; t...
What is page thrashing? Some operating systems (such as UNIX or Windows in enhanced mode) use virtua...
How can you enable automatic paging in DataGrid ? Following are the points to be done in order to en...
What Are Named Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Name...
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and F...