MYSQL command Daquan

2010-05-24  来源:本站原创  分类:Database  人气:294 

Common MySQL command Daquan

First, connect MySQL

Format: mysql-h host address-u username-p password

1, Example 1: Connect to the machine on MYSQL.

First, open the DOS window, then enter the directory mysqlbin, then type the command mysql-uroot-p, a carriage return after the prompt you lose your password, if the newly installed MYSQL, super-user root no password, so you can directly enter Enter in the MYSQL, MYSQL prompt is: mysql>.

2, Example 2: connect to remote host on MYSQL. Suppose the remote host IP is: 110.110.110.110, user name is root, password is abcd123. Type the following command:

mysql-h110.110.110.110-uroot-pabcd123

(Note: u and the root can not have spaces, the other is the same)

3 out of MYSQL command: exit (Enter).

Second, change your password

Format: mysqladmin-u username-p password your new password the old password

1, Example 1: to add a root password ab12. First, enter the directory in DOS mysqlbin, and then type the following command:

mysqladmin-uroot-password ab12

Note: Since the beginning of root without a password, so-p old password one can be omitted.

2, Example 2: then root password to djg345.

mysqladmin-uroot-pab12 password djg345

Third, add a new user. (Note: different from above, the following environment because MySQL command, so all the back end with a semicolon as a command character)

Format: grant select on database .* to username @ log host identified by \ "password \"

Example 1, add a user password for test1 abc, so he can log on any host, and all databases have query, insert, update, delete permissions. First of all to root users connected to the MySQL, and then type the following command:

grant select, insert, update,

delete on *.* to Test2 @ localhost identified by \ "abc \";

If you do not want test2 password, you can resort to a command to eliminate the password.

grant select, insert, update, delete on mydb

.* To Test2 @ localhost identified by \ "\";

In the above about the login, add user, password change and other issues. Let us look at MySQL, the database operation. Note: You must first log on to MySQL, the following operations are carried out in the MySQL prompt, and end each command with a semicolon.

1, MySQL frequently used commands

create database name; create a database

use databasename; select database

drop database name directly delete the database, not to remind

show tables; indicator

describe tablename; table a detailed description of

select distinct remove duplicate fields in addition

mysqladmin drop database name to delete the database before a prompt.

Display the current mysql version and the current date

select version (), current_date;

2, changes in the root password for mysql:

shell> mysql-u root-p

mysql> update user set password = password ("xueok654123") where user = 'root';

mysql> flush privileges / / Refresh database

mysql> use dbname; open the database:

mysql> show databases; display all database

mysql> show tables; show all the tables in the mysql database: first use mysql; then

mysql> describe user; show table mysql database user table column information);

3, grant

Create a connection to the server from any place as a full super-user, but must use a password something to do this

MySQL> grant ALL privileges on *.* to User @ localhost identified by 'something' with

Add a new user

Format: grant select on database .* to username @ log host identified by "password"

GRANT ALL PRIVILEGES ON *.* TO Monty @ localhost IDENTIFIED BY 'something' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO Monty @ "% "IDENTIFIED BY 'something' WITH GRANT OPTION;

Remove authorization:

MySQL> revoke ALL privileges on *.* from root @ "% ";

mysql> delete from user where user = "root" and host ="%";

mysql> flush privileges;

Create a user in a particular client it363.com custom login, can access a specific database fangchandb

mysql> grant select, insert, update, delete, create, drop on fangchandb .* to [email protected] identified by 'passwd'

Rename the table:

mysql> alter table t1 rename t2;

4, mysqldump

Backup Database

shell> mysqldump-h host-u root-p dbname> dbname_backup.sql

Restore database

shell> mysqladmin-h myhost-u root-p create dbname

shell> mysqldump-h host-u root-p dbname <dbname_backup.sql

If you want to unload the building table command, the command is as follows:

shell> mysqladmin-u root-p-d databasename> a.sql

If you just want to unload a sql command insert data without the need to build the table command, the command is as follows:

shell> mysqladmin-u root-p-t databasename> a.sql

So if I only want the data, not what you want sql command, how does it work?

mysqldump-T. / phptest driver

Of these, only designated-T parameters can be discharged only plain text files that unloaded the data directory,. / The current directory, that is, the same directory with mysqldump. If you do not specify the driver table, it will unload the entire database of data. Each table will generate two files, one for. Sql files, including construction of the table implementation. The other is. Txt file contains only data, and no sql command.

5, the query can be stored in a file and tell mysql to read query from a file instead of waiting for keyboard input. Shell type can be used to redirect the utility to complete the work. For example, if there is stored in the file my_file.sql search

Consultation, following the implementation of these queries could be:

For example, if you want to built form statement written in the sql.txt in advance:

mysql> mysql-h myhost-u root-p database <sql.txt

1, the installation environment:

Windows XP

Mysql 4.0.17 from the next time you need to use mysql-uroot-proot can login

In the remote or the machine can use mysql-h 172.5.1.183-uroot landing, according to the second line of this strategy to determine

Permission changes to take effect:

1) net stop mysql

net start mysql

2) c: \ mysql \ bin \ mysqladmin flush-privileges

3) After landing mysql, with flush privileges statement

6, create a database staffer

create database staffer;

7, the following statement at the mysql environment in the implementation of the

Shows the database user has permissions to show databases;

Switch to the staffer database use staffer;

Have permission to display the current database table show tables;

Shows the structure of the table staffer desc staffer;

8, create a test environment

1) create a database staffer

mysql> create database staffer

2) create table staffer, department, position, depart_pos

create table s_position

(

id int not null auto_increment,

name varchar (20) not null default 'manager', # set default values

description varchar (100),

primary key PK_positon (id) # set the primary keys

);

create table department

(

id int not null auto_increment,

name varchar (20) not null default 'Systems', # set default values

description varchar (100),

primary key PK_department (id) # set the primary key

);

create table depart_pos

(

department_id int not null,

position_id int not null,

primary key PK_depart_pos (department_id, position_id) # set the complex and primary keys

);

create table staffer

(

id int not null auto_increment primary key, # set the primary key

name varchar (20) not null default 'Anonymous', # set default values

department_id int not null,

position_id int not null,

unique (department_id, position_id) # set the unique values

);

3) Delete

mysql>

drop table depart_pos;

drop table department;

drop table s_position;

drop table staffer;

drop database staffer;

9, modify the structure

mysql>

# Table position to increase the column test

alter table position add (test char (10));

# Modify the column test table position

alter table position modify test char (20) not null;

# Table position changes the default value of the column test

alter table position alter test set default 'system';

# Table position to remove the default test

alter table position alter test drop default;

# Table position to remove the column test

alter table position drop column test;

# Remove the primary key table depart_pos

alter table depart_pos drop primary key;

# Increase the primary key table depart_pos

alter table depart_pos add primary key PK_depart_pos (department_id, position_id);

10, operation data

# Insert Table department

insert into department (name, description) values ('Systems', 'Systems');

insert into department (name, description) values ('PR', 'PR');

insert into department (name, description) values ('customer service department', 'Customer Service Department');

insert into department (name, description) values ('Finance Department', 'Finance Department');

insert into department (name, description) values ('test department', 'Test Department');

# Insert Table s_position

insert into s_position (name, description) values ('Director', 'Director');

insert into s_position (name, description) values ('manager', 'Manager');

insert into s_position (name, description) values ('general staff', 'general staff');

# Insert Table depart_pos

insert into depart_pos (department_id, position_id)

select a.id department_id, b.id postion_id

from department a, s_position b;

# Insert Table staffer

insert into staffer (name, department_id, position_id) values ('Chen governance', 1,1);

insert into staffer (name, department_id, position_id) values ('Li Wenbin', 1,2);

insert into staffer (name, department_id, position_id) values ('Ma Jia', 1,3);

insert into staffer (name, department_id, position_id) values ('Kang Zhiqiang', 5,1);

insert into staffer (name, department_id, position_id) values ('Yang Yuru', 4,1);

11, query and delete operations

# Display Systems staff and positions

select a.name, b.name department_name, c.name position_name

from staffer a, department b, s_position c

where a.department_id = b.id and a.position_id = c.id and b.name = 'Systems';

Part number # display system

select count (*) from staffer a, department b

where a.department_id = b.id and b.name = 'Systems'

# Show number of departments

select count (*) cou, b.name

from staffer a, department b

where a.department_id = b.id

group by b.name;

# Delete the Customer Service Department

delete from department where name = 'Customer Service Department';

# Will be revised to finance a Finance Department

update department set name = 'finance an' where name = 'Finance Department';

12, backup and recovery

Backup database staffer

c: \ mysql \ bin \ mysqldump-uroot-proot staffer> e: \ staffer.sql

Staffer.sql get a sql script, does not include building a database of statements, so you need to manually

Create the database before they can import

Restore database staffer, need to create an empty library staffer

c: \ mysql \ bin \ mysql-uroot-proot staffer <staffer.sql

If you do not want to then manually create a staffer, you can

c: \ mysql \ bin \ mysqldump-uroot-proot - databases staffer> e: \ staffer.sql

mysql-uroot-proot> e: \ staffer.sql

However, species so that the system can not exist staffer library, and can not import other names database

Of course, you can manually modify the staffer.sql file

13, import data from text to database

1) Use tools to c: \ mysql \ bin \ mysqlimport

The role of this tool is to file into and remove the file extension name of the same table, such as

staffer.txt, staffer to staffer tables are imported

Commonly used options and features are as follows

-D or - delete the new data into the data table, delete data in the data table before all the information

-F or - force regardless of whether an error is encountered, mysqlimport will force to insert data

-I or - ignore mysqlimport skip or ignore those who have the same unique

Keyword line, import the data file will be ignored.

-L or-lock-tables locks tables before the data is inserted, thus prevented,

When you update the database, the user's query and update affected.

-R or-replace this option with the-i option to the role of the contrary; this option will replace

The only keywords in the table have the same record.

- Fields-enclosed-by = char

Data in the specified text file to any enclosed records, and many cases

Data from the double quotation marks. By default data is not included characters played.

- Fields-terminated-by = char

All the data specified separator between the values in the period-separated file,

Separator is a full stop. You can use this option to specify the separator between the data.

The default delimiter is tabbing character (Tab)

- Lines-terminated-by = str

This option specifies the text file data between the BOC and the line of separation string

Or character. Mysqlimport by default as the line separator to newline.

You can choose to use a string to replace a single character:

A new line or a carriage return.

mysqlimport command common options are-v show version (version),

-P prompted for a password (password) and so on.

This tool has a problem and can not ignore some of the columns, so that our data into great trouble, although

Can manually set the field, but somehow the results will appear, we do a simple example

We define the following depart_no.txt, stored in e plate, spacing tabs \ t

10 10

11 11

12 24

Execute the following command

c: \ mysql \ bin \ mysqlimport-uroot-proot staffer e: \ depart_pos.txt

There is no use out in the siege of symbols, divided by the default \ t, there will be problems because the use of other symbols,

Do not know the reason windows

2) Load Data INFILE file_name into table_name (column1_name, column2_name)

This command in the mysql> prompt, use the advantage of the designated column can be imported, the sample is as follows

c: \ mysql \ bin \ mysql-uroot-proot staffer

mysql> load data infile "e: / depart_no.txt" into depart_no (department_id, position_id);

These two tools have problems in Windows use, I do not know the reason Windows is of Chinese,

And does not specify a column it had a null value, which is obviously not what we want, so careful use of these tools

Into MySQL: mysql-uuser-ppassword - port = 3307

1: Use the SHOW statement to find out what currently exists in the server database:

mysql> SHOW DATABASES;

2:2, to create a database MYSQLDATA

mysql> Create DATABASE MYSQLDATA;

3: Select the database you created

mysql> USE MYSQLDATA; (press Enter when the instructions appear Database changed successfully!)

4: See what now exists in the database table

mysql> SHOW TABLES;

5: Create a database table

mysql> Create TABLE MYTABLE (name VARCHAR (20), sex CHAR (1));

6: shows the table structure:

mysql> DESCRIBE MYTABLE;

7: adding records to the table

mysql> insert into MYTABLE values ("hyq", "M");

8: The way the data into a text database table (for example D: / mysql.txt)

mysql> LOAD DATA LOCAL INFILE "D: / mysql.txt" INTO TABLE MYTABLE;

9: import. Sql file command (such as D: / mysql.sql)

mysql> use database;

mysql> source d: / mysql.sql;

10: Delete table

mysql> drop TABLE MYTABLE;

11: Empty Table

mysql> delete from MYTABLE;

12: update data in the table

mysql> update MYTABLE set sex = "f" where name = 'hyq';

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name

SET col_name1 = expr1 [, col_name2 = expr2 ...]

[WHERE where_definition]

[ORDER BY ...]

[LIMIT rows]

or

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...]

SET col_name1 = expr1 [, col_name2 = expr2 ...]

[WHERE where_definition]

UPDATE with new values update existing rows in a table column. SET clause that you want to modify which columns and their values should be given. WHERE

Clause, if given, specifies which rows should be updated. Otherwise, all rows are updated. If the ORDER BY clause is specified, records specified in the order about to be updated.

If you specify key words LOW_PRIORITY, UPDATE implementation will be delayed until no other clients are reading from the table.

If you specify key words IGNORE, the update statement will not be aborted, even during the update process duplicate key error. Records led to the conflict will not be updated soon.

If an expression to access a column from tbl_name, UPDATE uses the current value of the column. For example, the following statement setting out the value of its current age plus the value of 1:

mysql> UPDATE persondata SET age = age +1;

UPDATE assignments are calculated from left to right. For example, the following statement will set out its age twice, then add 1:

mysql> UPDATE persondata SET age = age * 2, age = age +1;

If you set as its current value, MySQL noted that this does not update it.

Actually be changed, and UPDATE return the number of rows. In MySQL 3.22 or later version, C API function mysql_info ()

Match and returns the number of rows updated, and UPDATE the number of warnings during.

In MySQL 3.23, you can use LIMIT # to ensure that only a given number of rows to be changed.

If an ORDER BY clause is used (starting from MySQL 4.0.0 support), rows will be updated in the order specified. This is actually only together with LIMIT

Together to be useful.

Starting from MySQL 4.0.4, you can perform a multiple tables UPDATE operation:

UPDATE items, month SET items.price = month.price

WHERE items.id = month.id;

Note: Multi-table UPDATE could not use the ORDER BY or LIMIT.

Keywords: mysql

Start: net start mySql;

Enter: mysql-u root -p/mysql-h localhost-u root-p databaseName;

Listed in the database: show databases;

Select a database: use databaseName;

Listed in table: show tables;

Show table column attributes: show columns from tableName;

Establish a database: source fileName.txt;

Matching characters: You can use the wildcard _ to any one character,% represents any string;

Add a field: alter table tabelName add column fieldName dateType;

Increase the number of fields: alter table tabelName add column fieldName1 dateType, add columns fieldName2 dateType;

Multi-line command input: Note the word can not be broken; When you insert or change data, the string can not expand to the field where more than one line, or a hard carriage return will be stored in the data;

Add an administrator account: grant ALL on *.* to User @ localhost identified by "password";

After each statement, enter add a semicolon to the end of the fill ';', or fill plus '\ g' can be;

Query time: select now ();

Check the current user: select user ();

Query the database version: select version ();

Query the database currently in use: select database ();

1, delete student_course students in the database table:

rm-f student_course / students .*

2, back up the database: (test database backup)

mysqldump-u root-p test> c: \ test.txt

Backup forms: (a backup test database under the table mytable)

mysqldump-u root-p test mytable> c: \ test.txt

Backup data into the database: (back into test database)

mysql-u root-p test

3, create a temporary table: (create temporary table zengchao)

create temporary table zengchao (name varchar (10));

4, create a table is to first determine the existence of the table

create table if not exists students (... ...);

5, some tables have been copied from the structure of the table

create table table2 select * from table1 where 1 <> 1;

Six, copy the table

create table table2 select * from table1;

7, on the table to rename

alter table table1 rename as table2;

8, changes the type of the column

alter table table1 modify id int unsigned; / / modify column id of type int unsigned

alter table table1 change id sid int unsigned; / / modify the name of the column id to sid, and the property was revised to int unsigned

9, creating an index

alter table table1 add index ind_id (id);

create index ind_id on table1 (id);

create unique index ind_id on table1 (id); / / create a unique index of

10, delete the index

drop index idx_id on table1;

alter table table1 drop index ind_id;

11, United characters or more columns (id and the column ":" and the column name and the "=" Connection)

select concat (id ,':', name ,'=') from students;

12, limit (selected from 10 to 20) <the first of a record set of numbers is 0>

select * from students order by id limit 9,10;

13, MySQL does not support the function

Affairs, views, foreign keys and referential integrity, stored procedures and triggers

14, MySQL will use index operation symbols

<,<=,>=,>,=, Between, in, do not begin with% or _ like

Of 15, using the index of disadvantage

1) slow down the pace of additions and deletions to change data;

2) take up disk space;

3) to increase the burden of query optimizer;

When the query optimizer generates execution plan will take into account the index, too many indexes will increase the workload of the query optimizer, the query result can not choose the best plan;

16, analysis of the efficiency index

Methods: In a general SQL statement prepend explain;

The results mean:

1) table: Table name;

2) type: the connection type, (ALL / Range / Ref). Where ref is the ideal;

3) possible_keys: queries can use the index name;

4) key: actual use of the index;

5) key_len: Index was using some of the length (bytes);

6) ref: display column name or "const" (do not understand the meaning);

7) rows: Show MySQL result that in finding the right number of rows to scan;

8) extra: MySQL's recommendations;

17, with a shorter fixed-length column

1) Try to use shorter data type;

2) Try to use fixed-length data type;

a) use char instead of varchar, fixed-length data processing faster than the variable length;

b) The frequent changes of the table, easy to form a debris disk, thus affecting the overall performance of the database;

c) case of a breakdown of the data table, use a fixed length of the table rows more easily reconstructed. Use a fixed length of data lines, the beginning of each record is a multiple of a fixed record length, can easily be detected, but the use of variable-length data is not necessarily a row;

d) for the MyISAM table type, although the data into fixed-length columns can improve performance, but the space occupied by a large;

18, using not null and enum

As the column definition Is not null, it can provide data to come out faster required for less space, but also in the query, MySQL does not require check Cunzai special case, Ji null Value , Congeryouhua inquiry;

If one contains only a limited number of specific value, such as gender, whether valid or school year and so on, in this case should be considered to convert the enum value of the column, MySQL processed more quickly, because all the enum values in the system is to identify the values expressed in;

19, use the optimize table

For frequently modified form fragments prone to query the database to read more disk blocks to reduce query performance. A long table with variable disk fragmentation problems exist, the problem is more prominent on the blob data types, because of its size vary considerably. By using the optimize table to order debris to ensure no decline in database performance, optimizing those affected by the debris of data sheet. optimize table can be used for MyISAM and BDB type tables. Virtually any defragmentation methods are used mysqldump to dump the data table, and then use the file after the conversion both new data table;

20, using the procedure analyse ()

Can use the procedure analyse () show the best type of recommendation, use very simple select statement followed by the procedure analyse () on it; example:

select * from students procedure analyse ();

select * from students procedure analyse (16,256);

The second statement is required procedure analyse () do not contain more than 16 recommended value, or contains more than 256 bytes of the enum type, without restriction, the output may be very long;

21, use the query cache

1) The query cache works:

The first implementation of the select statement on a particular server to remember the query text and query results are stored in the cache, next came across this statement, directly from the cache return result; when the update data table, the data table any cached queries become null and void, and will be discarded.

2) Configure the cache parameters:

Variable: query_cache _type, query cache mode of operation. In mode 3, 0: do not cache; 1: Caching queries, except beginning with select sql_no_cache; 2: According to those who need only to select sql_cache at the beginning of the cache query; query_cache_size: Set maximum query result set cache size, than this value large will not be cached.

22, adjust the hardware

1) upload more memory in the machine;

2) increasing faster hard drive to reduce the I / O wait time;

Seek a major factor in determining performance, literally is the slowest moving heads, once head positioning, reading from the track is fast;

3) in a different physical disk devices, the redistribution of disk activity;

If possible, the database should be the busiest store in different physical devices, which use the same physical device with different partition is different, because they will compete for the same physical resources (head).

相关文章
  • MYSQL command Daquan 2010-05-24

    Common MySQL command Daquan First, connect MySQL Format: mysql-h host address-u username-p password 1, Example 1: Connect to the machine on MYSQL. First, open the DOS window, then enter the directory mysqlbin, then type the command mysql-uroot-p, a c

  • MySQL command Daquan Classic Edition (switch) 2010-09-23

    The following article introduces the MySQL command Daquan, including the MySQL database of commonly used commands, modify the MySQL database root password and to grant the actual practical application of the introduction, the following is the descrip

  • mysql command Daquan (rpm) 2011-03-18

    Start: net start mySql; Enter: mysql-u root -p/mysql-h localhost-u root-p databaseName; Listed in the database: show databases; Select a database: use databaseName; List form: show tables; Display table column attributes: show columns from tableName;

  • Daquan classic version of the MySQL command (turn) 2010-09-23

    The following article focuses on the MySQL command Daquan, including the MySQL database commonly used commands, modify the root password for the MySQL database and the actual practical application of the grant's introduction, the following is the des

  • Mysql command line used Daquan 2010-12-02

    The first one, mysql service start and stop net stop mysql net start mysql The second measure, landing mysql Syntax is as follows: mysql-u username-p password Type the command mysql-uroot-p, enter your password after the prompt, enter 12345, then pre

  • Linux SSH command Daquan 2010-05-02

    Linux SSH command Daquan rm-rf mydir / * delete mydir directory * / cd mydir / * mydir directory entry * / cd - / * Top level directory * / cd ~ / * return the root directory * / mv tools tool / * the tools directory renamed the tool * / ln-s tool ba

  • (Transfer) Liunx SSH command Daquan 2010-05-25

    Linux SSH Command Daquan rm -rf mydir /* Remove mydir directory */ cd mydir /* Into the mydir directory */ cd - /* Top-level directory */ cd ~ /* Back to the root directory */ mv tools tool /* The tools directory renamed tool */ ln -s tool bac /* Cre

  • linux svn command Daquan 2010-03-22

    linux svn command Daquan 1, checkout the file to a local directory svn checkout path (path is the directory on the server) For example: svn checkout svn: / / 192.168.1.1/pro/domain Shorthand: svn co 2, to the version of the library to add a new file

  • How to change mysql command prompt information under 2010-04-06

    We often encounter this problem you also for your MySQL command mode, the previous information or tips: MySQL>, then how are we going to change under the mysql command prompt information? So what the current selected database, what the user is curren

  • How to change the mysql command prompt information under 2010-04-06

    We often encounter this problem you also for your MySQL command mode, the previous information or tips: MySQL>, then how are we going to change under the mysql command prompt information? So what the current selected database, what the user is curren

  • MySQL command Collection (change) 2010-04-13

    First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DOS window, then enter the directory mysql \ bin, then type the command mysql-u root-p, a carriage return after the prompt

  • Easy language core support library DLL command Daquan 2010-04-21

    Easy language core support library DLL command Daquan . Version 2 . DLL command _ to take a short integer pointer, an integer type,, "lstrcpyn", public . Parameter objective indicators, short integer, transfer site . Parameter source pointer, a

  • linux find command Daquan 2010-04-24

    linux command to find the text added, I believe very useful for beginners, here are some commonly used linux find command. grep command: grep-i pattern files: not case-sensitive searching. By default, case-sensitive, grep-l pattern files: list only t

  • mysql command Collection 2010-05-07

    Test environment: mysql 5.0.45 [Note: in mysql through mysql> SELECT VERSION (); to see the database version] Order: leo First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DO

  • mysql command under linux 2010-05-24

    mysql command under linux (2010-04-14 18:09:36) reproduced Tags: topics for one, to summarize: 1.linux start the mysql command: mysqladmin start / Ect / init.d / mysql start (in front of the installation path for the mysql) 2.linux next restart mysql

  • The use of SQL * PLUS command Daquan 2010-05-26

    The use of SQL * PLUS command Daquan Oracle's sql * plus to interact with the oracle client tools. In sql * plus, you can run sql * plus command and sql * plus statement. We usually refer to DML, DDL, DCL statement is sql * plus statements, their imp

  • Journey to the mysql command used MySql 2010-05-30

    First, connect MYSQL. Format: mysql-h host address-u username-p password 1, Example 1: Connect to the machine on MYSQL. First, open the DOS window, then enter the directory mysqlbin, then type the command mysql-uroot-p, a carriage return after the pr

  • DOS command Daquan (Classic Collection) 2010-06-07

    net use \ \ ip \ ipc $ "" / user: "" the establishment of air links IPC net use \ \ ip \ ipc $ "password" / user: "User name" non-establishment of air links IPC net use h: \ \ ip \ c $ "password" / user: &

  • android command Daquan 2010-06-10

    android command Daquan Baidu very comprehensive library of documentation: http://wenku.baidu.com/view/202240270722192e4536f633.html With more specific examples in this article Article Transfer from: http://blog.csdn.net/liranke/archive/2009/12/15/501

  • AWARD BIOS settings completely manual (CMOS settings command Daquan. Set Chinese translation) 2010-06-19

    AWARD BIOS settings completely manual (CMOS settings command Daquan, set Chinese translation) Collection AWARD BIOS yes was applied in the present compatible and widely used BIOS, but because the information inside are all in English and requires the