MySQL GROUP_CONCAT текстийн урт

GROUP_CONCAT гэж буянтай функц байдаг, их хэмжээний текст group-лэй залгах үед зарим текст таслагддаг, үүнийг дараахь коммандаар шийдлээ. Хэрэв байнга ашиглана гэвэл mysql-н тохиргоонд нь хийж өгөх хэрэгтэй байх.

SET SESSION group_concat_max_len = 1000000;

дараа нь

SELECT id, GROUP_CONCAT( `field`) SEPARATOR "; ") FROM table1 GROUP BY `id`
Advertisements

About Сайнбаяр
Web Developer.

2 Responses to MySQL GROUP_CONCAT текстийн урт

  1. I like the helpful info you provide in your articles.
    I will bookmark your blog and check again here regularly.
    I’m quite sure I’ll learn many new stuff right here!
    Best of luck for the next!

  2. Pingback: oracle developer advanced forms and reports download

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: