General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 9 … > >>   ∑:386  Sort:Date

Downloading and Installing MySQL on Windows
Where to find answers to frequently asked questions on Downloading and Installing MySQL on Windows? I want to learn how to install MySQL database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Downloading and Installing MySQL on Windows. Clear a... 2018-06-12, 3676🔥, 0💬

Show Server Status with "mysqladmin" in MySQL
How To Check Server Status with "mysqladmin" in MySQL? If you want to check the server status by with "mysqladmin", you can following this tutorial example: &gt;cd \mysql\bin &gt;mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl... 2018-06-01, 3675🔥, 0💬

Data File for MyISAM Storage Engine in MySQL
Where Table Data Is Stored by the MyISAM Storage Engine in MySQL? By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, each database will have its own subdirectory to store table data. If a new table is created with the MyISAM sto... 2017-09-01, 3654🔥, 0💬

List All Existing Databases in MySQL
How To Get a List of Databases from MySQL Servers in MySQL? Once you got a MySQL server connection object successfully, you need to know what databases are available on the server and which database you should use to manage your tables and data. To get a list of all available databases on your MySQL... 2017-11-11, 3643🔥, 0💬

What Is mSQL in MySQL
What Is mSQL in MySQL? Mini SQL (mSQL) is a light weight relational database management system capable of providing rapid access to your data with very little overhead. mSQL is developed by Hughes Technologies Pty Ltd. MySQL was started from mSQL and shared the same API.   ⇒ What Is SQL in MySQL ⇐ ... 2017-07-15, 3627🔥, 0💬

Analyze Tables with "mysqlcheck" Command in MySQL
How To Analyze Tables with "mysqlcheck" in MySQL? If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database: &gt;cd \mysql\bin &gt;mysqlcheck -u root --analyze mysql mysql.colu... 2018-02-28, 3611🔥, 0💬

UPDATE Using Data from Other Tables in MySQL
How To Use Values from Other Tables in UPDATE Statements in MySQL? If you want to update values in one table with values from another table, you can use a subquery as an expression in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE clau... 2018-01-13, 3595🔥, 0💬

IS_IPV4() - Detecting IPv4 Address
How to detect an IPv4 Address using the IS_IPV4() function? IS_IPV4(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv4 address, 0 otherwise. For example: SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256'); -- +---------------------+------- ----------------+-- | IS_IPV4... 2026-02-02, 3589🔥, 0💬

Transaction Roll Back when Session Killed in MySQL
What Happens to the Current Transaction If the Session Is Killed in MySQL? If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be removed. This is called an implicit rollback when sess... 2017-08-03, 3584🔥, 0💬

Show All Columns of an Existing Table in MySQL
How To Get a List of Columns in an Existing Table in MySQL? If you have an existing table, but you don't remember what are the columns used in the table, you can use the "SHOW COLUMNS FROM tableName" command to get a list of all columns of the specified table. You can also use the "DESCRIBE tableNam... 2018-03-10, 3576🔥, 0💬

Decrementing a Date by 1 in MySQL
How To Decrement Dates by 1 in MySQL? If you have a date, and you want to decrement it by 1 day, you can use the DATE_SUB(date, INTERVAL 1 DAY) function. You can also use the date interval subtraction operation as "date - INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SEL... 2017-12-26, 3561🔥, 0💬

Returning Query Output in HTML Format in MySQL
How To Return Query Output in HTML Format in MySQL? By default, "mysql" returns query output in text table format. If you want to receive query output in HTML format, you need to use the "-H" command option. Here is a good tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u root -H test mysql&... 2018-02-08, 3559🔥, 0💬

Administrator Tools for Managing MySQL Server
Where to find answers to frequently asked questions on Administrator Tools for Managing MySQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Administrator Tools for Managing MySQL Server. Clear answers are provided with tutorial exercises... 2018-06-06, 3546🔥, 0💬

What Is RollBack in MySQL
What Is Rollback in MySQL? Rollback is a way to terminate a transaction with all database changes not saving to the database server.   ⇒ MySQL Database Tutorials ⇐ What Is Commit in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2016-10-16, 3537🔥, 0💬

What Is a Transaction - Unit of Work in MySQL
What Is a Transaction in MySQL? A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statemen... 2017-08-03, 3534🔥, 0💬

Returning Query Output in XML Format in MySQL
How To Return Query Output in XML Format in MySQL? By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u root -X test mysql&am... 2018-04-21, 3522🔥, 0💬

Connecting to MySQL Server on a Specific Port in MySQL
How To Connect to MySQL Server on a Different Port in MySQL? If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise shows you how to connect "mysql" to start... 2017-11-25, 3519🔥, 0💬

LAST_INSERT_ID() - Last Value of AUTO_INCREMENT Column
How to obtain the last inserted value of an AUTO_INCREMENT column using the LAST_INSERT_ID() function? LAST_INSERT_ID() is a MySQL built-in function that returns the last inserted value of an AUTO_INCREMENT column. For example: CREATE TABLE MyTable (id INTEGER AUTO_INCREMENT, comment CHAR(80), PRIMA... 2025-04-11, 3517🔥, 0💬

Tables Using MEMORY Storage Engine in MySQL
How To Create a New Table Using the MEMORY Storage Engine in MySQL? MEMORY storage engine stores table data in computer system memory. This is good for creating temporary tables. MEMORY is not the default storage engine. You need to specify "ENGINE = MEMORY" at the end of the "CREATE TABLE" statemen... 2017-08-08, 3517🔥, 0💬

What Is SQL in MySQL
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.   ⇒ What Is Table in MySQL ⇐ What Is mSQL in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorial... 2017-07-15, 3514🔥, 0💬

Calculating the Difference between Two Dates in MySQL
How To Calculate the Difference between Two Dates in MySQL? If you have two dates, and you want to know how many days between them, you can use the DATEDIFF(date1, date2) function as shown below: SELECT DATEDIFF(DATE('1997-02-28'), DATE('1997-03-01')) FROM DUAL; -1   ⇒ Calculating the Difference bet... 2017-12-26, 3495🔥, 0💬

JSON_SCHEMA_VALIDATION_REPORT() - JSON Schema Validation Report
How to generate a validation report of a JSON value against a JSON schema using the JSON_SCHEMA_VALIDATION_REPORT( )function? JSON_SCHEMA_VALIDATION_REPORT( schema,json) is a MySQL built-in function that returns a validation report of a JSON value against a given JSON schema. The report itself is a ... 2024-11-23, 3485🔥, 0💬

Create an Index for a Given Table in MySQL
How To Create an Index for a Given Table in MySQL? If you have a table with a lots of rows, and you know that one of the columns will be used often as a search criteria, you can add an index for that column to improve the search performance. To add an index, you can use the "CREATE INDEX" statement ... 2018-02-14, 3470🔥, 0💬

User Privilege Tables in MySQL
Where Are User Privileges Stored on the Server in MySQL? MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored in different tables: "mysql.user" - Stores privileg... 2017-12-09, 3463🔥, 0💬

<< < 1 2 3 4 5 6 7 8 9 … > >>   ∑:386  Sort:Date

General MySQL Oracle SQL Server