Advertisement
Isigar

SQL table create [PHP]

Feb 23rd, 2017
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.41 KB | None | 0 0
  1. INPUT:
  2.         $sql = new SQL();
  3.         $sql->createTable("test")
  4.             ->add("ID")->type($sql::TYPE_INT)->primary()
  5.             ->add("username")->type($sql::TYPE_STRING,250)->notNull()
  6.             ->add("role")->type($sql::TYPE_STRING,100)->def("guest");
  7.  
  8. OUTPUT:
  9. CREATE TABLE test
  10. (
  11.     ID int,
  12.     username varchar(250) NOT NULL,
  13.     role varchar(100) DEFAULT guest,
  14.     PRIMARY KEY (ID)
  15. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement