Jump to content

How do you include ' character in the column data an INSERT SQL query string?


gregaryb

Recommended Posts

INSERT INTO members (trade, business_name, first_name, surname, structure, license description minimum_charge minimum_budget maximum_size maximum_distance unit street suburb state postcode phone mobile email expiry_date) VALUES ('-1', 'Greg\'s Native Landscapes', 'Greg', 'Boyles', '51 824 753 556', 'Sole trader', '', 'Ecological weed control Low maintenance Drought tolerant Irrigation systems Small retaining walls Small tree removal General pruning Bush tucker gardens Small ornamental billabongs Native lawns', '100', '5000', 'Up to 50', '20', '', '56 Derby Drive', 'Epping', 'VIC', '3076', '94013696', '0455328886', 'gregplants@bigpond.com', '2023 10 31')

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Native Landscapes'' at line 1

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...