General MySQL Oracle SQL Server

<< < … 9 10 11 12 13 14 15 16 17 > >>   ∑:386  Sort:Date

Shutdown MySQL Server Properly in MySQL
How To Properly Shutdown MySQL Server Daemon mysqld in MySQL? The proper way to shutdown your MySQL server is to the use "mysqladmin shutdown" command. Other ways to shutdown your server include: Enter "mysqladmin -u root -ppassowrd shutdown" command with options in a command window. Use Windows Tas... 2017-12-04, 2765🔥, 0💬

Rename an Existing Table in MySQL
How To Rename an Existing Table in MySQL? If you want to rename an existing table, you can use the "ALTER TABLE ... RENAME TO" statement. The tutorial script below shows you a good example: mysql&gt; ALTER TABLE tip RENAME TO faq; Query OK, 0 rows affected (0.01 sec) mysql&gt; SELECT * FROM ... 2018-02-14, 2760🔥, 0💬

Giving Privileges at the Database Level in MySQL
How To Grant User Privileges at the Database Level in MySQL? If you want to grant a user privilege at the database level, you can use the "GRANT privilegeName ON databaseName.* TO userName" command. The argument "databasename.*" in the command stands for all tables in the specified database. The fol... 2017-08-21, 2755🔥, 0💬

Using Group Functions in the ORDER BY Clause in MySQL
Can Group Functions Be Used in the ORDER BY Clause in MySQL? If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many links were created in each year in each tag. The group output is sorted by the c... 2017-12-31, 2748🔥, 0💬

Adding More Data to the Test Table in MySQL
How To Add More Data to the Testing Table in MySQL? If you want to continue with other tutorial exercises in this FAQ collection, you need to add more data to the testing table. Follow the script below to add a new column and: mysql&gt; ALTER TABLE fyi_links ADD COLUMN tag VARCHAR(8); mysql&... 2017-11-02, 2745🔥, 0💬

Creating a New Database in MySQL
How To Create a New Database in MySQL? A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are the administrator of the server, you can create a new databases using the CREATE DATABASE statements with MySQL client interface progr... 2017-11-11, 2740🔥, 0💬

Deleting a User Account in MySQL
How To Delete a User Account in MySQL? If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: &gt;cd \mysql\bin &gt;mysql -u root -pretneciyf mysql mysql... 2017-12-13, 2739🔥, 0💬

Using LIKE Conditions in MySQL
How To Use LIKE Conditions in MySQL? A LIKE condition is also called pattern patch. There are 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause is used to provide the escape char... 2018-03-24, 2738🔥, 0💬

What Is Transaction in MySQL
What Is 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 statements... 2016-10-16, 2728🔥, 0💬

SESSION_USER() - Synonym for USER()
What's the difference between SESSION_USER() and USER() functions? SESSION_USER() is a synonym for the USER() function. Related MySQL functions: USER() - Login Name of Current User SESSION_USER() - Synonym for USER() SYSTEM_USER() - Synonym for USER() CURRENT_USER() - Authentication Name of Current ... 2025-01-07, 2684🔥, 0💬

Running MySQL Server on a Specific Port in MySQL
How To Run MySQL Server on a Different Port in MySQL? By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start the server to listen to a different port nu... 2017-11-29, 2659🔥, 0💬

Inserting Rows with a SELECT Statement in MySQL
How To Insert Multiple Rows with a SELECT Statement in MySQL? If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example: &lt;?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_l... 2017-09-20, 2651🔥, 0💬

FORMAT_PICO_TIME() - Formatting Picoseconds in Readable Units
How to format a number of picoseconds in a human-readable unit using the FORMAT_PICO_TIME() function? FORMAT_PICO_TIME(con) is a MySQL built-in function that converts a number of picoseconds in a human-readable unit of ps, ns, ms, s, min, h, or d. For example: SELECT FORMAT_PICO_TIME(9), FORMAT_PICO... 2025-09-24, 2631🔥, 0💬

CRC32() - Cyclic Redundancy Check 32-Bit
How to calculate the 32-bit CRC (Cyclic Redundancy Check) value using the CRC32() function? CRC32(str) is a MySQL built-in function that calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. For example: SELECT CRC32('MySQL'), HEX(CRC32('... 2024-07-15, 2611🔥, 0💬

DENSE_RANK() - Density Rank of Sorted Values
How to calculate the density rank of the sorting field expression in the current result set window using the DENSE_RANK() function? DENSE_RANK() is a MySQL built-in window function that calculates the density rank of the sorting field expression in the current result set window. For example: SELECT ... 2024-09-28, 2492🔥, 0💬

JSON_STORAGE_FREE() - Free Space in JSON Value
How to obtain the free space size in a JSON table column using the JSON_STORAGE_FREE() function? JSON_STORAGE_FREE(json) is a MySQL built-in function that returns the free space size in a JSON table column. Free space occurs when JSON table column is partially updated with less data. For example: CR... 2024-12-18, 2437🔥, 0💬

UNCOMPRESSED_LENGTH() - Uncompressed Data Length
How to calculate the original data length of a compressed byte string using the UNCOMPRESSED_LENGTH() function? UNCOMPRESSED_LENGTH(str) is a MySQL built-in function that returns the original data length of a given compressed byte string. For example: SET @bin = x'37000000789C738BF44C4ECD2B49 2DD24BC... 2024-12-18, 2384🔥, 0💬

MySQL Functions on Character String Values
Where to find reference information and tutorials on MySQL database functions on string values? I want to know how to use SUBSTRING(), REPLACE() and other character string related functions. Here is a collection of reference information and tutorials on MySQL database functions on string values comp... 2023-11-10, 2377🔥, 0💬

LAG() - N-Row before Current Row within Window
How to evaluate a field expression on n-row before the current row in the current result set window using the LAG() function? LAG(exp, n, default) is a MySQL built-in window function that evaluates a field expression on n-row before the current row in the current result set window. For example: SELE... 2024-09-28, 2340🔥, 0💬

JSON_QUOTE() - Quoting JSON String
How to convert a regular character string into a JSON (JavaScript Object Notation) string using the JSON_QUOTE() function? JSON_QUOTE(str) is a MySQL built-in function that converts a regular character string into a JSON string by quoting the string with double quotes. It replaces the double-quote c... 2023-12-10, 2339🔥, 0💬

FIRST_VALUE() - First Value of Result Set Window
How to obtain the first value of a field expression in the current result set window using the FIRST_VALUE() function? FIRST_VALUE(exp) is a MySQL built-in window function that returns the first value of a field expression in the current result set window. For example: SELECT help_topic_id AS tip, h... 2024-09-28, 2281🔥, 0💬

MySQL Functions on System Information
Where to find reference information and tutorials on MySQL database functions on System Information? I want to know how to use DATABASE(), VERSION() and other functions. Here is a collection of reference information and tutorials on MySQL database functions on System Information compiled by FYIcente... 2024-07-15, 2277🔥, 0💬

COLLATION() - Detecting Character Collation Name
How to detect the character collation name associated to a given character string using the COLLATION() function? COLLATION(str) is a MySQL built-in function that returns the character collation name associated to a given character string. A character collation name refers to a set of rules to sort ... 2025-10-14, 2187🔥, 0💬

JSON_TABLE() - Inline Table with JSON Array
How to create an inline table with a JSON Array using the JSON_TABLE() function? JSON_TABLE(json, path COLUMNS (column_list) AS alias) is a MySQL built-in function that creates an inline table by parsing JSON array members. For example: the following statement creates a 1-column table with string me... 2024-11-23, 2154🔥, 0💬

<< < … 9 10 11 12 13 14 15 16 17 > >>   ∑:386  Sort:Date

General MySQL Oracle SQL Server