SQL injection is a technique often used to attack databases through a website. This is done by including portions of SQL statements in a web form entry field in an attempt to get the website to pass a newly formed rogue SQL command to the database (e.g. dump the database contents to the attacker). SQL injection is a code injection technique that exploits a security vulnerability in a website’s software. The vulnerability happens when user input is either incorrectly filtered for string literal escape characters embedded in SQL statements or user input is not strongly typed and unexpectedly executed. SQL commands are thus injected from the web form into the database of an application (like queries) to change the database content or dump the database information like credit card or passwords to the attacker. SQL injection is mostly known as an attack vector for websites but can be used to attack any type of SQL database.
Difference between mysql_connect() and mysql_pconnect() PHP
mysql_pconnect() acts very much like mysql_connect() with two major differences.
When connecting using mysql_pconnect() , the function would first try to find a (persistent) link that’s already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.
When connecting using mysql_connect(), the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use
Note :mysql_close() will not close links established by mysql_pconnect().
- SQL Create DB – It is used to create a database
- SQL Create Table – It is used to create a table.
- SQL Create Index - It is used to create indexes in tables
- SQL Drop - can be used to delete table,indexes and databases
- SQL Truncate - can be used to delete records in table
- SQL Alter - It is used to add, delete, or modify columns in a table.
SQL ROUND() is used to round a numeric field to the number of decimals specified.
SELECT ROUND(column_name,decimals) FROM table_name
Table – Users
| oid | uid | price |
| 1 | 1 | 60.345645 |
| 2 | 2 | 30.45564 |
| 3 | 2 | 60.78565 |
| 4 | 1 | 70.96565 |
| 5 | 2 | 80.565645 |
| 6 | 1 | 50.57565 |
mysql> SELECT ROUND(price,2) as price FROM orders;
| price |
| 60.35 |
| 30.46 |
| 60.79 |
| 70.97 |
| 80.57 |
| 50.58 |
6 rows in set (0.00 sec)
SQL LEN() returns the length of the value in a text field.
SELECT LEN(column_name) FROM table_name