Unlimited classification of mysql stored procedures
Drop table if exists 'pcms _ channel ';
Create table if not exists 'pcms _ channel '(
'Cid' tinyint (3) unsigned not null auto_increment,
'Name' char (10) not null comment' channel name
Many of my friends may just install mysql directly and have almost no security knowledge, because I don't think mysql requires security configuration as php does, in fact, you have a great risk for your database. I will introduce some security
Mysql database is a very important point in our WEB development and website. We can say that we need to back up the database in real time or one backup every day, but if we back up the database manually every day, this may be forgotten, next I will
MySQL allows statements to be scheduled, which makes queries from several clients more cooperative, so that a single client will not be locked for too long. Changing the scheduling feature also ensures that specific queries are processed faster. Let'
1. Download the MySQL Installation File
The following two files are required to install MySQL:
MySQL-server-5.0.26-0.i386.rpm
MySQL-client-5.0.26-0.i386.rpm
For the "Unzip Hat Enterprise Linux 3 RPM (x86) downloads" item, find the "Server" and
Does MySQL 5.1 storage programs and functions work for replication?
Yes, the standard behavior executed in the storage program and function is copied from the master MySQL server to the slave server.
Can the stored programs and functions created on
During this time, I read about how to restore data through Logs and time points in SQL server. I also read some online examples to see how to restore data through logs.
Prerequisites:
Change the database fault recovery mode to non-simple mode.
Configuring a large memory for the database can effectively improve the database performance. Because the database is running, a region is allocated in the memory as the data cache. Generally, when a user accesses a database, the data is first read
SELECT @ SERVERNAME, SERVERPROPERTY ('servername ')-- Default instance
USE masterGO
-- Set two variablesDECLARE @ serverproperty_servername varchar (100), @ servername varchar (100)
-- Obtain information about the Windows NT Server and the
Recently, we have studied the implementation of MYSQL random extraction. For example, to randomly extract a record FROM the tablename table, the general syntax is: SELECT * FROM tablename order by rand () LIMIT 1.However, I checked the MYSQL
Implement random. Find the following statement from the manual to complete the task:
SELECT * FROM table_name order by rand () LIMIT 5;
Rand says this in the manual ::
RAND ()
RAND (N)
Returns a random floating point value ranging from 0 to 1.0. If
I. Data Backup shortcuts
Because this method has not been verified in the official documentation, we call it a test.
Objective: To back up a MySQL database in the hostA host and restore it to the hostB
Test environment:
Operating System: WinNT4.0,
I. Optimizing mysql during compilation
If you distribute and install mysql from the source code, note that the compilation process will have an important impact on the future target program. Different compilation methods may obtain similar target
Several Methods to crack the mysql root Password:Method 1Use phpmyadmin, which is the simplest. Modify the user table of the mysql database, but do not forget to use the PASSWORD function.Method 2Use mysqladmin, which is a special case stated
Recently, a large number of servers frequently experience MYSQL disconnection and refresh failures.
This problem occurs on windows hosts, and the solution found based on common official errors is invalid.
Symptom: Can't connect to MySQL server on '
Max_user_connections has been mentioned in the mysql manual. It is used to restrict user resources. How can we limit user resources? A small test is conducted here.First, check the value of the global variable.Mysql> select @ max_user_connections;+ -
Method 1: Use the SQL Server proxy (Alert + Job)The procedure is as follows:1. First, use the following command to enable the trace flag.SQL codeDbcc traceon (3605, 1204, 1222,-1)Note:3605 output the result of DBCC to the error log.1204 return the
Tool Selection I. Sqlyog is a powerful tool, but in the face of a 5G database, it can only strike, simply put, the local import can be, from the local import server can not.II. Phpadmin comes with this, but it's okay, but it's never used in the end,
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