Re: OS X Server 10.1.2

Try this: http://www.entropy.ch/software/macosx/mysql/ regards, Andreas On Sonntag, Januar 27, 2002, at 04:37 Uhr, [EMAIL PROTECTED] wrote: i tried to start mysql thinking it was preinstalled on OS X Server. is it not installed on OS X Server? apparently all of the usual files are not

Re: InnoDB and SET TRANSACTION ISOLATION LEVEL, etc...

Jeremy, look at http://www.innodb.com/ibman.html and http://www.innodb.com/todo.html about InnoDB isolation levels. Currently, SET TRANSACTION ISOLATION LEVEL does not have any effect on MyISAM, BDB, or InnoDB. The standard isolation level of InnoDB is REPEATABLE READ (you can also call that

Readline in mysql client does not read /etc/inputrc

Hi! Jon == Jon Haugsand [EMAIL PROTECTED] writes: Description: Jon When starting the mysql client, I could not input any Scandinavian Jon characters, like æøå. Even if these characters are inputable in the Jon bash shell. Readline in a bash shell first reads the /etc/inputrc and Jon then

Problem with Load Data InFile

Dear all, I had a problem with load data infile syntax LOAD DATA INFILE '$file' REPLACE INTO TABLE $table FIELDS TERMINATED BY '|' that the original data has already carriage returns was considered as new records in the database, I solved it by using the following syntax: LOAD DATA INFILE '$file'

Mysql 4.0.1 autocommit bug with Innodb table

I am using Mysql 4.0.1 alpha for Windows, my table are all on InnoDB, when I connect to mysql server using C API mysql_real_connect() and execute a sql command select * from sampletable and fetched the result set, then execute a truncate table anothertable, it reports 1192 Can't execute the

MySql Server Specification!

Dear friend , I want to connect to MySql server thru telnet ...it ask for Handshake command so any budy can tell me what r the commands for communicating with server and where can i find list of command ...actually i want to write mysql gui client so i need to know what command

RE: Cannot import mysql dump

Hi, can someone from the mysql developers tell me what i did wrong, if this is a bug? I converted back to 3.23.42 to be on the safe side. ;) TIA -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National

Re: Found option without preceding group in config file: c:\WINNT\my.ini line: 1 Program aborted

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Gary Penn writes: I am having trouble with this error: Found option without preceding group in config file: c:\WINNT\my.ini line: 1 Program aborted cut - Yes, the first line of the my.ini file is [mysqld] cut Could you

Re: Can this can be done in a single SQL statement?

Hi Mark, Can anyone tell me if this can be done in a single SQL statement? This sounds like solving the problem in procedural logic. Try putting that aside and/or converting to relational logic. As to the complexity of working with so many tables, its realisation is startlingly simple once

Re: Can this can be done in a single SQL statement?

Hi DN, Boy SQL is damn powerful!!! I see what you mean by having my head switch the way it is thinking and a lot of penny's dropped this afternoon, Thankyou. In the end I did this: SELECT studentname_27.objectives_id, studentname_27.data, staff.name, studentname_27.date,

RE: Can this can be done in a single SQL statement?

* Mark Wordsall So there is no join is this sql statement, I say this cos I see no word saying JOIN? Yes, there are. The comma separating table names in the FROM clause are synonyms for 'INNER JOIN', and the actual joining is done in the WHERE clause, where you match the different tables, in

MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting starting

I can not connect to mysql neither do some tests: [hlutz:/usr/local/mysql] hlutz% mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'hlutz@localhost' (Using password: NO)' [hlutz:/usr/local/mysql] hlutz% su mysql Password: Sorry

Re: Mysql 4.0.1 autocommit bug with Innodb table

Hi! This is a bug in the MySQL layer of code. I am sending a carbon copy of this email to Monty. I assume calling COMMIT explicitly after the SELECT allows you to do the TRUNCATE? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See

Help with formating data in textarea

Sorry to bother again but does anyone know how to do the following? I'm interested in learning more about the following: The only reason I'm writing to this list is that I've had such great help in the past and I've been looking for new ways of displaying data from mysql so why not go to the

RE: mysql benchmark

hi! jon-david == jon-david schlough [EMAIL PROTECTED] writes: jon-david thanks christopher and monty ! got perl into my path and it's working... jon-david another ? tho: i also want to benchmark postgreSQL living on another 2K jon-david machine, does the mysql benchmark have to run locally or

Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting starting

Am Sonntag den, 27. Januar 2002, um 19:15, schrieb Michael Collins: At 6:43 PM +0100 1/27/02, Helmuth Lutz wrote: I can not connect to mysql neither do some tests: [hlutz:/usr/local/mysql] hlutz% mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied

Re: Fulltext build 2 days and counting... A SOLUTION!

After a few days of playing around I finally was able to come up with a solution: Even though it says it will be much faster to populate the table, then add the fulltext index, it appears the opposite is true for large tables. I built an empty copy of the table I wanted to index, added the

Re: Using LIMIT to select random rows

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Ulf Harnhammar writes: This is a suggestion for a small addition to MySQL's syntax which I'm proposing, unless someone is kind enough to show me that there already is equivalent functionality somewhere else in MySQL. See,

RE: most appropriate data type for currency?

I'd recommend decimal(10,2), myself. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 26, 2002 5:57 PM To: Shankar Unni Cc: [EMAIL PROTECTED] Subject: Re: most appropriate data

RE: Understanding throughput with JDBC

Hi! Emmanuel == Emmanuel van der Meulen [EMAIL PROTECTED] writes: cut This will of course slow down any query significantly, if the WHERE clause matches a lot of rows, but should still be faster than: - retrieving all rows to get a count. or - Do two queries: SELECT COUNT(*) FROM ...

Re: MySQL monitoring tools

Hi! Hi All, Does anybody know if there are any monitoring tools for MySQL database? Thanks, Aruna. You can find a wide range of MySQL tools in the MySQL software portals at: http://www.mysql.com/portal/software/html/index.html Take a look under the section 'Administrators' and

RE: Selecting the row with largest number in a column

Thanks, but using SELECT MAX(age) FROM contacts only gives me the maximum age, not the person with that age. The table is tiny, changes very often and therefore indexes would be a waste of time. Thanks Richard -Original Message- From: Butch Bean [mailto:[EMAIL PROTECTED]] Sent: 25

Why does MAX(t.a), t.b return fields from different records?

I think that the command SELECT id, ref, MAX(timestamp), field FROM t GROUP BY ref; should give me fields with the latest timestamp for each ref in my table. But it doesn't. I have the following table: mysql describe t; +---+--+--+-+-++ |

Re: MySql Server Specification!

On Sun, Jan 27, 2002 at 02:11:57PM -, vikram singh wrote: I want to connect to MySql server thru telnet ...it ask for Handshake command so any budy can tell me what r the commands for communicating with server and where can i find list of command ...actually i want to

Re: Mcan't stop daemon on OS X

At 19:21 -0500 1/27/02, John McCauley wrote: I'm running 3.23.47 on Mac OS X 10.1.2 and can't stop the mysqld without resorting to a kill -9 I read in a past post that this was fixed in 3.23.45. Any further info? Works for me. Is it possible your system actually is still running an older

Re: MySql Server Specification!

At 14:11 + 1/27/02, vikram singh wrote: Dear friend , I want to connect to MySql server thru telnet ...it ask for Handshake command so any budy can tell me what r the commands for communicating with server and where can i find list of command ...actually i want to write mysql

Re: Why does MAX(t.a), t.b return fields from different records?

At 16:07 -0800 1/27/02, [EMAIL PROTECTED] wrote: I think that the command SELECT id, ref, MAX(timestamp), field FROM t GROUP BY ref; should give me fields with the latest timestamp for each ref in my table. But it doesn't. 1) Why do you think that query should return that result? 2) Why are you

Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me gettingstarting

At 20:31 +0100 1/27/02, Helmuth Lutz wrote: Am Sonntag den, 27. Januar 2002, um 19:15, schrieb Michael Collins: At 6:43 PM +0100 1/27/02, Helmuth Lutz wrote: I can not connect to mysql neither do some tests: [hlutz:/usr/local/mysql] hlutz% mysqladmin version mysqladmin: connect to server at

MySQL undo?

Hi, I did a really dumb thing. I went update Tablename set Name = 'Joe Bloe' instead of update Tablename set Name = 'Joe Bloe' where ID = 5. Now all the Name records in Tablename = 'Joe Blow' Damn. I can't believe I did that, but it was a slip of the hand. Is there any easy way to recover

Re: Why does MAX(t.a), t.b return fields from different records?

Hi Paul, Me I think that the command SELECT id, ref, MAX(timestamp), field FROM t Me GROUP BY ref; should give me fields with the latest timestamp for Me each ref in my table. But it doesn't. Paul 1) Why do you think that query should return that result? Apparently because I had some

Re: MySQL undo?

Only in the case of transaction based tables in which you haven't committed; Time to restore a backup. David S. Jackson wrote: Hi, I did a really dumb thing. I went update Tablename set Name = 'Joe Bloe' instead of update Tablename set Name = 'Joe Bloe' where ID = 5. Now

Re: Mcan't stop daemon on OS X

[localhost:local/mysql/bin] root# ./mysqld -v ./mysqld Ver 3.23.47 for apple-darwin5.1 on powerpc On Sun, 27 Jan 2002 18:52:34 -0600 Paul DuBois [EMAIL PROTECTED] wrote: At 19:21 -0500 1/27/02, John McCauley wrote: I'm running 3.23.47 on Mac OS X 10.1.2 and can't stop the mysqld without

Re: Mcan't stop daemon on OS X

At 21:29 -0500 1/27/02, John McCauley wrote: [localhost:local/mysql/bin] root# ./mysqld -v ./mysqld Ver 3.23.47 for apple-darwin5.1 on powerpc % ./mysqld -v ./mysqld Ver 3.23.47 for apple-darwin5.2 on powerpc I built mine from source. Did you? On Sun, 27 Jan 2002 18:52:34 -0600 Paul

describe all tables

Can describe be used to show columns from all tables in a database? All at once that is. I want to document all fields in all tables and find I need to display one table at a time. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] |||

Multiple Field Terminators in LOAD??

I’m trying to create a LOAD statement that will enable me to load both a comma or tab delimited text file. I am only successful in achieving one or the other by using: LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY '\\t,' LINES TERMINATED BY '\\r\\n' or LOAD DATA LOCAL

Problems with accented characters

I have just started using mySQL and learning how to use it, so please accept my apologies in advance if this has already been asked here. There is an option to download all archives, but no search facility. I am from Brazil, and one should note that Portuguese makes extensive use

Re: Multiple Field Terminators in LOAD??

At 22:35 -0800 1/27/02, Chris Williams wrote: I'm trying to create a LOAD statement that will enable me to load both a comma or tab delimited text file. I am only successful in achieving one or the other by using: LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY '\\t,'

Re: [BUG] CREATE TABLE ... SELECT ...

At 22:36 -0500 1/27/02, Terra wrote: Greetings, I believe I have stumbled upon a subtle behavioral bug in mysql 3.23.47... CREATE TABLE testing SELECT * FROM template WHERE 1=0; I do this to create quick tables based on a master template table... This is mostly done when I'm working with

Re: Mcan't stop daemon on OS X

Nope. Binary dist from the mysql site. Looks like it's source time... -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Paul DuBois [EMAIL PROTECTED] Date: Sun, 27 Jan 2002 20:42:49 -0600 To: John McCauley [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Mcan't

Attention ! Ce Email est une bombe !!!

Enfin, disons surtout qu’en visitant le site dont je vais vous donner le lien, vous allez avoir accès à des photos et à des vidéos qui sont de véritables bombes …. A ne pas mettre entre toutes les mains… Jugez plutôt : Plus de 100 liens accessibles gratuitement, classés par thématiques (vous

about the stable version of MySQL-Max-3.23

hi, I am wanting to use MySQL with InnoDB support and it is available with the extended version of MySQL (i.e. Max) or unstable version of MySQL-4.0. As, the stability of version MySQL-Max-3.23 was to declare by Innobase Oy in January 2002, I don't no whether it has been declared stable or not. I

Re: Record-level locking

On Fri, Jan 25, 2002 at 11:35:03AM -0800, Gary E Bickford wrote: A couple hundred netapps? Man, you must have a big operation. What sort of business is it? Mostly Yahoo! Mail. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408)

Re: Which is faster VarChar(255) or Text?

On Fri, Jan 25, 2002 at 09:42:07AM -0600, BD wrote: Jeremy, Thanks, I hadn't thought of TinyText. With flat file type databases that I used to use, if I put something in a memo field, it takes longer to retrieve the data because it is stored in a separate physical file. There is

ODBC - Access Denied -- Please help!!!!

Hi I am new to MySQL I have installed MySQL on windows 200 swerver and installed MyODBC. I created a db and added a user with the grant command and added select,insert,delete,update privileges for the user. mysql show grants for www;

Case for Field Name Alias

Have a design situation where I could use a field name alias to simplify some programming. I'm wondering which of my options would be considered good form. I generated a series of database action shells (as I call them) in a middleware language to standardize a sequence of events surrounding db

RE: Case for Field Name Alias

I would go for the parameterized solution here - fully flexible routines are a very good thing. Plus it sounds as if your tables will be more normalized - i.e. you won't be including meta-data in your data tables (if I'm interpreting what you're saying correctly). Good luck, Jon

seeking partner

TF Information Exchange (TF) Physical Address : Room 210, Building 2, Chegongzhuang Street No. 6, Xicheng District, Beijing, China Post Code: 100044 Tel: +86-10-6800-3112 Fax: +86-10-6800-1452 Web site: http://www.tangfeng.org E-mail: [EMAIL PROTECTED]