MySQL + php + Red Hat Linux 6.2

2001-12-20 Thread EdwardSPL
Hello, My System is Red Hat 6.2 and need to run with php4 and imp ( www.horde.org/imp )... I found the MySQL packages ( RPM ) at www.mysql.com MySQL 3.23.46 Server (i386) (6M) MySQL 3.23.46 Benchmark/test suites (i386) (689K) MySQL 3.23.46 Client programs (i386) (1.7M) MySQL 3.23.46 Libraries

4.0.1 bug reports. Has it been released yet?

2001-12-20 Thread Mark Maunder
I've seen various bug reports for mysql 4.0.1 but no sign of it on the site. Has it been released yet? I think the 'IN BOOLEAN MODE' modifier for a fulltext search may solve all my problems. kind regards, Mark. - Before

RE: MyODBC leaking handles...

2001-12-20 Thread Jens Collin
Hi, Well, if I close my application, windows grabs hold of the handles again... If that is what you mean? I use it with an applications generator for telecom mostly so I have no idea how the inner works is done. I could find out for you if you want to, since I'm working at that company :) We

mysqldump - basic question

2001-12-20 Thread ROry O'Connor
this is an absolute newbie question - but when i try to run mysqldump with a cron (like with a shell script) i can't because mysqldump utility stops to ask for a password. how can I either embed the password or set up mysqldump to not ask for one if, for instance, root is running the shell

RE: mysqldump - basic question

2001-12-20 Thread Matthew Smith
You could use one of: 1. .my.cnf with a password set for the client 2. use -ppassword on the command line Depends on how secure you want it - use the appropriate grant for the user. M -Original Message- From: ROry O'Connor [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 09:36 To:

Re: mysqldump - basic question

2001-12-20 Thread Henning Sprang
Am 20 Dec 2001 03:35:37 -0600 schrieb ROry O'Connor: this is an absolute newbie question - but when i try to run mysqldump with a cron (like with a shell script) i can't because mysqldump utility stops to ask for a password. how can I either embed the password or set up mysqldump to not ask

temp workaround for fulltext 50% occurence threshold

2001-12-20 Thread Mark Maunder
I've figured out a temp workaround for the problem/feature of words that appear in more than 50% of records in a fulltext index being considered stopwords. I just added as many dummy records as there are real records in the table. A fulltext search will now not disregard any words based on their

Re: I *think* that I've just found the most misleading item in MySQLGUI..

2001-12-20 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: [skip] My /etc/my.cnf begins with this: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock Wrong ! mysqlgui code will look in [client] options header, like all other clients. But like i said in my previous post, MySQLGUI doesn't *CARE* about

Re: is there a Solaris version of mysql++ c++ API

2001-12-20 Thread Sinisa Milivojevic
Uday Anumalachetty writes: Hi All, Is there a solaris version of Mysql++ API. I see some downloads under the solaris section but no Mysql++. Is there a patch that I need to install to make it work on Solaris? Thanks for your responses. Uday As long as you use GNU 2.95 and 3.0 series of

Re: temp workaround for fulltext 50% occurence threshold

2001-12-20 Thread Sergei Golubchik
Hi! On Dec 20, Mark Maunder wrote: I agree with your logic of words that occur more frequently have a lesser weight - it makes alot of natural language sense. But there should be a way to either disable the '50% occurence = zero weight' setting or perhaps disable word weighting altogether

Complex Left Join

2001-12-20 Thread Brian E . Lozier
I'm trying to accomplish something a bit complex with a single query. Basically, I'm doing a nested category/file listing, and I want to get the number of categories and the number of files under each category in the list. For example: http://www.massassi.org/saberworks/files.php user: kedri

Re: temp workaround for fulltext 50% occurence threshold

2001-12-20 Thread Mark Maunder
Sergei Golubchik wrote: Mark, it's no point in discussing how things could be done in 3.23 branch - nothing can be changed there, this is exactly the reason we call it stable. How to get rid of 50% threshold is explained in the manual - for MySQL-3.23.x the only way is to modify the source

Re: temp workaround for fulltext 50% occurence threshold

2001-12-20 Thread Sergei Golubchik
Hi! On Dec 20, Mark Maunder wrote: Sergei Golubchik wrote: I'm using version 4. I tried using 'IN BOOLEAN MODE' under version 4.0.0 but it doesn't recognize it. I'm using the MySQL 4.0.0-alpha Server (i386) (6.2M) binary RPM. Should I compile from source? I would like to but

RE: Complex Left Join

2001-12-20 Thread Simon Green
Can OPTIMIZE help at all? Simon -Original Message- From: Brian E. Lozier [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 10:14 To: [EMAIL PROTECTED] Subject: Complex Left Join I'm trying to accomplish something a bit complex with a single query. Basically, I'm doing a nested

Re: 4.0.1 bug reports. Has it been released yet?

2001-12-20 Thread Sinisa Milivojevic
Mark Maunder writes: I've seen various bug reports for mysql 4.0.1 but no sign of it on the site. Has it been released yet? I think the 'IN BOOLEAN MODE' modifier for a fulltext search may solve all my problems. kind regards, Mark. We are just making sure that no bugs are reported

RE:[2] Complex Left Join

2001-12-20 Thread Brian E . Lozier
I've never used that, but the manual says it's for fixing up tables after a lot of deletions. I don't see how that applies to this problem. Forgive my ignorance, please, if I've missed something. Brian How should I know if it works? That's what beta

Date Format Query

2001-12-20 Thread Vaishali Vaidya
Hi, I am a new user to MySql, and have recently installed version 3.23.25-beta. I have a date string of the type 'DD-MON-YY' (for Oracle Users) (Eg. 20-DEC-01') If I try to insert this into a date field in the table, either as it is, or via the DATE_FORMAT function, it inserts a NULL Even when I

Compiling mysql-3.23.46 on OSF1

2001-12-20 Thread Martin MOKREJ
Hi, did someone manage to compile mysql on OSF1 4.0[D-F] series using Digital's cc and cxx compilers? Please Cc: me in reply, thanks. CC=cc CXX=cxx CFLAGS='-non_shared -O3 -tune-host' CXXFLAGS='-non_shared -O3 -tune-host' ./configure --with-libwrap --with-mysqld-ldflags=-all-static

Re: temp workaround for fulltext 50% occurence threshold

2001-12-20 Thread Mark Maunder
Sergei Golubchik wrote: Hmm, them 4.0.1 (with IN BOOLEAN MODE) won't help either :-( It uses the same scoring scheme as the above query in 4.0.0 Where can I get 4.0.1? I dont see it on the website. Because it's not officially out yet :-) (you can always use it before official

Embedded SQL

2001-12-20 Thread Raymond Wan
Hi, I know there's a C API for MySQL, but I was just wondering if MySQL has a preprocessor that supports statements such as EXEC SQL ... in a host language such as C. The preprocessor would then replace these statements with calls to the C API. I looked through the

Re: Embedded SQL

2001-12-20 Thread M. A. Alves
On Thu, 20 Dec 2001, Raymond Wan wrote: . . . I know there's a C API for MySQL, but I was just wondering if MySQL has a preprocessor that supports statements such as EXEC SQL ... in a host language such as C . . . The thing (purportedely) exists for Ada (adapower.com). However Ada is not as

RE: Date Format Query

2001-12-20 Thread Vaishali Vaidya
Hi, Thanks a lot for the speeedy response. I have tried this. However, I am likely to receive the date in the DD-MON-YY format from the frontend. And the MySql Manual doesnt mention any function which will format a given string and convert it to date. Hence, the query. Incase there is no go, then

Re: Embedded SQL

2001-12-20 Thread Sinisa Milivojevic
Raymond Wan writes: Hi, I know there's a C API for MySQL, but I was just wondering if MySQL has a preprocessor that supports statements such as EXEC SQL ... in a host language such as C. The preprocessor would then replace these statements with calls to the C API. I

left join question, I think...

2001-12-20 Thread Paul Chvostek
I'm a bit new to this, so bear with me if it seems obvious. :) I have two tables the content of which I'd like to display in a single result, ordered by content of fields that have similar content but different names in the two tables. This is as far as I've gotten: SELECT invoice.invdate

Need Driver for JRun

2001-12-20 Thread Vaishali Vaidya
Hi, I am a novice to MySql and am trying to develop an application on IIS-Allair JRun combination on Win NT server, with MySql as backend database. Please let me know where I can get a driver to connect JRun and MySql for the above combination. Also, do I require Apache Webserver as well and if

Query help

2001-12-20 Thread Mattias Persson
I have two tables, one for the articles and one with orderrows. When I update the price in the article table i want to make a query to update the price in orderrows on all rows with a certain orderstatus. I can't figure out how to write this query... I tried UPDATE orderrows SET price =

Re: Need Driver for JRun

2001-12-20 Thread Sundara Pandian
Hi, You can connect to the mysql database with the following line con = DriverManager.getConnection(jdbc:mysql://localhost/database?user=someuserp assword=somepwd); But first you need the mm.mysql driver download it from the following URL: http://www.mysql.com/downloads/api-jdbc.html You would

RE: create function: fails with error 1126

2001-12-20 Thread Tim Wuyts
Hello, I tried ldd on the .so file: no output! this is very strange. I tried to compile this on several other machines, but ldd never gives any output. If i replace gcc with c++, ldd does show me the shared libraries, but none are missing. If i try to use the .so file generated with c++ I get

temporary table permissions?

2001-12-20 Thread Paul Chvostek
I've given up on the LEFT JOIN thing I was poking at earlier, and have successfully (at least at a mysql command prompt) designed the necessary sequence of commands to get what I want ... in the form of a CREATE TEMPORARY TABLE follow by two INSERT INTO ... SELECTs. The only catch is ... it

Re: Compiling mysql-3.23.46 on OSF1

2001-12-20 Thread Martin MOKREJ
On Thu, 20 Dec 2001, Martin MOKREJ wrote: Hi, did someone manage to compile mysql on OSF1 4.0[D-F] series using Digital's cc and cxx compilers? Please Cc: me in reply, thanks. CC=cc CXX=cxx CFLAGS='-non_shared -O3 -tune-host' CXXFLAGS='-non_shared -O3 -tune-host' ./configure

Re: New world

2001-12-20 Thread John Meyer
At 06:41 PM 12/19/2001 +0100, Sven Hammann wrote: Hello, I'm new in the world of MySQL and have a question: What Software can I use to programm MySQL clients for HTML(XML) or Java ? Is there a Software which is easy to use ? I usually use PHP solutions for HTML. Java, you can use the JDBC

RE: MyODBC availability

2001-12-20 Thread Michael Widenius
Hi! Venu == Venu [EMAIL PROTECTED] writes: Venu Hi Kevin, -Original Message- From: Kevin Donnelly [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 12:47 PM To: [EMAIL PROTECTED] Subject: MyODBC availability Does anyone know why it is that the MyODBC authors

Strange problem: some data is partially missing (BUG?)

2001-12-20 Thread Gerry
Hi, When i use the mysqlclient to view some data from the table KLASSEN i get some strange partially missing data. like this: select DISTINCTROW * from KLASSEN where KlasseID='Y_FILTER' order by Kenmerk; +--+-+--+ | KlasseID | Kenmerk |

It really works!

2001-12-20 Thread mhmh79
Dear Friend: AS SEEN ON NATIONAL TV: Making over half million dollars every 4 to 5 months from your home for an investment of only $25 U.S. Dollars expense one time THANKS TO THE COMPUTER AGE AND THE INTERNET! Before you say Bull, please read the following. This is the letter you

Re: temporary table permissions?

2001-12-20 Thread Carl Troein
Paul Chvostek writes: The only catch is ... it won't go in PHP. The code looks fine, and I suspect it's just a permission problem. Indeed it seems that you need to have CREATE to do that. There might be a good reason for it, but the only thing I can think of is disk usage. Do I *realy*

Re: Query help

2001-12-20 Thread Carl Troein
Mattias Persson writes: I have two tables, one for the articles and one with orderrows. When I update the price in the article table i want to make a query to update the price in orderrows on all rows with a certain orderstatus. Can anyone please help me!!! From the manual: [...] new

Comments Welcome

2001-12-20 Thread Matthew Darcy
Is this the output you would expect from a correctly compiled and installed mysql system when running mysql_install_db Also where is the support-files this message speaks of, Thanks, Matt. [mysqldba@jordan bin]$ ./mysql_install_db Installing all prepared tables 011220 15:38:01

As plain as the nose on your face

2001-12-20 Thread Matthew Darcy
I have set the root password for the mysql install. I have read the manual and want to make a new database. I ran mysql_install_db (see my other mail today) which seemed to do little, then did what the manual told me with [mysqldba@jordan bin]$ ./mysqladmin create bathjobs ./mysqladmin: CREATE

RE: create function: fails with error 1126

2001-12-20 Thread Sinisa Milivojevic
Tim Wuyts writes: Hello, I tried ldd on the .so file: no output! this is very strange. I tried to compile this on several other machines, but ldd never gives any output. If i replace gcc with c++, ldd does show me the shared libraries, but none are missing. If i try to use the .so file

Re: As plain as the nose on your face

2001-12-20 Thread Kurt Tappe
I'm new to MySQL, so I hope the gurus will catch anything I get wrong below. However, this methodology worked for me. At 3:38 PM + 12/20/01, Matthew Darcy wrote: I have set the root password for the mysql install. I have read the manual and want to make a new database. I ran

Got error 127 when reading table

2001-12-20 Thread Martin MOKREJ
Hi, once I've reported here problems that somehow randomly we get these errors in mysql's log file. It looks, that when user drops a table, a table isn't dropped or somehow remains in cache. The when user tries to create the table again from scratch, he get's the error 127. Please note that the

Re: I *think* that I've just found the most misleading item in MySQLGUI..

2001-12-20 Thread Eibach
Sinisa Milivojevic To: [EMAIL

Re: Comments Welcome

2001-12-20 Thread Benjamin Pflugmann
Hi. On Thu, Dec 20, 2001 at 03:35:00PM -, [EMAIL PROTECTED] wrote: Is this the output you would expect from a correctly compiled and installed mysql system when running mysql_install_db Seems so. Why do you ask? There was no error message, so why do you doubt it? Also where is the

RE: As plain as the nose on your face

2001-12-20 Thread James Cox
try ./mysqladmin -u root -p create bathjobs and FYI, ./mysqladmin --help Thank you. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 03:38 PM To: [EMAIL PROTECTED] Subject: As plain as the nose on your face I have set the root password

help..

2001-12-20 Thread landz of change
I'm using redhat 7 and i've installed php4 and mysql. The package of php and mysql ( in RPM ) i installed are : - php-4 - mod_php-4 - php-mysql - mysql-3.2.3 - mysql_server-3.2.3 - mysql_devel-3.2.3 I ran mysqld and then i typed mysql from the bash prompt and it works, i got the prompt mysql .

RE: As plain as the nose on your face

2001-12-20 Thread Matthew Darcy
Thank you for explaining. I did try mysqladmin --help. This gave me a list of commands and I understood what each did however the problem was I didn't understand why the error was occuring. I get the impression you last comment was a little condesending, please remember all people where new to

odbc connection problem

2001-12-20 Thread Devore, Jacob
When I connect through odbc I get a succes with info, when I look at the info I have a sql state of s1000, native error 0. If I try to query the database I get an error and the sql state is s1000 with native error code of 1142. Everything I read on the internet says it's some kind of

RE: As plain as the nose on your face

2001-12-20 Thread James Cox
Matthew, i wasn't meaning to be condescending... it was simply a fyi - for your information :) James -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 05:57 PM To: Mysql Subject: RE: As plain as the nose on your face Thank you for

RE: mysql.sock??

2001-12-20 Thread Maximiliano Lucius
MayBe it´s late, but did you try to run the db server with user and permissions ?? M. - Original Message - From: Mike Blain [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED] Cc: Quentin Bennett [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:01 PM Subject: RE:

RE: odbc connection problem

2001-12-20 Thread Venu
Hi, -Original Message- From: Devore, Jacob [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 10:01 AM To: '[EMAIL PROTECTED]' Subject: odbc connection problem When I connect through odbc I get a succes with info, when I look at the info I have a sql state of s1000,

Re: Gui's for linux

2001-12-20 Thread James Thompson
I am not normally a fan of gui's but seeing as I am finding mysql a bit different from oracle I could use all the help I can get as my database may end up quite complicated. Are the gui's available for linux ??? are they any good. While we don't support admining a db from a gui you may be

Nested Queries.

2001-12-20 Thread Larry Reiter
I have constructed a query which requires a temporary table but I would rather use a nested query. In other words, I want to extract a set of data and then use that set of data as a query against some other data. Like some sort of SELECT within a SELECT. Can I do this in MySQL? Cheers, LTR

Re: Detecting OS through MySQL

2001-12-20 Thread Brent Cowgill
Thanks, I'll look for it in the future. Michael Widenius wrote: Hi! Brent == Brent Cowgill [EMAIL PROTECTED] writes: Brent Is there any way to detect the Operating System that a MySQL server is Brent running on Brent using SQL or DBI function calls only? Sorry no. But this is would be a

Help! Inserts way too slow in big db

2001-12-20 Thread Steve Rapaport
Okay, here's a tuning/opt problem for you experts: I have several CD's worth of records that are being converted and then inserted into our phone listing database. the total db size will be about 22 million listings. Well, it has reached 7 million and the insertions are getting slower and

Re: Help! Inserts way too slow in big db

2001-12-20 Thread Craig Vincent
I have several CD's worth of records that are being converted and then inserted into our phone listing database. the total db size will be about 22 million listings. Take a look at the LOAD INTO command, it was designed specifically for mass INSERTs and is well optimized for the procedure.

Re: Nested Queries.

2001-12-20 Thread Christian Andersson
Subqueries are not (yet)working in mysql, they will be implemented in the 4.0.x or is it 4.x which hopefully will be out very soon :-) so if you are using the 3.23.xxx you have to stick with temporary tables /Christian - Original Message - From: Larry Reiter [EMAIL PROTECTED] To:

Backup and Restore

2001-12-20 Thread Alex Shi
Hello, I have a question regarding to table backup and restore. Suppose we have a table of sales waste book. Now I need to backup data within a certain period of time (from date1 to date2) from the table, and after backup the data should be deleted from the table. Also the backuped data can be

Can't find file host.frm

2001-12-20 Thread P.J.D. Kouwer
Hi, I'm having some problems with starting Mysql and I hope someone could help me.. I start safe_mysqld and it says Can't find file host.frm I checked my.cnf and the directory and it has host.frm. I deleted /var/lib/mysql/mysql (datadir) and started mysql_install_db, but this didn't work out.

Re: Help! Inserts way too slow in big db

2001-12-20 Thread Steve Rapaport
So let's say I were to change my convertload program to write a batch of records to a local file, then call LOAD INTO to load it. Obviously this adds some extra disk overhead, but if LOAD INTO is fast enough, maybe it's worth it. What would be a good size / number of records for such a batch?

datetime column altered to not null

2001-12-20 Thread Edgart Gonzalez
Hi, We have a table (170K rows) and we altered the colum 'created_date' to not null with default value to '1900-01-01 00:00:00' , after the alter column statement is complited we select for the same column for nulls and I found 13K rows with null value select * from table1 where creted_date is

Re: Coredump when running scripts/mysql_install_db

2001-12-20 Thread Michael Widenius
Hi! Michael == Michael Stassen [EMAIL PROTECTED] writes: Michael While I have your attention, let me take this opportunity to report that Michael I've run into quite a few obstacles building MySQL from source. (I Michael reported most of these at the end of October, but have received no

Re: datetime column altered to not null

2001-12-20 Thread Craig Vincent
We have a table (170K rows) and we altered the colum 'created_date' to not null with default value to '1900-01-01 00:00:00' , after the alter column statement is complited we select for the same column for nulls and I found 13K rows with null value select * from table1 where creted_date

RE: datetime column altered to not null

2001-12-20 Thread Edgart Gonzalez
Oops we are running mysql 3.23.42 on linux 7.1 -Original Message- From: Edgart Gonzalez [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:54 AM To: '[EMAIL PROTECTED]' Subject: datetime column altered to not null Hi, We have a table (170K rows) and we altered the colum

Re: Help! Inserts way too slow in big db

2001-12-20 Thread John McConnell
One thing to keep in mind when using LOAD is to be sure when you telnet to cd to the directory where the file is that you want to load, and then get into mysql and do the LOAD statement. It's a simple thing to overlook, and if you don't do this it won't work. John McConnell --

RE: Got error 127 when reading table

2001-12-20 Thread Almar van Pel
I believe this error is assigned to a crashed table. try repair table and afterwards optimize. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Martin MOKREJ [mailto:[EMAIL PROTECTED]] Verzonden: donderdag, december 20, 2001 17.24 Aan: [EMAIL PROTECTED] Onderwerp: Got error 127

Re: Help! Inserts way too slow in big db

2001-12-20 Thread Philip Molter
On Thu, Dec 20, 2001 at 08:32:55PM +0100, Steve Rapaport wrote: : Okay, here's a tuning/opt problem for you experts: : : I have several CD's worth of records that are being converted : and then inserted into our phone listing database. the total : db size will be about 22 million listings.

RE: Got error 127 when reading table

2001-12-20 Thread Martin MOKREJ
On Thu, 20 Dec 2001, Almar van Pel wrote: I believe this error is assigned to a crashed table. try repair table and afterwards optimize. Eh, I forgot to mention that I've done CHECK TABLE a bit too late, when the user came and said that the problem got fixed itself, and asked me what I did.

show tables doesn't work in 3.23.46

2001-12-20 Thread Jeff Holt
After I created the mysql database, the 'show tables' command displayed the empty set. I checked my mysql.log file and found no errors. My permission in mysql.db and mysql.user look good (i.e., usernames seem to be correct and all permission columns are 'Y'). Any help would be greatly

Re: Help! Inserts way too slow in big db

2001-12-20 Thread Steve Rapaport
VALinux 2-CPU P3, 800 Mhz, using mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686) Tables are MyISAM. Computer has 1 GB of memory, tuned for large DBs. Philip Molter wrote: On Thu, Dec 20, 2001 at 08:32:55PM +0100, Steve Rapaport wrote: : Okay, here's a tuning/opt problem for you

HELP: Can not append access table with some duplicate records to mysql ver 4.

2001-12-20 Thread Dante Alzamora
Does someone know how to append records ignoring records that do not meet the database restrictions (UNIQUE index field). I can do it at the server with the IGNORE clause but that clause that not exist in access. TIA, Dante -

Re: Coredump when running scripts/mysql_install_db

2001-12-20 Thread Michael Stassen
On Thu, 20 Dec 2001, Michael Widenius wrote: Hi! Michael == Michael Stassen [EMAIL PROTECTED] writes: CUT Michael 2) While this worked for 3.23.41, I cannot believe it has worked for you Michael since 3.23.43. It doesn't for me. The problem is that somewhere between Michael 41 and

Problem with setrlimit on HPUX 10.20

2001-12-20 Thread Michael Widenius
Hi! cut Could you try to modify your test to do the proper casts and see if you can find what is going wrong on your system ? If we can find a test that fails on your system but works on ours, we would know a lot more about of how to fix this problem. Michael Yes, as it turns out. The

RE: Backup and Restore

2001-12-20 Thread Kemp Randy-W18971
Have you looked at mysqldump function? -Original Message- From: Alex Shi [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 1:36 PM To: [EMAIL PROTECTED] Subject: Backup and Restore Hello, I have a question regarding to table backup and restore. Suppose we have a table of

Re: Help! Inserts way too slow in big db

2001-12-20 Thread Steve Rapaport
A good thought, in fact it's mentioned in my original post. My problem with that is that at the current table size, an index can take more than 24 hours to generate when the table is full, and I can't find any way to measure its progress. So I won't know if I'm waiting for days for something,

UNIX_TIMESTAMP() INT unsigned problems

2001-12-20 Thread Colin Faber
Description: When attempting to select a result set by subtracting the value of an unsigned INT column against UNIX_TIMESTAMP() the result set is invalid. How-To-Repeat: Test case: mysql create table t (ts int unsigned not null); insert into t values

Re: Time Difference Function

2001-12-20 Thread Alex Kirk
I've been looking through the manual at www.mysql.com all of the time/date functions, and I can't seem to find the one I want: one that will take two times and find the difference between them. Basically, I'd like to be able to use this for a report that gives the number of hours worked on a

DBD::mysql

2001-12-20 Thread franky
I have all the time the same error, I try different value but nothing is right! in the Perl Makefile.PL command i receive this message: Checking if your kit is complete... Looks good Note (probably harmless): No library found for -lz Using DBI 1.18 installed in

Windows 95 winsock version

2001-12-20 Thread Quentin Bennett
Hi, From the manual: Note that if you are using an old Win95 release (for example OSR2), it's likely that you have an old Winsock package; MySQL requires Winsock 2! You can get the newest Winsock from http://www.microsoft.com/. Win98 has the new Winsock 2 library, so the above doesn't apply for

Re: DBD::mysql

2001-12-20 Thread sherzodR
Try to install it using .rpm. I believe Redhat and Madrake packages all have perl-mysql libraries. Good luck franky wrote: franky: I have all the time the same error, I try different value but nothing is franky: right! franky: in the Perl Makefile.PL command i receive this message:

Re: Help! Inserts way too slow in big db

2001-12-20 Thread Rodney Broom
From: Steve Rapaport [EMAIL PROTECTED] CREATE TABLE White ( Your table definition isn't exactly acurate, it's missing some column declorations and things. But that's OK, I didn't really need to see it created. Maybe I can offer some programatic help instead of DB design or MySQL help. I

Reporting Tool

2001-12-20 Thread Zach Curtis
Does anyone know of a reporting tool that would query a MySQL database and integrate with my application logic (PHP)? I'm looking for something that would allow users thru a GUI interface using their browser, to run their own queries and select how they want the data displayed/formatted (e.g.,

Can't connect to SERVER MYSQL localhost

2001-12-20 Thread Daniel Bechtel
Hello, I'm running Windows ME and installed 2 weeks ago MYSQL and got it working fine. Had no problems. Now suddenly since a couple days I can't get the MYSQL Server started anymore. I get the above described message. Well, I checked the manual and followed those hint's but it does not tell me

installation problem

2001-12-20 Thread Macedo, Marlon - (Per)
Hi, i`m trying to install mysql on my E250 Solaris 7. when i issue mysql it outputs: # ./mysql ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed where can i find libncurses.so.5 ? Thank you, Marlon Macedo -Mensaje original- De: Daniel Bechtel

Re: Coredump when running scripts/mysql_install_db

2001-12-20 Thread Michael Stassen
After applying your patch to my copy of 3.23.46, I get mysqld.cc: In function `void kill_mysql()': mysqld.cc:622: `kill_server_thread' undeclared (first use this function) mysqld.cc:622: (Each undeclared identifier is reported only once mysqld.cc:622: for each function it appears in.)

Uninstall source distribution?

2001-12-20 Thread Mike Blain
what is the best/safest way to uninstall a MySQL distribution that was installed from source (rather than RPMs)? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Time Difference Function

2001-12-20 Thread Bogdan Stancescu
The solution I found for the same problem was arithmetic subtraction between unix_timestamp() values. Hope this helps. Bogdan Alex Kirk wrote: I've been looking through the manual at www.mysql.com all of the time/date functions, and I can't seem to find the one I want: one that will take

Very Urgent

2001-12-20 Thread SHAM SUNDAR
Hello sir, When i cannect from my java program i use to get error General Error: 22.Can u pls help in this.My mysql version is 3.23.46 Thanks in advance Bye Sham __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your

Re: Windows 95 winsock version

2001-12-20 Thread Miguel Angel Solorzano
At 11:17 21/12/01 +1300, Quentin Bennett wrote: Hi! http://www.microsoft.com/windows95/downloads/contents/WURecommended/S_WUNetworking/dunwinsky2k/Default.asp Regards, Miguel Hi, From the manual: Note that if you are using an old Win95 release (for example OSR2), it's likely that you have an

Benchmarking

2001-12-20 Thread Joel Wickard
Hello, I've looked around on mysql.com, and through the directories of my mysql install I'm looking for information on benchmarking my mysql database, but I'm not interested in seeing how it performs against other databases, I'm interested in testing how my designs will perform when scaled. If

virtual tables.

2001-12-20 Thread Christian Andreu-von Euw
I am a new mySQL user and am trying to port an MS Access database over to mySQL. In access you can create queries which serve as virtual tables. For example I could have two tables, Customer order info and customer order status. I want to present these as a customer order table. I write a

Re: Can't connect to SERVER MYSQL localhost

2001-12-20 Thread Daniel Bechtel
The folder ibdata is empty. no such thing like ibdata1 exists. Concerning changing the ownership/permission ... I'm running Windows ME no file share activated so there is no option to change the permission etc. Do you know what those codes mean... operating error number 3 and the 011220 Where

RE: create function: fails with error 1126

2001-12-20 Thread Tim Wuyts
Eureka! -rdynamic is considered an invalid option for gcc ( a quick browse through newsgroup history learns that it *probably* is no longer supported as of gcc-2.95.3, since it's use was never very clear nor documented) however, Sinisa's post got me to try this: ln -s

Re: Segmentation Faults on 4.0 Using Linux on Alpha

2001-12-20 Thread Michael Widenius
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Van writes: Sinisa: As in possibly the binutils problem? I've had to use: gcc version 2.95.4 20011006 (Debian prerelease) to do any builds of things that need glibc2.3.2, but had to revert to the potato compiler to

How can i RollBack or Commit using PHP in MYSQL

2001-12-20 Thread sreedhar
Hi all, How can i RollBack or Commit using PHP in MYSQL. i have not found any commands through PHP Doc. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: How can i RollBack or Commit using PHP in MYSQL

2001-12-20 Thread Durga_Prasad
MySQL with MyISAM Tables does not provide the facility of Commit or Rollback. You need to compile MySQL with InnoDB tables to have above mentioned features. Check out: www.innodb.com regards, Durga Prasad Placed At : sreedhar [EMAIL

Re: Coredump when running scripts/mysql_install_db

2001-12-20 Thread Michael Widenius
Hi! Michael == Michael Stassen [EMAIL PROTECTED] writes: cut This is strange; I have built mysqlbinlog on HPUX 10.x and many other OS without having to add -lpthread (or similar) to the link line. Here is the link line on our HPUX 10.20 machine: /bin/sh ../libtool --mode=link gcc -O3