Re: Newbye speed question

I wonder why you have 19 fields in a single table. I don't think there is really any way to predict it, since it depends on so many different factors. On Fri, 3 Oct 2003 11:19:56 +0200, Peer Reiser <[EMAIL PROTECTED]> wrote: | Fortunately the database is not in production :-) but it should go

Re: Updated: How to write this query

On Wed, 1 Oct 2003 16:58:26 -0500, sean peters <[EMAIL PROTECTED]> wrote: [...] | So ive been running a query like: | SELECT A_data, B_data, C_data FROM A, B, C | WHERE A.A_ID = B.A_ID | AND A.A_ID = C.A_ID | AND A.A_ID = 4; | [...] | | What i really want is to get the A_data from A, and if there

Re: random record

I just checked... 83 On Mon, 15 Sep 2003 13:54:53 +0100, "Andy Eastham" <[EMAIL PROTECTED]> wrote: | 39? | | > -Original Message- | > From: tuncay bas [mailto:[EMAIL PROTECTED] | > Sent: 15 September 2003 13:32 | > To: mysql | > Subject: random record | > | > | > hi, | > | > why its

Re: Doing Differential backup

On Wed, 20 Aug 2003 18:44:04 -0500, Miguel Perez used a few recycled electrons to form: | | Hi list, | | Does any know how to do differential backups or does exist a tool | that do this kind of backups. | | I have mysql 4.0.12 and use innodb tables, mysql is running on | redhat 7.3 You are prob

Re: moving MySQl database

Check your ownerships and permissions. On Thu, 21 Aug 2003 00:27:05 +0800, Jon Miller used a few recycled electrons to form: | I've tried moving the database from one partition to another and now I'm getting the following error: | # Starting mysqld daemon with databases from /data/mysql | 03082

Re: Master/Master Asynchronous replication

On Mon, 28 Jul 2003 22:23:06 -0700, Jeremy Zawodny used a few recycled electrons to form: | On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote: | > | > Currently we have a web based application that is mostly reads (4:1 | > r/w). It is using a single MySQL database server. Is there

Re: Fw: check

Use an ENUM() On Mon, 14 Jul 2003 23:57:56 +0200, "Alex82" <[EMAIL PROTECTED]> wrote: | so what can i do to make a column accetp only certain values...there are any | other solutions? | - Original Message - | From: "Egor Egorov" <[EMAIL PROTECTED]> | To: <[EMAIL PROTECTED]> | Sent: Monday

Re: How can a single row with a single column represent 2 values without bitwise data representation

column type and then using mysql's FIND_IN_SET() function in your where clause. -- Michael Brunson 504.200. [EMAIL PROTECTED]ICQ: 83163789 Data Center Manager -- www.zipa.com --Zipa, LLC -- MySQL General Mailing List Fo

Re: Table design suggestions?

ate it! This scheme will give you the most flexibility. There is no limit as to how many people can be in a group or how many groups a person can be in. You will want to create a joined unique key on the group_id and member_id. Have Fun! Michael -- Michael Brunson

Re: Thoughts on MySQL training?

management. I went to one over a year ago.. and I liked it so much that I convinced our CEO to get the trainer (Jeremy) in for a week to train all our developers. Definitely worth the price. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED]

Re: composite keys indexing

On Tue, 1 Apr 2003 20:30:32 -0800 (PST), Jinesh Varia used a few recycled electrons to form: | Hello group, | | I have a simple composite key | create table a_b (aID int NOT NULL, bID int NOT NULL, primary key | (aID,bID)); | | Where aID is primary key in the table a and bID is the primary key in

Re: MySQL & mail servers

On Tue, 1 Apr 2003 13:15:00 -0800, Jeremy Zawodny used a few recycled electrons to form: | On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven Nakhla wrote: | > | > Are there currently any open-source mail servers that utilize MySQL? | | Yes, many. | | > I know that there are some that will authenti

Re: SQL optimization problem

LEFT JOIN On Sat, 11 Jan 2003 18:35:44 +0100, Blaster used a few recycled electrons to form: | Hey, | | (this post is pretty long, a short version of the problem is listed at the | bottom if you don't like reading long emails :P) | | I'm currently going through all my SQL queries for my webpa

Re: update and data manipulation

On Thu, 17 Oct 2002 03:50:47 +0100, Nikolas Galanis used a few recycled electrons to form: | Hello | | When I want to update a value, I can use numerical functions like +,* | etc. Can I do the same with strings? For example, when I want to append | a string in an existing value, how (if of cou

Re: MySQL Replication

| | TIA Only put in select privileges in the permission tables. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.com

Re: Anyone get MySQL and RH7.2 to work?

On Thu, 7 Mar 2002 22:20:46 -0500, Paul Warren used a few recycled electrons to form: | I've been frustrated with this for the past I-donno-how-many days. Has | anyone been able to get MySQL to work on Red Hat 7.2? | | I've been getting multiple errors. The First was the resolveIP() right from |

Re: ENUM -- integers or strings?

PHP will handle your var types for you just fine. If you want to bet sure, so an intval() before you compare. On Fri, 4 Jan 2002 16:18:24 -0500, Erik Price used a few recycled electrons to form: | There's no data in the database yet, so I haven't tested this code. I | don't want to use the mys

Re: Multilingual support

On 4 Jan 2002 06:27:44 -, K Jeevan used a few recycled electrons to form: | hi all |We are using mySQL as our database. Our site needs multilingual support |especially Korean. We tested inserting some Korean fonts into the database. It |accepted the values but while retriving the values

Re: INSERT INTO - need some advice

use the LAST_INSERT_ID() sql function On Fri, 4 Jan 2002 11:32:19 +0800, Arvin Bautista used a few recycled electrons to form: | I had 2 tables, the second table had a field (a key field) that is related | to the field of the first table | | first table

Re: duplicating collumn

ERT INTO t3 (ID,pn,af) SELECT t1.ID, t1.pn, t2.af FROM t1 LEFT JOIN t2 USING ID; ALTER TABLE t1 RENAME t1_old; ALTER TABLE t3 RENAME t1; Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Interco

Re: left join

On Thu, 03 Jan 2002 09:21:45 -0600, Dan Liu used a few recycled electrons to form: | Hi everyone, | I ran a query which is: | select A.a as a,B.b as b from A left join B on A.c=B.c and A.d=B.d order by A.c,A.d; | Both table A and Table B have about 3000 records.And there are about 3000 records in

Re: database,

On Wed, 2 Jan 2002 21:00:59 -0800 (PST), help used a few recycled electrons to form: | database,sql,query,table | | | | | I am new to phpmyadmin, I need to make a db for a | online job resume service site. This site is like | hotjobs but people can also attach photos. I need some | direction o

Replication errors

error. // database,sql,query,table Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.com --

Re: Could you look at this PHP/MySQL Code?

quot;; | $sql3 = "INSERT INTO skills (member_id, name, schooling, | certifications, description) VALUES | ('$member_id','$skill_name','$schooling','$certifications','$skill_descr | iption')"; | $result = mysql_result($sql3); |

Re: WG: Why I will stay with Microsoft SQL Server

y for this problem ? | > | > Greetings | > | > Korbinian Bachl | > www.whiskyworld.de Set-up ring replication, but in your case it would be a very short ring with only 2 nodes. Both computers would act as master and as slaves. You'll have a problem with auto-increment and ma

Re: Why I can't run Mysql program ? Please Help !

he socket file. :-) Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.com -

Re: How can I "select" in multi table

n all of them at the same time but not "select * from table1 |where ..." then | "select * from table2 where ...", then ... | | Thanks | | cb Use a merge table as an overlay to select from. http://www.mysql.com/doc/M/E/MERGE.html Thanks, Michael -- Michael Brunson

Re: Benchmarking

On Mon, 24 Dec 2001 12:37:21 -0800, Joel Wickard used a few recycled electrons to form: | Hello, | I've looked around on mysql.com, and through the directories of my mysql | install I'm looking for information on benchmarking my mysql database, but | I'm not interested in seeing how it performs ag

Re: Help! Languages and Characters....

Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.com - Before

Re: MySQL and kernel upgrade

On Tue, 18 Dec 2001 09:53:32 +0700, Sommai Fongnamthip used a few recycled electrons to form: | Hi, | I was read recommendation from MySQL download page to upgrade Linux Kernel | for latest MySQL version. I have problem because I must still with Linux | Red Hat 6.2 (kernel 2.2.16-3) beca

Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)

your ownerships and permissions. All the directories and files in the mysql data dir should be owned by your mysql user and mysql group. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Inter

Re: Database Synchronization

s need to be done on tables on same server. This is due to the fact that one query can not take 2 connection handlers. | Hope u will not get Angry with bunch of questions Not a problem. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED]

Re: Rename a Database?

| > new | > database? Could someone point me to the details on this? | > | > -- | > Chip Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.

Re: RAID RAID_CHUNKS speed differences

On Thu, 15 Nov 2001 23:29:27 -0800, Jeremy Zawodny used a few recycled electrons to form: | On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote: | > | > Has anyone ran any benchmarks as to what affect different number of | > RAID_CHUNKS has on speed? | | The more chunks, t

Re: Problem related to not equal to function

On Fri, 16 Nov 2001 10:41:31 +0530, Manish Mehta used a few recycled electrons to form: | Hello , | | I have a problem related to not <> or != (not equal to function) . | | The SQL Query is | | select a.cBook_Name from tbl_bookmaster as a , tbl_empbookrelation as b | where a.nb

Re: RAID RAID_CHUNKS speed differences

Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.com On Thu, 15 Nov 2001 16:14:58 -0600, Michael Brunson <[EMAIL PROTEC

RAID RAID_CHUNKS speed differences

er was fully up. The box is a 750 PIII with 756M of RAM, running linux and the 3.23.44 version of mysql. Any suggestions would be great. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED]