Add USER MYsql
CREATE USER 'toombila'@'%' IDENTIFIED BY 'password';
Tambah Privilage
GRANT ALL PRIVILEGES ON * . * TO 'toombila'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
update places set
image_file_name = NULL
where image_file_name = ""
SELECT *
FROM `places`
WHERE image_file_name IS NOT NULL
SELECT *
FROM `places`
WHERE code = "CU0112"
LIMIT 0 , 30
## search berdasarkan kata tertentu
SELECT *
FROM `places`
WHERE name LIKE '%Café%'
LIMIT 0 , 100
Recent comments
8 weeks 6 days ago
25 weeks 1 day ago
36 weeks 6 days ago
42 weeks 4 days ago
42 weeks 5 days ago
43 weeks 5 days ago
46 weeks 2 days ago
47 weeks 4 days ago
48 weeks 21 hours ago
50 weeks 18 hours ago