/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 vote253 views1 answer
Timestamp in sqlite
SQL
5 votes267 views1 answer
Commentaire table oracle
SQL
3 votes312 views1 answer
Oracle list invalid password logon denied
SQL
6 votes260 views6 answers
Count mysql
SQL
16 votes276 views1 answer
Mysql reset auto increment value
SQL
0 vote271 views1 answer
Show tables in cassandra cql
SQL
3 votes261 views1 answer
Postgresql db owner change
SQL
0 vote265 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
2 votes325 views2 answers
MySql FULL OUTER JOIN
SQL
4 votes260 views1 answer
Phone number sql
SQL