/SQL/Provide hardcoded value in the mysql query

Provide hardcoded value in the mysql query

SELECT "" as Serial,
   "" as Object_ID,
   "" as ObjectDEsc,
   "" as Object_Num,
   "--(UNKNOWN -- )" as DropList
UNION
 SELECT CAST(p.Serial AS UNSIGNED INTEGER) as Serial, 
  p.Object_ID, 
  p.Part_ID, 
  st.Description AS ObjectDesc, 
  s.Object_Num, 
  concat(Serial,' (',st.Desc,' #',s.Object_Num,')') as DropList 
 FROM Parts p LEFT JOIN Objects s ON p.Object_ID = s.Object_ID 
 LEFT JOIN ObjectTypes st ON s.ObjectType_ID = st.ObjectType_ID

Source: stackoverflow.com

Similar codes

0 vote242 views1 answer
.sql File Run in PSQL
SQL
1 vote202 views1 answer
Firebase bigquery cloud message
SQL
3 votes222 views2 answers
Pl sql escape '
SQL
0 vote261 views1 answer
Site:av.ru "files"
SQL
0 vote241 views1 answer
QUERY JPQL
SQL
1 vote244 views1 answer
Where not in array sql
SQL
0 vote207 views1 answer
Mysql percentage of total
SQL
0 vote232 views1 answer
Copy data from one postgres container to another
SQL
8 votes226 views2 answers
Change name of colum in sql table
SQL
0 vote227 views1 answer
Like sql for second letter of the family name
SQL