PHP mySQL - Insert new record into table with auto-increment on primary key

PhpMysqlInsertAuto Increment

Php Problem Overview

Wondering if there is a shorthand version to insert a new record into a table that has the primary key enabled? (i.e. not having to include the key column in the query) Lets say the key column is called ID, and the other columns are Fname, Lname, and Website

$query = "INSERT INTO myTable VALUES ('Fname', 'Lname', 'Website')";

Php Solutions

Solution 1 - Php

Use the DEFAULT keyword:

$query = "INSERT INTO myTable VALUES (DEFAULT,'Fname', 'Lname', 'Website')";

Also, you can specify the columns, (which is better practice):

$query = "INSERT INTO myTable
          (fname, lname, website)
          VALUES
          ('fname', 'lname', 'website')";

Reference:

Solution 2 - Php

I prefer this syntaxis:

$query = "INSERT INTO myTable SET fname='Fname',lname='Lname',website='Website'";

Solution 3 - Php

$query = "INSERT INTO myTable VALUES (NULL,'Fname', 'Lname', 'Website')";

Just leaving the value of the AI primary key NULL will assign an auto incremented value.

Solution 4 - Php

This is phpMyAdmin method.

$query = "INSERT INTO myTable
         (mtb_i_idautoinc, mtb_s_string1, mtb_s_string2) 
         VALUES
         (NULL, 'Jagodina', '35000')";

Solution 5 - Php

You can also use blank single quotes for the auto_increment column. something like this. It worked for me.

$query = "INSERT INTO myTable VALUES ('','Fname', 'Lname', 'Website')";
Categories
Recommended Php Solutions
Recommended Mysql Solutions
Recommended Insert Solutions
Recommended Auto Increment Solutions

Previous Solution:

Can I set a breakpoint when variable is getting a specific value in .NET?

.NetVisual StudioDebuggingBreakpointsConditional Breakpoint

Next Solution:

Problem inflating custom view for AlertDialog in DialogFragment

AndroidAndroid AlertdialogAndroid FragmentsAndroid InflateLayout Inflater

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionJimmyJammedView Question on Stackoverflow
Solution 1 - PhpregalityView Answer on Stackoverflow
Solution 2 - Phpjenkin90View Answer on Stackoverflow
Solution 3 - PhpKorvin SzantoView Answer on Stackoverflow
Solution 4 - PhpminimalView Answer on Stackoverflow
Solution 5 - PhpRahul BharatiView Answer on Stackoverflow