General MySQL Oracle SQL Server

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

Command-Line End User Interface 'mysql'
Where to find answers to frequently asked questions on Command-Line End User Interface "mysql"? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Command-Line End User Interface "mysql". Clear answers are provided with tutorial exercises on mysql co... 2018-04-28, 3116🔥, 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, 3115🔥, 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, 3113🔥, 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, 3102🔥, 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, 3096🔥, 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, 3089🔥, 0💬

"mysqld" Command Line Options in MySQL
What Are the "mysqld" Command Line Options in MySQL? "mysqld" offers a big list of command line options. Here are some commonly used options: "--help" - Displays a short help message on how to use "mysqld". "--verbose --help" - Displays a long help messages on how to use "mysqld". "--console" - Spec... 2017-12-04, 3078🔥, 0💬

Verify MySQL Server Status in MySQL
How Do You Know If Your MySQL Server Is Alive in MySQL? If you want to know whether your MySQL server is alive, you can use the "mysqladmin" program in a command window as shown in the following tutorial: &gt;cd \mysql\bin &gt;mysqladmin -u root ping mysqld is alive The "mysqld is alive" mes... 2018-06-06, 3064🔥, 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, 3060🔥, 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, 3054🔥, 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, 3054🔥, 0💬

What Is MyISAM in MySQL
What Is MyISAM in MySQL? MyISAM is a storage engine used as the default storage engine for MySQL database. MyISAM is based on the ISAM (Indexed Sequential Access Method) concept and offers fast data storage and retrieval. But it is not transaction safe.   ⇒ What Is InnoDB in MySQL ⇐ What Is ISAM in... 2017-07-03, 3054🔥, 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, 3052🔥, 0💬

What Is Join in MySQL
What Is Join in MySQL? Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.   ⇒ What Is Union in MySQL ⇐ What Is View in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 3050🔥, 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, 3045🔥, 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, 3038🔥, 0💬

Tables Using BDB Storage Engine in MySQL
How To Create a New Table Using the BDB Storage Engine in MySQL? BDB (BerkeleyDB) storage engine was originally developed at U.C. Berkeley. It is now maintained by Sleepycat Software, Inc., which is an Oracle company now. BDB is transaction safe, and has been used in products from many companies, li... 2017-08-13, 3033🔥, 0💬

Verify the Version of MySQL Server in MySQL
How Do You Know the Version of Your MySQL Server in MySQL? If you want to know the version number of your MySQL server, you can use the "mysqladmin" program in a command window as shown in the following tutorial: &gt;cd \mysql\bin &gt;mysqladmin -u root version mysqladmin Ver 8.41 Distrib 5.... 2018-06-06, 3032🔥, 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, 3030🔥, 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, 3028🔥, 0💬

Extract Unit Values from a Date and Time in MySQL
How To Extract a Unit Value from a Date and Time in MySQL? If you want to extract a specific date or time unit value out of a date or a time, you can use the EXTRACT(unit FROM expression) function. The tutorial exercise below gives you some good examples: ELECT EXTRACT(DAY FROM NOW()) FROM DUAL; 28 ... 2018-03-13, 3025🔥, 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, 3025🔥, 0💬

Date and Time Data Types in MySQL
What Are Date and Time Data Types in MySQL? MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of '1000-01-01 00:00:00' and '9999-12-31 23:59:59'.... 2018-01-19, 3020🔥, 0💬

What Is a Data Lock in MySQL
What Is a Data Lock in MySQL? MySQL uses two types of data locks at two levels to provide you the transaction isolation level you need: Share Lock at Row Level (S) - A data row is locked by a transaction for reading. Exclusive Lock at Row Level (X) - A data row is locked by a transaction for updatin... 2017-04-28, 3014🔥, 0💬

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

General MySQL Oracle SQL Server