/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

3 votes196 views1 answer
Two select sql
SQL
0 vote191 views1 answer
Exec procedure oracle
SQL
6 votes229 views5 answers
Oracle list tablespaces
SQL
0 vote217 views1 answer
SQL Where-Klausel
SQL
0 vote193 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote249 views1 answer
Oracle check table lock
SQL
1 vote207 views1 answer
Where not in array sql
SQL
0 vote266 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
4 votes190 views2 answers
Tsql utf to local time
SQL
0 vote260 views1 answer
A network or instance-specific error sql server
SQL