Archive for the ‘mysql’ Category

multi-column auto-increment sequences in mysql

Benchmarking your Wordpress SQL

generating test data for mysql

mysql administration program, adminer

Copying tables in MySQL

In: mysql

17 Aug 2009

easily copy tables in mysql

Whether desktop or web based, there has recently been a proliferation of SQL design tools on the net. SchemaBank may look like one more in the box. But a detailed look at the features will show you more on offer. SchemaBank is a visual data modelling tool which can help you create ERD diagrams within [...]

The most common type of web application a developer encounters are database related. But rarely is the case when you have the required data in your database during testing, making it a frequent source of frustration for programmers, who than have to manually populate the database. Having a dummy set of data is always a [...]

The MySQL SELECT is a ubiquitous statement. You can select rows using the ‘*’ operator or by listing the individual column names. But many times you may require using all the columns from a table except a couple of them. For example you may have a table containing twelve columns from which you require only [...]

HeidiSQL is an easy-to-use ide for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface. With a download size of less than 2Mb, it is quite lightweight and fast to load.

Below is a small script that lets you read the table sizes of a MySQL database.

< ?php
 
$link = mysql_connect(’host’, ‘username’, ‘password’);
 
$db_name = "your database name here";
$tables = array();
 
mysql_select_db($db_name, $link);
$result = mysql_query("SHOW TABLE STATUS");
 
while($row = mysql_fetch_array($result)) {
/* We return the size in Kilobytes */
$total_size = ($row[ "Data_length" ] [...]


RECENT COMMENTS

ON TWITTER