Topic: nevykdo SQL uzklausos
sveiki,
pas mane kompe idiegta WAMP5 serveris: apache + mysql + php. isijungsiu mysql console ir pradedu SQL uzklausas:
SHOW DATABASES; // suzinau databases
CREATE DATABASE test; // susikuriu DB
USE test; // paleidziu naudojimui
SHOW TABLES; // pasitikrinu ar nera jokiu lenteliu
ir nejna sukurti lenteles.. rashau:
CREATE TABLE nariai (
ID int(3) auto_increment, unsigned, not_null
username varchar(30) not_null
e-mail varchar(30) not null
PRIMARY KEY (ID, username);
ir ismeta tokia klaida: ERROR 1064 (42000): 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 'unsig
ned not_null
username varchar(30) not_null
e-mail varchar(30) not_null
prim' at line 2
pagelbekit, dekoju.