Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE
- IF NOT EXISTS t1 ( c1 text DEFAULT ( 'abc' ), c2 INT(3) INDEX , c3 blabla CONSTRAINT bla ) ;
- !§$%&/(dfsdf CREATE OR REPLACE TABLE "t2" (c1 INT, PRIMARY KEY(c1) ) ENGINE=MyISAM blablub ;
- --create table "t3" (c1 int, primary key(c1) ) ENGINE=MyISAM blablub ;
- #create TABLE "t4" (c1 INT, PRIMARY KEY(c1) ) ENGINE=MyISAM blablub ;
- /*create table "t5" (c1 int, primary key(c1) ) ENGINE=MyISAM blablub ;*/
- INSERT IGNORE INTO t1 VALUES( 'v1', 123 , 'ka' ) ;
- INSERT OR IGNORE INTO ´T1´ VALUES( 'v2', 234 , 'ka' ) ;
- INSERT INTO ´t1´ ( c2 ) VALUES( 111),(222), (333 ) ;
- /*InSErt into ´t1´ ( c1,c2 ) values( 'a',111),('b',222), ('c',333 ) ;
- */
- INSERT INTO ´t1´ ( "c1", `C2` ) VALUES
- ( 'a',444),('b',555), ('c',666 ) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement