[MySQL] Query Help!

[JoSePh15_]

I want a mysql query that removes all the addons that the player have.. Thanks

 

[cbrm]

DELETE FROM `player_storage` WHERE `key` >= 10000000;
UPDATE `players` SET `lookaddons` = 0;

 

[JoSePh15_]

another question... i imported that while testing my website restarter..

CREATE TABLE IF NOT EXISTS `z_shut` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shutdown` int(11) NOT NULL DEFAULT '1',
  `long` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 
 
INSERT INTO `z_shut` (`id`, `shutdown`, `long`) VALUES
(1, 0, 1);

now i wanna uninstall it, so i do that?

DELETE TABLE `z_shut`;

Without changing the mysql database!

 

[cbrm]

to empty table:

TRUNCATE TABLE `z_shut`;

to delete table from db:

DROP TABLE `z_shut`;

 

[JoSePh15_]

books?
what books? the table name is z_shut

 

[cbrm]

then change it! its just an example

 

[JoSePh15_]

aha

Ty's