<< < 120 121 122 123 124 125 126 127 128 129 130 > >>   Sort: Rank

How To Remove the Top White Space of Your Web Page
How To Remove the Top White Space of Your Web Page? - CSS Tutorials - Introduction To CSS Basics The top white space of your Web page is provided by the browser's default CSS definition of the margin-top property on the BODY tag. You can remove this white space by adding your own margin-top definiti...
2007-05-11, 7313👍, 0💬

What Are the Formatting Behaviors of HTML Elements
What Are the Formatting Behaviors of HTML Elements? - CSS Tutorials - HTML Formatting Model: Block, Inline and Floating Elements From a formatting behavior point of view, HTML elements can be divided into 2 categories: Block Element - Formatted as a rectangular block occupying the entire width of th...
2007-05-11, 4972👍, 0💬

How To Set Different Text Fonts Inside Tables
How To Set Different Text Fonts Inside Tables? - CSS Tutorials - Introduction To CSS Basics If want to set the text font inside tables different than outside tables, you can use CSS definitions with contextual selectors. In the CSS example below, Both selectors "TABLE P" and "P" match those &lt;...
2007-05-11, 5373👍, 0💬

What Is the HTML Element Formatting Model
What Is the HTML Element Formatting Model? - CSS Tutorials - HTML Formatting Model: Block, Inline and Floating Elements An HTML document is divided into HTML elements. Each element is considered as a formatting unit using a box-oriented formatting model, which has: Content Box - A rectangular area f...
2007-05-11, 5009👍, 0💬

What Are the CSS Cascading Order Rules
What Are the CSS Cascading Order Rules? - CSS Tutorials - Introduction To CSS Basics The most important cascading order rules are: A specified CSS definition wins over a default CSS definition in the browser. A CSS definition with a contextual selector wins over a CSS definition with a tag selector....
2007-05-11, 5196👍, 0💬

What Is a Transaction
What Is a Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transac...
2007-05-11, 5144👍, 0💬

What Is Style Property Inheritance
What Is Style Property Inheritance? - CSS Tutorials - Introduction To CSS Basics Style property Inheritance is a rule that allows a style property of a child HTML tag to inherit the same property of the parent HTML tag, if that property is not defined on the child tag. This inheritance rule is very ...
2007-05-11, 5044👍, 0💬

How To Use IDs to Override Classes
How To Use IDs to Override Classes? - CSS Tutorials - Introduction To CSS Basics Class is a nice way to separate a group of tag instances. To identify one or two special instances, you can use the ID attributes and ID selectors. In the CSS example below, the ID selector "P#hot" wins over all other s...
2007-05-11, 5040👍, 0💬

What Is a Block Element
What Is a Block Element? - CSS Tutorials - HTML Formatting Model: Block, Inline and Floating Elements A block element is formatted as a rectangular block occupying the entire width of the parent content box. Examples of block elements are: &lt;P> - A paragraph of text and/or inline elements. &am...
2007-05-11, 5022👍, 0💬

What Is CSS Cascading
What Is CSS Cascading? - CSS Tutorials - Introduction To CSS Basics CSS cascading is another rule that allows multiple definitions on the same style property of the same HTML tag instance. The Web browser will use cascading order rules to determine the winning definition. Multiple definitions of the...
2007-05-11, 5062👍, 0💬

How To Use Different Markers on Ordered List Items
How To Use Different Markers on Ordered List Items? - XHTML 1.0 Tutorials - Understanding Lists and List Items By default, browsers will use decimal numbers as the item markers for ordered lists. If you want to change them to something else, like alphabetical letters, you need to use CSS properties....
2007-05-11, 5169👍, 0💬

How To Use Different Markers on Unordered List Items
How To Use Different Markers on Unordered List Items? - XHTML 1.0 Tutorials - Understanding Lists and List Items By default, browsers will use solid dots as the item markers for unordered lists. If you want to change them to something else, like tiny squares, you need to use CSS properties. Here is ...
2007-05-11, 5327👍, 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, 5012👍, 0💬

How To Omit Columns with Default Values in INSERT Statement
How To Omit Columns with Default Values in INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you c...
2007-05-11, 5842👍, 0💬

How To Select All Columns of All Rows from a Table
How To Select All Columns of All Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY The simplest query statement is the one that selects all columns of all rows from a single table: "SELECT * FROM tableName;". The (*) in the SELECT clause tells the query to return all column...
2007-05-11, 6966👍, 0💬

What Happens If Unique Value Constraints Are Violated
What Happens If Unique Value Constraints Are Violated? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you are inserting a new record that has values violating a unique constraint, you will get an error. Note that primary key column has a unique value constraint by default. ...
2007-05-11, 5385👍, 0💬

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good example: mysql> SELECT COUNT(*) FROM ...
2007-05-11, 5389👍, 0💬

What Happens If the UPDATE Subquery Returns No Rows
What Happens If the UPDATE Subquery Returns No Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, MySQL will provide a NULL value to the SE...
2007-05-11, 5440👍, 0💬

Can Group Functions Be Mixed with Non-group Selection Fields
Can Group Functions Be Mixed with Non-group Selection Fields? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. Th...
2007-05-11, 5730👍, 0💬

Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: mysql> SELECT ...
2007-05-11, 5220👍, 0💬

How To Count Groups Returned with the GROUP BY Clause
How To Count Groups Returned with the GROUP BY Clause? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you use the COUNT(*) function on groups returned with the GROUP BY clause, it will count the number of rows within each group, not the number of groups. If you want to count the nu...
2007-05-11, 5899👍, 0💬

Is the Order of Columns in the SET Clause Important
Is the Order of Columns in the SET Clause Important? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements Yes. The order of columns in the SET clause of the UPDATE statement is important. There is a BIG DIFFERENCE between MySQL and Oracle on update columns with previous values: Orac...
2007-05-11, 5215👍, 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, 5035👍, 0💬

What Happens If the UPDATE Subquery Returns Multiple Rows
What Happens If the UPDATE Subquery Returns Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, My...
2007-05-11, 5328👍, 0💬

<< < 120 121 122 123 124 125 126 127 128 129 130 > >>   Sort: Rank