Re: How to query SET OPTION variables?

2002-05-03 Thread Jeremy Zawodny
On Fri, May 03, 2002 at 01:22:30PM +0200, Harald Fuchs wrote: > > How about "SHOW OPTIONS [LIKE wild]", nicely accompanying "SHOW VARIABLES"? Yeah, that'd be the way to go, I think. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-54

mysql.sock file does not get created

2002-05-03 Thread vigneshvg
>Description: I try to run the mysqld script to start the MySQL server. It starts, then immediately I get a message saying it has ended. [root@localhost init.d]# ./mysql.server start [root@localhost init.d]# Starting mysqld daemon with databases from /var/lib/mysql/mysql 020504 11:22:19 mysql

RE: dupe records

2002-05-03 Thread Anvar Hussain K.M.
Hi, At 07:56 AM 03/05/2002 -0500, you wrote: >[snip] > Here is probably an easy question to answer, but I can't figure > an EASY >way to do it. Right now, I use a temp table with a unique column to solve >it. I am hoping that there is a way in the SELECT >statement. AnywayWhat I wa

Re: Data transition

2002-05-03 Thread Dicky Wahyu Purnomo
On Sat, 4 May 2002 07:23:46 +0400 support <[EMAIL PROTECTED]> wrote: > Hello, everybody! > > Please give me a hint at some resources about synchronization of two > MySQL databases, situated in different places. > > The point is, I have my local and providers' versions of the same > database. A

MySQL Installation Problem

2002-05-03 Thread Jagadeesh Suryadevara
Hello, I downloaded all the following files to load MYSQL software. mysql-4.0.0a-alpha-win-src.zip mysql-4.0.0a-alpha-win.zip mysql-4.0.1a-alpha-win-src.zip mysql-4.0.1a-alpha-win.zip I installed mysql after unzipping the above two versions of .zip files. After install

MySQL Installation Problem

2002-05-03 Thread Jagadeesh Suryadevara
Hello, I downloaded all the following files to load MYSQL software. mysql-4.0.0a-alpha-win-src.zip mysql-4.0.0a-alpha-win.zip mysql-4.0.1a-alpha-win-src.zip mysql-4.0.1a-alpha-win.zip I installed mysql after unzipping the above two versions of .zip files. After install

Data transition

2002-05-03 Thread support
Hello, everybody! Please give me a hint at some resources about synchronization of two MySQL databases, situated in different places. The point is, I have my local and providers' versions of the same database. And need to synchronize them at a daily basis with the least traffic involved. Thank

Group by "counted" records...

2002-05-03 Thread Edilson Vasconcelos de Melo Junior
Hi, My table have two fields (iduser INT, dtaccess TIMESTAMP) with the following data: iduser | dtaccess --- 10 | '2000-10-02' 3 | '2000-12-04' 4 | '2000-10-09' 3 | '2000-12-04' 5

speed optimization on awkward self join

2002-05-03 Thread Colin Anderson
I'm starting to get pretty comfortable with mysql, but I'm still a beginner, and I've run into a problem I can't seem to get around. I'm having trouble getting a particular query to run within anything approaching a reasonable amount of time -- I'm not sure whether it's a problem with my query s

MySQL Query Problem

2002-05-03 Thread Kory Wheatley
I'm working with an event calendaring system that keeps track of the time an event starts and the time the event ends. The Duration field holds a decimal value equivalent to the length of time the event lasts. Here is the description of the Schedule table which holds this field: mysql> describe

Performance issues between two servers

2002-05-03 Thread Carl McNamee
Backgroud: We have a process that runs on a server (APPDEV1) that writes records to a mysql server (SQLDEV0). We attempted to move the databases from SQLDEV0 to SQLDEV1 and have run into some sort of performance bottleneck. The server SQLDEV0 is a Compac server with ~2GB of ram and two processors

RE: Any ideas how to speed this up?

2002-05-03 Thread Venu
Hi, > -Original Message- > From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 03, 2002 2:00 PM > To: 'Alexander Shaw'; MySQL List > Subject: RE: Any ideas how to speed this up? > > > What version of the ODBC Drivers are you using? > > I had a VB app using the 3.5x

RE: Any ideas how to speed this up?

2002-05-03 Thread Alexander Shaw
Cheers Ken, will give that a try for a start. Alex -Original Message- From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] Sent: 03 May 2002 22:00 To: 'Alexander Shaw'; MySQL List Subject: RE: Any ideas how to speed this up? What version of the ODBC Drivers are you using? I had a VB app us

RES: My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Edilson Vasconcelos de Melo Junior
Hi, Thank u very much!! It helped a lot... I also created two indexes: one in wmkt_email_sent for (nmachine e fkpbl) and another in wmkt_client for fkEmail (both sugested by Luciano Barcaro). About the size of the resultset: all these table have about 100.000 records and they can be about 10.000.0

RE: Any ideas how to speed this up?

2002-05-03 Thread Kenneth Hylton
What version of the ODBC Drivers are you using? I had a VB app using the 3.5x versions of the ODBC driver manipulating very small tables and it was absolutley painful to run. I stepped back to the version 2.x drivers (2.9, I think - anyhow, the driver information is available on the web site)

mysql - problem with timeout

2002-05-03 Thread info
hello ... first excuse my bad english ;-( we have a problem . one of our servers is working with the following components and configuration: linux suse 7.1 mysql 3.23.33 phpadmin 2.2.5 webmin 0,90 our problem . we work with a few databases in mysql ... often when we start more than

Re: select by total goals

2002-05-03 Thread Alex Behrens
Hey, I'm trying to display this information on a page, but I'm having trouble. How do I output this into php? mysql, query Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779

Re: display days between two dates?

2002-05-03 Thread mos
At 01:36 PM 5/3/2002, you wrote: >Hello, > >Newbie SQL person here. I am hoping to be able to do the >following. Given two dates, I would like to display all of the days >between them. > >So if I had the dates 2002-02-08 and 2002-02-12, I would like to have >MySQL spit back > >2002-02-08 >2002-02-

java...mysql

2002-05-03 Thread Nick Stuart
Sorry if this got sent twice... Hello all. Im trying to right a simple program for MySQL through java but am running into a problem of sorts. Following is the code that has theproblem: conn = DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=");stmt = conn.createSt

Any ideas how to speed this up?

2002-05-03 Thread Alexander Shaw
Hi, I'm currently developing an application with an Access 2000 front end and MySQL back end. I have coded in updates to a table (based on selections in a list box) with a work around for the lack of support for sub selects using a temporary table. The problem is that already with quite small am

Re: (Maybe) Silly question

2002-05-03 Thread João Paulo Vasconcellos
On Friday 03 May 2002 16:19, Cal Evans wrote: > 4 step process > > ALTER TABLE to add a new Date column > > Populate the new field with the date portion of the DATETIME > > Drop the DATETIME column > > Rename the DATE column with the name of the original field. > Thanks. I'll try it. > -

RE: (Maybe) Silly question

2002-05-03 Thread Cal Evans
4 step process ALTER TABLE to add a new Date column Populate the new field with the date portion of the DATETIME Drop the DATETIME column Rename the DATE column with the name of the original field. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Ori

RE: Simple Question relating to Indexing

2002-05-03 Thread Cal Evans
I've not checked your syntax but it looks like you've got the idea. One caveat. Unless you have a UNIQUE index, you can have multiple people named John Smith. If you specify UNIQUE in your index clause then you can't. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.caleva

Re: Solved (Re: 4.0.2 Replication still buggy...)

2002-05-03 Thread Jeremy Zawodny
On Fri, May 03, 2002 at 11:46:42AM -0600, Sasha Pachev wrote: > On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: > > After even more tracking stuff down, I managed to isolate it to a > > change made in MySQL 4.0.1. ?The query in question was doing: > > > > ? INSERT INTO ... SELECT ... > >

(Maybe) Silly question

2002-05-03 Thread João Paulo Vasconcellos
Hello everybody, i was thinking about my database, and I found that the guy who planned it before me created a field to hold the date people registered with the site. The field is a DATETIME, but the time portion is never used! So, I began to wonder if I could resize the field to DATE, but

display days between two dates?

2002-05-03 Thread Tim Carlson
Hello, Newbie SQL person here. I am hoping to be able to do the following. Given two dates, I would like to display all of the days between them. So if I had the dates 2002-02-08 and 2002-02-12, I would like to have MySQL spit back 2002-02-08 2002-02-09 2002-02-10 2002-02-11 2002-02-12 Any way

Changing column from UNIQUE?

2002-05-03 Thread NIPP, SCOTT V (SBCSI)
I have a column in a table that is currently configured as UNIQUE. I have recently discovered that some duplicates may exist in this column, so I want to remove the UNIQUE flag on this column. How? Thanks. sql > Scott Nipp > Systems Analyst > SB

Re: Simple Question relating to Indexing

2002-05-03 Thread Shaun Bramley
I'd like to first thank Carl and Anders for your quick and very informative answers. I really appreciate it. To get this staightened out, for a table specified by: CREATE TABLE Player ( PlayerID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, TeamID INT NOT NULL, TrophyFlag TINYINT, Reco

Re: Solved (Re: 4.0.2 Replication still buggy...)

2002-05-03 Thread Sasha Pachev
On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: > After even more tracking stuff down, I managed to isolate it to a > change made in MySQL 4.0.1. ?The query in question was doing: > > ? INSERT INTO ... SELECT ... > > rather than > > ? INSERT IGNORE INTO ... SELECT ... > > MySQL 3.23.x

RE: Optimization

2002-05-03 Thread Jay Blanchard
[snip] I want to optimize one of my php scripts to acess mysql only once. Is there anyway to put these two queries together: SELECT COUNT(*) from TABLE where name="JOHN" SELECT * from TABLE where name="JOHN" limit 10 [/snip] try select *, sum(if(name = 'JOHN', 1, 0)) AS COUNT from table where n

RE: My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Jay Blanchard
You have written the following: [snip & arrange] SELECT idemailsent, email, idclient FROMwmkt_email_sent a, wmkt_client b, wmkt_email c WHERE nMachine = 0 AND c.idemail=a.fkemail AND b.f

RE: Simple Question relating to Indexing

2002-05-03 Thread Svensson, B.A.T. (HKG)
> Hello all being relatively new on the SQL scene I must say some of the > concepts are a little new and strange to me. My really big question is what > is the difference between an index and a key? are the synonamous with each > other? A key will identifying a row or several rows. Just like yo

Optimization

2002-05-03 Thread Rodrigo Pérez
Hi, I want to optimize one of my php scripts to acess mysql only once. Is there anyway to put these two queries together: SELECT COUNT(*) from TABLE where name="JOHN" SELECT * from TABLE where name="JOHN" limit 10 Is it possible ? Thanks, Rodrigo --

Re: My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Colin Faber
Hi Edilson, Increase your key and join buffers. also select your absolute values first. i.e.: SELECT idemailsent, email, idclient FROM wmkt_email_sent a, wmkt_client b, wmkt_email c WHERE fkuser = 1 AND fkpbl = 23 AND nMachine = 0 AND c.idemail=a.fkemail AND b.fkemail=a.fkemail ORDER BY email L

My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Edilson Vasconcelos de Melo Junior
Hi, My query is running very very VERY slowly and this is creating a lot of troubles. Please, see it below and if u find something useful and faster i'll be very grateful. MYSQL >> SELECT idemailsent, email, idclient FROM wmkt_email_sent a, wmkt_client b, wmkt_email c WHERE nMachine = 0

RE: How to Count(*) with LIMIT

2002-05-03 Thread mos
At 09:46 AM 5/3/2002, you wrote: > > Nope. :) > > The table could be in excess of 1 million rows. The > > user sees just the > > first 100 rows no matter what. If he wants to see a > > different group of > > records he can use the search fields at the top of > > the form. I want the web > > serve

Re: Strategies for maintaining tables calculated from other tables?

2002-05-03 Thread Jeff Kilbride
MySQL has a column type for that, so you don't have to use an INT or BIGINT: http://www.mysql.com/doc/S/E/SET.html --jeff - Original Message - From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 4:19 AM Subject: Re: Strategies for maintaining tabl

RE: need SQL assistance with a few selects MORE INFO

2002-05-03 Thread Jay Blanchard
[snip] 2. The date of max disksize and the date of min disksize...in one query...if that's possible. [/snip] mysql> select RunDate, -> MAX(IF(ClientName = 'ABC INC', DiskSize, '')) AS ABC, -> MAX(IF(ClientName = 'Eat at Joe', DiskSize, '')) AS Joe, -> MAX(IF(ClientName = 'The Hop', Di

RE: Simple Question relating to Indexing

2002-05-03 Thread Cal Evans
I'll take a stab at this. A key is a value that you can use in a table and relate it to another table. In this usage you will hear people talk of primary keys and foreign keys. A primary key is a value that uniquely identifies a record in a table. With VERY FEW exceptions, all tables should hav

Simple Question relating to Indexing

2002-05-03 Thread Shaun Bramley
Hello all being relatively new on the SQL scene I must say some of the concepts are a little new and strange to me. My really big question is what is the difference between an index and a key? are the synonamous with each other? Thanks in advance Shaun Bramley query mysql ---

RE: need SQL assistance with a few selects

2002-05-03 Thread Jay Blanchard
[snip] 1. An average disksize for each client, date doesn't matter. The result I'd like to see would be something like: "ABC INC","1.8" "Joe's Restaurant","1.2" [/snip] mysql> SELECT CLIENT_NAME, AVG(DISK_SIZE) AS Average, MIN(DISK_SIZE) AS Minimum, MAX(DISK_SIZE) AS Maximum -> from table <--

Re: Question

2002-05-03 Thread Egor Egorov
Shows, Friday, May 03, 2002, 5:02:16 PM, you wrote: SL> Description: SL> error = SL> Column 'nombre' is used with UNIQUE or INDEX but is not defined as NOT NULL SL> My server= SL> mysql Ver 9.38 Distrib 3.22.30, for pc-linux-gnu (i686) SL> Question= SL> Can you help me ? You can't create ind

Re: Re: Re: GUI managers for Linux

2002-05-03 Thread Victoria Reznichenko
Rance, Thursday, May 02, 2002, 8:51:24 PM, you wrote: RH> Victoria, RH> You asked me to be sure that the information going into the MyCC dialog box RH> about the server was correct, and it is, port, user, password, and host, but RH> still no connect, php can even connect to the database with t

indexing?

2002-05-03 Thread Steve Bradwell
> -Original Message- > From: Steve Bradwell > Sent: Friday, May 03, 2002 10:31 AM > To: '[EMAIL PROTECTED]' > Subject: indexing? > > I've been doing some reading on indexes but I thought I should get an > experienced persons input. My question is about "Over Indexing". > I have

RE: How to Count(*) with LIMIT

2002-05-03 Thread olinux
> Nope. :) > The table could be in excess of 1 million rows. The > user sees just the > first 100 rows no matter what. If he wants to see a > different group of > records he can use the search fields at the top of > the form. I want the web > server to serve as many pages/sec as possible and >

Re: Database Maintenance Philosophy ?

2002-05-03 Thread Brent Baisley
Well, the first obvious suggestion is to use RAID to avoid "hiccups" with disk failure. You probably already have that. At my last job we setup all our servers so that everything was stored on an external RAID. The only thing on the internal (software mirrored) disks was the OS and whatever confi

need SQL assistance with a few selects

2002-05-03 Thread Robert L. Yelvington
Greetings folks, I am able to do all this by pulling out data with PHP or PERL...just need some straight MySQL command line advise Specifically, I need some assistance with the following: Here's my table's structure (table name is 'table'): ID, CLIENT_NAME, CLIENT_LOGIN, DISK_SIZE, RUNTIME

Re: Question

2002-05-03 Thread Michael Chang
Columns that are UNIQUE or indexed *MUST* be defined as NOT NULL (e.g.: 'nombre INT NOT NULL') Michael On Fri, 3 May 2002, Shows Lycos wrote: > > Description: > error = > Column 'nombre' is used with UNIQUE or INDEX but is not defined as NOT NULL > > My server= > mysql Ver 9.38 Distrib

Re: Good color coded SQL editor for MySQL?

2002-05-03 Thread João Salvado
Running emacs 21.2 in Windows NT environment: (add-to-list 'exec-path "d:/usr/bin") For the client. (setf sql-mysql-options (quote ("-n" "-B" "-f" "-i" "-q" "-t"))) Options for the client. I'm my opinion the best color coded SQL editor ;) jjs -- [SIBS] - Sociedade Interbancária de Serviç

Question

2002-05-03 Thread Shows Lycos
Description: error = Column 'nombre' is used with UNIQUE or INDEX but is not defined as NOT NULL My server= mysql Ver 9.38 Distrib 3.22.30, for pc-linux-gnu (i686) Question= Can you help me ? Thanks. Juan - Before posting,

Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread Victoria Reznichenko
Milan, Friday, May 03, 2002, 2:15:49 PM, you wrote: MR> I have a problem with updating MySQL database on linux with mysql MR> 3.23.24-beta-log. I have prepared a database on Win98 SE platform MR> with 3.23.49a and when i moved to my linux server at school (RedHat MR> 7.0 CZ with MySQL 3.23.24-

Connecting to MySQL from an apache module using C API

2002-05-03 Thread Robert Vetter
Hello, I have problems with connecting to a mysql database. I use a global MYSQL handle in the module. The connection is created in module_child_init() function and closed in module_child_exit(). It seems, that the connection works only for the first request after apache has been restarted. A

Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread Gerald Clark
They must be owned by the user under which the mysqld runs, or change them to mode 766. Milan Reznicek wrote: >I have a problem with updating MySQL database on linux with mysql >3.23.24-beta-log. I have prepared a database on Win98 SE platform >with 3.23.49a and when i moved to my linux server

RE: dupe records

2002-05-03 Thread Steve Buehler
Thank you. This is exactly what I needed. Steve At 07:56 AM 5/3/2002, Jay Blanchard wrote: >[snip] > Here is probably an easy question to answer, but I can't figure > an EASY >way to do it. Right now, I use a temp table with a unique column to solve >it. I am hoping that there is a w

problem Pl, Solve it

2002-05-03 Thread piyush
Dear Sir, I am using MySql with Visual Basic I Could not add new record or edit old record through visualbasic in the table of mysql, if there in the table and in that separate field there is no longer value (string long in length) then the value i want to add or edit. thanks please reply me on

RE: dupe records

2002-05-03 Thread Jay Blanchard
[snip] Here is probably an easy question to answer, but I can't figure an EASY way to do it. Right now, I use a temp table with a unique column to solve it. I am hoping that there is a way in the SELECT statement. AnywayWhat I want to do is to select records from a table but if ther

Database Maintenance Philosophy ?

2002-05-03 Thread Jay Blanchard
Good Friday Morning to you all! Some of our MySQL databases are approaching the extrememly large size (10's of millions of records) and while we do regularly scheduled maintenance via CRON, and we do nightly differential back-ups couple with full back-ups on the weekends. Data is added at a fairl

RE: How to upgrade MySql?

2002-05-03 Thread Hong Tian
Thanks! -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 7:04 AM To: [EMAIL PROTECTED] Subject: Re: How to upgrade MySql? Hong, Thursday, May 02, 2002, 10:22:56 PM, you wrote: HT> We have a Web server with Apache 1.3.22+MySql 3.23.44+php 4.0.6

dupe records

2002-05-03 Thread Steve Buehler
Here is probably an easy question to answer, but I can't figure an EASY way to do it. Right now, I use a temp table with a unique column to solve it. I am hoping that there is a way in the SELECT statement. AnywayWhat I want to do is to select records from a table but if there i

Connecting to MySQL from an apache module using C API

2002-05-03 Thread Robert Vetter
Hello, I have problems with connecting to a mysql database. I use a global MYSQL handle in the module. The connection is created in module_child_init() function and closed in module_child_exit(). It seems, that the connection works only for the first request after apache has been restarted. A

Re: Migration from windows to linux

2002-05-03 Thread Arthur Fuller
I use a shareware tool called dbScripter (www.dkgas.com), which is very cheap to license. It lets you generate scripts that will create table structures, indexes and table-loads. It comes with syntax profiles for SQL Server, Oracle and Access, and you can also create your own profiles. I created o

RE: data compare and duplicate entries..

2002-05-03 Thread Andrew Hazen
Good points, However, while I agree that you need at least one unique key, putting multiple unique keys in a table can also have serious performance ramifications as the system will slow down considerably if constantly rebuilding indexes. It probably depends upon how many fields have to be check

Re: Strategies for maintaining tables calculated from other tables?

2002-05-03 Thread Rob
I'm also curious what solutions others have arrived at for this. I currently have a similar situation to what you are describing: I've got a large database of timestamped log entries, and need to generate periodic summaries over them, but don't want to actually mine the entire huge database every

Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread sucker
- Original Message - From: "Milan Reznicek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 1:15 PM Subject: ERROR 1036: Table 'xxx' is read-only > I have a problem with updating MySQL database on linux with mysql > 3.23.24-beta-log. I have prepared a database on

ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread Milan Reznicek
I have a problem with updating MySQL database on linux with mysql 3.23.24-beta-log. I have prepared a database on Win98 SE platform with 3.23.49a and when i moved to my linux server at school (RedHat 7.0 CZ with MySQL 3.23.24-beta-log) I can't update or insert to table. I have changed rights t

mysql@lists.mysql.com

2002-05-03 Thread Dennis Peyerl
Thank you Henning but I'd like to go deeper into detail. What you've said is OK, but then I will have to create a real database-user for each user. I'd like to know how safe this is, cause I am unsure what possibilities this gives to each of the users. On the other hand, if I would create one

Re: Help! with mod_auth from apache integrating with mysql

2002-05-03 Thread Egor Egorov
Info_Best-IT, Thursday, May 02, 2002, 7:07:57 PM, you wrote: II> I have a databse on mysql server that authenticates users... However mod_auth did II> not have access to the database containing the user info. How can I set up my II> database with adequate permissions to allow mod_auth to acce

Re: Problem with FullTextSearch and PHP

2002-05-03 Thread Victoria Reznichenko
root, Thursday, May 02, 2002, 4:42:26 PM, you wrote: r> If i use full text search with Boolean mode i got the following error r> mysql> select * from articles where match (title,body) against('+Your -Trail' r> in boolean mode); r> ERROR 1064: You have an error in your SQL syntax near 'boolean mo

Re: Should i repair?

2002-05-03 Thread Egor Egorov
Edilson, Friday, May 3, 2002, 3:17:11 AM, you wrote: EVdMJ> I have a table that has now about 10 records (about 100bytes each one). EVdMJ> My queries were too slow and some time a lost connection. But now i can't do EVdMJ> anything with this table :( Show us the structure of the ta

Re: How to upgrade MySql?

2002-05-03 Thread Egor Egorov
Hong, Thursday, May 02, 2002, 10:22:56 PM, you wrote: HT> We have a Web server with Apache 1.3.22+MySql 3.23.44+php 4.0.6 HT> on Solaris 8. Now we want to upgrade MySql to latest version. HT> Should I re-compile both Apache, MySql, and PHP or just re-compile HT> MySql? The question is how to up

Re: MySQL Problem

2002-05-03 Thread Victoria Reznichenko
Jagadeesh, Friday, May 03, 2002, 8:06:12 AM, you wrote: JS> We want to use MYSQl as a back end for one of our projects. JS> We download following 4 zip to install MySQL. JS> mysql-4.0.0a-alpha-win-src.zip JS> mysql-4.0.0a-alpha-win.zip JS> mysql-4.0.1a-alpha-win-src.zip JS> mysql-4.0.1a-alpha-wi

RE: mySQL under cygwin : mysql_install_db does not create host.frm

2002-05-03 Thread Olivier Delrieu
sorry, no effect, the deamon could not be started anyway as there is no mysql database ... moreover, mysql_install_db lauch : /usr/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/usr --datadir=/var/mysql/data --skip-innodb --skip-gemini --skip-bdb and the sql statement include onl

RE: ensuring that I'm getting the correct "last insert ID"

2002-05-03 Thread sean . odonnell
Thanks jeff, thats a question thats been bugging me for a while. -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 10:24 To: Sean O'Donnell; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ensuring that I'm getting the correct "last insert ID" Just ma

Re: mySQL under cygwin : mysql_install_db does not create host.frm

2002-05-03 Thread Gelu
Hi, I think you must run the db_install script. Good luck, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: TP R Murthy <[

RE: LOAD DATA LOCAL error

2002-05-03 Thread Roger Baklund
* Neil Bobstone > I Have compile Mysql 3.23.49 with : --enable-local-infile > > > > But when I want to use LOAD DATA LOCAL its says : The used command is > not allowed with this MySQL version There was some bugs related to --enable-local-infile in 3.23.49: http://www.mysql.com/doc/N/e/News-3

Re: mySQL under cygwin : mysql_install_db does not create host.frm

2002-05-03 Thread TP R Murthy
hi, where are you running the server from? you might wanna try running from the base dir ./bin/safe_mysqld & i used to have the same problem. on a linux machine though. regards, On Fri, 3 May 2002, Olivier Delrieu wrote: > > Dear all, > > I've installed Cygwin and CAMP and I'm now lookin

mySQL under cygwin : mysql_install_db does not create host.frm

2002-05-03 Thread Olivier Delrieu
Dear all, I've installed Cygwin and CAMP and I'm now looking for guidelines to build/install mysql under cygwin and XPpro. Sorry for that question but I tried during severals days with no luck. I'm using the scripts provided by Gerrit P. Haase in http://sources.redhat.com/ml/cygwin/2001-12/msg

Re: memcpy segfaults from store_record_in_cache under load on p4, 3.23.41 and .49

2002-05-03 Thread Heikki Tuuri
Jay, please send me the error log, the queries, and the table definitions. What is your my.cnf like? Are your sure memory consumption does not approach 2 GB? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com fo

mysql@lists.mysql.com

2002-05-03 Thread Henning Olsen
If the users dont have access via ftp to your htm-doc's but only see the result in browser, you have no problems in having the MySQL-password in the php-section of the login-doc. The users will never see the php-part of the doc, because it's a server-side part and will only produce the html-co

LOAD DATA LOCAL error

2002-05-03 Thread Neil Bobstone
Hi, I Have compile Mysql 3.23.49 with : --enable-local-infile But when I want to use LOAD DATA LOCAL its says : The used command is not allowed with this MySQL version Could anyone help me ? Best regards, Julien Calvet

Re: sub-selects

2002-05-03 Thread sucker
"Alex" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:... > i have to use a statement like: > SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1 > AND CODICE<>ALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE > (CODICE_ARCHIVIO=342)) > > but mysql doesn't support inner select. > > What

LOAD DATA error

2002-05-03 Thread Julien Calvet
Hi, I Have compile Mysql 3.23.49 with : --enable-local-infile But when I want to use LOAD DATA LOCAL its says : The used command is not allowed with this MySQL version Could anyone help me ? Best regards, Julien Calvet

mysql@lists.mysql.com

2002-05-03 Thread Dennis Peyerl
Hello I want to realize the following thing: A user shall be able to connect through a php-website into mysql. I have a form with to input types (standard html). The two input types are text and password. I don't know how to use that, to log a user in. Do I have to create a special table for

Re: inserting into the lowest possible id

2002-05-03 Thread Gelu
Hi, Nice tricky, but... SET @x:=0; SELECT @x:=t1.id+1 FROM mytable t1 LEFT JOIN mytable t2 ON t1.id+1 = t2.id WHERE t2.id IS NULL LIMIT 1; INSERT INTO mytable SET id=@x,data0='x',data1=''; Regards, Gelu _ G.NET SOFTWARE COMPANY

Problems with MySQL on FreeBSD4.5

2002-05-03 Thread webmaster
(Sorry if I am reposting this now, guys...ehe) I'm having trouble with a MySQL installation on a FreeBSD4.5 system (MYSQL version 3.23.49). >From time to time top shows that it runs >98% of CPU time, and of course the site's >response gets sluggish... Sometimes queries even times out or MySQL

ROWID

2002-05-03 Thread Alain ROY
Hello, Is there, in MySQL 4.0 database tables, a pseudo column ROWID (containing a unique id for each row of the tables), like in Oracle or Informix databases ? If not, will this feature be in MySQL 4.1 ? Regards A. ROY -

Re: MySQL Problem

2002-05-03 Thread Dicky Wahyu Purnomo
On 3 May 2002 05:06:12 - "Jagadeesh Suryadevara" <[EMAIL PROTECTED]> wrote: > When i check in the folder where it is loaded MySQL there are some > applications > with names MySQLManager,WinMysqladmin in bin directory. > When click on these applications it showing some screens but we > are