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 »
