Skip to content

Alex T. Silverstein's Blog

code and life

Category: mysql

MySQL: The reason for using the “DELIMITER” statement in MySQL routines (stored procedures, functions, triggers)

Author Alex T. SilversteinPosted on June 18, 2013Categories mysql, programming and development11 Comments on MySQL: The reason for using the “DELIMITER” statement in MySQL routines (stored procedures, functions, triggers)

MySQL: How to Re-Sync (Refresh) Replication Properly

Author Alex T. SilversteinPosted on May 17, 2013May 17, 2013Categories mysql, programming and development1 Comment on MySQL: How to Re-Sync (Refresh) Replication Properly

MySQL: INSERTing a row IF NOT EXISTS — Yes, it’s possible!

Author Alex T. SilversteinPosted on January 29, 2013January 29, 2013Categories mysql, programming and developmentLeave a comment on MySQL: INSERTing a row IF NOT EXISTS — Yes, it’s possible!

MySQL:Old-Style JOIN Syntax is Required for Correlated Subqueries

Author Alex T. SilversteinPosted on November 29, 2012November 29, 2012Categories mysql, programming and developmentLeave a comment on MySQL:Old-Style JOIN Syntax is Required for Correlated Subqueries

MySQL MERGE and TEMPTABLE Algorithms for Views

Author Alex T. SilversteinPosted on November 29, 2012November 29, 2012Categories mysql, programming and developmentLeave a comment on MySQL MERGE and TEMPTABLE Algorithms for Views

MySQL Transactions — The Right Way

Author Alex T. SilversteinPosted on November 27, 2012November 29, 2012Categories mysql, programming and developmentTags mysql, sql, transactionsLeave a comment on MySQL Transactions — The Right Way

MySQL How-To: Match a GUID in a MySQL Regex (Regular Expression)

Author Alex T. SilversteinPosted on September 4, 2012Categories mysql, programming and developmentLeave a comment on MySQL How-To: Match a GUID in a MySQL Regex (Regular Expression)

MySQL How-To: Which SQL statements are running right now?

Author Alex T. SilversteinPosted on August 2, 2012August 21, 2012Categories mysql, programming and developmentTags information_schema, mysql, performance, profiling, sqlLeave a comment on MySQL How-To: Which SQL statements are running right now?

Recent Posts

  • Easily Remove Built-In Windows 10 Apps Using PowerShell
  • How to Trace/Capture Web Service & REST HTTP Requests Using Fiddler in 3 Easy Steps
  • .NET Web API – Transform dynamic result to JSON
  • Stop POODLE SSL (SSLv3 Vulnerability) Attacks on Apache
  • Consider Encryption for Your Business — Article Published in Saratoga Business Journal

Recent Comments

  • Carmine Yantis on How to Use the Ping Command to Ping IPv4 or IPv6
  • Gabriel Henao on How to Use the Ping Command to Ping IPv4 or IPv6
  • WilliamPes on Easily Remove Built-In Windows 10 Apps Using PowerShell
  • MB on How to Use the Ping Command to Ping IPv4 or IPv6
  • devops training on Linux: How to Determine Cron-Execution-Time Environment Variable Values

Archives

  • August 2019
  • December 2015
  • December 2014
  • October 2014
  • July 2014
  • February 2014
  • June 2013
  • May 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • September 2012
  • August 2012

Categories

  • apache
  • asp.net
  • css
  • encryption
  • linux administration
  • mysql
  • perl
  • PowerShell
  • programming and development
  • project management
  • shell scripting
  • sql server administration
  • web api
  • windows

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Alex T. Silverstein's Blog Proudly powered by WordPress