General MySQL Oracle SQL Server

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

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, 3569🔥, 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, 3531🔥, 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, 3510🔥, 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, 3507🔥, 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, 3463🔥, 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, 3439🔥, 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, 3426🔥, 0💬

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, 3413🔥, 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, 3403🔥, 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, 3399🔥, 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, 3399🔥, 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, 3393🔥, 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, 3388🔥, 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, 3383🔥, 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, 3383🔥, 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, 3381🔥, 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, 3370🔥, 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, 3354🔥, 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, 3346🔥, 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, 3341🔥, 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, 3338🔥, 0💬

Updating Existing Rows in MySQL
How To Update Existing Rows in a Table in MySQL? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET ... 2023-09-10, 3323🔥, 1💬

💬 2023-09-10 Pintu kumar: To update existing rows in a table in MySQL, you can use the UPDATE statement. Here's a general syntax for updating rows in MySQ...

What Is Union in MySQL
What Is Union in MySQL? Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.   ⇒ What Is ISAM in MySQL ⇐ What Is Join in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 3321🔥, 0💬

Entering Characters as HEX Numbers in MySQL
How To Enter Characters as HEX Numbers in MySQL? If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a character string, if the expression cont... 2018-03-31, 3319🔥, 0💬

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

General MySQL Oracle SQL Server