.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < 1 2 3 4 5 >   Sort: Date

How To See the CREATE TABLE Statement of an Existing Table
How To See the CREATE TABLE Statement of an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to know how an existing table was created, you can use the "SHOW CREATE TABLE" command to get a copy of the "CREATE TABLE" statement back on an existing table. T... 2007-05-11, 5149👍, 0💬

What Are Date and Time Data Types
What Are Date and Time Data Types? - MySQL FAQs - Introduction to SQL Basics 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:... 2007-05-11, 5142👍, 0💬

What Are Group Functions
What Are Group Functions? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on each r... 2007-05-11, 5132👍, 0💬

How To Create a New Table by Selecting Rows from Another Table
How To Create a New Table by Selecting Rows from Another Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the "CREATE TABLE ... SEL... 2007-05-11, 5104👍, 0💬

How To Drop an Existing View
How To Drop an Existing View? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing view, and you don't want it anymore, you can delete it by using the "DROP VIEW viewName" statement as shown in the following script: mysql> DROP VIEW faqComment; Query OK, 0 rows ... 2007-05-11, 5100👍, 0💬

Can SELECT Statements Be Used on Views
Can SELECT Statements Be Used on Views? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: mysql> CREATE VIEW myLinks A... 2007-05-11, 5099👍, 0💬

How To Delete an Existing Row from a Table
How To Delete an Existing Row from a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: mysql> INSERT INT... 2007-05-11, 5095👍, 0💬

How To Get a List of Columns in an Existing Table
How To Get a List of Columns in an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing table, but you don't remember what are the columns used in the table, you can use the "SHOW COLUMNS FROM tableName" command to get a list of all columns of th... 2007-05-11, 5094👍, 0💬

How To Insert Multiple Rows with One INSERT Statement
How To Insert Multiple Rows with One INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements 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 t... 2007-05-11, 5089👍, 0💬

How To Get a List of Indexes of an Existing Table
How To Get a List of Indexes of an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutor... 2007-05-11, 5089👍, 0💬

What Are String Data Types
What Are String Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded char... 2007-05-11, 5082👍, 0💬

How Many Groups of Data Types
How Many Groups of Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL support 3 groups of data types as listed below: String Data Types - CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, VARBINARY, TINYBLOB, TINYTEXT, BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT, ENUM, SET Numeric Data Typ... 2007-05-11, 5064👍, 0💬

How To Filter Out Duplications in the Returning Rows
How To Filter Out Duplications in the Returning Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If there are duplications in the returning rows, and you want to remove the duplications, you can use the keyword DISTINCT in the SELECT clause. The DISTINCT applies to the combination of a... 2007-05-11, 5063👍, 0💬

How To Delete an Existing Column in a Table
How To Delete an Existing Column in a Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing column in a table and you do not need that column any more, you can delete it with "ALTER TABLE ... DROP COLUMN" statement. Here is a tutorial script to delete an e... 2007-05-11, 5056👍, 0💬

How To Create a New Table
How To Create a New Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip": mysql> CREATE TABLE tip (id INTEGER PRIMARY KEY, subj... 2007-05-11, 5052👍, 0💬

How To Get a List of All Tables in a Database
How To Get a List of All Tables in a Database? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to see the table you have just created, you can use the "SHOW TABLES" command to get a list of all tables in database. The tutorial script gives you a good example: mysql> SH... 2007-05-11, 5050👍, 0💬

How To Use LIKE Conditions
How To Use LIKE Conditions? - MySQL FAQs - Introduction to SQL Basics A LIKE condition is also called pattern patch. There are 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause i... 2007-05-11, 5041👍, 0💬

How To Join Two Tables in a Single Query
How To Join Two Tables in a Single Query? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries 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 ... 2007-05-11, 4979👍, 0💬

How To Create a Testing Table
How To Create a Testing Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements 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> CREATE TABLE fyi_links (id INTEGER PR... 2007-05-11, 4967👍, 0💬

How To Drop an Existing Table
How To Drop an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to delete an existing table and its data rows, you can use the "DROP TABLE" statement as shown in the tutorial script below: mysql> SELECT * FROM tipBackup; +----+-------------+---------- ---... 2007-05-11, 4953👍, 0💬

How To Rename an Existing Column in a Table
How To Rename an Existing Column in a Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing column in a table and you want to change the column name, you can use the "ALTER TABLE ... CHANGE" statement. This statement allows you to change the name of a colu... 2007-05-11, 4942👍, 0💬

What Is a SELECT Query Statement
What Is a SELECT Query Statement? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. A SELECT statement allows you to retrieve data from one or more tables or view... 2007-05-11, 4896👍, 0💬

How To Rename an Existing Table
How To Rename an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you want to rename an existing table, you can use the "ALTER TABLE ... RENAME TO" statement. The tutorial script below shows you a good example: mysql> ALTER TABLE tip RENAME TO faq; Query OK, 0 ro... 2007-05-11, 4852👍, 0💬

How To Use IN Conditions
How To Use IN Conditions? - MySQL FAQs - Introduction to SQL Basics An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the tutorial exercise below: SELECT 3 IN (1,2,3,4,5) FROM DUAL; ... 2007-05-11, 4814👍, 0💬

<< < 1 2 3 4 5 >   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML