(Vineet Kumar Saini) In the previous article you saw how to insert a value from a textbox into a MySQL database in PHP. In this article you will see how to insert a value from a radio button into a MySQL database using PHP.
Tag: Open Source
How to resize InnoDB logs?
(Thomas) If for any reason you need to change the size of InnoDB log files (also known as transaction logs), but not sure how to do it, this post will guide you through the steps.
Global Transaction Identifiers are in MySQL 5.6.5 DMR
(Luís Soares) I am very happy and especially proud to announce that the replication team has delivered global transaction identifiers to MySQL 5.6.5 Development Milestone Release (DMR). It is a very useful, big, impressive and game-changing feature that will make life easier for many of our users.
Was a query served from MySQL Query Cache?
(Maciej Dobrzanski) The MySQL query cache is a special buffer, where database stores the text of a SELECT statement together with the corresponding result that was sent to the client. For as long as no table that a statement refers to changes in any way, including the contents, the cached result can
MySQL: Create, Show, and Describe Database Tables
(wubayou) This article will describe how to work with database tables. Specifically, you will learn how to create, show, and describe database tables.
How to prevent swapping on a MySQL server?
(Maciej Dobrzanski) Swapping occurs when system moves some data between memory and a special area on disk called swap space. The process is called swapping in or swapping out depending on the direction in which it happens. System swaps out when it makes a decision to free up some physical memory (RA
Insert Value From Radio Button in MySQL in PHP
(Vineet Kumar Saini) In the previous article you saw how to insert a value from a textbox into a MySQL database in PHP. In this article you will see how to insert a value from a radio button into a MySQL database using PHP.
Can COUNT(*) be used in MySQL on InnoDB tables?
(Thomas) COUNT() function returns a number of rows returned by a query. In a popular opinion COUNT(*) should not be used on InnoDB tables, but this is only half true.
MySQL DELETE Join example
(Jan Brinkmann) A very useful helper in your join toolbox can be a delete join. Even though it’s not a special join type but a join used within DELETE statements, it’s still worth mentioning. However, from time to time when I want to make use of delete joins on my own, I somehow managed it to forgo
How to find MySQL configuration file?
(Thomas) A customer called me today asking for help with locating the configuration file used by one of their production MySQL instances. From the description I was given it appeared that their server had at least six different copies of my.cnf file in different locations on disk. And all were simil
