Scribd
Upload
22 views3 pages

200616_classwork_70749_2

The document outlines the four basic elements of MySQL: literals, data types, nulls, and comments. It explains that null represents the absence of a value and any arithmetic operation involving null results in null. Additionally, it describes single-line and multi-line comments, detailing how to properly format them for documentation purposes.

Uploaded by

erictsam58
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views3 pages

200616_classwork_70749_2

The document outlines the four basic elements of MySQL: literals, data types, nulls, and comments. It explains that null represents the absence of a value and any arithmetic operation involving null results in null. Additionally, it describes single-line and multi-line comments, detailing how to properly format them for documentation purposes.

Uploaded by

erictsam58
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

UNIT IV

DATABASE CONCEPTS

AND

THE STRUCTURED QUERY


LANGUAGE

SESSION 11

1
MYSQL ELEMENTS:
There are four basic elements in MySQL .They are:

1. Literals
2. Data Types
3. Nulls
4. Comments

 Literals
 Data Type
 Null: If a column in a row has no value then the column is called Null.
Null and Zero are not equal.

Any arithmetic operations done with null returns the output as Null

Example: 2+Null =Null

NullX3=Null

4-Null =Null

7/Null =Null

 Comments: These are the non-executable part of a program. It is


mainly used for documentation purpose. Comments are used in a program
to make the program user friendly. They are classified into:

I. Single line comment: These comments cannot exceed more than


one line. They can be specified in two ways:
 Begin the comment with # .Proceed with the text of
the document.
Example: #this is a single line comment

2
 Begin the comment with -- (followed by a
space).Proceed with the text of the comment.
Example: -- not exceed more than one line

II. Multi-line comment: These comments exceed more than one line.
It is begin with /*.Proceed with the text of the comment. This text
can span multiple lines.
Example: /* this is a multiline comment
Comments exceed more than one line.*/

You might also like