Hej

Ktos moze ma pojecie gdzie jest problem

[SQL] pobierz, plaintext 
SQL query: 
 
CREATE TABLE calendar( 
cal_id int NOT NULL AUTO_INCREMENT , 
owner_id int, 
titlechar( 80 ) , 
notechar( 120 ) , 
date date, 
starttimechar( 5 ) , 
stoptimechar( 5 ) , 
repeat enum( 'Y', 'N' ) DEFAULT 'N', 
interv int, 
repeattype enum( 'DAY', 'WEEK', 'MONTH', 'YEAR' ) , 
until date, 
lastupdate date, 
updateby int, 
calread enum( 'Y', 'N' ) DEFAULT 'N', 
calwrite enum( 'Y', 'N' ) DEFAULT 'N', 
calupdate enum( 'Y', 'N' ) DEFAULT 'N', 
caldelete enum( 'Y', 'N' ) DEFAULT 'N', 
PRIMARY KEY ( cal_id ) 
) 
 
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 'repeat enum('Y','N') DEFAULT 'N', 
interv int, 
repeattype enum('DAY','WEEK','M' at line 9
[SQL] pobierz, plaintext 

czy repeat nie jest słowem kluczowym? wtedy daj je tak `repeat`

Oczywiscie ze jest ale ja wolalbym aby ktos podal rozwiazanie:)

a nie podałem?

nie jestem na tyle obeznany z sql niestety potzrebuje syntax sorki

nie rozumiesz co tam wyzej kolega sf napisal?
slowo repeat umiesc w tych ciapkach `````````
dlatego ze repeat jest zarezerwowanym slowem

ciagle ten sam error

[SQL] pobierz, plaintext 
CREATE TABLE `calendar` (
  `cal_id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) DEFAULT NULL,
  `title` char(80) DEFAULT NULL,
  `note` char(120) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `starttime` char(5) DEFAULT NULL,
  `stoptime` char(5) DEFAULT NULL,
  `repeat` enum('Y','N') DEFAULT 'N',
  `interv` int(11) DEFAULT NULL,
  `repeattype` enum('DAY','WEEK','MONTH','YEAR') DEFAULT NULL,
  `until` date DEFAULT NULL,
  `lastupdate` date DEFAULT NULL,
  `updateby` int(11) DEFAULT NULL,
  `calread` enum('Y','N') DEFAULT 'N',
  `calwrite` enum('Y','N') DEFAULT 'N',
  `calupdate` enum('Y','N') DEFAULT 'N',
  `caldelete` enum('Y','N') DEFAULT 'N',
  PRIMARY KEY  (`cal_id`)
)
[SQL] pobierz, plaintext 

miales polaczone slowa kluczowe char z innymi slowami

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 'repeat enum( 'Y', 'N' ) DEFAULT 'N',interv int,repeattype enum( 'DAY', 'WEEK', '' at line 1