Can anyone help me?
I've just installed php, mysql and phpmyadmin on a macintosh running OS X (10.2).
PHP 4.2.3
MySQL 3.23.51-entropy.ch
phpMyAdmin 2.3.0
I keep getting the following error message when trying to create a new table using phpMyAdmin:
SQL-query:
CREATE TABLE orders (
rid HAR( 10 ) NULL ,
er HAR( 20 ) ,
PRIMARY KEY ( rid )
)
MySQL said:
You have an error in your SQL syntax near 'HAR(10) NULL, er HAR(20), PRIMARY KEY (rid))' at line 1
What I need is the following:
CREATE TABLE orders
( orderid VARCHAR(10) NOT NULL PRIMARY KEY,
type VARCHAR(8),
driver VARCHAR(20)
);
If I post this as an SQL Query, it works fine, but using the create new table function, it fails every time. It looks like my column names are being stripped of the first 4 characters along with the data type (VARCHAR). Obviously, this is generating the error, but I have no idea why this is happening.
I'm a newbie to phpMyAdmin.
Really, really hope someone can help me.
A million thanks in advance!
Wavey🙂
