<< < 6 7 8 9 10 11 12 13 > >>   Sort: Rank

What Is Rollback
What Is Rollback? - MySQL FAQs - Database Basics and Terminologies Rollback is a way to terminate a transaction with all database changes not saving to the database server.
2007-05-10, 5684👍, 0💬

What Is Commit
What Is Commit? - MySQL FAQs - Database Basics and Terminologies Commit is a way to terminate a transaction with all database changes to be saved permanently to the database server.
2007-05-10, 5491👍, 0💬

What Is Column
What Is Column? - MySQL FAQs - Database Basics and Terminologies A column defines one piece of data stored in all rows of the table.
2007-05-10, 5081👍, 0💬

What Is Primary Key
What Is Primary Key? - MySQL FAQs - Database Basics and Terminologies A primary key is a single column or multiple columns defined to have unique values that can be used as row identifications.
2007-05-10, 5595👍, 0💬

How To Shutdown MySQL Server
How To Shutdown MySQL Server? - MySQL FAQs - Downloading and Installing MySQL on Windows If you want to shutdown your MySQL server, you can run the "mysqladmin" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqladmin shutdown
2007-05-10, 4611👍, 0💬

What Is MyISAM
What Is MyISAM? - MySQL FAQs - Database Basics and Terminologies 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.
2007-05-10, 5175👍, 0💬

What Is Index
What Is Index? - MySQL FAQs - Database Basics and Terminologies An index is a single column or multiple columns defined to have values pre-sorted to speed up data retrieval speed.
2007-05-10, 5084👍, 0💬

What Is Table
What Is Table? - MySQL FAQs - Database Basics and Terminologies A table is a data storage structure with rows and columns.
2007-05-10, 5153👍, 0💬

What Is Union
What Is Union? - MySQL FAQs - Database Basics and Terminologies Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.
2007-05-10, 5112👍, 0💬

What Is ISAM
What Is ISAM? - MySQL FAQs - Database Basics and Terminologies ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.
2007-05-10, 5359👍, 0💬

What Is Join
What Is Join? - MySQL FAQs - Database Basics and Terminologies Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.
2007-05-10, 5151👍, 0💬

What Is View
What Is View? - MySQL FAQs - Database Basics and Terminologies A view is a logical table defined by a query statement.
2007-05-10, 5096👍, 0💬

What Is CSV
What Is CSV? - MySQL FAQs - Database Basics and Terminologies 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.
2007-05-10, 5303👍, 0💬

What Is Row
What Is Row? - MySQL FAQs - Database Basics and Terminologies A row is a unit of data with related data items stored as one item in one column in a table.
2007-05-10, 5022👍, 0💬

How Many SQL DML Commands Are Supported by "mysql"
How Many SQL DML Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are 4 SQL Data Manipulation Language (DML) commands that are supported by "mysql". They are listed below with short descriptions: "INSERT INTO tableName ..." - Inserts new data rows into th...
2007-05-10, 4455👍, 0💬

How To Get Help Information from the Server
How To Get Help Information from the Server? - MySQL FAQs - Command-Line End User Interface mysql While you are at the "mysql>" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows sevearal examples: >cd \mysql\bin >mysql -u root mysql> ...
2007-05-10, 4663👍, 0💬

How To Run "mysql" Commands from a Batch File
How To Run "mysql" Commands from a Batch File? - MySQL FAQs - Command-Line End User Interface mysql If you have group of "mysql" commands that need to be executed repeatedly, you can put them into a file, and run them from the file in "mysql" batch mode. Here is a batch file, \temp\links.sql, contai...
2007-05-10, 6833👍, 0💬

How To Return Query Output in XML Format
How To Return Query Output in XML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: >cd \mysql\bin >...
2007-05-10, 4708👍, 0💬

What Is MySQL
What Is MySQL? - MySQL FAQs - Database Basics and Terminologies MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com.
2007-05-10, 4792👍, 0💬

What Is mSQL
What Is mSQL? - MySQL FAQs - Database Basics and Terminologies Mini SQL (mSQL) is a light weight relational database management system capable of providing rapid access to your data with very little overhead. mSQL is developed by Hughes Technologies Pty Ltd. MySQL was started from mSQL and shared th...
2007-05-10, 4818👍, 0💬

What Are the "mysql" Command Line Arguments
What Are the "mysql" Command Line Arguments? - MySQL FAQs - Command-Line End User Interface mysql "mysql" supports only one optional command line argument, "database". But "mysql" allows the operating system to redirect input and output streams at the command line level. Here are some good examples:...
2007-05-10, 5374👍, 0💬

What Is SQL
What Is SQL? - MySQL FAQs - Database Basics and Terminologies SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.
2007-05-10, 4611👍, 0💬

How To Return Query Output in HTML Format
How To Return Query Output in HTML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in HTML format, you need to use the "-H" command option. Here is a good tutorial exercise: >cd \mysql\bin...
2007-05-10, 4703👍, 0💬

What Is the Command Line End User Interface - mysql
What Is the Command Line End User Interface - mysql? - MySQL FAQs - Command-Line End User Interface mysql "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It i...
2007-05-10, 4656👍, 0💬

<< < 6 7 8 9 10 11 12 13 > >>   Sort: Rank