SQL 2 nodarbiba

unsignet - bez negativam vertibam

ID - skaitlis
Lietotaja vards
Parole SHA1 hash 
e-pasts

CREATE TABLE `userlist` (
`ID` INT(10) UNSIGNED NOT NULL,
`username` VARCHAR(25) NOT NULL,
`pasw` CHAR(40) NOT NULL,
`email` VARCHAR(200) NOT NULL
)
COLLATE='latin1_swedish_ci'


prieksnoteikumi

maziem burtiem nosaukumi kolonnam jo īsak, jo labāk!
primary - un°ikala atslēga

key - atslega neunikalais indeks

unique - unikāla

fulltext - ka tiek meklēta informācija

spatial - meklēšanai

CREATE TABLE `userlist` ( `ID` INT(10) UNSIGNED NOT NULL, `username` VARCHAR(25) NOT NULL, `pasw` CHAR(40) NOT NULL, `email` VARCHAR(200) NOT NULL ) COLLATE='latin1_swedish_ci' 

ALTER TABLE `userlist` CHANGE COLUMN `ID` `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`ID`), ADD INDEX `username` (`username`), 	ADD INDEX `email` (`email`)