Help for this page

Select Code to Download


  1. 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
    
  2. 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)
    
  3. or download this
    SQL> select 'test',coordsys.* from soho.coordsys;
    
    'TES ID_COORDSYS COORDSYS_NAME
    ...
    test          13 Solar Cropped
    
    11 rows selected.