/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

1 vote143 views2 answers
Sql for date greater than
SQL
31 votes170 views2 answers
Grant all priviledges to mysql user
SQL
0 vote152 views2 answers
Sql select inside select
SQL
20 votes153 views3 answers
Update values in select statement sql
SQL
3 votes144 views2 answers
Sql paging query
SQL
104 votes930 views2 answers
Like in mysql
SQL
0 vote152 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
1 vote160 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote198 views1 answer
How to make full text search dynamic in mysql
SQL
2 votes203 views5 answers
Install postgresql 10 centos 7
SQL