November 7th, 2000, 08:27 AM
Just wondering if anyone could help? I'm trying to install a MySQL database and getting nowhere fast.. It's basically an address-book type thing.. one primary key BigNum (unique, primary) and some text fields (I think binary [not at all sure about this] not null and so on. I get this error message.
MySQL said: You have an error in your SQL syntax near '(50) BINARY DEFAULT 'Company' not null , location TEXT (80) BINARY DEFAULT 'Loc' at line 1
Anyone know what settings I'm doing wrong? It's a single-table database (nothing too complex to start with!!) and it's driving me mad!
November 8th, 2000, 12:23 PM
Can you include the exact query you made?