I need some help. I've never used MySQL before and am now learning it.
I'm trying to create a table within an existing database:
here is the error:
mysql> use Testing;
Database changed
mysql> select database();
+-----------------+
| database() |
+-----------------+
|Testing|
+-----------------+
1 row in set (0.00 sec)
mysql> < create_info.sql
-> \g
ERROR 1064 (42000): 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 '< create_info.sql' at line 1
mysql> mysql Testing < create_info.sql;
ERROR 1064 (42000): 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 'mysql Testing < create_info.sql' at line 1
mysql> mysql bbmc_employment < c:\create_info.sql;
ERROR 1064 (42000): 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 'reate_info.sql' at line 1
Here is the SQL script file:
Create Table Info
{
EmailAddress VARCHAR(45) NOT NULL,
PRIMARY KEY (EmailAddress),
Password VARCHAR(15) NOT NULL,
FName VARCHAR(15) NOT NULL,
LName VARCHAR(20) NOT NULL,
Address1 VARCHAR(35) NOT NULL,
Address2 VARCHAR(20) NULL,
City VARCHAR(20) NOT NULL,
State VARCHAR(2) NOT NULL,
ZipCode VARCHAR(10) NOT NULL,
Phone1 VARCHAR(12) NOT NULL,
Phone2 VARCHAR(12) NULL
};
Any ideas...????