Sql syntax error in dropping tabels

Question

I am using phpMyadmin as a database and I can't drop the tables ...how to spot the syntax error?

<?php       
include 'dbconnect.php';  //connect to DB  
//Droping The tables  
$dropping = @mysql_query('DROP TABLE IF EXISTS rents, criticise, writesIn, writenIn, translated, reads, worksIn, inStock, playsIN, store, genre, employee, newspaper, customer, critic, language, actor, film, city ;'); 
if (!$dropping) {   
  exit('<p>Error dropping the tables<br />'.   
      'Error: ' . mysql_error() . '</p>');   
}       
if ($dropping) {   
  echo 'everything went just fine dropping the tables<br>';   
}

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads,worksIn,inStock,playsIN,store,genre,employee,newspaper,customer,critic,lan' at line 1 — osher
– osher, Commented Apr 9, 2015 at 10:08
phpMyadmin as a database no phpmyadmin is not a database! try to understand what you did on php and sql (and no, its not the same!) — donald123
– donald123, Commented Apr 9, 2015 at 10:09

TiiJ7 · Accepted Answer · 2015-04-09 10:11:48Z

1

reads is a reserved MySQL keyword. You need to enclose it in backticks:

DROP TABLE IF EXISTS rents, criticise, writesIn, writenIn, translated, `reads`, worksIn, inStock, playsIN, store, genre, employee, newspaper, customer, critic, language, actor, film, city

answered Apr 9, 2015 at 10:11

TiiJ7

3,4225 gold badges27 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ghostman · Accepted Answer · 2015-04-09 10:13:32Z

0

$dropping = @mysql_query('DROP TABLE IF EXISTS rents, criticise, writesIn, writenIn, translated, `reads`, worksIn, inStock, playsIN, store, genre, employee, newspaper, customer, critic, language, actor, film, city  ');

remove the semicolon ; and use backticks for reads as its a keyword

edited Apr 9, 2015 at 10:13

answered Apr 9, 2015 at 10:10

Ghostman

6,1129 gold badges36 silver badges53 bronze badges

1 Comment

Sanjay Kumar N S Over a year ago

Semicolon is a delimiter which will not cause any error at the end;

Collectives™ on Stack Overflow

Sql syntax error in dropping tabels

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related