/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 vote183 views1 answer
How to use db.execute
SQL
2 votes161 views1 answer
Sql server find table name
SQL
1 vote180 views1 answer
Mysql take number in string
SQL
0 vote178 views1 answer
Ksql quickstart docker
SQL
0 vote190 views1 answer
Hierarchal database table
SQL
0 vote162 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
5 votes178 views2 answers
Get number of columns sql
SQL
0 vote188 views1 answer
Postgresql import a database of gzip
SQL
0 vote177 views1 answer
Mysql select smaller of two values
SQL
4 votes193 views2 answers
Oracle unlock account
SQL