Links: MySQL

Root Reference Development Database related MySQL

Sub Categories:

Links:

12.3. String Functions

# SUBSTRING(str,pos) , SUBSTRING(str FROM pos) , SUBSTRING(str,pos,len) , SUBSTRING(str FROM pos FOR len) The forms without a len argument return a substring from string str starting at position pos. The forms with a len argument return a substring len characters long from string str, starting at position pos. The forms that use FROM are standard SQL syntax. mysql> SELECT SUBSTRING('Quadratically',5); -> 'ratically' mysql> SELECT SUBSTRING('foobarbar' FROM 4); -> 'barbar' mysql> SELECT SUBSTRING('Quadratically',5,6); -> 'ratica' This function is multi-byte safe.  

Clicked: 35 Added: 2005-02-10 13:13:05 - Bad URL? Report it

14.1.5 LOAD DATA INFILE Syntax

The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. For more information about the efficiency of INSERT versus LOAD DATA INFILE and speeding up LOAD DATA INFILE, section 7.2.12 Speed of INSERT Queries. 

Clicked: 126 Added: 2004-05-31 12:27:14 - Bad URL? Report it

Adding and removing users - 14.5.1.2 GRANT and REVOKE Syntax

The GRANT and REVOKE statements allow system administrators to create MySQL user accounts and to grant rights to and revoke them from accounts. GRANT and REVOKE are implemented in MySQL 3.22.11 or later. For earlier MySQL versions, these statements do nothing. 

Clicked: 135 Added: 2004-05-31 02:08:47 - Bad URL? Report it

Case studies

Clicked: 111 Added: 2004-05-31 02:10:04 - Bad URL? Report it

Chapter 5. Database Administration

Table of Contents 5.1. The MySQL Server and Server Startup Scripts 5.1.1. Overview of the Server-Side Scripts and Utilities 5.1.2. The mysqld-max Extended MySQL Server 5.1.3. The mysqld_safe Server Startup Script 5.1.4. The mysql.server Server Startup Script 5.1.5. The mysqld_multi Program for Managing Multiple MySQL Servers 5.2. The MySQL Instance Manager 5.2.1. Starting the MySQL Server with MySQL Instance Manager 5.2.2. Connecting to the MySQL Instance Manager and Creating User Accounts 5.2.3. MySQL Instance Manager Command-Line Options 5.2.4. MySQL Instance Manager Configuration Files 5.2.5. Commands Recognized by the MySQL Instance Manager 5.3. Configuring the MySQL Server 5.3.1. mysqld Command-Line Options 5.3.2. The Server SQL Mode 5.3.3. Server System Variables 5.3.4. Server Status Variables 5.4. The MySQL Server Shutdown Process 5.5. General Security Issues 5.5.1. General Security Guidelines 5.5.2. Making MySQL Secure Against Attackers 5.5.3. Startup Options for mysqld Concerning Security 5.5.4. Security Issues with LOAD DATA LOCAL 5.6. The MySQL Access Privilege System 5.6.1. What the Privilege System Does 5.6.2. How the Privilege System Works 5.6.3. Privileges Provided by MySQL 5.6.4. Connecting to the MySQL Server 5.6.5. Access Control, Stage 1: Connection Verification 5.6.6. Access Control, Stage 2: Request Verification 5.6.7. When Privilege Changes Take Effect 5.6.8. Causes of Access denied Errors 5.6.9. Password Hashing in MySQL 4.1 5.7. MySQL User Account Management 5.7.1. MySQL Usernames and Passwords 5.7.2. Adding New User Accounts to MySQL 5.7.3. Removing User Accounts from MySQL 5.7.4. Limiting Account Resources 5.7.5. Assigning Account Passwords 5.7.6. Keeping Your Password Secure 5.7.7. Using Secure Connections 5.8. Disaster Prevention and Recovery 5.8.1. Database Backups 5.8.2. Example Backup and Recovery Strategy 5.8.3. Table Maintenance and Crash Recovery 5.8.4. Setting Up a Table Maintenance Schedule 5.8.5. Getting Information About a Table 5.9. MySQL Localization and International Usage 5.9.1. The Character Set Used for Data and Sorting 5.9.2. Setting the Error Message Language 5.9.3. Adding a New Character Set 5.9.4. The Character Definition Arrays 5.9.5. String Collating Support 5.9.6. Multi-Byte Character Support 5.9.7. Problems With Character Sets 5.9.8. MySQL Server Time Zone Support 5.10. The MySQL Log Files 5.10.1. The Error Log 5.10.2. The General Query Log 5.10.3. The Update Log 5.10.4. The Binary Log 5.10.5. The Slow Query Log 5.10.6. Log File Maintenance 5.11. Running Multiple MySQL Servers on the Same Machine 5.11.1. Running Multiple Servers on Windows 5.11.2. Running Multiple Servers on Unix 5.11.3. Using Client Programs in a Multiple-Server Environment 5.12. The MySQL Query Cache 5.12.1. How the Query Cache Operates 5.12.2. Query Cache SELECT Options 5.12.3. Query Cache Configuration 5.12.4. Query Cache Status and Maintenance This chapter covers topics that deal with administering a MySQL installation, such as configuring the server, managing user accounts, and performing backups.  

Clicked: 14 Added: 2005-05-10 12:18:31 - Bad URL? Report it

MySQL

MySQL has become the most popular open source database and the fastest growing database in the industry. This is based on its dedication to providing a less complicated solution suitable for widespread application deployment at a greatly reduced TCO. 

Clicked: 205 Added: 2002-12-29 15:38:43 - Bad URL? Report it

MySQL -> Resetting the root password

How to reset the root password for MySQL 

Clicked: 174 Added: 2003-12-17 14:02:05 - Bad URL? Report it

1| 2| Next >>
Total number of links: 602 in 81 (sub)categories - Suggest a link