<< < 125 126 127 128 129 130 131 132 133 134 135 > >>   Sort: Rank

What Happens If One Row Has Missing Columns
What Happens If One Row Has Missing Columns? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells What happens if one row has missing columns? Most browsers will provide empty columns to the end of the row to make up the missing columns. For example, if your XHTML document has a table with t...
2007-05-11, 7074👍, 0💬

How To Control Vertical Alignment
How To Control Vertical Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By default, text in all table cells are aligned to the top vertically. If you want to control vertical alignment yourself, you need to use the "valign" attribute in a "tr" element or a "td" element: &...
2007-05-11, 10963👍, 0💬

How To Add Column Headers to a Table
How To Add Column Headers to a Table? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you want to add column headers to a table, you need to use "th" elements instead of "td" elements in the first row of the table. "th" elements are displayed in bold and centered by default. Below is...
2007-05-11, 7402👍, 0💬

How To Merge Cells in a Column
How To Merge Cells in a Column? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you want to merge multiple cells vertically in a row, you need to use the "rowspan" attribute of in a "td" element. "rowspan" allows you to specify how many cells you want to merge into this cell vertical...
2007-05-11, 7778👍, 0💬

How To Control Horizontal Alignment
How To Control Horizontal Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By default, text in all table cells are aligned to the left horizontally. If you want to control horizontal alignment yourself, you need to use the "align" attribute in a "tr" element or a "td" element:...
2007-05-11, 8310👍, 0💬

What Is a CAPTION Tag/Element
What Is a CAPTION Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "caption" element is an inline element that you can use to define the caption text of a table. Browsers will display caption above the table and aligned to the center. Here are basic rules about "caption" e...
2007-05-11, 10846👍, 0💬

How To Merge Cells in a Row
How To Merge Cells in a Row? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you want to merge multiple cells horizontally in a row, you need to use the "colspan" attribute of in a "td" element. "colspan" allows you to specify how many cells you want to merge into this cell horizonta...
2007-05-11, 8960👍, 0💬

How To Control Table Widths
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, browsers will calculate the table width based on the content widths of table cells. If you want to control the width of a table, you need to use the "width" attribute, which allows you to set the table...
2007-05-11, 7529👍, 0💬

How To Properly Shutdown MySQL Server Daemon mysqld
How To Properly Shutdown MySQL Server Daemon mysqld? - MySQL FAQs - Server Daemon mysqld Administration The proper way to shutdown your MySQL server is to the use "mysqladmin shutdown" command. Other ways to shutdown your server include: Enter "mysqladmin -u root -ppassowrd shutdown" command with op...
2007-05-11, 5302👍, 0💬

How To Quote Date and Time Values in SQL Statements
How To Quote Date and Time Values in SQL Statements? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts 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 exerc...
2007-05-11, 6078👍, 0💬

What Are the Differences between BINARY and VARBINARY
What Are the Differences between BINARY and VARBINARY? - MySQL FAQs - Introduction to SQL Basics Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in va...
2007-05-11, 5186👍, 0💬

How To Connect to MySQL Server on a Different Port
How To Connect to MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise...
2007-05-11, 5125👍, 0💬

How To Build WHERE Criteria with Web Form Search Fields
How To Build WHERE Criteria with Web Form Search Fields? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts 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...
2007-05-11, 7558👍, 0💬

What Are the Differences between CHAR and VARCHAR
What Are the Differences between CHAR and VARCHAR? - MySQL FAQs - Introduction to SQL Basics CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences: CHAR stores values in fixed lengths. Values are padded with space characters to match the speci...
2007-05-11, 5236👍, 0💬

How To Display a Past Time in Days, Hours and Minutes
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts 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 TI...
2007-05-11, 7393👍, 0💬

What Tools Available for Managing MySQL Server
What Tools Available for Managing MySQL Server? - MySQL FAQs - Administrator Tools for Managing MySQL Server MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin ...
2007-05-11, 5221👍, 0💬

How To Load Data Files into Tables with "mysqlimport"
How To Load Data Files into Tables with "mysqlimport"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to load a data file directly into a table, you need to prepare the data file as one line per data row, and use tab character as the column delimiter. The data file name sho...
2007-05-11, 5168👍, 0💬

What Are the Differences between CHAR and NCHAR
What Are the Differences between CHAR and NCHAR? - MySQL FAQs - Introduction to SQL Basics Both CHAR and NCHAR are fixed length string data types. But they have the following differences: CHAR's full name is CHARACTER. NCHAR's full name is NATIONAL CHARACTER. By default, CHAR uses ASCII character se...
2007-05-11, 5433👍, 0💬

How To Dump a Table to a File with "mysqldump"
How To Dump a Table to a File with "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to dump all rows in a table from the server to a file, you can use "mysqldump" with the "-f fileName" option as show in the following tutorial exercise: >cd \mysql\bin >mysqldump ...
2007-05-11, 5400👍, 0💬

How To Shut Down the Server with "mysqladmin"
How To Shut Down the Server with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to shut down the server with "mysqladmin", you can use the command "mysqladmin shutdown" as shown in the following tutorial example: >cd \mysql\bin >mysqladmin -u root shutdown If ...
2007-05-11, 5585👍, 0💬

How To Run MySQL Server on a Different Port
How To Run MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start t...
2007-05-11, 5261👍, 0💬

How To Check Server Status with "mysqladmin"
How To Check Server Status with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to check the server status by with "mysqladmin", you can following this tutorial example: >cd \mysql\bin >mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries:...
2007-05-11, 5230👍, 0💬

How To Use mysqlbinlog to View Binary Logs
How To Use mysqlbinlog to View Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration If you have binary logs turned on, you can use "mysqlbinlog" to view the binary log files. The tutorial exercise below shows you how to view two binary files together: >cd \mysql\bin >mysql -u root -pretne...
2007-05-11, 8046👍, 0💬

How To Quote Text Values in SQL Statements
How To Quote Text Values in SQL Statements? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts 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...
2007-05-11, 5791👍, 0💬

<< < 125 126 127 128 129 130 131 132 133 134 135 > >>   Sort: Rank