Skip to main content

Posts

Showing posts with the label MYSQL

Web Application Security

Application security : Some of the following Application security is exist in web development, These are in the order of most attacked at the level 1, 1 - Cross site scripting 2 - SQL Injection 3 - File Upload 4 - Cross site request forgery 5 - Local file inclusion 6 - Remote code execution 7 - Full path disclosure 8 - Remote file inclusion 9 - Authentication Bypass 10 - General bypass 11 - Open direct 12 - XML external entity 13 - Denial of services 1 - Cross site scripting (also known as XSS):   XSS vulnerabilities target scripts embedded in a page that are executed on the client-side (in the user’s web browser) rather than on the server-side. Let suppose end user fill the form and put the script tag in the textfield, this script is stored in the database field.  When this field shows in the web then this script would be executed and harm the web , Some common attacks are like , change the image source , fire any event, or steal the cookies. C...

MYSQL index

Introduction to index MySQL uses indexes to quickly find rows with specific column values. Without an index, MySQL must scan the whole table to locate the relevant rows. The larger table, the slower it searches. Creating indexes An index is a data structure such as B-Tree that improves the speed of data retrieval on a table at the cost of additional writes and storage to maintain it. When you  create a table  with a  primary key  or  unique key , MySQL automatically creates a special index named  PRIMARY . This index is called the  clustered index . The  PRIMARY  index is special because the index itself is stored together with the data in the same table. The clustered index enforces the order of rows in the table. Other indexes other than the  PRIMARY  index are called secondary indexes or non-clustered indexes CREATE TABLE t ( c1 INT PRIMARY KEY , c2 INT NOT NULL , c3 INT NOT NULL , c4 VARC...