0_0_29093616_23218.cpp:86:35: error: empty character constant
name varchar(20) not null default '' COMMENT '',
^
0_0_29093616_23218.cpp:86:46: error: empty character constant
name varchar(20) not null default '' COMMENT '',
^
0_0_29093616_23218.cpp:226:35: error: empty character constant
name varchar(20) not null default '' COMMENT '',
^
0_0_29093616_23218.cpp:226:46: error: empty character constant
name varchar(20) not null default '' COMMENT '',
^
0_0_29093616_23218.cpp:237:39: error: empty character constant
username varchar(20) not null default '' comment '',
^
0_0_29093616_23218.cpp:237:50: error: empty character constant
username varchar(20) not null default '' comment '',
^
0_0_29093616_23218.cpp:238:42: error: empty character constant
money int(10) not null default 0 comment '',
^
0_0_29093616_23218.cpp:239:63: error: empty character constant
datetime timestamp not null default current_timestamp comment '',
^
0_0_29093616_23218.cpp:276:35: error: empty character constant
name varchar(20) not null default '' comment '',
^
0_0_29093616_23218.cpp:276:46: error: empty character constant
name varchar(20) not null default '' comment '',
^
0_0_29093616_23218.cpp:277:40: error: empty character constant
content varchar(1000) not null default '' comment '',
^
0_0_29093616_23218.cpp:277:51: error: empty character constant
content varchar(1000) not null default '' comment '',
^
0_0_29093616_23218.cpp:320:35: error: empty character constant
name varchar(20) not null default '',
^
0_0_29093616_23218.cpp:328:35: error: empty character constant
name varchar(20) not null default '',
^
0_0_29093616_23218.cpp:483:35: error: empty character constant
name varchar(20) not null default '' comment '',
^
0_0_29093616_23218.cpp:483:46: error: empty character constant
name varchar(20) not null default '' comment '',
^
0_0_29093616_23218.cpp:484:45: error: empty character constant
score varchar(4) not null default 0 comment '',
^
0_0_29093616_23218.cpp:485:38: error: empty character constant
message varchar(50) not null default '',
^
0_0_29093616_23218.cpp:493:11: error: empty character constant
values(1,'',89,'helloworld'),(1,'',90,'hello'),(2,'',92,'helloworld'),
^
0_0_29093616_23218.cpp:493:34: error: empty character constant
values(1,'',89,'helloworld'),(1,'',90,'hello'),(2,'',92,'helloworld'),
^
0_0_29093616_23218.cpp:493:52: error: empty character constant
values(1,'',89,'helloworld'),(1,'',90,'hello'),(2,'',92,'helloworld'),
^
0_0_29093616_23218.cpp:494:6: error: empty character constant
(3,'',93,'world');
^
0_0_29093616_23218.cpp:6:1: error: 'use' does not name a type
use test;
^
0_0_29093616_23218.cpp:7:1: error: 'DROP' does not name a type
DROP table if exists equipment;
^
0_0_29093616_23218.cpp:8:1: error: 'create' does not name a type
create table equipment(
^
0_0_29093616_23218.cpp:15:1: error: 'INSERT' does not name a type
INSERT INTO equipment values (50431,'21', DATE '2013-01-23');
^
0_0_29093616_23218.cpp:16:1: error: 'INSERT' does not name a type
INSERT INTO equipment values (50532,'pad', DATE '2013-01-26');
^
0_0_29093616_23218.cpp:20:1: error: 'ALTER' does not name a type
ALTER Table equipment ADD COLUMN office VARCHAR(20);
^
0_0_29093616_23218.cpp:21:1: error: 'UPDATE' does not name a type
UPDATE equipment SET office='Headquarters';
^
0_0_29093616_23218.cpp:24:1: error: 'INSERT' does not name a type
INSERT INTO equipment(assetTag,description,acquired) values (50432,'IBM-PC',DATE '2013-01-01');
^
0_0_29093616_23218.cpp:27:1: error: 'DROP' does not name a type
DROP TABLE if EXISTS equipmentMultiSite;
^
0_0_29093616_23218.cpp:28:1: error: 'CREATE' does not name a type
CREATE TABLE equipmentMultiSite(
^
0_0_29093616_23218.cpp:35:1: error: 'INSERT' does not name a type
INSERT INTO equipmentMultiSite
^
0_0_29093616_23218.cpp:40:1: error: 'DROP' does not name a type
DROP TABLE equipment;
^
0_0_29093616_23218.cpp:41:1: error: 'CREATE' does not name a type
CREATE VIEW equipment AS
^
0_0_29093616_23218.cpp:47:1: error: 'select' does not name a type
select sum(amount) from payment where customer_id=1; /**/
^
0_0_29093616_23218.cpp:48:1: error: 'select' does not name a type
select count(*) from payment where customer_id=1; /**/
^
0_0_29093616_23218.cpp:50:1: error: 'select' does not name a type
select sum(amount) from payment where customer_id=1 and extract(year from payment_date)=2005 and extract(month from payment_date) between 05 and 06;
^
0_0_29093616_23218.cpp:51:1: error: 'select' does not name a type
select sum(amount) from payment where customer_id=1 and payment_date >= '2005-05-01 00:00:00' and payment_date < '2005-07-01 00:00:00';
^
0_0_29093616_23218.cpp:53:1: error: 'select' does not name a type
select sum(amount) from payment where customer_id=1 and payment_date > UNIX_TIMESTAMP('2005-05-01 00:00:00') and payment_date < UNIX_TIMESTAMP('2005-07-01 00:00:00');
^
0_0_29093616_23218.cpp:56:1: error: 'select' does not name a type
select sum(amount) from payment where customer_id=1 and extract(year from payment_date)=2005;
^
0_0_29093616_23218.cpp:57:1: error: 'select' does not name a type
select sum(amount) from payment where customer_id=1 and extract(year from payment_date)='2005'; /**/
^
0_0_29093616_23218.cpp:59:1: error: 'select' does not name a type
select sum(amount) from payment where extract(year from payment_date)=2005;
^
0_0_29093616_23218.cpp:62:1: error: 'select' does not name a type
select sum(amount) from payment_copy where extract(year from payment_date)=2005;
^
0_0_29093616_23218.cpp:64:1: error: 'explain' does not name a type
explain select sum(amount) from payment where extract(year from payment_date)=2005;
^
0_0_29093616_23218.cpp:67:1: error: 'create' does not name a type
create index cust_id on payment_copy(customer_id);
^
0_0_29093616_23218.cpp:69:1: error: 'select' does not name a type
select sum(amount) from payment_copy where customer_id=1 and extract(year from payment_date)=2005;
^
0_0_29093616_23218.cpp:71:1: error: 'drop' does not name a type
drop index cust_id on payment_copy;
^
0_0_29093616_23218.cpp:73:1: error: 'create' does not name a type
create index pay_date on payment(payment_date);
^
0_0_29093616_23218.cpp:74:1: error: 'drop' does not name a type
drop index pay_date on payment;
^
0_0_29093616_23218.cpp:80:1: error: 'select' does not name a type
select title from film_list;
^
0_0_29093616_23218.cpp:84:1: error: 'create' does not name a type
create temporary table if not exists tmp_user(
^
0_0_29093616_23218.cpp:93:1: error: 'desc' does not name a type
desc tmp_user;
^
0_0_29093616_23218.cpp:103:1: error: 'create' does not name a type
create view pay_view as
^
0_0_29093616_23218.cpp:106:1: error: 'create' does not name a type
create view pay_view as
^
0_0_29093616_23218.cpp:110:1: error: 'select' does not name a type
select * from pay_view;
^
0_0_29093616_23218.cpp:112:1: error: 'select' does not name a type
select * from pay_view limit 10;
^
0_0_29093616_23218.cpp:114:1: error: 'select' does not name a type
select * from pay_view limit 11,20;
^
0_0_29093616_23218.cpp:117:1: error: 'select' does not name a type
select * from pay_view order by rand() limit 5;
^
0_0_29093616_23218.cpp:119:1: error: 'drop' does not name a type
drop view pay_view;
^
0_0_29093616_23218.cpp:129:1: error: 'begin' does not name a type
begin
^
0_0_29093616_23218.cpp:131:1: error: 'create' does not name a type
create view pay_view as
^
0_0_29093616_23218.cpp:134:1: error: 'select' does not name a type
select * from pay_view limit 10;
^
0_0_29093616_23218.cpp:135:1: error: 'end' does not name a type
end
^
0_0_29093616_23218.cpp:141:1: error: 'set' does not name a type
set global event_scheduler=1;
^
0_0_29093616_23218.cpp:142:1: error: 'create' does not name a type
create table testduty(
^
0_0_29093616_23218.cpp:146:1: error: 'create' does not name a type
create event if not exists test_event on schedule every 10 second do insert into testduty(time) values(now());
^
0_0_29093616_23218.cpp:150:1: error: 'drop' does not name a type
drop event test_event;
^
0_0_29093616_23218.cpp:153:1: error: 'optimize' does not name a type
optimize table payment;
^
0_0_29093616_23218.cpp:157:1: error: 'create' does not name a type
create table if not exists test_has_index(
^
0_0_29093616_23218.cpp:164:1: error: 'create' does not name a type
create table if not exists test_no_index(
^
0_0_29093616_23218.cpp:171:1: error: 'delimiter' does not name a type
delimiter |
^
0_0_29093616_23218.cpp:17
|
