Re: [PHP] mysql error

>> CREATE TABLE log (  idlog int auto_increment not null,  imepri=
imek
>> varchar(50),  clock timestamp,  action varchar(30),  onfi=
le
>> varchar(100), filesize float(6,2),
uniqueid(idlog) ); -- here is your mistake

the syntax for that should be 'unique key(idlog)' if you only wanted
to specify a unique key, but this is a mistake.

as 'idlog' is marked auto-increment so I assume this is supposed to be
the primary which is inherently unique. What you want is:

CREATE TABLE log (
idlog int auto_increment primary key,
imepriimek
varchar(50),  clock timestamp,  action varchar(30),  onfil=
e
varchar(100), filesize float(6,2));



On Thu, May 5, 2011 at 10:49 AM, Daniel Brown wrote:
> On Thu, May 5, 2011 at 10:29, Grega Leskovšek wr=
ote:
>> 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,  imepri=
imek
>> varchar(50),  clock timestamp,  action varchar(30),  onfi=
le
>> 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
>
>    This is by no means a PHP question, and should not be asked =
on the
> PHP General mailing list.  Please ask questions in the appropriate
> place; for this, the MySQL General list is the correct forum, and
> they've been CC'd.  In the future, if it relates to a PHP database
> issue, you may want to use the PHP Database mailing list, also CC'd.
> This not only means you'll get more on-target help faster, but also
> helps in archiving data in the proper location for future searchers.
>
> --
>
> Network Infrastructure Manager
> http://www.php.net/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmdykman=
@gmail.com
>
>



--=20
 - michael dykman
 - mdykman@gmail.com

 May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg