Collections:
Inserting Data into an Existing Table in MySQL
How To Insert Data into an Existing Table in MySQL?
✍: FYIcenter.com
If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script:
<?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 101, 'dev.fyicenter.com')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
Remember that mysql_query() returns integer/FALSE on INSERT statements. If you run this script, you could get something like this:
SQL statement failed with error: 1142: INSERT command denied to user 'dev'@'localhost' for table 'fyi_links'
⇒ Fixing INSERT Command Denied Error in MySQL
⇐ Number of Rows Selected or Affected in MySQL
2017-10-08, 1457🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...