General MySQL Oracle SQL Server

<< < … 42 43 44 45 46 47 48 >   Sort: Rank

"FETCH" - Transferring Data from Cursors to Variables in SQL Server
How To Transfer Data from a Cursor to Variables with a "FETCH" Statement in SQL Server Transact-SQL? By default, a FETCH statement will display the fetched row on the client program window. If you want to transfer the output data to variables, you can specify an INTO clause with a list of variables ... 2016-10-17, 635👍, 0💬

SQL Server Transact-SQL Tutorials
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-SQL? I want to know how to write database scripts to run on SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Microsoft SQL Server Tran... 2016-10-17, 1930👍, 0💬

Turn on and off Autocommit in MySQL
How To Switch between Autocommit-On and Autocommit-Off Modes in MySQL? By default, your connection session will be in Autocommit-On mode, where every server executable statement will start a new transaction, and end the transaction when the execution ends. Changes will be committed. So consider this... 2016-10-17, 797👍, 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, 733👍, 0💬

Rollback the Current Transaction in MySQL
How To Rollback the Current Transaction in MySQL? If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLBACK command. It will remove all the database chan... 2016-10-17, 714👍, 0💬

Ways to Start a New Transaction in MySQL
How To Start a New Transaction in MySQL? MySQL server offers two modes to manage transactions: Autocommit On - Default mode. Can be started with "SET AUTOCOMMIT = 1" command. In this mode, every single SQL statement is a new transaction. All changes will be committed at the end of the statement exec... 2016-10-17, 705👍, 0💬

Transaction Committed when START TRANSACTION Executed in MySQL
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a middle of a current transaction, and a START TRANSACTION command is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become... 2016-10-17, 685👍, 0💬

Commit the Current Transaction in MySQL
How To Commit the Current Transaction in MySQL? If you have used some DML statements updated some data objects, and you want to have the updates to be permanently recorded in the database, you can use the COMMIT command. It will make all the database changes made in the current transaction become pe... 2016-10-17, 684👍, 0💬

Transaction Committed when DDL Statement Executed in MySQL
What Happens to the Current Transaction If a DDL Statement Is Executed in MySQL? If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. This is called an implicit commit by a DDL statement. ... 2016-10-17, 669👍, 0💬

Start a New Transaction Explicitly in MySQL
How To Start a New Transaction Explicitly in MySQL? If you are confused on the implicit new transaction rules, you can always start a new transaction with the "START TRANSACTION" command to start a new transaction explicitly. "START TRANSACTION" command works in both "Autocommit On" and "Autocommit ... 2016-10-17, 667👍, 0💬

Show the Current Transaction Mode in MySQL
How To Find Out the Current Transaction Mode in MySQL? If you are not sure about your current transaction mode, you can use the "SELECT @@AUTOCOMMIT FROM DUAL" statement to find out as shown in the following tutorial exercise: &gt;\mysql\bin\mysql -u dev -piyf fyi mysql&gt; SELECT @@AUTOCOMM... 2016-10-17, 663👍, 0💬

Ways to End the Current Transaction in MySQL
How To End the Current Transaction in MySQL? There are several ways the current transaction can be ended implicitly or explicitly: In "Autocommit On" mode, a single-statement transaction will be ended implicitly when the execution of the statement ends. Changes will be committed. Running the COMMIT ... 2016-10-17, 574👍, 0💬

What Is RollBack in MySQL
What Is Rollback in MySQL? Rollback is a way to terminate a transaction with all database changes not saving to the database server.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials 2016-10-16, 743👍, 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.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials 2016-10-16, 727👍, 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.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials 2016-10-16, 683👍, 0💬

What Is Transaction in MySQL
What Is Transaction in MySQL? A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements... 2016-10-16, 628👍, 0💬

MySQL Database Tutorials
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for MySQL DBA and MySQL database application developers. Clear explanations and sample scripts provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether you are... 2016-10-16, 2037👍, 0💬

What Is a Directory Object in Oracle
What Is a Directory Object in Oracle? A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples: &gt;... 2016-10-15, 827👍, 0💬

Load Data from External Tables in Oracle
How To Load Data from External Tables to Regular Tables in Oracle? Once you have your data entered in a text file, and an external table defined to this text file, you can easily load data from this text file to a regular table. The following tutorial exercise shows you how to load data from the tex... 2016-10-15, 808👍, 0💬

Run Queries on External Tables in Oracle
How To Run Queries on External Tables in Oracle? If you have an external table defined as a text file with the ORACLE_LOADER driver, you can add data to the text file, and query the text file through the external table. By default, data fields in the text file should be terminated by ','. The tutori... 2016-10-15, 798👍, 0💬

Error: Imported Table Already Exists in Oracle
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: &gt;cd \oraclexe\app\oracle\product\1 0.2.0\serve... 2016-10-15, 2095👍, 0💬

Import One Table back from a Dump File in Oracle
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import the "fyi_links" table from a dump file... 2016-10-15, 1328👍, 0💬

Where Is the Export Dump File Located in Oracle
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump directory and locate the dump file.... 2016-10-15, 1124👍, 0💬

Export Your Own Schema in Oracle
How To Export Your Own Schema in Oracle? If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory o... 2016-10-15, 930👍, 0💬

<< < … 42 43 44 45 46 47 48 >   Sort: Rank

General MySQL Oracle SQL Server