/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 server loop over query
SQL
0 vote234 views3 answers
Sql count condition
SQL
0 vote262 views1 answer
How do I insert a blob in SQL?
SQL
0 vote250 views1 answer
Postgres grep entire database
SQL
-3 votes252 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote227 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote233 views2 answers
Rebuild index sql server
SQL
0 vote263 views1 answer
Check constraint is violated
SQL
2 votes239 views3 answers
Current month mysql query
SQL
0 vote243 views1 answer
Get who is hired in month in sql
SQL