2个MYSQL语句_MySQL
- WBOYOriginal
- 2016-06-01 13:48:321111browse
bitsCN.com
SELECT sku, SUBSTRING( ordered_pic, 1, LENGTH( SUBSTRING_INDEX( ordered_pic, ",", 1 ) ) ) AS pid
FROM `product`
WHERE `purchaser_id` =13
LIMIT 0 , 30
SELECT id,picture_name FROM `picture` WHERE `width` =468 AND height = 468 AND created_at > '2012-08-01' and picture_name like 'W%'
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql远程连接对用户的测试(吴龙波)_MySQLNext article：三种批量增加的性能分析_MySQL