Index selection problem

understand why MySQL would ever pick that when 3 columns in the query can use the covering index_a Can anyone give me some input on how to make sense of this? Thanks, Morten select count(*) from orders where item_id = 9602 - 4534 records select count(*) from orders where item_id = 9602

Re: Index selection problem

On Jul 21, 2009, at 3:27 PM, Johnny Withers wrote: MySQL is unable to use your index when you use IN and/or OR on yoru column. Is this really true? I'm reading High Performance MySQL 2nd ed. these days and specifically got the impression that using IN will allow usage of the index. The

Re: Index selection problem

. In reality, index_b may make little sense, but I still don't understand why MySQL would ever pick that when 3 columns in the query can use the covering index_a Can anyone give me some input on how to make sense of this? Thanks, Morten select count(*) from orders where item_id = 9602 - 4534

Re: Need advice on a good setup for generic queries

have a sound setup first before considering mindlessly adding resources (however tempting it is). Thanks for your tips. I'll be looking further into splitting the tables. Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Need advice on a good setup for generic queries

in the parent table since last update. Eliminating duplicates could be a challenge, unless I build a new table for each update and then rename the tables - but that's costly in terms of memory. What do people usually do in this situation? Any other solutions to consider? Thanks, Morten -- MySQL

Re: Need advice on a good setup for generic queries

index/query-mechanisms. Does my problem make a little more sense now? Thanks. Morten Let's say I would like to see all actions that were created in october and solved in november. On Jul 12, 2009, at 3:54 PM, mos wrote: Morten, Perhaps you could also add how many rows

Re: The size of an index (INDEX_LENGTH)

Hi, It's InnoDB on 5.0.51. The only thing I can think of that *may* be different about this is that this index used to be on a composite key (some_id, some_varchar) but then the VARCHAR column got dropped. Other than that, it's just a plain index on an INT(11). Morten On Jun 16, 2009

The size of an index (INDEX_LENGTH)

? Is that true, or is information_schema.tables unreliable or? Thanks, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Does mysql support materialized views?

On Apr 20, 2009, at 11:34 AM, Olexandr Melnyk wrote: No, you will have to emulate them using triggers or stored procedures. Or: 1. Create table this_is_not_a_view and use that as the materialized view 2. Build a new version in the background this_is_not_a_view_pending as per your data

Speeding up character set conversion

, we have about 1.000.000 rows. While the production servers are dedicated DB servers in comparison to my MacBook, I'm still concerned that this is going to literally take hours. How can this be speeded up if at all? Dropping the index first and then recreate? Br, Morten -- MySQL

Re: Separate customer databases vs all in one

On Mar 18, 2009, at 11:47 AM, Johnny Withers wrote: I have an application and database doing this right now. We run both ways, a single db per customer and a single customer per db. Smaller customers are in a shared enviroment and larger customers have their own db, sometimes they even have

Re: avoiding use of Nulls (was: The = operator)

I certainly appreciate this discussion and the clear opinions of Mike. Somehow it turned my somewhat simple question into something much more interesting. I believe in referential integrity, I also believe that enforcing a fully saturated data model like Mike proposes, is a constraint on

The = operator

Hi, I have a query where I want to retrieve all the people who are not in a specific group. Like so: SELECT id, name FROM people WHERE group_id != 3; Since people may not be in a group at all, I also need to test if the column is NULL: SELECT id, name FROM people WHERE group_id

SQL_NO_CACHE

Hi, I was hoping that using SQL_NO_CACHE would help me bypass the query cache, but judging from the below it doesn't. What can I do to avoid the query cache? Thanks. Morten mysql select count(*) from users where email = 'hello'; +--+ | count(*) | +--+ |0

Re: SQL_NO_CACHE

Thanks for all the suggestions. The caching must be done somewhere else. There is no index on the column and there are about 500.000 rows in the table. A MySQL restart doesn't flush the cache in play, but a full restart of my laptop does (OS X). I may be chasing the wrong problem, but we

Re: SQL_NO_CACHE

of me. I'm just using this specific column because I was playing around while trying to figure out why the first query was slow and the subsequent snappy. Br, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Cost of using over dimensioned columns

me that I should keep things as tight as possible, but I may be narrow minded and need a sanity check. Thanks! Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Result ordering

(SELECT ... ) but is there a nicer way to use the rank than including it in the result set? Thanks! Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Result ordering

On Nov 30, 2008, at 11:42 PM, Andy Shellam wrote: Hi Morten, I think this is valid in MySQL (it certainly is for SQL Server) but you can use a CASE statement directly in the ORDER BY clause. Try something like this: SELECT name FROM foo WHERE bar = 34 OR baz 100 ORDER BY CASE

REGEXP vs LIKE/OR

REGEXP 'foo|bar|baz' != 0; Any opinions on what's the better approach and why? Thanks Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Picking the better query (join vs subselect)

in that the select_type is SIMPLE in the JOIN approach, but PRIMARY/DEPENDENT SUBQUERY in the subselect approach. Any tips much appreciated, the full example below. Br, Morten CREATE TABLE cars ( id integer, make varchar(32) ); CREATE TABLE parts ( id integer, car_id integer, value

Rewriting query to avoid inline view

. Anyone? A solution that doesn't return any rows for the dates that do not have an event would work. Example of the events table and the above query in action: http://www.pastie.org/185419 Any tips greatly appreciated, thanks. Morten -- MySQL General Mailing List For list archives: http

Re: Rewriting query to avoid inline view

, but it works on 5.0.45 at least - but seeing that I don't need it, I'll stop using it, thanks for the tip! Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Left outer join trouble

| +--+-+ |1 | Event A Event B Event C | +--+-+ I'm tempted to solve this using a view or two, but would like to know if there's a better way. Br, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Left outer join trouble

something fundamental in the joins. Thanks, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Left outer join trouble

table returned, and I do the joins using outer left joins. Br, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Efficient use of inline virtual views

are much appreciated, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Tricky query

keyval inner WHERE outer.key = inner.key AND inner.val = 9) ... Br, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tricky query

proposal will return 1,2,3,4 and not just 1,4. Br, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tricky query

How about: SELECT DISTINCT `key`, COUNT(`key`) AS c FROM `table` WHERE `value` in (8,9,10) HAVING c=3; Clever! Thanks :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replication

Hi on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running: Yes/No) i need to do some testing with my script and i got to make sure it reads that value correctly. regards Morten

SV: replication

and failes during the update. ive tried reading the documentation about mysql replication, but i cannot find what i am looking for. Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: on 25-01-2006 22:56 Til: Morten Kallesøe Cc: mysql@lists.mysql.com Emne: Re

Re: convert varchar/char to integer

morten bjoernsvik [EMAIL PROTECTED] skrev: Hi Gents Is it possible to sort char/varchars that only contains integers as integers and not as characters. I can't use integer because the standard says it may contain characters aswell. Currently I do this outside mysql in a perl-procedure

convert varchar/char to integer

| | 2004489 | | 2004547 | | 200543 | Thanks Morten Bjørnsvik, Oslo, Norway

Charset problems (utf-8 - latin1)

| 4.1.13-log| +-+---+ Regards Morten Fangel // fangel

SV: show master/slave status privileges ?

Alan Williamson wrote: I have made a user with the following command: GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r' Silly question Morten, and I am sure you have probably done it, but you are definitely running: % mysql FLUSH PRIVILEGES; You only need to FLUSH PRIVILEGES

show master/slave status privileges ?

CLIENT TO 'test'@'123.123.123.123' IDENTIFIED BY 'h4x0r'; No luck there ethier. Regards Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: alias not allowed in WHERE clause?

, during parse time. /morten Paul DuBois wrote: At 11:32 -0700 10/11/04, Nathan Clark wrote: SELECT city, state, SQRT( POWER( ( latitude - 39.039200 ), 2 ) + POWER( ( longitude + 95.689508 ), 2 ) ) AS distance FROM geographics WHERE distance 1 ORDER BY distance LIMIT 10; Returns: #1054 - Unknown column

[Fwd: Re: Where clause question]

Sorry, mailed it in html format. Read answer below Original Message Subject:Re: Where clause question Date: Tue, 12 Oct 2004 00:00:12 +0200 From: Morten Egan [EMAIL PROTECTED] To: Ed Lazor [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Not knowing how the inards

newbie installation question

sorry for spamming the list with this, i tried asking on the forums, but didn't receive a reply. i'm a complete newbie to mysql/php, but have programmed professionally (in C/C++/ASM) for about 9 years now. i originally installed mysql into C:/Program Files/mysql, before deleting and

C API

output much like you do with mysqlclient. That will make it so much easier to grab data and make it look nice and neat. Thanks. -- Morten Boenloekke Post * mortens (at) box (dot) sk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

ON UPDATE CASCADE

are taken from one and the same table, that should be possible, please help me , what is wrong ? My code woun't cascade anything. Yours Sincerely Morten Gulbrandsen === -- DROP TABLE IF EXISTS A -- Query OK, 0 rows affected (0.04 sec

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

are missing, what can I do, install again ? I could unzip the mysql-5.0.0-alpha-win.zip without a problem, and mysql actually runs, under windows 2000, Perhaps another version of MySQL 5.0 is required for win 2k ? Has anyone tried mysql-5.0.0-alpha under win2k ? Please ? Yours Sincerely Morten

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

Miguel Angel Solórzano MySQL 5.0 should install and run on any Win32 OS, then I guess that some installation's steps/options has failed for to add the missed files. Morten Gulbrandsen Interesting, obviously something is missing, anyway 5.0.0.a is present. I could try that, Miguel Angel

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

Miguel Angel Solórzano Well I will test that on my win2k server machine is now down running instead Suse 9.0. Morten Gulbrandsen Thanks, If I know that it runs satisfactorily under suse, I'm satisfied, I have suse 8.2, but I can go for suse 9.0 If necessary. Miguel Angel Solórzano Anyway you

ERROR 1005 at line 38: Can't create table '.\test\#sql-748_17.frm' (errno: 150)

USE test; DROP TABLE IF EXISTS relvar_a; CREATE TABLE relvar_a ( #PK SSNCHAR(9) NOT NULL, #FK SUPERSSN CHAR(9), DNOINT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )ENGINE = INNODB; SHOW WARNINGS; DESCRIBE relvar_a; DROP TABLE IF EXISTS relvar_b;

ERROR 1005 at line 38: Can't create table '.\test\#sql-748_17.frm' (errno: 150)

(); ++ | version() | ++ | 5.0.0-alpha-max-nt | ++ 1 row in set (0.11 sec) Microsoft Windows 2000 [Version 5.00.2195] What can I do, please ? Yours Sincerely Morten Gulbrandsen

ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

MySQL 5.0.0-alpha-max-nt under win2k a small problem: If I have a foreign key with reference to the same table, I get an error, ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist what can I do ? Yours Sincerely Morten Gulbrandsen USE test; DROP

Re: transaction support

%40posting.google.comrnum=1 Yours sincerely Morten Gulbrandsen - Original Message - From: Bryan Koschmann - GKT [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:37 AM Subject: transaction support Hi, I'm trying to get a software designer to write us

Enabling more detailed logging

/safe_mysqld --defaults-file=/etc/my.cnf What am I missing? How do I enable more detailed logging? Thanks, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: AW: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT

values ); is not possible, for any variable or value. Is this true for PRODUCT_ORDER ? Pleas tell me, what is the purpose of ON UPDATE CASCADE ON DELETE RESTRICT ? Is that necessary ? Why ? Example please ? Yours Sincerely Morten Gulbrandsen -Ursprüngliche Nachricht- Von: Toro Hill

AW: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT

-Ursprüngliche Nachricht- Von: Toro Hill [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 16. September 2003 03:36 An: Morten Gulbrandsen Cc: [EMAIL PROTECTED] Betreff: Re: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT I believe that your ON UPDATE CASCADE clause should

FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE RESTRICT

to the references ? Yours Sincerely Morten Gulbrandsen USE test; DROP TABLE IF EXISTS PRODUCT_ORDER, CUSTOMER, PRODUCT; CREATE TABLE PRODUCT ( category INT NOT NULL, id INT NOT NULL, priceDECIMAL(1,2), PRIMARY KEY(category, id) )TYPE=INNODB; CREATE TABLE

AW: How To Create Users In MySQL?

are not exactly the same. Even if it is the same MySQL version. Yours sincerely Morten Gulbrandsen -Ursprüngliche Nachricht- Von: Caroline Jen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 10. September 2003 22:33 An: [EMAIL PROTECTED] Betreff: How To Create Users In MySQL? I have the MySQL

The value of def_value must be a constant; it cannot be an expression or refer to other columns.

if this is a definition from the SQL standard, Can this be possible by correct implementation of 'actions', 'triggers' and constrains ? Yours sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

AW: different between index and key when create table

difference is 10 milliseconds in creating, And 20 milliseconds in dropping. ;-) I need some more queries ;-) Like insert into table ... values ... and select from ... where ... As is, I'll get an empty set, mysql SELECT * FROM info; Empty set (0.00 sec) Yours Sincerely Morten Gulbrandsen

ERROR 1115: Unknown character set: 'ucs2'

: 'ucs2' mysql the manual has some statement about ucs2 : Temporary restriction: UCS-2 can't (yet) be used as a client character set. That means that SET NAMES ucs2 will not work. Can I please have an example how to utilize this ? Yours sincerely Morten Gulbrandsen -- MySQL General

ERROR 1115: Unknown character set: 'latin1_de'

in german language, öäüß is part of that. Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

63 LSB ok but bit 64 is sign bit

Mysql offers this output, is it correct ? I think not. Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to code an 'IS - A' relationship ?

://www.aw-bc.com/info/database/elmasri.html Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

comp.databases.theory

Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Using joins to create code from E- ER relationships

to PHP, Perl or C. Yours sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

I simply can't compile this

) REFERENCES DEPARTMENT(DNUMBER) ON DELETE SET DEFAULT ON UPDATE CASCADE; ALTER TABLE DEPARTMENT ADD FOREIGN KEY (MGRSSN)REFERENCES EMPLOYEE(SSN) ON DELETE SET DEFAULT ON UPDATE CASCADE ; Please tell me what could be wrong, Yours Sincerely Morten Gulbrandsen

AW: mutual declarations produce Error 1005 (errno: 150)

STATUS to look at a detailed explanation of the latest InnoDB foreign key error in the server. == According to my general SQL experience it is all correctly ANSI SQL-92 coded. Please help me, What else can be done ? Yours Sincerely Morten Gulbrandsen -Ursprüngliche

AW: mutual declarations produce Error 1064

be wrong ? Yours sincerely Morten Gulbrandsen -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 7. August 2003 13:54 An: [EMAIL PROTECTED] Betreff: Re: mutual declarations produce Error 1064 Morten Gulbrandsen [EMAIL PROTECTED] wrote

mutual declarations produce Error 1064

server version for the right syntax to use near ' REFERENCES EMPLOYEE(SSN) )TYPE = INNODB' at line 10 Bye In short I have Department Dnumber References employee (ssn) Employee Ssn References department(dnumber) What can be done , please ? Yours sincerely Morten Gulbrandsen -- MySQL

AW: mutual declarations produce Error 1064

between any two different tables, Or does it exist another solution or workaround ? Yours Sincerely Morten Gulbrandsen The one who loves MySQL ;-) -Ursprüngliche Nachricht- Von: Fred van Engen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 13. August 2003 15:36 An: Morten Gulbrandsen

AW: mutual declarations produce Error 1064

declarations produce Error 1064 Morten Gulbrandsen [EMAIL PROTECTED] wrote: I think something is wrong with my administration, Basically I get these messages, ERROR 1005 at line 9: Can't create table '.\company\department.frm' (errno: 150) ERROR 1045: Access denied for user: '[EMAIL PROTECTED

AW: mutual declarations produce Error 1064

OK, 0 rows affected (0.00 sec) mysql grant all on company.* to 'elmasri'@'%' identified by 'navathe'; Query OK, 0 rows affected (0.00 sec) mysql Then I should be able to do whatever SQL permits ? Yours sincerely Morten Gulbrandsen -Ursprüngliche Nachricht- Von: Victoria Reznichenko

ERROR 1045: Access denied

; +---+ | Tables_in_company | +---+ | blabla| +---+ 1 row in set (0.00 sec) mysql Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql 4.0.1-alpha

; And mysql complains with ERROR 1005 at line 9: Can't create table '.\company\employee.frm' (errno: 150) Bye Can someone please help me to fix this code? I think something is wrong with the index declaration, or with the foreign key constraint. But what can I do ? Yours sincerely Morten

Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing

what is support for named pipes? Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

my.cnf is not available under windows 2000

Hi programmers, according to the manual, There are two option files with the same function: `C:\my.cnf', and the `my.ini' file in the Windows directory. Is it sufficient with only one of the files ? I have only my.ini For which purpose is my.cnf , please? Yours Sincerely Morten

Constraints under 3.23.55-nt

about foreign keys and referential triggered actions. Is InnoDB the correct table type for properly supporting referential triggered actions, please ? If not, what can I do instead ? Upgrade to some newer MySQL version please ? Yours Sincerely Morten Gulbrandsen -- MySQL General

I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints to guard the integrity of your data. Yours Sincerely Morten Gulbrandsen === -- DROP TABLE IF EXISTS EMPLOYEE -- Query OK, 0 rows

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

I have the default binaries. If InnoDB is not supported in MySQL, then I would have expected a warning, Or an error message. As we all can see, no warning or error is issued, perhaps another error level can give me more feedback ? Yours Sincerely Morten Gulbrandsen -Ursprüngliche

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

not obey. Is this fixed in later releases, please ? How can I increase the levels and sensitivity of the warnings, please ? Yours Sincerely Morten Gulbrandsen === C:\mysql\bintype constraint.sql USE company; DESCRIBE EMPLOYEE; SHOW CREATE TABLE EMPLOYEE; ALTER TABLE EMPLOYEE TYPE = InnoDB; SHOW

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

, how can I enable this fundamental Value have_innodb? Yours sincerely Morten Gulbrandsen -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 31. Juli 2003 16:01 An: [EMAIL PROTECTED] Betreff: Re: I Specify explicitly TYPE = InnoDB

schema and Catalog under MySQL 3.23.55

that the sql statements schema and catalog is not working in my version of mysql. What can be done in order to remedy this ? Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

working with linked Tables

. What does this mean ? Where is it documented, can it prevent nested tables or linked tables To perform properly ? Software mysql -V mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) uname -a Linux debian 2.2.17 #1 Sun Jun 25 09:24:41 EST 2000 i686 unknown Yours Sincerely Morten Gulbrandsen

3.7 Queries from Twin Project Taken from the Documentation tutorial

data would be higly appreciated. Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to code an IS - a relationship ?

://www.aw-bc.com/info/database/elmasri.html Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

comp-err.exe

to know what useful tasks Can be accomplished with comp-err.exe under windows 2000. Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERWin 4.1 not applicable for MySQL

Since I am fond of MySQL I'd like to know your opinion, Is it possible to access MySQL from AllFusion ERwin Data Modeler ? What design tool do you use under Windows or Linux for modeling a logical database ? Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List

MIN(), MAX() not working with LEFT JOIN? Bug?

FROM plads_ordre LEFT JOIN forestilling ON forestilling.id = plads_ordre.forestilling_id WHERE plads_ordre.ordre_id = '25408' Output: antal min max 1 7 19 -- / morten There are only 10 types of people in the world: Those who understand binary, and those who don't

Transaction with InnoDB - how to lock?

inserts. Now - how would I do this with InnoDB to make it safe? Best regards Morten (now pass the maillist filter; sql, mysql, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

How do temporary tables die?

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

Mysql as a backend to openldap

with this? -- Morten - 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 unsubscribe, e-mail [EMAIL

SQL Problem

i have a MySQL DB whit this tabel: Id ColPoint CntDateTime Cnt1 Cnt2 Cntx. Cnt32 11 2001-08-01 00:05:0012 14 21 2001-08-01 00:10:0011 12 31 2001-08-01 00:15:00109 41 2001-08-01 00:20:000

Group by

i have a tabel whit 5 min counting Id CntDateTime Cnt1 1 2001-08-01 00:05:0012 2 2001-08-01 00:10:0011 3 2001-08-01 00:15:0010 4 2001-08-01 00:20:000 5 2001-08-01 00:25:006 6 2001-08-01 00:30:0014 7 2001-08-01 00:35:0011 . . What i want is to make a