how to use database

In the development process will often use MySQL Export import Chinese table, this article will detail how to use it, need friends can refer to the next First, for UTF8 export: (1) Export all tables of the source database: Copy Code code as

1. Modify User Passwordmysqladmin-uroot-p123456 Password 123 (description: 123456 is the old password, 123 is the new password) 2. Display the database (after logging into the database) show databases;3. Use database using database name 4.select

1 databases: Warehouses for managing and storing data2 Advantages of the database:① can store a large amount of data ② easy to retrieve ③ maintain data consistency, integrity ④ security, can be shared ⑤ through combinatorial analysis, can generate

"declaration"Welcome reprint, but please keep the original source of the article →_→Life One number: http://www.cnblogs.com/smyhvae/Article Source: http://www.cnblogs.com/smyhvae/p/4028178.htmlBodyMain content: One, the cmd command line

One, SQL file Import Database1.mysql-u User name-p password2.use database name; If not, build one first.3.source d:\ file name. sql; The file path.4.repair table name, table name, ...; The table can be repaired to prevent errors in the table.5.check

Today I mainly learned the basic knowledge of MySQL.First, the introduction of the database　1. Classification of databases　　　To learn the database we first need to understand what is a database, the database is similar to a warehouse, can store a

A.MongoDB features, features, usage scenariosMongoDB Installation and ConfigurationMongoDB ArchitectureDatabase start, stop, connectJson/bson data formatMongodb1. FeaturesData is in memory, written to disk through a background threadNon-modal

Reprint AddressHttp://www.linuxidc.com/Linux/2015-08/121676.htmIn the MySQL database, when the inserted data cannot support Chinese, the encoding set of the database can be set to UTF8, so the database encoding set and other character encodings are

Delete database all tables and all stored procedure SQL statements at onceTransferring database data today requires emptying the database's original tables and stored procedures.To delete all tables:If table failure is deleted because of a foreign

Preface: The following is the most basic database of the most commonly used commands, especially for beginners to practice, I hope that through the practice of these commands to skillfully operate and consolidate the foundation, because only

Description : The following words may have multiple meanings , This document is intended to be interpreted only for programming . words are not much, practice makes perfect, read and write every day, the effect is good. If there are errors , Please

* from Step1 where Xingbie = ' female '; for example, query all girls, and age~* from step1 where Xingbie = ' women ' and nianling = and Xianzaisuozaidi = ' Beijing '; the third reason: the database can not play itself, to the PHP,. NET, JSP and

CREATE Database Link Test_dblinkCONNECT to SJZX identified by SJZXUSING ' (DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.176.150.201) (PORT = 1521)))(Connect_data =(service_name = ORCL)))‘;Database Link OverviewDatabase link is

First step: Start the database service1.cmd into the bin directory of MongoDB2. Enter: Mongod--dbpath "D:\ylkfSoft\mongoData\data\db" starts the database (the path behind--dbpath is the location of the database data that you randomly create after

Create a database1 Creating an Oracle database using the Database Configuration Assistant toolStep One Action windowThere are 4 choices. A CREATE Database B metabase option C Delete database D Administrative TemplatesStep Two Database Template

Char 0~255Varchar 0~65535Text 0~65535 (only characters are saved)Longtext 0~4294967295 (only characters are saved)CMD login MySQLMysql-u root-pMysql-p 3306-uroot-p123456 (-p must be uppercase to indicate port)1, database operation databasesCreate a

Creation of tables:1. Create column (field): Column name + type2. Set Primary key columns: uniquely identifies a single piece of data3. set Unique: content cannot be duplicated4. foreign key relationship:A table (from a table) in which a column

MySQL Common commands1: Use the show statement to find out what database currently exists on the server:Mysql> SHOW DATABASES;2:2. Create a database Mysqldatamysql> CREATE DATABASE Mysqldata;3: Select the database you createdmysql> use Mysqldata;

Import Database:1 Mysql>use ygeshop;Ygeshop for Database name2 Mysql>source the imported file name;As I entered the command line: Mysql>source ygeshop.sql;1. Display the list of databases.show databases;The default is two databases: MySQL and test.

PHP MySQL Database Classification of databases:Hierarchical database: Text structure similar to XML (HTML)Mesh Database:Relational database:Mainstream database:650) this.width=650; "src="