String constans refer to quoted string literals, or in some languages also to constant expressions formed from them, usually via concatenation.
Questions tagged [string-constant]
79 questions
0
votes
1 answer
What is wrong with my WHERE condition in Postgres?
I am running the query SELECT * FROM app_user WHERE login_id = "john"; and getting -
ERROR: column "john" does not exist
LINE 1: SELECT * FROM public.app_user WHERE login_id = "john";
^
SQL…
sam
- 95
- 7
0
votes
0 answers
Why am i getting this error for my insert statement?
insert into filiaal (filiaalnummer, plaats, adres)
values (35, "Utrecht", "Stationsplein")
ERROR: column "Utrecht" does not exist
LINE 2: values (35, utrecht, "Stationsplein")
Why does it say column Utrecht doesn't exist? I know it doesn't, i'm…
Jacob Zuma
- 1
- 1
0
votes
0 answers
Confused about error when creating a table with SQL
I'm working through a tutorial on data-driven astronomy on Coursera, and one of the activities is to create a table populated with exoplanets. My script is:
create table Planet (
kepler_id INTEGER NOT NULL,
koi_name VARCHAR(15) NOT NULL…
Jim421616
- 1,434
- 3
- 22
- 47
0
votes
3 answers
How can you return the result when facing values such as "Cote d'Ivoire" in SQL?
I made a PostgreSQL Table containing data from Oxford University Government Respond Tracker in handling COVID-19.
If anyone interested, here is the link to the data source.
You can download either JSON or CSV; in my case I am using the CSV format.…
aldy_abe
- 107
- 2
- 9
0
votes
2 answers
How to match EOF condition using antlr 4
I am new to ANTLR and I am currently writing a lexer for cool language in ANTLR 4.
For more about cool language please refer http://theory.stanford.edu/~aiken/software/cool/cool-manual.pdf.
One rule of cool language that I was trying to implement…
ADIL TANVEER
- 1
- 1
0
votes
1 answer
Update SQL data but the data contains ' so I get errors
I'm trying to update SQL data but it contains ' so I get errors.
The SQL statement looks like this:
UPDATE SystemConfiguration
SET HeaderScript = '