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) ); -- 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), onfile
varchar(100), filesize float(6,2));
On Thu, May 5, 2011 at 10:49 AM, Daniel Brown danbr...@php.net wrote:
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com 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
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.
--
/Daniel P. Brown
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=mdyk...@gmail.com
--
- michael dykman
- mdyk...@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=arch...@jab.org