Help for this page

Select Code to Download


  1. or download this
    select * from foo where(bar REGEX "^[aeiou]+$") ;
select * from foo where(bar REGEX "^[^aeiou]+$") ;
  2. or download this
      VARCHAR(100)  = ?
  VARCHAR(150)  = ?
  TEXT          = ?
...
  FLOAT(10)     = ?
  FLOAT(10,4) UNSIGNED = ?
  BOOLEAN       = ?
  3. or download this
    CREATE TABLE <table> (<field> <type> [UNIQUE] [NOT NULL], ...
    CONSTRAINT <constraint_name> PRIMARY KEY (<field name>));