MySQL’s Status Command
Status allows you to see various stats on the MySQL daemon. To get to your MySQL shell, type the following command at your shell:
|
1 |
[icezip@saturn ~/]$ mysql -u icezip -p |
(where icezip is your user…
Category: Database
Counting Number Of Entries In A Database
Do you have your own database? How would you like to know how many entries you have in your database from a PHP page? Well its easy, I am going to show…
New to Mysql? Read the Series and Become an Expert
This is the beginning of a series where I will work through the basic Mysql commands that you will need to manage a database.These commands are covered in this part…
Using MysqlDump
MysqlDump can be used for many different reasons. For one, you can use mysqldump to backup the data in your MySql DataBase. Here is what mysqldump does. MYSQLDUMP – takes all the information…
[Database] How to Install and Use Mysql Mac
All the required files are available on the the www.mysql.com download page, how to install and configure the interface described in detail can be seen in the following link: Note…
Fix All Structured Data Errors
It’s time to fix some common errors in your blog. In this blog post we are going to discus common structured data errors. You can use Google webmaster tools to detect them. Google already…
Moving Analysis Service Database to a Different Drive
Recently we faced a situation where the server hosting our Analysis Services ran out of the space on the primary C drive. After looking at the files stored on C…
SQLCLR Procedure to export query / SP results into CSV
We as database developers, many times have to export data into csv files and send them across to the Business users. The data the needs to be exported can be…
Creating a Delimited list from a column of a table
Many times when we normalize our database, we end up storing multi-values attributes as separate rows in table. For eg. Consider we are storing Photos and a set of tags…
SQL Server CLR function to concatenate values in a column
In one of my earlier post Creating a Delimited list from a column of a table, we had seen how to generate CSV (demilited string) from column values in a table…