页次: 1
使用as
select g_id as id , g_name as name from goods as my_goods; mysql> select my_goods.g_id as id , g_name as name from goods as my_goods;
示例
mysql> select * from goods; +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 1 | aaa | 1 | 1.10 | | 2 | aaa | 2 | 2.10 | | 3 | aaa | 3 | 3.10 | | 4 | bbb | 1 | 4.10 | | 5 | bbb | 2 | 5.10 | | 6 | bbb | 3 | 6.10 | | 7 | ccc | 1 | 7.10 | | 8 | ccc | 2 | 8.10 | | 9 | ccc | 3 | 9.10 | +------+--------+------+---------+ 9 rows in set (0.05 sec) mysql> select g_id as id , g_name as name from goods as my_goods; +----+------+ | id | name | +----+------+ | 1 | aaa | | 2 | aaa | | 3 | aaa | | 4 | bbb | | 5 | bbb | | 6 | bbb | | 7 | ccc | | 8 | ccc | | 9 | ccc | +----+------+ 9 rows in set (0.02 sec) mysql> select my_goods.g_id as id , g_name as name from goods as my_goods; +----+------+ | id | name | +----+------+ | 1 | aaa | | 2 | aaa | | 3 | aaa | | 4 | bbb | | 5 | bbb | | 6 | bbb | | 7 | ccc | | 8 | ccc | | 9 | ccc | +----+------+ 9 rows in set (0.00 sec)
ipbbs.net
离线
页次: 1