problem in cgi-perl using queries

Hello I have a database abc with one table xyz The html page is to sign up a new user and calls the following signup.cgi script. The new data is not getting inserted in the table when I execute it from the ip address - the page getting called by the form. BUT I can INSERT data in table by

Re: How to control the number of mysqld processes

On Mon, Mar 18, 2002 at 06:20:36PM +1030, Anatoly Osiko wrote: I have checked all the configurable parameters, but still is wondering what controls the number of processes started on the mysql startup. I am especially interested in bin/mysqld Ver 3.23.48-max for pc-linux-gnu on i686

Re: RAID

On Wed, Mar 13, 2002 at 11:00:35AM +0500, Rizwan Majeed wrote: is there a Raid Mode in MySQL.. I found a RAID_TYPE switch but dont know much about it. Here's what I recently wrote about RAID tables. Try to ignore the funny markup. :-) ---snip--- PRAID tables are just like MyISAM tables

Re: Problem with ordering select

Michal, /dev/hda8 256667256667 0 100% / looks like your root partition is full. 'show variables' tells you where Mysql is putting the temp table for your order by query. i believe it is sitting under your root partition. -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell

RE: Where is MySQL-DBI-perl-bin.rpm?

AFAIK not all of the perl modules are available as RPMs, you may either have to create the RPM on your own, or have to install that module the normal way, and force the installation of the dependent RPM using '--nodeps'. the latest distributions built by SuSE contain some of the perl modules

Sorting Data

Hello, To get German sorting order, you should start mysqld with --default-character-set=latin_de. This will give you the following characteristics. To get Tamil sorting order , i have started the mysqld with --default-character-set=latin1.But it is displaying the sorting order in a

synopsis of the problem (one line)

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:System Administrator Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class:

RE: RAID

-Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Here's what I recently wrote about RAID tables. Try to ignore the funny markup. :-) snip lots of usefull stuff. Does that answer your question a bit? Thanks Jeremy, I was a bit unsure as to RAID tables in

Row cannot be located for updating. Some values may have been changed since ...

Hello, This is my first day in this list and i don't know if this was asked before. Anyway i have this problem when i'm trying to delete a row a mySQL 3.23.38-nt table using a vb interface and connecting through myODBC 3.51.02 i keep getting this message : Row cannot be located for updating.

Re: FW: IS THIS BETTER?

I may have misunderstood, but I though the whole idea of having a spam filter rather than a subscription system was to make posting for newbies easier, not harder. At 20:39 2002-03-17, Dan Vande More wrote: Is there a way to spam control caps? filter fodder: sql,query -- Marjolein Katsma

Re: Conflicting results using PHP/Mysql

Doug, Sorry for leaving this so long but I've been tied up in business meetings. It may be that my query is restricting the data retrieval but I cannot see how. If I look at the data I am playing with, I have 3 tables and I want to show transactions from a certain course. I also want to show

RE: Invalid Argument ??? Not sure how to debug this

Try ... If ($result = ...) { ... ... } else echo(mysql_error()); I always do querying like this anyway (without the error echo in live stuff obviously) Tim Ward Internet Chess www.chessish.com http://www.chessish.com -- From: Daniel Negron/KBE

RE: NT service problem

I am using MySQL4.02 as a service on W2Kpro. You need to install the service before you can start it. mysqld-nt --install Then try the net start, possibly after a reboot. Rich -Original Message- From: Tommy Claasens / QDC KZN [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002

Mailing list manager

Hi, I have a database with a list of users who I would like to contact periodically. So I need a mailing list manager. Ideally I would like a client side application that enables you to send individual email messages based on a sql query (not all people will be interested in the message) I

Updating a column from a second table

Eldon, Monday, March 18, 2002, 3:00:30 AM, you wrote: EZ How can I update the values of a column in one table from the values in a EZ second table where there is are matching columns in the two tables using EZ mysql. Table1 EZ has columns DonorID and DonorPhone. Table2 has columns PersonID and

RE: mysql.sock

Art, Monday, March 18, 2002, 3:50:19 AM, you wrote: AF I get AF drwxr-xr-x 4 mysqldaemon 540 Mar 17 17:44 mysql MySQL datadir should belong to user 'mysql'. chown -R mysql.mysql /var/lib/mysql AF Art AF From: Dan Vande More [mailto:[EMAIL PROTECTED]] AF That's because you

MySQLDump

Boaz, Sunday, March 17, 2002, 4:24:33 PM, you wrote: BY 1. I was wondering if there is any way to backup MySQL information other BY than MySQLDump? There are mysqlhotcopy, mysqldump utilities, BACKUP TABLE and SELECT .. INTO OUTFILE statements. You can read about database backups in the manual:

problem running the mysql server!

Aleksander, Sunday, March 17, 2002, 6:24:15 PM, you wrote: AG i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on AG an AG i686) and ran mysql_install_db script. then i tried to start the server: AG [root@localhost]# safe_mysqld enter AG [1] 1360 AG [root@localhost]#

Encrypting MySQL tables

Hello, I have a MySQL database full of confidential information. What is the best was to encrypt the data. SQL statements, SSL ? Basically, I want the client software to decrypt the data and if someone tries to view with this software all they see is mixed characters Please advise

AW: NT service problem

Thanks for your help :-) The point ist, that I can start 'mysqld-nt --standalone' without problems BUT STILL can't get the service run. I do have installed the service correctly (liek all the other service running my machine) but it always terminates with Could not start MySQL service on local

Re: NT service problem

Check the location of the configuration file (should be either c:\my.cnf ~ OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a sample: [client] #password=my_password port=3306 #socket=MYSQL # [mysqld] port=3306 #socket=MYSQL skip-locking #enable-locking set-variable =

Re: mysql++ patch for GCC 3

Vladimir Smelyansky writes: I tried the patch and it still failed. Sorry for long post, but hope it may help. Thank you. Vlad. Try adding : std::out_of_range ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] /

Encrypting MySQL tables

Neil, Monday, March 18, 2002, 2:24:34 PM, you wrote: NT I have a MySQL database full of confidential information. What is the best NT was to encrypt the data. SQL statements, SSL ? Basically, I want the NT client software to decrypt the data and if someone tries to view with this NT

Difference between Max

I would like to know, what difference between the version mysql and mysql-max. I don't found anything about. Regards Alexander Pr/Brazil A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.

Re: Difference between Max

Am Montag, 18. März 2002 13:58 schrieb Alexander Burbello: I would like to know, what difference between the version mysql and mysql-max. I don't found anything about. take a look on http://www.mysql.com/downloads/mysql-max-3.23.html Regards Georg

Re: Selecting entries in table A that are NOT in table B.

Hello Markus, There -has- to be an easy solution to this, but I just can't for the world figure it out. I have a table called members(id,membernum,firstname,lastname) and a table called paid(id,membernum,year,paid). How on earth do I select the members in table members that are -NOT- in

RE: NT service problem

I ran the .exe file and WHAMMO! It installed itself as a service. I just needed to edit the service to have it automatically start at boot -Original Message- From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 6:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]

Re: mysql/php on linux

There is a tool that will automate the installation process, if you like. It can be found at: http://www.apachetoolbox.com/ You tell it what you want and with what features. Then it proceeds to download the files, configure, make and install them. It works quite well in my experience. On Mon,

RE: mysql/php on linux

PHP http://www.php.net/manual/en/install.linux.php mySQL http://www.mysql.com/doc/L/i/Linux.html I never had any problems with mysql and PHP talking to each other on Linux, and I am very wet behind the ears with Linux. Maybe you can give us an error messages you are receiving, and that will

MySQL query parsing

Hello - I am novice in the list. My question is - are the MySQL query parsing source codes available? Vladimir Rykov P bI K O B B. B. MOCKBA Vladimir Rykov, PhD in Computational Linguistics, MOSCOW http://rykov.narod.ru/ Engl. http://www.blkbox.com/~gigawatt/rykov.html Tel

Finally found mysql-nt service error 1061 1067

Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I

Finally found mysqld-nt service error 1061 1067

Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I

ms access / new form

Hey .. I m using mysql 3.23.49 and the latest myodbc .. connection works fine and reading data with access (winxp).. but, when I want to create a new data, I says me, that he is not able to jump to the data .. Vb of the button Dim stDocName As String stDocName = frm_new_personnel

Re: NT service problem

Hi, I am getting a problem with my select query with the limit statement like for eg, select table1.field1,table1.field2 from table1 limit 5000,500; The query will take a lot of time to execute. The table in question in only 16000 records. Could anybody advise me on this issue! Rishi, Advance

RE: mysql.sock

I done the chown, now using MySQL Navigator, I get Access denied for user: afore@localhost (using passowrd: YES). I get the same for user mysql and root using both my password and root password. mysql is a group as shown in Yast2 login manager also. Permissions now shows drwxr-xr-x mysql

Minimum client.

In order to run perl scripts that use DBI ( from a cleint machine ) to query a MySQL server on the LAN Do I need to install MySQL on the client machine or do I just need DBI? Both machines are running Red Hat 7.2. Any help would be appreciated. Richard

MyLua for Windows exists?

Can anyone tell me if has used MyLua (MySQL + LUA) for Windows? Or if the binaries that appear in the following URL http://www.fastflow.it/mylua/ can be compiled for Windows? MyLua is the only thing that I have found to write stored procedure for MySQL but I'm using Windows 2000 sever. Any

select speed

Greetings, We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large table ( 200,000+ records, 120+ columns) and some simple queries on that table have pretty inconsistent performance. Due to licensing issues I can't give an actual example of the table, but here is an equivalent

Features (Sequences, views, triggers/rules)

I am currently migrating my DB and associated apps to MySQL from Postgres, and I am running into a couple of limitations that I couldn't figure out how to work around from the docs, mostly stemming from sequences, views, and triggers. I am currently using the stock RH7.1 MySQL 3.23.36, please

Minimum client.

Richard, Monday, March 18, 2002, 8:03:36 PM, you wrote: RR In order to run perl scripts that use DBI ( from a cleint machine ) to RR query a MySQL server on the LAN Do I need to install MySQL on the client RR machine or do I just need DBI? Both machines are running Red Hat 7.2. You should to

Selecting entries in table A that are NOT in table B.

Markus, Monday, March 18, 2002, 1:54:46 PM, you wrote: ML There -has- to be an easy solution to this, but I just can't for ML the world figure it out. ML I have a table called members(id,membernum,firstname,lastname) ML and a table called paid(id,membernum,year,paid). ML How on earth do I

Sorting Data

Uma, Monday, March 18, 2002, 11:34:07 AM, you wrote: USTTo get German sorting order, you should start mysqld with UST--default-character-set=latin_de. This will give you the following USTcharacteristics. UST To get Tamil sorting order , i have started the mysqld with UST

delete old mysql users

Hello, I have a system running MySQL with old user accounts I wish to remove. I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? With Thanks, Steve.

Foreign languages

I've looked through the documentation and if this question is answered there, please point me to the relevant section because I've obviously missed it. What foreign languages does MySQL support definitively. As in can do all kinds of searches in, etc? I'm curious about Chinese and Japanese (and

Re: problem in cgi-perl using queries

Hello I have a database abc with one table xyz The html page is to sign up a new user and calls the following signup.cgi script. The new data is not getting inserted in the table when I execute it from the ip address - the page getting called by the form. BUT I can INSERT data in table

copy osx db to win2k

hello! i've been developing a MySQL database in mac osX - i would like to transfer it to work onto a win2k box running apache and mysql. what files from X do i need to copy over? is this a fairly simple process or am i heading for a world of pain?! cheers, jake p.s. if this is possible, does

Re: select speed

At 10:39 AM 3/18/2002, you wrote: Greetings, We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large table ( 200,000+ records, 120+ columns) and some simple queries on that table have pretty inconsistent performance. Due to licensing issues I can't give an actual example of the

insert...select across multiple databases

This one has been troubling me for some time now. For my project the most ideal and quickest solution to archive data is to do an insert...select followed by a delete on the original table. The problem is, I'd like my archive tables to exist in another database (makes it a lot easier on the

RE: delete old mysql users

We asked on the MySQL training last year and were told that this is a manual job... Just have to delete entree for each table. Unless some one else knows different? Simon -Original Message- From: Steve Wright [mailto:[EMAIL PROTECTED]] Sent: 18 March 2002 16:52 To: [EMAIL PROTECTED]

Re: bug: segfaults with mysql_read_default_group!

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Christian Hammers writes: Hello There is a problem with the myslq_read_default_group function! It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very latest Debian unstable (I'm the mysql maintainer of

Cannot start Mysql on Windowx XP

I just installed MySQL-3.23/mysql-3.23.49-win.zip from www.mysql.com Then opened it. But I still could not run mysql..it looks like it could not find the server. Where is the remote server? Anyway, see below how I was struggling.. C:\mysqlcd\mysql\bin C:\mysql\binmysqladmin ping

AIX binary distribution bug

Description: mysql binaries from AIX binary distribution will not run. 1 % cd /tmp/mysql/bin 2 % ./mysql Could not load program ./mysql: Dependent module /usr/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive Rebuild libz with shr.o, put in

MySQL as reporting database between corporate db and users is it OK?

Hello, I would like to use MySQL as a fast reporting database for a dotnet EIS. The source of the data is mainly 4 different huge and slow corporate db; Oracle 7, Oracle 8, Oracle 9 and MS SQL I need to perform daily load of tables at night. The load can be either Append or Replace. I have the

Recommended Book

Which of the many books I see online at barnesandnoble.com do you all think is the indispensible MySQL guide? I have used SQL on Sybase for several years, but want to start fresh and clean with MySQL. Would it better to wait for a new book that covers new generation MySQL? -- Jim Kaufman

Re: Recommended Book

Am Montag, 18. März 2002 19:23 schrieb Jim Kaufman: Which of the many books I see online at barnesandnoble.com do you all think is the indispensible MySQL guide? I have used SQL on Sybase for several years, but want to start fresh and clean with MySQL. One of the best is the book from Paul

Re: select speed

On Mon, Mar 18, 2002 at 11:39:09AM -0500, Gabriel Ricard wrote: Greetings, We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large table ( 200,000+ records, 120+ columns) and some simple queries on that table have pretty inconsistent performance. Due to licensing issues I

HELP! Linux mysql install

Hi, I wanted to know what the error possibly could be. I am using RedHat 6.0 Kernel 2.2.20 on i686 and installed mysql 3.23.47-sgi-irix6.5. I m running sh ./bin/safe_mysqld from the root directory and am getting the error : cannot execute binary file. Here is the error: ./bin/safe_mysqld:

RE: Script for Data base backup and recovery : Very essential

I use a perl method for a full week's worth of backups, this could be migrated to have a weekly, monthly, yearly snapshot as well. #!/usr/bin/perl my $szToday = `date +%a`; chop ($szToday); $dbDumpName = '/var/backup/dbDump.mysql'; $backupFile = '/var/backup/siteFiles'; $siteDir=

BerkeleyDB or InnoDB?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've read the docs on mysql.com about the BDB and InnoDB table formats, as well as their pro's con's and I was wondering if anyone could give their opinion on the matter. I don't need row-level locking or other fancy features other than

Cannot execute binary file error

Hi, I wanted to know what the error poosibly could be. I am using RedHat 6.0 Kernel 2.2.20 on i686 and installed mysql 3.23.47-sgi-irix6.5. I m running sh ./bin/safe_mysqld from the root directory and am getting the error : cannot execute binary file. Here is the error: ./bin/safe_mysqld:

queries and functions

Hi to all, does mysql have a type of libraries where you can keep queries or functions. For example if I need to run a query everyday, but I don't want to type the same query everytime I need it. How can I store that query in one place and call it every time I need it? Is this possible??

Re: select speed

key_buffer is 384M, table1.MYI is 17.5MB. Jeremy Zawodny wrote: On Mon, Mar 18, 2002 at 11:39:09AM -0500, Gabriel Ricard wrote: Greetings, We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large table ( 200,000+ records, 120+ columns) and some simple queries on that table have

RE: queries and functions

I don't think MySQL has a mechanism for doing any sort of stored procedure, but, I just saw this earlier today and went adn looked at it. It may help you, but I know nothing about it and con offer no further advice. Ken Hylton Programmer Analyst IV LEC Systems Programming Billing Concepts,

Re: MySQL as reporting database between corporate db and users is it OK?

From: Philippe Cand [EMAIL PROTECTED] - Is there a way to script MySQL to execute a list of commands then execute the load query? Yep, Perl makes this whole list of tasks simple. Or possible, depending on your stance. If you don't write any Perl, then I'd say to use a batch script and write

RE: BerkeleyDB or InnoDB?

In my experience InnoDB tables are superior to BDB, but during my comparisons I was working with a lot more data -- millions of rows -- than you will be; BDB's problems seemed to center around the size of the tables. So, BDB could work well for you. But, I can recommend InnoDB as a good way to

Re: MYSQL,Linux large threads number

On Fri, 15 Mar 2002, Peter Zaitsev wrote: Hello mysql, Some time ago I wrote about slow down of mysql with large number of threads, which is quite common in Linux-Apache-Mysql-PHP enviroment. The test was simulating the worst case of concurrency - all the threads are modified

kudos to the mysql team

I just wanted to say that MySQL absolutely rocks! We are using Mysql with a very large database and it's working beautfully. Needless to say we will be buying licenses to further support mysql. Here are some rough stats on what we were doing: Inserts: 13,000,000 per day Updates: 12,000,000

(newbie) how can I regenerate the data/mysql tables?

I'm running 3.23.43 on Windows 98. I've done the default binary installation, which created the mysql and test databases in c:\mysql\data, and I've added the menagerie and other sample databases to it. I would like to leave that structure in place but create another database somewhere else. I

Re: Conflicting results using PHP/Mysql

Your base table is transactions. I assume you want to do a LEFT JOIN. I think you might see an improvement if transactions were consistently named on the left side of the equalities as: $Itemlistquery.= transactions.Pdownload ; $Itemlistquery.= from bib_extract,scanrates,transactions where ;

Re: MySQL | Company | Contact Us

Friends, I am trying to install MySQL on a Powerbook G$ running Mac OS 10.1.3 and am having problems. I've followed your instructions and installed Fink but when I go to step 2 (Install packages required for MySQL - (you can copy this line from this document and paste in terminal to avoid

Default value support function

Can I have a default value call a function in a MYSQL table for example convert(float,getdate()) Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.com

Access denied on use mysql;

The problem begins when I type in use mysql; Please look at the very left edge with three asterisks..*** where I marked. ACCESS denied Hope it will be fixed with your help so I can mind my own chores. == C:\mysql\binnet start mysql The MySql service

Re: Default value support function

On Mon, Mar 18, 2002 at 05:32:07PM -0500, Kathy Reyes wrote: Can I have a default value call a function in a MYSQL table for example convert(float,getdate()) Nope. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell:

MySQL syntax different from Microsoft SQL syntax...Please HELP

I've looked throught the MySQL documentation and I can't seem to find the answer to this problem. I have a query that will work on a Microsoft SQL server, but I've tried moving it to a MySQL server and it won't work. I tried modifying it and I can't get it to work either. The scenario and

Re: MySQL | Company | Contact Us

I'd highly recommend just downloading the binary distribution from mysql.com. Works great for me. Jim Weber wrote: Friends, I am trying to install MySQL on a Powerbook G$ running Mac OS 10.1.3 and am having problems. I've followed your instructions and installed Fink but when I go to

Re: (newbie) how can I regenerate the data/mysql tables?

The directory space in which mysqld places the data is capable of containing multiple databases (related groups of tables) and tables (related groupings of data) up to the physical limits of your computer system. The mysql database contains the tables that hold information concerning user

differences

Everyone, What's the differences with MySQLD and MySQL-max? R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: select speed

Gabriel, I have a sneaky suspicion your primary key is a CHAR or VARCHAR, right? If so, your select statement is using an integer which means it has to convert it for each record. If you put quotes around the 30460203 it will run faster as in: select IndexField1,Field1,Field2 from

Re: differences

On Monday 18 March 2002 4:22 pm, [EMAIL PROTECTED] wrote: Everyone, What's the differences with MySQLD and MySQL-max? MySQL-max supports more table types. - Before posting, please check: http://www.mysql.com/manual.php

Re: MySQL syntax different from Microsoft SQL syntax...Please HELP

At 18:15 -0500 3/18/02, John Burns wrote: I've looked throught the MySQL documentation and I can't seem to find the answer to this problem. I have a query that will work on a Microsoft SQL server, but I've tried moving it to a MySQL server and it won't work. I tried modifying it and I can't get

Re: (newbie) how can I regenerate the data/mysql tables?

Doug Thompson wrote: (snip) Perhaps you have misunderstood how mysql organizes everything and you are wanting to do something that you don't need to do. I haven't misunderstood anything, I think. I know how to create additional databases with CREATE DATABASE. My problem is that I want to

SubSelect Problem

SELECT textid, title, description from structure where textid in (select subtopicid from subtopic where topicid='Top'); this gives an error at the opening bracket.. I am assuming that mysql realises that structure.textid=subtopic.subtopicid ...any ideas on getting this working? thanks for

RE: SubSelect Problem

Perhaps I am missing something right in front of me, or I have not been in the loop, but it is my understanding that MySQL does not support sub-selects, yet. http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html BTW, you may receive lots of replies of this very nature, because it is something

RE: SubSelect Problem

Alex, I believe you'll find that MySQL does not support subselects. This is why you're getting the error message. I suggest you consult the SELECT syntax manual page (http://www.mysql.com/doc/S/E/SELECT.html) to see what you can do with selects. You could try to convert this into a join,

RE: (newbie) how can I regenerate the data/mysql tables?

Use symbolic links :) -Original Message- From: Richard Trahan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 March 2002 3:13 AM To: [EMAIL PROTECTED] Subject: Re: (newbie) how can I regenerate the data/mysql tables? Doug Thompson wrote: (snip) Perhaps you have misunderstood how

RE: SubSelect Problem

Hi Alex, MySQL doesn't support sub-selects yet. Gurhan -Original Message- From: Alex Speed [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 7:13 PM To: [EMAIL PROTECTED] Subject: SubSelect Problem SELECT textid, title, description from structure where textid in (select

Re: (newbie) how can I regenerate the data/mysql tables?

Stephano Mariani wrote: Use symbolic links :) Actually, that's a good idea; it does let me put my table data somewhere else, but it's my fault that I didn't reveal my secret motivation in my original post. I have a general backup scheme which backs up everything in a set of directories

no tee in mysqlc

Why is there no tee in mysqlc? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To

How to use edit in mysqlc?

I like mysqlc because of the command line editing capability, but I can't find any documentation on this utility. Specifically, I haven't been able to figure out how edit works. Any help, please. - Before posting, please check:

Re: SubSelect Problem

Ok, no support for it (d'oh), so, how do I go about breaking it down into a join or something like that? - Original Message - From: Alex Speed [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 12:13 AM Subject: SubSelect Problem SELECT textid, title, description

Re: no tee in mysqlc

At 19:43 -0800 3/18/02, Richard Trahan wrote: Why is there no tee in mysqlc? Because, unfortunately, it dates back to MySQL 3.22.7, even in MySQL 4.x distributions. It hasn't been rebuilt since then. - Before posting, please

mysqladmin - access denied

I'm having trouble with Apache dying after log rotation and have tracked it down to the mssqladmin. When I try the: /usr/sbin/logrotate -f /etc/logrotate.conf I get the following error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user:

RE: mysql/php on linux

Hi all, I too new to php and mysql, trying to get things works. I installed Redhat 7.2, Apache, mysql and php. I copied a sample php script from the internet and save it as phptest.php in my cgi-bin. When calling it from my browser, I got Format error. Did I not do it right? Should I put it

Upgrading mysql from 3.22 to 3.23

Greetings, I wish to upgrade mysql server from 3.22 to 3.23 running on Linux and had a few basic questions which I am hoping someone can help me with. My plan is simply to download and unpack the binary distribution, stop mysqld, move the symlink to point to the new distribution, and restart.

RE: Finally found mysql-nt service error 1061 1067

Alex: I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a very well-designed, well-behaved service. I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. If this were a 'general mysql-nt problem', I would have had to set a login account in the SCM

Re: Sorting Data

On Mon, 18 Mar 2002, Victoria Reznichenko wrote: VRUma, VRMonday, March 18, 2002, 11:34:07 AM, you wrote: VR VRUSTTo get German sorting order, you should start mysqld with VRUST--default-character-set=latin_de. This will give you the following VRUSTcharacteristics. VR VRUST To get

Re: Upgrading mysql from 3.22 to 3.23

Hi, On Tue, 2002-03-19 at 11:41, Campbell McLeay wrote: I wish to upgrade mysql server from 3.22 to 3.23 running on Linux and had a few basic questions which I am hoping someone can help me with. My plan is simply to download and unpack the binary distribution, stop mysqld, move the symlink

Re: How to use edit in mysqlc?

At 19:45 -0800 3/18/02, Richard Trahan wrote: I like mysqlc because of the command line editing capability, but I can't find any documentation on this utility. Specifically, I haven't been able to figure out how edit works. Good question. I suspect that it's a mistake for it to be listed in the

Mysql dump

Hello, I am having all mysql database contents in one txt file.how i will dump all those contents to mysql database tablespls tell me how to do it -Uma - Before posting, please check:

Re: Mailing list manager

Newbert, Joe queried Hi, I have a database with a list of users who I would like to contact periodically. So I need a mailing list manager. Ideally I would like a client side application that enables you to send individual email messages based on a sql query (not all people will be

  1   2   >