MySQL Commands

How to add a column to MySQL using the add column SQL command

Add a unique table column in MySQL to ensure you do not have any duplicates, but using 'Add Unique' in your SQL Code

How to use the MySQL alter table command, and what to combine it with to do different things to your database.

Use Ceiling to always round a number up

The change SQL command can be used to change a column's name

The MySQL Count command is used to count the number of records held on a specific table

Use the create database command in MySQL to create a new database on the MySQL server

The describe command shows a tables fields and their formats

How to remove (drop) a column from a table using MySQL with your SQL database.

The drop database command in MySQL will remove a database from the server

Remove an entire table from a MySQL database using the drop table command

Use Floor to always round a number down

From is used with Select in MySQL to choose what table to query from

Limit the results of your MySQL query to results within a certain number range.

Change the size of a MySQL column by using the Modify SQL command

Login to your mysql server from unix shell

The SQL select statement is used to choose what data to pull from the mysql database

The show columns command is used to display all the columns for a given table and their details.

Use the show databases command in MySQL to show all the databases on the MySQL server

The show tables command is used to display all the tables in a MySQL database

Switch databases in MySQL using the use command

In SQL where is used with select to choose specifically what to search for in your MySQL database

Learn all of the available MySQL commands and what each of them is used for when working with your MySQL database.

Limit the results of your MySQL query to results between a certain number range.

How to close your connection to MySQL from PHP