manipulating databases using the command line

Windows used to, we are immersed in the graphical interface, unable to extricate themselves. When we use the database, the first reaction is to open the graphical interface tool. Needless to say, using this visualization tool can improve development efficiency, but it does more harm than good to us.

The pros and cons of using the command line and using a graphical interface are summarized below.

Using the command line:

1. It is critical to increase the mastery of SQL statements. The graphical interface is very friendly, let us not indulge in slightly complex SQL statements, but the bottom of the graphics interface is not encapsulated these SQL statements;

2. The error rate for SQL proficiency is almost zero. The graphical interface can do, the SQL statement must be able to do! The graphical interface can not do, the SQL statement may be able to do;

3. Using SQL statement execution efficiency is certainly higher than the graphical interface, because the graphical interface will also be a conversion of your operation;

4. Use the command line to occupy less system resources. This is a benefit for friends who have low computer configuration.

Using the graphical interface:

1. It's not good for you to have a long time, you will be dependent on it;

2. Not conducive to the control of SQL;

3. The use of graphical interface sometimes encounter strange problems, let you toss for a long time;

4. Fool-type operation will make you "stupid".

Sum up:

Get rid of the graphical interface, use the command line!

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/basis/