/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

1 vote97 views1 answer
Moodle query item quiz
SQL
50 votes199 views6 answers
Sql count duplicate rows
SQL
1 vote119 views1 answer
Oracle drop chain step
SQL
5 votes113 views2 answers
Ranking functions in sql
SQL
0 vote123 views2 answers
How to see table associated with a schema in sql
SQL
0 vote116 views1 answer
Mysql order by where condition sub query
SQL
0 vote116 views1 answer
Sql server current time without date
SQL
0 vote113 views2 answers
How covert into int in maria db
SQL
0 vote255 views1 answer
Hue hive UploadingTextFiletoHive
SQL
1 vote97 views1 answer
Sql server select rows by distinct column
SQL