Z-Car

Ramblings about everything from Cars to Computers

Z-Car
  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

MySQL – Select rows from a table when a field starts with a number

By Prodromus December 22, 2010 MySQL, Query Optimization 1 Comment
MySQL – Select rows from a table when a field starts with a number

A common request is how to select records from a table when a specific field starts with a number. This request often is used when searching free-form text fields where…

Read more

Exiting a MySQL Stored Procedure in the middle of the code

By Prodromus December 17, 2010 MySQL No Comments
Exiting a MySQL Stored Procedure in the middle of the code

While exiting a MySQL function is fairly straight-forward, simply use the RETURN keyword, exiting a Stored Procedure is not quite as obvious.  There is no EXIT keyword, however you can…

Read more

MySQL – Best way to remove all data from a table

By Prodromus November 22, 2010 MySQL, Scripting No Comments
MySQL – Best way to remove all data from a table

There are multiple ways in which to remove all data from a MySQL Table. The first is to use the DROP TABLE command, which will remove the entire table with…

Read more

MySQL – Help, I lost the Root password! Error number 1045

By Prodromus September 7, 2010 Errors, MySQL No Comments
MySQL – Help, I lost the Root password!  Error number 1045

Have you ever seen the dreaded MySQL Error number 1045 Access denied for user ‘root’@’localhost’ (using password: YES)? Don’t worry, this is an easy to recover from situation. Just follow…

Read more

MySQL – Innodb Slow Shutdown – Dirty Buffer Pages

By Prodromus September 3, 2010 Innodb, MySQL, Optimization No Comments
MySQL – Innodb Slow Shutdown – Dirty Buffer Pages

If you have a MySQL server that reserves a large amount of memory for the Innodb buffer pool, you may have seen that it can often take a very long…

Read more

MySQL Collate and Case Sensitivity – Flexible Compare

By Prodromus August 31, 2010 MySQL No Comments
MySQL Collate and Case Sensitivity – Flexible Compare

In a typical MySQL installation, the default character set and collation are latin1 and latin1_swedish_ci.  This means that all string comparisons will be performed in a case insensitive manner.  So, ‘Search String’=’search string’.  This…

Read more

  • « Previous
  • Next »
  • Terrorist Screening Database – The Terrorist Watch List
  • Lockheed Martin F-22 RaptorLockheed Martin F-22 Raptor
  • Node.js – fs.open / fs.writeFile, mode, file permissions, umask, and how they interactNode.js – fs.open / fs.writeFile, mode, file permissions, umask, and how they interact

Recent Posts

  • 2005 Laser Blue Lotus Elise for Sale
  • 2011 MacBook Pro GPU Failure – A software fix to disable GPU
  • Unable to renew using LetsEncrypt Certbot-Auto with CRON – Fail
  • Installing LetsEncrypt Certbot on Amazon Linux Server
  • Upgrade your Miata’s headlights with Hella H4 halogen bulbs, Cibie eCode projectors, and a relay kit.

Pages

  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

Copyright © 2021 Z-Car | Theme by: Theme Horse | Powered by: WordPress