Forum Documentation Showcase Pricing Learn more

Writing data into MySQL


#1

Is there any tips how I can write data into MySQL. I’m a bit unsure about right queries. I’m all connected to my database but I need to be able create records, view them and edit too. Table fields are super simple: ID, first name, and last name.


#2

Hey Mark,

Try this:

EDIT: Note to future readers…those are back ticks (found next to the 1 key) around the table name and column names (can easily be confused with apostrophe’s.) Technically only needed when using a reserved word in sql or when there is white space in a name. Just easier to always use.



Looking to accelerate your app development?

Let me turn
:thinking: :tired_face: :confounded:

into
:grinning: :sunglasses: :woman_student:

Development through Coaching at https://uniqueideas.com or schedule a free intro session :gift:

Ken Truesdale
LinkedIn


#3

Thanks for your help @mebeingken