Re: Unique Id generation

> Why would the auto_increment not work for you? The only case where you > would have a problem is if the last record was deleted before mysql > shutdown. If you are really concerned about this unique scenario, > insert a dummy record before shutdown to guard against it and delete > the dummy reco

Re: RE: Unique Id generation

> >I try to generate a unique id for each row in a Mysql-InnoDB Table. > >Because of many deletes I can't use an auto_increment column. > >After a Mysql restart, the next value for an auto_increment-column is > >max(auto_increment-column)+1, and I need a really unique id. > > > [JS] See if the

Unique Id generation

Hi all, I try to generate a unique id for each row in a Mysql-InnoDB Table. Because of many deletes I can’t use an auto_increment column. After a Mysql restart, the next value for an auto_increment-column is max(auto_increment-column)+1, and I need a really unique id. My first solution looks

Re: Weighting searches

Hi John John Nichel wrote: The db is MySQL 4.1.20 and the column synonyms_misspellings has a FULLTEXT index on it (the db is set to index on 3 characters). Can anyone help me understand why it's not rating the one with the match three times higher than the one with the match twice, and point

Re: monitor multiple mysql servers with no 3306 access

olled and polls the MySQL instances via local socket. nagios or hyperic HQ [1] can do that. Hyperic HQ looks a lot cooler than nagios. regards Nils [1] http://www.hyperic.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: drop stored procedures in prepare statment

re > statment. > > Is it a lack of feature in MySQL-5.0 version ?? Exactly. MySQL doesn't support dropping/creating functions/procedures or triggers in functions or triggers. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Google like search string to be implemented

" I think MySQL fulltext search in boolean mode would be the perfect choice for that: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html You can use search strings like your example with that directly. regards Nils -- MySQL General Mailing List For list archives: http://lists

Re: Adding a new autoincrement field to an existing table

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

Re: Disk parition full

5.1 series. You can use symbolic links to move some databases or even tables to another location. Other solution might be to move *all* databases to /var and change the datadir setting in my.cnf accordingly. Regards Nils [1] http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html

Re: InnoDB: Assertion failure

ernel. You have to decrease mysql memory usage. regards Nils (I have a dejá-vu here, did you post that question before?) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Growing innodb size

;ll see how it has been set up. Do you want a fixed size or should it grow automatically? Anyways, you might want to check this documentation: http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html NOTICE: You should not send privileged and confidential information to a maillinglist ;)

Re: Mysql and FOREIGN KEY

Hi, Micol lupen wrote: FOREIGN KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio) ^^^ check here! ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB; No comma before REFERENCES. REFERENCES is part of the foreign key definition. regards Nils -- MySQL General

Re: unauthenticated user

| That's just fine. The user is in login state, so he/she/it is not yet authenticated. There might be a DNS issue slowing down login, you might check if you can reverse lookup the hostnames of the connecting users. regards Nils -- MySQL General Mailing List For list archives: http://lists.

Re: mysqld got signal 11;

Michael Fernández M. wrote: Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. Sorry, but why do you say that?, because of the 32 bits kernel? Yes exactly. Depending on kernel version you can allocate something between 2 or 2.7GB. Until 2GB it's sa

Re: mysqld got signal 11;

value) and yesterday i increased to 500MB. But i did not touch the innodb_buffer_pool_size this still have 8 MB. Your buffer pool is a bit small, if you use innodb heavily. The innodb_additional_mem_pool is way to large I think the size could be lowered to something around 30MB. regards Nils

Re: mysqld got signal 11;

ocate about 2GB of RAM in total. You might want to check that. How big is your InnoDB buffer pool? regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL_CALC_FOUND_ROWS using ODBC driver

Nils Meyer wrote: > SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. LIMIT, not where. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL_CALC_FOUND_ROWS using ODBC driver

ECT FOUND_ROWS() returns exactly one record *CONTAINING* the number of found rows. So you have to access the resultset to get the actual number of rows. SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. regards Nils -- MySQL General Mailing List

Re: NOT EMPTY, like NOT NULL

Hi Js, js wrote: Is there any easy way to implement 'NOT EMPTY' constraint? There currently is no support for CHECK Constraints in MySQL, at least to my knowing. So you'd have to go with a trigger. regards Nils -- MySQL General Mailing List For list archives: http://lists.mys

Re: error 99(?) : can't connect to MySQL server

me more insight on that topic: http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ Don't be confused with the PHP mentioned, the first paragraphs apply to TCP/IP and mysql as whole. regards Nils -- MySQL General Mailing List For list archives: http://li

Re: Query headaches

id && item_status.supplier_id = i.supplier_id && item_status.group_id = 1) WHERE i.product_id = products.product_id && i.item_stock > 0 the field products.product_id is not defined at this place, because the subquery is specified in the field list and not join

Re: How to "cast" a column ?

a VARCHAR. This doesn't seem to make sense if this is not a very rare corner-case. Either both columns should be INT or VARCHAR. BTW, how can I get the number of rows examined (like in slow queries log) from mysql command line ? Run: EXPLAIN [query] have a look at the "rows" co

Re: Query Two Databases

ECT * FROM db2.table) If db2 on a other mysql server, it is possible to use the federated storage engine of MySQL. - -- Nils Jünemann Database and System Administration studiVZ | Saarbrueckerstr. 38 | 10405 Berlin | phone +49-(0)30-405042715 www.studiVZ.net | fax +49-(0)30-28093887 | ce

Re: Load Balance on MySql

. Do you store the content in the database or just links to files? regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql data into CSV file. / (Errcode: 13)

t write to your home directory. Try using /tmp instead or some dir mysqld can write to. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does Update allow for aliases?

e SQL. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySSQL on HP-UX

ts! Did you do that? Is there a user called "mysql"? regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Trying to create a new table in memory.

wrong? You use the memory storage engine If I am getting it right? Does MySQL report that it's out of memory (table full error) or does the OS do so? Are there any indexes (might double the data for your small table)? regards Nils -- MySQL General Mailing List For list archives:

SV: Determine version of *.frm, *.MYD and *.MYI

Well... It did document it In my wiki... which is gone... Nils -Oprindelig meddelelse- Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: fr 05-05-2006 21:57 Til: Nils Lastein Cc: mysql@lists.mysql.com Emne: Re: Determine version of *.frm, *.MYD and *.MYI No backups? And you

SV: Determine version of *.frm, *.MYD and *.MYI

I know it a 4.1... But as I compiled it my self it is not so easy to figure it out And it might take a while to trial-n-error all 4.1.x Nils -Oprindelig meddelelse- Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: fr 05-05-2006 20:28 Til: Nils Lastein Cc: mysql@lists.mysql.com

Determine version of *.frm, *.MYD and *.MYI

annot be read Unfortunately I'm unable to access the disk anymore, so I cannot see what version of the server generated these. How do I do that? Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help

Hi Shreedjhar, Are you aware of this paper ? http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf It may perfectly answer most of your questions. Best regards Nils valentin Tokyo / Japan http'//www.be-known-online.com On Saturday 18 June 2005 22:01, mad

Re: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

-new-mysql-user.php I hope that you find this info useful. Best regards Nils Valentin Tokyo / Japan http;//www.be-known-online.com On Tuesday 14 June 2005 06:58, Yannick wrote: > Kevin, > > In addition to that, the ZORUM database works because when I stop mysql, > the followin

Re: Recreating primary index on MyIsam table

Hi Peter, thanks a bunch, I new that it must have been something simple like this. I am just no programmer. ;-) Thanks a bunch !! Best regards Nils Valentin Tokyo / Japan On Sunday 10 April 2005 23:41, Peter Brawley wrote: > Nils, > > >So the task is to recreate the current

Recreating primary index on MyIsam table

shouldnt be too difficult, but perhaps I am just too long in front of the screen. ;-) Best regards Nils Valentin Tokyo / Japan www.be-known-online.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Users Conference 2005 - Call for Papers is Open

r set issues, which will allow to explore the issues described with national characters more detailed. Anybody interested in this kind of topic ? Note: No need to reply if not, otherwise my mail server might crash ;-) -- Greetings from Tokyo Nils Valentin http://www.be-known-online.com/mysql/ -

Re: what os to use for mysql on amd64?

L now? Opteron? OpenBSD? SuSE?" I am sure that anybody will appreciate any comments on the hot discussed topic. Best regards Nils Valentin Tokyo/Japan www.be-known-online.com/mysql --- > On Tuesday 27 July 2004 12:39, bad corn wrote: > > Hi all, > > > > Rec

Re: what os to use for mysql on amd64?

Hello MC, any results yet by any chance ? What conclusion did you get out of your test ? There is another threat going on with the subject line "Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?" Best regards Nils Valentin Tokyo/Japan On Tuesday 27 July

Re: Change Character Set for one user

elps a bit. Best regards Nils Valentin Tokyo / Japan On Monday 10 May 2004 23:42, Mike Blezien wrote: > Hello, > > is it possible to change the default character set for one mysql user > without affecting the global character set setting, via the the user's > .m

Re: User Conference Presentations

the presentations? They were supposed to be on the website at > the end of last week. > > Thanks -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Re: Documentation on character sets for version 4.0.17

regards (B (BNils Valentin (BTokyo / Japan (B (B (B (B (BOn Wednesday 05 May 2004 04:05, David Jourard wrote: (B> Nils, (B> (B> At 05:30 PM 5/4/04 +0100, you wrote: (B> >Basically the best guess would be the documentation that comes with your (B> >download. Note t

Re: Documentation on character sets for version 4.0.17

Hi David, (B (BYou may find my UC-2004 presentation useful as well as some UC-2003 (Bpresentations from Mr. Gulutzan and Mr. Barkov: (B (Bwww.be-known-online.com/mysql (Bmysql.planetmirror.com/Downloads/Presentations/MySQL-User-Conference-2003/National-Character-Sets-and-Unicode.pdf (B (BB

Re: Auto Increments and Other Keys

> All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables. > > I'm trying to add the auto_increment attribute to column in a table that > already has a primary key defined. Here is the table I'm trying to > create: > > > CREATE TABLE IF NOT EXISTS dataTypes ( > id int unsigned NOT NULL AU

Re: Version 4.1.1

, > Dan -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CRASH AND ROLLBACK SIMULATION

review one of those preprints, all I can say so far is "Very impressive", you will see for yourself.. On Friday 14 November 2003 00:58, nm wrote: > Do you know how to test a crash and a rollback? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysq

Re: Innodb: Can't init databases

Hi Hsiu-Hui, I havent followed the threat, excuse if this was mentioned before. Did you try to start the server with the --skip-innodb option yet ? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Thursday 13 November 2003 17:38, Hsiu-Hui Tseng wrote

Re: Error 1045: Access denied...

I get your point Patrick. I was customer support engineer myself. You cant always think about all eventualities can you ;-), its really hard and needs a special way of thinking. Anyway that little "lesson" saved my day. ;-) Thanks a lot. Nils Valentin On Thursday 13 November

Re: Error 1045: Access denied...

Hi Patrick How true ;-) hohohoho Sorry for my really bad English, I just imagine that you might have had an experience already from somebody taking it literally ?? I will try to avoid it. Thanks for the warning ;-) Best regards Nils Valentin On Thursday 13 November 2003 01:13, Patrick Dowd

Fwd: Re: Error 1045: Access denied...

Hi Fernando; you are logged in as anonymous user. log into mysql like this mysql -u root -p Hit enter if no password is set yet. -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Thursday 13 November 2003 00:47, Fernando wrote: > Hello, > i&#

Fwd: Re: Error 1045: Access denied...

Hi Fernando; you are logged in as anonymous user. log into mysql like this mysql -u root -p Hit enter if no password is set yet. -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Thursday 13 November 2003 00:47, Fernando wrote: > Hello, > i&#

Re: Setting wait_timeout in my.cnf?

Hmm. You could try show variables like "%timeout%"; perhaps interactive_timeout can help you out ? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Tuesday 11 November 2003 21:37, Hoeven, Maarten van der wrote: > nope, that didnt help.

Re: Setting wait_timeout in my.cnf?

Hi Maarten, I havent tried it recently but substitute any underbar (_) with a hiven (-) when doing a setting in the my.cnf. -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Tuesday 11 November 2003 20:22, Hoeven, Maarten van der wrote: > correction: sect

Re: MaxDB Release?

Hello Iago, I dont know anything, but I remember that a while back (3 months ago) some people mentioned that the 15th November should be a remarkable day for a MySQL announcement. Wether this is true or not I dont know. Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com

Fwd: Re: ANN: Database Workbench 2.4 released

Hi List members,  I just forward this for completeness of the thread . Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql -- Forwarded Message -- Subject: Re: ANN: Database Workbench 2.4 released Date: Wednesday 12 November 2003 01:26 From: Nils

Fwd: Re: ANN: Database Workbench 2.4 released

Hi List members,  I just forward this for completeness of the thread . Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql -- Forwarded Message -- Subject: Re: ANN: Database Workbench 2.4 released Date: Monday 10 November 2003 22:15 From: "Ma

Fwd: Re: ANN: Database Workbench 2.4 released

Hi List members,  I just forward this for completeness of the thread . Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql -- Forwarded Message -- Subject: Re: ANN: Database Workbench 2.4 released Date: Wednesday 12 November 2003 01:00 From: Nils

Fwd: Re: ANN: Database Workbench 2.4 released

Hi List members,  I just forward this for completeness of the thread . Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql -- Forwarded Message -- Subject: Re: ANN: Database Workbench 2.4 released Date: Monday 10 November 2003 21:08 From: "Ma

Fwd: Re: ANN: Database Workbench 2.4 released

Hi List members,  I just forward this for completeness of the thread . Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql -- Forwarded Message -- Subject: Re: ANN: Database Workbench 2.4 released Date: Tuesday 11 November 2003 23:47 From: Nils

Fwd: Re: ANN: Database Workbench 2.4 released

Hi List members, I just forward this for completeness of the thread . Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql - Hi Nils, > > > How do I install this tool on a Unix, Linux or BSD based machine ? > > > > The tool itself is Wi

Re: ANN: Database Workbench 2.4 released

gards -- Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Monday 10 November 2003 19:01, Martijn Tonies wrote: > Ladies, gentlemen, > > There's a new tool in town - Upscene Productions is > proud to announce: > > "Database Workbench for

Fwd: Re: WANTED: lots of data

Hi Mark, I understand that Dbvisualizer 4.0 has this function built in. There is a trial version available at www.minq.se I hope that helps Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Saturday 08 November 2003 16:37, Mark Horton wrote: > I'm wo

Fwd: Re: Setting up user acounts in 4.0.16

Of course. That was it ;-) I completely forgot about that for a moment. I looked in the wrong place, oooh no... Thanks a lot, (such a shame I didnt realize first)... Best regards Nils Valentin Tokyo/Japan On Thursday 06 November 2003 23:23, gerald_clark wrote: > You set db privileges,

Re: Setting up user acounts in 4.0.16

_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 1 row in set (0.00 sec)

Fwd: Re: Setting up user acounts in 4.0.16

Hi Thierno, you are right that the synatx I gave you is not correct. Thank you for pointing this out. I made the mistake when typing the e-mail ;-) However the original problem stays. It doesnt write the privileges (on my machine). Best regards Nils Valentin Tokyo/Japan On Thursday 06

Setting up user acounts in 4.0.16

. Can anybody copy me on that ? Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Online Backup.

2003年 8月 28日 木曜日 01:43、Nils Valentin さんは書きました: > Hi Chris, > > 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました: > > A very good question! One which I will attempt to provide a half-decent > > answer for. > > > > Trying to execute a transaction that involves grabbing

Re: Mysql Online Backup.

d no locks are written it also says under 3) how it locks and unlocks the tables. I guess thats best explained by Heikki ;-) - I copied her. Best regards Nils Valentin Tokyo/Japan > > In summary, it's not a question as to whether the current methods work, > it's a question as t

Re: Mysql Online Backup.

uct is providing this feature by using the actual row locks to make sure that ACID is taken care of while creating a consistent backup. Best regards Nils Valentin > > In summary, it's not a question as to whether the current methods work, > it's a question as to how well sui

Re: Mysql Online Backup.

xoops, basically a normal webpage, etc. The difference of all these tools is a) how they accesss and lock the tables/data you want to backup b) the format of the output file (txt,sql format, binary etc. c) the supported features I hope this answers some of your questions. Let me know if you ne

Re: Case sensitive indexes

Hi Gord, I understood that searches in general arecase insensitive (but I might be wrong of course). Try to use the word "BINARY" when creating the table or when making a SELECT. I am not sure how you would have to apply this to the index. Best regards Nils Valentin Tokyo/Japan

Re: own privileges

*.* TO 'root | ++ 1 row in set (0.09 sec) Best regards Nils Valentin Tokyo/Japan 2003年 8月 25日 月曜日 21:[

Re: differance between InnoDB and MyISAM tables ?

Hi Sanjay, I made a chart which shows the tables and their supported functions. Please have a look here: http://www.knowd.co.jp/staff/nils/ I hope this helps. Best regards Nils Valentin Tokyo/Japan 2003年 8月 22日 金曜日 18:45、sanjay gupta さんは書きました: > Hi all , > > can anybody te

Re: Spam from this list

Hi Thomas, I report this stuff always to [EMAIL PROTECTED] and 20 minutes later its gone ;-) Best regards Nils Valentin Tokyo/Japan 2003年 8月 23日 土曜日 22:25、Thomas Andersson さんは書きました: > Hmm > > This is not nice.. I posted on this list, and within seconds I got spam > from some p

Bug Report

hi There is a Bug in the InstallWizard Engine. If I install mysql on my winxp professional system WITHOUT sp1, install shield say goodbye when the setup is almost ready. i've tried custom and completly installation. maybe its a failied download. the mysql version is: mysql-4.0.14b-win.zip cya

Re: mysqlbinlog question

Hi Victoria, 2003年 8月 21日 木曜日 20:20、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > 2003? 8? 21? ??? 16:09?Victoria Reznichenko : > >> "Nils Valentin" <[EMAIL PROTECTED]> wrote: > >> > This

Re: mysqlbinlog question

Hi Victoria, 2003年 8月 21日 木曜日 16:09、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat > > 9. > > > > When I issue the command mysqlbinlog it does n

SHOW VARIABLES LIKE '%dir%'; (basedir and datadir)

| /tmp/ | +++ 9 rows in set (0.04 sec) Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

mysqlbinlog question

Start: binlog v 4, server v created 700101 9:00:00 I understood that I can use the tool to view the whole binary log data. Am I mistaken ? Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: mysqldump w/o password

Hi Asif, Just a guess, but how about [mysqldump] password = PASS ?? Best regards Nils Valentin Tokto/Japan Asif Iqbal wrote: Hi All I have to run this to dump the database mysqldump -u root -pPASS --opt database > database.tmp Is there anyway I can hide the PASS is a file ? I was try

Re: Fwd: Dynamic enabling of log files

Hi Prem, Which version are you curently using 3.23.xxx ?? Whats the XXX in your version ??? What do the change log files say at the www.mysql.com homepage ? Best regards Nils Valentin Tokyo/Japan Prem Soman wrote: Thanks neils! i have gone thru what u referred long before, i know that

Re: Secure Database Design Part II

always double check the correctness of the distrubutor table (as long as they are in sync ;-) Best regards Nils Valentin Tokyo/Japan 2003年 8月 16日 土曜日 05:36、Lefevre, Steven さんは書きました: > Hey folks - > > Thanks to everyone who gave input to my concerns. Of course, we don't > i

Re: Query with inner join (Help!)

Hi Fongo, Steve gave a perfect explanation ( and made me realize my and Egor's small mistake ;-) 2003年 8月 15日 金曜日 17:08、Nils Valentin さんは書きました: > Hi Fongo, > > http://www.mysql.com/doc/en/JOIN.html > > > Should work like this (untested): > > SELECT C

Re: Query with inner join (Help!)

Hi Fongo, http://www.mysql.com/doc/en/JOIN.html Should work like this (untested): SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from Customers, Orders WHERE Customers.cust_id = Orders.cust_id AND cust_id = 2 inner join Best regards Nils Valentin Tokyo/Japan 2003年

Re: MySql Control Center

Hi Ulises, Is that option only available on a Windows MySQLCC ?? I didnt find it on the linux version. Best regards Nils Valentin Tokyo/Japan 2003年 8月 9日 土曜日 01:47、Cabanillas Dulanto, Ulises さんは書きました: > The option "Automatically limit SELECT queries to " must be set i

Re: Joins and Unions

le2.id; mysql> SELECT * FROM table1 LEFT JOIN table2 USING (id); Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 09:25、Kim Kohen さんは書きました: > G'day all, > > I'm pretty new to MySQL and very new to v4. > > This is probably going to sound strange, but is it poss

Re: Joins and Unions

HEAP table which remains completely in the memory, but all data goes when the server crashes or powered off, the structure remains. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 15:21、あなたは書きました: > G'day Nils > > > just send a reply a minute ago. I got it now. You want

Re: Joins and Unions

regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 14:[EMAIL PROTECTED] さんは書きました: > well i'd like to join tables without duplicates, currently i cannot do this > unless i select the category table in a second loop to list all the > categories for that particular row/record > >

Re: Joins and Unions

s which exits in one table, BUT NOT in the other table. So for example: SELECT * FROM products p LEFT JOIN product_cat_join pcj ON p.productID=pcj.productID LEFT JOIN product_category pc ON pc.catID=pcj.catID WHERE pc.catID IS NULL Anybody: Please correct me if I talk rubbish here ;-) Best re

Re: Reading table structure and data from sql file.

Hi Binary, You could either make a new backup of only the table (see mysqldump manual). mysqldump --help Or you edit the backup file you have directly and save it under a new name and use it. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 03:13、Binay Agarwal さんは書きました: >

Re: Advanced text search

Hi Rudy, I have to correct myself. I meant something like ...WHERE phone REGEXP '.+27-21-' Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 15:39、Nils Valentin さんは書きました: > Hi Rudy, > > > I believe you just forgot a dot here in front of the +: > > phone=

escape sequence question

ackslashes and the single backsplash (after the 2003) I understood the first sample looks for ...2003's and the second one for ...2003\'s. or am I wrong ? Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

Hi J smith, Below was my sample not James. For my sample ou will need the brackets or it will give you an error. Hi James, You are right it gives an error, but as J Smith also pointed out in your case you dont need the brackets, in my case you would need it. ;-) Best regards Nils Valentin

Re: MD5-read permission?

Hi Steven, while the general idea sounds not to bad, I guess the "bad guess" would just use a undecrypt function wich they either develop themself or get from somewhere. Best regards Nils Valentin Tokyo/Japan 2003年 8月 14日 木曜日 03:07、Lefevre, Steven さんは書きました: > Hey folk

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

) ORDER BY e_mail; Best regards Nils Valentin Tokyo/Japan 2003年 8月 14日 木曜日 17:04、James Fryer さんは書きました: > Assuming a legal SELECT statement, this works fine: > >CREATE TABLE Foo SELECT ... > > but this does not: > >CREATE TABLE Foo (SELECT ...) > > This is a

Re: MD5-read permission?

2003年 8月 14日 木曜日 12:50、Nils Valentin さんは書きました: > Hi Steven, > > while the general idea sounds not to bad, I guess the "bad guess" would I meant the "bad guys" - what a silly typo ;-) > just use a undecrypt function wich they either develop themself or get from >

Re: Foreign Keys

(id), -> FOREIGN KEY (id2) REFERENCES p2(id))TYPE=InnoDB; Query OK, 0 rows affected (0.01 sec) In you case you haven't indexed IDTr Create table y ( IDTr INT NOT NULL, INDEX (IDTr) constraint FOREIGN KEY IDTr REFERENCES x(ID) )Type=Innodb; That

Re: MySQL 4.0.13 download

Hi Kirk, In case you are on Linux and a TAR file format would be fine then I could help you out. I keeep all 3 version locally and could e-mail it to you directly. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 04:28、MightyData さんは書きました: > How can I find a download for MySQL 4.0

Re: Joins and Unions

only applied for a certain column. Thats not possibe yet I believe. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 14:16、Kim Kohen さんは書きました: > G'day Nils > > Well, I can't speak for Daniel, and I'm not really up on his tables, but > I'm not using left jo

Re: Error Code 28?

Hi Ed, wouldn't that be the same cause >> "no space left on device" ?? A index is using perhaps another 30% of the whole table. Best regards Nils Valentin Tokyo/Tokyo 2003年 8月 13日 水曜日 00:27、あなたは書きました: > Hey Nils, > > I just tried it again, and it worked. :) &

Re: alter table froze entire machine!

the archive you should find a message from heikki Thuri stating something like this. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 13:42、Dan さんは書きました: > Ya plenty of freespace, 27 gigs, that one has got me before though. > Thanks! > Dan > > Nils Valentin wrote: > >

  1   2   3   4   >