SELECT INTO is a handy feature if you need to move (or copy, specifically in this example) data from one table to another. This brief article means to illustrate how the same Database storage result can be achieved using multiple approaches. Consider the following SQL INSERT statement, which puts data into TABLE 2 by first…
Have you ever found yourself irritated by the time it takes phpMyAdmin to perform functions, or even load? If you need to quickly check your database, you might find the one-page PHP file application, Adminer, for administration of you MySQL / Maria DB is the solution for you. Adminer has a simple interface that loads…
The following is an excerpt from an article i have referenced numerous times myself from the original source at MySQL : AB (the official MySQL developer zone, located at http://dev.mysql.com/tech-resources/articles/). The SET datatype is kind of like an ENUM, except there’s an option to pick groups of items as a reply, instead of only one…
Here’s a nice little helpful tutorial. More Tutorials should be collected here to save time in the future as this is certainly one of the most important aspects of dynamic web application development. I believe that the true power of the Application is derived from efficiency of the SQL, the Database Normalization itself, and the logic…
This is just a place where I keep notes. So I have a reference. The notes are the same regardless of my location.
add-on Apache ASCII Attitude Browser Command Line CSS custom design desktop Development Concepts Entertainment Graphic Design HTML IDE Related IIS Internet Explorer JavaScript Library.Images Linux match Mozilla MySQL PHP Productivity Recommended regex regular expressions replace Resources and Reference Rules-of-Thumb Search Engines Security semantic Software sql SQL & Query Scripting Taxonomy.None Technique & Method text-editor Unicode Web Development Windows Windows Stuff wordpress
