like that. ;)
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
timber,
I don't think this is MySQL related :-)
Well, he's offering something to *build* tables, that's why he came to
MySQL list in the first place...
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and round them at the end because integers truncate
instead of round.
If I'd need to convert currencies I would go for 4 or more decimal
places, depending on which currencies I needed.
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
d you completed my observation! ;)
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
es the final answer may be wrong.
I'd rather use a better algorithm instead of a work around in those
cases... ;)
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
would fail
miserably and produce lots of errors (money leak) at the end of the month.
As floating point arithmetic has it's own separated section on your
processor (unless you have a 386 or older computer) it would be *much*
faster than DECIMAL, so use it only if you are absolutely sure y
t have any overhead from outside.
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or what you want and
you'll probably get the correct results.
I'm also not sure that ANSI SQL specifies any order in particular when
no order is passed on the query...
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris Knipe wrote:
Doh.. Wrong email ;)
INSERT INTO a VALUES (NOW()) ?
Sorry, it was not for you, I wanted Jeremiah's query... replied the
wrong mail... my fault! ;)
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Nicholas Vettese wrote:
I have been having problems with my email, and I wanted to test to this
list.
Will let you know when I receive it...
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
an be the way you are using NOW()
within the query. Can you show us the query ?
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ect * from dates where a = "-00-00 00:00:00";
Should return no results.
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of the old (secular) one because it's yellow
and have the words "Don't Panic" on it's cover but the secular one is
more accurate and slightly lighter.
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"cous" (instead of "cows") and than,
search for "sex". As "sex" is by far the most searched it's probable
that it becomes the next search (specially after dubious words such as cow).
Now imagine your son searching for "cows" for his school ho
bold.
It's really hard to extract that information from searches anyway so the
best you can do, as far as I know, is to monitor the common mistakes by
looking into logs and adding terms to that table manually.
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.
Neil Tompkins wrote:
I have a number of different database fields.
> Does anyone have any recommendations about how I can
> perform a search engine type search including the text fields.
Full-Text Search:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
cheers,
--renato
--
l:
http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
emon replicating every 10 seconds
or so.
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dingly. The API writers had
predicted them all and fixed bugs on it and you'd have to go through the
same work, which is not good. (reinventing the wheel).
always look for a stable library before doing it yourself ;)
--renato
--
MySQL General Mailing List
For list archives: http:
your
queries passing arguments instead of concatenating it your self on the
query and how to quote properly the strings so you can stop worrying
about it once and for all... ;)
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
handles in your code (you should care for it).
If you're sure it's not your fault, (and you do have privileges) send
that page to the admin and ask him for a better network! ;)
cheers,
--renato
PS: This error message is subject to forums like this quite often, if
you had googled for
ve the
slave there will be no load balancing on that site.
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
em (manually or with some tool).
hope that helps,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday 11 April 2005 16:00, mysql helppp wrote:
> Error - Duplicate key '444642', -1
> (The syntax of the error message is not exact)
probably index error, run myisamchk on the table, or "repair table" inside
MySQL command line. Should fix without loose any data.
--rengolin
--
MySQL Genera
On Friday 08 April 2005 06:14, Richard Miller wrote:
> I didn't know the CSV table-type existed -- sounds really cool!
>
> As I understand it, it will save table data in a flat CSV file, but if
> I already have a CSV file, can I trick MySQL into thinking it's a
> table? That wasn't clear from the
On Wednesday 06 April 2005 20:05, jon wrote:
> Normal recovery seems to grab 490 rows... but, originally there were
> some 22 million rows in there.
Seems your data file was corruped too not only the indexes. and probably broke
when updating the 491st registry... try use myisamchk -e
-e, --ext
You could use the CSV table type:
http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html
Or use the LOAD DATA INFILE to import all data:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
--rengolin
--- Richard Miller <[EMAIL PROTECTED]> wrote:
> I have a dozen, very large CSV files that I wou
Hi Jalil,
I had the same problem more than once. I solved it
with a (not-so) simple perl script but the idea is
very simple: swap the machines!
scenario #1: master and slave running
- master is used for writes, slave for reads,
replication goes well. you have a DNS entry for
MASTERDB.domain an
On Wednesday 30 March 2005 10:49, Brent Baisley wrote:
> Wow, you are asking a lot, especially since an inexpensive UPS could be
> had for less than $50. You don't need one to keep the system up for a
> long time, just long enough for writes to finish. A few minutes should
> be plenty.
Yeah, remem
On Tuesday 29 March 2005 20:51, Scott Klarenbach wrote:
> Is there a way to represent infinity in mysql?
>
> I could make infinity default to 100,000,000 or some other number I
> know will never be reached, but it seems less elegant a solution...
probably not the best but you could have two fields
On Tuesday 29 March 2005 11:44, Shamim Shaik wrote:
> I cannot stop or lock tables on the master webapps write data to it
> constantly.
>
> I am copying over the binlogs and applying them to the slave.
>
> It is taking a long time so I just want to know if load data or copying
> tables over would b
On Tuesday 29 March 2005 11:26, Shamim Shaik wrote:
> Can I run load data from master on myisam tables where my table size is
> approx 30G?
- stop slave
- on master do:
- lock tables
- tar cpf - /var/lib/mysql/tbl | ssh -C slave tar xpf - -C /var/lib/mysql/tbl
- start slave
- on master again:
-
iable was added in MySQL 4.0.14.
> *
>
> I already tried put of both modes:
> read_only=1
> and
> set-variable = read_only=1
>
> But neither functioned.
>
> Anybody will can help me?
>
> Thanks in advance,
>
> Renato Cramer.
--
MySQL General
ut of both modes:
read_only=1
and
set-variable = read_only=1
But neither functioned.
Anybody will can help me?
Thanks in advance,
Renato Cramer.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
olumns in table, and, depending on approach,
the second column will can be disabled for the users.
Example:
Name: Marco van Basten
Archive: Basten, Marco van
I hope that helps.
Regards,
Renato Cramer.
-Mensagem original-
De: andy thomas [mailto:[EMAIL PROTECTED]
Enviada e
Hi Scott,
Really in user table not modify nothing, but in db table the privileges
appear ok.
Your user get message of access denied?
Regards,
Renato Cramer.
-Mensagem original-
De: Scott Fletcher [mailto:[EMAIL PROTECTED]
Enviada em: segunda-feira, 7 de junho de 2004 17:29
Para: [EMAIL
Hi,
I tried search numerous times and not get: either return all messages or
neither.
Is one known problem?
Regards,
Renato Cramer.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
improved, with warnings generated for statements such as LOAD DATA
INFILE and DML statements such as INSERT, UPDATE, CREATE TABLE, and ALTER
TABLE.
Regards,
Renato Cramer.
-Mensagem original-
De: Mauricio Pellegrini [mailto:[EMAIL PROTECTED]
Enviada em: quinta-feira, 3 de junho de 2004 13:20
Para
> -Mensagem original-
> De: Renato Cramer
> Enviada em: quarta-feira, 2 de junho de 2004 11:07
> Para: Lista MySQL (E-mail)
> Assunto: Restore from Backup done with Replication features
>
> Dear Friends,
>
> Considering what a backup is don
to column id_supervision.
4. Create foreign key referencing the column id_supervision in vacancy table
and supervision
table.
I hope that helps.
Regards,
Renato Cramer.
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviada em: quarta-feira, 2 de junho de 2004 10:02
ment?
- Exist a better method (1-8) to make consistency backups of the
transactional databases without interrupt or block the master server and
without use the InnoDB Hot Backup tool?
All sugestions will be welcome.
Thanks in advance,
Renato Cramer.
--
MySQL General Mailing List
For list
Hi All,
I already looking for Autocommit within my.ini at documentation and archives
of the list, and not found.
Anybody can help me?
Thanks in advance,
Renato Cramer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
generated for statements such as LOAD DATA
INFILE and DML statements such as INSERT, UPDATE, CREATE TABLE, and ALTER
TABLE.
I don't understand why, but...
Greetings,
Renato.
-Mensagem original-
De: Katherine Haines [mailto:[EMAIL PROTECTED]
Enviada em: terça-feira, 18 de maio de 20
good reference font?
I need study this subject. Any other recommendation?
Thanks in advance.
Renato Cramer.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
host
Port: 3306
Someone can help me?
Thanks in advance,
Renato Cramer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rectly.
* I use 'mysqld.exe', as MySQL server, without any special configuration in
my.ini:
[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld.exe
[mysqld]
basedir=C:/MYSQL
datadir=C:/MYSQL/data
Summarizing: I can't access to the Mysql from Internet!
Some additional suggestions?
Regards,
but i don't want to reinvent the
wheel, does some plan on it exists already?
thanks,
Renato
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
other mysqld server running on
port: 3306 ?
021030 17:08:34 Aborting
021030 17:08:34 ./bin/mysqld: Shutdown Complete
What am I doing wrong?
Thanks
Renato
-
Before posting, please check:
http://www.mysql.com/manual.php
i settings are:
post_max_size = 5000
upload_max_filesize = 4000
memory_limit = 5000
max_execution_time = 1800
My column type setting is: LONGBLOB
Do I need to tune any of the server parameters to allow for this upload?
Tha
i settings are:
post_max_size = 5000
upload_max_filesize = 4000
memory_limit = 5000
max_execution_time = 1800
My column type setting is: LONGBLOB
Can anyone help?
Thanks
Renato
-
Before posting, please che
I have this problem in MySQL
select id from usuario;
ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it
How can I solve this problem?
thks
-
Before posting, please check:
http://www.mysql.com/manual.php
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support
]
>Synopsis:
>Severity: <[ non-
in the redhat instalation procedure. And I did that for all servers, but
only this one has this behaviour.
Egor Egorov wrote:
>Renato,
>Tuesday, July 23, 2002, 9:40:35 PM, you wrote:
>
>RL> I have several mysql servers installed, all without TZ variable, one of
>RL> the
vances 4
more hours.
Below is the information about my system. now the --timezone option in
/etc/init.d/mysql nor in /usr/bin/safe_mysql is not set.
Any help will do, thanks
Renato Lins
# cat /etc/redhat-release
Red Hat Linux release 7.2 (Enigma)
#cat /etc/sysconfig/clock
ZONE="America/Ma
will work with XML(Doc-Book XML of linux debian distribution). We will
use Mysql for databases queries
Renato BARRIOS
OVNIBUS project
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
database will be MYSQL
Please see
http://ovnibus.free.fr
Sincerely yours,
Renato BARRIOS
OVNIBUS projec
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
ed all to the original :
This fixes the problem,
Saludos,
Renato Moscoso del Campo.
Gestion / Operaciones.
Geotel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
57 matches
Mail list logo
