/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 vote178 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote170 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote151 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
2 votes174 views3 answers
Application.properties spring boot mysql
SQL
4 votes151 views1 answer
Sql list users and roles
SQL
1 vote191 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote185 views2 answers
Functions with parameters SQL
SQL
0 vote203 views1 answer
Postgres - Login and connect as default user
SQL
5 votes219 views3 answers
Sql limit offset
SQL
0 vote187 views1 answer
Mysql backup query
SQL