To repair a crashed table in CentOS + VestaCP server. Stop the MariaDB service via VestaCP goto the mysql folder/var/lib/mysql/DATABASENAME/TABLE_NAME try to
Read More »
Suitable for creating eNewsletter or bulk email application. We can use wildcard method in SQL. SELECT * FROM tableName WHERE emailField LIKE
Read More »
Fastest way to replace a table field string with SQL statement. UPDATE [THETABLENAME] SET [THEFIELDNAME] = REPLACE(THEFIELDNAME, 'string_to_replace', 'new_string')
Read More »
If you are using NOW() at your MySQL query, you may have problem when you hosted the file at different timezone server.
Read More »
Sometime we just want to find any duplicate data in the table, this simple statement will help to get the list of
Read More »
A simple statement to update one table field with another table field value. UPDATE theUpdateTable INNER JOIN theValueTable ON (theUpdateTable.matchValueField =theValueTable.matchValueField) SETtheUpdateTable.valueToUpdate
Read More »
Sometime we just need to compare left and right table to ensure the data are tally. There’s 2 SQL statement we can
Read More »