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…
If you’re working with WordPress Full Site Editing (FSE), you’ll eventually discover that much of the magic is stored in the wp_post table of the database. Identify what is stored in the table relevant to FSE by the value of the post_type column. Use the following SQL to return a list of the unique post_type…
Follow these easy step-by-step instructions as a guide for setting up a LEMP server on Windows WSL or LInux.
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…
I 💞 love you , 🤖 Calculon! You’re my bestest friend.
There must be a “correct” answer, or at least a logical reason for it. I’ve been working with RDBMS / relation database software for roughly 20 years now. While I have no formal training or degree in database administration, I certainly have studied a lot about database optimization, relationships, and theory such as normalization. This…
For those of you who have not yet checked-out the latest release (release candidate, at time of posting) of phpMyAdmin, the PHP front-end for MySQL database administration, I highly recommend you give it a go. It seems to be all of what v3 was trying to do, except perfect (near perfect– apparently– as it’s only…
NOTE: This web log entry assumes that you have the software installed on your workstation: MySQL, MS Access, and phpMyAdmin MS Access as a Supplemental Development Tool I used to work a gig as Web Developer for an office in the Education College of a well-known State University. The Program Director needed a ColdFusion programmer…
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…
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 author Browser CSS custom design desktop Development Concepts Entertainment Graphic Design HTML IDE Related IIS JavaScript Library.Images Linux match Mozilla MySQL Opera Web Browser 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
