how to name set

1. Delete a tabledrop table + table name2. Modify the tableAlter table+ table name + Add (add) + column name + int (type)Alter table+ table name + drop (delete) +column (column) + column name3. Deleting a databaseDrop Datebase + library NameCRUD

Using the SQL Sever language for database operationsCommon keywordsIdentity self-growthPrimary KEY Primary KeyUnique Uniqueness KeyNot NULL non-nullReferences foreign key (reference)When using the query operations database, you need to set up a

MySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/bin (Mysqladmin mysqldump and other commands)Startup scripts/etc/init.d/mysql (startup

----------------------------------------------------------------Database artboards:When a table defines a primary key or a unique index, you can modify, add, and delete data in the results window.Using SQL statements to create a data table is the

1. Use database_name;2. Set names UTF8; (or other required encoding)3. Source example.sql (SQL file storage path)MySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration

1. Create a table: Primary Key ID User name Gender Weight (kg) Birthday Wages Last Login time Personal profile --Terminology: The

The database operation is divided into three parts, namely, DDL (database, table operation) DML (data Delete and change) DQL (check)"DDL" CREATE | ALTER | DROPDatabase"CREATE DATABASE"CREATE datebase database name DEFAULT charracter SET UTF8 COLLATE

One, MySQL command line argumentsUsage:mysql [OPTIONS] [Database]//Command mode-?,--help//Display assistance information and exit-I,--HELP//Display Help information and exit--auto-rehash//Auto-complete function, like Linux inside, press the TAB key

----------------------------------------------------------------Database artboards:A table that defines a primary key or a unique index enables you to change, add, and delete data in the results window.Using SQL statements to create a data table is

--View Databaseshow databases;--Create a databaseCreate database ' name ';--Delete Databasedrop database name ';--Select LibraryUse ' Library name ';--View your current librarySelect Database ();--View All tablesShow tables;--Delete Tabledrop table

Personal summary of MySQL base statements (including views, functions, clauses, etc.)A lot of beginners may be the same as me when I first touch the SQL statement to practice but always forget the statement format, in order to solve this annoying

A combination of queries from its surface meaning we know that by a condition or multiple criteria to query, we first look at the interface of the combination query: Code: U-Layer: Private Sub btnCheck_Click (ByVal sender as System.Object, ByVal

MySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/bin (Mysqladmin mysqldump and other commands)Startup scripts/etc/init.d/mysql (startup

MysqlTo modify a new password:Use MySQL;Update user set password= ' new password ' where user= ' username ';Flush privileges; Update permissionsAdd new users:Grant SELECT, Insert,update,delete on database. Table to username @ Login Host identified

by @ Eat Watermelon Star remind First we introduce the next selenium Selenium is also a tool for Web application testing. The selenium test runs directly in the browser, just as the real user is doing. Supported browsers include IE, Mozilla Firefox,

Data manipulationAdd data,insert intoStandard formatInsert into table name (List of fields) value (data list);Using SetInsert into table name set field 1= value, 2 ...;Inserting data from other data tablesInsert into Table name (field list)

MySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/bin (Mysqladmin mysqldump and other commands)Startup scripts/etc/init.d/mysql (startup

Reprint: http://www.cnblogs.com/linjiqin/archive/2013/03/01/2939384.htmlMySQL installation directory (Ubuntu system)Database directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/

LogThe role of the log:1. Solving the system problems2. Troubleshooting Network Services3. Record Past Events/var/log///log File save locationCron//Record recurring task scheduleDMESG//boot core detection informationLastlog//System all the last

Article excerpt from: http://www.cnblogs.com/linjiqin/archive/2013/03/01/2939384.html thanks bo friends to share O (∩_∩) o~MySQL Common commandsMySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql