MySQL not working

💬 App Building
1

I am showing some code that applies to a data table Appt02 where Extra3 = "X".

I have been working on this carefully to check on capitalization and on names. The code is good,

But when it runs it applies to the entire table.

I am using cPanel to monitor my data files and Extra3 = "X" is on the correct rows.

Yes, the code runs for the entire table.

Any thoughts?

Mike

Pict1
Pict1985×270 21.9 KB

3

Hi @mdsmith1 I think you need to use single quotes on the string literal.

E.g. Does this return the correct number of rows?

select * from Appt02 where Extra3 = 'X'

Thanks

1 Like
4

I second Jon’s suggestion.

Single quotes for strings in SQL.

Double quotes are used for forcing literal schema/table/column names.

5

Jon:

I got some help from Clause AI and it suggested that. But it does not seem to work for longer strings.

I use the same code for putting the first name and last name of the doctor but it does not work for a longer string like "Barry Coghlin, Oncologist".

I have found a work around so I am OK.

Mike

6

Are you saying when you do something like Tim Grey, MD works. However, when you insert something like Christopher Browning, D.Clin.Psych it fails?

If so, is there a character limit in the column you’re inserting into?