General MySQL Oracle SQL Server

<< < … 3 4 5 6 7 8 9 10 11 12 13 … > >>   ∑:380  Sort:Date

Adding a New User Account in MySQL
How To Add a New User Account in MySQL? If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is: CREATE USER userName IDENTIFIED BY 'passwordStrin... 2017-09-08, 2571🔥, 0💬

Create a Table for Transaction Testing in MySQL
How To Create a Table for Transaction Testing in MySQL? If you want to learn transaction management, you should create a table with the InnoDB storage engine. The default storage engine MyISAM does not support the transaction concept. The tutorial exercise below shows you a good example of creating ... 2016-10-17, 2570🔥, 0💬

Use Existing Column Values in the SET Clause in MySQL
How To Use Existing Column Values in the SET Clause in MySQL? If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by column names in the expressions. The tutorial exer... 2018-01-13, 2568🔥, 0💬

What Is a Subquery in MySQL
What Is a Subquery in MySQL? A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The output of the subquery will be used in the final evalu... 2017-09-17, 2568🔥, 0💬

Quoting Date and Time Values in MySQL
How To Quote Date and Time Values in SQL Statements in MySQL? If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first one us... 2017-06-23, 2567🔥, 0💬

Sorting Query Output in MySQL
How To Sort the Query Output in MySQL? If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement returns rows sorted by the values in the "counts... 2017-11-02, 2565🔥, 0💬

Quoting Text Values in MySQL
How To Quote Text Values in SQL Statements in MySQL? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one sing... 2017-06-28, 2565🔥, 0💬

What Is NULL Value in MySQL
What Are NULL Values in MySQL? NULL is a special value that represents no value. Here are basic rules about NULL values: NULL presents no value. NULL is not the same as an empty string ''. NULL is not the same as a zero value 0. NULL can be used as any data type. NULL should not be used in any compa... 2018-03-28, 2564🔥, 0💬

What Is Table in MySQL
What Is Table in MySQL? A table is a data storage structure with rows and columns.   ⇒ What Is Column in MySQL ⇐ What Is SQL in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-15, 2555🔥, 0💬

Using CASE Expression in MySQL
How To Use CASE Expression in MySQL? There are 2 ways to use the CASE expression. The first way is to return one of the predefined values based on the comparison of a given value to a list of target values. The second way is to return one of the predefined values based on a list of conditions. Here ... 2018-03-24, 2554🔥, 0💬

Inserting a New Row into a Table in MySQL
How To Insert a New Row into a Table in MySQL? To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: mysql&gt; INSERT INTO fyi_links VALUES (101, 'dev.fyicenter.com', NULL, 0, '2006-04-30'); Query OK, 1... 2018-01-16, 2554🔥, 0💬

Deleting an Existing Database in MySQL
How To Drop an Existing Database in MySQL? If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sql = 'DROP DATABASE fyi'; if (mysql_query($... 2017-10-23, 2550🔥, 0💬

Returning Top 5 Rows in MySQL
How To Return Top 5 Rows in MySQL? If you want the query to return only the first 5 rows, you can use the LIMIT clause, which takes one parameter as the maximum number of rows to return. The following statement returns the first 5 rows from the fyi_links: mysql&gt; SELECT id, url, counts, tag FR... 2017-12-21, 2549🔥, 0💬

Evaluating Expressions with SELECT Statements in MySQL
How To Calculate Expressions with SELECT Statements in MySQL? There is no special SQL statements to calculate expressions. But you can use the "SELECT expression FROM DUAL" statement return the calculated value of an expression. "DUAL" is a dummy table in the server. The tutorial exercise below show... 2018-04-12, 2547🔥, 0💬

Show All Indexes of a given Table in MySQL
How To Get a List of Indexes of a Given Table in MySQL? If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutorial script below shows you a nice example: mysql&gt; SHOW ... 2018-02-14, 2544🔥, 0💬

Giving Privileges at Server Level in MySQL
How To Grant User Privileges at the Global Level in MySQL? If you want to grant a user privilege at the global level, you can use the "GRANT privilegeName ON *.* TO userName" command. The argument "*.*" in the command stands for all database and all tables. The following tutorial exercise shows you ... 2017-08-21, 2543🔥, 0💬

Experiment with Data Locks in MySQL
How To Experiment Data Locks in MySQL? If you want to have some experience with data locks, you can create two windows running two mysql transactions in two sessions. In session 1, you can run a UPDATE statement with REPEATABLE READ transaction isolation level to create an exclusive lock. Before com... 2017-04-28, 2542🔥, 0💬

Numeric Data Types in MySQL
What Are Numeric Data Types in MySQL? MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. MEDIUMINT - A medium integer stored... 2018-01-19, 2539🔥, 0💬

Using Table Alias Names in MySQL
How To Define and Use Table Alias Names in MySQL? When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: mysql&gt; SELECT l.id, l.url, r.comment FROM fyi_links l INNER JOIN fyi_rates ... 2017-12-31, 2537🔥, 0💬

What Is Row in MySQL
What Is Row in MySQL? A row is a unit of data with related data items stored as one item in one column in a table.   ⇒ What Is Primary key in MySQL ⇐ What Is Column in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-15, 2535🔥, 0💬

Use "mysql" to Run SQL Statements in MySQL
How To Use "mysql" to Run SQL Statements in MySQL? If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to run two SQL statements with "mysql": &gt;cd \mysql... 2018-02-28, 2531🔥, 0💬

What Is Primary key in MySQL
What Is Primary Key in MySQL? A primary key is a single column or multiple columns defined to have unique values that can be used as row identifications.   ⇒ What Is Foreign Key in MySQL ⇐ What Is Row in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 2531🔥, 0💬

Using IN Conditions in MySQL
How To Use IN Conditions in MySQL? An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the tutorial exercise below: SELECT 3 IN (1,2,3,4,5) FROM DUAL; 1 SELECT 3 NOT IN (1,2,3,4,5) FRO... 2018-03-28, 2528🔥, 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, 2525🔥, 0💬

<< < … 3 4 5 6 7 8 9 10 11 12 13 … > >>   ∑:380  Sort:Date

General MySQL Oracle SQL Server