Updated 2017-02. Ubuntu 16.04 LTS. Apache 2.4.18, PHP 7.0.13, MySQL 5.7.17 Background These are my notes I use to get the MySQL server software setup on my development computer. I want to be able to work on the databases from the local computer as well as from other computers on a trusted LAN. MySQL Server…
Summary As of MySQL 5.0, renaming a table is trivial with the “rename table” function. Renaming a column was a little cryptic, even looking at the documentation. Here are a couple of concrete examples. To rename a table from “lu_wind_direction” to “lu_direction”: To rename a column called “wind_speed” to “speed” in the table named “spacetime”: So, when renaming a…
Summary If you have a database and you don’t need a full US state and zip database, it might be helpful to have a look-up table of state names and abbreviations. I searched for a little while and didn’t find anything simple right away, so here is a little SQL script to make a state…
Summary Everybody needs a contacts table sooner or later. There is nothing that special about this one, but it is a place to start. Mostly likely, you will need to add and/or subtract field names. The straight SQL files are linked below, including the three look-up tables referenced in the contacts table. There is also…
Summary Here is a “quick and dirty” way to get a drop-down box in an HTML page to show the latest values from a MySQL database. Notice that there is a significant lack of error-handling. It sure did help clean up my HTML form, though. Assumptions: You already have a mysql connection object open and a MySQL database…
The MySQL data-types table in Open Document format (much better for printing). Type {storage} Name Range Attributes Default Numeric{1 byte} TINYINT[(M)] -128 TO 127[0 to 255 if UNSIGNED] AUTO_INCREMENTUNSIGNED, ZEROFILL,SERIAL DEFAULT VALUE NULL[0 if NOT NULL] Numeric{2 bytes} SMALLINT[(M)] -32,768 to 32,767[0 to 65,535] AUTO_INCREMENT,UNSIGNED, ZEROFILL,SERIAL DEFAULT VALUE NULL[0 if NOT NULL] Numeric{3 bytes} MEDIUMINT[(M)] -8,388,608 to 8,388,607[0 to 16,777,215] AUTO_INCREMENT,UNSIGNED,…
Summary Here is a “quick and dirty” way to get a connection to a MySQL server and a database selected. There are newer and better ways of doing this. If you use a shared hosting provider, however, they are not always so quick to update the servers to the latest software. This method should work…