MySQL (c api) VC instance and code download (1) (2)

10. SQL statement skills

1. A problem with an SQL statement: column and column Conversion

Select * from v_temp

The preceding view result is as follows:

User_name role_name

-------------------------

System Administrator

Feng Administrator

Feng users

Test Users

The result is as follows:

User_name role_name

---------------------------

System Administrator

Feng administrator, general user

Test Users

==============================

Create table a_test (name varchar (20), role2 varchar (20 ))

Insert into a_test values ('lil', 'manage