/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 votes133 views1 answer
Oracle list dates without weekends
SQL
6 votes145 views4 answers
Mysql group by date
SQL
0 vote137 views1 answer
Java spring boot connect to sql server
SQL
1 vote188 views1 answer
Concat first name and last name in mysql
SQL
5 votes149 views4 answers
Traduction
SQL
0 vote258 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote132 views1 answer
Sql developer search all packages for text
SQL
0 vote96 views1 answer
Count char in java
SQL
0 vote133 views1 answer
Get null value in sql
SQL
0 vote139 views1 answer
Mysql order by rand limit 1 really slow
SQL