| 12345678910111213141516 |
- echo \
- "SELECT c1,c3 FROM pok where c3 <> 34 and c5 = 2.3;
- INSERT INTO pok VALUES ( 'abc', 32, 56.7 );
- INSERT INTO pok ( c1, c2,c3) VALUES ( 'abc', 32, 56.7 );
- INSERT INTO pok ( c1, c2,c3) VALUES ( 'abc', +32, +56.7 );
- INSERT INTO pok ( c1, c2,c3) VALUES ( 'abc', -32, -56.7 );
- upDAte pok SET c2 = '5', c3 = 1 WHERE c1 = '1' AND c5 = 6;
- delete FROM pok WHERE c1 = '1' and c2=3 AND c5 <= 4.35;
- CREATE TABLE pok ( c1 INT, c2 VARCHAR (5), c3 DOUBLE );
- DROP TABLE pok;
- ALTER TABLE pok ADD COLUMN id int;
- ALTER TABLE pok ADD popis varchar(10);
- UPDATE pok SET c2 = NULL, c1=c2, c3=(-c3+12)/c1 where c1 NOT NULL;
- update pok set c1=c2,c2=c1,c3=NULL where c1+2>1/cat+0.5 and not (c1=1 or c2=2);" \
- | ./sqlptest
|
