need simple help

need simple help

am 12.05.2011 21:30:26 von legrega

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) );

-- When the sun rises I receive and when it sets I forgive ->
http://moj.skavt.net/gleskovs/
Always in Heart, Grega Leskovšek

--
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

Re: need simple help

am 12.05.2011 21:35:19 von Peter Brawley

On 5/12/2011 2:30 PM, Grega Leskovšek wrote:
> 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) );
CREATE TABLE log (
idlog int auto_increment primary key,
imepriimek varchar(50),
clock timestamp,
action varchar(30),
onfile varchar(100),
filesize float(6,2)
);

PB

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