SQL syntax error

[johnnylu305]

create table tableA(id int)11111
select id from tableA 11111
Neither of them should be accepted.

[kyechou]

I wonder whether these queries should be accepted:

• select id from tableA;
• select id from tableA; select id from tableB;

I mean should it be one query per line, or should semicolons be used to denote the end of a query?

[johnnylu305]

I think vanillaDB not support multiple query in one line with semicolons now.

[kyechou]

That's right, but I mean should it support?

[johnnylu305]

I am not sure. Try to contact vanilladb@datalab.cs.nthu.edu.tw. Thx.

[SLMT]

@kyechou
Good question !

In our current design, we do not support multiple queries in a line.
Since we focus on making code easy to read, we only implement the functions that are really necessary for the system.