Tag Archives: database
Top 5 Free Database Systems

MySQL Community Edition MySQL Community Edition is the freely downloadable version of the world’s most popular open source database. It…

Add new column to database table programmatically

Let’s see how we can add a new column to an existing table in database using c#. SqlConnection Connection =…

Get Field Name and Type of Database Table

Today we will see how we can retrieve table’s columns’ names and types. USE mydatabase GO   SELECT column_name, data_type…

Connect to a MySQL database in Python

import MySQLdb as mysqlib import sys   dbserver = "localhost" dbuser = "username" dbpass = "********" db = "dbname" conn…

Calculate MySQL Database size

Today we will see how we can retrieve MySQL database size. All databases: SELECT table_schema "Database", SUM( data_length + index_length)…

How To Connect C++ To Mysql in Linux

There is a great library for C++ and Mysql called mysql++. Today we will see a simple example on how…

Backup SQL Server Database

To create a Full Database Backup using transact sql is simple. The following sql code does the trick: USE database_name;…

Backup MySQL Database

If you would like to take a mysql database backup from the terminal, all you have to do is to…

Previous Page