Is MySQL support distributed database ?

2001-04-12 Thread Rajesh Matkar
Dear Sir, Is MySQL support distributed database or not ? If yes, then please let me know , how it's doing . Regards Rajesh Matkar

where is the chinese (big5) version, windows binary distribution

2001-04-12 Thread Hugh
i need a mysql binary distribution with chinese big5 charset compiled...WINDOWS version. i have ever download an source code for windows version, but i cannot be compile as big5 version, coz there seems not has a file named "configure" might exist in Unix platform. i dont know how to compile i

MyOdbc Silent Install

2001-04-12 Thread Yusuf Incekara
Dear Res Rickli , Victor , David Brieck , Joachim Klein, Gerald R. Jensen, Edward Apostol , Lee Jenkins ... Thanks for interesting Myodbc Silent Install Merge Module. Due to i get too many copy request and because of the merge module 's size (3,5 MB) i have to put it on a web page. Scripts are re

Ynt: ms frontpage

2001-04-12 Thread Yusuf Incekara
try to create a odbc dsn using myodbc. - Original Message - From: ilker YILDIZ <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 11:40 PM Subject: ms frontpage Hi, I want connect mysql databse with ms front page 200. How? What do i? Thanks.

RE: getting ip of mysql server

2001-04-12 Thread Yusuf Incekara
There is some free codes on the web which written in different languages that queries subnet and mysql's standart port on each of theese possible clients. I mean ping machines first on the subnet. then query port 3306 . if replies then try to connect . if connect it works. I have one written with

mail to mysql database recepient

2001-04-12 Thread Prasad Mhatre
Dear All, I will like to mail all the users in Mysql database having valid email record, their data with user name and password. How to go about this? does anyone have a free script to share? I also want a column to be updated with random password for each user. Any help is appreciated. Than

Re: Books

2001-04-12 Thread Steve Werby
"Mike" <[EMAIL PROTECTED]> wrote: > I am looking at using MySQL,Apache and PHP on a Web app and was wondering if > there was a good book out there. I seen a few on the MySQL site that look > really interesting, any comments on them. It would be helpful to know how experienced of a programmer and

Re: query memory usage

2001-04-12 Thread Steve Werby
"ryc" <[EMAIL PROTECTED]> wrote: > When performing a query that will return a large dataset (by large I mean > 100k+ rows), is it more effecient (memory usage wise) to use the results as > you fetch them or fetch all the results into an array, free the statement > handle, and the process from arra

query memory usage

2001-04-12 Thread ryc
When performing a query that will return a large dataset (by large I mean 100k+ rows), is it more effecient (memory usage wise) to use the results as you fetch them or fetch all the results into an array, free the statement handle, and the process from array? What about performance wise? I am usin

Books

2001-04-12 Thread Mike
I am looking at using MySQL,Apache and PHP on a Web app and was wondering if there was a good book out there. I seen a few on the MySQL site that look really interesting, any comments on them. Cheers Mike Benzel [EMAIL PROTECTED] Code it once with ASTA and run it anywhere Servers (Win32,Linux,Ja

RE: MySQL error (newbie)

2001-04-12 Thread Mike
I had the same thing on two recent installs. My fix, uninstall it and download the current release Server and Client from the MySQL site. Works great here Cheers Mike Benzel [EMAIL PROTECTED] Code it once with ASTA and run it anywhere Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,W

Re: adding columns to my database

2001-04-12 Thread N!kke
and if that won't work you dont have alter privileges for your table. Cheers, Nikke > Från: "Billy Passauer" <[EMAIL PROTECTED]> > Datum: Thu, 12 Apr 2001 15:16:19 -0400 > Till: "Dean MacIsaac Jr." <[EMAIL PROTECTED]> > Kopia: <[EMAIL PROTECTED]> > Ämne: RE: adding columns to my database > > A

MySQL error (newbie)

2001-04-12 Thread myjunk
I recently installed MySQL from the Red Hat 7.0 CD. When I try to access MySQL as a standard user I get this error. "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.socket'(111)" Any idea on what I need to do to correct this? Mike ---

Re: ssh connection between web server and mysql

2001-04-12 Thread Leon Harris
Hi Jeremy, thanks for your reply. I believe that the session was idle. It also does it when I give the -2 option to ssh ( ssh2 is supposed to not time out, according to some usenet posts I have read). The point of the excercise is to have an encrypted connection that I can make DBI calls to the

Re: Select

2001-04-12 Thread Steve Werby
"David Beech" <[EMAIL PROTECTED]> wrote: > On 12 Apr 2001, at 13:54, 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 ta

Re: connecting to mysql using php

2001-04-12 Thread David Beech
On 12 Apr 2001, at 16:03, 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 or is it also the path to > where mysql is on my server? Just the

Re: round and computer science

2001-04-12 Thread Dennis Nichols
At 4/13/01 03:42 AM, Peter Holm wrote: >mysql> select floor(23.49 + 0.5); >++ >| floor(23.49 + 0.5) | >++ >| 23 | >++ > >mysql> select floor(23.49

Re: No Subject

2001-04-12 Thread Steve Werby
<[EMAIL PROTECTED]> wrote: > Can i make a user friendly interface for Sales people to make a contact > to my data base on mysql running on my linux server. Your question is pretty vague. You'll probably want to investigate a web scripting language such as PHP or Perl, which can interact with MyS

Re: ssh connection between web server and mysql]

2001-04-12 Thread Leon Harris
[EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query > > If you just reply to this message, and include

RE: Select

2001-04-12 Thread David Beech
On 12 Apr 2001, at 13:54, 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 have 20 Rows (with > ID's 1-20) > > m

Re: Incredibly Stuck on Errcode 2 File not found in mysqlimport

2001-04-12 Thread David Beech
On 12 Apr 2001, at 17:53, Lucy wrote: > 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. Th

Re: No Subject

2001-04-12 Thread Joshua J. Kugler
You sure can. How is left as an exercise for the reader. Read up on HTML, Perl, and DBI. That should get you started. j- k- On Friday 13 April 2001 12:31, [EMAIL PROTECTED] wrote: > Hi, >Can i make a user friendly interface for Sales people to make a contact > to my data base on m

Problem with Access, recordsets, and ODBCDirect work spaces...

2001-04-12 Thread Joshua J. Kugler
Yes, I have read the manual, many times, and searched the archives. I am using an ODBCDirect (in MS Access 97) workspace to connect to the MySQL server. That works fine, and I can get and display data. I can even execute a recordset.edit command, but when I do recordset.update, I get ODBC cal

No Subject

2001-04-12 Thread atifch
Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://list

Re: Select Question

2001-04-12 Thread Benjamin Pflugmann
Hi. On Thu, Apr 12, 2001 at 09:39:46PM -0400, [EMAIL PROTECTED] wrote: > The following works ok in SQL Server, can it work in mySQL? > > select * from users where id in (select userid from group where name='sales') Sub-selects are not (yet) supported by MySQL. But you can rewrite that query to

Character Set

2001-04-12 Thread Huy, Tran Le Huy
Hello, I am working with a MySQL 3.22.32 on Sun.When I run my application on it(Jakatatomcat + Apache + DataBase MySQL), I can not show character set is French. But When I change by run Jakatatomcat + Apache on my client(WINNT 40) and Database MySQL on Sun , I can show character set french. Plea

round and computer science

2001-04-12 Thread Peter Holm
OK, I understand this is something very basic, I should understand. Maybe anybody can teach me the difference between: mysql> select floor(23.49 + 0.5); ++ | floor(23.49 + 0.5) | ++ |

Select Question

2001-04-12 Thread James Gonthier
The following works ok in SQL Server, can it work in mySQL? select * from users where id in (select userid from group where name='sales') TIA, Jim Gonthier --- The Fastest Browser on Earth now for FREE!! Download Opera 5 for Windows now! Get it at http:

Stable version

2001-04-12 Thread Jocelyn Bernier
Hi everybody, I am currently running MySQL 3.23.35 on Windows NT 4.0 SP6. I checked the mailing list regularly and didn't see any complaint or bug report regarding version 3.23.37. In fact I would like to know what is the most stable version running on that platform ? __

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.

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 fol

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

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: 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: 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: 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.

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 -

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 as

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 Apr

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%') and

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: 's have several types, defined by a separate table:

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: **

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 SE

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

__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 version

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 aban

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 t

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

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 d

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

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 gordon]

ms frontpage

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

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 t

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 ! > >

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 compleme

Re: Is this a bug?

2001-04-12 Thread btjones
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 sec) gl - Original Message - From: "

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: 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

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 -p db_name < file; I would like to undo the first operation on table_1 in case the second query (on t

RE: adding columns to my database

2001-04-12 Thread Billy Passauer
Always helpful info: What have you tried, and what errors are you getting? Try: ALTER TABLE yourtablename ADD COLUMN (newcol1 VARCHAR(10), newcol2 VARCHAR(25)); ... Billy ... > -Original Message- > From: Dean MacIsaac Jr. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 12, 2001 3:0

SELECT Calculation

2001-04-12 Thread Steve Lowe
Hi, Can someone tell me if it is possible to have a calculation in a SELECT statement. EG SELECT * FROM (table_name) where (col_1 + col_2 = col_3) I am using MySQL 3.23.xx and PHP4 I only want to display those fields where the sum is true. Kindest Regards, Steve Lowe -

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 connect

RE: adding columns to my database

2001-04-12 Thread Ravi Raman
hi. alter table sometable add column newcol VARCHAR(20) after oldcol; change sometable, newcol, oldcol and the column definition to what you want. hth. -ravi. -Original Message- From: Dean MacIsaac Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 3:04 PM To: [EMAIL PROTECT

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

Re: adding columns to my database

2001-04-12 Thread Lindsay Adams
ALTER TABLE tablename ADD COLUMN column_name ; 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 following along

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 sa

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

adding columns to my database

2001-04-12 Thread Dean MacIsaac Jr.
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 following along with the manual, but, I'm not seeing it, and I get errors every time in telnet. If someone would be so kind as to help me, I appr

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 c

Re: oops!!! Here's the output

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

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: 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 wo

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 =

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 t

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 1

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: 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 1

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 da

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 datab

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: Artem> Now i want to find a product which contains both 'AMD' and 'DURON'

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 spac

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 or

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 database

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 it

MySQL Module Installation Failure

2001-04-12 Thread Jaffe, Peter S.
To anyone basically familiar with MySQL: I know nothing about MySQL, and have been instructed to install it on a RedHat 7.1 Linux system. I went through installing MySQL server, client, and development RPMs and that worked fine. Now I skipped the installation of the DataDumper module (because it'

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:

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

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

Oops!!

2001-04-12 Thread Scott Dunn
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 records in this txt file. I puts the first reco

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: Re[2]: col_name(length) index and INNOBASE problem

2001-04-12 Thread Heikki Tuuri
Alex, sorry, but it is not a planned enhancement for a long time. For small columns it is as good to create an index on the whole column, because there is at least some 15-byte space overhead for secondary index records anyway. For large columns the application can add an extra column to the tabl

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 >an

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 th

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 i

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 chec

Re: I Need your help

2001-04-12 Thread Bob Hall
>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_Entre

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 re

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.

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 no

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 posti

  1   2   >