3.3.4.7 Pattern Matching. Mysqli. 1 Reference Manual :: 12.2.6 LOAD DATA INFILE Syntax. 1 Reference Manual :: 2.3 Installing MySQL on Microsoft Windows. MySQL Commands. 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. 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]; List all databases on the sql server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the db. mysql> show tables; To see database's field formats. mysql> describe [table name]; To delete a db. mysql> drop database [database name]; To delete a table. mysql> drop table [table name]; Show all data in a table. mysql> SELECT * FROM [table name]; Show unique records. Sum column. or.