CREATE TABLE online (
idonline int(10) unsigned NOT NULL auto_increment,
ip varchar(16),
domain varchar(100),
FKiduyeler int(10) unsigned,
lasttime timestamp DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (idonline),
KEY online_index3587 (ip),
KEY online_index3588 (domain),
KEY online_index3592 (FKiduyeler),
KEY online_index3604 (lasttime)
);
yüklediğimde verdiği hata ise
SQL sorgusu:
CREATE TABLE online(
idonline İNT( 10 ) UNSİGNED NOT NULL AUTO_INCREMENT ,
ip VARCHAR( 16 ) ,
domain VARCHAR( 100 ) ,
FKiduyeler İNT( 10 ) UNSİGNED,
lasttime TİMESTAMP DEFAULT 'CURRENT_TIMESTAMP', -- burdaki tırnak işaretlerini kaldırdım ortaya çıkan sonuşu en alta yazdım
PRIMARY KEY ( idonline ) ,
KEY online_index3587( ip ) ,
KEY online_index3588( domain ) ,
KEY online_index3592( FKiduyeler ) ,
KEY online_index3604( lasttime )
);
MySQL çıktısı: Belgeler
#1067 - Invalid default value for 'lasttime'
---------------
Hata
SQL sorgusu:
CREATE TABLE visitor_chats ( visitor_id varchar(32) NOT NULL, browser_id varchar(32) NOT NULL, visit_id varchar(32) NOT NULL, chat_id int(11) unsigned NOT NULL, fullname varchar(255) NOT NULL, email varchar(255) NOT NULL, company varchar(255) NOT NULL, status tinyint(1) unsigned NOT NULL, typing tinyint(1) unsigned NOT NULL, waiting tinyint(1) unsigned NOT NULL, area_code varchar(255) NOT NULL, first_active int(10) unsigned NOT NULL, last_active int(10) unsigned NOT NULL, qpenalty int(10) unsigned NOT NULL, request_operator varchar(32) NOT NULL, request_group varchar(32) NOT NULL, question varchar(255) NOT NULL, customs text NOT NULL, allocated int(11) unsigned NOT NULL, internal_active tinyint(1) unsigned NOT NULL, internal_closed tinyint(1) unsigned NOT NULL, internal_declined tinyint(1) unsigned NOT NULL, external_active tinyint(1) unsigned NOT NULL, external_close tinyint(1) unsigned NOT NULL, exit int(11) [...]
MySQL çıktısı: Belgeler
#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 'exit int(11) unsigned NOT NULL,
PRIMARY KEY (visitor_id,browser_id,visit_id,c' at line 26