/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 vote350 views3 answers
How to filter repeated same result using sql query
SQL
7 votes359 views6 answers
Mysql group concat
SQL
1 vote327 views3 answers
Mysql disable foreign keys check
SQL
0 vote328 views1 answer
Search In the Data using ObjectName
SQL
0 vote328 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote344 views1 answer
Mysql insert into select transaction c#
SQL
0 vote338 views1 answer
Sql find leading space
SQL
7 votes319 views2 answers
Sql server drop temp table if exists
SQL
0 vote335 views1 answer
Postgresql array to rows
SQL
0 vote347 views1 answer
Start stop mysql linux
SQL