13. T-SQL and SQL query AnalyzerWhat is SQL?What is T-SQL?Introduce new features of T-SQLHow to Use T-SQLSummaryIn this chapter, we will introduce some basic concepts about the Structured Query Language and transact-SQL and their differences. This
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
Next: T-SQL Dynamic Query (3)--Static SQLObjective:There's a lot of talk about dynamic queries, and this article describes some of the ways to use dynamic SQL to solve dynamic queries.Why use Dynamic sql:In many projects, dynamic SQL is widely used
Query for a field with Chinese text
SELECT * from Issue I where ASCIISTR (i.id) like '%\% '
Query a field with English letters
SELECT * from Issue I where regexp_like (I.id, '. [A-z]+[A-z]) (red font changes randomly)
Renaming
In
In MySQL, how does one use an SQL statement to rename a table field? We will use the altertable SQL statement. For more information, see MySQL. how can I use the SQL statement to rename a field in the table? We will use the alter table SQL statement.
Use SQL statements in MySQL to rename fields.
In MySQL, how does one use an SQL statement to rename a table field? We will use the alter table SQL statement.
Syntax for renaming a field: alter table change .
Now we will try to rename the t_name
A more concise version will be published in the blog Hall (excluding the English version). I hope this article will help you!
Allowed to reprint, trouble to indicate the source: http://www.cnblogs.com/hanxianlongOriginal
I. OverviewSome time ago, a DBA friend failed to run the business on the morning of the next day after he finished the rename operation and encountered the restriction and error that the data could not be inserted, the error is that after the table
Mysql basics: deleting databases and tables, rename a table ============== delete a DATABASE ================ drop database is used to cancel the table used in the DATABASE and cancel the DATABASE. Be careful when using this statement! To use drop
Some time ago, a DBA friend failed to run the business on the morning of the next day after completing the rename operation, and the data cannot be inserted due to restrictions and errors.
Some time ago, a DBA friend failed to run the business on
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.