Re: Default date format

2004-12-27 Thread jakub
rmat=name The DATE format (For future). So I guess the variable is prepared but not used for anything yet. -- Jakub Vrana -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Default date format

2004-12-27 Thread Jakub Vrana
datetime_format and time_format in SHOW VARIABLES, it's even documented somewhere (e.g. http://mysqld.active-venture.com/SET_OPTION.html ) but it seems it doesn't do anything in MySQL 4.1.7. -- Jakub Vrana -- MySQL General Mailing List For list archives: http://lists.mysql.com

Problem with dates and BETWEEN operator

2002-10-25 Thread Jakub Szewczyk
00:00:00 | | 45 | 2002-11-11 00:00:00 | | 46 | 2002-11-18 00:00:00 | | 47 | 2002-11-25 00:00:00 | | 48 | 2002-12-02 00:00:00 | | 49 | 2002-12-09 00:00:00 | | 50 | 2002-12-16 00:00:00 | | 51 | 2002-12-23 00:00:00 | | 52 | 2002-12-30 00:00:00 | | 53 | 2003-01-06 00:00:00 | | 54 | 2003-01-13 00:00:00 |

SQL - Update problem

2002-08-28 Thread Jakub Mach
Hi, how can I do sql command like this: update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id Thanks for answer j. - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

what causes 'got error 127 from table handler'?

2001-12-17 Thread Jakub Suchy
) NOT NULL auto_increment, counts int(11) NOT NULL default '0', name varchar(80) NOT NULL default '', pridano datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (id,name) ) TYPE=MyISAM; does anybody know the answer? thank you JS -- jakub suchy [ [E

mySQL memory leaks !!! (?)

2001-08-20 Thread Jakub Trzetrzelewski
/mtrace.log I achieve many lines (76 in fact) of places where memory is not freed. Does anybody knows what is going on ? (it's my fault or it's mysql functions fault or mtrace fault ;-) ?) Any help would be appreciated. - Jakub Trzetrzelewski ---

Re: LIKE Magic

2001-07-05 Thread Jakub Wasielewski
where kword_10 IS NULL" enough? Cheers, I love MySQL ;) -- Jakub Wasielewski <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

LIKE Magic

2001-07-05 Thread Jakub Wasielewski
and both returned different vaules in second examle. Table docs is execkly the same on both MySQL's and kword_10 is a varchar(50). Please help me understand... Cheers, -- Jakub Wasielewski <[EMAIL PROTECTED]> - Befo

mySQL and polish characters

2001-05-04 Thread Jakub Kasprzycki
ole, and the mySQLadmin... The database is made in Access and transported using the myODBC but even when I INSERT the data manually through the console it doesn't work. Anyone had the similar or same problem? Please help... :-) THX ****