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…
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,…
Note: Published 2016-08-31. Summary Conclusion: The Nook Color hardware makes a nice tablet with a really sharp screen at a reasonable price. There seems to be a catch about the version of the Nook Color that you get. Apparently some will NOT boot from the SD card. Research this before tryin it. My Nook Color has…
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…
Open Document format Open source office doc. Much better for printing. cal = Calendar.Prints a calendar for [[month] year].cat = Catenate.Joins files end to end or send file to standard output. cd = Change Directory.”..” is one directory up. Without a path, sends you home.chgrp = Change Group.Changes the group associated with file-list. Group is the name or group…
Summary This page has a brief explanation of a possible way to increase the resolution of your unsupported / poorly supported video card under linux by using the generic vesa driver. A sign of this is only getting 800×600 or 640×480 pixels when your monitor can handle a greater resolution. Background Trying to install Linux…