/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 vote105 views1 answer
Tsql default value when no value returned by query
SQL
-1 vote102 views1 answer
How to format tables in sqlplus
SQL
0 vote115 views1 answer
Datagrip execute procedure
SQL
2 votes114 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote109 views1 answer
Sql server set complex constraints
SQL
0 vote106 views1 answer
Windows services sql
SQL
0 vote108 views1 answer
Sql trying to delete database in use
SQL
1 vote116 views1 answer
Check if mysql is installed
SQL
16 votes115 views3 answers
Jwt secret key generator laravel
SQL
-1 vote108 views1 answer
Mysql order by on condition
SQL