/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

0 vote404 views1 answer
Finding leap year in sql
SQL
0 vote344 views2 answers
How to tun mysql on ubunto
SQL
0 vote340 views1 answer
Dump db only triggers mysql
SQL
8 votes350 views3 answers
Alter user root mysql
SQL
7 votes351 views2 answers
Mysql get year from date
SQL
4 votes372 views1 answer
How to drop a database in sql server when it is in use
SQL
1 vote374 views2 answers
Sql insert timestamp
SQL
32 votes347 views6 answers
Insert into values select
SQL
9 votes359 views3 answers
Date format in sql
SQL
1 vote351 views1 answer
Right outer vs left outer join
SQL