Reserved Words Used in MySQL Newest Version
Today I will share with you all the reserved words that I’ve learned from my updated MySQL Database Server Version 5.5. This version has been released since Jan 14, 2010 by Oracle. I used to have MySQL v. 5.1 on my Apache server, now I updated to the latest version. The list below includes the reserved words from the latest version which is 5.5. The bottom of this page is the list of reserved words from previous versions. I will explain how these reserved words…
Get the last id from a table
If you need an ID before you can get the data from user’s inputs, you can use the query below to get the last id from a table in your database, and then you can increment 1 to that id. For example, a brand new ID can be assigned to an online order using the last id from the table and add 1 to it. Here’s what you can do: Send a query that return the last id of a table using either query below:…