Re: mysql error
| From: | xianhua zhou | Date: | Tue, 10 May 2011 09:38:27 +0000 |
| Subject: | Re: mysql error | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-312740@lists.php.net to get a copy of this message | ||
Hi Grega,
Probably you wanna define a primary key, if so, then change from
"uniqueid" to "primary key".
2011/5/6 Curtis Maurand <curtis@maurand.com>:
>
>
>
> engine=
>
> --C
>
> Grega Leskovšek wrote:
>> Can smbd please look at this sentence - I got an error and do
> not
>> know how to fix it - I am still very unfamiliar with
> MYSQL:
>>
>> CREATE TABLE log ( idlog int auto_increment
> not null, imepriimek
>> varchar(50), clock timestamp, action
> varchar(30), onfile
>> varchar(100), filesize float(6,2),
> uniqueid(idlog) );
>>
>> 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
> '(idlog) )' at line 1
>>
>> -- When the sun rises I receive
> and when it sets I forgive ->
>>
> http://moj.skavt.net/gleskovs/
>> Always in Heart, Grega
> LeskovĹĄek
>>
>> --
>> PHP General
> Mailing List (http://www.php.net/)
>> To unsubscribe, visit:
> http://www.php.net/unsub.php
>>
>>
>