Question

CREATE TABLE Bill(
bill_id char(15) PRIMARY KEY,
bill_name VARCHAR(150) NOT NULL,
dateOfVoteCommittee date,
dateOfVote date,
isPassed tinyint(1) CHECK (isPassed IN (0,1)),
date_signed date,
isVeto tinyint(1) CHECK (isVeto IN (0,1)),
dateOfVote_override date,
proposed_person_id INT,
committee_id INT,
foreign key(proposed_person_id) REFERENCES Congressman(person_id),
foreign key(committee_id) REFERENCES Committee(committee_id)
);

INSERT INTO Bill (bill_id, bill_name, dateOfVote, isPassed, date_signed, isVeto, dateOfVote_override, proposed_person_id, commitee_id) VALUES(1,'SB2 Florida Statutes',DATE'2019-03-27',1,DATE'2019-03-27',0,23,);  

*I am getting this error - mysql

Mysql doesn't like the date entries in the insert statement. Schema above for reference.

Answer 1

INSERT INTO Bill (bill_id, bill_name, date of vote, isPassed, date_signed, isVeto, dateOfVote_override, proposed_person_id, commitee_id) VALUES(1,'SB2 Florida Statutes',DATE'2019-03-27',1,DATE'2019-03-27',0,23,);

the underlined words above are creating errors. why you have written DATE before the actual date. you simply need to write actual data like ..... '2019-03-27'.

also, you have written an applied comma after last value inserted which is 23. the comma doesn't come at the end.

the correct statement is written below.

INSERT INTO Bill (bill_id, bill_name, date of vote, isPassed, date_signed, isVeto, dateOfVote_override, proposed_person_id, commitee_id) VALUES(1, 'SB2 Florida Statutes', '2019-03-27', 1, '2019-03-27', 0, 23);