[MYSQL] "You have an error in your SQL syntax"
#1

Hello, Im not sure if this is the correct section to post my issue. But im so confused and beginner with this MySQL

After i uploading the SQL file to my database it shows this error.
Code:
SQL query:


--
-- Dumping data for table `banned`
--

INSERT INTO `banned` (`User`, `Banner`, `IP`, `Date`, `Time`, `Reason`) VALUES


-- --------------------------------------------------------

--
-- Table structure for table `lshousedata`
--

CREATE TABLE IF NOT EXISTS `lshousedata` (
  `Houseid` int(11) NOT NULL,
  `OwnerName` varchar(128) NOT NULL default 'The Bank',
  `OwnerID` int(11) NOT NULL default '-1',
  `RenterName` varchar(128) NOT NULL default 'None',
  `RenterID` int(11) NOT NULL default '-1',
  `HouseName` varchar(50) NOT NULL default 'House',
  `Value` int(11) NOT NULL default '200000',
  `Rent` int(11) NOT NULL default '0',
  `ForSale` int(11) NOT NULL default '0',
  `Alarm` int(11) NOT NULL default '0',
  `Money` int(11) NOT NULL default '0',
  `Drugs` int(11) NOT NULL default '0',
  `Condoms` int(11) NOT NULL default '0',
  `Flowers` int(11) NOT NULL default '0',
  `Robberies` int(11) NOT NULL default '0',
  `Breakins` int(11) NOT NULL default '0',
  `OwnerVisits` int(11) NOT [...]
MySQL said: Documentation

#1064 - 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 'CREATE TABLE IF NOT EXISTS `lshousedata` (
  `Houseid` int(11) NOT NULL,
  `Owne' at line 11
Thanks in advance, I pormise i will give an ++REP
Reply
#2

My MYSQL version:

MySQL 5.6
Reply
#3

Did you get the error, while trying to create those tables, or when launching the server?
Reply
#4

Quote:
Originally Posted by CrazyChoco
View Post
Did you get the error, while trying to create those tables, or when launching the server?
Nope, I just uploaded the SQL file then it failed to upload due to that error. I did not launched the server yet because I dont have the SQL File yet uploaded to the database. And basically when launching my server i just receive an error in the end of line like this

Code:
[MYSQL] Could not retrieve field - SERVER SHITTING DOWN
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)