[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


Messages In This Thread
[MYSQL] "You have an error in your SQL syntax" - by S4MSUNG - 03.01.2015, 14:32
Re: [MYSQL] "You have an error in your SQL syntax" - by S4MSUNG - 03.01.2015, 14:34
Re: [MYSQL] "You have an error in your SQL syntax" - by CrazyChoco - 03.01.2015, 14:37
Re: [MYSQL] "You have an error in your SQL syntax" - by S4MSUNG - 03.01.2015, 14:40

Forum Jump:


Users browsing this thread: 1 Guest(s)