.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

<< < … 123 124 125 126 127 128 129 130 131 132 133 … > >>   Sort: Rank

How To Enter Microseconds in SQL Statements
How To Enter Microseconds in SQL Statements? - MySQL FAQs - Introduction to SQL Date and Time Handling If you want to enter microseconds in a SQL statements, you can enter them right after the time string as a 6-digit number delimited with '.'. '0' will be padded to right if not enough digits. Here ... 2007-05-11, 9298👍, 0💬

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, 5214👍, 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, 5190👍, 0💬

How To Escape Special Characters in SQL statements
How To Escape Special Characters in SQL statements? - MySQL FAQs - Introduction to SQL Basics There are a number of special characters that needs to be escaped (protected), if you want to include them in a character string. Here are some basic character escaping rules: The escape character (\) needs... 2007-05-11, 8070👍, 0💬

How To Present a Past Time in Hours, Minutes and Seconds
How To Present a Past Time in Hours, Minutes and Seconds? - MySQL FAQs - Introduction to SQL Date and Time Handling If you want show an article was posted "n hours n minutes and n seconds ago", you can use the TIMEDIFF(NOW(), pastTime) function as shown in the following tutorial exercise: SELECT TIM... 2007-05-11, 5334👍, 0💬

How To Include Numeric Values in SQL statements
How To Include Numeric Values in SQL statements? - MySQL FAQs - Introduction to SQL Basics If you want to include a numeric value in your SQL statement, you can enter it directly as shown in the following examples: SELECT 255 FROM DUAL; -- An integer 255 SELECT -6.34 FROM DUAL; -- A regular number -... 2007-05-11, 6135👍, 0💬

How To Convert Character Strings to Dates
How To Convert Character Strings to Dates? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a character string that represents a date, and you want to convert it into a date value, you can use the STR_TO_DATE(string, format) function. STR_TO_DATE() shares the same formatting cod... 2007-05-11, 6412👍, 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, 5197👍, 0💬

How To Create Table Borders
How To Create Table Borders? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells There are two sets of borders within a table: Outer Borders - Borders that around the outer edges of the table. Inner Borders - Borders between table cells. If you want to create table outer borders and inner b... 2007-05-11, 5822👍, 0💬

How To Calculate the Difference between Two Time Values
How To Calculate the Difference between Two Time Values? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have two time values, and you want to know the time difference between them, you can use the TIMEDIFF(time1, time2) function as shown below: SELECT TIMEDIFF(TIME('19:26:50'), TIM... 2007-05-11, 5627👍, 0💬

How To Use Regular Expression in Pattern Match Conditions
How To Use Regular Expression in Pattern Match Conditions? - MySQL FAQs - Introduction to SQL Basics If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern condition: REGEXP. The following tutorial exercise provides you some good examples: SELECT 'FY... 2007-05-11, 5339👍, 0💬

How To Extract a Unit Value from a Date and Time
How To Extract a Unit Value from a Date and Time? - MySQL FAQs - Introduction to SQL Date and Time Handling If you want to extract a specific date or time unit value out of a date or a time, you can use the EXTRACT(unit FROM expression) function. The tutorial exercise below gives you some good examp... 2007-05-11, 5254👍, 0💬

How To Convert Dates to Character Strings
How To Convert Dates to Character Strings? - MySQL FAQs - Introduction to SQL Date and Time Handling You can convert dates to character strings using the DATE_FORMAT(date, format) function. MySQL supports the following basic formatting codes: %a Abbreviated weekday name (Sun..Sat) %b Abbreviated mon... 2007-05-11, 5906👍, 0💬

What Happens If NULL Values Are Involved in Expressions
What Happens If NULL Values Are Involved in Expressions? - MySQL FAQs - Introduction to SQL Basics If NULL values are used in expressions, the resulting values will be NULL values. In other words: Arithmetic expressions with NULL values result NULL values. Comparison expressions with NULL values res... 2007-05-11, 5444👍, 0💬

How To Enter Binary Numbers in SQL Statements
How To Enter Binary Numbers in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want to enter character strings or numeric values as binary numbers, you can quote binary numbers with single quotes and a prefix of (B), or just prefix binary numbers with (0b). Binary numbers will be au... 2007-05-11, 10662👍, 0💬

How To Add a New Column to an Existing Table
How To Add a New Column to an Existing Table? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements If you have an existing table with existing data rows, and want to add a new column to that table, you can use the "ALTER TABLE ... ADD COLUMN" statement. The tutorial script below shows ... 2007-05-11, 5527👍, 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, 5127👍, 0💬

How To Write Date and Time Literals
How To Write Date and Time Literals? - MySQL FAQs - Introduction to SQL Date and Time Handling MySQL offers a number of formats for you to use to enter date and time literals: ANSI standard format: "YYYY-MM-DD HH:MM:SS". Non-standard limiters. Like: "YYYY/MM/DD HH^MM^SS" or "YYYY.MM.DD HH-MM-SS". No... 2007-05-11, 5486👍, 0💬

How To Concatenate Two Character Strings
How To Concatenate Two Character Strings? - MySQL FAQs - Introduction to SQL Basics If you want concatenate multiple character strings into one, you need to use the CONCAT() function. Here are some good examples: SELECT CONCAT('Welcome',' to') FROM DUAL; Welcome to SELECT CONCAT('FYI','center','.com... 2007-05-11, 11972👍, 0💬

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

How To Enter Characters as HEX Numbers
How To Enter Characters as HEX Numbers? - MySQL FAQs - Introduction to SQL Basics If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a charact... 2007-05-11, 7526👍, 0💬

What Are Date and Time Functions
What Are Date and Time Functions? - MySQL FAQs - Introduction to SQL Date and Time Handling MySQL offers a number of functions for date and time values: ADDDATE(date, INTERVAL expr unit) - Adding days to a date. Same as DATE_ADD(). ADDTIME(time1, time2) - Adding two time values together. CURDATE() -... 2007-05-11, 5424👍, 0💬

What Are Date and Time Intervals
What Are Date and Time Intervals? - MySQL FAQs - Introduction to SQL Date and Time Handling A date and time interval is special value to be used to increment or decrement a date or a time at a given date or time unit. A data and time interval should be expression in the format of "INTERVAL expressio... 2007-05-11, 5396👍, 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, 4909👍, 0💬

<< < … 123 124 125 126 127 128 129 130 131 132 133 … > >>   Sort: Rank

.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