General MySQL Oracle SQL Server

<< < … 33 34 35 36 37 38 39 40 41 42 43 … > >>   ∑:1363  Sort:Date

What Is a Table in SQL Server
What is a table in SQL Server? A table in database is a data object used to store data. Tables have the following features: Data is stored in a table with a structure of rows and columns. Columns must be pre-defined with names, types and constrains. A table object may have other associated data obje... 2016-11-20, 3043🔥, 0💬

Database Basics and Terminologies in MySQL
Where to find answers to frequently asked questions on Database Basics and Terminologies in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Database Basics and Terminologies in MySQL to help you review your knowledge. A short answer is prov... 2017-07-21, 3042🔥, 0💬

Enabling TCP/IP Protocol on a SQL Server
How To Enable TCP/IP Protocol on a SQL Server? By default, the TCP/IP protocol is turned off when a SQL Server is installed to reduce security risk. But if you want applications to connect and access the SQL Server, you need to enable the TCP/IP protocol on the server by following this tutorial: 1. ... 2024-07-25, 3041🔥, 0💬

Create a Single Index for Multiple Columns in Oracle
How To Create a Single Index for Multiple Columns in Oracle? If you know a group of multiple columns will be always used together as search criteria, you should create a single index for that group of columns with the "ON table_name(col1, col2, ...)" clause. Here is an example of one index for two c... 2019-04-17, 3040🔥, 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, 3040🔥, 0💬

Ways to Start MySQL Server in MySQL
How To Start MySQL Server Daemon mysqld in MySQL? There are a number of ways to start MySQL server daemon, mysqld: Double click on the file name, mysqld.exe, in a file explorer window. This is an easy way to start the server. But you will not be able to specify any command line options. Enter "mysql... 2017-12-04, 3040🔥, 0💬

Use an Explicit Cursor without OPEN Statements in Oracle
How To Use an Explicit Cursor without OPEN Statements in Oracle? If you want to open a cursor and loop through its data rows in quick way, you can use the FOR ... IN ... LOOP statement in the same way as the implicit cursor. The following tutorial exercise gives you a good example: CREATE OR REPLACE... 2018-04-07, 3039🔥, 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, 3038🔥, 0💬

Creating Triggers for INSERT Statements Only in SQL Server
How To Create a Trigger for INSERT Only in SQL Server? The trigger, dml_message, provided in previous tutorials was defined to handle all 3 types of DML statements, INSERT, UPDATE, and DELETE. If you do not want the trigger to handle all 3 types of DML statements, you can list only 1 or 2 of the sta... 2016-10-24, 3038🔥, 0💬

Defining the Name and Server for a new DSN
How To Define the Name and Server for a new DSN? Continuing from the previous tutorial, on the first screen of the "Create a New Data Source to SQL Server" wizard, you should enter 3 fields: Name, Description, and Server as suggested below: Name: FYI_SQL_SERVER Description: FYIcenter.com SQL Server ... 2024-08-06, 3037🔥, 0💬

Install Oracle SQL Developer in Oracle
How To Install Oracle SQL Developer in Oracle? Once you have sqldeveloper-v1.0.0.zip downloaded, extract the zip file into the root directory: \. When the extraction is done, the installation is completed. Your copy of Oracle SQL Developer is installed in directory: \sqldeveloper, and ready to run. ... 2019-02-05, 3037🔥, 0💬

Install Oracle SQL Developer in Oracle
How To Install Oracle SQL Developer in Oracle? Once you have sqldeveloper-v1.0.0.zip downloaded, extract the zip file into the root directory: \. When the extraction is done, the installation is completed. Your copy of Oracle SQL Developer is installed in directory: \sqldeveloper, and ready to run. ... 2019-02-05, 3037🔥, 0💬

Use DML Statements in PL/SQL in Oracle
Can DML Statements Be Used in PL/SQL in Oracle? Yes, you can run almost any DML statements in PL/SQL directly. To manipulate Oracle database data you can include INSERT, UPDATE, and DELETE statements, directly in PL/SQL programs, without any special notation, as shown in the following sample code: (... 2018-10-13, 3037🔥, 0💬

Arithmetic Operations in Pl/SQL in Oracle
What Are the Arithmetic Operations in Oracle? There are 4 basic arithmetic operations on numeric values as shown in the following sample script: PROCEDURE proc_arithmetic AS addition NUMBER; subtraction NUMBER; multiplication NUMBER; division NUMBER; BEGIN addition := 7 + 8; subtraction := addition ... 2018-08-06, 3037🔥, 0💬

Turn on Error Logs in MySQL
How To Turn on Error Logs in MySQL? If you want MySQL to write critical errors into a log file, you can use the "--log-error=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: &gt;cd \mysql\bin &gt;mkdir \mysql\logs ... 2017-11-29, 3037🔥, 0💬

Tables Using InnoDB Storage Engine in MySQL
How To Create a New Table Using the InnoDB Storage Engine in MySQL? InnoDB storage engine was developed by Innobase Oy, which is an Oracle company now. InnoDB is transaction safe, and has been used by a number of large Websites, like Slashdot.org. InnoDB is not the default storage engine. You need t... 2017-09-01, 3036🔥, 0💬

Experiments of Data Locks in Oracle
How To Experiment a Data Lock in Oracle? If you want to have some experience with data locks, you can create two windows running two SQL*Plus sessions. In session 1, you can run a UPDATE statements to create a data lock. Before committing session 2, switch to session 2, and run a UPDATE statements o... 2019-08-08, 3035🔥, 0💬

Update Column Values on Multiple Rows in MySQL
How To Update Column Values on Multiple Rows in MySQL? If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good example: mysql&gt; UPDATE fyi_lin... 2018-01-13, 3035🔥, 0💬

Importance of Column Order in the SET Clause in Update Statements in SQL Server
Is the Order of Columns in the SET Clause Important in SQL Server? The answer is NO. The order of columns in the SET clause of the UPDATE statement is NOT important. You probably already noticed from the previous tutorial. There is a BIG DIFFERENCE among SQL Server, MySQL and Oracle on update multip... 2016-11-02, 3034🔥, 0💬

List All Tables with "mysql" Command in MySQL
How To Show All Tables with "mysql" in MySQL? If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example: &gt;cd \mysql\bin &gt;mysql -u root test Welcome to the MySQL monitor. Commands end... 2018-02-28, 3033🔥, 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, 3032🔥, 0💬

What Is Commit in MySQL
What Is Commit in MySQL? Commit is a way to terminate a transaction with all database changes to be saved permanently to the database server.   ⇒ What Is RollBack in MySQL ⇐ What Is Transaction in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2016-10-16, 3032🔥, 0💬

Use Subqueries in the FROM Clause in Oracle
How To Use Subqueries in the FROM Clause in Oracle? If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. The following statement shows you how to use a subquery as base ... 2019-09-27, 3031🔥, 0💬

Start Oracle SQL Developer in Oracle
How To Start Oracle SQL Developer in Oracle? To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connections icon, because you haven't defined any conne... 2019-02-05, 3031🔥, 0💬

<< < … 33 34 35 36 37 38 39 40 41 42 43 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server