How To Get the Last ID Assigned by MySQL

Q

How To Get the Last ID Assigned by MySQL? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts

✍: FYIcenter.com

A

If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below:

<?php
  include "mysql_connection.php";

  $sql = "INSERT INTO fyi_users (name)" 
     . " VALUES ('John King')";
  if (mysql_query($sql, $con)) {
    print(mysql_affected_rows() . " rows inserted.\n");
    print("Last ID inserted: ".mysql_insert_id()."\n");
  } else {
    print("SQL statement failed.\n");
  }

  mysql_close($con); 
?>

If you run this script, you will get something like this:

1 rows inserted.
Last ID inserted: 3

2007-05-11, 6892👍, 0💬

How To Build WHERE Criteria with Web Form Search Fields
How To Build WHERE Criteria with Web Form Search Fields? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If your PHP script is linked to a Web form which takes search key words for multiple data fields. For example, your Web form asks your visitor to search for Website links with... 2007-05-11, 6818👍, 0💬

How To Display a Past Time in Days, Hours and Minutes
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the TIMEDIFF() SQL function. Note that the TI... 2007-05-11, 6555👍, 0💬

How To Query Multiple Tables Jointly
How To Query Multiple Tables Jointly? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "use... 2007-05-11, 5648👍, 0💬

How To Perform Key Word Search in Tables
How To Perform Key Word Search in Tables? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern... 2007-05-11, 5401👍, 0💬

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 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 ea... 2007-05-11, 5365👍, 0💬

How To Shut Down the Server with "mysqladmin"
How To Shut Down the Server with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to shut down the server with "mysqladmin", you can use the command "mysqladmin shutdown" as shown in the following tutorial example: >cd \mysql\bin >mysqladmin -u root shutdown If ... 2007-05-11, 4988👍, 0💬

What Is "mysqladmin"
What Is "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqladmin" is a command-line interface for administrators to perform server administration tasks. It support a number of commonly used commands like: "mysqladmin shutdown" - Shuts down the server. "mysqladmin ping" ... 2007-05-11, 4900👍, 0💬

How To Check Server Status with "mysqladmin"
How To Check Server Status with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to check the server status by with "mysqladmin", you can following this tutorial example: >cd \mysql\bin >mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries:... 2007-05-11, 4740👍, 0💬

What Tools Available for Managing MySQL Server
What Tools Available for Managing MySQL Server? - MySQL FAQs - Administrator Tools for Managing MySQL Server MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin ... 2007-05-11, 4733👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.