How to stop parsing the HTML tags?

There are couples Method to avoid the parsing of HTML tags, I used following two ways.


How to use XMP Tag for avoid HTML parsing, See Example
Method No 1

<img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOZoBT5-0tL8iOdoHHiqqLgQxwtOtbtLHJp2MaanGJK2BhQOSjIh1FyTgN9uYuCam5kOfUN3NixaLcT7sf46MKGEn7p1PKXJpKG79jMtCZHH4xroHX9AzlQqC97Jbu54Q8pN_H4DLHE9jL/s1600/wordpress.jpg" />

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript"></script>

How to use script Tag for avoid HTML parsing, See Example
Method No 2

<script type="text/plain">
<img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOZoBT5-0tL8iOdoHHiqqLgQxwtOtbtLHJp2MaanGJK2BhQOSjIh1FyTgN9uYuCam5kOfUN3NixaLcT7sf46MKGEn7p1PKXJpKG79jMtCZHH4xroHX9AzlQqC97Jbu54Q8pN_H4DLHE9jL/s1600/wordpress.jpg" />
<meta content='jX6W4C5R1HdrWqp91JMBxHzxqBM' name='alexaVerifyID'/>
<script src='http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js' type='text/javascript'></script>

Best Related Posts are Following:

1. Dojo Interview Questions and Answers for Fresher.
2. EmberJS Interview Questions and Answers.
3. Basic Ember js Interview Questions and Answers.
4. Express Js Interview Questions and Answers.
5. Node Js Interview Questions and Answers for Experienced.
6. JQuery Interview Questions And Answers For Experienced.

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY

Following are few reasons with solutions:

Reason 1:
ID is auto-increment and primary key. id is auto filed when an record is insert.
When we try to insert record with same id which is already exist in table, then such type of error comes.
SOLUTION:
So, write SQL in following ways.

INSERT INTO users (name) VALUES ('name1'); //skip the id field which is auto-increment

Reason 2:
When table is used to frequent insertion of records, like we are storing db logs for each action. Sometimes, it have thousand of thousands records, and field(like id) limit cross the limit. SOLUTION: Increase the limit of id field.

ALTER TABLE `users` CHANGE `id` `id` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT; 

Reason 3:

When table is used to frequent insertion of records, like we are storing db logs for each action.Sometimes, it have thousand of thousands records, and table goes to overhead.
SOLUTION: Execute following query
OPTIMIZE TABLE `users`

Best Related Posts are Following:

1. DBMS Interview Questions and Answers for Freshers.
2. MySQL Interview Questions and Answers for Experienced.
3. Difference between inner join and outer join in MySQL.
4. How to get a list of MySQL user accounts?.
5. How to delete MySQL Binary logs Files in Wamp Server?.
6. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
7. Multiple column ordering in Zend Framework.
8. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
9. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
10. Difference Between MyISAM and innoDB - MySQL.
11. MySQL Functions - MySQL tutorial for beginners.
12. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
13. Mysql FullText Search Examples.
14. MySQL Constraint Example.
15. MySQL Cascade Example.
16. Mysql-Group-Concat.
17. MySQL Expressions.
18. MySQL Delete Table Example.
19. Replace Table - Update Field, Move Records to another table MySQL.
20. mysql insert syntax - Add records from another table - Copy Table from one table to another.
21. Mysql Update Syntax - Update Multiple Records.
22. What is Mysql.
23. Mysql Console Commands - Export and Import database from command line.
24. MySQL interview Questions and Answers For Experienced.