Re: How to get it in ONE query?

2001-04-12 Thread Jan Dvorak
Hi, No, you can't get both in one query. Anyway, you probably want to see how many results would be returned in the first place, before deciding on sensible LIMIT clause parameters. And you may want to add an ORDER BY clause to your second query, so that you can rely on the order in which the

Pb with configure

2001-04-12 Thread Michel AVERSENG
Description: checking return type of sprintf... configure: error: can not run test program while cross compiling How-To-Repeat: just launch ./configure Fix: ? Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: ATCHIK MySQL support: none Synopsis:

MYSQL

2001-04-12 Thread dsheela
Hi is there anyone on the list fron Pune, India who can lend me a MySql CD for a while. my installation is not taking off.. Thanks Mihir Telephone: 020 5281296

version

2001-04-12 Thread Lebrun Jonathan
How can I replace MySql 3.22.xx with MySql 3.23.34. Uninstall 3.22.xx ? Thx. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Perl MySQL Interface

2001-04-12 Thread Mark Rowlands
let perl -MCPAN -e shell be your friend i /mysql/ will show you all the mysql stuff or i /dbi/ even On Thursday 12 April 2001 01:16, Chris Becker wrote: go to perl.com - click CPAN and look for DBI and DBD, and look for docs on how to install a perl module. You need to

Re: client problems

2001-04-12 Thread oltra jean-michel
On Tue, 10 Apr 2001, Erik Kabo wrote: Date: Tue, 10 Apr 2001 18:37:17 -0400 From: Erik Kabo [EMAIL PROTECTED] Reply-To: Erik Kabo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: client problems Hi, I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I installed it, the

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-12 Thread David Beech
On 11 Apr 2001, at 18:07, Mohamed Ould wrote: apache "make" abort with these errors: usr/local/mysql/lib/libmysqlclient.a(my_compress.o ): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress'

Re: MyODBC, NT 4.0 WS, and Access 2000

2001-04-12 Thread Adrian D'Costa
In your odbc setup did you give the host name that you defined on the linux box? Adrian On Wed, 11 Apr 2001, Fenn Rider wrote: I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting to a MySQL db running on a linux box. When I try to connect, I get a dialoge that says:

Re: I Need your help

2001-04-12 Thread David Beech
On 11 Apr 2001, at 11:16, [EMAIL PROTECTED] wrote: Good morning, Please, I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help, My query is : select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where

connect/pconnect performance

2001-04-12 Thread samuel C
Hi. I use persistent connections opened from php scripts. For what I read in the manual, when a client try to connect to the same server, same database , same user, same password, if a persistent connection is already open, it should use that mysql link, never open another persistent

Re: MySQL and PHP issue

2001-04-12 Thread David
I want to be able to change menu items on the fly instead of having to modify the html code manually. Some of the menu item links change a lot or I need to add additional menus. Keeping the menus in a database allows me to edit/change the menu items easily from the web page Thanks Rolf Hopkins

col_name(length) index and INNOBASE problem

2001-04-12 Thread BAUMEISTER Alexandre
Bonjour, We found a bug in INNOBASE tables with col_name(length) indexes. Here is the table : create table test ( symbole char(20) not null primary key, libelle char(100) not null, index id_lib (libelle(1)) ) TYPE=INNOBASE; For the test I insert one row but there can be many,

change default delimiter

2001-04-12 Thread Shambhu Kumar singh
Hi, Can somebody help me, with changing the default delimiters of MySQL. For Example I want to change the single quotes that enclose a string in an INSERT statement to #. How can it be done. Thanks in advance. Shambhu kumar Singh. _ Chat

Insert Problem in C API

2001-04-12 Thread Shambhu Kumar singh
Hi, I am running a query using C APIs to insert a large text item into a MySQL table. The query is as follows sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-12 Thread Sinisa Milivojevic
Jeremy Zawodny writes: On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote: This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: Insert Problem in C API

2001-04-12 Thread Aigars Grins
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C variable containing a large text item The problem occurs when mydata contains a single quote, then that single quote is taken as the end of the column value by the MySQL parser

Re: MySQL and PHP issue

2001-04-12 Thread David Beech
On 11 Apr 2001, at 18:59, David wrote: I tried posting this in the PHP newsgroup but received no response so thought I would try here since issue involves MySQL The easiest solution is to use lists, eg: ul liAdmin/li ul liNetworking/li ul liping litraceroute liecho /ul

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-12 Thread Mohamed Ould
David Beech a crit : On 11 Apr 2001, at 18:07, Mohamed Ould wrote: apache "make" abort with these errors: usr/local/mysql/lib/libmysqlclient.a(my_compress.o ): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress'

Re: PATCH2: REGEXP in select only works with short expressions onAlpha

2001-04-12 Thread Stephen Beynon
Thanks for the patch and the rapid response :) My application has been running with this patch for 15 hours now - and has done over 2 million regexp matches without problems :) Stephen On Wed, 11 Apr 2001, Michael Widenius wrote: "Stephen" == Stephen Beynon [EMAIL PROTECTED] writes:

Re: col_name(length) index and INNOBASE problem

2001-04-12 Thread Miguel Angel Solórzano
At 12:30 12/04/2001 +0200, BAUMEISTER Alexandre wrote: Hi, Maybe this issue is relative at your compiled version or platform because I wasn't be able to repeat: Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. c:\mysql\binmysql test Welcome to the MySQL

Re: Weird Index usage n 3.23.36

2001-04-12 Thread Sinisa Milivojevic
Artem Koutchine writes: Hi! I have notice a very weird index selection when execution a query in 3.23.36. Here is an example: The table is: mysql describe words; ++--+--+-+ -+---+ | Field | Type

col_name(length) index and INNOBASE problem

2001-04-12 Thread BAUMEISTER Alexandre
Bonjour, Sorry I mistyped the version of Mysql with which we have the bug. It's Mysql-3.23.36 with patch correcting Solaris and other non Linux Unix problem. We found a bug in INNOBASE tables with col_name(length) indexes. Here is the table : create table test ( symbole

Mass upload

2001-04-12 Thread Khristopher_Klaich
Hello--- I am wondering if anyone has done anything that resembles the following: I need to take a flat file (currently in excell) and upload it into a MYSQL database via the web using PHP. This will happen every week so what is the best way to do this drop the table then re-create it with the

Root password forgotten in MySQL

2001-04-12 Thread Sandeep Pachpande
Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks in advance. Sandeep

Re: col_name(length) index and INNOBASE problem

2001-04-12 Thread Heikki Tuuri
Hi! Innobase does not support partial-field indexes. We have to block their usage in the SQL parser. Miguel's query on Win NT perhaps worked because the optimizer there chose another access path and did not use the partial-field index. But thank you Alex, we have to block them in the parser,

MySql developer

2001-04-12 Thread Lorenzo De Vito
I would like to know what experience need for development in MySql project, I read the istructions on the site but it say to send my software, so I want ask: What languages are required ? What kind of experience ? - Before

Re: more on the install problem

2001-04-12 Thread Gerald Clark
Well, where IS the socket? If it is not where mysqladmin is looking, then you should add to /etc/my.cnf: [client] socket=/tmp/mysql.sock Substituting the correct full path/name for the socket. Make sure /etc/my.cnf is world readable. Mike Millner wrote: I've narrowed it down some. I'm not

Re: Root password forgotten in MySQL

2001-04-12 Thread Gerald Clark
It is in the manual. Sandeep Pachpande wrote: Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks

Re: RE - MYSQL recovery/reliability under powerfail conditions

2001-04-12 Thread Bob Hall
Hi We are evaluating various RDBMS for use on within an airborne server (Embedded NT4.0) environment. This environment does not have reliable power. Aircraft are powered cycled without regard for delicate OS environments etc. Here in south Arlington, Va., the power also cycles without regard

Re: Root password forgotten in MySQL

2001-04-12 Thread B. van Ouwerkerk
Now I want to create new database for same but i forgot my root mysql password. Take a look at the manual. It's there, so USE it. You can also find the answer in this lists archive. Bye, B. - Before posting, please

Re: Root password forgotten in MySQL

2001-04-12 Thread Sven Huster
At 15:13 12.04.2001, Sandeep Pachpande wrote: Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks in

Re[2]: col_name(length) index and INNOBASE problem

2001-04-12 Thread BAUMEISTER Alexandre
Heikki, Could you please tell me (and add in the manual perhaps) if this is a planned enhancement or not and if it's planned, if it will be added in a long or a short delay. Thanks, Alex. HT Innobase does not support partial-field indexes. We have to block their HT usage in the

Re: just a question

2001-04-12 Thread Scott Meesseman
I know that there is some way to give the DOS window a scrollbar, somewhere in it's properties maybeI can't remember, in which case you can view what races past your eyes Scott At 11:08 PM 4/11/01, you wrote: Using ver 8.18 dist 3.23.36 on win98se. It unzipped just fine, installed and

Re: Mass upload

2001-04-12 Thread Marty Landman
At Thursday 4/12/01 08:56 AM, [EMAIL PROTECTED] wrote: I need to take a flat file (currently in excell) and upload it into a MYSQL database via the web using PHP. This will happen every week so what is the best way to do this drop the table then re-create it with the info. from the

Re: Root password forgotten in MySQL

2001-04-12 Thread Ken Menzel
http://www.mysql.com/doc/R/e/Resetting_permissions.html - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Sandeep Pachpande" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001

How to loada 28MB LONGTEXT data?

2001-04-12 Thread Wei Zhu
Hi everyone; I have some problem in load a 28 MB LONGTEXT data into mysql database using "LOAD DATA INFILE ...". At the beginning, server returns me the error message as below: ERROR 1030: Got error 139 from table handler I tried the same command again, then I got another error message: ERROR

Problem installing binary on AIX 4.3.1.0

2001-04-12 Thread Olivier Hislaire
From: [EMAIL PROTECTED] Date: Thu, 12 Apr 2001 17:12:06 +0200 To: [EMAIL PROTECTED] Hi there, Although I am using AIX4.3.1, I tried to install the binary version (which is built for AIX4.3.3). Most of the time, it does not make any difference, but when I run: scripts/mysql_install_db I get:

FW: MySQL Module Installation Failure

2001-04-12 Thread Jaffe, Peter S.
I accidentally forgot the attachment, sorry... -Original Message- From: Jaffe, Peter S. To: '[EMAIL PROTECTED]' Sent: 4/12/2001 8:34 AM Subject: MySQL Module Installation Failure To anyone basically familiar with MySQL: I know nothing about MySQL, and have been instructed to install

root password

2001-04-12 Thread Mr.Mongkol Phitaksuksanti
I do something wrong i testing to use dbtools to manage mysql, and i wanna to do change something but i miss. I delete user root :-( i think, now on my database don't have user root .. but i have a lot of data that i need in this

AW: unusable mysqlshow and mysqldum under 3.23.36

2001-04-12 Thread Martin Bringe
Hi, we are using an older mysql-version from binary (debian) install - without problems. Now we want to use this newer versionm because of replication- and new table-format-features (myisam). All Tables are in Format myisam. Not Database (test, mysql, our own database) is visible via mysqldump

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-12 Thread Tom Yarrish
I had a problem like this when I put together my Apache/PHP/mySQL server (now keep in mind I didn't use RPM's, I built all from source). Anyway, there's a line in the Makefile under apache-x.x.x/src that begins with LIBS1=. At the end of the line, you will probably have to add "-lz" (that's

Weird Index usage n 3.23.36

2001-04-12 Thread Michael Widenius
Hi! "Artem" == Artem Koutchine [EMAIL PROTECTED] writes: Artem Hi! Artem I have notice a very weird index selection when execution a query Artem in 3.23.36. Artem Here is an example: Artem The table is: cut Artem Now i want to find a product which contains both 'AMD' and 'DURON'. I Artem

BDB recovery error

2001-04-12 Thread Ken Menzel
We had a crash of MySQL this morning for some reason. (Why who knows!) The real problem was it would not restart until the log.* files were deleted. It looks like it was trying to perform a recovery on a dropped database. The server would not start. This is not cool! We dropped the test

Incredibly Stuck on Errcode 2 File not found in mysqlimport

2001-04-12 Thread Lucy
Hi I'm incredibly stuck. I've been through the lists over and over, and manual is silent on this detail, and have found no solution. The Unix remote host fails to find the text file to import from my pc, Win2000. The TABLE is created already. The text file is fine. I've done this via "load

Re: root password

2001-04-12 Thread Ken Menzel
http://www.mysql.com/doc/R/e/Resetting_permissions.html - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Mr.Mongkol Phitaksuksanti" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12,

RE: Select

2001-04-12 Thread Jim Zarvis
What is good clean sql syntax to accomplish the following with MySQL: SELECT * FROM tablename WHERE value is in array of values i.e. (psudocode) Assume I have a field called ID in my table, and that I have 20 Rows (with ID's 1-20) myarray = (1,3,4) I want to return all the fields where ID = 1

Re: Oops!!

2001-04-12 Thread Steve Werby
"Scott Dunn" [EMAIL PROTECTED] wrote: I accidentally crashed 1 of my tables. So I deleted everything in the table and tried to reload the data into the table and now I get this error: Query OK, 1 row affected (0.02 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 5 I have a total of 1901

RE: Select

2001-04-12 Thread Peter Skipworth
select * from blah where fieldname in (1,3,4) On Thu, 12 Apr 2001, Jim Zarvis wrote: What is good clean sql syntax to accomplish the following with MySQL: SELECT * FROM tablename WHERE value is in array of values i.e. (psudocode) Assume I have a field called ID in my table, and that I

Re: Select

2001-04-12 Thread Steve Werby
"Jim Zarvis" [EMAIL PROTECTED] wrote: What is good clean sql syntax to accomplish the following with MySQL: SELECT * FROM tablename WHERE value is in array of values i.e. (psudocode) Assume I have a field called ID in my table, and that I have 20 Rows (with ID's 1-20) myarray = (1,3,4)

Re: BDB recovery error

2001-04-12 Thread Sasha Pachev
On Thursday 12 April 2001 10:49, Ken Menzel wrote: We had a crash of MySQL this morning for some reason. (Why who knows!) The real problem was it would not restart until the log.* files were deleted. It looks like it was trying to perform a recovery on a dropped database. The server would

RE: Select

2001-04-12 Thread Gonzalez, Kristopher
by the way, that's not a functional example...i was using array syntax, but this won't work if you try to use it as is...it should be a 'list' or else contain an even number of elements...not that it's relevant, but i hate posting code that's inoperable... -Original Message-

Re: oops!!! Here's the output

2001-04-12 Thread Scott Dunn
mysql describe main; ++--+--+-+-+---+ -+ | Field | Type | Null | Key | Default | Extra | Privileges |

Is this a bug?

2001-04-12 Thread Chris Harshman
At the first of the month (no changes made to the database; this script is just running SELECT statements at present) the number of rows returned by this query dropped noticeably. Is this a bug, is my query just fubar'd, or...? SELECT account.username AS account_username, customers.username AS

Re: Is this a bug?

2001-04-12 Thread René Tegel
you try to select the march 87. 2001 ;) read the manual about date/time conversion and math: mysql select current_date(), current_date()-0, current_date()-14; | current_date() | current_date()-0 | current_date()-14 | | 2001-04-12 | 20010412 | 20010398 | 1 row in set (0.00

Linux MySQL issues

2001-04-12 Thread Mike Haboustak
Hello there list! I'm having some trouble with my web server running Apache and MySQL. I'm accessing the DB through the latest DBI:DBD and Perl. I was running 2.22.32 quite successfully for about a year until usage starting becoming a problem. I upgraded to 2.23.36 and the problem stayed the

Re: adding columns to my database

2001-04-12 Thread Lindsay Adams
ALTER TABLE tablename ADD COLUMN column_name creation clause; On 4/12/01 12:04 PM, "Dean MacIsaac Jr." [EMAIL PROTECTED] wrote: I'm just not understanding what I'm reading in Ch. 7. I created a table, in my database, now I just want to add 2 more varchar columns to it. I tried

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-12 Thread Mark Worsdall
Hi, I have had some various similar things happen with other apps since upgrading to Fbsd4.2stable What I have learnt to do first before anything else is, reboot and load a SINGLE CPU compiled kernel to determine at what/where the bug may be. I had a/still occasionally get a constant waiting

privilege problem

2001-04-12 Thread Leon Zilber
I am not sure I am encoutering the following problem when I try to access the database? java.sql.SQLException: Server configuration denies access to data source java.sql.SQLException: Server configuration denies access to data source My java program defines: user and a password and when I

commit/rollback?

2001-04-12 Thread Jochen Mielke
Hello, Let's say I have a file which contains the following lines: insert into table_1 values (1,2,3); insert into table_2 values (4,5,6); It's called from the command line with mysql -u root -ppassword db_name file; I would like to undo the first operation on table_1 in case the second

Re: BDB recovery error

2001-04-12 Thread Ken Menzel
Hi Sasha, Looks like you found two bugs at once. The first one is that someone mysqld segfaults, probably a bug in processing some query or possibly some OS issue, but there is not much we can tell at this point - the only way to track it down would be if you had full logging enabled and

RE: adding columns to my database

2001-04-12 Thread Dean MacIsaac Jr.
Billy, and friends, Always helpful info: What have you tried, and what errors are you getting? alter table web_guests add column (p1 varchar(15), p2 varchar(15)); Error 1064 You have an error in your sql syntax near '(p1 varchar(15), p2 varchar(15))' at line 1 TIA, Dean MacIsaac

Re: Is this a bug?

2001-04-12 Thread btjones
/time conversion and math: mysql select current_date(), current_date()-0, current_date()-14; | current_date() | current_date()-0 | current_date()-14 | | 2001-04-12 | 20010412 | 20010398 | 1 row in set (0.00 sec) gl - Original Message - From: "Chris Harshman&qu

Re: commit/rollback?

2001-04-12 Thread Thalis A. Kalfigopoulos
You can't with MyISAM and executing from shell prompt. Either alter the table type to BDB or Innobase If you stick with MyISAM you can use a higher level language (perl,php) to check the return value of each insert and handle the flow accordingly. If the 2nd insert fails, you'll have to

Re: ssh connection between web server and mysql]

2001-04-12 Thread Jeremy Zawodny
On Thu, Apr 12, 2001 at 02:32:42PM +0800, Leon Harris wrote: On the client I do a ssh -q -n -f -l account -L 3306:mysqlserver.mydomain.com:3306 then mysql -u dbuser --port=3306 -h 127.0.0.1 -p dbname and I get an encrypted connection. ( thats what tcpdump shows me) ! Lovely ! But

Re: time and date

2001-04-12 Thread Alexander Skwar
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500: Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. Thanks! Either add a timestamp column to your

ms frontpage

2001-04-12 Thread ilker YILDIZ
Hi, I want connect mysql databse with ms front page 200. How? What do i? Thanks.

Mysql and Perl DBI

2001-04-12 Thread Gordon Stewart
I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-13.tar.gz. Can any one help Gordon [gordon@fido

Re: BDB recovery error

2001-04-12 Thread Sasha Pachev
On Thursday 12 April 2001 14:03, Ken Menzel wrote: Hi Sasha, Looks like you found two bugs at once. The first one is that someone mysqld segfaults, probably a bug in processing some query or possibly some OS issue, but there is not much we can tell at this point - the only way to

Re: How to loada 28MB LONGTEXT data?

2001-04-12 Thread ryc
# perror 139 Error code 139: Unknown error: 19 139 = Too big row (= 16 M) This means the 28MB row you tried loading is bigger than the max allowed packet size. You might want to change the max_allowed_packet variable (ie -O max_allowed_packet=32M or something similar on the commandline). The

Re: SELECT Calculation

2001-04-12 Thread ryc
What you wrote will work just fine. It is very easy to create a test case and see if it works, saves you the trouble of posting to the list. mysql create table test (a int, b int, c int); Query OK, 0 rows affected (0.09 sec) mysql insert into test values (2,3,5); Query OK, 1 row affected (0.00

Help with complex SQL Query

2001-04-12 Thread Peter M. Perchansky
Greetings: Prelude: We have five tables all sharing a very similar structure (each has a Customer_ID and Server_ID field for example). Each table can contain zero to many records with duplicate Server_ID values allowed. Need: I need to be able to count the distinct Server_ID's across all of

Identifying unused databases

2001-04-12 Thread Gary Huntress
I have been offering free hosting of MySQL databases at freesql.org for the last few weeks. As a result I now have several hundred databases (which I think is great!), with a subset (perhaps 50) that are in active use. I would like to implement a policy where I can cull dormant or otherwise

__tz problem in sys/time.h

2001-04-12 Thread Greg Berry
Description: When compiling mysql-3.23.36, many *.cc files caused a compilation error that said that __tz has multiple data definitions in /usr/include/sys/time.h. It first happens in the client subdirectory, but happens many times after that as well. I am using RH Linux 2.2.16-22smp gcc

Re: Identifying unused databases

2001-04-12 Thread Chris Harshman
You should be able to use 'find' on the directory and search by UNIX atime (atime is updated whenever the database is accessed, be it a read or a write). `find . -atime ...` man find for more details. From there, it's a simple shell script On Thu, 12 Apr 2001, Gary Huntress wrote: I have

Re: Is this a bug?

2001-04-12 Thread Chris Harshman
Never mind; thanks for the pointers to TFM... =) The updated, working query looks like this: TO_DAYS(NOW()) - TO_DAYS(customers.last_mod) 14 Thanks all! On Thu, 12 Apr 2001, Chris Harshman wrote: At the first of the month (no changes made to the database; this script is just running

PHP (--with MySQL) Installation error

2001-04-12 Thread LAURIE KEITH
I am trying to install PHP 4.0 on a intel machine running Red Hat Linux 6.2. I have the MySQL version 3.22.32 installed and works fine. It is located in: /usr/local/mysql-3.22.32-pc-linux-gnu-i686 When installing the PHP with the ./configure command I get:

relationship/field design

2001-04-12 Thread Dennis Gearon
I have a table design question, looking for tips, not the exact sql to create the tables. I have tried several solutions, and as yet, I don't like what I am coming up with. So if someone could help me, I would be grateful. Assumptions: email_address's have several types, defined by a separate

URGENT: select in (select) or Join?

2001-04-12 Thread Sofiane Sakhri
Hello, Please, I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help, My query is : select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'word1%')

mysql installation problems on sparc-sun-solaris8

2001-04-12 Thread Ethan Wellman
I downloaded the solaris 8 mysql package from ftp://ftp.sunfreeware.com/pub/freeware/sparc/8/mysql-3.22.26a-sol8-sparc-local.gz and installed it, but when i try to run /usr/local/mysql/bin/safe_mysqld, it reports the following error to /usr/local/mysql/var/wakko.err: mysqld started on Thu

connecting to mysql using php

2001-04-12 Thread josh kneedler
i'm trying to connect to mysql using php so that i can do web based queries of my tables. i'm new at this so here are some questions: 1. is localhost just the ip of my server or is it also the path to where mysql is on my server? 2. if root is the login name should it be my login or just stay

Cracking Win 2000 hash?

2001-04-12 Thread Alan Halls
I have a flat txt file that I need to decrypt so that I can build a new database for membership. It was encrypted on a Windows 2000 box. Here is an example of the format: mystic:kdYE[JQKAZAKaMZEKWNeL: mr:ihIAUNUYBACYUZeK_^]d: jr:bxX[TMcaXAeIed__[LWN: Anybody have any suggestions? Alan

Re: Cracking Win 2000 hash?

2001-04-12 Thread Roel Vanhout
Do you have code on how it is encrypted? 'on a windows 2000 box' doesn't say much. Windows passwords are stored in the sam database, in a binary format, unreadable by users (and even by admins). You can brute force those with l0pthcrack (www.l0pht.com), I don't know if it works for windows 2000.

Re: connecting to mysql using php

2001-04-12 Thread Roel Vanhout
This is a real RTFM, but here we go: On Thu, Apr 12, 2001 at 04:03:20PM -0700, josh kneedler wrote: i'm trying to connect to mysql using php so that i can do web based queries of my tables. i'm new at this so here are some questions: 1. is localhost just the ip of my server Yes. Or just

Re: relationship/field design

2001-04-12 Thread Roel Vanhout
On Thu, Apr 12, 2001 at 03:16:42PM -0700, Dennis Gearon wrote: The biggest problem seems to be structuring the tables to force the requirement for at least ONE email address, but not having to create lots of empty fields. Looks like you're looking for foreign keys, but you can't do that in

Re: Cracking Win 2000 hash?

2001-04-12 Thread Steve Brazill
"l0phthcrack" should work, since the "rocket scientists" in Redmond have still retained the "NetBIOS" version of the password (the old "Windows for Workgroups" version) in the SAM. So much for improved security... (HA HA HA HA HA HA HA ) Roel Vanhout wrote: Do you have code on how it is

Re: connecting to mysql using php

2001-04-12 Thread Rolf Hopkins
Let me explain a little further. - Original Message - From: "josh kneedler" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 13, 2001 7:03 Subject: connecting to mysql using php i'm trying to connect to mysql using php so that i can do web based queries of my tables. i'm

Re: privilege problem

2001-04-12 Thread Rolf Hopkins
...And you have checked that permissions have been set correctly, both in MySQL and at the OS level. - Original Message - From: "Leon Zilber" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 13, 2001 3:27 Subject: privilege problem I am not sure I am encoutering the

UTF-8 supported, compatible or plain won't work ?

2001-04-12 Thread S A
Can you use UTF-8 with MySQL ? Is UTF-8 supported now, just compatible or plain won't work ? I've read conflicting discussion on this topic. thanks, - Sam. - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

  1   2   >