/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 vote275 views1 answer
Sql reverse order of results
SQL
11 votes285 views1 answer
Oracle insert from select
SQL
0 vote270 views1 answer
Datetime postgres typeorm
SQL
2 votes251 views2 answers
Exec procedure pl sql
SQL
2 votes259 views2 answers
Compare date mysql
SQL
1 vote302 views1 answer
Sql server set variable if exists
SQL
0 vote257 views1 answer
Sql get table last modified time
SQL
15 votes266 views3 answers
Find duplicate keys in mysql
SQL
11 votes285 views3 answers
How to get last row of table in sql
SQL
1 vote257 views1 answer
Add time to date sql
SQL