sandeepm Posted March 27, 2015 Share Posted March 27, 2015 How to write GROUP_CONCAT_MAX_LEN Increasing as per requriement in perticuar select query in php..... Link to comment Share on other sites More sharing options...
justsomeguy Posted March 27, 2015 Share Posted March 27, 2015 You can use SET GLOBAL or SET SESSION to change the value of a system variable, assuming that variable can be changed at runtime.http://dev.mysql.com/doc/refman/5.1/en/set-statement.html Link to comment Share on other sites More sharing options...
sandeepm Posted April 1, 2015 Author Share Posted April 1, 2015 Yes, But i need while fetching the data from database, based on size of records automatically increasing size... is it possible...... Link to comment Share on other sites More sharing options...
justsomeguy Posted April 1, 2015 Share Posted April 1, 2015 You should change the variable before the query to a value large enough that will allow the query to succeed. Link to comment Share on other sites More sharing options...
sandeepm Posted April 3, 2015 Author Share Posted April 3, 2015 (edited) please give an example because i have large data to cancat Edited April 7, 2015 by sandeepm Link to comment Share on other sites More sharing options...
justsomeguy Posted April 6, 2015 Share Posted April 6, 2015 So set the value to something that will be large enough for you, that's all I'm suggesting. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now