Category Archives: MySQL

GRANT’ing Privileges and Permissions To Users On A Database In MySQL

If you would like to add a user to MySQL and give them permissions to view on or multiple databases, then continue reading. It is a fairly simple process and can be very powerful in keeping your database secure as well as giving people the access to the database they need. In order to run [...]

MySQL Copy Table Data To Another Table – Migrating MySQL Data

So you are looking at transferring the data of on MySQL Table into another MySQL Table. This can be surprisingly easier if your tables have the same structure. You can use the query below which will gather the data from one MysQL table and then insert the data into a second table of your choice. [...]

MySQL Change Root Password

When you first install mysql, there won’t be a mysql password set for you. In order to set a mysql root password, you can use the mysqladmin command. Create MySQL Root Password Firstly change to the folder where your mysql is installed and enter the following command, where mypassword is the new password to use [...]

What are unix timestamps and why they are useful

Unix timestamps are a way or storing a specific date and time. Unix timestamps are a 10 digit number that represents the number of seconds that have passed since midnight Universal Co-ordinated Time (UTC) of January 1st, 1970. What makes timestamps ever so useful is that since timestamps are recorded as of UTC (or GMT) [...]

MySQL DELAYED INSERT – A MySQL Syntax Tip

When performing MySQL queries on your websites, there can often be a delay in a page loading while a MySQL Query is busy executing and returning the result. Generally the delay is minimal however on large complex queries with lots of join across multiple tables and millions of rows of data, there will be a [...]

MySQL INSERT IGNORE – A MySQL Syntax Tip

In MySQL, when you perform a mysql insert statements, it is almost inevitable that you will come across errors during the insert every so often. Once an issue is encountered with a mysql insert, the rest of the mysql inserts will not be imported since the MySQL query won’t continue. This can be annoying since [...]