Re: MYSQL 4.0

On Wed, Jun 26, 2002 at 08:15:11PM +0530, Arul wrote: > Hi > > Any idea when MySQL 4.0 stable release will be made.. > As of now only Alpha is released.. Rumor has it that 4.0.2 might be beta. > Also any sites which run on 4.0 Alpha Yes. Half my servers have been moved to what will be 4.0.2.

Display Records in Multiple Pages

I have 100 records in mySQL database and I need to display them in my web page using php and html. How to display them in multiple pages? Each page must contain 25 records. Does anyone know how to do it other than create 4 pages and manually list the records there? or maybe point me some reference

Access denied @locahost

I've been scowering (sp?) the docs but I can't get past: mysql> use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql> This happens under any condition where access is needed. It is after I have done mysql_install_db and chown and there is a user "mysql". It does

Re: "Commands out of sync; you can't run this command now" Error ?

Hi, I'm only using mysql_query, never mysql_query_unbuffered. Regards, Jocelyn - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 5:49 AM Subject: Re: "Commands out of sync; you can'

Re: Signal 11 on SHOW PROCESSLIST query

On Wed, 26 Jun 2002 18:13:07 -0700 (PDT) Henry Hank <[EMAIL PROTECTED]> wrote: > > Mysql has crashed twice in the last month with the same errors in the error > log (see log below). I attempted to resolve the stack dump, but when I do "nm > -n libexec/mysqld > /tmp/mysqld.sym" I get a "nm: l

Re: Cartesian Product

At 13:22 +0100 6/26/02, Simon Green wrote: >Hi >When I run my MySQL question I get what I think is a cartesian product? > >SELECT table1,Username >FROM table1, table2 >WHERE table1.Username != table2.Username; > >If I just run'=' then no problem but it seems to what to match every thing >with ever

Re: "Commands out of sync; you can't run this command now" Error ?

Because the PHP interface is based on the C interface. It hit's the C interface at some point since PHP is itself written in C. - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 7:44 PM Subject: "Commands out of sync;

help me..please!

hi i was just wondering.is it posible to manipulate flat file databases with My SQL?.if it is..where can i get more info on this?. i really don't have any idea how to use MySQL with flat file databases. thanks. __ Do You Yahoo!? Yahoo! - Official pa

Re: How can this Oracle Query converted to MySQL

Hi All Sorry Guys...I just cut a small part of a bi Query where i had problems but i didnt see the User Table missing in the From List :(( Thanx for your Help.. -Arul - Original Message - From: "Rob Vieira" <[EMAIL PROTECTED]> To: "'Benjamin Pflugmann'" <[EMAIL PROTECTED]>; "Arul" <

Re: Getting field results using c

At 10:42 -0500 6/26/02, rm wrote: >I'm trying to retrieve a particular field using C API. When I use this >select statement from the mysql client it retrievs the correct result: > >mysql>SELECT ap_senders FROM mailtable WHERE pw_name='regis' and >pw_domain='mbpost.com'; > >But... > >In the C func

Re: "Commands out of sync; you can't run this command now" Error ?

At 1:44 +0200 6/27/02, Jocelyn Fournier wrote: >Hi, > >I've just got this error on my server. > >According to the manual, I can read : > >"If you get Commands out of sync; you can't run this command now in your >client code, you are calling client functions in the wrong order! >This can happen, fo

need help conceptualizing my first mySQL database

I'm trying to figure out how to setup my first mySQL DB... I hope this isn't too OT for this list. The DB will serve several purposes, which I think will each go into a different table w/in one DB. Here's what I want to be able to accomplish: pull up a listing of: 1) names and email addresses

Re: I can login to mysql as root but not as any other user...

Are u doing a user@hostname or user@%? The hostname part is needed, % means from anywhere. A better way to write this to prevent any errors is enclosing user & host in single quotes as such: 'user'@'host'. Regards, Bhavin. - Original Message - From: "Michael Knauf/Niles" <[EMAIL PROTECTED

How does update low priority work?

If you execute UPDATE LOW PRIORITY table_name .. does mySQL automatically return or does it wait for the update to execute? (that is, is it async or sync)? Andrei Cojocaru [EMAIL PROTECTED] - Before posting, please check:

LOAD DATA

Everyone, Is it possible to use LOAD data infile syntax in MySQL ver 3.23.51 win98 version? R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -

Signal 11 on SHOW PROCESSLIST query

Hello All, I have mysql 3.23.41 running on a Dell Poweredge 2550 on standard install of Red Hat 7.2 (2.4.9-21smp). This version of mysql came with Red Hat. It's been running my website very smoothly for the last few months, and averages 130 queries per second. Mysql has crashed twice in t

MySQL Crash with varchar(40)

I got problem on my machine running with mysql 3.23.51, some field use varchar (40) if query from this field mysql got hanging Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x82c3318 = SELECT * FROM `COURSE` ORDER BY `SUBJNAME` ASC

Compilation problem on Solaris 8

Hi I've tried to compile the latest mysql source on our Solaris 8 SPARC server and gcc 2.95.3, but make hangs up with these errors; -I/usr/share/src/mysql-3.23.51/include -DHAVE_RWLOCK_T -c sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this

Re: How can this Oracle Query converted to MySQL

create temporary table tmp SELECT IndustryID FROM Company_Industries CI WHERE CI.CompanyID = C.CompanyID; SELECT U.UserID FROM Transaction_Data T, Rfq_Data R ,Company C WHERE T.TransactionID = R.TransactionID AND (R.Industryid=1 or R.IndustryID=tmp.IndustryID) Cheers Rich Arul w

MYSQL 4.0

Hi Any idea when MySQL 4.0 stable release will be made.. As of now only Alpha is released.. Also any sites which run on 4.0 Alpha Regards, -Arul To pass the List : sql , query - Before posting, please check: http://www

Re: innodb bug

Shakeel, this may be something with 32-bit unsigned integer / signed integer arithmetic. I assume mysqld runs in the 32-bit mode? Are you able to compile mysqld yourself? You could add the following to line 214 of mysql/innobase/include/buf0buf.ic ... if (block < buf_pool->blocks) { printf(

Re: Searching through a MySQL-driven website

At 05:00 AM 6/26/2002, you wrote: >I run a MySQL/PHP-based website. In an attempt to make some search >functionality, I search a few specific tables that I find relevant and look >in certain fields when performing a search. A query will generally look >something like this: > >SELECT * FROM Books W

Re: encrypt myisam?

At 05:40 AM 6/26/2002, you wrote: >Hi! > >I want to store my mysqldatabase encrypted on disk, it contains sensitive >data. Is there anybody out there doing this already? Or do I have to rewrite >the myisam routines? Or is there another way? > >Regards, Tobbe > >- Tobbe, MySQL 4.02 has AE

Getting field results using c

I'm trying to retrieve a particular field using C API. When I use this select statement from the mysql client it retrievs the correct result: mysql>SELECT ap_senders FROM mailtable WHERE pw_name='regis' and pw_domain='mbpost.com'; But... In the C function listed below: #include #include

RE: SubQueries and Temp Tables

At 7:16 -0700 6/26/02, Dave Morse wrote: >MySQL is barely an SQL database - it doesn't support much basic SQL 89 >functionality. Can any one throw some light on why professional SQL >database developers want to use it for anything but simple file >management? AND It is written in C as well so why

Re: Type of column in query float instead of integer

At 20:22 +0200 6/26/02, Iago Sineiro wrote: >Hi all. > >I execute the next query in Delphi 5.0 against MySQL and Delphi understand >that the column of the query is of type ftFloat >when it should be ftInteger (The field cantidad in the database is int). > >SELECT SUM(cantidad) AS Ventas >FROM LALB

RE: How can this Oracle Query converted to MySQL

In a nutshell, this can be rewritten as a join - no sub-select needed, so no problem (this is true of the vast majority - albeit not all - sub-selects). Because the "U" table is missing (indeed, it looks like a lot of your join informaiton is missing too), there's no way for me to give you an acc

RE: Type of column in query float instead of integer

U can use the latest version of WinZeos 5.0.3 Hope it helps R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: Iago Sineiro [SMTP:[EMAIL

"Commands out of sync; you can't run this command now" Error ?

Hi, I've just got this error on my server. According to the manual, I can read : "If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order! This can happen, for example, if you are using mysql_use_result() and try t

Re: Permission denied for download???

What URL did you try? Takacs Istvan wrote: > Hi > > I'd like to download > mysql-3.23.51-sun-solaris2.8-sparc.tar.gz > from mysql.com, but the server doesn't allow me > to get the file. > > What's wrong with it? > > Thanks in advance! > > Regards; > > Istvan > > -

Re: MySQL Book by Dubois - Pg. 63 Tutorial Question

You are correct. It was a typo on my part. I forgot to copy the AND in the "AND event.event_id = score.event_id;" The problem is the same and I still receive an empty set message. You are also correct that there are events with the date of 1999-09-23. TIA for any assistance. D. H. Craig, CS

Help with join...

Hi! I have an table called 'list' where I store all items for the pulldown menues on my site. Table list has three columns - id (int autoincrement) - pulldown_name (tinytext - name of pulldown) - item (tinytext - the item for the pulldown menu) A table called client_index stor all the info a

Re: How can this Oracle Query converted to MySQL

At 03:03 PM 6/26/02 +0530, Arul wrote: >SELECT >U.UserID >FROM >Transaction_Data T, Rfq_Data R ,Company C >WHERE >T.TransactionID = R.TransactionID AND >(R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM >Company_Industries CI WHERE CI.CompanyID = C.CompanyID)) You ran this query throug

I can login to mysql as root but not as any other user...

mysql is running on an i386 box with Red Hat Linux 7.0 this works: mysql -u root -p --it askes for the root password, and lets me into the mysql monitor. I can create databases and tables, life seems good. than I try something like: Grant all on *.* to user identified by 'password'; where us

Cartesian Product

Hi When I run my MySQL question I get what I think is a cartesian product? SELECT table1,Username FROM table1, table2 WHERE table1.Username != table2.Username; If I just run'=' then no problem but it seems to what to match every thing with every thing and so I run out of memory. Is there a way

RE: Regarding Store Procedures

[snip] I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. [/snip] http://www.mysql.com/doc/T/O/TODO_sometime.html MySQL does not currently support stored procedures Jay sql, mysql, query --

Re: thousands of binary log files

At 11:43 +0200 6/26/02, Gary Colman wrote: >Hi > >Paul - Thanks for your suggestion. >Unfortunately the general query log indicates that there is >no hint of any external interference and it still rotates You may not see an explict FLUSH LOGS query. Do you seen any lines that say "Refresh" afte

Re: Regarding Store Procedures

MySQL doesn't support stored procedures. They are on TODO and should appear in MySQL-5.0. Pradeep.C.Pangi wrote: > Hi All, > I am new to MySQL, can any body tell me how to write store procedures > in MySQL. > and How to run the same in command line. This will help me very much. > -- For

Re: force no results

Hi, i found a solution by myself i think it's very complex but may help others for finding solutions Thats the query: SELECT entries.id, entries.head, entries.date, entries.author FROM entries LEFT JOIN category ON entries.cat_no REGEXP CONCAT("\\.",category.id,"(\\.|$)") LEFT JOIN entgroup ON e

Re: what permissions do i need to set

Shon Stephens wrote: > > i have an application that will allow me to rotate mysql table using > date variable substition. in other words > > table=tblname.%m%d%Y > > if i am using a remote system to host the application, what Host doesn't matter. "localhost" and remote hosts are processed in t

Distorted display of query output in W2K

I recently installed MySQL on a computer running Windows 2000 and have been working through the tutorial session in the manual. All went well until I created the second (event) table. While I believe that all the data in the table is correct, any query which returns the remark column results in a

Cartesian Product

> Hi > When I run my MySQL question I get what I think is a cartesian product? > > SELECT table1,Username > FROM table1, table2 > WHERE table1.Username != table2.Username; > > If I just run'=' then no problem but it seems to what to match every thing > with every thing > and so I run out of mem

Re: Port newbie

Marcel, Wednesday, June 26, 2002, 12:57:27 AM, you wrote: M> ./bin/safe_mysqld --user=mysql --port=7000 & M> im want to start mysql in the 7000 por and imm using the command abobe put M> it still on port 3306. M> Whats Wrong ? I can put port parameter in My.cnf ? Check your my.cnf file is t

Re: mysql-3.23.51

LTrain1007, Wednesday, June 26, 2002, 1:51:17 AM, you wrote: L> I downloaded this version, and unzipped it using winrar. I have all the L> files in a directory but i dont know how to use or install mysql? any help? Have you downloaded binary or source distribution? If you downloaded binary dis

Re: Problem with MySQLImport utility

ericloe, Tuesday, June 25, 2002, 12:17:03 PM, you wrote: e> I'm new in MySQL.anyone out there can help please? e> I'm actually experimenting with the mysqlimport utility to import data from e> a text file.however i'm always getting this error upon the command c:\mysql\bin>m

Re: innodb bug

Bert -- Your problem is not the same as Shakeel's. For you, the database is saying that it couldn't allocate memory. For Shakeel, it is saying that an assert failed. At about line 213, there is a right shift (X >> Y) that is occuring. The behavior of a right shift is different depending o

Increasing number of open_files

RedHat 7.1 MySQL Version 3.23.42 Couple of questions about MySQL and the "open_files" stat as reported by "mysqladmin extended-status". I've changed my configuration (both MySQL and Linux) to increase the max number of open files -- I don't have a problem here. But, I do see that the "open_files

RE: How to change default mysql data-dir in Linux server ?

Search for 'my.cnf' on mysql.com This is the config file that you can use to set the data dr You may need to create it if it doesn't already exist. HTH Peter --- Excellence in internet and open source software ---

Subsecond date/time values?

How are people representing subsecond date/time values with MySQL? In Sybase, the datetime data type supports subsecond values with a resolution of 1/300th of a second (go figure). PostgreSQL does microseconds with its time (4 bytes) and timestamp (8 bytes) data types. More generally, JDBC prov

MySQL client unusable with large data sets

I've been a loyal MySQL fan for a few years now, and use it extensively in web site development. But I've run into a problem now (MyODBC 3.51.03) that is making me reconsider my choice. Most of my database access is local using JDBC, but I have some critical Windows software that relies on My

Re: SubQueries and Temp Tables

It's hard to give a common suggestion which is suitable for all cases. We need to know the exact queries being executed. Arul wrote: > Agreed Ralf... > Not all SubQueries can be replaced by Joins.. > Thats why we have planned for Temp Tables.. > Any ideas on it.. > > > - Original Message -

Re: Regarding Store Procedures

Pradeep.C.Pangi, Wednesday, June 26, 2002, 2:17:05 PM, you wrote: PCP> I am new to MySQL, can any body tell me how to write store procedures PCP> in MySQL. PCP> and How to run the same in command line. This will help me very much. MySQL doesn't support stored procedures yet. -- For te

Re: mysql dumps core on solaris

Aqeel, Tuesday, June 25, 2002, 5:12:45 PM, you wrote: AA> I have installed mysql 3.23.25 on solaris 7. It was AA> installed in /usr/local/mysql. When I run the AA> safe_mysqld scritp, the mysql daemon starts withouut AA> any error and the ps command shows that mysql is AA> running. However from l

Re: what permissions do i need to set

Shon, Tuesday, June 25, 2002, 8:54:39 PM, you wrote: SS> i have an application that will allow me to rotate mysql table using SS> date variable substition. in other words SS> table=tblname.%m%d%Y SS> if i am using a remote system to host the application, what SS> permissions to i need to give t

Re: [Zeoslib-general] Type of column in query float instead of integer

> I execute the next query in Delphi 5.0 against MySQL and Delphi understand > that the column of the query is of type ftFloat > when it should be ftInteger (The field cantidad in the database is int). > > SELECT SUM(cantidad) AS Ventas > FROM LALBARANCL > WHERE fecha >= "2002-05-01" > AND fecha

Re: long table scroll down

At 16:15 -0400 6/26/02, Anil Garg wrote: >Hi, >for viewing long tables. >in my sql query when i say SELECT * FROM abc >i miss the upper entries of the table as they scroll down. >is there something by which i can view a table page by page(as | more in >unix) >thanx >anil Yes, if you *are* using U

Re: long table scroll down

mysql> pager more See: http://www.mysql.com/doc/m/y/mysql.html Gurhan - Original Message - From: "Anil Garg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 4:15 PM Subject: long table scroll down > Hi, > for viewing long tables. > in my sql query when i say

Re: encrypt myisam?

Hi! There is a workaround for it using ENCODE and DECODE functions. Insert data in this style: INSERT INTO t VALUES (field) ENCODE('string','password'); Retrive it using decode(): SELECT decode (field,'password') FROM t; Perhaps this helps. Tobias Bengtsson wrote: > Hi! > > I want to st

MyODBC windows driver "auto" setup..

When trying to use the "/auto" feature of the Windows MyODBC driver setup program, it wants to use read a "odbcinst.ini" file. Anyone have any info on the format of this file and what should be in it? Many thanks in advance... -- Rick MySQL spam killer strikes again.. (not) ---

Setting up a mysql server for the web

I hope someone can tell me a bit more on how to integrate a MYSQL server with a windows network. I have a web server that is running IIS5. The internet user account is IUSR_Machinename. I do not want to run the database on the web server. When I tried this with Access it did not work because t

Re: Regarding Store Procedures

There are no stored procedures in mySQL Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: "Pradeep.C.Pangi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 05:17 Subject: Regarding Store Procedures > Hi All, > I am new to MySQL, can any bod

Re: remove foreign key constraint

Pierre, Tuesday, June 25, 2002, 3:54:28 PM, you wrote: PB> how to remove a foreign key constraint without recreating the innodb table ? No, it's not possible ... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ens

Re: Regarding Store Procedures

Hello. On Wed 2002-06-26 at 16:47:05 +0530, [EMAIL PROTECTED] wrote: > Hi All, > I am new to MySQL, can any body tell me how to write store procedures > in MySQL. > and How to run the same in command line. This will help me very much. More of help would be a look in the manual, which would

mysql find/replace problem.....

Err well, the problem is mine since I'm new to SQL. I have an mysql server running and have a data source that contains text posts. I'd like to setup a script that will search for "string1" and replace it with "string2". There may be text before or after this statement that must rem

Re: How can this Oracle Query converted to MySQL

What us "U.UserID"? You don't have table U in the table list. Arul wrote: > SELECT > U.UserID > FROM > Transaction_Data T, Rfq_Data R ,Company C > WHERE > T.TransactionID = R.TransactionID AND > (R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM > Company_Industries CI WHERE CI.CompanyI

Re: How can this Oracle Query converted to MySQL

Hi. First, I removed the CC to the java list, because this problem is not java-related in any way. Second, I suggest you do some reading in the manual, the questions you asked recently are mostly answered there. On Wed 2002-06-26 at 15:03:19 +0530, [EMAIL PROTECTED] wrote: > SELECT > U.UserID >

Type of column in query float instead of integer

Hi all. I execute the next query in Delphi 5.0 against MySQL and Delphi understand that the column of the query is of type ftFloat when it should be ftInteger (The field cantidad in the database is int). SELECT SUM(cantidad) AS Ventas FROM LALBARANCL WHERE fecha >= "2002-05-01" AND fecha < "2002

RE: SubQueries and Temp Tables

MySQL is barely an SQL database - it doesn't support much basic SQL 89 functionality. Can any one throw some light on why professional SQL database developers want to use it for anything but simple file management? AND It is written in C as well so why do Java developers use it? Regards, Dave

query: restartmysql daemon

Hi, the sql process(on doing ps) shows the following process: /usr/local/bin/safe_mysqld --user=mysql when i kill this process and try to restart it with command: safe_mysqld --user=mysql it says "a mysql process already exists". can anyone tell me how to restart mysql daemon. thanx anil --

Is the server down?

Is the mysql mail list down? sql - 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 <[EMAIL PROTECTED]> To u

help with an integer column, please

I've got the following 2 tables: create table cinema_order ( id int not null primary key auto_increment, revision_number int not null default 1, active_revision int not null default 1 ); create table cinema_order_revision ( id int not null primary key auto_increment, cinema_order_id int not null

Best filesystem for MySQL ?

Hi, I wonder which is the best filesystem to use with MySQL (to increase performances). And which mounting option should be used ? According to the documentation, the best system is SuSE Linux 7.1, 2.4 kernel, and ReiserFS. I currently use ReiserFs with noatime option. But it seems (according to

count of rows with HAVING

Is there any way in SQL (and especially MySQL) that I can determine the count of rows that would be returned by a SELECT with a GROUP BY and a HAVING, without retrieving the rows? For example, I want the number of orders whose total value is greater that 1. The orders would be SELECTed like t

Re: force no results

Hi! I'm not sure whether I understood what exactly you mean. To exclude a row from the result, one should usually use conditions in WHERE clause. Probably you missed something in WHERE? Martin Adler wrote: > Hi, > > is it possible to force mysql in a SELECT clause depend on a > condition to

How to change default mysql data-dir in Linux server ?

Hi, I have installed MySQL 4.0 on Linux box using RPM. Everything is working fine, but the database directory is set to /var/lib/mysql. So everytime I create a database it is getting created on /var/lib/mysql. What I would like to have is to create database under /var/lib/mysql/data_dir, w

RE: Regarding Store Procedures

Mysql does not currently support stored procedures. Check the website for the features that will be added to the 4.x seriese. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Pradeep.C.Pangi [mailto:[EMAIL PROTECTED]] Sent: Wed

InnoDB: Lock wait timeout problem

Hi all! I am using MySQL (version 3.23.51-max-log). I have a problem with locking. Let's assume that we have 2 connections (Conn1 and Conn2) and table test: CREATE TABLE `test` ( `id` int(3) NOT NULL auto_increment, `name` char(10)

RE: How can this Oracle Query converted to MySQL

Not directly, MySql does not support sub selects yet. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --

RE: Unions

Does anyone else feel that lack of support for subqueries is the number 1 deficiency in MySQL? I'm not sure why support for subqueries is being deferred for so long. Certainly, uncorrelated subqueries are almost trivial to implement and the truth is that correlated subqueries aren't really all t

Re: Problem building MyODBC driver on W2K

For anyone else having this problem building the MyODBC MySQL driver, I ended up commenting out all of the ctl3d calls in setup.c (and replacing SetWindowLong(hdlg, DWL_MSGRESULT,Ctl3dDlgFramePaint(hdlg, wMsg, wParam, lParam)); with SetWindowLong(hdlg, DWL_MSGRESULT,lParam);) The driver now li

long table scroll down

Hi, for viewing long tables. in my sql query when i say SELECT * FROM abc i miss the upper entries of the table as they scroll down. is there something by which i can view a table page by page(as | more in unix) thanx anil - B

Re: innodb bug

Hi! It turned out that the bug indeed was connected with a 32-bit signed integer wrap-over if the buffer pool on a 32-bit computer is bigger than 2 GB. The following patch may fix the problem, but better test first if there are also other similar wrap-overs which I did not notice. Best regards,

Problem with SELECTion of data - JOINS ?

I am trying to do move a (hard to maintain) spreadsheet task over to the Mysql database so I can more easily add to the data and harvest result information. I am using Mysql 3.23.49 The following table parts have been created and will be referenced below: CREATE TABLE TestSuite ( TSid int(11)

Re: Inserting images (not the location of the images)

[please honor my mail-followup-to header] At a certain time, now past, Dana Diederich spake thusly: > Out of curiosity, why would you recommend not putting images into a DB? > I've had a lot of success doing that sort of thing. > > Cheers. > -Dana I never said it wouldn't work, but you need to

Re: innodb bug

Ah, that makes sense. So it potentially could be the simple matter of telling the compiler that the type is unsigned. --shak Chuck Simmons wrote: > Bert -- > > Your problem is not the same as Shakeel's. For you, the database is > saying that it couldn't allocate memory. For Shakeel, it is

RE: Regarding Store Procedures

There are no sprocs in MySQL at this time. There are plans for such, but it will be at least a 4.x (post 4.0) release. There are some 3rd party things out there to allow you to run inline Perl and stuff like that, but they are true add ons and are not an exact match to a stored procedure concept

MyODBC for MAC OS9

Hello, I am trying to set up a MyODBC connection from my MAC OS9. I have a filemaker database on the MAC OS 9 machine that I would like to connect to a MySQL database on my host server. There are MyODBC drivers published for MAC OS X on the MyODBC downloads page, but they don't seem to work on MAC

Re: Searching through a MySQL-driven website

Hi! You can try FULLTEXT search, implemented in MySQL, or consider installing specialized Web search engine. Eivind A. Sivertsen wrote: > I run a MySQL/PHP-based website. In an attempt to make some search > functionality, I search a few specific tables that I find relevant and look > in cert

Re: Regarding Store Procedures

> I am new to MySQL, can any body tell me how to write store procedures in MySQL. MySQL doesn't support stored procedures yet. > and How to run the same in command line. This will help me very much. But you can create text fle with SQL commands and then run it from command line: mysql -h host

Fulltext query

Dear listmembers, I have two tables candidate_index candidate_skill candidate_index hold information about the candidate like id (autoincrement), firstName, lastName and emailAddress. candidate_skill has three columns - id (autoincrement) - candidateID - skill client_index has a fulltext inde

Regarding Store Procedures

Hi All, I am new to MySQL, can any body tell me how to write store procedures in MySQL. and How to run the same in command line. This will help me very much. Thanks in Advance. Pradeepp - Before posting, please check:

Mysql Question - urgent help needed pls

Hi, Could any of you help me in getting a Performance Comparison document for MySQL on different architectures (Intel linux or S390 linux). Regards, prabha - Before posting, please check: http://www.mysql.com/manual.php

dbf2mysql

I've just downloaded a version of dbf2mysql that supports fields of type MEMO. I was wondering if anyone knew how to use this as the readme doesn't tell you? Thanks, Neil - Before posting, please check: http://www.mysql.com

encrypt myisam?

Hi! I want to store my mysqldatabase encrypted on disk, it contains sensitive data. Is there anybody out there doing this already? Or do I have to rewrite the myisam routines? Or is there another way? Regards, Tobbe -- `Given enough eyeballs, all bugs are shallow.' 69D6 E76A FC83 E9CA 0747 7A

Re: Can't create FOREIGN KEY restraints on InnoDb tables

At 11:55 AM 6/25/2002 -0400, Andy Dustman wrote: > From a usability perspective, since other databases don't seem to be so >picky about this sort of thing, InnoDB ought to (IMHO): > >a) Act on REFERENCES clauses (i.e. column type REFERENCES ref-table) >instead of ignoring them. > >b) Auto-create

Searching through a MySQL-driven website

I run a MySQL/PHP-based website. In an attempt to make some search functionality, I search a few specific tables that I find relevant and look in certain fields when performing a search. A query will generally look something like this: SELECT * FROM Books WHERE LongName LIKE '%$kw%' OR ShortName

Re: thousands of binary log files

Hi Paul - Thanks for your suggestion. Unfortunately the general query log indicates that there is no hint of any external interference and it still rotates every few seconds ... there are constant accesses to the DB, and the bin-log is rotated mid-connection by a querying client. I have an in

RE: problem

U did not clarify that either u r accessing MYSQl through java beans or u have specified the driver in that JRun itself..U require to start mysql as service on ur machine for that u need to click winmysqladmin.exe at mysql\bin dir .. hope it should work.. D K Dubey -Original Message- From

How can this Oracle Query converted to MySQL

SELECT U.UserID FROM Transaction_Data T, Rfq_Data R ,Company C WHERE T.TransactionID = R.TransactionID AND (R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM Company_Industries CI WHERE CI.CompanyID = C.CompanyID)) This is to Pass the Mail Server : sql,query ---

Re: Unions

Hiho hiho! How about: CREATE TABLE tmp_whatever SELECT FROM table1... INSER INTO tmp_whatever SELECT FROM table2... ? Greetings Ralf P.S.: A bit dirty for someone who got used to Oracle ;-) Arul wrote: >Hi > >Can i use Unions in MySQL. >If not could anyone comeout with some alternates.

  1   2   >