All Questions
We will use BETWEENclause to find records between dates and the IS Operator to check NULL values. we can not use name = NULL condition as null values can not be determined by the equal to sign. SELECT * FROM `user` WHERE date BETWEEN '2015-06-01' AND '2015-10-01' AND name is NULL .
First We need to select common record's ids . SELECT id FROM `user` INNER JOIN `userdata` WHERE user.id = userdata.userid Then we will match to found records from first table where matching id is not there. SELECT * FROM USER WHERE id NOT IN(SELECT id FROM `user` INNER JOIN `userdata` WHERE user.id = userdata.userid)
OUTPUT: SELECT * FROM table WHERE 1 :: Gives All Rows SELECT * FROM table WHERE -1 :: Gives All Rows SELECT * FROM table WHERE 0 :: Gives Nothing
CSS stands for Cascading Style Sheets. It is a style sheet language which is used to describe the look and formatting of a document written in markup language. It provides an additional feature to HTML. It is generally used with HTML to change the style of web pages and user interfaces. It can also be used with any kind of XML documents including plain XML, SVG and XUL. CSS is used along with HTML and JavaScript in most websites to create user interfaces for web applications and user interfaces for many mobile applications.
1.You can add new looks to your old HTML documents.2.You can completely change the look of your website with only a few changes in CSS code.1.
1) Solves a big problemBefore CSS, tags like font, color, background style, element alignments, border and size had to be repeated on every web page. This was a very long process. For example: If you are developing a large website where fonts and color information are added on every single page, it will be become a long and expensive process. CSS was created to solve this problem. It was a W3C recommendation. 2) Saves a lot of timeCSS style definitions are saved in external CSS files so it is possible to change the entire website by changing just one file. 3) Provide more attributesCSS provides more detailed attributes than plain HTML to define the look and feel of the website.
SGML (Standard Generalized Markup Language) is the origin of CSS. It is a language that defines markup languages.
Following are the different variations of CSS: 1.CSS12.CSS23.CSS2.14.CSS35.CSS4
CSS is added to HTML pages to format the document according to information in the style sheet. There are three ways to insert CSS in HTML documents. 1.Inline CSS2.Internal CSS3.External CSS
* Bandwidth* Site-wide consistency* Page reformatting* Accessibility* Content separated from presentation
Ascending by selectors is not possible Limitations of vertical control No expressions No column declaration Pseudo-class not controlled by dynamic behavior Rules, styles, targeting specific text not possible
1.Bootstrap2.Foundation3.Semantic UI4.Gumby5.Ulkit
There are two reasons behind this: 1.It enhances the legibility of style sheets. The background property is a complex property in CSS, and if it is combined with color, the complexity will further increase.2.Color is an inherited property while the background is not. So this can make confusion further.
An Embedded style sheet is a CSS style specification method used with HTML. You can embed the entire stylesheet in an HTML document by using the STYLE element. <style> body { background-color: linen; } h1 { color: red; margin-left: 80px; } </style>
1.You can create classes for use on multiple tag types in the document.2.You can use selector and grouping methods to apply styles in complex situations.3.No extra download is required to import the information.
The CSS opacity property is used to specify the transparency of an element. In simple word, you can say that it specifies the clarity of the image. In technical terms, Opacity is defined as the degree to which light is allowed to travel through an object. For example: <style> img.trans { opacity: 0.4; filter: alpha(opacity=40); /* For IE8 and earlier */ } </style>
HTML: Hypertext Markup Language. This is a structrural language for web development.
Some CSS Style components are: 1.Selector2.Property3.Value
The CSS opacity property is used to specify the transparency of an element. In simple word, you can say that it specifies the clarity of the image. In technical terms, Opacity is defined as the degree to which light is allowed to travel through an object. For example: <style> img.trans { opacity: 0.4; filter: alpha(opacity=40); /* For IE8 and earlier */ } </style>
The universal selector matches the name of any of the element type instead of selecting elements of a specific type. <style> * { color: green; font-size: 20px; } </style>
The p[lang] command is used for selecting all the elements of a paragraph.
It is used for defining percentage values.
The background-color property is used to specify the background color of the element. For example: <style> h2,p{ background-color: #b0d4de; } </style>
The background-repeat property repeats the background image horizontally and vertically. Some images are repeated only horizontally or vertically. <style> body { background-image: url("paper1.gif"); margin-left:100px; } </style>
The background-position property is used to define the initial position of the background image. By default, the background image is placed on the top-left of the webpage. You can set the following positions: 1.center2.top3.bottom4.left5.right
The background-attachment property is used to specify if the background image is fixed or scroll with the rest of the page in the browser window. If you set fixed the background image, then the image not move during scrolling in the browser. Let's take an example with the fixed background image. background: white url('bbb.gif'); background-repeat: no-repeat; background-attachment: fixed;
An overall block is given to class selector while id selectors take only a single element differing from other elements. CSS Class Selector<style> .center { text-align: center; color: blue; } </style> CSS Id Selector<style> #para1 { text-align: center; color: blue; } </style>
* You can create classes for reusing it in many documents.* By using it, you can control the styles of multiple documents from one file.* In complex situations, you can use selectors and grouping methods to apply styles.