Advertisement
Guest User

Untitled

a guest
Jan 7th, 2012
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.87 KB | None | 0 0
  1. CREATE     TABLE
  2. IF     NOT     EXISTS   t1   (  c1   text  DEFAULT   (   'abc'  ),       c2 INT(3) INDEX ,    c3  blabla  CONSTRAINT bla  )   ;
  3.  
  4. !§$%&/(dfsdf CREATE    OR  REPLACE    TABLE "t2"  (c1 INT, PRIMARY KEY(c1)  )  ENGINE=MyISAM   blablub   ;
  5.  
  6. --create table "t3" (c1 int, primary key(c1)  )  ENGINE=MyISAM   blablub   ;
  7. #create TABLE "t4" (c1 INT, PRIMARY KEY(c1)  )  ENGINE=MyISAM   blablub   ;
  8. /*create table "t5" (c1 int, primary key(c1)  )  ENGINE=MyISAM   blablub   ;*/
  9.  
  10. INSERT IGNORE    INTO   t1   VALUES(  'v1',  123  ,  'ka'  )  ;
  11. INSERT  OR IGNORE    INTO   ´T1´   VALUES(  'v2',  234  ,  'ka'  )  ;
  12. INSERT    INTO   ´t1´ (  c2  )  VALUES(  111),(222),  (333  )  ;
  13. /*InSErt    into   ´t1´ ( c1,c2  )  values(  'a',111),('b',222),  ('c',333  )  ;
  14. */
  15. INSERT    INTO   ´t1´ ( "c1",   `C2`  )   VALUES    
  16. (  'a',444),('b',555),  ('c',666  )  ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement