Re: Index selection problem

(index_a) WHERE ... Brent Baisley On Tue, Jul 21, 2009 at 5:52 AM, Morten wrote: Hi, I have a table "orders" with the columns item_id INT FK items(id) customer_id INT FK customers(id) status_id TINYINT -- Between 1 and 4 always ordered_at DATETIME delivered_at DATETIME There are ind

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. Th

Index selection problem

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 records select cou

Re: Need advice on a good setup for "generic queries"

hrow some more RAM at it. But ideally, I would 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://

Re: Need advice on a good setup for "generic queries"

sion, but I hope that can be done. Otherwise I'm back to considering alternative 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,

Need advice on a good setup for "generic queries"

that depending on which rows have been updated 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 i

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 Ju

The size of an index (INDEX_LENGTH)

right? 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

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 the

Speeding up character set conversion

. In production, 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

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 o

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

Re: SQL_NO_CACHE

which was wrong 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://l

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 w

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(*) | +

Cost of using over dimensioned columns

an varchar(20)? My intuition tells 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

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 C

Result ordering

INCT name FROM (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]

REGEXP vs LIKE/OR

mbled upon REGEXP, and can do the same this way: SELECT id FROM table WHERE value 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)

The EXPLAIN result only differs 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

Re: Rewriting query to avoid inline view

ision, 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]

Rewriting query to avoid inline view

the same using pure DML, such that I don't need to build a huge inline view in case the range is multiple years. 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.o

Re: Left outer join trouble

records from the tickets 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]

Re: Left outer join trouble

d that I was missing 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]

Left outer join trouble

d = events.ticket_id -> GROUP BY id -> ; +--+-+ | id | text| +--+-+ |1 | Event A Event B Event C | +--+-+ I'm tempted to solve this using a view or two, but would li

Efficient use of inline virtual views

declaring the view? Any tips for improving the query are much appreciated, 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]

Re: Tricky query

ne value (as IN requires). Your 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]

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]

SV: replication

an update 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.co

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

convert varchar/char to integer

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

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 per

Charset problems (utf-8 -> latin1)

ter_set_system| utf8| | version | 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: > >

show master/slave status privileges ?

e the user with: GRANT SUPER,REPLICATION 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]

[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 kno

Re: alias not allowed in WHERE clause?

ction, 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 - Unknow

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 reinstalli

C API

the result so I get 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

ON UPDATE CASCADE

rence 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

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

50) Bye mysql> select version(); ++ | 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 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;

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

arget the linux users. Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

IMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )TYPE = INNODB; DESCRIBE A; ALTER TABLE A # here is the buggy code ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN) ON DELETE SET NULL ON UPDATE CASCADE; === Yours Sincerely Morten Gulbrandsen -- MySQL General

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

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 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

Re: transaction support

r=&ie=UTF-8&oe=UTF-8&selm=60ca69db.0308210016.822e230%40posting.google.com&rnum=1 Yours sincerely Morten Gulbrandsen - Original Message - From: "Bryan Koschmann - GKT" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 06,

Enabling more detailed logging

: /usr/bin/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 be

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?

ifferent under Linux and windows. The commands 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]

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

to know 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 unsubscr

AW: different between index and key when create table

... where ... As is, I'll get an empty set, mysql> SELECT * FROM info; Empty set (0.00 sec) Yours Sincerely Morten Gulbrandsen Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR 1115: Unknown character set: 'latin1_de'

elease, Please ? I need to insert statements 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]

ERROR 1115: Unknown character set: 'ucs2'

wn character set: '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 Mort

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]

63 LSB ok but bit 64 is sign bit

set (0.00 sec) Hi, on my operating system 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]

comp.databases.theory

erely 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

ning MySQL 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

N KEY (DNO) 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 G

AW: mutual declarations produce Error 1064

company LIKE "EMPLOYEE"; SHOW TABLE STATUS FROM company LIKE "DEPARTMENT"; Can someone please take a look at my coding, -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 8. August 2003 13:02 An: [EMAIL PROTECTED

AW: mutual declarations produce Error 1064

compile ! All I can get is alter table X add foreign key referencec X No mutual references 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

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

AW: mutual declarations produce Error 1064

me what could 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"

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

ould be incorrectly formed for the altered table. Starting from version 4.0.13, you can use SHOWINNODB 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

AW: mutual declarations produce Error 1064

the users I have created ? I expect one user and one password for entering mysql, And depending upon which database I'd like to use I expect for each database I'd like to use, one second password, This seems to be another topic, When I write mysql> grant all on company.* to '

ERROR 1045: Access denied

la| +---+ 1 row in set (0.01 sec) mysql> drop table blabla; Query OK, 0 rows affected (0.00 sec) mysql> show tables; Empty set (0.00 sec) mysql> create table blabla ( fname varchar(15) not null )type=innodb; Query OK, 0 rows affected (0.00 sec) mysql> show tables;

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 si

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

like to know 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 Sincere

ERROR 1005 at line 3: Can't create table '.\company\employee.frm' (errno: 150)

I DO ? mysql> SHOW VARIABLES LIKE "have_innodb"; +---+---+ | Variable_name | Value | +---+---+ | have_innodb | YES | +---+---+ 1 row in set (0.00 sec) mysql> Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For li

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

keyboard, now please, 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 explicit

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

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\bin>type constraint.sql USE company; DESCRIBE EMPLOYEE; SHOW CREATE TABLE EMPLOYEE; ALTER TABLE EMPLOYEE TYPE = Inn

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

ion 5.00.2195] This seems fine to me, I believe 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 Sincerel

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

rsion 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

Constraints under 3.23.55-nt

oes not give me feedback 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

schema and Catalog under MySQL 3.23.55

mpany_00 authorization administrator; === it seems to me 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

ror. 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 Gulbrand

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]

3.7 Queries from Twin Project Taken from the Documentation tutorial

dummy 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]

comp-err.exe

ike 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

Anywhere 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

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

ent_id ) as max 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 understa

Transaction with InnoDB - how to lock?

rrent user 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 manua

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

? -- 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 &

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 Se

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