MySQL – PHP Developer

View a single column definition in MySQL

By Paul August 26, 2021MariaDB, MySQL

Most MySQL developers will be familiar with the DESCRIBE statements, which shows the definition of all the columns in a table: > DESCRIBE contacts; +------------+---------------------+------+-----+---------+----------------+ | Field | Type |…

MySQL CREATE TABLE syntax from existing table

By Paul July 20, 2016MySQL

A short MySQL tip: SHOW CREATE TABLE [table_name] in MySQL will give you the SQL to create table_name is another database, including all indexes.

MySQL client display results vertically

By Paul July 19, 2016MySQL

If you are selecting a single row with a large number of columns in MySQL (a common use case for me at least), here's a handy tip: you can display…

MySQL named locks

By Paul October 9, 2010MySQL

Until recently, I've only run PHP sites on single host setups, which has kept things reasonably simple. However, I've moved one project to a load balanced solution, which randomly sends…

Special characters in passwords

By Paul January 6, 2010MySQL, Security

Recently I moved our website at work from one hosting provider to another. As we have several instances of the site (testing, demo, live etc.), each with their own separate…