Five Basic but Useful MySQL commands

Posted by kumarjit in Web Hosting, Web Hosting Tips

1 Star2 Stars (No Ratings Yet)

Five Basic but Useful MySQL commands

MySQL is the most popularly used database query and maintenance software. It has an excellent API and language bindings with most major languages – PHP, Python, C++, Ruby. Below are listed five very basic but useful SQL commands –

1. SELECT

This command is used in almost all interactive queries from a MySQL database, to request for tuples (rows). It is the most easy to use and basic command in MYSQL.

2. CREATE

This command creates a table with the desired name and attributes. If necessary, it can borrow fields from other tables.

3. INSERT

This command is used to insert new tuples (rows) in a table. It has 3 variations – INSERT … VALUES, INSERT … SETS, INSERT … SELECT. The first two statements insert explicitly mentioned values as tuples (rows), whereas the third is used to insert values from one table to another based on certain queries.

4. ALTER TABLE

This command is used to alter the structure of any table after it is created, for example, create, destroy or rename fields (columns), or change column attributes.

5. UPDATE

This SQL command is very commonly used, to update the tuples (rows) to some changed value based on certain queries.

BounceWeb provides great offers on MySQL hosting!

Be Sociable, Share!

Leave a Reply

You must be logged in to post a comment.