SQL 15 dec

$rezultats = mysql_query("SELECT * FROM `users` LIMIT 2;" , $link);

$rezultats = mysql_query("SELECT * FROM `users` LIMIT 3,1;" , $link); 3 no sākumā

SELECT `username` AS `username12` FROM `users` ; 

CREATE DATABASE `testb`; DROP DATABASE `testb`;

CREATE TABLE `testtable` ( `id` INT(42), `lulz` TEXT, `what` VARCHAR(10) )

_______________________________

CREATE TABLE `testtable` ( `id` INT(42), `user` TEXT, `pass` VARCHAR(10), UNIQUE(`id`) )

_______________________________

CREATE TABLE IF NOT EXISTS `testtable` ( `id` INT(42), `user` TEXT, `pass` VARCHAR(10), UNIQUE(`id`) )

_______________________________

DROP TABLE `testtable`; CREATE TABLE `testtable` ( `id` INT(42), `user` TEXT, `pass` VARCHAR(10), UNIQUE(`id`) ); DESCRIBE `testtable`; 
____________________________________________________
DROP TABLE `testtable`;  CREATE TABLE `testtable` ( `id` INT(42), `user` TEXT, `pass` VARCHAR(10), PRIMARY KEY(`id`) );  DESCRIBE `testtable`; 
_____________________________________________________