Thanks Quentin...
Further to this, I tried changing the types of the fields from DOUBLE to:
DECIMAL(10,2) and also VARCHAR(20) to avoid any issues with precision
The query still returns back
Query OK, 2 rows affected (0.05 sec)
when the fields are DECIMAL or VARCHAR too.
Might be time to fi
Its not a problem with precision is it - 332.25 looks OK to you and me, but
who knows what it looks like to the CPU? Maybe it sees one of the doubles as
slightly different and updates?
-Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 May 2006 11:48 a.m.
T
I've 3 machines that I use with mysql. One is used for BI consulting and
other two for operational consulting. Which one is indicated to be an
master server ? Is there possible, with 2 nics in machines, use one for
replication and other for receive clients consulting ?
Thanks.
--
There is no reason why you can't use single quotes around the HTML. You
don't appear to have any single quotes with the HTML so this should work
fine. Everything, including the double quotes, should be then stored in
your database.
Regards
Steve wrote:
thank you for the clue of double quoting the html when inserting into the
database but I still get the error. the problem seems to be that I have
quotes INSIDE the html code as well (links and pix) so, i still get this
error.
"
Database Selected: candlecatalog
Query: insert in
Hello everybody!!
I've a problem synchronizing a master mysql to a slave:
When my master make a rotate in binlog my slave can follow up it and catch.
What should I do ?
--
__
Alguns caminham pelo arco,
eu caminho pela reta.
Alexandre Gonçalves Jacarandá
Assessor de Tecnolo
> Most likely, MySQL has done a 'DELETE' followed by an 'INSERT' - i.e. two
rows.
According to:
http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html
The rows-affected value is 1 if the row is inserted as a new record and 2 if
an existing record is updated.
But what happens if the row
Most likely, MySQL has done a 'DELETE' followed by an 'INSERT' - i.e. two rows.
Quentin
-Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 May 2006 11:23 a.m.
To: mysql@lists.mysql.com
Subject: INESRT ... ON DUPLICATE KEY - rows affected incorrect?
Mysql 4.
Mysql 4.1.16 running on Fedora Core 4 (Linu) X86_64 with InnoDB tables
I have a table called which has a (combined) primary key of assetid and
date plus several data fields (open, high, low, close - all doubles, and
voume - a bigint). See the bottom of the email for the table definition.
INSERT
I'm a very beginner and trying to get my way into sql with...
One told me to double quote the html. Now, it's said the php has a
"mysql_real_escape_string" so... What the hell is this and how do I make
that work??? And where is the radio to call MAYDAY Or SOS???
Steve wrote:
>thank you for
Steve wrote:
thank you for the clue of double quoting the html when inserting into the
database but I still get the error. the problem seems to be that I have
quotes INSIDE the html code as well (links and pix) so, i still get this
error.
PHP has a function called 'mysql_real_escape_strin
thank you for the clue of double quoting the html when inserting into the
database but I still get the error. the problem seems to be that I have
quotes INSIDE the html code as well (links and pix) so, i still get this
error.
"
Database Selected: candlecatalog
Query: insert into Products
(Pro
Hi Baynaa,
> I am trying to install syslog-ng + phpsyslogng ... It pipes all the
> log messages to a pipe file mysql.pipe in sql statement format.
> But now the problem is mysql can not read from the pipe file. When
> I give the command:
> $ mysql -u sysloguser -p syslog < mysql.pipe
Doe
I have column and I want to make sure the db is always making sure the value
that gets input into this VARCHAR() column is always lowercase;
Is there a way to set the value of a column within a table to automatically
be lowercase. I know how to use the LOWER() function when performing queries
but
At 15:55 -0500 5/18/06, Steve wrote:
Hi everyone...
how do I enter html code into my database???
Like any other string.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
I think you might consider refactoring your code to use a hybrid of Nested
Sets and Adjacency List.
It's fairly trivial to add a 'parent_id' to the nested set, so you really
don't loose any of your existing schema structure, but it will be much
faster to traverse a tree, and no recursion is requir
Hi steve, you just have to double quotes your insert!
On 5/18/06, Steve <[EMAIL PROTECTED]> wrote:
Hi everyone...
how do I enter html code into my database???
Hi everyone...
how do I enter html code into my database???
On 5/18/06, Kishore Jalleda <[EMAIL PROTECTED]> wrote:
On 5/18/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
> Hi -
>
> I'm trying to import some data into a MySQL database, which was dumped
> from mysqldump. Just looking at the .sql file generated, there's only
> about 7000 lines, on an 800M dump.
Kishore Jalleda wrote:
On 5/18/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Hi -
I'm trying to import some data into a MySQL database, which was dumped
from mysqldump. Just looking at the .sql file generated, there's only
about 7000 lines, on an 800M dump. I guess this tells me I have some
ext
On 5/18/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Hi -
I'm trying to import some data into a MySQL database, which was dumped
from mysqldump. Just looking at the .sql file generated, there's only
about 7000 lines, on an 800M dump. I guess this tells me I have some
extremely long lines, which
Peter,
>Right now I am doing this with PHP and a recursive function, but is it
>possible to do this directly with one query?
SQL is not recursive, so you need an sproc. There are some examples with
discussion at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html.
PB
-
Pe
After deciding a max level, you can self join the table max level time.
Also, you can add two columns, one int column as a hashcode, and one int
column as showing current level. And by writing a simple program, you can
update the hashcode field. You can think bitwise. Just reserve n bits for
each
Hi -
I'm trying to import some data into a MySQL database, which was dumped
from mysqldump. Just looking at the .sql file generated, there's only
about 7000 lines, on an 800M dump. I guess this tells me I have some
extremely long lines, which would be happy to take up more than
'max_allowed
Well, it's documented here:
http://dev.mysql.com/doc/internals/en/flush-tables.html
"Every time a thread releases a table, it checks if the refresh
version of the table (updated at open) is the same as the current
refresh_version. If not, it will close it and broadcast a signal on
COND_refresh (
Hi all!
server version: 5.0.18
I attempted to create a trigger with statement and update, it does like
this:
CREATE TRIGGER update_trans AFTER UPDATE ON main_trans
FOR EACH ROW
BEGIN
IF OLD.trans_status='INITIAL' and OLD.trans_state='INITIAL' THEN
update trans set trans_status=NEW.trans_status, t
Hi,
This is an example of an table that I store categories in. Each category
have a id and also a parent. If the parent_id is 0 that category is a
super-category.
Assume that I would like to get a list of all categories and its parent
category, grandparents category etc down to super-category. Fo
Does mysqlcheck sometimes repair problems that it does not report? I've
seen a few instances where running mysqlcheck -r -f fixed application
problems even though it reported all tables "OK."
--Eric
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Bedford Bob wrote:
I'd like to retrieve the total amount of time the articles have been in the
site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap
year).
if an article has been online from 2004-10-01 to null (meaning the article
hasn't been sold yet) then I may count 365 da
Bob
>I'd like to retrieve the total amount of time the articles have been
in the
>site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap
>year).
In a valid-time app like yours, it is usually more sound to mark
"current" with a
far-in-the-future date than with NULL. Arguably
sheeri kritzer wrote:
MySQL usually gives a syntax error *where* the error happens. In this
case, it would indicate a problem with "SEC_TO_TIME(" but there
shouldn't be a problem, both according to the manual AND according to
my example.
The parser reads the query left-to-right and always qu
Mike Blezien wrote:
Hello,
this is a continued problem we are having from a earlier posting to the
list regarding a query. We need to calculate the SUM of the column
'agent_product_time' which is a TIME datatype column and according to
the manual:
http://dev.mysql.com/doc/refman/4.1/en/date-
Bedford Bob schrieb:
Hi,
My clients can put their articles on my website. They pay for the real
utilisation of the site. If a client has used 2 slots for all year, then he
pays for them.
Now my articles table has a starddate (when the client has started to sell
his product) and an enddate (when
When I do this, the query browser pops up with a select * from table query
which is executed on my behalf revealing my data. All I have to do is press
the edit button (assuming the result set is editable, of course.)
Can you be more specific about 'nothing shows up'?
Tim
-Original Message-
Hello
using MySQL administrator tool, I can view databases under the
catalog folder, but I can't view the data filled in the tables, when
doing right click table --> Edit table Data , nothing shows up
Thanks for your help
hicham
--
MySQL General Mailing List
For list archives: http://lists.mysq
Hi,
My clients can put their articles on my website. They pay for the real
utilisation of the site. If a client has used 2 slots for all year, then he
pays for them.
Now my articles table has a starddate (when the client has started to sell
his product) and an enddate (when the article is sold).
Hi,
for recovery purposes I need to know what exactly is in the master.info
file. Especially the log position. Is it Read_Master_Log_Pos or
Exec_Master_Log_Pos?
Another question: Does "stop slave;" only stop reading the log from
master or does it also stop executing the log that has been rea
37 matches
Mail list logo
