Re: Dumping database names from bash with exclusion

* h...@tbbs.net [150401 15:22]: > On 2015/04/01 16:09, Tim Johnson wrote: > >Using Mysql 5 on darwin (OS x). > >This command > >SELECT schema_name FROM information_schema.schemata WHERE > >schema_name NOT IN > >('mysql','information_schema','performance_schema'); > >as executed from the mysql prom

Re: Dumping database names from bash with exclusion

On 2015/04/01 16:09, Tim Johnson wrote: Using Mysql 5 on darwin (OS x). This command SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema'); as executed from the mysql prompt gives me a dump of all databases except those no

Dumping database names from bash with exclusion

Using Mysql 5 on darwin (OS x). This command SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema'); as executed from the mysql prompt gives me a dump of all databases except those not included in the tuple. This command mys

Re: longtext fields in a row

Hi Andrew, On 4/1/2015 1:58 PM, Andrew Wallace wrote: I thought that TEXT fields only stored a pointer to the actual data in the table, not the data itself - storing 9 to 12 bytes in the table: |"BLOB| and|TEXT|

Re: longtext fields in a row

I thought that TEXT fields only stored a pointer to the actual data in the table, not the data itself - storing 9 to 12 bytes in the table: |"BLOB| and|TEXT| columns count from one to four plus

Re: longtext fields in a row

Ok, thanks, couldn't find that anywhere. Need to think for a different solution.. Anyway thanks for the remark, best regards, Schimanski. Andrew Mueller schreef op 01-04-15 om 19:35: There is a max row size of 65,535 bytes. There is no real way to get around this limit other than placin

Re: longtext fields in a row

There is a max row size of 65,535 bytes. There is no real way to get around this limit other than placing the HTML code somewhere else, perhaps in a different table. On Wednesday, April 1, 2015, Trianon 33 wrote: > Hello, > > I'm fiddling wit a table where I put in a date field (datetime, also

longtext fields in a row

Hello, I'm fiddling wit a table where I put in a date field (datetime, also key) and some integer fields (8 of them mostly 14 long) and some longtext fields (16 of them). The longtext fields are filled with some statistics I generate complete with HTML around, something like this: 12.925.965