General MySQL Oracle SQL Server

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

Accessing MySQL Server through Firewalls in MySQL
How To Access MySQL Servers through Firewalls in MySQL? If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MySQL server as shown below: Firewalls to MyS... 2017-11-25, 3340🔥, 0💬

What Is TIMESTAMP Data Type in MySQL
What Is TIMESTAMP Data Type in MySQL? A TIMESTAMP data type allows you to record a date and time like DATETIME data type. But it has some interesting features when used on a table column: The first TIMESTAMP column in a table will be assigned with the current date and time, if it is not listed in an... 2018-03-13, 3336🔥, 0💬

Creating a Test Table in MySQL Server in MySQL
How To Create a Test Table in Your MySQL Server in MySQL? If you want to create a test table in your MySQL server, you can use the "mysql" program in a command window as shown in the following tutorial: &gt;cd \mysql\bin &gt;mysql -u root Welcome to the MySQL monitor. Commands end with ; or ... 2018-06-06, 3329🔥, 0💬

"mysql" Command Line Options in MySQL
What Are the "mysql" Command Line Options in MySQL? "mysql" offers a big list of command line options. Here are some commonly used options: "-?" - Displays a help message on how to use "mysql" and terminates the program. "-u userName" - Specifies a user name for the server to authenticate when conne... 2018-04-28, 3321🔥, 0💬

Chaning Other User's Password in MySQL
How To Change the Password of Another User Account in MySQL? If you want to change the password of someone else's user account, you can connect to the server as "root" and use the "SET PASSWORD FOR userName ..." command to change the password of another user account. There are two ways to use this c... 2017-09-08, 3307🔥, 0💬

Create a Test Table with Test Data in MySQL
How To Create a Testing Table with Test Data in MySQL? If you want to follow the tutorial exercises presented in this collection, you need to create a testing table and insert some test data, as shown in the following sample script: mysql&gt; CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url V... 2017-11-05, 3304🔥, 0💬

Managing User Accounts and Access Privileges in MySQL
Where to find answers to frequently asked questions on Managing User Accounts and Access Privileges in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing User Accounts and Access Privileges in MySQL. Clear answers are provided with tu... 2017-12-13, 3299🔥, 0💬

Date and Time Intervals in MySQL
What Are Date and Time Intervals in MySQL? A date and time interval is special value to be used to increment or decrement a date or a time at a given date or time unit. A data and time interval should be expression in the format of "INTERVAL expression unit", where "unit" and "expression" should fol... 2017-12-26, 3290🔥, 0💬

What Is a Result Set Object in MySQL
What Is a Result Set Object in MySQL? A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a result set object, you can us... 2017-09-20, 3284🔥, 0💬

Revoking User Privileges in MySQL
How To Revoke User Privileges in MySQL? If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a privilege on a specific database, if that privilege was... 2017-08-21, 3283🔥, 0💬

PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect
How to obtain the performance schema thread id of the current connection using the PS_CURRENT_THREAD_ID() function? PS_CURRENT_THREAD_ID() is a MySQL built-in function that returns the performance schema thread id of the current connection. For example: SELECT PS_CURRENT_THREAD_ID(); -- +-----------... 2025-02-16, 3281🔥, 0💬

Difference between CHAR and VARCHAR in MySQL
What Are the Differences between CHAR and VARCHAR in MySQL? CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences: CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length. VARCHAR stores value... 2018-01-19, 3273🔥, 0💬

Rename an Existing Column in a Table in MySQL
How To Rename an Existing Column in a Table in MySQL? If you have an existing column in a table and you want to change the column name, you can use the "ALTER TABLE ... CHANGE" statement. This statement allows you to change the name of a column, and its definition. The tutorial script below gives yo... 2018-03-04, 3271🔥, 0💬

Deleting Multiple Rows from a Table in MySQL
How To Delete Multiple Rows from a Table in MySQL? You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table: mysql&gt; SELECT id, url, notes, coun... 2018-01-08, 3271🔥, 0💬

Incrementing a Date by 1 in MySQL
How To Increment Dates by 1 in MySQL? If you have a date, and you want to increment it by 1 day, you can use the DATE_ADD(date, INTERVAL 1 DAY) function. You can also use the date interval add operation as "date + INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SELECT DATE... 2017-12-26, 3271🔥, 0💬

Introduction to SQL Basics in MySQL
Where to find answers to frequently asked questions on Introduction to SQL Basics in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to SQL Basics in MySQL. Clear answers are provided with tutorial exercises on character and nu... 2018-04-21, 3265🔥, 0💬

Connect to MySQL Server with User Account in MySQL
How To Connect to MySQL Server with User Accounts in MySQL? If you want to connect a MySQL server with user account name and password, you need to call mysql_connect() with more parameters like this: $con = mysql_connect($server, $username, $password); If your MySQL server is provided by your Intern... 2017-11-25, 3260🔥, 0💬

JSON_VALID() - Validating JSON Value
How to verify if value is a JSON (JavaScript Object Notation) value using the JSON_VALID() function? JSON_VALID(val) is a MySQL built-in function that returns 1 if the given value is a valid JSON value. For example: SELECT JSON_VALID('hello'), JSON_VALID('"hello"'); -- +---------------------+------- ... 2023-12-17, 3256🔥, 0💬

Select Rows with WHERE Clause in MySQL
How To Select Some Rows from a Table in MySQL? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is a normal Boolean expression. If any data from ta... 2017-11-02, 3251🔥, 0💬

What Is CSV in MySQL
What Is CSV in MySQL? CSV (Comma Separated Values) is a file format used to store database table contents, where one table row is stored as one line in the file, and each data field is separated with comma.   ⇒ What Is Transaction in MySQL ⇐ What Is BDB in MySQL ⇑ Database Basics and Terminologies ... 2016-10-16, 3248🔥, 0💬

VERSION() - Version Number of MySQL Server
How to obtain the version number of the MySQL server using the VERSION() function? VERSION() is a MySQL built-in function that returns the version number of the MySQL server. For example: SELECT VERSION(); -- +-----------+ -- | VERSION() | -- +-----------+ -- | 8.0.17 | -- +-----------+ SELECT @@ver... 2025-01-07, 3242🔥, 0💬

What Is "mysqlimport" Command in MySQL
What Is "mysqlimport" in MySQL? "mysqlimport" - A command-line interface for administrators or end users to load data files into tables program tool to load data into tables. Here is a sample commands supported by "mysqlimport": "mysqlimport databaseName fileName" - Imports the data from the specifi... 2018-05-19, 3228🔥, 0💬

Dividing Query Output into Groups in MySQL
How To Divide Query Output into Groups in MySQL? You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in that column will be considered as a single group. When the GROUP BY clause is speci... 2017-10-16, 3218🔥, 0💬

What Is MySQL
What Is MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com.   ⇒ What Is mSQL in MySQL ⇐ Database Basics and Terminologies in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-21, 3211🔥, 0💬

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

General MySQL Oracle SQL Server