Re: SQL Query
| From: | Adam Williams | Date: | Sat, 07 Sep 2002 06:00:44 +0000 |
| Subject: | Re: SQL Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21628@lists.php.net to get a copy of this message | ||
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
Adam
On Sat, 7 Sep 2002, Bryan McLemore wrote:
> Hi Guys I have written this SQL Query :
>
> CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address VARCHAR(50),
> startDate DATE, lastWork DATE, progress INT(3))
>
> I'm sending it in through php and I can't get it to work correctly. Please help.
> Also, I would like to make id the primary key/index
>
> -Bryan
>