Re: Turn off autocommit

At 17:13 05/12/01 -0600, Demirchyan Oganes-AOD098 wrote: Hi, >Hi everyone, > >I'm using InnoDB tables, and I would like to turn the auto commit off. >I do SET AUTOCOMMIT=0 in my.ini file. > >And when I restart the server, it won't start. This condition should be executed by the client which is q

Re: Replication Problem on MySQL 3.23.45/Win32

At 12:04 07/12/01 -0800, A. Clausen wrote: Hi, Does print the command "show databases" the db in question ? and you are able for perform commands on the tables using the mysql client tool ? Regards, Miguel >I have been using replication for several months between to Win2k machines. >Last week I

check this out guys

START MAKING MONEY ONLINE!!! I GUARANTEE THIS IS FOR REAL!!! - NO RISK (60 DAYS MONEY BACK GUARANTEE) - VERY EASY (WORK FROM HOME) - GET AVERAGE $130 DAILY on 2 HOURS WORK (more hours more $) - NO SPECIAL SKILLS OR EXPERIENCED REQUIRED (WE WILL GIVE YOU ALL THE TRAINING AND PERSONAL SUPPORT YO

Re: EJB and MYSQL

Hi, [EMAIL PROTECTED] wrote: > > Hi all > > Which version of MySql can support J2EE well? I have ever used > mysql with Jboss (open source of EJB implementation) , it feels some > limitation in comparison with using oralce. > > Why mySQL haven't been support by the BEA weblogic or other main

Re: Packet is Larger than max_allowed_packet from server configuration of 65536 bytes

Hi, Max allowed packet size of a SQL statement is 16MB. Its limit is from structure of MySQL packet. So, please set environment as below. --set-variable=max_allowed_packet=16M Thanks. Chris Stark wrote: > > Hi, > > I am having a problem with the configuration of the mysql server or

Help files??

Greetings! I am new to MySQL. How do I link the help file (*.cnf) to MySQLGUI? I read the readme files, not sure where to put the *.cnf so it is in the path for MySQLGUI. Any help you can give me would be greatly appreciated. (I am learning development in PHP, Apache, and MySQL. I created (from

Re: MYSQL running under WIN98

Dan: Did you start the server (c:\mysql\bin\mysqld-opt.exe)? Gerald Jensen - Original Message - From: "Dan Wolfe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 8:23 PM Subject: MYSQL running under WIN98 After installing mysql specifying nothing but defaul

MYSQL running under WIN98

After installing mysql specifying nothing but defaults, I started mysql without any parameters and then ran "MYSQL TEST" and received the following error message: "Can't connect to mysql server or localhost (10061)". Any suggestions? ---

Re: Need help with SELECT and JOIN pls

I'm no expert in this in fact I just recently started playing with joins, but here's one that I actually used for a recent shopprt cart piece. I appologise if it wraps but the output is long...content conatins the basic content info but product contains the list of prices. Yes I could have jus

Server stuck on "initdb" command

Hi, Does anybody know what the "Init DB" command is in the output from show processlist and why it would take 60 seconds? I can't find anything in the docs or mailing list about it. We've been pushing some servers to the limits and we are starting to routinely see a half dozen connections in a

Need help with SELECT and JOIN pls

Hi, I have two tables: mysql> describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10

RE: 64bit mysql and gcc

> > I just checked out sun-freeware and they have recently released gcc 3.0.2. > I am downloading this now and as soon as I get some time over I will > see if this can be used to generate 64 bit binaries. I just checked on this. The gcc package from sun-freeware was not built with 64bit support

Re: Query Question Additional Info

Thanks for all your suggestions, I apparently had a brain cramp. Problem solved. Thanks, Steve - Original Message - From: "Steve Osborne" <[EMAIL PROTECTED]> To: "MySQL (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 1:36 PM Subject: Query Question Additional Info > > I a

RE: Creating MySQL table w/2 primary keys

What is your goal here? Is this a file linking two other files, the group_conclusion file and the Pad_analysis_result file? Or something like that? Where you search for all of the records with a single group_conclusion and then reference the analysis_result records? My first question is are these

innodb won't allocate the memory i ask it to

I have a system with 1gig of ram and i am trying to get the innodb buffer to be about 750megs. Whenever I set the value in the database config file it won't start with an error along the lines of, 011207 21:02:42 mysqld started InnoDB: Fatal error: cannot allocate 67108864 bytes of InnoDB: memor

RE: Query question

Oops, sorry missed the fact that it's two different tables. Try this... $result=mysql_db_query("database_name", " Select user.email_login, user.password, owner.activeuser from user, owner where email_login like '$name' and password like '$password' and user.nameid like owner.nameid;");

RE: Query question

$query = "SELECT User.* FROM User,Owner WHERE email_login=$login_name && password=PASSWORD($password) && activeuser=\"Y\" "; $result = mysql($query) or die("Error: ".mysql_error()); if( mysql_num_rows($result) != 1 ) { ...not an active/valid user ... } -Original Message- From: Steve

Re: Query and join problem with null values

Thanks ! It's exactlly what I wanted. I got the same result a few seconds ago using EMS MySQL Manager but I didn't understand how. Your example is much better ! What is the difference between a LEFT JOIN and a LEFT OUTER JOIN ? And of course you're right for the data type ; Thanks again A

Re: Query question

I don't get the question.. you just have to compare the values out from the database with the values from the user input. my $sth = $dbh->prepare("SELECT usremail, usrStatus from users where usrName = ?"); $sth->execute(param{'name'}); my ($email,$status) = ($sth->fetchrow_array); print "invalid

Seeking alternatives to nested subquery

Hello. I am writing an application for educational research that allows users to transcribe digital video and apply analytic keywords to segments of that video. Users are then able to search for instances of these keywords during the process of analyzing their data. I am in the process of alter

Re: Replication Problem on MySQL 3.23.45/Win32

No, it is not directly supported, but, according to the manual, using the option "use-symbolic-links" and placing the file "database_name.sym" in the MySQL data directory, with a line pointing to the location of the database files, you fake it. A. Clausen [EMAIL PROTECTED]

Query Question Additional Info

I am trying to validate a user in a login form. There are 3 things that must be true. User login name = email_login (from User table) User password = password (from User Table) User must be active: activeuser (from Owner table) = 'Y' The Owner table does have a common field with the User Table

Re: Creating MySQL table w/2 primary keys

that doesn't create two primay keys it uses both colums to form the primary key, which is A LOT different. if you use primary key (a,b) be sure to put a and b not null AND unique. otherwise you could have duplicates in either of these rows. also, if you are fetching rows based on b, it WILL NOT u

Re: Mysql 4.0

Hi, glad to hear that it is not only me... I got the same error on Pentium 200MMX, even when compiling the source. I found that configure prepared gcc for Pentium Pro, so the quick and dirty fix was to hardcode Pentium into the configure script. This must be a bug... Tor Rune Skoglund, Gyldenlø

Query question

I am trying to validate a user in a login form. There are 3 things that must be true. User login name = email_login (from User table) User password = password (from User Table) User must be active: activeuser (from Owner table) = 'Y' I don't know why I'm having so much difficulty with this SQL

Re: replication

Thanks for the reply Jeremy... What I need actually is a cluster. We have lots of users using lots of small databases... Our users should send a query to one server, and somehow we must load balance that... I think I'd better get more hardware to that server, until mysql come up with a clusteri

Re: Replication Problem on MySQL 3.23.45/Win32

I'm not sure, But I don't think symbolic links are allowed on win2k... Take a look into this... Regards, gustavo On Fri, 2001-12-07 at 12:04, A. Clausen wrote: > I have been using replication for several months between to Win2k machines. > Last week I upgraded to MySQL 3.23.45, an

RE: Can this be done?

UPDATE myTable SET DueField = 0, StatusField = IF(StatusField = 'O', 'C', StatusField) WHERE PrimaryKeyField = "XYZXYZ"; -- Greg Johnson -Original Message- From: Chris Boget [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 1:42 PM To: [EMAIL PROTECTED] Subject: Can this be

Re: Query and join problem with null values

mysql> create table users( -> usrID smallint unsigned auto_increment, -> usrZip char(5), -> primary key(usrID)); Query OK, 0 rows affected (0.00 sec) mysql> create table cities( -> ctyZip char(5) not null, -> ctyName varchar(30) not null, -> primary key(ctyZip)); Query OK,

Replication Problem on MySQL 3.23.45/Win32

I have been using replication for several months between to Win2k machines. Last week I upgraded to MySQL 3.23.45, and everything continued working fine. Yesterday, I put the line "use-symbolic-links" in the my.cnf file because I've created a very large database that I have another drive reserved

Re: Database Synchronization

On Fri, 7 Dec 2001 03:07:56 -0800 (PST), Pragneshkumar Gandhi <[EMAIL PROTECTED]> wrote: | Hi All | I am New Subscriber to this mailing List. | This is Pragneshkumar from India. | | I have one Application Which are wriitten in java/jsp and | using mysql as db. | | Now this application is running

sorting question

hi, i have to sort a list of alpha-numeric data, this is what the list should look like when i give an order command: 123a 123b 123c 123A 123B 123C but this is the result: 123a 123A 123b 123B 123C some fields he puts the capital letters first 123c How can i become the list above, i'v

Re: Creating MySQL table w/2 primary keys

I do it all the time, just go primary key c (a,b) A. Clausen [EMAIL PROTECTED] - Original Message - From: "sherzodR" <[EMAIL PROTECTED]> To: "Demirchyan Oganes-AOD098" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 11:58 Subject: Re: Crea

RE: Query and join problem with null values

Thanks for your answer. It's quite logical indeed... I'm new to SQL ! Does it mean that I can't query on several tables at once if some keys have a NULL value or is there another way ? What I want is one line for my peopleId 2, built with informations from several tables... Or in other words I

MySQL in Cobalt Raq

Please i need enable MYSQL to mi customers in mi cobalt raq 3 can helmpe?' MySQL stay installed and runing,, please sendme info for enable to other users od server. Best regrads Pablo - Before posting, please check: http://w

Re: A bug or problem

Leonardo, >Hello there. > >I just found something that I couldn't exactly call a bug. Certainly it >is a problem. > >If I have a InnoDB table with an auto_increment field and try to insert >a row in this table, it will increment the field in question normally. >The problem happens when the query

RE: Importing for MicroSoft Access 97

Hi, > -Original Message- > From: Hajar Abdus-Sabuur [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 07, 2001 7:29 AM > To: [EMAIL PROTECTED] > Subject: Importing for MicroSoft Access 97 > > > Hello- > > I created a schema for my database in MicroSoft Access > 97. I would like to

RE: Query and join problem with null values

Michael do the first join people.zip = city.zip yo get 2 rows from people 1 and 3 notice there is no peopleid 2 from first join so correct answer is to retun null Rick -Original Message- From: Michaël Delorme [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 11:00 AM To: [EMA

Query and join problem with null values

Hi guys I have a problem on a SQL query : I got no records selected. Below is a sample of my 2 tables : A table identifying people, containing their adress therefore a ZIP code. However for some people I don't have their adress, so no ZIP code : Table People +--+--+ | PeopleID

HELP!! MySQL clinet libraries for codewarrior

Hello I'm currently developing a plugin interface for a development tool (www.runrev.com) which allows access to various databases including mysql on Mac, Win, Unix. However there seems to be no Codewarrior compatible client libraries for OSX..and the release data is a few days away can anybody h

Can this be done?

Is there a way to do this? If so, I've not been able to find it in the documentation... I have 3 fields: PrimaryKeyField StatusField DueField I want to update the DueField to 0 (zero) where the PrimaryKeyField = "XYZXYZ". I also want to update the StatusField for those records to be equal to

A bug or problem

Hello there. I just found something that I couldn't exactly call a bug. Certainly it is a problem. If I have a InnoDB table with an auto_increment field and try to insert a row in this table, it will increment the field in question normally. The problem happens when the query used has a problem,

DBTools Manager for Windows 1.0.12 Released

Hi, A new version (1.0.12) of DBTools is available for download. Here is a list of what is new or changed: - new PHP Web Script Generator - new Query Designer (former query by design) - new BLOB/TEXT/CHAR/VARCHAR Editor - new Relatioship Editor - Grid View was redesigned to look a little bit mor

Windows Programming MySQL

I noticed on the web site, that about 50% of the users of MySQL, used MySQL on the Windows platform. Now, in the Window's world, either BDE or OLE DB have become the base technologies for accessing databases, moreso in my opinion than ODBC. Yet, the MyOLEDB driver is a very barebones driver and I

Problem I cannot get but probably security and very simple to solve and handy program too

Hi, I have 2 Identical programs but with different users. Program lure3 / lure4 are exactly the same but lure4 is with root user rights the other one with lure user (an other user but with all rigths on MAPI database.) I cannot figure out what is wrong probably very simple but I seem to be overloo

Re: are my queries bloated?

http://www.tums.com On Friday, December 7, 2001, at 06:58 AM, Erik Price wrote: > > On Thursday, December 6, 2001, at 08:35 PM, Arjen G. Lentz wrote: > >> There is also the one part that limits your selection (shoeshine.com). >> So that >> is very important. I've quoted the table structure o

Can't install MySQL-benchmark RPM

>Description: Attempting to install the MySQL-benchmark RPM for 4.0.0 yields an RPM message requiring MySQL-DBI-perl-bin. Downloading the 'Mysql-DBI-perl-bin' package (v 1.1825-1) from a mirror (/Downloads/RPMS/i386) does *not* satisfy the dependency - probably a case mismatch between the

replicate-do-table

Hello everyone, How does mysql replication handle the replicate-do-table config option? Does the binlog get filtered before transmission, or once data is received by the slave? Thanks Todd - Before posting, please chec

Re: Problem with a Select

Jens Vonderheide wrote: > > > Message From To > > > > Exampel 1 2 > > > > UserID UserName > >1 Me > >2 You > > > > Message From To > > ExampelMe You > > SELECT > u.Message, u1.UserName AS From, u2.UserName AS To > FROM > Messages AS m, >

RE: EJB and MYSQL

I would say that mysql 4.X, when it is production ready, will be the best for J2EE applications. And using mysql with jboss (www.jboss.org) (add Tomcat or Jetty to the mix) is a very powerful, open source application. If a company can afford BEA, then they can also afford a data base like

RE: Problem with a Select

Can you show me your complete SQL sentence? I thing you have to use two Users tables. Andres. - Original Message - From: Jonas Jonsson <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 12:02 PM Subject: Problem with a Select Hi I have a table named Messages

Re: MySQL graphical front-end for Mac OSX

Robert Alexander writes: > At 18:07 -0700 2001/12/06, René Fournier wrote: > >Does anyone know if such a thing exists? (Especially a freeware one?) I'd like to >be able to create and modify table structures without hitting Terminal everytime. I >was using MySQLFront on Windows for this, and it w

Re: Problem with a Select

> Message From To > > Exampel 1 2 > > UserID UserName >1 Me >2 You > > Message From To > ExampelMe You SELECT u.Message, u1.UserName AS From, u2.UserName AS To FROM Messages AS m, UsersAS u1, UsersAS u2 WHERE m.From = u

Re: Problem with a Select

select t1.name, t2.name from messages left join Users as t1 on mesagges.From = t1.UserID left join Users as t2 on messages.To = t2.UserID; Jonas Jonsson wrote: > > Hi > > I have a table named Messages > It looks like this > > Message From To > > Exampel 1 2 > > And I also

Importing for MicroSoft Access 97

Hello- I created a schema for my database in MicroSoft Access 97. I would like to know if there is anyway to import this schema into MySQL? PLease help. Thank You __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.

Re: porting mysql to ibm os/390 open editionjzawodn@yahoo-inc.com

[EMAIL PROTECTED] writes: > > And I guess that was what I was offering. I've got the environment, don't really > have enough info about porting mysql to make it work, have cursory info about > automake, etc... > > If I knew who to contact in IBM, that might make it a lot easier, too... > > Ed

Problem with a Select

Hi I have a table named Messages It looks like this Message From To Exampel 1 2 And I also have a table named Users, A short version of it looks like this UserID UserName 1 Me 2 You Now to the problem I want to do a Select from Messages like this

Re: Does Mysql Have TRIGGER ??????

Pragneshkumar Gandhi writes: > > It doesn't, and IMHO the manual is clear on this: > > "The planned update language will be able to handle > > stored > > procedures. Our aim is to have stored procedures > > implemented > > in MySQL 4.1. We are also looking at triggers." > Hi Carl Troein > Sorry

RE: Strange 'sleep'

Update: actually, sometimes the query executes normally. About every third execution shows the strange behaviour described below, and only when executed through the cgi, never when executed directly from the command line. One would think that this must be related to the cgi, but it does _not_ hap

Re: Slow results with SELECT's that return large numbers of results

Jeremy Zawodny wrote: > > > > SELECT COUNT(*) FROM foo WHERE ... > > > > > How can I get this to work with a GROUP BY? > > Can you post the query along with the output of EXPLAIN so we > can get a good idea what's going on? Query: SELECT documents.document_id FROM documents, dictiona

Re: MySQL graphical front-end for Mac OSX

I haven't used it but a lot of people recommend PHPMyAdmin. Especially if your MySQL server is hosted by a company that doesn't give access to a shell account. Erik On Thursday, December 6, 2001, at 08:07 PM, René Fournier wrote: > Does anyone know if such a thing exists? (Especially a fr

Re: are my queries bloated?

On Thursday, December 6, 2001, at 08:35 PM, Arjen G. Lentz wrote: > There is also the one part that limits your selection (shoeshine.com). > So that > is very important. I've quoted the table structure of the subprojectweb > table > above, and the 'subproject_name' field is not indexed. There

Bin-log problems

Hi, I have a problem with the bin-log files growing too rapidly. They seem to be growing at a rate of about 1 gig every two hours even though the server is not busy. I have been running this server for about a year with replication and have had very little problems. This log problem started ab

Re: i can not find my.cnf !

On Friday 07 December 2001 19:15, Feny Suha wrote: > Hi all! > I used OS Linux Mandrake 8.0 and i installed MySQL-3.23.43 in my computer. > But i want change path for data directory MySQL, so i must change the > default of My.cnf but i could not find My.cnf.Manual MySQL said that > there're defaul

Re: Comparision

http://www.phpbuilder.com/columns/tim2705.php3 Altough it's NOT done with the latest versions of each DB. (He says that mySQL can't do transactions, well it does now with innoDB) (I think the max concurrent connections setting wasn't changed so that's why his mySQL was craching after 100 con

Re: Decimal separator

So sprach »Lars G 'LG' Örne« am 2001-12-07 um 13:19:00 +0100 : > MySQL, float fields: Can I change from "." to ","? Nope, they are always stored with . in the DB. However, when SELECTing, you can easily convert using MySQLs replace() function. Alexander Skwar -- >> Wohnung in Gel

removing mysqll

Hi i am new to the list would likwe to know how to remove mysql an client and others componets to make sure my machine is clean from mysql? just to make a new installation with the rpm´s packages of the lasta version, how do i install rpm versions? can i install all the packages of mysql with one

Re: ERROR 1006: please help

Jacob writes: > > mysql> create database jake; > ERROR 1006: Can't create database 'jake'. (errno: 13) > mysql> > > Can someone tell me what could be the cause of this I followed the > instructions to a T to get it all setup but now its not working i do > appreciate any help. That's premissio

Re: Does Mysql Have TRIGGER ??????

Pragneshkumar Gandhi writes: > Does Mysql Have TRIGGER ?? Calm down. There's no need to run around like a headless chicken (or whatever one does with 6 '?'s). It doesn't, and IMHO the manual is clear on this: "The planned update language will be able to handle stored procedures. Our aim is

Decimal separator

MySQL, float fields: Can I change from "." to ","? /Lars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[

Does Mysql Have TRIGGER ??????

Does Mysql Have TRIGGER ?? = Living on Earth may be expensive, but it includes an annual free trip round the Sun. Regards, Pragneshkumar Gandhi, India. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com

i can not find my.cnf !

Hi all! I used OS Linux Mandrake 8.0 and i installed MySQL-3.23.43 in my computer. But i want change path for data directory MySQL, so i must change the default of My.cnf but i could not find My.cnf.Manual MySQL said that there're defaults files for My.cnf like /etc/my.cnf or datadir/my.cnf or ~/.

Database Synchronization

Hi All I am New Subscriber to this mailing List. This is Pragneshkumar from India. I have one Application Which are wriitten in java/jsp and using mysql as db. Now this application is running on net as well as in my intranet meand it is running on remote server as well as local server INDEPENDET

Trying to update a longblob field using ASP's

I'm trying to make a copy of a longblob field in an ASP. I'm using this code: Set rs = Server.CreateObject("ADODB.Recordset") Set rs2 = Server.CreateObject("ADODB.Recordset") SQLStmt = "SELECT `Object` FROM `Objects` WHERE `ID`=" & data & ";" rs2.Open SQLStmt, Conn, 3, 3 Se

Re: Mysql 4.0

Harald Fuchs writes: > In article , > Robert Alexander <[EMAIL PROTECTED]> writes: > > > I'm getting the exact same error when trying to install MySQL 4.0 on RedHat 7.0 -- >both the binary distribution and the RPM. > > Previous binary versions of MySQL have

oracle from mysql

Hi, Please I need help. I am a new to the Mysql, and want to know if is it possible to get or update database managed with oracle. In our dept (of University institute) we want to use Mysql for many reason, one of them we use linux system, Unfortunatley we need to get some informations from anothe

mysql@lists.mysql.com

>Description >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

ERROR 1006: please help

mysql> create database jake; ERROR 1006: Can't create database 'jake'. (errno: 13) mysql> Can someone tell me what could be the cause of this I followed the instructions to a T to get it all setup but now its not working i do appreciate any help. I was able to login and set a pass. Jacob ---

Re:Creating MySQL table w/2 primary keys

Hi! >CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( >ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), >GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) >) Type=InnoDB; I guess the follow

Re: Multiple instances running over the same DB data with GFS/OpenGFS

On Fri, Dec 07, 2001 at 09:43:08AM +0100, Chemolli Francesco (USI) wrote: > > I have a GFS/OpenGFS-based cluster I intend to use for an HA mysql > setup. Just for fun, I tried running two instances of MySQL over > the same table files, and you can imagine my surprise when it mostly > worked

Multiple instances running over the same DB data with GFS/OpenGFS

I have a GFS/OpenGFS-based cluster I intend to use for an HA mysql setup. Just for fun, I tried running two instances of MySQL over the same table files, and you can imagine my surprise when it mostly worked I "only" got an "error in table handler" when when inserting row #8k of a concurrent

Parallel queries in PHP program

All, Can I implement parallel queries to mySQL by using sevial query sentences in a single PHP file? Who knows how to do it? including query the same table or different tables in parallel. Regards Ares - Before posting, please