name table

mysql5.5How it works: It's actually the process of outputting data directly from the MySQL repository in a logical SQL statement or generating a backup file.Grammar:BackupMysqldump-u User name-p password database name, table name > Backup

First, user authorization1. Precautions:-MySQL Database server is set up, placed in a separate room or IDC room,mysql database service By default only allows the database administrator root to log on locally, Authorization is required for other

1. Organizational structure of the data Level type Mesh Type Relationship Type2.mysql Package Format Package Manager-specific format:. RPM Package Generic binary package: Unzip play can be used source program: Source Package3.mysql is the C/s

MySQL database backup and recoveryRestore a database: mysql-h localhost-u root-p123456 wwwBacking up a database: mysqldump-h localhost-u root-p123456 www > d:\www2008-2-26.sqlWhere www is the database nameThe following is a test in the

Reprinted from http://blog.csdn.net/cuker919/article/details/8514253Select Segment_name, bytes as sizeFrom User_segmentswhere Segment_type = ' TABLE ' and segment_name in (' view_jlzdh_mp_dl_day_01 ', ' view_jlzdh_mp_dl_day_02 ', ' View_jlzdh_mp_ Dl_

"Backed-up Commands"1) backing Up the databaseMysqldump-uroot-pwsyht-b Library name >/opt/test.sql #加-B for information on adding use DB and CREATE database db2) View the databaseEgrep-v "#|\*|--|^$"/opt/test.sql #查看test. SQL Library Contents3)

' Is the escape character of MySQL and avoids the conflict with MySQL's own keyword, so long as you don't use MySQL's reserved word or Chinese in Column name, table name, you don't need to escape.All databases have similar settings, but MySQL uses '

MySQL base day03_ storage engine and foreign key-mysql 5.6Conditions for foreign keys:1, the table's storage engine is the InnoDB storage engine2, the type of the foreign key field in the table is consistent with the field type of the reference

How can we get an accurate view of the MySQL storage engine, and let me show you two ways to do it right.1) Right way one: SHOW table STATUS from database library name where name= ' table name '2) Mysqlshow-u Database login account-P Sometimes,

SceneWhen we use the database, we often encounter menu options, such as the Personal information table: "Gender": male, female, "education": Junior college, College, undergraduate, master and above; English level: English four, English six,

The difference between a variable's definition and a declarationFirst, the definition of a variable must occur before the variable declaration (extern), the declaration of a variable can have more than one, but the definition of the variable is

The square brackets represent an object name (view, stored procedure, table, etc.), column name;Normal use, add the same, but if the object name is reserved words, such as cascade, it must be added, but it is recommended not to keep the word as the

Export Data | statement/* Export to Excel EXEC Master.. xp_cmdshell ' bcp SettleDB.dbo.shanghu out c:\temp1.xls-c-q-s gnetdata/gnetdata '-u ' sa '-P ' "'/* Import Excel SELECT * From OpenDataSource (' microsoft.jet.oledb.4.0 ', ' Data source= '

1. Log in to the MySQL server[Email protected] ~]# mysql-u root-pEnter Password://Follow the prompts to enter the correct password2. Execute the MySQL action statementExecute "show master Logs" after logging into "mysql>" environment with Root;

1, ddl-additions and deletions to check(1) Select-Get Data (SELECT * from table name WHERE condition)(2) Update-Updates data (Update table name SET (field name = value, field name = value) WHERE condition)(3) Delete-delete data (delete from table

• Trigger (Trigger)"Trigger is essentially a stored procedure, but not an EXE to invoke execution, but to change the operation of the database by adding and deleting""Trigger only for increase, deletion, change effective"Format of the trigger(The

Recently in the use of sqoop1.99.6 to do data extraction, during the encounter a lot of problems, hereby recorded here, convenient for later review and collation1. First configuration, you need to configure the Lib directory of HDFs to

Table connections:The data of multiple tables is queried one at a time, and the common displaySub-query mode:Select Column Name 1, column name 1, (select Column Name 2 from table Name 2 where table name 2. Common Column name = table Name 1.

View DatabaseSHOW DATABASES;Create a databaseCREATE database IF not EXISTS name;Select DatabaseUse database name;View data tables in a databaseSHOW TABLES;Deleting a databaseDROP database name IF EXISTS;Create a simple database tableCREATE table IF

mysql> status; # # #查看数据库基本信息·mysql> show databases; # # # # # #查看数据库列表信息·mysql> use MySQL; # # # #切到mysql This library·Mysql> show Tables; # # # #查看着个库中有哪些表·mysql> use MySQL # # # #切到mysql This library·mysql> describe user; # # #查看着个user表的结构·# # # #