/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 vote247 views1 answer
Sql group by error
SQL
1 vote264 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote235 views1 answer
Mysql create table columns with spaces
SQL
1 vote253 views1 answer
T-SQL Alter the column data type
SQL
1 vote269 views1 answer
Simple project for database
SQL
0 vote278 views1 answer
Sql delete caracter list
SQL
0 vote272 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote278 views1 answer
Express api ith mysql data
SQL
0 vote268 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote295 views2 answers
Generate sql trigger through ef migration
SQL