MySQL

This is the first day of the formal learning of PHP, so, want to do here about the environment to build knowledge, combined with the class teacher's notes and their own understanding and problems

8.1 MySQL Function libraryPHP functions. Functions used in PHP to operate the MySQL function libraryCommon functionsMysql_connect ("Host name/IP", "username", "password")---> Build php connection to MySQL, return resources---->Mysql_error () returns

MySQL method from: http://www.cnblogs.com/jjcc/p/5896588.html# # #在网上看到一篇, it's a great wayFor example, to get the top 3 of the class, MySQL can be implemented with Group_concat + GROUP by + substring_index .Test formDROP TABLE IF EXISTS ' test

1. Update the system before installing2. Installing Apache21 sudo apt install apache23. Install PHP1 sudo apt install php2 sudo apt-get install libapache2-mod-php4. Install MySQL1 sudo apt install mysql-server php7.0-mysql2 sudo apt-get install

1, manually register, uninstall, start, stop the MySQL serviceOriginal URL: http://jingyan.baidu.com/article/647f0115b007887f2048a810.htmlManually register the MySQL service.Enter the DOS window and navigate through the directory to enter the

ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:no)ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:yes)Workaround for the above two errors under Windows1. Locate the profile

Review code discovery, colleague MySQL Bulk insert data is implemented by iterating with a for loop, inserting the list each data single time. It is equivalent to inserting n data in bulk, and the database connection and inserting operations are

Installed a bit mysqlmysql 5.7. Version 16First extract the downloaded files into the folder, in my folder as an example: E:\MySQL\mysql-5.7.16-winx64\mysql-5.7.16-winx64First of all, change the INI file in the download piece.# These is commonly set,

It is important to note that a function is used in an SQL statement because it is possible that each statement will be called, even if each record in the table is called.Pay attention to the conversion, will consume a lot of performance, even the

Many recent projects have consulted MySQL for cascading removal issues. Do a systematic literacy here.What is a cascade delete.That is, depending on the foreign key relationship, when you delete the parent table, you delete the child tables that

According to inside's configuration file to organize.[mysql]port            = 3306socket           = /data/mysql/3306/mysql_3306. Sockdefault-character-set=utf8prompt = [\\[email protected]\\h][\\d]>\\_[mysqld]# basic  settings  #user =nobody        

Today the database load goes straight up and the number of database connections explodes. Take a look at the sentence, the culprit is a very simple statement: SELECT * from Eload_promotion_code WHERE 1 and exp_timeFirst look at the index of this

To know the size of each database, proceed as follows:1. Access to the INFORMATION_SCHEMA database (information on other databases)Use INFORMATION_SCHEMA;2, query the size of all data:Select Concat (Round (sum (data_length/1024/1024), 2), ' MB ') as

2 Modifying the character set of a database and tableALTER DATABASE MAILDB default character set utf8;//modify the character set of the databasesALTER TABLE mailtable default character set utf8;//modify the character set of the tablesIf you want to

MySQL startup script#!/bin/bashmysql_port=3308Mysql_username= "Admin"mysql_password= "Password"Function_start_mysql (){printf "Starting mysql...\n"/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/data/dbdata_${mysql_port}/my.cnf 2>&1 >/dev/

1. Three threads: Main Library binlog dump thread, from library I/O thread and SQL thread. 2.creation Process: When replication starts from the library (start Slave), you first createI/Othreads Connect to the main library, and the main library then

Keyboard ESC clear Command \c Cancel commandLogin mysql-ucountname-p enter cmd command invalid in operating system environment variable register MySQLShow all databases show databasesDisplay table use dbname;show tables;Display table structure

Method One: Use the tee in the mysql> promptMysql> Tee output.txtLogging to file ' Output.txt 'Mysql> noteeOutfile disabled.Ormysql> \ Output.txtLogging to file ' Output.txt 'mysql> \ tOutfile disabled.This spool function, similar to Sqlplus, allows

Http://www.jb51.net/article/27616.htm a colleague suggested that the MySQL database connection used for development was slow because our MySQL development database was deployed on a single machine, so it might be caused by a network connection

MySQL technology insider-SQL programming Reading Notes (2)-data types, java programming ideas Reading Notes The selection of data types affects the performance of applications that interact with the database. 1. Generally, if a page can store as