My php4 and MySQL packages are php-4.0.1pl2-win32.zip, Mysql-3.23.19-beta-win.zip. Install MySQL first, use winzip8.0 to open the package for full installation, the default installation path is: C:mysql;When the installation is complete, open "run"
1. Installation EnvironmentOperating system: Red Hat Linux Enterprise as 4.0Database: MySQL 5.0.24Web server: Apache 2.2.3Scripting language: PHP 5.1.6
2. Install MySQL 5.0.24-------------Download package mysql-5.0.24.tar.gz, address
Sometimes we do things that may speed and safety in the early stage is not the focus of our consideration, the flexibility of data may be more important for an immature system, here I use Thinkphp+mysql+jqgrid to make a simple custom data model. A
Using the old version of the MySQL client navicate 8, the MySQL server with the mysql5.6 version, in the revision of the engine version of the version is not correct;
MySQL error ' Type=myisam '
Solution:
Replace
Type=myisam
With
Engine=myisam
The statement is simple
The code is as follows
Copy Code
$connection =mysql_connect ("localhost", "root", "password"); Connect and select a database servermysql_select_db ("Test", $connection);$query = "SELECT * from
MySQL has the following several logs:Error log: Log-errQuery log: LogSlow query log: log-slow-queriesUpdate log: Log-updateBinary log: Log-bin
[Client]Port = 3306Socket
After installation Lnmpa slowly focus on optimization, the first is to delete the MySQL log, delete mysql-bin.0000* similar files look irritable.View Source code Printing HelpLogin
The code is as follows
Copy Code
Here's a few simple Query examples to show DISTINCT implementations.
1. First look at the DISTINCT through a loose index scan:
The code is as follows
Copy Code
sky@localhost: Example 11:03:41> EXPLAIN SELECT DISTINCT
1. Calculating age
If you have a person's birthday and need to calculate the age of this person, replace the @dateofbirth in the following statement with a birthday
The code is as follows
Copy Code
SELECT Date_format
In MySQL, there are several statements in the following control process:1) Case
The code is as follows
Copy Code
Below'll return zeroSELECT case 0 if 0 THEN ' zero ' when 1 THEN ' one ' ELSE ' no one ' end;Below'll
MySQL uses multiple statements in the exception handling section of a stored procedure--Create a test table without any datadrop table if exists t;CREATE TABLE t (id int);--Create a stored proceduredrop procedure if exists test;Delimiter |CREATE
Configuration Instructions
Linux version: Centos7
MySQL version: MySQL5.7.16
This document is available for MySQL version >=5.7.6
First, uninstall CentOS7 the default carrying MARIADB package
# Check MARIADB installation Pack
[root@wing ~
COUNT (*) and COUNT (COL)Online search, found that all kinds of statements are:For example, think of Count (COL) faster than COUNT (*);Think Count (*) is faster than count (COL);And a friend is very funny to say this is actually looking at the
Recently, in order to be developed for the company of an information management system from the previous trial run development machine (Windows NT + IIS4.0 + Access) migrated to a real Linux server (Apache1.3.12 + PHP 4.03 + MySQL 3.23.26 , where
Start/Stop MySQL
how to start MySQL : (in this article, install MySQL in/usr/local/mysql for example)
The code is as follows
Copy Code
#/usr/local/mysql/share/mysql.server Start
If the installation directory
1 Viewing the structure of a table(1) Show create TABLE + database name(2) desc+ database name2 Modifying a table(1) Add a column to the tableALTER TABLE database name add column addr varchar (20)//Add Address column(2) Modifying a table column
Configure hibernate2.1.2 to connect to mysql in resin3.0Configure hibernate2.1.2 to connect to mysql in resin3.0Author: hamalConventions:Resin3 indicates the installation root directory of resin3.0Hibernate2 indicates the installation root
Many of my friends have installedMysqlBut I don't know how to use it. In this article, we will learn some common MYSQL commands from the aspects of connecting to MYSQL, changing the password, and adding users.1. Connect to MYSQL.Format: mysql-h host
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