Oracle Database Tutorials
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for Oracle DBAs and Oracle database application developers. Clear explanations and simple examples provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether yo... 2017-07-10, 2763👍, 2💬
What Is Union in MySQL
What Is Union in MySQL? Join is data retrieval operation that combines multiple query outputs of the same structure into a single output. ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials 2017-07-07, 348👍, 0💬
What Is ISAM in MySQL
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes. ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials 2017-07-03, 366👍, 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. ⇒Database Basics and Terminologies in MySQL ... 2017-07-03, 358👍, 0💬
What Is InnoDB in MySQL
What Is InnoDB in MySQL? InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now). ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials 2017-07-03, 351👍, 0💬
What Is BDB in MySQL
What Is BDB (BerkeleyDB) in MySQL? BDB (BerkeleyDB) is transaction safe storage engine originally developed at U.C. Berkeley. It is now developed by Sleepycat Software, Inc. (an Oracle company now). ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials 2017-07-03, 332👍, 0💬
Breaking Query Output into Pages in MySQL
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, and you don't want to present all of them to your users on a single page. You can break output into multiple pages, and only present 10 rows per page like what Google Website is doing. To do this, you n... 2017-06-28, 397👍, 0💬
Looping through Query Output Rows in MySQL
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, and loop through the result with the mysql_fetch_assoc() func... 2017-06-28, 385👍, 0💬
Updating Existing Rows in MySQL
How To Update Existing Rows in a Table in MySQL? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: <?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET ... 2017-06-28, 385👍, 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, 361👍, 0💬
Deleting Existing Rows in MySQL
How To Delete Existing Rows in a Table in MySQL? If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: <?php include "mysql_connection.php"; $sql = "DELETE FROM fyi_links WHERE id = 1102... 2017-06-28, 343👍, 0💬
Dispaly Part Time in Days, Hours and Minutes in MySQL
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the TIMEDIFF() SQL function. Note that the TIMEDIFF() function can only handle time range within 839 hou... 2017-06-23, 477👍, 0💬
Query Multiple Tables Jointly in MySQL
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, and ... 2017-06-23, 387👍, 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, 367👍, 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, 345👍, 0💬
Key Word Search in Tables in MySQL
How To Perform Key Word Search in Tables in MySQL? The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as '%keyword%', where (%) represents any number ... 2017-06-23, 293👍, 0💬
Is SQL Server Transact-SQL Case Sensitive?
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard SQL, you can type in your Transact-SQL statement in upper case or lower case. However, you should use upper case for all key words in Transact-SQL statements as a best practice. The following example... 2017-06-16, 405👍, 0💬
What Is SQL Language
What Is SQL Language? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). During the 1970s, a group at IBM's San Jose research center developed a database system "System R" based upon Codd's model. Structured English Query Language ("SEQ... 2017-06-16, 386👍, 0💬
General Questions on Microsoft SQL Server Transact-SQL
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transact-SQL? I am new to Transact-SQL. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team in general areas of Microsoft SQL Server Transact-SQL: What Is SQL Langua... 2017-06-16, 375👍, 0💬
Versions of SQL Server Transact-SQL
How do I tell what version of Transact-SQL my SQL Server is using? The Transact-SQL version is the same as the SQL Server. You can determine the SQL Server version using the following Transact-SQL statement: SELECT @@version ------------------------------ ------------------------------ ------------Mi... 2017-06-16, 365👍, 0💬
What Is SQL Server Transact-SQL (T-SQL)?
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension of the standard SQL (Structured Query Language). Transact-SQL was developed by Microsoft and Sybase. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in ... 2017-06-16, 361👍, 0💬
Statement Batch in SQL Server Transact-SQL
What is statement batch in SQL Server Transact-SQL? A statement batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The st... 2017-05-29, 404👍, 0💬
Comments in SQL Server Transact-SQL Statements
How to enter comments in SQL Server Transact-SQL statements? There are 2 ways to enter comments within Transact-SQL statements: Starting comments with two dashes "--": Everything between "--" and the end of the line is treated as a comment. Entering comments between "/*" and "*/": Everything between... 2017-05-29, 402👍, 0💬
What Is a Statement in SQL Server Transact-SQL
What is a statement in SQL Server Transact-SQL? A statement in SQL Server Transact-SQL is a single smallest execution unit. Here are some examples of Transact-SQL statements: "PRINT 'Hello World!';" - An output statement that print a character string to the console. "SELECT GETDATE();" - A query sta... 2017-05-29, 382👍, 0💬
Start and End of Statement in SQL Server Transact-SQL
How to start and end a statement in SQL Server Transact-SQL? Here are some simple rules about writing statements in SQL Server Transact-SQL: A Transact-SQL statement must be started with a pre-defined statement keyword. A Transact-SQL statement must be ended with a new line (/n) or a semicolon (;) c... 2017-05-29, 375👍, 0💬
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...