1. Add a new column to the existing table in the database Statement:altertable name add column name type Example:alter MyUser ADD Userdesc VARCHAR(+);2. Name the rename in the existing tables in the database Statement:altertablecolumn
Five ways to change MySQL database name:
The code is as follows
Copy Code
1. RENAME DATABASE db_name to New_db_name
This one.. This syntax is added to the MySQL 5.1.7, 5.1.23 and removed.It is said that it is
Rename table syntaxRename table Tbl_name to New_tbl_name [, tbl_name2 to New_tbl_name2] ... Use this statement to rename one or more tables.
The rename operation occurs automatically, which means that other threads cannot read any tables while
New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp
1. Database Name 1.1 The Concept Database Name (db_name) is the identifier of a database, just like the ID card number of a person. If multiple databases are installed on a machine, each database has a database name. After the database is installed
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The general practice is ldquo; trilogy: rdqu
Oracle Data is constantly changing during project
Five methods to change the mysql database name: 1. RENAMEDATABASEdb_nameTOnew_db_name .. This syntax is added in mysql5.1.7 and removed in 5.1.23. Data may be lost. Or don't use it. See: dev.mysql.comdocrefman5.1enrename-database.html 2
Five methods
This article mainly introduces Python under the powerful renaming method of the OS module renames detailed information, the need for friends can refer to under the Python OS module powerful renaming method renames detailed in Python there are many
Sunday in order to save the main Library users table space temporarily expanded 20G tablespace, resulting in the DG Library's/bak/datafile/directory is insufficient. The log application to the extended-space archive crashes, and, more tragically,
How to rename a MySQL database
[Preface] One of the databases needs to be backed up for business needs, and then imported into a brand new database; it is the fastest and easiest way to directly modify the name of the current database for backup.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.