Free Chinese Calendar 2023 - Year of the Rabbit
Want to know when is the 2023 Chinese New Year day? Look for free Chinese calendars for 2023? Chinese New Year Date for Year 2023 The Rabbit 2023 January 22 Sunday Chinese New Year ⇒ Free Chinese Calendar 2024 - Year of the Dragon ⇐ Free Chinese Calendar 2022 - Year of the Tiger ⇑ Chinese New Yea... 2023-01-25, 187743👍, 6💬
MySQL Tutorials - Herong's Tutorial Examples
This MySQL tutorial book is a collection of notes and sample codes written by the author while he was learning MySQL himself, an ideal tutorial guide for beginners. Topics include introduction of Structured Query Language (SQL); installation of MySQL server on Windows, Linux, and macOS; using MySQL ... 2022-11-22, 415👍, 1💬
"Multiple files found for the same tablespace ID" Error
This section provides a tutorial example on the 'Multiple files found for the same tablespace ID' error caused by an outdated database file left from an external MySQL server. 2022-10-01, 806👍, 0💬
MySQL Data Directory Initialization
Tutorial example on how to initialize the MySQL server data directory with the 'mysqld --initialize-insecure' command, which will create a root user without password. 2022-10-01, 297👍, 0💬
--secure-file-priv="" - MySQL Server Option
This section provides a tutorial example on how to change the '--secure-file-priv' MySQL Server option, to control directory permissions for dumping all tables in a database as tab delimited files. 2022-10-01, 271👍, 0💬
"SELECT COUNT(*)" on InnoDB Table
This section provides a tutorial example showing why 'SELECT COUNT(*)' is slow on InnoDB tables. It does a full table scan by reading all data pages to count the number of rows. 2022-10-01, 213👍, 0💬
Impact of InnoDB Log Buffer on INSERT
This section provides a tutorial example to demonstrate the performance impact of InnoDB Log Buffer. Setting innodb_flush_log_at_trx_commit =0can reduce execution time reduction on INSERT and other data change statements from 35 ms to 1 ms. 2022-10-01, 212👍, 0💬
MySQL Authentication Method "caching_sha2_password"
A tutorial example is provided on how to create a new user account with 'mysql_native_password' authentication method to avoid the 'caching_sha2_password' error with mysqli_connect() method. 2022-10-01, 166👍, 0💬
Using "mysql" Command to Run SQL Statements
This section provides some tutorial examples on how to run SQL statements on a MySQL server with the client tool mysql. SQL statements can be executed one by one interactively, or in batch mode. 2022-10-01, 165👍, 0💬
Using DDL to Create Tables and Indexes
This chapter provides tutorial notes on DDL (Data Definition Language) statements. Topics include CREATE TABLE, CREATE INDEX, and ALTER TABLE statements; selecting column options when creating tables. 2022-10-01, 165👍, 0💬
PHP mysqli_connect() Error on "localhost" on macOS
This section provides a tutorial on the PHP mysqli_connect() 'No such file or directory' error, and the workaround of replacing 'localhost' with '127.0.0.1'. 2022-10-01, 155👍, 0💬
Transaction Management and Isolation Levels
This chapter provides tutorial notes on transactions. Topics include introduction of transactions, transaction management in MySQL, transaction isolation levels: Read Uncommitted, Read Committed, Repeatable Read, Serializable. 2022-10-01, 154👍, 0💬
MySQL Command Line Client Tool
A tutorial example on how to use the MySQL Command Line Client Tool to connect to MySQL Server. The example also includes SQL commands to create a new test database/table and insert some data to the table. 2022-10-01, 141👍, 0💬
Spatial Data Functions
Describes some commonly used Spatial Data functions like, ST_GeomFromText(), ST_AsText(), ST_GeometryType(), POINT(), ST_X(), ST_Y(), ST_NumPoints(), ST_PointN(), ST_Area(), etc. 2022-10-01, 141👍, 0💬
This section provides a tutorial example on how to install OpenSSL on a Windows system.
This section describes what is WADL (Web Application Description Language), an XML-based file format...
Want to know when is the 2039 Chinese New Year day? Look for free Chinese calendars for 2039? Chines...
Where to find lucky wedding dates for year 2027? Lucky Wedding Dates: 2027 - Year of the Goat ⇒ Lu...
什么是病毒载体疫苗？ 它的工作机制是什么？ 病毒载体疫苗又可以细分成两个小类：复制型病毒载体 疫苗（ReplicatingViral Vect...