#42 Whilst creating a database

[Stephen Morison]

This happens whilst creating the contacts table please advise a fix thanks heaps.

ERROR 1064: You have an error in your SQL syntax near 'mysqladmin
CREATE TABLE contacts (
id int(11) NOT NULL,
owner int(11) NOT ' at line 1
mysql> ňAborted

[David van der Bokke]

try:
mysql databasename < install-db-mysql

[Steve Dickson]

I have even tried creating the table manually in mysql with the following results;

mysql> alter table calendar add datetime int(11);
ERROR 1064: parse error near 'datetime int(11)' at line 1

PHP Version 4.0.1pl2
MySQL Version 3.23.10-alpha
Apache Version 1.3.12
On Windows 98SE

I was successful when I changed the name to datetime1, so it might be an idea changing the variable name away from a data type name.

Regards