$ Hostname = "localhost"; // defines the name of the connected mysql server
$ Username = "root"; // defines the user name used for connection.
$ Password = ""; // defines the password used for connection.
$ Link = mysql_connect ($ hostname, $ username, $ password); // connect to the mysql server
Mysql_select_db ("test", $ link); // select a database tutorial
// Define an SQL statement
$ SQL _str = "update friends set name = 'Andy 'where id = 1 ";
Mysql_query ($ SQL _str) or die ("error! "); // Execute SQL query
Echo mysql_info ($ link );
// Define the SQL statement and perform the modification operation
$ SQL _str = "insert into friends (name, sex, birthday, address) values ('Chen Jing Qiu ', 'male', '2017-08-23', 'day marks ')";
Mysql_query ($ SQL _str) or die ("error! "); // Execute SQL query
Printf ("The id value of the last insert operation is: % dn", mysql_insert_id (); // return the id value affected by insert