Re: max_allowed_packet via SQL Statement

2006-05-17 Thread Dan Nelson
In the last episode (May 18), Jim said: > Is there any way of getting the max_allowed_packet setting via a SQL > statement? mysql> SHOW VARIABLES LIKE 'max_allowed_packet'; ++--+ | Variable_name | Value| ++--+ | max_allowed_packet |

max_allowed_packet via SQL Statement

2006-05-17 Thread Jim
Hi All, Is there any way of getting the max_allowed_packet setting via a SQL statement? Eg. select version(); returns the version and need to do same for max_packet_size.