Jesse wrote:
Are you sure this is the right line - I mean the whole statement?
You are right, I did not include the whole statement. Here's the entire
section:
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION
SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENG
One database, multiple tables.
I need to limit access to one table per user, but also allow all other
tables to be accessed by all users. For example:
Say I have 5 users: usera, userb, userc, userd, usere
Table 1 - all 5 users, select, inset, update, delete
Table 2 - all 5 users, select, inset,
Prem wrote:
Hi All,
Could you please explain why some one needs multiple sql daemons and how to
control the number of dameons.
It forks so it can handle multiple queries at the same time. The main
process (mysqld_safe) handles starting up the other processes and
various other things (I assu
At 9:09 AM +0530 7/26/06, Prem wrote:
Hi All,
Could you please explain why some one needs multiple sql daemons and
how to control the number of dameons.
Do you believe that you have multiple daemons? If so, why?
If you're looking at the output of ps or top and you see a bunch of
mysqld proc
Mark Dale wrote:
Hello MySQL List
I have a simple table that outputs results like so:
select name, question_id, answer from table;
+---+--+-+
|NAME |QUESTION_ID |ANSWER |
+---+--+-+
|Mark |100 |Yes
Hi All,
Could you please explain why some one needs multiple sql daemons and how to
control the number of dameons.
Thanks,
Prem
Ratheesh K J wrote:
I would like to know whether a SELECT query would block an Update on the
same table. The table is of InnoDB type.
Since InnoDB tables apply row level locks should the Update queries be
blocked until the select query completes?
I experienced such a scenario wherein an update
leo huang wrote:
hi, Dilipkumar
Thank you very much!
I think I know the fact: The Innodb can't reuse the deleted rows' disk
space. And a solution is: dump the data; shutdown mysql; delete the
files; restart mysql; import the data.
InnoDB does re-use the space inside the database, it's the log
hi, Dilipkumar
Thank you very much!
I think I know the fact: The Innodb can't reuse the deleted rows' disk
space. And a solution is: dump the data; shutdown mysql; delete the
files; restart mysql; import the data.
Regards,
Leo Huang
2006/7/24, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi,
Try u
Hello MySQL List
I have a simple table that outputs results like so:
select name, question_id, answer from table;
+---+--+-+
|NAME |QUESTION_ID |ANSWER |
+---+--+-+
|Mark |100 |Yes |
|Ma
Isn't this over-complicated
select id_ingenio, sum(cantidad)
from ingenio, detalle_transaccion
where ingenio.id_ingenio = detalle_transaccion.id_ingenio
group by ingenio.id_ingenio
or
select id_ingenio, sum(cantidad)
from ingenio left join detalle_transaccion
on ingenio.id_ingenio = detalle_tr
Hi. thanks ! but nop...
SELECT id_ingenio,cantidad FROM detalle_transaccion WHERE cantidad IS NULL;
Empty set (0.00 sec)
and with coalesce
nop :-( it's the same problem
mysql> select id_ingenio, (select case when sum(
coalesce(cantidad,NULL) ) is null then 0 else sum(cantidad) end f
Try this:
select id_ingenio, (select sum(coalesce(cantidad,0)) from
detalle_transaccion where
id_ingenio=ingenio.id_ingenio group by id_ingenio) as cantidad from
ingenio LIMIT 5;
"obed" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> Hi all !
>
> i have two tables ingenio a
> ++--+
>
> | id_ingenio | cantidad |
>
> ++--+
>
> | 1 | NULL |
> | 2 | NULL |
> | 3 | NULL |
> | 4 | 2622.77 |
> | 5 | NULL |
>
> ++--+
> 5 rows in set (0.01 sec)
You can use
Hi all !
i have two tables ingenio and detalle_tanque, detalle_tanque has a
foreign key to ingenio, i want to show all the ingenio values and a
sum of the cantidad field in the detalle_tanque table for each value
in ingenio, but one of the ingenio's values it doesn't exist in
detalle_tanque, i
My question is how do I send multiple sets of data into a stored
procedure
without doing the things I had outlined.
MySQL doesn't have arrays. Pass the data in a comma-delimited string
and PREPARE the statement, or pass it as a temp memory table.
PB
-
L P wrote:
Chris,
thank you fo
Chris,
thank you for the response, but that was not my question.
My question is how do I send multiple sets of data into a stored procedure
without doing the things I had outlined.
On 7/17/06, Chris <[EMAIL PROTECTED]> wrote:
L P wrote:
> Folks,
> say I have a need to add multiple rows at the
Thank you to everyone who replied. It turned out I had index corruption and
after running an OPTIMIZE TABLE I was able to convert all the records to
InnoDB.
Thanks,
Frank
At 02:05 PM 7/25/2006, Winn Johnston wrote:
after talking to a few people on the #mysql irc
someone suggested using NFS to create a ramfs to get
100GB+ RAM shared memory to load the entire database
into the RAM. Can anyone offer any Pros or Cons to
this setup, drawing from personal expierence?
t
On Jul 25, 2006, at 12:47 PM, David Nance wrote:
Hi, we have been losing slaves due to errors in replication. See error
message below. Would appreciate if anyone could share if they have
seen same
issues. It seems something may be getting corrupted in the binary log.
Thanks.
The error reads:
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of this many rows?
InnoDB doesn't keep a count on number of rows, like MyISAM does.
InnoDB only main
--- Winn Johnston <[EMAIL PROTECTED]> wrote:
>
>
> --- Jimmy Guerrero <[EMAIL PROTECTED]> wrote:
>
> > Hello,
> >
> > Just to make sure we separate the two...
> >
> > > mysql cluster that preforms reads on all the
> > slaves, and writes only on
> > the master.
> >
> > The above can be used
Hi, we have been losing slaves due to errors in replication. See error
message below. Would appreciate if anyone could share if they have seen same
issues. It seems something may be getting corrupted in the binary log.
Thanks.
The error reads:
Last_error: Error 'Duplicate entry '12312942' for
On 7/13/06, Jim Winstead <[EMAIL PROTECTED]> wrote:
Sounds like the well-known problem with Debian stable's glibc on x86_64:
http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl
Just for the record, this resolved it for us. We applied the patch
mentioned to t
I have a table of type MyISAM that is reporting 47 million rows when I do a
SELECT COUNT(*). When I convert this table to InnoDB, running a SELECT
COUNT(*) returns only 19 million rows. The conversion confirms 19 million
rows were inserted and reports no warnings or duplicates.
I have done the co
Hi Claude, all!
[EMAIL PROTECTED] wrote:
Hi Joerg,
Thank for your answer.
Her e are some details that you requested.
That other request was about MySQL 5.0.18 on Solaris 10, but I do not
remember any answer how that continued.
I have no idea why "libtool" causes such problems on Solaris.
Thanks a lot Michael. I can't believe i didn't see that little detail... that
happens when you're just exhausted, i guess.
Thanks a lot. :-)
Francisco
- Original Message -
From: Michael Stassen
To: Paco Zarabozo A.
Cc:
Sent: Tuesday, July 25, 2006 1:50 AM
Subject: Re
I think if you do it as a enum field, it shows as a checkbox in phpmysql
define it as enum 'Yes','No'
>>>-Original Message-
>>>From: Brian E Boothe [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, July 25, 2006 11:07 AM
>>>To: mysql@lists.mysql.com
>>>Subject: yes or no checkbox
>>>
>>>kn
know this is probably a simple question but if im going to setup a yes
or no checkbox on a table feild on MySQL thru phpmyadmin, how do i do
that ??
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
On 7/25/06, Chris White <[EMAIL PROTECTED]> wrote:
On Tuesday 25 July 2006 02:10 am, Jon wrote:
> CREATE PROCEDURE sp_test1 (IN some_limit int)
> select * from some_table limit some_limit;
>
> and
> CREATE PROCEDURE sp_test2 (IN some_table table)
> select * from some_table;
Well, first off wi
On Tuesday 25 July 2006 02:10 am, Jon wrote:
> CREATE PROCEDURE sp_test1 (IN some_limit int)
> select * from some_table limit some_limit;
>
> and
> CREATE PROCEDURE sp_test2 (IN some_table table)
> select * from some_table;
Well, first off with stored procedures the format is:
DELIMITER $$
CREA
--- Jimmy Guerrero <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Just to make sure we separate the two...
>
> > mysql cluster that preforms reads on all the
> slaves, and writes only on
> the master.
>
> The above can be used to describe a typical use case
> for MySQL Replication.
>
> In a MySQL C
Hi Joerg,
Thank for your answer.
Her e are some details that you requested.
>That other request was about MySQL 5.0.18 on Solaris 10, but I do not
>remember any answer how that continued.
>I have no idea why "libtool" causes such problems on Solaris.
>
I already red this email, but this has no
But the scope of a prepared statement is only the session? I want a stored
procedure to avoid some sql in clientside code...Or do you mean a prep in
the stored?
/Jon
On 7/25/06, Burke, Dan <[EMAIL PROTECTED]> wrote:
If I understand correctly, what you need is prepared statements.
http://dev.
Hi Claude, all!
[EMAIL PROTECTED] wrote:
Hi,
I am compiling/installing MySQL 5.0.22 on Solaris 9 (patched). I received
the following error message .
Making all in zlib
make[2]: Entering directory `/tmp/mysql-5.0.22/zlib'
/bin/bash ../libtool --preserve-dup-deps --tag=CC --mode=link gcc -O3 -D
If I understand correctly, what you need is prepared statements.
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html
Dan.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon
Sent: Tuesday, July 25, 2006 7:44 AM
To: Visolve DB Team
Cc: mysql@lists.mysql.c
Hello,
MySQL Cluster has been available since version 4.1.
For production purposes we recommend the GA version of 5.0.
For the testing of new features (Disk-Data, Replication, etc) take a look at
the latest 5.1 version.
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
> -Original Mess
On 7/25/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote:
On 7/25/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote:
> Hi ALL
>
> I want to implement MySQL Cluster, are there any step by step guide to
> implement it
>
> Thanks and Regards
>
> Kaushal
>
Hi
Is cluster suite is available only in version
Are you sure this is the right line - I mean the whole statement?
You are right, I did not include the whole statement. Here's the entire
section:
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION
SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTI
Sorry pal: It runs on Unix and NetWare.
What version are you using? I assume Windows at least ( if still looking
for an .exe :-) ) Then please read this:
http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html
"8.13. mysqlhotcopy — A Database Backup Program
Aaah. I missed that. Shows how
Jesse wrote:
I have a backup that was created by a MySQL 5 server using MySQLDump.
When I try to restore the database using the following command:
mysql -u root -p -D BPA < c:\backup\mydata.sql
I get the error:
ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax;
check the
Jesse wrote:
I read in the manual that MySQLHotCopy would be better than MySQLDump
for backing up MyISAM tables. However, I cannot find a .exe in the bin
directory by that name. I found a script by that name in a 4.1
installation that I have, but I don't think it's the latest version. Is
th
On 7/25/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
Hello Jon.
Hi there Team :)
And thanks for the quick reply
Could you tell me the version of MySql ?. You can find the version by
excuting the command
SELECT version()
If the version is below 5, the stored procedure feature would not
hi all.and tank you mr logan.i read the ldconfig man page but cant find any
things.
when i execute following command:
#ldconfig -v | grep mysql
the following lines appeared:
ldconfig: Can't stat /usr/X11R6/lib/Xaw95: No such file or directory
ldconfig: Can't stat /usr/X11R6/lib/Xaw3d: No
On 7/25/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote:
Hi ALL
I want to implement MySQL Cluster, are there any step by step guide to
implement it
Thanks and Regards
Kaushal
Hi
Is cluster suite is available only in version of MySQL 5 and above.
Regards
Kaushal
--
MySQL General Mailing L
Hello Jon.
Could you tell me the version of MySql ?. You can find the version by
excuting the command
SELECT version()
If the version is below 5, the stored procedure feature would not work .
Thanks
Visolve DB Team.
- Original Message -
From: "Jon" <[EMAIL PROTECTED]>
To:
Sent
Hello Kaushal,
You can get the MySQL clustering details from the following link.
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-quick.html
http://dev.mysql.com/doc/refman/5.0/en/index.html
Thanks,
ViSolve DB Team
- Original Message -
From: "Kaushal Shriyan" <[EMAIL PROTECTED]>
Hi Kaushal,
I hav the strong impression you did not look at all to find the answers
you seek. A quick search on www.mysql.com gave me 836 hits.
My advice would be: Go start reading some documentation regarding Clusters
in general and the use of MySQL in such a configuration.
Kind Regards,
--
Pe
Hi ALL
I want to implement MySQL Cluster, are there any step by step guide to
implement it
Thanks and Regards
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi list
I'm trying to make stored procedures use parameters for limit and tables, I
guess this is either me using the wrong datatype or it's not possible. I'm
having the same issue with seting the table for the query:
CREATE PROCEDURE sp_test1 (IN some_limit int)
select * from some_table limit
50 matches
Mail list logo
