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

Count number of tables in the database – MySQL

By Prodromus January 27, 2011 MySQL, Scripting 2 Comments
Count number of tables in the database – MySQL

Determining the number of tables that are contained in a MySQL database is very straight-forward, although it is an often asked question. The simplest way to accomplish this is using…

Read more

MySQL Delimiters – Or why I hate stored procedures and Error Code : 1064 You have an error in your SQL syntax.

By Prodromus August 19, 2010 MySQL, Stored Procedure 1 Comment
MySQL Delimiters – Or why I hate stored procedures and Error Code : 1064 You have an error in your SQL syntax.

MySQL 5.0+ gave DBA’s the ability to write stored procedures and functions. This is a great addition, and one that all “real” DB engines should provide. But, as many DBA…

Read more

MySQL – SQL Injection, and how to Prevent it

By Prodromus June 11, 2010 MySQL, Scripting No Comments
MySQL – SQL Injection, and how to Prevent it

SQL injection vulnerabilities are often been described as the most serious threat for Web applications, regardless of what language they are written in . Web applications that are vulnerable to…

Read more

MySQL – Disabling Binary Logging for INSERT and UPDATE

By Prodromus June 2, 2010 MySQL, Replication 1 Comment
MySQL – Disabling Binary Logging for INSERT and UPDATE

I have run into many situations where there would be a benefit to not replicate a large INSERT or UPDATE from the MASTER to SLAVE in order to not block…

Read more

MySQL – Constraints on Hierarchical Data in a Self-Referential Table

By Prodromus June 1, 2010 MySQL No Comments
MySQL –  Constraints on Hierarchical Data in a Self-Referential Table

I recently had a client who was using a table structure that utilized a self-referential structure using an ID field and Parent_ID fields. After upgrading to Innodb, his DBA was…

Read more

MySQL How to delete duplicate records and rows of data

By Prodromus May 3, 2010 MySQL, Programming No Comments
MySQL How to delete duplicate records and rows of data

The fastest and easiest way to delete duplicate records is my issuing a very simple command. alter ignore table [tablename] add unique index `unique_index` ([fieldname]) What this does is create…

Read more

  • « Previous
  • Pretty White ZPretty White Z
  • Solar Pool Heater Keeps Kids ToastySolar Pool Heater Keeps Kids Toasty
  • MySQL – SQL Injection, and how to Prevent itMySQL – SQL Injection, and how to Prevent it

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

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.

Chat with me Live!

Recent Comments

  • Phyllis Dorazio on GE Induction Cooktop – Control Lock Stuck ON
  • Chuck from PA on Toyota SDK8
  • Tony Mann on Toyota SDK8
  • James J. Fairbanks on Fairchild Republic A-10 Thunderbolt II “WartHog”
  • MyClock on Moen shower faucet provides no cold water, only hot

Categories

  • A-10 Thunderbolt II
  • Animals
  • B-17 Flying Fortress
  • B-25 Mitchell
  • Bell
  • Blogging
  • BMW
  • Boeing
  • Books
  • Cars
  • Chevy
  • Chrome
  • Chrysler
  • Corruption
  • Datsun
  • DIY
  • Electric Car
  • Electronics
  • Energy-Independence
  • Engines
  • Errors
  • Extjs
  • F-111 Aardvark
  • F-14 Tomcat
  • F-15
  • F-16 Fighting Falcon
  • F-20 Tigershark
  • F-22 Raptor
  • F-4 Phantom II
  • F/A-18
  • F6-F Hellcat
  • Fabrica Militar de Aviones
  • Fairchild Republic
  • Food
  • General Dynamics
  • Girls
  • Global Warming
  • GM
  • Green
  • Grumman
  • Honda
  • Humor
  • IA 58 Pucará
  • Infiniti
  • Innodb
  • JsonStore
  • Linux
  • Lion Electric Vehicles
  • Lockheed
  • Lockheed Martin
  • Lotus
  • MacBook Pro
  • Magazine
  • Mazda
  • McDonnell Douglas
  • Mercedes
  • Miata
  • Mongo DB
  • Movie
  • Museum
  • MySQL
  • Node.js
  • North American Aviation
  • Northrop
  • Oil Companies
  • Optimization
  • Other
  • P-38 Lightning
  • P-39 Airacobra
  • P-47
  • P-51 Mustang
  • Paleo
  • Past
  • PHP
  • Planes
  • Planes of Fame
  • Politics
  • Porsche
  • Primal
  • Pro Bono
  • Programming
  • Query Optimization
  • R/C Airplanes
  • Repair
  • Replication
  • Republic
  • Restore Backup
  • Rolls-Royce
  • RQ-170 Sentinel
  • Scam
  • Scripting
  • Security
  • SEO – Search Engine Optimization
  • Software
  • Solar
  • Stored Procedure
  • Tesla
  • Th!nk!
  • Theater
  • Tourism
  • Toyota
  • Toyota SDK8
  • Travel
  • Vacation
  • War
  • Web
  • Wings of Freedom
  • Wordpress
  • X-2
  • Zip Files

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