Example of MySQL queries in the SQL programming languages
SELECT *, COUNT(*) as count FROM `users` GROUP BY `users`.`addr` HAVING COUNT(*) > 500
SELECT * `links` FROM `links`, `users` WHERE`links`.`uID`=`users`.`uId` GROUP BY `users`.`addr` HAVING COUNT(*) > 500
SELECT *, COUNT(*) FROM `users` GROUP BY `users`.`addr` HAVING COUNT(*) > 500
SELECT DISTINCT(`field_name`) FROM tableName
DELETE `links` FROM `links`, `users` WHERE `users`.`lastAccess` < “2010-12-31” AND `links`.`uId`=`users`.`uId`
DELETE `users` FROM `users` WHERE `users`.`lastAccess` < “2010-12-31”
DELETE `links` FROM `links`, `users`, `ipbanned` WHERE `links`.`uId`=`users`.`uId` AND `ipbanned`.`ip`=`users`.`addr`
DELETE `link` FROM `link`, `user` WHERE `link`.`userId`=`user`.`id` AND `user`.`password`='XXX'
DELETE `user` FROM `user` WHERE `user`.`password`='XXX'
DELETE `users` FROM `users`, `ipbanned` WHERE `ipbanned`.`ip`=`users`.`addr`
DELETE `links` FROM `links` WHERE `links`.`uId` = 0
INSERT INTO `ipbanned` (`ip`) SELECT `users`.`addr` FROM `links`, `users` WHERE`links`.`uId`=`users`.`uId` GROUP BY `users`.`addr` HAVING COUNT(*) > 500
INSERT INTO `ipbanned` (`ip`) SELECT `users`.`addr` FROM `users` GROUP BY `users`.`addr` HAVING COUNT(*) > 40