INFORMATIONS THAT I NEED: (Please, reply with this part)

Q1) How I make this 2 REGEX querys, like in MySQL:
select * from foo where(bar REGEX "^[aeiou]+$") ;
select * from foo where(bar REGEX "^[^aeiou]+$") ;
A:

Q2) How I LOCK and UNLOCK a table? When I unlock will 
unlock all the tables (like in MySQL) or just one?
A:

Q3) What types are suported? Based in MySQL, what is the 
similar:
  VARCHAR(100)  = ?
  VARCHAR(150)  = ?
  TEXT          = ?
  MEDIUMTEXT    = ?
  TEXT          = ?
  SMALLINT      = ?
  FLOAT         = ?
  DOUBLE        = ?
  FLOAT(10)     = ?
  FLOAT(10,4) UNSIGNED = ?
  BOOLEAN       = ?

** Please, include the maximal size of each (varchar,integer,float,double,etc...)

Q4) How I make an AUTO_INCREMENT column? For example, and
column called ID where when a row is inserted in the table, 
this col will be improved automatically with the next ID. 
And need to be an PRIMARY KEY.
A:

Q5) How to set a columns as PRIMARY KEY?
A:

Q6) Is the LIKE resource enable? It works like that?:
select * from foo where(bar LIKE "%text_in_the_midle%") ;
A:

Q7) How to get the list of tables?
A:

Q8) How to get columns of a table and the types of them?
A:

Q9) How to get the maximal value of a integer column?:
select max(ID) as ID from foo ;
A: