Re: mysql error 1064

[Rick James]

> create table log_book (fdate date, actype varchar2(16), acid varchar(16), nlandings number, nhours number);

NUMBER -> INT, FLOAT, DECIMAL(11,2), etc

> insert into log_book values (TO_DATE('08/12/1973','MM/dd/YYYY'),'C150','N5787G',1,1.8);

TO_DATE -> STR_TO_DATE, with different arguments.

I suspect the rest of your SQL will have errors. Keep the online manual open: dev.mysql.com