Very useful MySQL Commands.......

[RC (आर.सी.) Adhikari]

http://www.pantz.org/software/mysql/mysqlcommands.html

MySQL Commands

Posted on 07-25-2007 00:13:00 UTC | Updated on 01-21-2010 02:40:23 UTC
Section: /software/mysql/ | Permanent Link

---

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. To use MySQL with Perl you will need to use the Perl modules DBI and DBD::mysql.

Below when you see # it means from the unix shell. When you see mysql> it means from a MySQL prompt after logging into MySQL.

To login (from unix shell) use -h only if needed.

# [mysql dir]/bin/mysql -h hostname -u root -p

Create a database on the sql server.

mysql> create database [databasename];

Click the link for more details.........MySQL Commands

With Regards
-------------------------------
RC (आर.सी.) Adhikari