/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 vote344 views1 answer
Mysql get date diff in months
SQL
2 votes344 views1 answer
Orcale index size
SQL
0 vote325 views1 answer
Mysql select where field like in list
SQL
0 vote374 views3 answers
Sql parenthetical expression examples
SQL
0 vote323 views1 answer
See Foreign Key
SQL
0 vote325 views1 answer
MySQL - How to find word with the most similar beginning
SQL
4 votes337 views2 answers
Linq join
SQL
4 votes313 views3 answers
Count with where
SQL
12 votes344 views4 answers
Psql command not found
SQL
0 vote356 views1 answer
Soql queries for not contact related account records in salesforce
SQL