use a stored proc, and commit at regular interval say, for every 1k rows.
This would be faster and if ur using slave, they will also commit at regular
interval and be in sync.
regards
anandkl
On Sat, Apr 10, 2010 at 6:12 AM, Mitchell Maltenfort wrote:
> I have two tables, A and B. B has newer d
Which one is more suitable for developing an ERP Application ? MyISAM or InnoDB
?
Are there other tools to backup MySQL Database than Standard GUI Tools which
MySQL provide in the website ? So far, I use this GUI tools and setup an
automatic backup on 9AM everyday. Is this backup tools is relia
I have two tables, A and B. B has newer data, A has more columns.
I want to update some of the columns in A with all but one of the
columns in B. They have the same number of records -- about eight
million -- and one key column in common for matching. (That's the one
from B I don't want to updat
Hi Carsten
thanks for providing mysql support at 846pm kobenhavn time (on a fridag no less)
I will DEFINITELY check this out
Takk!
Martin Gainty
__
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si
If you'll excuse the shameless plug: I once created a tool to help find
the exact parameters to use for PHPs date() and MySQLs DATE_FORMAT().
Please see
http://bitbybit.dk/php/date_format/
(Yes, it looks horrible. But it works)
/ Carsten
Martin Gainty skrev:
Good Afternoon All
following t
(Agradecimentos para o conselho)
Eu espero que o homem responsável parará a chuva e permitirá a todos nós a
oportunidade de dessecar e apreciar a luz do sol
Obrigado!
Martin Gainty
__
Por favor não altere/interrompa ou altere esta transmissão
Basicay, your date_format works like:
select DATE_FORMAT('YY-MM-DD','%y-%b-%d') from DUAL;
"Martin Gainty" escreveu na mensagem
news:blu142-w2137936b18ae273dbd6cb1ae...@phx.gbl...
Good Afternoon All
following the documentation available at
http://dev.mysql.com/doc/refman/5.1/en/date-and-tim
Good Afternoon All
following the documentation available at
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
i wish to select a date using DD-MON-YY format but my format of '%y-%b-%d'
appears to be incorrect
mysql> select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL;
+-
Kyong,
Thanks for the feedback on InnoDb. I will tinker with it when I have
more time. I wonder if MySQL will ever release an alternative to Innodb
like Falcon or whether Falcon is dead as a dodo? :-)
Mike
At 11:07 PM 4/8/2010, Kyong Kim wrote:
We've seen good results throwing more RAM
In phpmyqdmin in SQL window type :
show create procedure procedureName;
eg; SHOW CREATE PROCEDURE circle_area; in SQL
Check more on :
http://adminlinux.blogspot.com/2009/12/mysql-tips-verify-database-objects.html
Thanks
On Fri, Apr 9, 2010 at 1:00 PM, alba.albetti wrote:
> Since I work on My
Since I work on MySQL by using phpMyAdmin, is there anyone saying to me if and
how it's possibile to see the code of a stored procedure that I've created? For
example on Oracle I use sql-developer but with phpMyAdmin is it possible to see
the whole code of a procedure or of a trigger after creat
11 matches
Mail list logo