A co to znaczy?Jaki jest best player i kto ostatnio dołanczył
SELECT count(*) FROM `accounts`
SELECT count(*) FROM `players`
SELECT count(*) FROM `guilds`
SELECT name FROM `players` ORDER BY created DESC limit 1
SELECT name FROM `players` ORDER BY experience DESC limit 1
Lepiej użyć mniej zapytać, żeby nawet w minimalnym stopniu nie obciążać bazy danych.11 postów w tym wszystkie to prośby lol
Code:SELECT count(*) FROM `accounts` SELECT count(*) FROM `players` SELECT count(*) FROM `guilds` SELECT name FROM `players` ORDER BY created DESC limit 1 SELECT name FROM `players` ORDER BY experience DESC limit 1
SELECT `TABLE_ROWS` FROM `information_schema`.`tables` WHERE `table_schema` = 'nazwa_bazy' AND `table_name` IN ('accounts', 'players', 'guilds');