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

Hi David, (B (BThank you for the detailed description. That certainly makes things easier to (Bargue now ;-). (B (BO.K Where to start ? (B (BFirst, as you know in version 4.0 you can basically set the character sets (Bonly for server and client side (not for DB, table, columns,

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

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

Hi Prem, That question was just here 2 days ago, so easy to answer. ;-) Logs can be enabled/disabled for the session with SET SQL_LOG_OFF | SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in v3.23.52: http://www.mysql.com/doc/en/SET_OPTION.html Best regards

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

Re: Foreign Keys

) 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 should work. Best regards Nils Valentin

Re: MD5-read permission?

2003 8 14 12:50Nils 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 somewhere. Best regards Nils Valentin Tokyo/Japan

Re: Root

ON *.* TO 'root'@'%' indentified by 'my_password' with grant option; Best regards Nils Valentin Tokyo/Japan 2003 8 8 13:59FT : Thanks Nils, Now that phpmyadmin is working ..I can do just about everything on my db...but when I try to log on on the server by typing : myself it still

Re: Dropping primary key/unique key

need NULL in a key, use UNIQUE instead mysql drop table uksample2; Query OK, 0 rows affected (0.00 sec) Best regards Nils Valentin Tokyo/Japan 2003 8 6 19:22Victoria Reznichenko

Re: How can I enable unicode and japanese support?

which you can use. Not all functions are yet double byte safe. The manual is discusssing this in more details. Best regards Nils Valentin Tokyo/Japan 2003 8 6 22:[EMAIL PROTECTED] : I am using cold fusion to make a small custom website using mysql to store the information a user inputs. I

Re: Tricky INSERT

Hi Fraser, I a sorry I dont understand what you want to do. Could you show how you want it to be and the queries which you used so far ? Best regards Nils Valentin Tokyo/Japan 2003 8 13 08:30Fraser Hanson : I have table A with column id, and table B with columns id and content. I am

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. :) However, I tried creating a few indexes in the db

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

this also in each SELECT statement. Best regards Nils Valentin Tokyo/Japan 2003 8 14 18:06James Fryer : At 09:47 am 14/08/03, Jim Smith wrote: But why do you need the parentheses? This was a simplified query for example purposes. The real query looks more like (SELECT ...) UNION

Re: Root

must be mysql GRANT ALL ON *.* TO 'root'@'hostname' indentified by 'my_password' with grant option; Note that the username and hostname are in separated single quotes. Sorry for that confusion. Why did nobody correct me ??? never mind ;-) Best regards Nils Valentin Tokyo/Japan Try it again

Password formats 3.23-4.x

Hi MySQL fans ;-), I tried to get some experience with converting between the different password formats as describd here: http://www.mysql.com/doc/en/Password_hashing.html So I took this sample mysql UPDATE user SET Password = OLD_PASSWORD('mypass') - WHERE Host = 'some_host' AND User =

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:28MightyData : How can I find a download for MySQL 4.0.13? I looked

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

BY e_mail; Best regards Nils Valentin Tokyo/Japan 2003 8 14 17:04James Fryer : Assuming a legal SELECT statement, this works fine: CREATE TABLE Foo SELECT ... but this does not: CREATE TABLE Foo (SELECT ...) This is a problem for me as I'd like to use the output of a SELECT...UNION

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:07Lefevre, Steven : Hey folks - While contemplating the design

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

escape sequence question

Hi MySQL Fans ;-), I have problems understanding why the below two commands would return the same result. 1) mysql select * from sensei where link like '/var/www/html/xoops/2003\'s sum'; +---++-+---+ | instructor_id | llink

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:39Nils Valentin : Hi Rudy, I believe you just forgot a dot here in front of the +: phone=.+27-21-* Best regards Nils Valentin Tokyo

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:13Binay Agarwal : Hi everybody, I

Re: Joins and Unions

, 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 regards Nils Valentin

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 Hi Daniel and Kim, Isn't

Re: Joins and Unions

a 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 to change the way the data

Re: Joins and Unions

; mysql SELECT * FROM table1 LEFT JOIN table2 USING (id); Best regards Nils Valentin Tokyo/Japan 2003 8 13 09:25Kim 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 possible to create a union using the logic of a join? I have 4

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:47Cabanillas Dulanto, Ulises : The option Automatically limit SELECT queries to must be set in the Query Configuration Dialog

Re: NT service starts, but I still have to start server manually.

. ;-) Thats all really I can remember 1) mysqld --install 2) net start mysql 3) checking if the mysql servie is set to automatic startup in the services processlist. I hope that this helps a bit. Le me know how it went. Best regards Nils Valentin Tokyo/Japan 2003 8 11 19:50Tony Groves : Nils

Re: Dropping primary key/unique key

(0.00 sec) Best regards Nils Valentin Tokyo/Japan 2003 8 6 19:22Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: Hi Victoria, Victoria Reznichenko wrote: Nils Valentin [EMAIL PROTECTED] wrote: I have a problem understanding why MySQL is deleting a unique key

Re: column privilege problem--Solved

'@'localhost' IDENTIFIED BY 'columnuser'; Best regards Nils Valentin Tokyo/Japan Dathan Vance Pattishall wrote: FYI Note on this. Using column privs you take a performance penalty on reads / writes. ---Original Message- --From: Tiffany Wilkes [mailto:[EMAIL PROTECTED] --Sent: Tuesday

Re: Root

password) That should be it. Mysql has a nice manual by the way where it is all described detailed, comes in very handy to have such a print close, just in case ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 3 14:21FT : Hi everyone I am quiet new to DB and MySql I must have made a big

Re: ansi characters in Fulltext search

Forgot to copy the list ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 4 07:45Nils Valentin : Hi Kevin, Correct me if I am wrong, but the sweddish character set is the default setting with mysql ;-). I was supposing that includes the most or all scandinavian characters. Best regards

Re: Granting privileges

Nils Valentin Tokyo/Japan Many thanks Todd Nils Valentin wrote: Hi Todd, try this grant all - on *.* - to todd indentified by 'my_password' - with grant option; I believe you forgot the .* wich I added after grant all on... Best regards Nils Valentin Tokyo/Japan

Re: Granting privileges

Nils Valentin Tokyo/Japan That definitely works, but what I am not sure about is now -u todd -h localhost has all Y in the privileges; before only the first few had Y. Why is that? Is that due to the *.*? Todd Jamie Krasnoo wrote: You still need to flush the privileges. Changes

Re: Root

: mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password' with grant option; If the user doesn't need to create new users than you can leave with grant option. Best regards Nils Valentin Tokyo/Japan Thanks - Original Message - From: Nils Valentin [EMAIL

Re: Granting privileges

you have very restricted rights. Try SELECT USER() to see which user account mysql is using currently. Then use the SHOW GRANTS FOR command to see which privileges are set. Best regards Nils Valentin The % in the Host column does not appear to work for me, and there is something different

Re: help regarding mysql

2003 8 2 15:11: Hi frnd. I am also using mysql and facing problems regarding access to the db using odbc from visual basic. i have made a table under mysql default db and used ms ado to connect to the db. what will be the server name in such a case(that will be used to connect to the

Dropping primary key/unique key

Hi Mysql fans ;-); 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 index in the table. When I do it then I get this: mysql desc

  1   2   3   4   >