eth0 — 2012-10-07T23:00:45-04:00 — #1
Can't seem to be able to see what's wrong with this query. Could a kind soul kindly advise me?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL ,
`labpdfserial` VARCHAR NULL ,
`isDoctor` TINYINT(1) NULL ,
PRIMARY ' at line 48.
SQL Error: 1064
guelphdad — 2012-10-07T23:16:04-04:00 — #2
you have to declare a size for VARCHAR or CHAR datatypes.
eth0 — 2012-10-07T23:23:04-04:00 — #3
oh.. thanks for the tip. Was using mysql workbench to convert mssql to mysql.