Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sql Knowledge For learners :)
- --------------------------------------------------------
- --->What Is Sql Injection
- ---------------------------------------------------------
- SQL injection is a technique where malicious users can inject SQL commands into an SQL statement, via web page input.
- Injected SQL commands can alter SQL statement and compromise the security of a web application.And Also Distroy your Database colonthree emoticon
- ---------------------------------------------------------
- --->What is Information_schema ?
- ---------------------------------------------------------
- INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables.
- Following is a list of each of the views that exist.
- INFORMATION_SCHEMA.CHECK_CONSTRAINTS
- INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE
- INFORMATION_SCHEMA.COLUMN_PRIVILEGES
- INFORMATION_SCHEMA.COLUMNS
- INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
- INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
- INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
- INFORMATION_SCHEMA.DOMAINS
- INFORMATION_SCHEMA.KEY_COLUMN_USAGE
- INFORMATION_SCHEMA.PARAMETERS
- INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
- INFORMATION_SCHEMA.ROUTINE_COLUMNS
- INFORMATION_SCHEMA.ROUTINES
- INFORMATION_SCHEMA.SCHEMATA
- INFORMATION_SCHEMA.TABLE_CONSTRAINTS
- INFORMATION_SCHEMA.TABLE_PRIVILEGES
- INFORMATION_SCHEMA.TABLES
- INFORMATION_SCHEMA.VIEW_COLUMN_USAGE
- INFORMATION_SCHEMA.VIEW_TABLE_USAGE
- INFORMATION_SCHEMA.VIEWS
- -------------------------------------------------------
- --->What Is Null Value ?
- ---------------------------------------------------------
- The SQL NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank.
- A field with a NULL value is a field with no value. It is very important to understand that a NULL value is different than a zero value or a field that contains spaces.
- -------------------------------------------------------------
- Different Operator Use in Sql
- -------------------------------------------------------------
- --->ALL operator
- -------------------------------------------------------------
- The ALL operator is used to compare a value to all values in another value set.ALL is used to select all records of a SELECT STATEMENT
- Example:
- For example, ALL means greater than every value, means greater than the maximum value. Suppose ALL (1, 2, 3) means greater than 3
- ---------------------------------------------------------------
- ---->AND Operator
- ----------------------------------------------------------------
- The AND operator allows the existence of multiple conditions in an SQL statement's WHERE clause.In simple Words
- The AND operator displays a record if both the first condition AND the second condition are true.
- ---------------------------------------------------------------
- ---->OR Operator
- ---------------------------------------------------------------
- The OR operator is used to combine multiple conditions in an SQL statement's WHERE clause.In simple Words
- The OR operator displays a record if either the first condition OR the second condition is true.
- --------------------------------------------------------------
- ---->GROUP BY Statement
- -------------------------------------------------------------
- The GROUP BY Statement
- The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.
Add Comment
Please, Sign In to add comment
