<< < 26 27 28 29 30 31 32 33 34 35 > >>   Sort: Date

What are 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-03-24, 413👍, 0💬

Returning the Second 5 Rows from a Query in SQL Server
How To Return the Second 5 Rows in SQL Server? If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. If you are using MySQL server, you can use the "LIMIT startRo...
2016-10-29, 413👍, 0💬

Enter a New Row Interactively in Oracle
How To Enter a New Row into a Table Interactively in Oracle? If you don't like to use the INSERT statement to enter a new row into a table, you can use the object view to enter it interactively. Follow the steps below to enter new row into table TIP: Double-click on the table name TIP. Click the Dat...
2018-10-08, 412👍, 0💬

Pass a Parameter to a Cursor in Oracle
How To Pass a Parameter to a Cursor in Oracle? When you define a cursor, you can set a formal parameter in the cursor. The formal parameter will be replaced by an actual parameter in the OPEN cursor statement. Here is a good example of a cursor with two parameters: CREATE OR REPLACE PROCEDURE FYI_CE...
2018-07-18, 412👍, 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, 412👍, 0💬

Testing DML Triggers in SQL Server
How To Test a DML Trigger in SQL Server? To test a DML trigger defined on a table, you just need to execute several INSERT, UPDATE and DELETE statements on that table as shown in this tutorial example: USE FyiCenterData; GO INSERT INTO fyi_users (name) VALUES ('FYI Admin'); GO Records are inserted, ...
2016-10-25, 412👍, 0💬

Insert Multiple Rows with 1 INSERT Statement in MySQL
How To Insert Multiple Rows with One INSERT Statement in MySQL? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good exa...
2018-01-16, 411👍, 0💬

Creating a Large Table with Random Data for Indexes in SQL Server
How To Create a Large Table with Random Data for Index Testing in SQL Server? If you want to see how index can be used to improve data search performance, you have to build some large tables, which requires large amount of random data. This tutorial exercise helps you to build a large table with pur...
2016-11-13, 411👍, 0💬

What Is a SELECT Query Statement in SQL Server
What Is a SELECT Query Statement in SQL Server? The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. SELECT statements allows you to retrieve data from one or more tables or views, with different selection criteria, groupi...
2016-10-26, 411👍, 0💬

Define an Anonymous Block in Oracle
How To Define an Anonymous Block in Oracle? An anonymous block must have an execution part, which is a group of other PL/SQL statements enclosed in the BEGIN ... END statement. Here is a script on how to define a simple anonymous block with SQL*Plus: SQL&gt; set serveroutput on; SQL&gt; begi...
2018-10-30, 410👍, 0💬

Entering Microseconds in SQL Statements in MySQL
How To Enter Microseconds in SQL Statements in MySQL? If you want to enter microseconds in a SQL statements, you can enter them right after the time string as a 6-digit number delimited with '.'. '0' will be padded to right if not enough digits. Here are some good examples: SELECT TIME('1997/01/31 0...
2017-12-26, 410👍, 0💬

"ALTER LOGIN" - Disabling a Login Name in SQL Server
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use the "ALTER LOGIN" statement with a DISABLE keyword. If you want to enable it later on, you can use the ENABLE keyword. The tutorial exercise below shows how to disable and enable login name "Dba_Logi...
2016-10-19, 410👍, 0💬

Types of Table Joins in MySQL
How To Join Two Tables in a Single Query in MySQL? Two tables can be joined together in a query in 4 ways: Inner Join: Returns only rows from both tables that satisfy the join condition. Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the fir...
2017-12-31, 409👍, 0💬

"INSERT" and "UPDATE" Statements - Inserting and Updating Data In Tables in SQL Server
How to insert and update data into a table with "INSERT" and "UPDATE" statements in SQL Server? This is the third tutorial of a quick lesson on creating database objects with Transact-SQL statements. This lesson shows you how to create a database, create a table in the database, and then access and ...
2016-12-02, 409👍, 0💬

"CREATE DATABASE" Statement - Creating New Databases in SQL Server
How to create new databases with "CREATE DATABASE" statements in SQL Server? This is the first tutorial of a quick lesson on creating database objects with Transact-SQL statements. This lesson shows you how to create a database, create a table in the database, and then access and change the data in ...
2016-12-02, 409👍, 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, 408👍, 0💬

UPDATE Using Data from Other Tables in MySQL
How To Use Values from Other Tables in UPDATE Statements in MySQL? If you want to update values in one table with values from another table, you can use a subquery as an expression in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE clau...
2018-01-13, 408👍, 0💬

Measuring Performance of INSERT Statements in SQL Server
How To Measure Performance of INSERT Statements in SQL Server? When indexes are defined for a table, each time a new row is inserted to the table, all the indexes must be updated. This extra update work could slow down the insert statement. To find out how much slower the INSERT statements will be o...
2016-11-13, 408👍, 0💬

Writing Inner Joins with the WHERE Clause in SQL Server
How To Write an Inner Join with the WHERE Clause in SQL Server? 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: SELECT l.id, l.url, r.comment FROM fyi_links l, fyi_rates r WHERE ...
2016-10-29, 408👍, 0💬

Creating a New Table in a Given Schema in SQL Server
How To Create a New Table in a Given Schema in SQL Server? When you create a new table, you can specify in which schema you want this table to be located by prefixing the table name with the schema name. In the tutorial example below, a new table "test" is created in schema "fyi": USE FyiCenterData;...
2016-10-22, 408👍, 0💬

Pass Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle? Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQL&gt; CREATE OR REPLACE PROC...
2018-11-11, 407👍, 0💬

Run the Anonymous Block Again in Oracle
How To Run the Anonymous Block Again in Oracle? If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script: SQL&gt; set serveroutput on; SQL&gt; begin 2 dbms_output.put_line('This is a PL/SQL FAQ.'); 3 end; 4 / Th...
2018-10-30, 407👍, 0💬

Scope of Local Variables in Oracle
What Is the Scope of a Local Variable in Oracle? The scope of a variable can be described with these rules: A variable is valid within the procedure or function where it is defined. A variable is also valid inside a sub procedure or function defined. If a variable name is collided with another varia...
2018-10-13, 407👍, 0💬

Retrieve Field Values from RECORD Variables in Oracle
How To Retrieve Values from Data Fields in RECORD Variables in Oracle? If a variable is a RECORD variable with data fields assigned values, you can retrieve those values out of its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script showing...
2018-09-01, 407👍, 0💬

<< < 26 27 28 29 30 31 32 33 34 35 > >>   Sort: Date