Stored procedure to add-remove prefix by rename table mysql
Kedar
Here is one more procedure – (this time) for mass renaming of table. Adding and Removing table-name prefixes š A friend of mine was renaming 100+ tables by using replace…
Browsing Category
MySQL-Scripts
21 posts
MySQL related blog posts with scripts
Stored procedure to Find database objects
This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables.…
MySQL Stored procedure ā Split Delimited string into Rows
This procedure will split a ā;ā separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And…
MySQL Stored procedure ā Execute query if table or Column exists
Well procedures mainly carried out working with information schema and it’s usage in stored procedure.Ā Procedures are fairly simple and easy to understand. 1. Edit_table ā following procedure executes queries to…
MySQL master master replication monitor with php code
For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it š Well this is fairly simple php code for…
Calculate Mysql Memory Usage ā Quick Stored Procedure
In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory…
Monitor multiple mysql replication using php: Updated
Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication…
Replication slave lag monitoring using heartbeat and windows batch scripts
“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter…
Search / find through all databases, tables, columns in MySQL
What will you do if one day some one ask you to find single string in allĀ databases, all tablesĀ and in allĀ columns, In MySQL Database? I just read such question and…
Upload Image to MySQL using PHP
Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite…
Recent Comments