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

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

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

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

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

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: 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:30、Fraser Hanson さんは書きました: > I have table A with column id, and table B with columns id

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:19、Dan Edwards さんは書きました: > Hi about 2 months ago I had trouble with alter table

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:47、Roger Baklund さんは書きました: > * Roger Baklund > > > > They both look for "2003's". > > * Nils Valentin > > > Thats

Re: A final Windows MySQL PHP plea

s 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:21、Gary Broughton さんは書きました: > Hi all > > Is there anybody out there who has managed to successfully configure > Win2000, IIS5, MyS

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

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:38、Rudi Ahlers さんは書きました: > Hi > > Can someo

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:06、James 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

Re: Root

for the mysql> GRANT ALL ON *.* TO 'root'@'%' indentified by 'my_password' with grant option; Best regards Nils Valentin Tokyo/Japan 2003年 8月 8日 金曜日 13:59、FT さんは書きました: > Thanks Nils, > > Now that phpmyadmin is working ..I can do just about everyth

Re: Index existence

Hi Ian, mysql> SHOW INDEX FROM tbl_name; Best regards Nils Valentin Tokyo/Japan 2003年 8月 14日 木曜日 12:13、Ian 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

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:25、Rudi Ahlers さんは書きました: > Hi > > I'm trying to search for some tables in a database, that contains only > certain parts

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

Hi FT, 2003年 8月 8日 金曜日 16:15、Nils Valentin さんは書きました: > Hi FT, > > Thats because you specified the wrong host in the syntax below: > > mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password' > with grant option; Just ralized tha

Re: How can I enable unicode and japanese support?

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

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

Re: Reading table structure and data from sql file.

ase" which 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:54、Binay Agarwal さんは書きました: > Hi Nils , > > Thank

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 Nil

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 Cybot, Thank you for spotting that. I was a bit careless ;-) Best regards Nils Valentin Tokyo/Japan 2003年 8月 12日 火曜日 19:23、Cybot さんは書きました: > Nils Valentin wrote: > > Hi Rudi, > > > > I would go for the UPDATE ...SET... syntax. > > > > http:/

Re: Dropping primary key/unique key

All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead mysql> drop table uksample2; Query OK, 0 rows affected (0.00 sec) Best regards Nils

Re: Multiple field updates

;-) Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 21:29、Rudi 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 &g

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

Re: escape sequence question

Hi Roger, 2003年 8月 14日 木曜日 19:33、Roger 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

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

flaming me for that statement. ;-) 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

Re: Dropping primary key/unique key

Update: 2003年 8月 7日 木曜日 17:06、Nils Valentin さんは書きました: > [Warning: LNG TEXT - enjoy ;-)] > > Hi Victoria, > > sorry for the misunderstanding. I just tried to reproduce the sample. While > I have records what I did I did not write down all commands exactly as they > a

Re: column privilege problem--Solved

.student TO 'columnuser'@'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

Re: Granting privileges

| +--+ 3 rows in set (0.00 sec) See the difference ;-). The first line says it all the other two are only dependent sub privileges.

Re: Root

client for details. Here just a rough sample: 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/J

Re: Granting privileges

e the privileges 'manually' with INSERT, UPDATE,DELETE Best regards 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

Re: Granting privileges

er as '[EMAIL PROTECTED]' to limit it to only the one host. Best regards Nils Valentin Tokyo/Japan > > Many thanks > > Todd > > Nils Valentin wrote: > >Hi Todd, > > > >try this > > > >grant all > >-> on *.* > >-> to

Re: ansi characters in Fulltext search

Forgot to copy the list ;-) Best regards Nils Valentin Tokyo/Japan 2003年 8月 4日 月曜日 07:45、Nils 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 o

Re: Root

h-privileges (xxx is your new 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:21、FT さんは書きました: > Hi everyone > I a

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 uksam

  1   2   3   4   >