Posts Tagged ‘mysql’

How to do string replace (str_replace) in MySQL

mysqlMySQL has a built in function to perform string replace (just like PHP str_replace) thru the query. I just perform a MySQL string replace at a website migration and everything work like a charm. This MySQL string replace function really save me a lot of time! Imagine if i’m going to edit the record one by one, and there is 100 record, i think i’m going to be crazy after the manual edition.

To perform string replace (str_replace) in MySQL, you can use the query below:-

Continue reading How to do string replace (str_replace) in MySQL »

Tags: , , , ,
Posted in MySQL Database, SQL | No Comments »

MySQL: How to add column to existing table

mysql how to add columnMany ways to add column to existing table in MySQL. If you r using GUI tools, add column to table in MySQL is easy. If you are using CLI, then here’s the command to add column in MySQL table.

To add column in existing table, you may refer to the 2 examples below:-

Continue reading MySQL: How to add column to existing table »

Tags: , , , ,
Posted in MySQL Database, Open Source | No Comments »

How to monitor sql query in mysql?

mysql logoMonitor what sql query is running in mysql is very import for performance analysis. By monitor sql query, you are be able to know what is running at the backend. if your framework logs all sql queries then you can monitor from there, if not, you might need to turn on mysql log to monitor all the sql query being executed.

To monitor sql query in MySQL, simply follow the steps below:-

Continue reading How to monitor sql query in mysql? »

Tags: , ,
Posted in MySQL Database, SQL | No Comments »

Page 1 2 3