Category : MySql

Home » Archive by category : MySql

The database model behind WordPress doesn’t follow several good database design rules and conventions. When we’re designing a database for a specific purpose, knowing all its desired functionalities in advance, we can follow all of those rules. But WordPress needs to cover anything that anyone could have in mind, so sacrificing foreign keys and using ..

Read more

JSON data can be stored in TEXT and VARCHAR columns, but having an data type specifically for JSON is fun. JSON Labs Release: Native JSON Data Type and Bin..

Read more

Enable MySQL Event Scheduler Start MySQL event scheduler by executing following query in PhpMyAdmin or MySQL command prompt.

Create a Event Here the following event will run everyday and clear/delete 10 days old data fromcart table based on time stamp

View Event Show all the running events. [crayon-5b4db9726f9b285190771..

Read more

There are several strategies for backup, snapshot, dump, dump binlog, it all depends on your need and the size of your database. I’ll explain a little about the tool provides by MySQL, which is the mysqldump , I indicate this tool for databases that have 15gb/20gb even more than that, the probability that you have ..

Read more

As with version 10.0.1, it is now possible to use multiple masters as source for single slave node as replication topology. This link can help you set up the replication from a single master. To add more masters just use the ‘CHANGE MASTER TO’ command and use different master addresses. Update: Follow this to setup ..

Read more

http://www.microshell.com/database/mysql/emulating-nextval-function-to-get-sequence..

Read more

Mar..

Read more

Apply Percona best practices to achieve better MySQL database performance and avoid the time, complexity, and risk of customizing a my.cnf configuration on your own. Simply copy and paste the results of the Percona Configuration Wizard for MySQL into your my.cnf file. Tens of thousands of MySQL users have already used this tool to improve ..

Read more

AN sample below to write an update query that should be executed based on a select query and conditions. [crayon-5b4db972702992..

Read more

http://www.infotuts.com/crud-example-php-jq..

Read more