MySQL error when inserting data containing apostrophes (single quotes)

-

Apostrophe Delimiter

In the MySQL version of SQL, you signal the beginning and the end of a string with either single quotes or double quotes. Both of the following examples are valid:
  • INSERT INTO COMPANY_TABLE (company_name) VALUES ‘The Fish Shack’;


    INSERT INTO COMPANY_TABLE (company_name) VALUES “The Fish Shack”;

    The following example, however, creates an error:

    INSERT INTO COMPANY_TABLE (tag_line) VALUES ‘Eat at Joe’s -- It’s Good Food!’;

    SQL wants to interpret the string as "‘Eat at Joe’," with everything following the second apostrophe as erroneous. The following text does not fix the problem:

    INSERT INTO COMPANY_TABLE (tag_line) VALUES “Eat at Joe’s -- It’s Good Food!”;

    This would work if the text had only one apostrophe between the double quotes, but this text has two. Also, because some Web-page programming languages use double quotes themselves, you may wish to avoid using them in your SQL.

Comments

Post a Comment

Popular posts from this blog

Free icons

-
It's important to use icons with the same style in your project. So here's a list of free icons you can use. 🆓👇 🔸fethericons. com 🔸iconmonstr. com 🔸freeicons. io 🔸lineicons. com 🔸css. gg 🔸jam-icons. com
Read more

how to create template file in php. why it is usefull

-
ravimane and php,mysql     that code that is same in two page no need to write twice , just make one file having that code and call or include anywhere you want.     everyone have been trying with .tpl.php extension. but doesn't matter what you want take, but with .php extension. that cool na  .so check out below and seek whatever you want .     below i made three file         top.php <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <link rel="stylesheet" href="css/style.css" type="text/css"> <meta name="Author" content="YOUR NAME HERE"> middle.php </head> <body> <div id="banner"> <img src="xyzlogo.gif" alt="XYZ, Inc. logo"> </div> <div id="menu"> <a href="index.php">Home</a> | <a href="sitemap.php">Sitemap</a> | <a hr...
Read more

[PHP] Create MySQL Trigger in PHP

-
phpmysql Introduction When we want to execute a specific task at a scheduled time, MySQL provides special functionality called triggers. Triggers are basically named blocks of code that are executed, or fired, automatically when a specified type of SQL statement is executed. Triggers can be executed before after an INSERT, UPDATE or DELETE statement is executed on the table. Syntax CREATE TRIGGER trigger_Name {Before|After}{Insert|Update|Delete}ON table_name For  EACH  ROW sql_block For Example Using the following query, you can better understand what a trigger is and how to use a trigger to execute a specific task at a scheduled time. Query The following query creates a  trigger named "MysqlTrigger", this trigger is associated with the name emp table and is fired before an update. When you try to update a name with lower case, it will automatically convert it to UPPER case . "CREATE TRIGGER MysqlTrigge...
Read more