`useslots` int(11) NOT NULL default '48', `equipslots` int(11) NOT NULL default '48', `matchcardties` int(11) NOT NULL default '0', `matchcardlosses` int(11) NOT NULL default '0', `matchcardwins` int(11) NOT NULL default '0', `omoklosses` int(11) NOT NULL default '0',
`marriagequest` int(10) unsigned NOT NULL default '0', `cantalk` int(10) unsigned NOT NULL default '1', `partnerid` int(10) unsigned NOT NULL default '0', `married` int(10) unsigned NOT NULL default '0', `mounttiredness` int(9) NOT NULL default '0', `mountlevel` int(9) NOT NULL default '1', `messengerposition` int(10) unsigned NOT NULL default '4', `messengerid` int(10) unsigned NOT NULL default '0', `guildrank` int(10) unsigned NOT NULL default '5', `guildid` int(10) unsigned NOT NULL default '0', `jobRankMove` int(11) NOT NULL default '0', `jobRank` int(10) unsigned NOT NULL default '1', `rank` int(10) unsigned NOT NULL default '1', `createdate` timestamp NOT NULL default CURRENT_TIMESTAMP, `budd圜apacity` int(11) NOT NULL default '25', `spawnpoint` int(11) NOT NULL default '0', `skincolor` int(11) NOT NULL default '0', `accountid` int(11) NOT NULL default '0', 'characters', 'CREATE TABLE `characters` ( ) ENGINE=InnoDB AUTO_INCREMENT=753 DEFAULT CHARSET=latin1' `lastlogininmilliseconds` bigint(20) unsigned NOT NULL default '0', `tempban` timestamp NOT NULL default ' 00:00:00',
`lastpwemail` timestamp NOT NULL default ' 17:00:00', `lastknownip` varchar(30) NOT NULL default '', `forumaccid` int(11) NOT NULL default '0', `banned` tinyint(1) NOT NULL default '0', `createdat` timestamp NOT NULL default CURRENT_TIMESTAMP, `loggedin` tinyint(4) NOT NULL default '0', `password` varchar(128) NOT NULL default '', Here are the SHOW CREATE TABLE queries for the 3 tables: 'accounts', 'CREATE TABLE `accounts` ( Seems to still ignore the check for '1' in banned column of accounts table. However this deletes all rows in the inventoryitems table where itemid = '234000'. Table inventoryitems has columns itemid and characterid ( characterid links to characterid in table characters) Table characters has columns: characterid and accountid ( accountid links to id in table accounts). Table accounts has columns: id (primary key) and banned. You can join the table accounts to inventoryitems by a 3rd table called characters. The column banned in accounts has a value of 1 I would like to DELETE FROM inventoryitems WHERE itemid = 2340000 The column in question for inventoryitems is called itemid The column in question for accounts is called banned I am trying to execute a MySQL query to delete rows from 'table2' where column = 'value' IF column in 'table1' = 'value'
0 kommentar(er)
