-
SQL: select into
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…
-
Adminer – phpMinAdmin – phpMyAdmin
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…
-
MySQL SET Data Type
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…
-
MySQL SELECT Tutorials: Simple JOIN
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…
Up-to-date articles will return when migration completes. Meanwhile viewing an old database.