title: MySQL Prepare Statement - Maximum Length 1000 Characters
body: <p>I have an SQL statement which exceeds 1000 characters that I'm using through prepare method - is there anyway to extend this value marginally?</p>
  
  <p>Once I use the prepare command it truncates the SQL to 1000 characters, similarly if I just select the variable holding the sql string this also is truncated in output.</p>
  
  <p>In addition to the core SQL there could be any number of additional queries added on.</p>
  
  <p>I suppose I could create a view and then select from the view, however views in MySQL are a little sluggish.</p>
  
  <p>I know I can refine this down and replace with select tv.* etc and I have done that in my trials, however the additional queries can add significantly to the length and actually the items that are selected are least of my worries.</p>
  
  <p>Is there no way to extend the 1000 limit.</p>