Welcome to the MySQL Knowledge Base and Tutorial
PHP mysql select average program example
PHP mysql select average program example PHP MySQL code to to calculate average. <!doctype html> <html lang=”en”> <head> <metaRead More »
MySQL AVG() function
MySQL AVG() function AVG function to calculate the average value of a set of values or an expression. The AVG() functionRead More »
MySQL count function
MySQL count function The COUNT() function returns the number of rows that matches a specified criteria. COUNT function to count theRead More »
MySQL MIN() and MAX() Functions
MySQL MIN() and MAX() Functions The MIN() function returns the smallest value of the selected column and the MAX()Read More »
MySQL UPDATE Statement
MySQL UPDATE Statement The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax: UPDATE tablename SET col1 = val1, col2 = value2, …Read More »
MySQL where condition
MySQL where condition WHERE Syntax SELECT column1, column2, … FROM table_name WHERE condition; Note: The WHERE clause is not only used in SELECT statement,Read More »
mysql create index on table
mysql create index on table CREATE INDEX Syntax Creates an index on a table. Duplicate values are allowed: CREATE INDEX index_nameRead More »
MySQL Server Logs
MySQL Server Logs MySQL Server has several logs that can help you find out what activity is taking place. ByRead More »
mysqld dead but subsys locked
mysqld dead but subsys locked Backup for future Safety: cp /var/lock/subsys/mysqld /root/mysqld than delete it rm /var/lock/subsys/mysqld then close allRead More »
Creating and Selecting a Database
Creating and Selecting a Database If the database administrator creates your database for you when setting up your permissions, youRead More »
SQL CASE
SQL CASE The CASE statement goes through conditions and return a value when the first condition is met (like anRead More »
Rename database in MySQL
From phpMyAdmin, select the database you want to select. In the tabs there’s one called Operations, go to the renameRead More »
mysql between example : Get data between two dates
mysql between example : Get data between two dates Read More »
comparison operator between in mysql
comparison operator between in mysql General Syntax – mostly used SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; expr BETWEEN min AND max If exprRead More »