Master:
# 1    Mysql command line                  
hans
Online no
State
Grouping Member
Class class4
Score 221
Wealth 155.5
Posts 156
Login 21:17:46
I put some simple commands here for reference.
Login with command line:
Before enter mysql shell, type the following command:
mysql -u usename -p

After click, allow us enter password to login. After login we will enter mysql shell.

Show tables:
mysql>show tables in a-databasename

Show columns of table:
mysql>use database a-databasename
mysql>show colunms in a-tablename
Hits: 215, Date: 2010-05-22 02:08:08
[Agree] ( 7 ) [Against] ( 6 )

1 - 1 [ 1]

Reply: Mysql command line

*First line:


More content:


Tags:



Hint: You cannot post here before loginLogin | Register

nothing