| Phlogiston | snoyes: damn it ;( |
| snoyes | If you have 5.0, however, you can get MySQL to build that statement for you. |
| whatspy | wobbles: thx, I had read it already, but did not get it all right |
| Leithal | zimnyx: yes |
| g0rd0n | ok i couldnt remove client 4.0 because of dependencies, i have both 4.0 and 4.1 clients installed... added old_passwords = 1 to my.cnf, problem solved bye |
| the_wench | see ya |
| Phlogiston | snoyes: hmm I have... but I will use php script now |
| whatspy | where they say " L + 1 bytes", what is "L" ? |
| snoyes | whatspy: length of data you store |
| whatspy | L is lenght, M is maxlenght |
| symtab | hello after i executed a mysql command i got this Query OK, 0 rows affected, 5 warnings (0.01 sec) is there a way i can also see the warnings? |
| snoyes | SHOW WARNINGS; |
| symtab | thanks |
| snoyes | Phlogiston: SELECT CONCAT('ALTER TABLE t1 ', GROUP_CONCAT(CONCAT('MODIFY ', column_name, ' text'))) AS `sql` FROM COLUMNS WHERE table_schema = 'yourDb' AND table_name = 't1' AND data_type = 'mediumtext'; that should be, ...FROM information_schema.columns WHERE... |
| Phlogiston | thanks snoyes :) |
| symtab | for example | Warning | 1364 | Field 'aboutme' doesn't have a default value | is this a problem? i cant define a default value because its TEXT but will this slow down my queries? |
| snoyes | imperceptibly. More to the point, what should that column contain? |
| symtab | or cause any problems? `aboutme` text NOT NULL, will contain anything...some text |
| snoyes | To avoid the warning, be sure to specify some value when you insert records. Even if it's an empty string. |
| symtab | ok thanks but does this influence in any way? (except the warning message dissapears)? i aplogise for my bad english |
| Turt|e | anyone running on freebsd that can tell me how to raise the process memory limit on 6.2 ? |
| whatspy | exit DOH! |
| snoyes | symtab: not much (unless you turn on some of the strict sql modes, in which case that warning will be an error instead) |
| symtab | snoyes, ok, thanks |