/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 vote197 views1 answer
Sqlite update from another table
SQL
8 votes160 views1 answer
Sql remove characters from string right
SQL
0 vote169 views1 answer
Mysql with
SQL
3 votes184 views2 answers
Install mysql powershell
SQL
0 vote248 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote177 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
2 votes224 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote248 views2 answers
Install phoenix
SQL
0 vote180 views1 answer
Mariadb current date plus 1 day
SQL
1 vote187 views1 answer
Show table status command in mysql
SQL