CodeDiesel : Resources, tutorials and articles for the Web Developer and Designer

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 [...]

Comments Off
Tags: mysql, PostgreSQL

Generating test data for MySQL

In: mysql

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 [...]

(3) Comments
Tags: data, testing

Selecting all except some columns in MySQL

In: mysql

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 [...]

(9) Comments
Tags: mysql

HeidiSQL – Lightweight MySQL IDE

In: mysql|tools

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.

(3) Comments
Tags: mysql

Getting MySQL table size with PHP

In: mysql

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 */ [...]