Re: PHP or Perl?

In the last episode (Aug 15), Mark Healey said: > As part of my own learning mysql project I'm planning to build > databases for all my books and DVD's. Stephen Hawking is probably a > better typist than I am so I plan to use barcodes to get the info > ,taking the information from various web s

PHP or Perl?

As part of my own learning mysql project I'm planning to build databases for all my books and DVD's. Stephen Hawking is probably a better typist than I am so I plan to use barcodes to get the info ,taking the information from various web sites. People tell me that PHP is THE way to do database wo

Trying to install MySQL on Win98

Hi, I downloaded MySQL 3.23.57 for Windows as I wish to learn MySQL locally and then use the one I already have installed on my UNIX server. I ran setup and rebooted but the WinMySQLadmin program will not start the Server as it has a MyODBC error "Driver 3.51 Not Found". I c

Re: Secure Database Design Part II

Hi Steven, I believe I understand your concerns. I think the only way to reduce the risk of associating the wrong data is tripple checking it by different persons or even better make two tables which you can compare against each other. The second table only readable to you. This way you could a

Re: Bi-directional Replication

I'll forward this conversation to the list since I'm no mysql guru and others with more knowledge might step in. Glen Boyer wrote: Let me ask you this, If I may ? You have Server A in San Diego and Server B in New York You have replication between A ---> B You have replication between B ---> A

Re: Bi-directional Replication

Eric wrote: Hi, Do you know of a database that can do such a thing? sorry, no I don't. MySQL is the only DBMS with replication I found, yet. There is a replication project with PostgreSQL but it's not in the official distribution the last time I checked. In the announcement of the cooperation

replication and internals

Replicating queries where re-written to fix various bugs, most notably time and auto-increment bugs. Why doesn't replication also enforce rewriting INSERT INTO into INSERT DELAYED / etc. I've notice that the replicating thread in 3.23.5x will wait for a table instead of going onto another log e

Re: Optimizing imports

On 15 Aug 2003 at 16:34, Jackson Miller wrote: > However I want to know how I can > optimize my insert statements to try to speed things up. Have you read this? http://www.mysql.com/doc/en/Insert_speed.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.o

Optimizing imports

I need to have a web application be able to import large amounts of data (400,000 rows of 10 columns). I know how to script it and have it running in the background. However I want to know how I can optimize my insert statements to try to speed things up. Will it help if I insert multiple row

Re: querie assitance

At 15:52 -0500 8/15/03, Rob Yelvington wrote: I need some help with a query. I have two tables in one data base that both have a SSN field. The ssn field in one table contains slashes and the ssn field in the other does not. I know how to use CONCAT() and RIGHT(),MID(), and LEFT() on one of the s

querie assitance

I need some help with a query. I have two tables in one data base that both have a SSN field. The ssn field in one table contains slashes and the ssn field in the other does not. I know how to use CONCAT() and RIGHT(),MID(), and LEFT() on one of the ssn fields to obtain a result with digits only

RE: Bi-directional Replication

-->-Original Message- -->From: Mark T. Dame [mailto:[EMAIL PROTECTED] -->Sent: Friday, August 15, 2003 1:38 PM -->To: MySQL Mailing List -->Subject: Re: Bi-directional Replication --> -->On 08/15/03 16:01, Andreas wrote: -->> -->> I did this some time ago. -->> -->> Host A and B -->> You

MySQL embedded server example bug

Hi Team: I've found a bug in the example presented in the Official MySQL Manual in the section 9.1.15.6 A Simple Embedded Server Example. I tried to compile the program following the instructions depicted in the manual and a compiling error arose. The error was: gcc -g -W -Wall -I/usr/

Secure Database Design Part II

Hey folks - Thanks to everyone who gave input to my concerns. Of course, we don't intend to have the mysql port open to the world. We will have Apache/PHP connect on a unix socket, or to another machine with a cross-cable on non-routeable IPs. But now I have another question. We are working on a

Re: Bi-directional Replication

On 08/15/03 16:01, Andreas wrote: I did this some time ago. Host A and B You just configure host A as master and host B as slave of host A. Then you do the same vice versa. There is a description in the manual. > A BIs a circle. < I have this set up, but I also have other sla

About Embedded MySQL server

I've installed the last stable MySQL version (4.0.14-standard) under Linux, (Suse-8.0) kernel 2.4.28-64GB SMP, form the binary distribution that i downloaded from www.mysql.com. I'm interested on implementing the embedded server within my clients programs but the distribution do not have inclu

Re: Bi-directional Replication

Glen Boyer wrote: Can anyone tell me if your product can or will do Bi-Directional Replication. I did this some time ago. Host A and B You just configure host A as master and host B as slave of host A. Then you do the same vice versa. There is a description in the manual. > A BIs a

RE: Bi-directional Replication

mySQL can do that but will break on primary key violations. Also mySQL a slave can only have one master. Try log-slave-updates in my.cnf on the slave so A -> B -> A or you can have a replication ring A-> B -> C -> A Make sure your server-id is unique among all master / slaves. -->-Origi

Bi-directional Replication

Can anyone tell me if your product can or will do Bi-Directional Replication. We are currently using MS-Access which has A Desiggn Master and Replica's that can exchange information (data) back and forth between replica's. Is there any way to do this with MySQL ? We are looking for a database sy

Re: Q: Delete subselect

[EMAIL PROTECTED] wrote: > > I know that MySQL 3.23.nnn did not support a delete subselect, just wondering > what the best/most efficient way to do the following is: > > delete from table_a where table_a.column_1 in ( select column_1 from > table_b); > > Assuming that column_1 is the same da

Re: I simply can't compile this

"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > [skip] > ALTER TABLE EMPLOYEE # here is the buggy code > ADD FOREIGN KEY (DNO) REFERENCES DEPARTMENT(DNUMBER) > ON DELETE SET DEFAULT > ON UPDATE CASCADE; > > ALTER TABLE DEPARTMENT > ADD FOREIGN KEY (MGRSSN)REFER

RE: MySQL to syslog

I am not sure that MySQL can directly log to syslog but Unix provide this logger - make entries in the system log logger [-t tag] [-p pri] [-i] [-f file] [message...] So you use MysQL to put messages in a file and then use logger to send it to syslogs. This is how we do it too. Regards, -O

Re: Character case conversion problem

"Tumurbaatar S." <[EMAIL PROTECTED]> wrote: > I'm running MySQL 3.23.55 on WinXP and > have some problem using non latin charset. > I've added these 2 lines under [mysqld] group > of my.ini: > > character-sets-dir = c:/mysql/share/charsets/ > default-character-set=cp1251 > > Then restarted server

Re: Is query possible? (Newbie)

If I understand your question correctly, what you want is: SELECT first_table.*, second_table.end_date FROM first_table LEFT JOIN second_table ON first_table.primary_key=second_table.primary_key cheers, Jan Sometime recently Grant Cooper said: > I have 2 tables used for an online calendar...

Re: Better query method?

suppose your table is people. select people.Name, count( *) as cParent from people left join people as p on ( people.ID=p.Parent) group by people.Name order by cParent I have not tested this. You have to make indexes on Parent and ID. Santino At 8:36 -0500 15-08-2003, John Macon wrote: Hi all,

MySQL to syslog

Is there now a way within MySQL to log to syslog? I was reading an archived email conversation between Sinisa Milivojevic and Vincent Stoessel in which they seemed to indicate that there was no need to log to syslog. As Vincent only had a request for timestamps in the error log, Sinisa simply satis

Better query method?

Hi all, Long time reader, first time poster, I hope that I get this right. I am setting up a database that reflects a relationship between two records without using the primary key as the tie between the two. I need to make a list of these based on the number of children each has, and I am hav

AW: I simply can't compile this

Hi! I know older versions of MySQL do not support foreign keys. Find out weather your version do. If not, you may have to do without the foreign keys in your definitions. Best regards Babs -Ursprüngliche Nachricht- Von: Morten Gulbrandsen [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 15.

Re: notification when replication stops.....

Tom Roos wrote: > > hi > > every now and then my replication stops. i now about this when i logon 2 the slave > and check the status. > > what is the best procedure i would follow 2 automate a notification message when > replication stops? > > i ryn mysql 4.0.13 on rh linux > > tks > >

About Embedded MySQL server

I've installed the last stable MySQL version (4.0.14-standard) form the binary distribution. I'm interested on implementing the embedded server within my clients programs but the distribution do not have included the libmysqld.a library. There is a possible solution to this without having to g

Character case conversion problem

Hi, I'm running MySQL 3.23.55 on WinXP and have some problem using non latin charset. I've added these 2 lines under [mysqld] group of my.ini: character-sets-dir = c:/mysql/share/charsets/ default-character-set=cp1251 Then restarted server and created a simple database with a string fields. 'myis

Re: Query with inner join (Help!)

Hi Fongo, Steve gave a perfect explanation ( and made me realize my and Egor's small mistake ;-) 2003年 8月 15日 金曜日 17:08、Nils Valentin さんは書きました: > Hi Fongo, > > http://www.mysql.com/doc/en/JOIN.html > > > Should work like this (untested): > > SELECT Customers.Name, Customers.City, Orders.Produc

I simply can't compile this

CREATE TABLE EMPLOYEE ( FNAME VARCHAR(15) NOT NULL, MINIT CHAR, LNAME VARCHAR(15) NOT NULL, SSN CHAR(9) NOT NULL, BDATE DATE, ADDRESS VARCHAR(30), SEX CHAR, SALARY DECIMAL(10,2), SUPERSSNCHAR(9), DNO

Re: replication blues

"Primaria Falticeni SDU" <[EMAIL PROTECTED]> wrote: > I met the same problem Problem with auto_increment column? If so I wasn't able to repeat it with master_connect_retry=2. >and I noticed that you need, on the slave, set > connect_retry to 2 (connect_retry is the time after which the slave retr

AW: Query with inner join (Help!)

It works! SELECT Customers.Name, Customers.City, Orders.Product, Order.Price FROM Customers INNER JOIN Orders ON Customers.cust_id = Orders.cust_id WHERE cust_id = 2; Thanks a lot. -Ursprüngliche Nachricht- Von: Egor Egorov [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 15. August 2003 1

RE: Is query possible? (Newbie)

Grant, Could you please be a bit more specific? What do you mean when you say "I want to create a query that will take all the fields in. If no end_date exists then set to NULL."? Thanks -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 4:11

Re: log-bin not created

Sohail Hasan <[EMAIL PROTECTED]> wrote: > I am using mysql version 4.0.12 on a solaris sparc box. My server has > stopped creating the log-bin files although it is defined in my.cnf. The > directory permissions of the data directory are fine. What is wrong with > the setup? Is extention of log

Re: Query with inner join (Help!)

"B. Fongo" <[EMAIL PROTECTED]> wrote: > > I ' m trying to extra some information from 2 tables using inner join, > but receive an error warning. Am newbie so I' m not able to feature out > why my queries don't work. > > Scenario: > > I have 2 tables: Customers and orders. The have following str

Re: Query with inner join (Help!)

Hi, You need to put the Join in the FROM section of the query, not the WHERE. That is to say, move this WHERE cust_id = 2 inner join Orders ON Customers.cust_id = Orders.cust_id to FROM Customers inner join Orders ON Customers.cust_id = Orders.cust_id You could acutally use this method i

Re: Query with inner join (Help!)

Hi Fongo, http://www.mysql.com/doc/en/JOIN.html Should work like this (untested): SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from Customers, Orders WHERE Customers.cust_id = Orders.cust_id AND cust_id = 2 inner join Best regards Nils Valentin Tokyo/Japan 2003年 8

Query with inner join (Help!)

Hello! I ' m trying to extra some information from 2 tables using inner join, but receive an error warning. Am newbie so I' m not able to feature out why my queries don't work. Scenario: I have 2 tables: Customers and orders. The have following structures: Customers

notification when replication stops.....

hi every now and then my replication stops. i now about this when i logon 2 the slave and check the status. what is the best procedure i would follow 2 automate a notification message when replication stops? i ryn mysql 4.0.13 on rh linux tks _ ___ _ __ /______

RE: Transactions tutorial

Try Microsoft's "Inside SQL Server 2000" by Delaney. -Original Message- From: Thomas Svenson [mailto:[EMAIL PROTECTED] Sent: 15 August 2003 01:44 To: MySQL list Subject: Transactions tutorial I'm looking for any online resources/tutorials and such about transactions. Preferable for MySQL