I. Mode
Ii. stored procedures and functions
Syntax:
Create procedure sp_name ([proc_parameter [,...])
[Characteristic...] routine_body
Create function sp_name ([func_parameter [,...])
RETURNS type
[Characteristic...]
A few days ago, I encountered a strange problem in the management system. Today I have the opportunity to install the MySQL environment to reproduce this problem. Because it is not the most primitive environment, it may not be completely reproduced,
These days I want to debug erlang's nif call c cpi, So I downloaded the source code. I mainly want to generate a mysql_nif.dll Link Library.Win:Decompress the source code and run libmysql In the lib directory. dll, libmysql. lib, mysqlclient. the
Working environment Windows Server 2003, MySQL Installation Directory D: Program FilesMySQLMySQL Server 5.0, WinRAR installation directory C: Program FilesWinRARThe path to the backup data storage is E: dataBackupMySQL. The following is the source
Since I started my career, I have found that many technical staff and colleagues have consulted the author or on the Internet about how to write LEFT JOIN and its features, and the equivalent connection is generally normal, I wrote a Microsoft SQL
When installing wordpress on MacBookPro today, the installer always reports an error saying that it cannot connect to the database. The mysql client can be used normally and it can be determined that it is not a server problem. I wrote a php script
The procedure is as follows:1. Create a new project ibatisnew in eclipse, and import the jar packages of mysql and ibatis. These two packages (ibatis-2.3.4.726.jar + mysql-connector-java-5.0.8-bin.jar) can be downloaded from the Internet and copied
You cannot use the column with the RAND () value in an order by clause, because order by will calculate the column multiple times. However, in MySQL3.23, You can do: SELECT * FROM table_name order by rand (), which is helpful for obtaining a random
Recently, I am working on converting ms SQL Server to MySQL. I have summarized some experiences and shared them with you. At the same time, these will be constantly updated. I hope you can add more information.
1. MySQL supports enum, set, and SQL
The backup of MySQL database is one of the most important tasks. The data backup of MySQL database can achieve absolute security of data in MySQL database, and the data in MySQL database will not be lost due to any minor faults, automatic backup is
After learning some basic operation commands, let's learn how to create a database and a database table.
1. Use the SHOW statement to find out the current database on the server: mysql> show databases; + ---------- + | Database | + ---------- + |
1. Connect to the mysql server of the other party
Mysql-u root-h 192.168.0.1
Mysql.exe this program is in the bin directory where you have installed mysql
2. Let's take a look at some databases on the server.
Mysql> show databases;
By default, mysql
1. Prepare the serverNow we plan to establish a MySQL CLuster System with five nodes, so we need five machines for the following purposes:
Node (Purpose) IP address (host name)Management node (MGM) 192.168.0.1 (db1)SQL Node 1 (SQL1) 192.168.0.2 (db2)
Table_cache specifies the table cache size. When MySQL accesses a table, if there is space in the table buffer, the table is opened and put into it, so that the table content can be accessed more quickly. Check the status values Open_tables and
MYSQL has been installed here for a long time. Do you think the program installation is wrong when it crashes? If you are smart, you may find that the actual MYSQL has been installed successfully. It will take a while, but do you know why? Haha tell
1. Copy the table structure and data, but do not copy the index and foreign key:Create table a select * from B;2. Copy the table structure, index, and foreign key without copying data:Create table a like B;3. Copy data only:Insert into a select *
When installing MySQL today, the following error is reported when the./configure command is executed because the package selected by default is not installed in the initial Linux:./Configure -- prefix =/usr/local/mysql -- with-charset = utf8 -- with-
Perform Two-layer development and use mysql for database.Based on your experience and the methods provided by colleagues on the network, you can remove unnecessary files and create a mysql mini version. It is very convenient to use, with a size of 5
Recently, mysql managed by myself experienced slow query. In order to be able to query slow query SQL statements, mysql's slow query log is started, you can use either of the following methods to start a slow query:1. log on to mysql directly and
I found that an SQL statement such as order by rand () is convenient, but the efficiency is too low. So I used the following methods to optimize it, the JOIN table method is used to obtain random data rows. You can use the explain SQL statement to
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