]I have also tried to run this query:
Code:
CREATE TABLE mpc.loginlog (
loginid int(10) unsigned NOT NULL auto_increment,
ip varchar(20) NOT NULL default '',
username varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
atime int(10) unsigned NOT NULL default '0',
KEY id (loginid)
);
but got next error:
Code:
Error
SQL-query :
CREATE TABLE mpc.loginlog (
loginid int(10) unsigned NOT NULL auto_increment,
ip varchar(20) NOT NULL default '',
username varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
atime int(10) unsigned NOT NULL default '0',
KEY id (loginid)
)
MySQL said:
Table 'loginlog' already exists
This sounds weird... First it says it doesn't exist, then it exist... hmmm. Please help