Something is wrong in your syntax obok ... latin1 Opcje

[Sharky]

Witam, gdy chce dodac zapytanie do bazy danych, pojawia mi sie nastepujacy napis:
#1064 - Something is wrong in your syntax obok 'DEFAULT CHARSET=latin1' w linii 18

w 18 linii mam:

[SQL] pobierz, plaintext 
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
[SQL] pobierz, plaintext 

co jest nie tak?

[Sharky]

Mam część kodu tak:

[SQL] pobierz, plaintext 
--
-- Table structure for table `account`
--
 
CREATE TABLE `account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `amount` decimal(10,2) NOT NULL,
  `payment_opt` enum('P','A') NOT NULL DEFAULT 'P',
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `deleted` enum('Y','N','P') NOT NULL DEFAULT 'N',
  `entrydate` varchar(20) NOT NULL DEFAULT '',
  `paystatus` enum('TRUE','FALSE','Pending') NOT NULL DEFAULT 'Pending',
  `order_id` int(11) NOT NULL DEFAULT '0',
  `transfer_status` enum('TRUE','FALSE') NOT NULL DEFAULT 'FALSE',
  `approved` enum('Y','N') NOT NULL DEFAULT 'N',
  `bid_cost` int(11) NOT NULL DEFAULT '0',
  `shipped` enum('Y','N') NOT NULL DEFAULT 'N',
  `item_id` int(11) NOT NULL,
  `paytime` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
 
 
--
-- Dumping data for table `account`
--
 
INSERT INTO `account` VALUES (1,104,'120.00','P','Y','N','2009-03-02 05:52:12','Pending',1235994732,'FALSE','N',4,'N',0,0),(2,104,'120.00','P','Y','N','2009-03-02 05:53:47','Pending',1235994827,'FALSE','N',4,'N',0,0),(3,104,'120.00','P','Y','N','2009-03-02 05:53:58','Pending',1235994838,'FALSE','N',4,'N',0,0),(4,104,'120.00','A','Y','N','2009-03-02 05:54:05','Pending',1235994845,'FALSE','N',4,'N',0,0),(5,107,'240.00','P','Y','N','2009-03-02 16:37:43','TRUE',1236033463,'TRUE','N',10,'N',0,0),(6,107,'240.00','P','Y','N','2009-03-02 16:38:03','TRUE',1236033483,'TRUE','N',10,'N',0,0),(7,107,'240.00','P','Y','N','2009-03-02 16:38:13','TRUE',1236033493,'TRUE','N',10,'N',0,0);
 
[SQL] pobierz, plaintext 

Ten post edytował Sharky 12.11.2009, 19:51:16