MariaDB Tutorial

Entries

• 2020
• 11/25 insert statement-insert line
• 11/24 update statement-line update
• 10/16 select statement-select row
• 10/15 Output the contents of the table as CSV
• 10/14 Read CSV file data into table
• 10/13 replace function-replaces a string
• 9/17 Get the ID of the last inserted row --last_insert_id function
• 7/27 Check the SQL mode "sql_mode"
• 7/15 MariaDB defaults to 3306
• 7/14 Rename table --rename table statement
• 7/13 Initialization and update of datetime type representing datetime at the current time
• 6/24 Disable SQL mode "STRICT_TRANS_TABLES"
• 6/17 Reset root password
• 6/16 Set root password
• 6/15 Check MariaDB version
• 6/9 Change field definition --alter table change column statement
• 5/23 Create user --create user command
• 5/22 Password settings, database and table access permissions --grant command
• 5/21 Create database --create database command
• 5/20 Delete user
• 5/19 Drop database --drop database statement
• 5/18 Display a list of databases --show databases statement
• 5/17 Display a list of users
• 3/10 use --Select a database
• 3/9 Connect to MariaDB database
• 3/8 Display a list of tables
• 2/18 create table --create table
• 2/7 Create an index
• 2/6 Check foreign key constraints
• 2/5 Remove foreign key constraint
• 2/4 Delete index
• 2/3 Check the index
• 2/2 explain --View SQL execution plan for SQL performance investigation
• 2/1 Check the table capacity and database capacity with MariaDB
• 1/31 Check the type of database engine
• 1/30 Change the database engine