- or download this
mysql> select * from coordsys;
+-------------+--------------------------------+
| ID_COORDSYS | COORDSYS_NAME |
...
mysql> select 'test', * from coordsys;
ERROR 1064 (00000): You have an error in your SQL syntax. Check the m
+anual that corresponds to your MySQL server version for the right syn
+tax to use near '* from coordsys' at line 1
- or download this
mysql> create table temp_table_name ( test varchar(4) );
Query OK, 0 rows affected (0.00 sec)
...
| NULL | 13 | Solar Cropped |
+------+-------------+--------------------------------+
11 rows in set (0.00 sec)
- or download this
SQL> select 'test',coordsys.* from soho.coordsys;
'TES ID_COORDSYS COORDSYS_NAME
...
test 13 Solar Cropped
11 rows selected.