/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

10 votes166 views3 answers
Sql check double value
SQL
2 votes178 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote168 views1 answer
Oracle string length
SQL
1 vote152 views1 answer
How to see logical reads in sql server
SQL
9 votes161 views2 answers
Sql server check table exists
SQL
0 vote174 views1 answer
Two inner joins sql
SQL
0 vote182 views2 answers
Nested query
SQL
1 vote203 views2 answers
List tables sqlalchemy
SQL
1 vote154 views2 answers
Sql server add time to date
SQL
0 vote254 views1 answer
Get statis values sql
SQL