Collections:
Creating a New Table in MySQL
How To Create a New Table in MySQL?
✍: FYIcenter.com
If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script:
<?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)" . ", counts INTEGER" . ", time TIMESTAMP DEFAULT CURRENT_TIMESTAMP()" . ")"; if (mysql_query($sql, $con)) { print("Table fyi_links created.\n"); } else { print("Table creation failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
Remember that mysql_query() returns TRUE/FALSE on CREATE statements. If you run this script, you will get something like this:
Table fyi_links created.
⇒ Number of Rows Selected or Affected in MySQL
⇐ Managing Tables and Running Queries with PHP for MySQL
2017-10-08, 1482🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...