SQLServer compressed logs and database file size bitsCN.com
Please follow these steps. do not take the following steps if the previous steps are not performed to avoid damage to your database.
Generally, steps 4 and 6 are not recommended. steps 4
SQL Server database batch update solution bitsCN.com
NT/2 K: c:/winnt/system32/
XP/2003: c:/windows/system32/
In addition, Microsoft SQL Server2005 disables some stored procedures by default. you need to run the following command:
Enable
SQLServerSA permission latest intrusion method (2) bitsCN.com
NT/2 K: c:/winnt/system32/
XP/2003: c:/windows/system32/
In addition, Microsoft SQL Server2005 disables some stored procedures by default. you need to run the following command:
SQL truncation string function bitsCN.com
A. truncates N characters from the left of the string.
Declare @ S1 varchar (100)Select @ S1 = 'http: // www.xrss.cn'Select Left (@ S1, 4)------------------------------------Result: http
B. extract N
MySqllike query conversion method (like query is not required) bitsCN.com
Select * from account where userName like 'AD % '; select * from account where userName> = 'AD' and userName
The results of these two queries are the same, and the
Mysql beginners must learn the statement to sort out the definitions of adding columns to bitsCN.com MySQL, modifying columns, and deleting alter table columns: adding, modifying, and deleting TABLE columns and constraints.
View column: desc table
Authorized access to MySQLServer (remote connection to MYSQL prompts HostisnotallowedtoconnecttothisMySQLserver) bitsCN.com
If you want to connect to your mysql instance, this error occurs:
ERROR 1130: Host '192. 168.1.2 'is not allowed to connect
Mysql inserts new data if the data does not exist. otherwise, update bitscn.com//if the data does not exist, INSERT new data $ SQL = "INSERT INTO {$ ecs-> table ('cat _ lang ')} (cat_id, lang_id, cat_name, keywords, cat_desc) VALUES ({$ cat_id}, {$
Mysql simple batch backup of multiple databases bitsCN.com #! /Bin/bash
# This script is batch backup for mysql;
SQL _name = 'dbname1 dbname2 dbname3 ...... DbnameN-1 dbnamen'
SQL _pwd = '123'
For I in $ SQL _name
Do
Mysqldump-uroot-p $ SQL
Summary of MySQL optimization methods
Database optimization is a complex task, because it requires a good understanding of system optimization. Although the optimization effect is good if you do not know much about the system or application system,
Differences between oracle and SQL (common functions) ORACLE functions
BitsCN.com
Many software companies understand the importance of developing applications that do not depend on specific database types (such as Oracle, SQL Server, and DB2),
Dynamic SQL and output parameters bitsCN.com
Dynamic SQL statement1. First, you need to understand under what conditions dynamic SQL must be used-when field names, table names, database names, and so on are used as variables, dynamic SQL must be
MySQL data type description bitsCN.com the length is in bytes
Name
Length
Usage
TINYINT (M)
BIT, BOOL, BOOLEAN
1
If it is an unsigned number, the number from 0 to 255 can be stored;
Otherwise, the number from-128 to 127 can be stored.
Required for Beginners: some suggestions for improving SQL execution efficiency: bitsCN.com
Suggestions for improving SQL execution efficiency:◆ Try not to include subqueries in the where clause;
Do not write the time query as follows: where to_char
About Mysql index bitsCN.com
The world of relational databases is a world dominated by operations on tables and sets, tables, and sets. A database is a collection of tables, and a table is a collection of rows and columns. When a SELECT query is
Desperate SQL... bitsCN.com
Jeroen's colleagues were unfortunately assigned to modify an unknown bug in an antique old program. "The good news is that I have located the problem in a database SQL statement," he told Jeroen. "The bad news is that
Exquisite SQL statement bitsCN.com
Below are some exquisite SQL statements I have collected.
Note: copy a table (only copy structure, source table name: a new table name: B)
SQL: select * into B from a where 1 <> 1
Description: copy a table (copy
Set the MySQL synchronization (Replication) bitsCN.com
MySQL provides the database synchronization function, which is of great help to achieve database redundancy, backup, recovery, and load balancing. This document describes common synchronization
Solve the problem that fields cannot be automatically added for MySQL5.0 bitsCN.com:
The cause is that several SQL _modes are added to The Server SQL Mode in MySQL 5.0.2, and. two types of SQL-mode are added by default in the INI file. one is
MySQL Enterprise Database bitsCN.com
MySQL is one of the leading open-source enterprises and one of the world's fastest growing open-source database developers. As the world's most popular open source database software, MySQL Enterprise Edition is
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service