Unique
| From: | D u r r a n i | Date: | Mon, 05 Jun 2000 19:44:10 +0000 |
| Subject: | Unique | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-1120@lists.php.net to get a copy of this message | ||
Hi PHP's,
I want to create a table as below in MySQL
Create table Station
(
id varchar(30) Primary Key,
Station varchar(30) unique,
Details varchar(100)
);
But this shows the following error
ERROR 1064: You have an error in your SQL syntax near 'unique,
Details varchar(100)
)' at line 4
May I know how to create unique fields in MySQL.
Thanx for ur help
Durrani