|
Home >> FAQs/Tutorials >> MySQL Tutorials
MySQL Tutorial - Define the ID Column as Auto-Incremented
By: FYIcenter.com
(Continued from previous topic...)
How To Define the ID Column as Auto-Incremented?
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
(Continued on next topic...)
- How To Create a New Table?
- How To Get the Number of Rows Selected or Affected by a SQL Statement?
- How To Insert Data into an Existing Table?
- How To Fix the INSERT Command Denied Error?
- How To Insert Multiple Rows with a SELECT Statement?
- What Is a Result Set Object?
- How To Query Tables and Loop through the Returning Rows?
- How To Break Query Output into Pages?
- How To Update Existing Rows in a Table?
- How To Delete Existing Rows in a Table?
- How To Quote Text Values in SQL Statements?
- How To Quote Date and Time Values in SQL Statements?
- How To Display a Past Time in Days, Hours and Minutes?
- How To Perform Key Word Search in Tables?
- How To Build WHERE Criteria with Web Form Search Fields?
- How To Query Multiple Tables Jointly?
- How To Define the ID Column as Auto-Incremented?
- How To Get the Last ID Assigned by MySQL?
| 