Android ASP Astrology Big5 Bitcoin Blowfish Built-in C# Calendar CD-DVD Cheminformatics Chinese Cryptography DES Email Encoding Ethereum Flash GB2312 General H Herong History HTML Java JavaScript JDBC JSP JVM Linux Molecule Movie Music MySQL Neural Network Perl PHP Physics PKI Publication Python REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO

<< < 1 2 3 4 5 6 7 8 > >>   ∑:175  Sort:Rank

ORDER BY Clause of a SELECT Statement
This section provides tutorial examples on how to use the ORDER BY clause to sort rows of the base table according to the given order. 2022-10-01, ∼349🔥, 0💬

Numeric Literal Evaluation Examples
This section provides tutorial examples on how numeric literals are evaluated to values of different datatypes. 2022-10-01, ∼348🔥, 0💬

References
This section provides a list of reference materials used in this book. 2022-10-01, ∼347🔥, 0💬

Introduction of Datatype
This section provides quick introductions of datatypes supported by SQL: Character String, Bit String, Exact Number, Approximate Number, Date and Time. 2022-10-01, ∼346🔥, 0💬

SQL and Database Terminologies
This section provides brief descriptions of terminologies related to SQl and database. 2022-10-01, ∼345🔥, 0💬

PHP Programs and MySQL Server
This chapter provides notes and tutorial examples on MySQL server and PHP programs. Topics include configuring the PHP engine to use the MySQL extension library, commonly used MySQL functions, running SQL statements to create table, insert rows and fetch rows. 2022-10-01, ∼344🔥, 0💬

Examples of Different Types of Operation
This section provides tutorial examples of different types of operations: numeric, predicate, date and time. 2022-10-01, ∼343🔥, 0💬

What Is a Stored Procedures
Describes what is a stored procedure - is an executable program that is stored in the database server. 2022-10-01, ∼343🔥, 0💬

Getting Driver and Server Information
Describes how to get JDBC driver and database information through the DatabaseMetaData object. 2022-10-01, ∼342🔥, 0💬

Column Options When Creating Tables
A tutorial example is provided on how to use different column options like, NULL, UNIQUE, DEFAULT, PRIMARY KEY, when creating new tables. 2022-10-01, ∼340🔥, 0💬

Table Column Types for JSON Documents
Describes 1 type of table column to store JSON documents: JSON. 2022-10-01, ∼340🔥, 0💬

Flow Control Functions
Describes 4 types of flow control functions: CASE ... WHEN, CASE WHEN, IF and IFNULL. 2022-10-01, ∼339🔥, 0💬

Installing MySQL Server on Linux
This chapter provides introductions and tutorial examples about MySQL database server on CentOS systems. Topics include installing MySQL 8.0 on CentOS 8; starting and stoping 'mysqld' as a system service; setting MySQL 'root' password; MySQL file and data locations; MySQL log files; backing up MySQL... 2022-10-01, ∼339🔥, 0💬

Delete Records That Are Not Referenced
This section provides a tutorial example on bulk deletion for records that are not referenced by another table. 2022-10-01, ∼337🔥, 0💬

Operations and Functions for Character Strings
Describes operations and functions for character strings, sequences of characters from predefined character sets. 2022-10-01, ∼336🔥, 0💬

JSON Document Functions
Describes some commonly used JSON Document functions like, JSON_VALID(), JSON_TYPE(), JSON_ARRAY(), JSON_OBJECT(), JSON_EXTRACT(), JSON_REMOVE(), JSON_REPLACE(), JSON_SET(), and JSON_INSERT(). 2022-10-01, ∼336🔥, 0💬

What Are Storage Engines
This section describes MySQL storage engines, which implement different strategies on how data is stored, updated and retrieved in storage devices. 2022-10-01, ∼336🔥, 0💬

Statistic Information on InnoDB Tables
This section provides a tutorial example on how to collect and review statistic information on InnoDB tables in MySQL server. 2022-10-01, ∼335🔥, 0💬

mysql - The Client Tool for End Users
This section provides a quick introduction of mysql, the client tool for end users to manage their data on MySQL servers. You can run mysql on a remote system to create new databases and new tables, to insert, update or delete data from tables. 2022-10-01, ∼330🔥, 0💬

Performance of Inserting Integers to MySQL Database
This section provides a tutorial example on how to test the performance of inserting integers into MySQL server database using PHP 'mysqli' functions. MySQL server is 100 times slower on my CentOS computer and macOS computer. 2022-10-01, ∼330🔥, 0💬

Introduction of MySQL Programs
Notes and tutorial examples are provided on MySQL 8.0 programs. Topics include a list of MySQL 8.0 major programs; introduction of mysqld, mysqladmin, mysql, mysqldump, and mysqlimport programs. 2022-10-01, ∼329🔥, 0💬

"SHOW STATUS ..." - Server Status Variables
This section describes Server Status Variables, which are counters used by MySQL server to provide statistics information about its running status. 2022-10-01, ∼329🔥, 0💬

Bulk Delete with a Simple Condition
This section provides a tutorial example on bulk deletion with a simple condition on a large table. 2022-10-01, ∼328🔥, 0💬

Table Column Types for Character Strings
Describes 4 types of table columns to store character strings: CHAR, VARCHAR, NCHAR and NCHAR VARYING. 2022-10-01, ∼327🔥, 0💬

<< < 1 2 3 4 5 6 7 8 > >>   ∑:175  Sort:Rank

Android ASP Astrology Big5 Bitcoin Blowfish Built-in C# Calendar CD-DVD Cheminformatics Chinese Cryptography DES Email Encoding Ethereum Flash GB2312 General H Herong History HTML Java JavaScript JDBC JSP JVM Linux Molecule Movie Music MySQL Neural Network Perl PHP Physics PKI Publication Python REST SOAP Sorting Swing TV Series UML Unicode VBScript Web Web-Services Windows WSDL XML XMLPad XSD XSL-FO