Articles Posted in the " Mysql " Category
-
MySQL Offset Limit Data Selections
MySQL provides a LIMIT clause that is used to specify the number of records to..
-
10 Mistakes Which PHP MySQL Developers Make
1. Using MyISAM rather than InnoDB MySQL has a number of database engines, but you’re..
-
How to Get the Current Timezone of Mysql Database
By running below query you can able to get the Current Timezone of the database..
-
How to Add Column to Mysql Table and Auto Increment with Primary Key
Check below on How to Add a Column to Mysql Table with Auto Increment and..
-
How to Get Size of a Database in Mysql
To Get Data Base Size in MB and Free Space in MBSELECT table_schema “dbName”, ..
-
How to find duplicate rows in Sql or Mysql
You can find duplicate rows in the mysql table, just use below select query, to..
-
alter table and make id as auto increment
ALTER TABLE internal MODIFY COLUMN id INT(32) NOT NULL auto_increment PRIMARY KEY;
-
Export to Excel Using PHP and Mysql
Below simple program will export mysql data values to excel sheet without using any PHP..
-
Best way to loop through a PHP mysql Resultset
If you want to loop throuh the mysql result set twice then use below way…
-
PHP Radio Button Example With Mysql DB
Simple PHP Radio button enable and disable textarea textbox example in php using Mysql