Following a Plan

The execution plan (often called the query execution plan or the explain plan) contains the individual steps a database goes through to execute a SQL statement. For example, execution plans provide information on which indexes are used, in which order access to the various tables occurs, and what algorithms are used for joins, sorting, and grouping operations.

The execution plan roughly corresponds to bytecode in scripting languages like Perl or Python – it is used internally to execute SQL statements. Creating an execution plan is sometimes also known as a compiling. However, this is more commonly referred to as the prepare phase ....

(More)

Southern writes:  

Print all the Data from a MySQL Table in an HTML Table using PHP

What we are using here:

MySQL database:

–MySQL Username: root

–No MySQL Password

–Database Name: PracticeDatabase

–Table Name: Contacts

And 3 echo statements to print the HTML table.

The code:

more My Coding

Note: Obviously this would need to be adjusted to include the database password, etc.

kguske writes:  

This December, 2012, article details Wikipedia's efforts to date and future plans to migrate the # 6 website from MySQL to open source fork MariaDB. Although Wikipedia's primary concern is for open and supported development, initial results indicate a hard benefit: performance improvements.

Unfortunately, it appears that the concern for support is also real - significant security issues remain 2 months and 1 release after being reported. For MariaDB, the issues were either already resolved before or have been after the report. Commercial support is available for both MySQL (owned by Oracle) and MariaDB (developed by the original developers of MySQL and owned by the not-for-profit MariaDB Foundation).

 Read More...

Southern writes:  

Oracle is set on Tuesday to release 78 security fixes for vulnerabilities in its database, middleware and applications, according to a preview announcement posted to the company's website this week.

A full 27 of those are targeted for the MySQL database. One of the vulnerabilities can be exploited over a network without log-in credentials. The highest CVSS (Common Vulnerability Scoring System) Base Score among the MySQL bugs is 5.5, which falls into the system's "medium" risk range.

Two other fixes are for Oracle's database, and Oracle is also planning to ship 11 patches for Fusion Middleware. Five of the bugs in the latter can be remotely exploited with no user authentication required.

more: ITWorld

Southern writes:  

One of the most important tasks any developer needs to do often is back up their MySQL database. In many cases, the database is what drives most of the site. While most web hosts do a daily backup of a customer's database, relying on them to make backups and provide them at no cost is risky to say the least. That's why I've created a database backup function that I can call whenever I want -- including nightly CRONs.

The PHP & MySQL Code
more: david walsh

nb1 writes:  

The creator of MySQL has launched a Web-based campaign to "save" the open-source database from the "clutches" of Oracle, which is attempting to purchase its current owner, Sun Microsystems.

Oracle announced plans to buy Sun in April for US$7.4 billion, but the deal has been held up while European authorities conduct an antitrust review. One key concern of regulators, as well as open-source advocates, is the future of MySQL under Oracle, which holds a healthy share of the database market with its own proprietary product.

But if users speak up now, European authorities could stop the merger or force Oracle to provide certain concessions and guarantees around MySQL, Michael "Monty" Widenius said in a

blog post.