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 UUID()

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 record

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

Re: monitor multiple mysql servers with no 3306 access

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: 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: drop stored procedures in prepare statment

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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Google like search string to be implemented

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.mysql.com

Re: Adding a new autoincrement field to an existing table

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

. 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: unauthenticated user

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.mysql.com/mysql

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: Growing innodb size

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 ;) regards Nils -- MySQL

Re: mysqld got signal 11;

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

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

Re: SQL_CALC_FOUND_ROWS using ODBC driver

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

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: 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.mysql.com/mysql

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

://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://lists.mysql.com/mysql To unsubscribe:http

Re: How to cast a column ?

. 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 column there. regards Nils

Re: Query headaches

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 joined upon. So you have to add products to the from clause. regards Nils -- MySQL

Re: Query Two Databases

.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 | cell +49-(0)175-9331740

Re: Load Balance on MySql

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)

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?

. 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

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

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

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

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]

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

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 following site stops

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

Recreating primary index on MyIsam table

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

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

MySQL Users Conference 2005 - Call for Papers is Open

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/ -- MySQL General Mailing List

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 2004 12:39

Re: what os to use for mysql on amd64?

? 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, Recently our company has purchased a dual

Re: Change Character Set for one user

. 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 .my.cnf option file ?? thx's -- MikemickaloBlezien

Re: User Conference 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:http://lists.mysql.com/[EMAIL PROTECTED]

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 that online documents at www.

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

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

Re: Version 4.1.1

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: 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: CRASH AND ROLLBACK SIMULATION

to 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/mysql/ -- MySQL General

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've just installed

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

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 2003 01:22, you

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

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

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. Thanks though

Re: ANN: Database Workbench 2.4 released

-- 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 MySQL Download a trial: http://www.upscene.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 - Hi Nils, How do I install this tool on a Unix, Linux or BSD based machine ? The tool itself is Windows based - however, people

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 -- Forwarded Message -- Subject: Re: ANN: Database Workbench 2.4 released Date: Monday 10 November 2003 21:08 From: Martijn

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 22:15 From: Martijn

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

Setting up user acounts in 4.0.16

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]

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

Re: Setting up user acounts in 4.0.16

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) -- Nils Valentin Tokyo/Japan http

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: Mysql Online Backup.

/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 need more details. Best regards Nils Valentin Tokyo/Japan Regards, Chris P.S. Keep up the great work over

Re: Mysql Online Backup.

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 suited they are to your needs. For mine they work well, but if I was processing 600 queries / second, I think I'd want

Re: Mysql Online Backup.

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 to how well suited they are to your needs. For mine they work well, but if I was processing 600 queries / second

Re: Mysql Online Backup.

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 to how well suited they are to your needs. For mine

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 2003 8 26

Re: own privileges

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

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:45sanjay gupta : Hi all , can anybody tell me the differance between

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:25Thomas Andersson : Hmm This is not nice.. I posted on this list, and within seconds I got spam from some phone company which was a reply

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

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

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

/ | +++ 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://lists.mysql.com/[EMAIL

Re: mysqlbinlog question

Hi Victoria, 2003 8 21 16:09Victoria 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 not show me the whole binary logfile but just the first line or so

Re: mysqlbinlog question

Hi Victoria, 2003 8 21 20:20Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: 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

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

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 trying

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 8

Re: Query with inner join (Help!)

customers.cust_id = 2; That should wrap it up nicely ;-). Best regards Nils Valentin Tokyo/Japan 2003 8 15 16:44B. Fongo : Hello! I ' m trying to extra some information from 2 tables using inner join, but receive an error warning. Am newbie so I' m not able to feature out why my

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:36Lefevre, Steven : Hey folks - Thanks to everyone who gave input to my concerns. Of course, we don't intend to have the mysql port open

Re: escape sequence question

Hi Roger, 2003 8 14 19:33Roger Baklund : * Nils Valentin I have problems understanding why the below two commands would return the same result. [...] mysql select * from sensei where link like '/var/www/html/xoops/2003\'s sum'; [...] mysql select * from sensei where last_name

Re: A final Windows MySQL PHP plea

Hi Andrew, I guess your reply was meant for Gary (the original poster of this e-mail). I will foward your request to the mailing list. Best regards Nils Valentin Tokyo/Japan WOW!!! That kind of System Power and you are wasting it on Windows and IIS E! Sorry - but Dual

Re: Multiple field updates

;-) Best regards Nils Valentin Tokyo/Japan 2003 8 13 21:29Rudi Ahlers : Great thanx, this one worked wonders Kind Regards Rudi Ahlers +27(82) 926 1689 The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man

Re: Multiple field updates

Hi Cybot, Thank you for spotting that. I was a bit careless ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 12 19:23Cybot : Nils Valentin wrote: Hi Rudi, I would go for the UPDATE ...SET... syntax. http://www.mysql.com/doc/en/UPDATE.html Something like UPDATE tblname SET

Re: Fwd: Dynamic enabling of log files

Nils Valenin Tokyo/Japan 2003 8 13 13:30Prem Soman : Note: forwarded message attached. Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- --- Valentin Nils

Re: Reading table structure and data from sql file.

does what is says only one database will be updated (default database). Seems like for now editing the backup file is the fastest solution (on a command line). Best regards Nils Valentin Tokyo/Japan 2003 8 13 03:54Binay Agarwal : Hi Nils , Thanks for quick reply. I know already about

Re: Dropping primary key/unique key

Hi Victoria, Victoria Reznichenko wrote: Nils Valentin [EMAIL PROTECTED] wrote: I have a problem understanding why MySQL is deleting a unique key instead of a primary key. from Documentation: DROP PRIMARY KEY drops the primary index. If no such index exists, it drops the first UNIQUE

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

James Fryer wrote: At 10:17 am 14/08/03, Nils Valentin wrote: The simple answer would be that the syntax says: http://www.mysql.com/doc/en/UNION.html SELECT... UNION... SELECT... Further down the page it says If you want to use an ORDER BY for the total UNION result, you should use

Re: Advanced text search

Hi Rudy, I believe you just forgot a dot here in front of the +: phone=.+27-21-* Best regards Nils Valentin Tokyo/Japan 2003 8 13 15:25Rudi Ahlers : Hi I'm trying to search for some tables in a database, that contains only certain parts of info. I have about 3000+ records, and I'm

Re: Index existence

Hi Ian, mysql SHOW INDEX FROM tbl_name; Best regards Nils Valentin Tokyo/Japan 2003 8 14 12:13Ian Collins : Is there any way of determining the existence of an index? I have a colleague messing about porting an application from MS SQLServer to MySQL 5 (compiled from the source

Re: Designing a secure database?

Hi Steve, I understood that usually the data required to connect to a db is stored in a outsorced php file. For mysql clients you can define usernamepassword etc. in the my.cnf configuration file, but I am not sure if a PHP client would access this file. Best regards Nils Valentin Tokyo

Re: Multiple field updates

Hi Rudi, I would go for the UPDATE ...SET... syntax. http://www.mysql.com/doc/en/UPDATE.html Something like UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 3999 AND 8001; Best regards Nils Valentin Tokyo/Japan 2003 8 12 18:38Rudi Ahlers : Hi Can someone please tell me howto

Re: Error Code 28?

-queries), or from the ASP side perhaps a time limit etc. Best regards Nils Valentin Tokyo/Japan 2003 8 13 01:00: Hey Nils,. Is there a way I can set error checking on a page? I have a test mySQL db that displays all the records in an ASP page. It works without a problem (it's only 10 records

Re: A final Windows MySQL PHP plea

the one or the other useful tip. http://www.dell.com/us/en/biz/topics/power_ps2q03-jaffe.htm Best regards Nils Valentin Tokyo/Japan 2003 8 13 01:21Gary Broughton : Hi all Is there anybody out there who has managed to successfully configure Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI

Re: escape sequence question

Hi Roger, Thanks for the thorough explanation. I think I got it now ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 14 20:47Roger Baklund : * Roger Baklund They both look for 2003's. * Nils Valentin Thats what I also thought at first sight, but there seems to be more

Re: alter table froze entire machine!

Hi Dan, Just a guess though, but you are sure you have PLENTY of harddisk space laying around ? If not that would perfectly explain the behaviour. Best regards Nils Valentin Tokyo/Japan 2003 8 13 08:19Dan Edwards : Hi about 2 months ago I had trouble with alter table on large tables

Re: alter table froze entire machine!

in the archive you should find a message from heikki Thuri stating something like this. Best regards Nils Valentin Tokyo/Japan 2003 8 13 13:42Dan : Ya plenty of freespace, 27 gigs, that one has got me before though. Thanks! Dan Nils Valentin wrote: Hi Dan, Just a guess though, but you

Re: Joins and Unions

- but only applied for a certain column. Thats not possibe yet I believe. Best regards Nils Valentin Tokyo/Japan 2003 8 13 14:16Kim 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 joins. The situation I have is not one where I need

  1   2   3   4   >