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

by

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:

More Related Contents:

  1. Using PHP read word in textarea line by line and insert to mySQL
  2. How to insert multiple rows from array using CodeIgniter framework?
  3. PHP mysql insert date format
  4. Incorrect Integer (2147483647) is inserted into MySQL?
  5. Escaping single quote in PHP when inserting into MySQL [duplicate]
  6. PHP/MySQL Insert null values
  7. MySQL – ignore insert error: duplicate entry
  8. Object of class DateTime could not be converted to string
  9. Prevent InnoDB auto increment ON DUPLICATE KEY
  10. php run once and insert twice in mysql database
  11. Replacing \r\n with PHP
  12. multiple auto increment in mysql
  13. MySQL Join two tables with comma separated values
  14. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  15. Connect DATABASE Error TYPE: 2002: Permission denied
  16. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  17. How to convert MySQL time to UNIX timestamp using PHP?
  18. How to specify the parent query field from within a subquery in MySQL?
  19. MySQL ORDER BY rand(), name ASC
  20. CONCAT columns with Laravel 5 eloquent
  21. array_push() vs. $array[] = …. Which is fastest? [duplicate]
  22. Store html entities in database? Or convert when retrieved?
  23. avoiding MySQL injections with the Zend_Db class
  24. using the browser prompt to download a file
  25. How can I use DATE() in Doctrine 2 DQL?
  26. How to create a database-driven multi-level navigation menu using Laravel
  27. MySqli Commands out of sync; you can’t run this command now [duplicate]
  28. Insert non-English decimal points in mysql
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. How to upload image PHP and insert path in MySQL?

Leave a Comment