MySQL
- Getting started with MySQL
- ALTER TABLE
- Arithmetic
- Backticks
- Backup using mysqldump
- Change Password
- Character Sets and Collations
- Clustering
- Comment Mysql
- Configuration and tuning
- Connecting with UTF-8 Using Various Programming language.
- Converting from MyISAM to InnoDB
- Create New User
- Creating databases
- Customize PS1
- Data Types
- Date and Time Operations
- Dealing with sparse or missing data
- DELETE
- Drop Table
- Dynamic Un-Pivot Table using Prepared Statement
- ENUM
- Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...
- Error codes
- Events
- Extract values from JSON type
- Full-Text search
- Group By
- Handling Time Zones
- Indexes and Keys
- INSERT
- Install Mysql container with Docker-Compose
- Joins
- JOINS: Join 3 table with the same name of id.
- JSON
- Limit and Offset
- LOAD DATA INFILE
- Log files
- Many-to-many Mapping table
- MyISAM Engine
- MySQL Admin
- MySQL client
- MySQL LOCK TABLE
- Mysql Performance Tips
- MySQL Unions
- mysqlimport
- NULL
- One to Many
- ORDER BY
- Partitioning
- Performance Tuning
- Pivot queries
- PREPARE Statements
- Recover and reset the default root password for MySQL 5.7+
- Recover from lost root password
- Regular Expressions
- Replication
- Reserved Words
- Security via GRANTs
- SELECT
- Server Information
- SSL Connection Setup
- Stored routines (procedures and functions)
- String operations
- Table Creation
- Temporary Tables
- Time with subsecond precision
- Transaction
- TRIGGERS
- UNION
- UPDATE
- Using Variables
- VIEW
MySQL Customize PS1
Customize the MySQL PS1 with current database
In the .bashrc or .bash_profile, adding:
export MYSQL_PS1="\[email protected]\h [\d]>"
make the MySQL client PROMPT show current [email protected] [database].
Custom PS1 via MySQL configuration file
In mysqld.cnf or equivalent:
[mysql]
prompt = '\[email protected]\h [\d]> '
This achieves a similar effect, without having to deal with .bashrc's.
