/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

13 votes344 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
33 votes370 views6 answers
Change column name in mysql
SQL
0 vote354 views1 answer
Sql contains vs like
SQL
0 vote371 views1 answer
How to start my sql server on mac
SQL
20 votes347 views5 answers
Mysql reset auto increment to 1
SQL
1 vote359 views3 answers
Drop unique key constraint in sql server
SQL
6 votes372 views2 answers
Postgresql pg_dump
SQL
6 votes362 views2 answers
Mysql get yesterday
SQL
3 votes335 views1 answer
Difference sql vs mysql
SQL
-1 vote379 views5 answers
Operator in sql
SQL