Pages

Wednesday, January 1, 2014

How to run MySQL query in php script when table name is a number

If you're using numbers as table names or if they start with a number, you need to escape them using backticks.

 Ex) Insert query

$sql1 = "INSERT INTO `9998` (forward_speed) VALUES (50);"
 
 

1 comment:

  1. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care
    http://chennaitraining.in/qliksense-training-in-chennai/
    http://chennaitraining.in/pentaho-training-in-chennai/
    http://chennaitraining.in/machine-learning-training-in-chennai/
    http://chennaitraining.in/artificial-intelligence-training-in-chennai/
    http://chennaitraining.in/snaplogic-training-in-chennai/
    http://chennaitraining.in/snowflake-training-in-chennai/

    ReplyDelete