Hi,
I am loading a couple of mysql tables through a perl module. Apache loads
this perl module during startup.
But when I query through mod_perl it fetches only limited number of rows
from MYSQL table. rest of the rows are just ignored.
Raw query from the mysql shell yields proper results.
Please
thnx a million paul
got that :)
>So ... why do you want to do this?
well i get really irretated of seein row# 66 right after 5
but seriously i dont know the + or - points of the types
besides my project supervisor just declared v DONT NEED isam
since v dont NEED row 6 after 5 n not
At 5:29 + 6/29/02, toby - wrote:
>hi guyz
>
>i va all my tables " myisam " since its da default type
>
>how can i make isam tables
Add
TYPE = ISAM
to the end of your CREATE TABLE statement.
>
>1. will someone plz guide me with about the syntex
>
>2. how can i change the type of my my
On Friday, 28. June 2002 19:29, Anil Garg wrote:
Hi Anil,
> Now, when i run the following query:
> mysql> select * from xoops_groups_modules_link where type='R' and mid=2 and
> groupid=3 ;
> ERROR 2006: MySQL server has gone away
> No connection. Trying to reconnect...
> Connection id:1
> Cu
Hi Mikhail
What i meant to say is that My First Query returns 3 rows satisfying two
conditions Like CI.IndustryID IN (2,3) and Count(C.CompanyID) = 2
So when i add another OR say (CI.IndustryID IN (2,3) OR C.b2b = 'N') and
Count(C.CompanyID) = 2
I guess it should aways have the possibilty of re
hi guyz
i va all my tables " myisam " since its da default type
how can i make isam tables
1. will someone plz guide me with about the syntex
2. how can i change the type of my myisam tables to isam
:( without having to drop them
thnx a million
toby .
sql, query
___
Hi All
MYSQL Supports Unions in 4.0.1.
Similarly any idea when it will support other SET Operators Like Minus
Regards,
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
Mathieu DESPRIEE writes:
>
> Hi all,
>
>
> I want to setup (on linux systems) a pair of redundant mysql servers,
> working this way :
> * one master and one backup
> * the master handles all the requests, the backup updates its data
> frequently (and, if possible, CONSISTENTLY) from the mast
Hi all,
What are the major differences between BDB and MyISAM separate the fact
that BDB is slower and suports transactions, and MyISAM faster and does
not support transactions ?
(On most recent version of MySQL 3.23)
What are the major avantages/drawbacks of InnoDB ?
Thanks
---
Hi Every Body,
I am not able to install MySQL
(MySQL-Max-3.23.51-1.i386) on Red Hat Linux 7.1.
After running the installer(i.e. rpm file), mysql
folder is getting created at /usr/lid with one
file in it named mysqld-max.sym. I am not able to
proceed from that point.
So, please guide me how to ins
Hi all,
I want to setup (on linux systems) a pair of redundant mysql servers,
working this way :
* one master and one backup
* the master handles all the requests, the backup updates its data
frequently (and, if possible, CONSISTENTLY) from the master
* on failure of the master, the backup come
I have a bit of an issue:
I have just upgraded my version of MySQL on my Cobalt Qube Linux server,
and the installation would appear to have removed (or not created) a
mysql.sock file in the /var/lib/mysql/ directory. It has created a link
in the /tmp/ directory. I have verified that there are
Just made some additional testing...
If you change
Conn2: create temporary table Temp select id, name from test where id = 3;
to
Conn2: insert into Temp select id, name from test where id = 3;
then it won't work too. But if you change it to
Conn2: select id, name from tes
Hi!
> "rhuddleston" == rhuddleston <[EMAIL PROTECTED]> writes:
>> Description:
rhuddleston>The following query results in a different # of rows if the
sql_big_tables is set to 1:
rhuddleston> select count(incidents.ref_no) from incidents, labels where
incidents.ref_no like '020531
Heikki,
Thank you very much for response.
But I still don't understand why do I have lock in Conn1.
Let's go through statement again.
> > Conn1: begin;
> > Conn1: update test set name = 'rat' where id = 3;
InnoDB docs: "UPDATE ... SET ... WHERE ... : sets an exclusive next-key lock
on every rec
hello everyone
i am working on a project in which db is mysql and it should support
japanese and korean simultaneously I have mysql 3.23.36 running on
red_hat_linux_7.1_sea-wolf and default ecoding for mysql is sjis
Kindly tell meif is it possible to make a database support japanese and
korea
Phil,
since InnoDB has its own internal data dictionary, simply renaming a
directory of the .frm files does not rename a database inside InnoDB, like
it does for MyISAM.
To move InnoDB tables to another database you have to do
mysql> USE olddatabasename;
mysql> RENAME yourtable TO newdatabasena
Mikhail,
I think MySQL in this case waits for a MySQL table level lock. Note that
CREATE TABLE ... SELECT ... sets shared locks on the rows it reads in the
SELECTed table.
Workaround: use
SELECT INTO OUTFILE
+
LOAD DATA INFILE
In that way you can avoid locking altogether and do a consistent re
Description:
(1) file:innobase/os/os0sync.c
function: os_event_wait_time
line:237
In this function, it use Windows API
"WaitForSingleObject" while passing a wrong parameter.
Because WaitForSingleObject wants the second
parameter to be quantity
On Fri, Jun 28, 2002 at 09:24:02AM +0530, Arul wrote:
> Hi
>
> Just was curious to know...
>
> I saw a posting by one of the guys here that Yahoo uses MySQL. Is
> this true..
Guilty as charged.
>
> Any idea how many MySQL servers does Yahoo Use amd for which domain
> they use MYSQL.
How many
20 matches
Mail list logo
