/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 vote185 views1 answer
Primary key multiple colums
SQL
6 votes198 views2 answers
Foreign key sqlite3 python
SQL
0 vote185 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote217 views1 answer
Sparql if bound query
SQL
0 vote257 views1 answer
How to find sql server name
SQL
7 votes234 views2 answers
Create index mysql cli
SQL
0 vote193 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote193 views1 answer
Influxdb clone measurement
SQL
0 vote177 views1 answer
Shrink database file in sql server
SQL
0 vote242 views1 answer
Scheduled mysql database backup in linux
SQL