MySQL (CAPI) VC instance and Code Download (1) (2) _ PHP Tutorial

MySQL (CAPI) VC instance and Code Download (1) (2 ). 10. SQL statement skills 1. a problem with an SQL statement: the result of the select * fromv_temp view on the row and column conversion is as follows: user_namerole_name --------------------- System Administrator 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

Example 1: an SQL statement: select * from v_temp for row-column Conversion. the preceding view result is as follows: user_name role_name ----------------------- system administrator...