mysqlcc - release 0.8.10-beta - show create

From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysqlcc - release 0.8.10-beta - show create >Description: If there are more than one database (database1, database2, database3) connected by MySQLCC, and you will start the function "show create" for one of the tables o

Re: Large resultset

Thanks, that solved the problem. I thought that I could have my own fetch-size but I has now understood that Integer.MIN_VALUE is the only size that is accepted. Regards Roland Carlsson - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Roland Carlsson" <[EMAIL PROTECTED]

terrible replication annoyance

hi guys , i have posted here a few times already and i have trawled the list archives and tried every tutorial on the topic without any luk , i am still getting this error, why cant it read the master log saying it isnt open ? the user i have used has ALL permissions, if i set log-bin in the slave

Re: MySQL Web Server ?

The one and only Apache web server > Hi, I'm a MySQL newbie - Is there a "MySQL Web Server" > product ? Oracle has their OWS (Oracle Web Server) > for example. > > Can anyone reccomend a *very* lightweight web server > with enough scripting ability to talk to MySQL - > preferably for RedHat? > >

MySQL Web Server ?

Hi, I'm a MySQL newbie - Is there a "MySQL Web Server" product ? Oracle has their OWS (Oracle Web Server) for example. Can anyone reccomend a *very* lightweight web server with enough scripting ability to talk to MySQL - preferably for RedHat? Thx! __

Re: MySQL and Redhat 7.3

Check the log for error messages, it's in the data directory... /usr/local/mysql/data/ - Original Message - From: "b b" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 6:27 AM Subject: MySQL and Redhat 7.3 Greetings, I am new to this list so I don't know if

MATCH / AGAINST fatal bug

MATCH / AGAINST fatal bug MySQL version: 4.0.11-gamma OS : Windows 2000 SP3 RAM: 1GB Apacer Free Disk Space: 32GB HD Write Back Cache: Disabled Under some circumstances the following query does never terminate. The win32 service cannot be stopped either = FATAL.

Re: Altering table which has FOREIGN KEY constraints

Reznichenko, Thank you for your answer! > What do you mean "could not execute a query on those tables"? > Could you be more detailed? Ok. let me explain. When I was using MySQL 4.0.10, After I add columns with "ALTER TABLE" on foreign key referencing table so many times, when I execute "SELECT

RE: MySQL Shutdown FAILED

Yeah, I notice this too, especially after upgrading to MAX. I really find it annoying. My guess is that the RPM is slightly different than the God given RH version, so there are TWO KXXmysqld in /etc/rc.d/init.d or in one of the rc.3 or rc.5 or something and so one shuts it down, then the other ex

Re: MySQL database on a Linux ramdisk partition?

Hi, >Is it possible to place MySQL data directories on a Linux ramdisk mount? Oh yes. No fragmentation aftertaste. Regards, Gabriel - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: message from server: "Not unique table/alias: 'USER_ROLE'" ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul DuBois wrote: At 12:50 +0530 3/11/03, Mufaddal Khumri wrote: What does the error mean ? - message from server: "Not unique table/alias: 'USER_ROLE'" This happens when I try to use the java code: PreparedStatement pstmt = con.prepareStatement("S

MySQL and Redhat 7.3

Greetings, I am new to this list so I don't know if this topic has been pounced around or not. DOES MYSQL WORK ON REDHAT? I got Redhat 7.3 and MySQL 3.23.55 I tried binary installations. I tried installing from source too. When I finally run the /usr/local/mysql/bin/safe_mysqld --user=mysql &

MySQL database on a Linux ramdisk partition?

Is it possible to place MySQL data directories on a Linux ramdisk mount? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

wrong time in m$office

hi, m$office (office 2000 - win xp) can not handle the "time" correct. openoffice (win-xp or redhat-phoebe3) has no problems. what´s wrong? MyODBC-windows 3.51 $ rpm -q MyODBC MyODBC-2.50.39-11 $ rpm -q mysql-server mysql-server-3.23.54a-4 mysql> describe stunden; ++

Re: MyODBC: SQLBindParameter mix DATA_AT_EXEC with direct boundparam eters

On Mon, 2003-03-10 at 09:40, Naumann, Frank wrote: > Hi all, Hi !! > > I found a problem (bug?) when updating a blob column via MyODBC. The > statement i run is like that: > > UPDATE blob_table SET blob_col = ? where id = ? > > when i do NOT bind the restriction as input parameter, but write i

help needed

Hello, I have RH 6.1. I have mysql 3.22.25 version binary installation databases are in /var/lib/mysql binaries in /usr/bin/mysql etc /var/lib/mysql/mysql.pid /var/lib/mysql/=mysql.sock and rpm packages: perl-DBI-1.13-1, perl-DBD-mysql-mysql-1.22.10-1 perl-5-5.0050 and binary instal

Re: Is there any way to search a whole database for a value?

A request such as this make me think the database is not properly normalized. If there is one value that can be in several columns, it is very likely those columns need to be broken into their own table, so that they can be queried with a SELECT statement that has only one column in its WHERE c

Re: Using ssh tunnel and mysql

on 3/10/03 1:55 PM, Pete Harlan at [EMAIL PROTECTED] wrote: > So your db is on foo.bar.com, and that's the machine you're sshing > into? If so, then you might try > > ssh -n -N -L 3307:127.0.0.1:3306 foo.bar.com > > Since, once on the new host, it's the localhost's IP address you want > to conn

Re: Is there any way to search a whole database for a value?

At 11:01 -0800 3/11/03, Keith Roberts wrote: I need to look in several different tables/columns in a database for a particular value. If I find it, I need to update it. Is there any way to search/update every table/column in one query in a particular database? No. -- Keith Roberts IT Manager - L

Re: what's the best format option for importing SQL Server databases?

At 14:24 -0600 3/11/03, kenn murrah wrote: Greetings. I've been challenged with an assignment in which my client will feed me a 9000-record SQL Server database every night, and I in turn will need to import the data into mySQL, replacing the mySQL database from the night before ... Given that

Re: message from server: "Not unique table/alias: 'USER_ROLE'" ?

At 12:50 +0530 3/11/03, Mufaddal Khumri wrote: What does the error mean ? - message from server: "Not unique table/alias: 'USER_ROLE'" This happens when I try to use the java code: PreparedStatement pstmt = con.prepareStatement("Select * From USER_ROLE, ROLE" + "WHERE USER_ROLE.USERID = ? And

Re: what's the best format option for importing SQL Server databases?

CSV would be the easiest way. -Shamit Verma (http://vshamit.com) - Original Message - From: "kenn murrah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 1:54 AM Subject: what's the best format option for importing SQL Server databases? Greetings. I've been c

what's the best format option for importing SQL Server databases?

Greetings. I've been challenged with an assignment in which my client will feed me a 9000-record SQL Server database every night, and I in turn will need to import the data into mySQL, replacing the mySQL database from the night before ... Given that scenario, and the fact that I obviously wan

Re: Desperate Sum(), Group by/Join question - One Step closer...

Ok, in regards to my previous dilemma, I've gotten it to: SELECT golf_pick_periods.id, golf_pick_periods.period_name, golf_pick_periods.period_start_date, golf_pick_periods.period_end_date, COUNT(DISTINCT golf_events.id) AS num_events, COUNT(golf_pla

Re: Problems with JDBC autoReconnect and wait_timeout

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Emma Wansbrough wrote: Hi, I am having major problems with persistant database connections on a resident process in java. My database connection url looks like this: jdbc:mysql://balti/log?autoReconnect=true&user=root&password=pineapple But it does

message from server: "Not unique table/alias: 'USER_ROLE'" ?

What does the error mean ? - message from server: "Not unique table/alias: 'USER_ROLE'" This happens when I try to use the java code: PreparedStatement pstmt = con.prepareStatement("Select * From USER_ROLE, ROLE" + "WHERE USER_ROLE.USERID = ? And USER_ROLE.ROLEID = ROLE.ID"); pstmt.setIn

MySQL, GCC, and Solaris...

After trying to compile MySQL for several hours yesterday I finally found a combination that works... under Solaris v2.9, using GCC 2.95.2, and MySQL v3.23.54a I had a successful compile. Any upgrading of GCC or MySQL causes a failure in the compilation of sql_lex.cc:85 - Has anyone encountered thi

Re: Is there any way to search a whole database for a value?

mysqldump | grep '' Keith Roberts wrote: I need to look in several different tables/columns in a database for a particular value. If I find it, I need to update it. Is there any way to search/update every table/column in one query in a particular database? -- Keith Roberts IT Manager - Lapto

Problems with JDBC autoReconnect and wait_timeout

Hi, I am having major problems with persistant database connections on a resident process in java. My database connection url looks like this: jdbc:mysql://balti/log?autoReconnect=true&user=root&password=pineapple But it does not appear to be reconnecting because if I go into /etc/my.cnf and s

Is there any way to search a whole database for a value?

I need to look in several different tables/columns in a database for a particular value. If I find it, I need to update it. Is there any way to search/update every table/column in one query in a particular database? -- Keith Roberts IT Manager - Laptops For Less 2995 White Star Anaheim, CA 92806

RE:RE SELECT not doing what is expected

Pardon me, It should have read Player not Name in table 1. I don't get an error I get ID | Name | Player | goals | assists | shutouts | points -- 1 rob J.Doe 2 3

Re: SQL Statement Problems (NOT IN)

Phil Dowson wrote: Literally in MSSQL server you would have (but I cant use subselects) SELECT t1id FROM t1 WHERE t1id NOT IN (SELECT t2id FROM t2 WHERE t2gid = 192) SELECT t1id FROM t1 left join t2 ON t1.t1id =t2. t2id AND t2.t2gid = 192 WHERE t2.t2id IS NULL --

One Simple Question

I know that the file size limit for mySQL tables is limited by the operating system. I want to confirm that this is not a database size limit. Pardon my being a novice, but I just want to be sure. Thanks for the help, Joe __ Do you Yahoo!? Yahoo! We

Desperate Sum(), Group by/Join question

Hi all, I've got a mysql application that tracks golf events where players pick winners. Each event is associated by date with a "pick period" (ie a month). I'm trying to get a COUNT() function to count all the picks by pick period for a given player (in this case id = "1"). The following SQL

MySQL List

My apologies if this is covered somewhere, but is there a web interface to change mailing list options such as MIME/Plaintext digest options ? The EZMLM respone page from mysql-help does not reference a web interface or other commands for controlling list options.

Re: SQL Statement Problems (NOT IN)

Quoting Bruce Feist <[EMAIL PROTECTED]>: > Phil Dowson wrote: > > >SELECT t1.t1id > >FROM t1 > >LEFT JOIN t2 ON t1.t1id = t2.t2id > >WHERE t2.t2gid <> 192 //an example of a gid I am using// > > > >This is close, it shows all the id's that exist in the t2 table without a > >t2.t2gid of 192, bu

Desperate Sum(), Group by/Join question

Hi all, I've got a mysql application that tracks golf events where players pick winners. Each event is associated by date with a "pick period" (ie a month). I'm trying to get a COUNT() function to count all the picks by pick period for a given player (in this case id = "1"). The following SQL

binlog-ignore-db & replicate-ignore-db problem

Hi All, I am trying to set up a replication ignoring a given database, but unfortunatly it doesn't works (for me). In my.cnf of my master I have at the end : log-bin server-id= 1 binlog-ignore-db=access The line: " binlog-ignore-db=access " is supposed to make the master not to log updat

ASP.NET¿Õ¼ä×Ô¶¯±¸·ÖÊý¾Ý¿â£¬ËÍ2GµÄÓʾÖ!

尊敬的客户，您好！ 时创网络为企业推出ASP.NET高级虚拟主机！全部系统主机存放在国家超级 数据港，通过2.5G光纤直连ChinaNET骨干网,适用于大型的企业、大型电子商务 网站、大型个人网站（带论坛 社区等）。！ 我们提供高速空间服务之余，还提供了用ASP发邮件 、ASP连接access SQL Server2000数据库例程，SQL Server2000企业管理服务器的说明等。务求 使您最高效的使用我们的空间服务，以下为您推荐两款高级空间： 一、虚拟专用型C的详细配置资料： 脚本支持：ASP ASP.NET CGI Active Perl Front Page 2000

Re: Mysql hangs on multi table update on innodb table.

Scott Wong writes: > > Version: Mysql 4.0.10-gamma > > Description: Mysql hangs and possibly can not recover from a query on an innodb > table. > > How to Repeat : > > drop table if exists parent; > drop table if exists child; > > CREATE TABLE parent(id INT NOT NULL, > PRIMARY KEY (

SQL

Salom Sherzod. Bu men Jizzaxdan Uzbdan Husniddinman. Chatda kup gaplashgandik agar eslasez. Man internetda sizni SQLda ishlashizni bilib qoldim. Shunga sizdan bitta narsani suramoqchi edim. Siz qattasiz Toshkentdami? Manga Microsoft SQL 2000 kerak bulib qoluvdi. hech topomadim. qattan topsa buladi.

Innodb and tablespace

I need help! I'm making some testing with innodb tables and there're some issues I don't understand. I created a small tablespace of 10M: innodb_data_file_path = ibdata1:10M; Then I created this simple database: CREATE DATABASE trace_db; use trace_db; CREATE TABLE chromatogram (

Re: SQL Statement Problems (NOT IN)

Quoting Bruce Feist <[EMAIL PROTECTED]>: > Phil Dowson wrote: > > >>Looks like a syntax error to me. There is no t1id in t2. Also, the OR > >>is redundant; if no t2 row was found, both t2id and t2gid will be NULL, > >>so checking one of them suffices. Try > >> > >>SELECT t1.t1id > >> FROM t

Re: Master (pc) Slave (laptop) Replication

>It is automatic. >Next time you connect your laptop to the network, >and start mysqld on your laptop, it will catch up to the master >provided the bin logs are still on the master. The reason i am asking is because it is not updating a couple of records. But if I create a new db with some conten

FW: mySQL 4.1 sql,query,queries,smallint

../Luc Bui --- +46(0) 11 24 70 86 +46(0) 70 68 17 111 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 11 mars 2003 17:58 To: Luc Bui (PAC) Subject: Re: mySQL 4.1 Your message cannot be posted because it appears to be either spam or simpl

Re: Master (pc) Slave (laptop) Replication

It is automatic. Next time you connect your laptop to the network, and start mysqld on your laptop, it will catch up to the master provided the bin logs are still on the master. Daniel Negron/KBE wrote: I have set up replication and have it working properly for the most part. If I update the maste

Re: Master (pc) Slave (laptop) Replication

At 11:48 -0500 3/11/03, Daniel Negron/KBE wrote: I have set up replication and have it working properly for the most part. If I update the master the slave follows suit. But my slave is a laptop, that I use for testing but would like that data to stay up to date withthe master. Overnight if 'live

Master (pc) Slave (laptop) Replication

I have set up replication and have it working properly for the most part. If I update the master the slave follows suit. But my slave is a laptop, that I use for testing but would like that data to stay up to date withthe master. Overnight if 'live changes take place on the Master, while the slav

Re: Is mysql_real_escape_string for blob storage?

At 0:07 + 3/12/03, Lai Liu-yuan wrote: Thanks for your reply. But, what then is the role of mysql_real_query? In document, it says "You must use mqsql_real_query for queries that contain binary data"? That doesn't mean the data values don't need to be properly escaped. What if you put a binar

Re: Is mysql_real_escape_string for blob storage?

Thanks for your reply. But, what then is the role of mysql_real_query? In document, it says "You must use mqsql_real_query for queries that contain binary data"? - Before posting, please check: http://www.mysql.com/manual.php

Re: Is mysql_real_escape_string for blob storage?

At 23:05 + 3/11/03, Lai Liu-yuan wrote: Hi, everyone. I use blob to store image data in mysql. I use mysql_real_query to store it, but did not use mysql_real_escape_string to process it before hand. Then I saw in the document that this is needed. But I am testing the data stored by reading

Re: SQL Statement Problems (NOT IN)

> I am trying to check a table to see if a value doesnt exist, and I > would prefer to use the NOT IN syntax, but that doesnt work for mysql. > I've been trying to construct a similar statement in MySQL, but I'm > coming up cold. > > t1 > 't1id' > '1' > '18' > '19' > > t2 > 't2id','t2gid' > '19',

Is mysql_real_escape_string for blob storage?

Hi, everyone. I use blob to store image data in mysql. I use mysql_real_query to store it, but did not use mysql_real_escape_string to process it before hand. Then I saw in the document that this is needed. But I am testing the data stored by reading them out to do some processing, there seems

Re: SELECT not doing what is expected...

It doesn't explain the problem at all, since you didn't say what the problem was.. I would have expected an error message because: You can't join USING (player) because 'Players' has no 'player', and if it did, the WHERE clause would be redundant. The WHERE clause also references the non-exis

sql_select_limit of 4.0.11

Hallo, what I have is this: /usr/sbin/mysqld-max --version /usr/sbin/mysqld-max Ver 4.0.11-gamma-Max for pc-linux on i686 Downloaded and installed: MySQL-client-4.0.11-0 MySQL-shared-4.0.11-0 MySQL-Max-4.0.11-0 MySQL-devel-4.0.11-0 MySQL-server-4.0.11-0 MySQL-bench-4.0.11-0 ...started, loaded, ru

SQL Statement Problems (NOT IN)

Hi All, I am new to this list, so appologies if I sound like a newbie. I am trying to check a table to see if a value doesnt exist, and I would prefer to use the NOT IN syntax, but that doesnt work for mysql. I've been trying to construct a similar statement in MySQL, but I'm coming up cold. t1

Re: Query Help

* [EMAIL PROTECTED] > Two tables > > 1. Clients > ClientID (Primary Key, Unsigned int , Auto_Increment) > Vehicle typeChar(200) > Vehicle Color CHAR(200) > > 2. Service > ServiceID (Primary Key, Unsigned int , Auto_Increment) > ClientID

Re: idle login segfault on 4.0.11a-gamma

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sat, 5 Apr 2003 [EMAIL PROTECTED] wrote: > >Description: > > With a stale login (idle for some time), I've experienced a > repeated ability to cause a seg-fault by attempting to get the > status (\s). I have not tested this

Re: Large resultset

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roland Carlsson wrote: Hi! I have a query that returns a resultset of 70 mb. I'd somehow would like J/Connector to fetch only small pieces using Statement.setFetchSize but it still get the whole ResultSet at once and then I get an OutOfMemoryError. Is i

Re: Large resultset

Hello and thanks for your answer! If I have understood correctly LIMIT will only return as many row as the limit. I need all rows, but I can't handle them all at once. In JDBC there are a method to "stream" the resultset into small portions and when the end of the portion is reached it automatical

Re: Large resultset

Hello and thanks for the answer! I use the following code to create the statement and resultset: java.sql.PreparedStatement stat = conn.prepareStatement(sqlQ, java.sql.ResultSet.CONCUR_READ_ONLY); stat.setFetchSize(5); java.sql.ResultSet res = stat.executeQuery(); So I don't think there is anyth

Query Help

Very informative MySQL list. Good Job People! Query Question.. Two tables 1. Clients ClientID (Primary Key, Unsigned int , Auto_Increment) Vehicle typeChar(200) Vehicle Color CHAR(200) 2. Service ServiceID (Primary Key, Unsigned int , Aut

AW: Large resultset

Hi, why don't you try to solve the problem with ordinary sql-selects. You can take "select . limit " regards Reiner > -Ursprüngliche Nachricht- > Von: Roland Carlsson [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 11. März 2003 12:54 > An: [EMAIL PROTECTED] > Betreff: Large resu

MySQLGUI links are broken

Hello, it seems as if all links on http://www.mysql.com/Downloads/mysqlgui/ are broken. Many thanks for a hint, regards, Helmut Jarausch Lehrstuhl fuer Numerische Mathematik RWTH - Aachen University D 52056 Aachen, Germany -

Re: Large resultset

> I have a query that returns a resultset of 70 mb. I'd somehow would like > J/Connector to fetch only small pieces using Statement.setFetchSize but it > still get the whole ResultSet at once and then I get an OutOfMemoryError. > Is it a bug in setFetchSize? Does J/Connector ignore it? Have I to

Re: Using ssh tunnel and mysql

On Mon, 2003-03-10 at 22:01, Pete Harlan wrote: > On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote: > > Whether it's a feature or not, it's not always so easy to figure out > > what to do. If you specify -h localhost, it can be argued that you > > really want the socket even if you spec

Re: Off topic help, SSL and form posts

On Tue, 2003-03-11 at 04:15, Scott Haneda wrote: > I have run into a problem where data is truncated when sending to MySql via > a SSL connection, I can not determine whether this is my server or just the > protocol, I hope the later, as I know web* 4, which is what I am using will > never get it f

Large resultset

Hi! I have a query that returns a resultset of 70 mb. I'd somehow would like J/Connector to fetch only small pieces using Statement.setFetchSize but it still get the whole ResultSet at once and then I get an OutOfMemoryError. Is it a bug in setFetchSize? Does J/Connector ignore it? Have I totally

Re: SELECT to new table

* Phillip S. Baker > How do I write a SQL call to take the results of a select statement and > plug them into a new table in the DB? If the new table exist, use INSERT ... SELECT: http://www.mysql.com/doc/en/INSERT_SELECT.html > If the new table does not exist, use CREATE TABLE ... SELECT http:

Re[2]: how turn off binary update log?[Scanned]

hello, Jeff. you wrote 10 ìàðòà 2003 ã., 5:18:23: JK> From you're info below, mysql *shouldn't* be turning on the binary log. An JK> easy way to test is just to run the 'ps' command and see if '--log-bin' is JK> being added to the command line. If you have a long command line for the JK> mysql pr

Re: mysql embedded server threads

Does anybody (on this list) know anything about threaded embedded server? Where can I get info about this problem? >I've been using mysql embedded server in my online game >project. The game server receive client requests, >and create a new thread for every request. >I made some tests with a sin

Re: [repost] Finding table name when using Union

On Tue, 2003-03-11 at 07:33, Richard Taubo wrote: > > When using the Union statement in MySQL, is it possible to retrieve the > corresponding table name for a given row? The reason I need to know > this is that I present info from different tables in their own way. I > know I can create a colum

Re: query cache hits not counted in Com_select (fwd)

Hi! > In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in > Com_select. The documentation for Com_select implies that they should be > there. Is this the intended behavior, or is it a bug? > > - JD It is intended behaviour. Com_select is incremented each time SELECT query is

Re: MySQL Client on Linux won't connect to MySQL Server on XP

No it says that the ip 10.0.0.220 does not have the right privileges to connect to your mysql server. This can be solved if you connect through command line to mysql and give grant all privileges on *.* to [EMAIL PROTECTED] identified by 'paswdyouwant'; This will give the basic privileges to all