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:Date

MySQL Introduction and Installation
Tutorial examples and notes are provided on MySQL installation on Windows systems. Topics include main features of MySQL; downloading and installing MySQL; starting and stopping MySQL server; introduction of command line client tool, shell, workbench. 2022-10-01, ∼544🔥, 0💬

What Is MySQL Workbench
Quick introduction of MySQL Workbench and ways to start it and access the local MySQL server. 2022-10-01, ∼537🔥, 0💬

CREATE TABLE - Statement to Create Tables
A tutorial example is provided on how to use CREATE TABLE statements to create tables in different ways. 2022-10-01, ∼526🔥, 0💬

What Is MySQL
Quick introduction of MySQL with a list of main features. 2022-10-01, ∼525🔥, 0💬

MySQL Program Option Files
This section provides a tutorial example on how find the default option files for MySQL programs. The default option file for MySQL programs is /etc/my.cnf for Linux and macOS computers 2022-10-01, ∼520🔥, 0💬

Datatypes and Data Literals
This chapter provides tutorial notes on datatypes. Topics include introduction of 5 datatypes supported in SQL-92 and MySQL; binary representations of each datatype; data literals; literal evaluations. 2022-10-01, ∼519🔥, 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, ∼518🔥, 0💬

Java Programs and MySQL Servers
This chapter provides tutorial notes on MySQL JDBC driver. Topics include installing MySQL JDBC driver; connection URL and DriverManager class; DataSource and Connection objects; server and driver information; creating tables with auto-increment columns. 2022-10-01, ∼514🔥, 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, ∼511🔥, 0💬

Manage MySQL Server 'mysqld' on CentOS
This section provides a tutorial example on how to start and stop MySQL server program 'mysqld' as a system service on CentOS 8 systems using the 'systemctl' command. 2022-10-01, ∼510🔥, 0💬

System, User-Defined and Stored Procedure Variables
This chapter provides tutorial notes on 3 types of variables in MySQL: System Variables, User-Defined Variables and Stored Procedure Variables. System variables have two scopes: Global and Session. 2022-10-01, ∼508🔥, 0💬

Operations and Expressions
This chapter provides tutorial notes on operations and expressions. Topics include types of operations and expressions; arithmetic operations; predicate operations; data and time operations; examples of different types of operations. 2022-10-01, ∼506🔥, 0💬

Table Column Types for Different Types of Values
This chapter provides tutorial notes on table column types. Topics include column types for character strings, bit strings, exact numbers, approximate numbers, data and time values. 2022-10-01, ∼505🔥, 0💬

JDBC Driver Connection URL
Describes the connection URL format and how to create connection objects with the DriverManager class. 2022-10-01, ∼501🔥, 0💬

mysqladmin - The Client Tool for Administrators
A quick introduction is provided on mysqladmin, the client tool managing MySQL servers. You can run mysqladmin on a remote system to check the status of the MySQL server or shutdown the server. 2022-10-01, ∼497🔥, 0💬

List of MySQL Programs
This section provides a list of main executable programs provided in MySQL 5.0 Community Edition. 2022-10-01, ∼493🔥, 0💬

Defining and Calling Stored Procedures
This chapter provides tutorial notes on store procedures. Topics include what is a stored procedure; creating a stored procedure; calling a stored procedure to run; passing data into and out of stored procedures. 2022-10-01, ∼490🔥, 0💬

MySQL Server on macOS
This chapter provides tutorial notes on MySQL server for macOS systems. Topics include installing MySQL Server on macOS; connecting MySQL Server on macOS using localhost IP address. 2022-10-01, ∼487🔥, 0💬

Table Column Types for Exact Numbers
Describes 4 types of table columns to store exact numbers: NUMERIC, DECIMAL, INTEGER and SMALLINT. 2022-10-01, ∼483🔥, 0💬

Clustered Index Used by InnoDB Engine
This section describbes the Clustered Index data structure used by the InnoDB engine to stored indexed data rows of a table in MySQL server. 2022-10-01, ∼483🔥, 0💬

Numeric Value Functions
Describes some commonly used numeric functions like, ABS(), CEILING(), COS(), PI(), RANDOM(), ROUND(), and TRUNCATE(). 2022-10-01, ∼482🔥, 0💬

Using SELECT to Query Database
This chapter provides tutorial notes on SELECT query statements. Topics include SELECT statement syntax, FROM clause, WHERE clause, GROUP BY clause, ORDER BY clause, JOIN table operations. 2022-10-01, ∼479🔥, 0💬

%mysql% Variable for MySQL Server Path
Tutorial example on how to create an environment variable '%mysql%' to represent the MySQL Server directory path name. This gives a quick way to invoke a MySQL command like '%mysql%\bin\mysql'. 2022-10-01, ∼479🔥, 0💬

Commonly Used Functions
This chapter provides tutorial notes on built-in functions. Topics include commonly used flow control functions, character string functions, numeric functions, data and time functions, the cast function. 2022-10-01, ∼478🔥, 0💬

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

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