code-diesel
/* PHP & MySQL Journal */
Archive for the ‘mysql’ Category
Multi column sequences in MySQL
In: mysql
18 Aug 2010multi-column auto-increment sequences in mysql
- No Comments
- Tags: sequences
Benchmarking Wordpress SQL using FirePHP
12 Feb 2010Benchmarking your Wordpress SQL
- (4) Comments
- Tags: wordpress
Adminer – a fast MySQL administration tool
18 Aug 2009mysql administration program, adminer
- (2) Comments
- Tags: mysql, tools
Copying tables in MySQL
In: mysql
17 Aug 2009easily copy tables in mysql
- (2) Comments
- Tags: mysql, tips
SchemaBank: Browser based SQL schema designer
24 Apr 2009Whether 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
25 Mar 2009The 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
28 Feb 2009The 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
18 Feb 2009HeidiSQL 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
4 Feb 2009Below 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" ] [...]
- (2) Comments
- Tags: mysql
