RE: F/U @ Re: * reiteration re: (re)starting MySQL

2001-11-27 Thread Roger C. Foster
By adding "skip-innodb" (minus the quotes) anywhere in the section "[mysqld]" should work. For more info look in the "MySQL Technical Reference" section "2.1.2.2 Preparing the Windows MySQL Environment". Roger -Original Message- From: gx-inc [mailto:[EMAIL PROTECTED]] Sent: Monday, N

RE: VC++ _ MFC Question

2001-11-27 Thread jwubbel
>AfxMessageBox((CString)er.error); It looks like you are trying to ask the compiler to cast er.error as a CString. The compiler complains because the exception you are catching using BadQuery (i.e., er.error) is probably implemented with STL. Usually you would see the error dumped out as follo

Re: MySQL hang after select count()

2001-11-27 Thread Abu
its took a long time. --process list-- +-+-+---+-+-+--+---+- -+ | Id | User| Host | db | Command | Time | State |

MySQL hang after select count()

2001-11-27 Thread Abu
I dont understand mysql eat system 13 load average after that mysql hang while runing query via web using DBD-Mysql and DBI. Everyone help me for your experience how to tuning mysql for this solution. Thanks -Abu- kernel-2.4.9-6 on rh 7.1 mysql-3.23.36-1 mysql-devel-3.23.36-1 mysql-server-3.23.

query syntax question

2001-11-27 Thread Patrick Bolduan
i want to do this: SELECT matrix.matrixId FROM matrix, language WHERE (matrix.fromLanguageId = language.languageId AND language.isoLanguageId = 25) AND (matrix.toLanguageId = language.languageId AND language.isoLanguageId = 27); but the grouping doesn't seem to be working. it this a MySQL limitat

VC++ - MFC Question

2001-11-27 Thread Mike Gleason Jr Couturier
Hello all ! I'm creating an MFC program with the mySQL API. Everything is working fine but when exceptions occurs (ie when connecting, changing databases...), I can't display the er.error message to the user... How can I convert the error message to a char * or a CString ?!?! [...]

Need to get arbitrary MySQL info into a pre-compiled C CGI.

2001-11-27 Thread jeff McLean
Hello: I am creating a CGI program in C that uses the mysqlclient library. I do not want to give away the source code for it, but want to have the binaries downloadable off my site on the net. It must have personolised info to login to the mysql server, though. I thought that I could have a text

mysql instalation

2001-11-27 Thread Landy Roman
mysql fails to start i get msg starting mysqld with database /var/lib/mysql and then it terminates please advice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Newbie Question

2001-11-27 Thread Phudgee
Hi, I have been searching for some answeres to my problem for around 2 months now I am a longtime user of MySQL but by no means am I very proficient at it. I have had no problems up to this point with it, so Ive not really needed to do much with it My webiste is PHP-Nuke 5 based. If you

Re: How record session in file with batch file?

2001-11-27 Thread Uriel Wittenberg
>Well, I actually use copy&paste. ;-) But I find I can't paste into a mySQL session (in Windows Me). I'm referring to the DOS window's paste function. Is there another way to paste from the Windows clipboard into a mySQL session? ---

Re: How record session in file with batch file?

2001-11-27 Thread Benjamin Pflugmann
Hi. On Wed, Nov 28, 2001 at 09:42:08AM +0800, [EMAIL PROTECTED] wrote: > How do you get output like below without retyping the command ("SELECT > count(*) FROM config a INNER JOIN config b USING (gid) WHERE > a.gid=10856")? Well, I actually use copy&paste. ;-) > I'm using Windows Me. > > The

Re: Too many connections (again) (could Mark answer this please)

2001-11-27 Thread yilmaz
thanks a lot Mark, now i figured it out, i should have used finally {} statements around close() functions. Best regards :) - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: ""yilmaz"" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 10:07 PM Su

Replication Problem

2001-11-27 Thread Arne Goetje
Hi, I'm using version 3.23.43 on both, master and slave. The slave exits replication with the following message: -- 011128 9:43:01 Slave: connected to master '', replication started in log '-bin.008' at position 53702 011128 9:43:01 Slave: did not get the expec

Re: SOURCE command somewhere in manual?

2001-11-27 Thread Uriel Wittenberg
> > Is there really a SOURCE command? > > An explanation why you did not simply try it, would be nice. Maybe > that would have helped to get an early answer. > > > Where is it in the official manual? > > This is part of the command line client, the belonging manual section > is http://www.mysql.co

How record session in file with batch file?

2001-11-27 Thread Uriel Wittenberg
How do you get output like below without retyping the command ("SELECT count(*) FROM config a INNER JOIN config b USING (gid) WHERE a.gid=10856")? I'm using Windows Me. The following type of command does not work: C:\mysql\bin>mysql --tee=\mysqluw\out.txt -T stud < \mysqluw\mysql.txt -

Re: Joining table with itself

2001-11-27 Thread Uriel Wittenberg
Sorry I didn't provide code, I didn't suspect what I've now discovered: the problem occurs only with TEMPORARY tables. I'm using 3.23.42. The following produces the error message I reported (assumes pre-existence of table 'scores'): create temporary table TT

How to install mysqlgui?

2001-11-27 Thread Peter Smith
Hello, I would like to know how to install mysqlgui and also fltk, flek, mysql++ I have been to mysqlgui's install.txt, but not enough information on installation, it only gives info on what you need to have to make mysqlgui work. Could you get back to me asap, as I need to do this for my wor

Re: display size of integers

2001-11-27 Thread Benjamin Pflugmann
Hi. On Mon, Nov 26, 2001 at 02:45:26PM -0500, [EMAIL PROTECTED] wrote: > I have a rhetorical question. > > I'm learning as much as I can about MySQL. There is one little detail > that I don't *have* to know the answer to, but I'm curious about. Don't > waste your time replying if you're busy

Re: Error on table

2001-11-27 Thread Benjamin Pflugmann
Hi. On Mon, Nov 26, 2001 at 07:55:01PM +0100, [EMAIL PROTECTED] wrote: > Dear Sir, Madam > > I have a problem whit a tabel on a Mysql datbase V3.23 running on a Cobalt > Raq4I. > > Some body whas create a tabel named kortbon . Now we have a SQL error on > line1. I cant drop the tabel from

Re: mysqldump question

2001-11-27 Thread Benjamin Pflugmann
Hi. On Mon, Nov 26, 2001 at 05:39:57PM +0300, [EMAIL PROTECTED] wrote: [...] > diff database_dump/Mtable.txt `mysqldump > --databases MYdatabase --tables MYtable` > ... > and make a conclusions depending of diff output. > > But according to well known SQL standarts the order of stored records i

Re: SQL Problem

2001-11-27 Thread Benjamin Pflugmann
Hi. This is dicussed here: http://www.mysql.com/doc/G/r/Group_by_functions.html (after the function list) http://www.mysql.com/doc/E/x/Examples.html (see the subsections) Bye, Benjamin. On Sat, Nov 24, 2001 at 11:01:26PM +0530, [EMAIL PROTECTED] wrote: > Hello Everyone, > > I wants

Record Locking?

2001-11-27 Thread randy
Hi.. I'm new to this list, and I am sort of new to MySQL and PHP. I was wondering, if you create an html-form based interface to a database, lets say its a database of customers, how can you lock a record if one person has it open? Lets say PersonA opens up Joe Blow's record on the intranet, and

Re: Different tables and their purposes

2001-11-27 Thread Benjamin Pflugmann
Hi. How about RTFM? http://www.mysql.com/doc/T/a/Table_types.html Bye, Benjamin. On Thu, Nov 22, 2001 at 11:11:19PM -0500, [EMAIL PROTECTED] wrote: > Hey, I was reading over some of the stuff on this list, and I was just > wondering, where I could find information on the different type

Re: Can't make after ./configure

2001-11-27 Thread Gordan Bobic
On Tuesday 27 Nov 2001 23:33, you wrote: > gcc version 3.0.2 It would appear that you tried compiling using the GCC 3.0.2 compiler. Try downgrading to 2.95.3 (the last stable release) and try again. Regards. Gordan - Before

Re: MySQL v4 FTS speed

2001-11-27 Thread Gordan Bobic
On Tuesday 27 Nov 2001 23:28, Sergei Golubchik wrote: > > Another question - is there a way to acquire a list of words in the FTS > > index? Someting like > > > > SELECT Word, > > count(*) AS Frequency > > FROMFTSIndex > > GROUP BYWord > > ORDE

Re: Joining table with itself

2001-11-27 Thread Benjamin Pflugmann
Hi. On Sun, Nov 25, 2001 at 11:32:15PM +0800, [EMAIL PROTECTED] wrote: > I tried: > > select ... from T1 a inner join T1 b using(...); > > and it doesn't work. I get a message about "Can't reopen table: 'a' ". I cannot reproduce this: mysql> SELECT count(*) FROM config a INNER JOIN config b U

Can't make after ./configure

2001-11-27 Thread chang-pingh
>Description: After running CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static the "make" doesn't compile and generated the following message. Un

RE: Recursive select to produce hierarchical listing

2001-11-27 Thread Jonathan Hilgeman
Not sure if you're using PHP to manipulate MySQL or not, but if so, I had the same problem and found the answer from someone on PHPBuilder, and then I mirrored the answer on my site here: http://php.sitecreative.com/faq.php#3 Hope it helps. - Jonathan -Original Message- From: Benjamin

Re: MySQL v4 FTS speed

2001-11-27 Thread Sergei Golubchik
Hi! On Nov 27, Gordan Bobic wrote: > > I take it the "IN BOOLEAN MODE" part of the AGAINST() is going to be new to > 4.0.1. Yes. And as it's in the manual now, changes of the syntax are unlikely. > Incidentally, how are the WHERE clauses handled when MATCH/AGAINST is used > for FTS? Given th

Re: Table Locking...

2001-11-27 Thread Benjamin Pflugmann
Hi. Please stop cross-posting and use the appropriate forum. On Wed, Nov 21, 2001 at 03:27:23PM -0700, [EMAIL PROTECTED] wrote: > > (PHP-DB folks, ignore this top question - unless you want to answer) > > Which type of DB/Table provides table locking while a process is > altering data?

Re: parallel processing in mysql

2001-11-27 Thread Benjamin Pflugmann
Hi. On Wed, Nov 21, 2001 at 02:02:15PM -0800, [EMAIL PROTECTED] wrote: > Does anyone know whether mysql supports parallel processing? I searched the > documentation on mysql.com, but didn't find it mentioned MySQL will use the thread implementation of your operating system, i.e. usually it will

Re: Recursive select to produce hierarchical listing

2001-11-27 Thread Benjamin Pflugmann
Hi. Maybe I am missing something, but won't SELECT M1.*,M2.* FROM Menu AS M1 JOIN Menu AS M2 ON M1.ID = M2.ParentID WHEREID=0 ORDER BY M1.Index, M2.Index work? Bye, Benjamin. On Tue, Nov 20, 2001 at 06:04:11PM -0800, [EMAIL PROTECTED] wrote: > I am trying to displ

mysqldump problem/question

2001-11-27 Thread Weaver, Walt
Another newbie question: I'm trying to do a mysqldump of a fairly large, wide (two longblobs) table, and am running into memory problems. After running for some time the mysqldump process will die with an "Out of memory (needed 8164 bytes)" message. Is there a way to tell mysqldump to not cache

Re: MySQL v4 FTS speed

2001-11-27 Thread Mike Wexler
Sergei Golubchik wrote: > Hi! > > On Nov 27, Mike Wexler wrote: > Lets also assume that there are 1,000,000 records with the word "really" , 1,000,000 records with the word "nice" and 500,000 records with the word "toy". Lets say there are only 500 records with all three words.

Re: Fw: localhost problem

2001-11-27 Thread Benjamin Pflugmann
Hi. On Wed, Nov 21, 2001 at 03:58:46AM +0100, [EMAIL PROTECTED] wrote: > i fixed the first problem, i had personal web server installed but i > had turned it off now my next problem is this, > http://www.pafo.net/mysql2.gif Why didn't you simply quote the error message? It looks arrogant to

Re: MySQL v4 FTS speed

2001-11-27 Thread Sergei Golubchik
Hi! On Nov 27, Mike Wexler wrote: > >> > >>Lets also assume that there are 1,000,000 records with the word "really" > >>, 1,000,000 records with the word "nice" and 500,000 records with the > >>word "toy". Lets say there are only 500 records with all three words. ^^^

Re: MySQL 3.23.x, FreeBSD, & LinuxThreads

2001-11-27 Thread Ken Menzel
Hi Ben I have beem running with Linux Threads for several months now. The only problems I have are related to updating to a new version of MySQL. I am trying to refine this, because the Linux thread package and the mysql package can both change! I have just shut off Linux thread for the moment

Re: Auto-normalization, and mysql.host table

2001-11-27 Thread Benjamin Pflugmann
Hi. On Tue, Nov 20, 2001 at 04:59:38PM -0500, [EMAIL PROTECTED] wrote: [...] > I'd like to normalize these fields by having a separate 'filenames' > table with an integer key that's used in the 'transfers' table. But > since I don't know what all the files will be until I load the > table, I hav

RE: Beginner - Updating a Table from a File

2001-11-27 Thread john
Raju, I want to be able to do an update from a text file I have placed in the /tmp dir. I have searched the "Manual" and it does not state how to do this. I have three book on this subject and non of them state explicitly how to accomplish the task of "import non-existing lines from /tmp/my_fi

Re: Beginner - Updating a Table from a File

2001-11-27 Thread CK Raju
Elaborate, please. Raju On Tuesday 27 November 2001 16:47, raezor wrote: > Can you update a table from a file? if so where can I find some syntax? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the

Fw: Could mysql count the datatraffic of DB's posted queries?

2001-11-27 Thread p-markovic
> SHOW STATUS will give you an indication on how much > traffic is moved between your server and the clients > (look for "bytes sent" and "bytes received") - but > only the totals for the server are displayed. I very > much doubt you can get the data by client or connection. > > I'm curious as to

Beginner - Updating a Table from a File

2001-11-27 Thread raezor
Can you update a table from a file? if so where can I find some syntax? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Re: Using SUM() and LEFT JOIN gives me incorrect values for SUM()

2001-11-27 Thread Benjamin Pflugmann
Hi. On Tue, Nov 20, 2001 at 10:40:25AM -0500, [EMAIL PROTECTED] wrote: > > I will try to be as complete as possible here. This is the query that I'm > trying to run: > > SELECT [...] > art_id, > art_title, > art_descri

Re: MySQL v4 FTS speed

2001-11-27 Thread Gordan Bobic
On Tuesday 27 Nov 2001 20:17, Mike Wexler wrote: > > The query > > > > SELECT * FROM table > > WHERE MATCH (description) AGAINST ("+A +really +nice +toy" IN BOOLEAN > > MODE) ORDER BY MATCH (description) AGAINST ("+A +really +nice +toy" IN > > BOOLEAN MODE) LIMIT 10 > > > > will abort the sear

Re: How do temporary tables die?

2001-11-27 Thread sherzodR
You mean how they are dropped? temp tables are created for each seperate process (session?). So as soon as the client (or you program) ends the session, they should be dropped Morten Dreier wrote: Morten: How do tamporary tables die? Is there a time limit, og do I have to drop Morten: them man

Re: Problem moving database datadir

2001-11-27 Thread Ken Kinder
Although I wouldn't suggest doing this, it seems to work fine for me. I suggest in moving the directory, do not make ANY changes to the permissions - any. Just do this as root: (Assuming you have redhat'ish directory structure) cd /var/lib/mysql mv dbname /home/user/database ln -s /home/user/d

RE: Could mysql count the datatraffic of DB's posted queries?

2001-11-27 Thread Carsten H. Pedersen
> Hi all, > > I'm looking for a posibility to count the datatraffic of a database at my > mysqldb-server. > The clients should got only select-rights on thier databases. And > I need to > count the resultset datatraffic of their select-queries. > > I'm using mysql version 3.23.39. > > I was lo

Re: Mysql question and sql request. Are they the same?

2001-11-27 Thread Benjamin Pflugmann
Hi. On Tue, Nov 20, 2001 at 02:23:31PM +0100, [EMAIL PROTECTED] wrote: > > Hei > > I asked this question sometime ago but I did not get any answer :-( I think the problem is that people are not sure what you are referring to (includes me). > and I can not find any explanation of this in the

Re: MySQL v4 FTS speed

2001-11-27 Thread Mike Wexler
>>Lets say I have a table with 4 fields >> >>itemKey INT(10) unsigned auto_increment primary key >>status enum("forsale", "sold") >>description TEXT >>price DECIMAL(10,2) >> >>And I do a >> >>SELECT * FROM table >>WHERE MATCH (description) AGAINST ("A really nice toy") >>AND status="forsale" >>OR

RE: making a dsn-LESS connection

2001-11-27 Thread Darren S Ball
I believe your provider must be a valid db drivermake sure it exists on your machine. you may want to check out www.4guysfromrolla.com they have a great section on asp dsn/dsn-less connections. Hope it helps. Darren S. Ball Software QA Engineer Lucent Technologies - InterNetworking Systems

Could mysql count the datatraffic of DB's posted queries?

2001-11-27 Thread p-markovic
Hi all, I'm looking for a posibility to count the datatraffic of a database at my mysqldb-server. The clients should got only select-rights on thier databases. And I need to count the resultset datatraffic of their select-queries. I'm using mysql version 3.23.39. I was looking for some logfiles

Re: making a dsn-LESS connection

2001-11-27 Thread Bruce and Irene
Hi Harry, Your ADO connection string should look something like this: Provider=MySqlProv;Data Source=yourdatabasename;Password=yourpassword;User ID=youruserid;Location=localhost Easiest way to build it is to createan empty text file on your desktop. Rename it 'Test.udl'. Double Click it. Select

Re: Re: undelete records ?

2001-11-27 Thread Benjamin Pflugmann
Hi. On Tue, Nov 20, 2001 at 09:26:51AM +, [EMAIL PROTECTED] wrote: > Just to clarify; > > My understanding now, > > If I delete row 14 (example) the next time I create any data in my database > it will be put in the now slack space that used to contain row 14 ? > if it does not entirely f

Re: Connection limit per user

2001-11-27 Thread Roman
Thank you very much. It's a real solution for me!!! > In the changes to 3.23.34 http://www.mysql.com/doc/N/e/News-3.23.34.html > > o Added option max_user_connections to mysqld. > > and in the show variables doc > http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html > > o max_user_connections The

Re: Error List

2001-11-27 Thread Benjamin Pflugmann
Hi. I am not sure, but I believe there is no such list. You can use perror to check what an error is about, e.g. shell> > perror 11 Error code 11: Resource temporarily unavailable Bye, Benjamin. On Tue, Nov 20, 2001 at 11:49:42AM +0530, [EMAIL PROTECTED] wrote: > hello > > I wan

Re: problem in SQL

2001-11-27 Thread Benjamin Pflugmann
Hi. On Tue, Nov 20, 2001 at 11:38:01AM +0530, [EMAIL PROTECTED] wrote: > Hello, > > I have a problem related SQL Query > > SELECT a.cAction_Name,a.nAction_ID FROM tbl_actionmaster a LEFT JOIN > tbl_roleactionrelation b ON a.nAction_ID != b.nAction_ID > WHERE b.nRole_ID = 3 > group by a.cAct

Re: urgent questions need your help!!

2001-11-27 Thread Benjamin Pflugmann
Hi. There is no straightforward method to recover deleted entries. The backup (of course, you have backups, don't you) will be your best friend. Theoretically, there is a chance to recover deleted entries, because they are not really deleted, but only put in a list of records to be reused. But i

making a dsn-LESS connection

2001-11-27 Thread GRC
I wish to have my asp pages (on an NT 4.0 iis 4.0 machine) connect to a mysql database. I want to have the DSN-LESS type of a connection. This DSN version works: ConnectionString = "DSN=myDSNname;User Id=myuserid;Password=aword;" However this DSN-less version does not: ConnectionString = "

Re: SELECT INTO LCOAL OUTFILE

2001-11-27 Thread Paul DuBois
At 8:28 AM +1300 11/28/01, Quentin Bennett wrote: >Hi, > >Is there a reason why, if I can > >LOAD DATA LOCAL INFILE 'file' INTO TABLE fred; > >why I can't > >SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred Because it's just never been implemented. > >I know the data has to travel to the cl

[OT] Comments about my DB layout

2001-11-27 Thread Etienne Marcotte
Good afternoon, This is my first post on that list, I was looking for relational database mailing list, and found none. So I will post my question here since my database will be under mySQL and users on this list probably have good experiece with DB design. I designed my database, and before all

Re: Exporting Data

2001-11-27 Thread Benjamin Pflugmann
Hi. On Mon, Nov 19, 2001 at 11:32:58PM -0600, [EMAIL PROTECTED] wrote: > Hello, > > Sorry about the OT, but I need to export data from various MySQL tables and > import into Excell spread sheets. Was hoping someone could suggest the best > format, TAB, CSV..etc delimited, which is the preferred

SELECT INTO LCOAL OUTFILE

2001-11-27 Thread Quentin Bennett
Hi, Is there a reason why, if I can LOAD DATA LOCAL INFILE 'file' INTO TABLE fred; why I can't SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred I know the data has to travel to the client, but it would make scripting easier! Quentin Bennett Transport Systems Division Infinity Solutions

Re: SOURCE command somewhere in manual?

2001-11-27 Thread Benjamin Pflugmann
Hi. On Tue, Nov 20, 2001 at 09:07:58AM +0800, [EMAIL PROTECTED] wrote: > The bitbybit.dk MySQL FAQ says: > > > How do I use a batch file with MySQL? > > >From within the MySQL client (v. 3.23.9 and above): > > mysql> SOURCE filename > > > Is t

Re: How do temporary tables die?

2001-11-27 Thread Ryan Fox
> How do tamporary tables die? Is there a time limit, og do I have to drop > them manually? They are dropped when the client connection that created them disconnects. They can also be dropped manually. Ryan - Before posting, p

How do temporary tables die?

2001-11-27 Thread Morten Dreier
How do tamporary tables die? Is there a time limit, og do I have to drop them manually? -- Morten Dreier http://www.pobox.com/~mdreier/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

[Fwd: Re: No Data Truncation warning with MM JDBC driver]

2001-11-27 Thread Steve Pellegrino
Is it planned for this to be addressed in a future MySQL version? Original Message Subject: Re: No Data Truncation warning with MM JDBC driver Date: Tue, 27 Nov 2001 12:15:08 -0600 From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Steve Pellegrino" <[EMAIL PROTECTED]> References:

Problem moving database datadir

2001-11-27 Thread Mike(mickalo)Blezien
Hello All, Hoping someone can point where I may have gone wrong on setting our client's databases within their own respective home directories. Here is one of the setups dir tree and settings: The database 'tracers' is symbolically linked from the datadir to the client's home directory. But for

Re: Connection limit per user

2001-11-27 Thread Andrew Schmidt
In the changes to 3.23.34 http://www.mysql.com/doc/N/e/News-3.23.34.html o Added option max_user_connections to mysqld. and in the show variables doc http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html o max_user_connections The maximum number of active connections for a single user (0 = no limit

RE: MySQL - Got Signal 11 - UPDATE

2001-11-27 Thread Jonathan Hilgeman
Hello All, I believe I've found a reason for and a fix to a problem I've been experiencing for some time now. My MySQL server has been restarting frequently - once, twice, even three times a day for the past few months. If I shutdown MySQL and run myisamchk on the tables, I'd get: myisamchk: MyIS

Connection limit per user

2001-11-27 Thread Roman
Hi All. Does anybody know how can I limit maximun connections number to mysqd for individual user, not for all users in sum, as it done by the variable max_connection ? I suppose it is nonstandard feature, and may be a patch for mysql is available ? -- regards Roman. -

data types for calculated columns

2001-11-27 Thread Larry Weng
Hi, Here is how to reproduce my problem. 1> create table t1(a bigint); 2> insert into t1(a) values(2); 3> create table t2(b double); 4> insert into t2(b) values(3); 5> select t1.a/t2.b as c from t1,t2; +--+ | c| +--+ | 0.67 | +

C and MySQL

2001-11-27 Thread Wilson de Aguiar
Hello ALL I'm making a program that will read a file that haves more or less 500.000 lines. The program filter this lines and record the data in a MySQL database. It will record more or less 500.000 records. I am reading the data of an archive text, sequentially, more or less like this:

C and MysQL

2001-11-27 Thread Granzoto
Hello ALL I'm making a program that will read a file that haves more or less 500.000 lines. The program filter this lines and record the data in a MySQL database. It will record more or less 500.000 records. I am reading the data of an archive text, sequentially, more or less like this:

Re: inserting from one table into another

2001-11-27 Thread Tony
...I hate when this happens, I found it. For those who didn't know: insert into table1 select table2.* from table2; I know, I should be column specifc to accomodate table schema changes later in life, but this was a test. T On Tuesday 27 November 2001 12:46 pm, Tony wrote: > I thou

index question strange behavior

2001-11-27 Thread rick herbel
Questions about index mysql> show index from listing; +-++-+--+-+- --+-+--+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | +-++

PHP install w/MySQL difference question

2001-11-27 Thread Erik Price
Hello, [The contents of this email contain quite an annoying amount of output from the command line, but please note that I have deleted most of the unnecessary output and tried to comment the parts that I felt were necessary.] I am curious as to what the difference will be if I choose to ins

inserting from one table into another

2001-11-27 Thread Tony
I thought the following SQL statement would work (both tables are the same schema): insert into table1 values ( select * from table2 ) ; ...or was I seeing magic posts in the wee hours of the morning? I didn't think that was a subselect, but maybe I am wrong there too. Any help

Re: MySQL - Got Signal 11 - URGENT-RedHat-gcc2.96

2001-11-27 Thread Trond Eivind Glomsrød
Sasha Pachev <[EMAIL PROTECTED]> writes: > On Monday 26 November 2001 03:40 pm, Ady Wicaksono wrote: > > gcc 2.96 has bugs that affect MySQL, what bug ? > > RedHat 7.1 and RedHat 7.2 comes with gcc 2.96 > > If we knew exactly what bug we would have given Red Hat a test case to fix > it. All we

Re: MySQL - Got Signal 11 - URGENT-RedHat-gcc2.96

2001-11-27 Thread Trond Eivind Glomsrød
Gordan Bobic <[EMAIL PROTECTED]> writes: > On Tuesday 27 Nov 2001 04:11, Ady Wicaksono wrote: > > gcc 2.96 has bugs that affect MySQL, what bug ? > > A number of bugs, and they don't just affect MySQL - there is a number of > packages that break when compiled using GCC-2.96. Some examples that

innodb producing strange error on a heavy-load system

2001-11-27 Thread Attila Beno
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi, any ideas what could be causing this? this happens when apache has reached its max_client limit. using 3.23.45 011127 18:16:30 InnoDB: Started /home/attila/mysql-max-3.23.45-pc-linux-gnu-i686/bin/mysqld: ready for connecti 011127 18:35:45 re

ANN: Data Architect 2.0

2001-11-27 Thread Peter Harvey
Cross-platform, cross-database, ERD based, data architecting tool. Screenshots http://www.thekompany.com/products/dataarchitect/screenshots.php3 Product Information http://www.thekompany.com/products/dataarchitect/ -- Peter Harvey -

Re: MySQL 3.23 Manual

2001-11-27 Thread Thomas Spahni
On Mon, 26 Nov 2001, A. Clausen wrote: > Where can I find a copy of the latest MySQL 3.23 manual? All I've been able > to find is the newer 4.x. It is part of every source distribution and may be found in the ./Docs directory. Thomas --

Re: Suggestion: Formatting TimeStamp columns

2001-11-27 Thread Thomas Spahni
On Mon, 26 Nov 2001, Brent wrote: > A Select statement will display the TmeStamp as 2005095105. Now I ask > you, how many users will understand this format? > Why not display TimeStamp in the same format as DateTime? At least then the > TimeStamp is in a meaningful representation that users

Re: Date Manipulation.

2001-11-27 Thread Julio Faerman
HI ! First of all , thnx a lot for the attention. The EXACT query i need is . assume IN and OUT as date colums in the format "-MM-DD HH:MM:SS " I need my query to return: "How many seconds are there between IN and OUT but outside the period 8:00 to 20:00" For example : IN ="2001-10-20 02:30:0

Re: Date Manipulation.

2001-11-27 Thread Thomas Spahni
On Mon, 26 Nov 2001, Julio Faerman wrote: > Is there anything like a "to_hours()" function ? > I need my query to to calculate how much time there is between two time > values Julio, ok, we are trying to help you, but please make our lives a little bit easier and tell us exactly what you

InnoDB

2001-11-27 Thread Meital Geron-Issers
Hello, I've just install mysql 4.23.44. I created an InnoDB Database and add to it 4 tables. I read in the manual that I should get only .frm file for each table and that is what I got. But, now, when I am trying to connect to the Database, mysql still searching the MYD file. What should I do?

Re: MySQL and .Net

2001-11-27 Thread Fredrick Bartlett
Hello Vaijayanthi.M! If you are successfull, please report to this list your solutions... Thanks, Fredrick Sinisa Milivojevic wrote: > Vaijayanthi writes: > > Sir, > > We are working in .Net environment. We could not use the MySQL database > > in the .Net platform. The MySQL ODBC (MYODBC) does

innodb: request for change in manual :)))

2001-11-27 Thread Attila Beno
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi, I've just rolled back half a gig's worth of data. :) it took some time. :) Right now, I know where I made the mistake, but I think if someone just looks through the innodb manual, it might not be so obvious at first. Could the list of commands

Problem of MySQL

2001-11-27 Thread EdwardSPL
Hello, My system is Linux Red Hat 6.2... So, Which version of MySQL ( RPM packages ) is good for work with RH 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: Netscape not rendering correctly

2001-11-27 Thread Amer Neely
sherzodR wrote: > > Lotta peoploe do not use and closing tags. It works fine in > IE, as it closes them automaticly whenever it sees the opening and > . But Netscape turns up its nose. So it should do w/ the HTML syntax, > I believe. You could post a link to that page, if you wish, or have HTM

Re: a simple GUI to retrieve and enter MySQL data?

2001-11-27 Thread Richard B. Tilley (Brad)
On Tue, 27 Nov 2001 09:27:38 -0500 Barbara Ferrell <[EMAIL PROTECTED]> wrote: > any favorites for a simple gui to retrieve and enter data using MYSQL. i am > using redhat linux 7.2 and a beginner I use webmin to manage mysql and other things on my Linux servers. I have several small databases,

RE: Mac OS X and MySQL

2001-11-27 Thread john
alright alright already, i give. i was having a bad day yesterday and some @#$%'er got me started. Paul DuBois has pointed out my statement "...for the last 10 years." This was referencing the PC vs. Mac war that's been going on in every newsgroup for the last ten years. I have had my mailbox flo

a simple GUI to retrieve and enter MySQL data?

2001-11-27 Thread Barbara Ferrell
any favorites for a simple gui to retrieve and enter data using MYSQL. i am using redhat linux 7.2 and a beginner - Original Message - From: <[EMAIL PROTECTED]> To: "Barbara Ferrell" <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 8:59 AM Subject: Re: a simple GUI to retrieve and en

Re: User Defined Functions.

2001-11-27 Thread Andrew Schmidt
http://www.mysql.com/doc/A/d/Adding_UDF.html thanks, -- Andrew - Original Message - From: "Julio Faerman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 3:11 PM Subject: User Defined Functions. > Can i create my own functions with mysql ? > > > >

User Defined Functions.

2001-11-27 Thread Julio Faerman
Can i create my own functions with mysql ? - 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 PROTE

OT (was: Is converting string to integer possible?)

2001-11-27 Thread Carl Troein
Jerry writes: > How did you know I have an Amiga??? I know everything about everybody. I'm god. :-) Or actually, I just looked at the mail headers. But hey, you can still call me god if you want to. ;-D //C - more diabolic than divine -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353

Re: Too many connections (again) (could Mark answer this please)

2001-11-27 Thread Mark Matthews
I've answered this twice, both in personal e-mails, but I'll answer it again, one last time :). Three things, First, you're using an old version of the driver. Please upgrade to the latest (you should do this when you suspect it might be the driver. Always check http://mmmysql.sourceforge.net/

Re[2]: can i do this with sql?

2001-11-27 Thread Aleksandar Bradaric
Hi, > i actually need the id's with no row returned as if they > were there (but with default values)... they do not need > to be inserted into the table, just returned as if they > were in there. The only way I can think of would be to create a table with all the values (ids) you ne

Re: MySQL4 and SSL using Java API

2001-11-27 Thread Mark Matthews
The JDBC driver (MM.MySQL) does not currently support SSL, as it only stabilized in version 4 of MySQL (which is still in Alpha test). SSL is in the plans for MM.MySQL, but not high on the list, as most of my users use it in a middleware-type situation, where SSL would not be used. If anyone wants

Re: MySQL and .Net

2001-11-27 Thread Sinisa Milivojevic
Vaijayanthi writes: > Sir, > We are working in .Net environment. We could not use the MySQL database > in the .Net platform. The MySQL ODBC (MYODBC) does not work with the > OleDBProvider of .Net. > We tried with the myOleDB provided by MySQL which is also not working > in .Net environment. Pleas

  1   2   >