Tag

mysql

5 posts with this tag.

• April 17, 2014 / 1 min read

  Ignore Foreign Key Constraints During Truncate or Drop

  If you are trying to drop/delete or empty/truncate a mysql table and you keep getting an error that you are violating a foreign key constraint, you may want to temporarily ignore that constraint. The code below demons...

  How To'sProgramming Guides

  

• April 1, 2014 / 1 min read

  Create new MySQL user and allow them to connect from any IP

  If you are getting the error: user is not allowed to connect to this MySQL serverConnection closed by foreign host Or : Access denied for user 'root'@'somehost.com' (using password: YES)) Then you probably have not cr...

  Programming Guides

  

• March 28, 2014 / 1 min read

  MySQL See all columns and tables that foreign key to a table or column

  If you're trying to understand how an existing database has been setup it can be very useful to see all of the tables/columns that foreign key into some other table/column. use INFORMATION_SCHEMA; select TABLE_NAME,CO...

  Programming Guides

  

• March 24, 2014 / 1 min read

  Ruby MySQL Transaction Example

  Here is a simple tutorial showing how to implement transactions in Ruby with MySQL. The code uses The MySQL2 Gem. We are showing the insert of 2 records into the customers table of a database. If either insert fails,...

  Programming Guides

  

• August 18, 2011 / 1 min read

  Add MySQL User | Give them Permissions On a Database

  This simple guide demonstrates adding a new user to mysql and giving that user full access rights to a particular db within MySQL. This is really useful when you want to create a new database user for a new wordpress...

  How To's