* h...@tbbs.net 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
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| https://dev.mysql.com/doc/refman/5.0/en/blob.htmland|TEXT|
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:
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
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| https://dev.mysql.com/doc/refman/5.0/en/blob.htmland|TEXT| https://dev.mysql.com/doc/refman/5.0/en/blob.htmlcolumns count from
one to four plus
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 triano...@gmail.com wrote:
Hello,
I'm fiddling wit a table where I put in a date field
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
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