General MySQL Oracle SQL Server

<< < … 5 6 7 8 9 10 11 12 13 14 15 … > >>   ∑:383  Sort:Date

JSON_TYPE() - Detecting Type of JSON Value
How to detect the type of a JSON (JavaScript Object Notation) value using the JSON_TYPE() function? JSON_TYPE(json) is a MySQL built-in function that returns the data type of a JSON (JavaScript Object Notation) value. For example: SELECT JSON_TYPE('[]'), JSON_TYPE('{}'); -- +-----------------+------... 2025-03-12, 2657🔥, 0💬

Viewing User Privileges in MySQL
How To View User Privileges in MySQL? If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userName" command. The following tutorial exercise shows... 2017-08-21, 2657🔥, 0💬

Rollback the Current Transaction in MySQL
How To Rollback the Current Transaction in MySQL? If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLBACK command. It will remove all the database chan... 2016-10-17, 2654🔥, 0💬

What Is "mysqlshow" Command in MySQL
What Is "mysqlshow" in MySQL? "mysqlshow" is a command-line interface for end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow": "mysqlshow" - Shows all the databases. "mysqlshow databaseName" - Shows all the tables in the specified database. "mys... 2018-02-28, 2650🔥, 0💬

Build WHERE Criteria with Web Form Data in MySQL
How To Build WHERE Criteria with Web Form Search Fields in MySQL? If your PHP script is linked to a Web form which takes search key words for multiple data fields. For example, your Web form asks your visitor to search for Website links with a URL search field, a Website title search field, a descri... 2017-06-23, 2646🔥, 0💬

Major Storage Engines Supported in MySQL in MySQL
What Are Storage Engines in MySQL? Storage engines are programs that are integrated into MySQL database management system to manage data tables. MySQL 5.0 supports the following major storage engines: MyISAM Storage Engine - MySQL default storage engine. Based on ISAM database concept. MyISAM is not... 2017-09-12, 2643🔥, 0💬

Memory Usage of the MySQL Server in MySQL
How Much Memory Does the Server Take in MySQL? If you are interested to know how much memory your MySQL server is taking, you can use Windows Task Manager to find out. Try to following this tutorial exercise: Start your MySQL server. Press Ctrl-Alt-Del and click Task Manager. The Task Manager window... 2017-12-04, 2641🔥, 0💬

Creating a Test Table in MySQL
How To Create a Testing Table in MySQL? If you want to practice DML statements, like INSERT, UPDATE and DELETE, you should create a testing table. The tutorial exercise shows you a good example: mysql&gt; CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(80) NOT NULL, notes VARCHAR(102... 2018-01-24, 2640🔥, 0💬

What Are DML Statements in MySQL
What Are DML Statements in MySQL? DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating existing rows in database tables . DELETE - Deleting existing r... 2018-01-24, 2638🔥, 0💬

What Is Index in MySQL
What Is Index in MySQL? An index is a single column or multiple columns defined to have values pre-sorted to speed up data retrieval speed.   ⇒ What Is View in MySQL ⇐ What Is Foreign Key in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 2632🔥, 0💬

What Is InnoDB in MySQL
What Is InnoDB in MySQL? InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now).   ⇒ What Is BDB in MySQL ⇐ What Is MyISAM in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-03, 2630🔥, 0💬

Creating a New Table in MySQL
How To Create a New Table in MySQL? If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR... 2017-10-08, 2629🔥, 0💬

DML Commands Supported in MySQL
How Many SQL DML Commands Are Supported by "mysql" in MySQL? There are 4 SQL Data Manipulation Language (DML) commands that are supported by "mysql". They are listed below with short descriptions: "INSERT INTO tableName ..." - Inserts new data rows into the specified table. "DELETE FROM tableName ..... 2018-02-08, 2628🔥, 0💬

Violation of Unique Value Constraint in MySQL
What Happens If Unique Value Constraints Are Violated in MySQL? If you are inserting a new record that has values violating a unique constraint, you will get an error. Note that primary key column has a unique value constraint by default. The following tutorial exercise gives you some good examples:... 2018-01-16, 2625🔥, 0💬

Viewing Log File with "mysqlbinlog" in MySQL
How To Use mysqlbinlog to View Binary Logs in MySQL? If you have binary logs turned on, you can use "mysqlbinlog" to view the binary log files. The tutorial exercise below shows you how to view two binary files together: &gt;cd \mysql\bin &gt;mysql -u root -pretneciyf test &gt;mysqlbinlo... 2017-11-29, 2624🔥, 0💬

Inner Join with the WHERE Clause in MySQL
How To Write an Inner Join with the WHERE Clause in MySQL? If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: mysql&gt; SELECT l.id, l.url, r.comment FROM fyi_links l, fyi_rates... 2017-09-28, 2623🔥, 0💬

Experiment with Dead Locks in MySQL
How To Experiment Dead Locks in MySQL? If you want to have some experience with dead locks, you can create two windows running two mysql transactions in two sessions at the REPEATABLE READ transaction isolation level. Then run some UPDATE statements as shown in the tutorial exercise below: (session ... 2017-07-21, 2622🔥, 0💬

Define the ID Column as Auto-Incremented in MySQL
How To Define the ID Column as Auto-Incremented in MySQL? Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow MySQL server to automatically ass... 2017-09-12, 2619🔥, 0💬

Entering Character Strings in MySQL
How To Include Character Strings in SQL statements in MySQL? If you want to include character strings in your SQL statements, you need to quote them in one of the following formats: Using single quotes. For example 'FYIcenter.com'. Using double quotes. For example "FYI Center". Using single quotes p... 2018-04-12, 2618🔥, 0💬

Query with a Full Outer Join in MySQL
How To Write a Query with a Full Outer Join in MySQL? There is no way to do full outer join in MySQL. It does not support this feature at the current MySQL release.   ⇒ Inner Join with the WHERE Clause in MySQL ⇐ Query with a Right Outer Join in MySQL ⇑ SELECT Statements with JOIN and Subqueries in... 2017-09-28, 2617🔥, 0💬

Retrieving the Last Sequence ID in MySQL
How To Get the Last ID Assigned by MySQL in MySQL? If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below: &lt;?php include "mysql_connection.php"; $sql = "INSERT... 2017-09-12, 2612🔥, 0💬

Transaction Committed when DDL Statement Executed in MySQL
What Happens to the Current Transaction If a DDL Statement Is Executed in MySQL? If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. This is called an implicit commit by a DDL statement. ... 2016-10-17, 2612🔥, 0💬

What Is SQL Standard in MySQL
What Is SQL Standard in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. SQL became an ANSI standard, called SQL-87, in 1986. ISO made a major revision, called SQL-92, in 1992. The latest r... 2018-04-21, 2610🔥, 0💬

ROLES_GRAPHML() - User Role Graph in GraphML Format
How to obtain User Role Graph in GraphML Format using the ROLES_GRAPHML() function? ROLES_GRAPHML() is a MySQL built-in function that returns user role graph in GraphML format. For example: SELECT ROLES_GRAPHML(); -- +----------------------------- ------------------------------ ---------+-- | ROLES_G... 2025-02-16, 2602🔥, 0💬

<< < … 5 6 7 8 9 10 11 12 13 14 15 … > >>   ∑:383  Sort:Date

General MySQL Oracle SQL Server