run-all-test

Have done a fresh install of 4.0.20 and am getting some odd errors when running as root when I peform the tests: *** C:\mysql\bench>perl run-all-tests --user=root --password=tops3cr3t Benchmark DBD suite: 2.15 Date of test:2004-07-25 22:11:28 Running tes

mySQL 5.0 compiling embedded server with VS 2003/Windows

I have not been able to link my app writen in Visual Objects to lymysqld (version 4.1.13) I got an error in the sever_init mysql_server_init(0, NULL_PTR, NULL_PTR); the prototype is defined as _dll function mysql_server_init( nInt as Int, arg as PTR, grp as PTR) as Int Pascal:libmysqld.mysql_

Re: what does Rows_examined mean exactly?

hrm.. but i tried SELECT * FROM post ORDER BY postdate DESC LIMIT 771297, 30 postdate is not primary key but just an INDEX it still examined 771297 rows From: Michael Stassen <[EMAIL PROTECTED]> To: tinys xuefer <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: what does Rows_examined mean exa

table_cache size for large value in opened_tables

Hi all, My system reports: Open_tables 512 Opened_tables 24,429 The docs say that if the latter is high I should increase the table cache size. (currently at 512) How does one decide what size to increase it to? And is there a problem with one of the applications that's making this figure so hig

query to select only numeric portion of string

Using MySQL 4.0.20, I need to extract just the numeric portion of a string in a field and move it to another field in the same table, but I'd only like to do this if the value actually starts with a number. So, what I'm looking to accomplish is: UPDATE table SET field2 = VOODOO( field1 ) The fi

RE: MySQL book

At 1:55 +0200 7/26/04, Schalk Neethling wrote: Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois - New Riders Publishing That's the first edition. I would suggest getting th

RE: MySQL book

Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois - New Riders Publishing -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Mu

Re: multiple table delete syntax question

I have no problem understanding the syntax, or how to do what I want (at least after my first mistake). It is more about if this is a consistant grammar. For example, unix commands have the form " ", except for "ln -s" (IMO). >From a lexical view, I do not think the two forms are parallel. My que

Slow server - any idea?

Hi eveybody, I've got problems since a few weeks with my mysql server. There are a lot of slow queries (about 1200 in less than 48 hours), even some that should absolutely not be slow like this one which is performing on a HEAP table : SELECT * FROM vb3_session WHERE sessionhash = '31d429cc3820a

Re: List of associated records

Each member can have several interests, and each interest can be held by several members. The best way to do this is with a third table relating the two: CREATE TABLE member_interests (member_id INT, interest_id INT, UNIQUE INDEX mem_int_idx (member_id,interest_id); Each row in this

Re: Display field of selected record from full table recordset

You probably want to pick up a good SQL book. MySQL by Paul DuBois is a really good one. http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=1090786499/sr=8-2/ref=pd_ka_2/102-0741496-3072118?v=glance&s=books&n=507846 You want to use the WHERE clause of the select statement. SELECT tabl

Re: Can't start server.

Debian, woody version. - Original Message - From: Jonathan Villa To: Levi Campbell Cc: [EMAIL PROTECTED] Sent: Sunday, July 25, 2004 2:06 PM Subject: Re: Can't start server. Levi Campbell said:

re: List of associated records

Create a seperate table called member_interests or something similar Store one member_id and one interest_id (or whatever you have your PKs named) in each row. This is similar to an order entry system, which typically has one table for order_headers and one for order_detail. The order_header tab

Re: Can't start server.

Levi Campbell said: > Okay, I've got MySQL installed but now I can't start the server deamon, > when > I try to start it as the root user, I get the following: "Warning: asked > for > 196608 stack space but got 126976" but on the user mysql I get: "bash: > mysqld: command not found." > > What do I

Display field of selected record from full table recordset

I have a recordset that retrieves the full content of the table - all fields, all records. Depending upon the content of different fields in different tables, I need to display certain fields of certain records within the full recordset. What's the syntax for selecting a particular record for displ

Newbie: Transitioning from MS Access to MYSQL

I am new to MYSQL and I want to set-up a database with two or more tables that need to be "linked". I come from a basic MS Access background, and in Access linking two tables is done by creating a relationship. Is it done the same way in MYSQL? If so, could someone please shed some light on this

List of associated records

I have come across this problem a few times and wondered how other people solved the problem. Let's say I have a table containing Members. Each Member can choose several items in which they are interested. Each of these items represent records in a separate table - Interests. How do you store whic

Re: mysql-4.0.20 configure fails mac os x 10.3.1 client

First, I should point out that the simplest course would be to download the precompiled binary from mysql. That said, I admit I like to build from source, largely because whenever things go wrong, I always learn something. On first glance, I see a few problems: 1) You are running OS X 10.3.1, b

Re: multiple table delete syntax question

[EMAIL PROTECTED] wrote: I have a question about the multiple table delete syntax. First the documentation on the website is very clear. My question is why not how. The 'delete from using' is not ambiguous (to me). My question is about the form: delete t1 from t1,t2 where ... I would take this t

mysql-4.0.20 configure fails mac os x 10.3.1 client

Environment: OS: Mac OS X 10.3.1, client mysql: 4.0.20 compiler: gcc version 3.3 20030304 (Apple Computer, Inc. build 1495) Symptom: Small section of configure log showing first errors shown below. There is a lot more of this, too much to post here. I've chopped the beginning and the end. I'm won

multiple table delete syntax question

I have a question about the multiple table delete syntax. First the documentation on the website is very clear. My question is why not how. The 'delete from using' is not ambiguous (to me). My question is about the form: delete t1 from t1,t2 where ... I would take this to mean remove matching

Can't start server.

Okay, I've got MySQL installed but now I can't start the server deamon, when I try to start it as the root user, I get the following: "Warning: asked for 196608 stack space but got 126976" but on the user mysql I get: "bash: mysqld: command not found." What do I need to do? -- MySQL General Ma

Re: what does Rows_examined mean exactly?

tinys xuefer wrote: slow.log: # Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327 SELECT * FROM `post` LIMIT 771297, 30; i dp have privmary key on table `post` does 'Rows_examined: 771327' means mysqlserver read through those 771327 rows to get 30 rows? it takes 14 seconds! possible

what does Rows_examined mean exactly?

slow.log: # Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327 SELECT * FROM `post` LIMIT 771297, 30; i dp have privmary key on table `post` does 'Rows_examined: 771327' means mysqlserver read through those 771327 rows to get 30 rows? it takes 14 seconds! possible to show 'Rows_exami