Hi, Eugene!
Sorry, my last post was sent too soon.
I suspect that you have run into locking issues with your table, which I
am guessing is a MyISAM table. MyISAM uses table-level locking - that
is, only one write operation can occur at any time on the table. Other
operations are blocked un
Hi, Eugene!
I suspect that you have run into locking issues with your table, which I
am guessing is a MyISAM table. MyISAM provides only table-level locking
- that is, only one write operation can occur at any time on the table.
Other operations are blocked until their turn comes.
It appe
Hy Guys,
I have a simple structure of tables, howewer has 50 million of registers and
2,5 GB of data.
The table is MyIsam and has 4 integer fields and 1 Text field, one primary key
with two integer fields
and one btree index with one integer field.
There is a select in this table using an index
Scott,
Perfect. This is exactly what I needed. Is there some place I get
some more documentation on the specifics of the ISO-compatible
queries? Might save me some hair-pulling-out in the future.
See 'Changes in 5.0.12' on the Joins manual page
(http://dev.mysql.com/doc/refman/5.1/en/joi
Perfect. This is exactly what I needed. Is there some place I get
some more documentation on the specifics of the ISO-compatible
queries? Might save me some hair-pulling-out in the future.
Scott
Peter Brawley wrote:
> Scott
>
>>SELECT *
>>FROM UserInfo u, DslInfo d
>>LEFT JOIN DslExtra e ON d.Ds
Scott
>SELECT *
>FROM UserInfo u, DslInfo d
>LEFT JOIN DslExtra e ON d.DslID = e.DslID
>LEFT JOIN ExtraAddr a ON a.UserID = u.UserID
>WHERE u.UserID = d.UserID;
>However it appears this syntax is not valid in MySQL 5.x
Right, as the 5.x docs say, 5.x wants ISO-compatible explicit joins, ie
SEL
I have four tables that I join to get one record set about a
customer. They are: UserInfo, ExtraAddr, DslInfo, and DslExtra.
Specifically the main tables are joined with:
SELECT * FROM UserInfo u, DslInfo d WHERE u.UserID = d.UserID;
I've been adding more data to other tables and LEFT JOINING to
Thankyou for pointing that out Daniel.
Regards
Keith
On Mon, 22 May 2006, Daniel Orner wrote:
> To: mysql@lists.mysql.com
> From: Daniel Orner <[EMAIL PROTECTED]>
> Subject: Re: Sparse 1.0b - framework for MySQL programs
>
> Hi,
>
> According to the CC license,
> "Creative Commons lic
On 5/22/06, Winanjaya - CBN <[EMAIL PROTECTED]> wrote:
> Dear Expert,
>
> I am very new to MySQL replication, I need to replicate my DB on 5 branches
into 1 DB at Head Office.
>
> eg.
>
> MyDB at Branch A need to be replicated to MyDB at Head Office
> MyDB at Branch B need to be replicated to MyD
Only with MySQL 5.0 is multi-master replication possible. Guiseppe
Maxia has a wonderful article about it at:
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
-Sheeri
On 5/22/06, Winanjaya - CBN <[EMAIL PROTECTED]> wrote:
Dear Expert,
I am very new to MySQL repli
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
In the last episode (May 22), Alain Roger said:
> I would like to make a dump of my database.
> however, i have some stored procedure and they are not exported to the *.txt
> file i've created via mysqldump.
>
> So, how can i dump stored procedure ?
Add the -R flag to mysqldump:
-R, --routin
Hi,
I would like to make a dump of my database.
however, i have some stored procedure and they are not exported to the *.txt
file i've created via mysqldump.
So, how can i dump stored procedure ?
thanks a lot,
Alain
Hi,
According to the CC license,
"Creative Commons licenses are not intended to apply to software. They
should not be used for software."
So I'm not entirely sure why you're recommending it. ^^; It is
released under the GPL.
--Daniel
"Keith Roberts" <[EMAIL PROTECTED]> wrote in m
Dear Expert,
I am very new to MySQL replication, I need to replicate my DB on 5 branches
into 1 DB at Head Office.
eg.
MyDB at Branch A need to be replicated to MyDB at Head Office
MyDB at Branch B need to be replicated to MyDB at Head Office
MyDB at Branch C need to be replicated to MyDB at H
Hi, list!
I have a little table (about 0.5 milloin records) which is kind of
queue. My perl script takes records from it one by one and does somes
actions.
Here's my table structure:
mysql> desc queue;
+--+-+--+-+---+---
http://dev.mysql.com/doc/refman/4.1/en/encryption-functions.html
On 5/21/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi Guys,
Can somebody enlighten me on AES_CRYPT & AES_DECRYPT functions on
MySQL. I noticed that you can mention DES key file in mysqld statup
options. how does the AES work
Uh, I don't have anything to add to this thread except that this was
the *exact* problem I was trying to solve and this really helped me a
lot. Thanks guys.
-BL
On 5/22/06, Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
> Hi,
>
> Greatly appreciated your kind help. Would it wor
Well, you're going to need to state how big a record is, what OS
platform you're using, what MySQL version you're using, and exactly
what error message you get when you're trying to insert that 5th
record.
Your my.cnf would help, too.
-Sheeri
On 5/22/06, Eko Budiharto <[EMAIL PROTECTED]> wrote:
As an addendum to this -- this was solved. The master and slave were
out of sync.
-Sheeri
On 5/19/06, Jeremy Cole <[EMAIL PROTECTED]> wrote:
Hi Sheeri,
> So I've seen replication break a few times due to duplicate queries.
> A few times it was around a server crashing, but I thought perhaps i
Hi Eko!
It shouldn't be an issue with table size. More likely, it is due to
duplicate records in the import file. Can you post the SHOW CREATE
TABLE for your table in full (including primary key information)? Also,
any output from your import run would be useful.
Thanks!
--
Jay Pipes
Co
Yesmin Patwary wrote:
Hi,
Greatly appreciated your kind help. Would it work, if I rewrite your query as below to remove all records from company_db that don't have any relation to other two tables?
DELETE
FROM company_db c
LEFT JOIN person p
ON c.company_id = p.company_id
LEF
fool.ben wrote:
>Hi everybody!
>I've install a mysql server on my computer. The operating system is Redhat
>fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect
>to the server using the following statement:
>$db_connection=mysql_pconnect("localhost","root","");
>The serv
Hi everybody!
I've install a mysql server on my computer. The operating system is Redhat
fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect
to the server using the following statement:
$db_connection=mysql_pconnect("localhost","root","");
The server returned the error 2
Hi Venu,
I would like to know the OS your using (for mysql server), BTW if
your using window. Try installing the myodbc and configure it so that
vfoxpro can communicate with it.
check this site:
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP
At 06:28 PM 5/22/2006, VenuGop
Hi all,
I have got a database in mysql and i need to use the gis and that was in
VFOXPRO.I need to display my data which is mysql on the map which database
is in VFoXPRO.Is there any way to have communication betweeen these two DBs.
Thanks and regards,
venu.
I'm doing a little something for the earth, and I thought I'd invite
you to join me:
http://friends.earthscreen.com/?r=EQFEKDIIICdXCWoICigC&i=gmail&[EMAIL
PROTECTED]&p=2&z=1&tc=23
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
I'm doing a little something for the earth, and I thought I'd invite
you to join me:
http://friends.earthscreen.com/?r=UQF0KDIIICdXCWoICigC&i=gmail&[EMAIL
PROTECTED]&p=2&z=1&tc=23
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
28 matches
Mail list logo