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 b
Hi Jackie,
I am sorry haven't searched for any documents myself, but I can imagine that
Google will list them up when you search for " OpenOffice MySQL Windows
Setup".
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 28日 月曜日 17:07、jackiesu さんは書きました:
> Thank you very much
Hi Herbert,
the -f/--force option lets you continue with the next command
Thats my $0.0.2.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 28日 月曜日 17:57、H M Kunzmann さんは書きました:
> I use mysqldump to dump my databases to file.
> I then write these files to tape.
>
> I was doing a
Hi Michael,
How many client connections does "mysql> SHOW PROCESSLIST" show you ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 27日 日曜日 22:41、Michael さんは書きました:
> I'm running a series of queries from a Python program using the MySQLdb
> module. The program opens a conn
Hi Mark,
Thanks for the reply. Looks like my next step should be to learn PhP ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 27日 日曜日 16:35、Obantec Support さんは書きました:
> - Original Message -
> From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: "Oban
Hi Ivan,
depending on mark's needs (orginal poster of the question), you might be
right. So far I have not so much experience with PHP.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 27日 日曜日 15:43、Ivan Cukic さんは書きました:
> Nils> How about LIKE \"$%searchdata%\" ?
>
&
other host can use the account. Not that the
wildcard will allow a root user to connect from any host.
I haven't heard or read of the possibility to choose the network device to
connect to. While I undestand what you are thinking I don't think that's
pracical. It's much easier to te
n it might
be o.k there, but for MySQL I believe you don't need it in your case (if
understood correctly what you want to do ;-)
So please try also this :
LIKE '%searchdata%'
Best regards
Nils Valentin
Tokyo/Japan
>
> using php as my chosen language.
>
> Mark
--
Hi Carlos,
I believe that would have to be 2 separated steps.
1) creating the value in the primary key and
2) creating the foreign key value
However you can use UNION to write both statements in one go.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 26日 土曜日 05:20、Write a Friend さんは書きました
Hi Vikram,
ignore both previous posts. Both don't work as wanted. I just realized that
and I will come back to you after I created the tables and made it sure.
Sorry for the confusion.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 25日 金曜日 14:42、Nils Valentin さんは書きました:
> H
hat cid itself is ambigous, because in both tables.
Best regards
Nils Valentin
2003年 7月 25日 金曜日 14:31、Nils Valentin さんは書きました:
> Hi Vikram,
>
> NULL is a special data type and requires special procedures.
>
> Try this:
> > mysql> delete from clients where cid = (sele
e you
an syntax error.
Hope that ends the problems you had.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 25日 金曜日 12:58、Vikram Vaswani さんは書きました:
> Hi all,
>
> I have the following two tables:
>
> mysql> SELECT * FROM clients;
> +-+--
Sounds like you want to give the DEBUG version a try ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 25日 金曜日 01:25、Miguel Perez さんは書きました:
> Hi:
>
> I have a question: does anyone know if exists a log in mysql to store only
> incorrect queries or queries that causes a code er
for the join condition.
Please see the JOIN Syntax for more information.
http://www.mysql.com/doc/en/JOIN.html
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 25日 金曜日 03:36、eli さんは書きました:
> Hi,
>
> Can anyone explain me how to create relationships between tables in Mysql?
>
>
Hi Martin,
I understand the ABS() function is used for this.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 23:42、Martin Moss さんは書きました:
> All,
>
> I have a question about grouping numbers.
>
> Lets say I have 10 records each containing a numeric value:-
>
> 1
Hope I could be of help.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 22:51、Henrik Schmiediche さんは書きました:
> Thanks for the help!
>
> - Henrik
>
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 23, 20
Seems like I forgot to post to the list again. O.K this one is for the record
;-)
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 13:54、あなたは書きました:
> Hi Saravanan,
>
> Thats a simple question. You have to specify a username and a password when
> connecting to the mysql server. I guess t
u can use the copied data again.
Go into your data folder (/var/lib/mysql for an rpm install) and do:
chown -R mysql foldername
chgrp -R msql foldername
That should make them accessable again (assuming MySQL uses the owner and
group "mysql".
Best regards
Nils Valentin
Tokyo/Japan
the items sperarately,
but the formatting will still need to be made with your application.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 04:47、Michael C. Podlesny さんは書きました:
> UGHH HELP!!
>
> I need to write a sql statement that will take the data from my table and
> use
Hi Mohammad,
I am sorry I am not usre what exactly you are after, but
you could use, HAVING or LIMIT to restrict an UPDATE statement.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 05:29、Mohammad Khan さんは書きました:
> Is there any way to restrict UPDATE without a WHERE cla
Hi Mark,
I use the the MySQL versions as provided from www.mysql.com.
The drivers are taken from the daily snapshot and/or from www.mysql.com.
Let me know if you need more information.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 23日 水曜日 23:44、Mark Matthews さんは書きました:
> -BEGIN
thing I am aware off right now. After I realized the problem I tried many
3.08 versions with the same symptom. Watch were it says "Unknown system
variable 'autocommit'" - which I havent set as far as I know.
Best regards
Nils Valentin
-
java.sql.SQLExce
Hi Andrew,
Thanks for the reply, that makes your question clearer, but I havent had a
chance yet to try the system you described. Sorry, unfortunately at this time
I am unable to help.
Best regards
Nils Valentin
2003年 7月 20日 日曜日 03:48、olinux さんは書きました:
> There is a diagram of the datab
Hi Andrew,
Unfortunately I am not, but I figured that it would probbaly take only 30-60
minutes to get the system set up on a machine ;-)
Have you tried it yet ?
You could login and use
SHOW TABLES;
DESCRIBE TABLES;
to find the information you require.
Best regards
Nils Valentin
Tokyo
for a ACCESS or SQL server ;-)
in any way.
Peace ;-)
Best regards
Nils Valentin
2003年 7月 18日 金曜日 16:09、Roger Irwin さんは書きました:
> Nils Valentin wrote:
> >Excuse me but frankly speaking in "British English" I am sure some people
> >wouls immadietly say "bullocks&q
value blue as it contains information such as that you know which
data record was orginally meant to conatin the value "blue". Onceyou
converted all to purple you will not be able to retrieve this information
anymore.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 18日 金曜日 06:49、Aaro
Hi Henry,
You created an alias for a table columnname. But either you
either you created the alias twice with the same name or you are refering to
two columns (one in each table with the same name).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 16日 水曜日 23:35、Henry さんは書きました:
> I hav
Asfar as I know that is the default settings in the mysql server to be
returned.
So you will have to set the necessary parameter from the mysql command line
client.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 16日 水曜日 22:32、Weir Travis さんは書きました:
> I have noticed that mySQL Cont
Hi Edward;
Thanks fot the reply.
I have a double error then ;-)
First mistaken whats actually correct and then even trying to fix it ;-)
Never mind.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 14日 月曜日 10:10、Becoming Digital さんは書きました:
> Actually, "Live and Learn" is correc
to right now)
http://marc.theaimsgroup.com/
(watch for Databases)
The one which I like most is here:
http://www.listsearch.com/mysql.lasso
Best regards
Nils Valentin
Toktyo/Japan
2003年 7月 12日 土曜日 16:19、Ernest Pianalto さんは書きました:
> Hi,
>
> I just joined this list and would like to s
Hi Nestor,
Sorry I didn't mean to be rude actually. Its saturday morning here in Tokyo
so I guess the Beer is a bit to early for me. But I come back to the idea
later during the day ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 13:22、Nestor Florez さんは書きました:
> Nils,
Hi Bruce,
Thank you for the reply.
Just for the record the options order must be
SELECT schedule_id,count(schedule_id)
FROM attendance
GROUP BY schedule_id
HAVING count(schedule_id) <10;
(swapped GROUP BY and HAVING)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 10:20、Br
Hi Bruce;
Thank you for the reply.
I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Thank you very much for the reply.
Best regards
Nils Valentin
2003年 7月 12日 土曜日 10:20、Bruce Feist さんは書きました:
> Nils Valentin wrote:
> >I would like to list all courses with
2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> Hi Bruce;
>
> Thank you for the reply.
>
> I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Aeeh thats was supposed to be ... life and learn..
Perhaps somebody knows a good spellchecker for logical mista
Hi Nicholas,
How about storing the BLOBS outside of the DB and refering to them ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 00:06、Nicholas Elliott さんは書きました:
> Hey all,
>
> I've been experimenting with the best way to store a large (~100GB) of data
> for retri
Hi Carmine,
Whats the physical size of the .MYI file and which OS version ??
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 00:23、Carmine Smedira さんは書きました:
> We have loaded a very large dataset and received an error message stating
> that the key file is full. How do you go
desc
> limit 1)) AS period_count, (TO_DAYS(NOW() -1)) from table 1;
>
> They both give me an error for the 'SELECT count FROM table2 WHERE id=id1'
> section. Is this illegal syntax? Would this be considered a subselect?
YUP
SELECT SELECT...
is a subselect.
Be
pyware has included
mechanisms to place adds on your screens exactly referencing the topics of
your interest (which they retrieve from your browsing behaviour).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 06:26、Nestor Florez さんは書きました:
> Interesting!
>
> After reading a
Aahhh Neil,
if you don't specify any table format than MySQL will automatically create the
table in MyISAM format.
Does that answer your question ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 06:41、Neil Zanella さんは書きました:
> Hello,
>
> Is there a way to specify
Hi John,
Thank you for the reponse. I tried that (I didnt post it here), but that gives
me the error
mysql> SELECT schedule_id,count(schedule_id) AS ct FROM attendance WHERE ct<10
GROUP BY schedule_id ;
ERROR 1054: Unknown column 'ct' in 'where clause'
Best regards
r you automatically.
I am unable at present to give any advice on the PHP side.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 11日 金曜日 23:41、Brian Rivet さんは書きました:
> Hi Nils,
>
> I wasn't actually aware of this, but I don't plan to use MySQL to
> enforce the foreign keys
Hi MySQL Fans ;-)
I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?
schedule_id is the course itself
SELECT schedule_id,count(schedule_id) FROM attendance WHERE
count(schedule_id)<1
output here as it wraps rather ugly in an e-mail.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 11日 金曜日 22:59、Brian Rivet さんは書きました:
> Hi Everyone,
>
> I'm using PHPMyAdmin to set up the database for a website, and I am
> trying to set up foreign keys between tables. I know tha
Hi Anton;
Thank you for the english reply. With your permission (I hope) I post it to
the mailing list. I know that there are some marvelous minds arround ;-)
Unfortunately I will not be a big help on this topic.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 11日 金曜日 20:56、あなたは書きました
n
have an AHA effect during the test through the way the questions are asked.
Best regards
Nils Valentin
Tokyo/Japan
PS: Now, let's get ready for the professional certificate ;-)
2003年 6月 10日 火曜日 19:03、rich johnson さんは書きました:
> Has anyone else tried this? I got 8/10. Going to the e
Hi Kevin,
In this case the error log file (hostname.err) in f.e /var/lib/mysql should
give you an idea whats going on.
Perhaps the settings inside the my.cnf from the newer version are very
different then from the older version.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 10日 木曜日 11
Hi Benny,
Thank you for the explanation, but I believe thats out of my reach to give any
advice here ;-)
Best regards
2003年 7月 9日 水曜日 21:30、Bernhard Schmidt さんは書きました:
> for me a recursive sql statement is when the result of a query can be used
> for a following query. the statement has start a
Hi jvilla,
I know that MySQL supports some simple nested queries from 3.23 -xx, and even
includes subselects from 4.1.
However I am not clear if any of the 2 queries will work straight away in 4.1
(once its stable).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 21:00、Jonathan Villa
Hi Benny,
May I guess that you are talking about nested queries or subseects ?
If yes than they are supported from Version 4.1. If no, than I have no clue
what you are talking about ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 20:26、Gerald R. Jensen さんは書きました:
> Benny:
>
have been completely out of my mind for the previous posting. I
hope you didn't have a chance yet to try the command from the previous
e-mail.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 17:15、Nils Valentin さんは書きました:
> Hi Faith,
>
> You will have to check your user
#x27;%' IDENTIFIED BY PASSWORD 'xxx'
This will allow root to connect from any host.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 15:57、fatih olcer さんは書きました:
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> i got an error when i try
f you give more details than we can be
more specific. ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 15:42、Neil Tompkins さんは書きました:
> Could any one advise what SQL statement I would need to use, to check a
> table for any duplicate records e.g that contain the same data within
www.mysql.com/doc/en/InnoDB_start.html )
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 15:19、mixo さんは書きました:
> The size is already set to 2000M, and I may be wrong, but the autoextend
> feature is not support
> in mysql version earlier that 4.
>
> Nils Valentin wrote:
> >H
Hi Paul,
2003年 7月 9日 水曜日 11:17、Paul DuBois さんは書きました:
> At 12:31 +0900 7/8/03, Nils Valentin wrote:
> >Hi Koh,
> >
> >Shouldn't the value in the first sample be used like this ?
> >
> >1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400
Hi Paul,
A good lesson to learn ;-).
What you are saying actually means that Kevin didnt need to install it again.
I must have missed this part in the manual.
Thank you for pointing this out.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 11:14、Paul DuBois さんは書きました:
> At 10:35 +090
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set f.e in my.cnf.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 22:45、mixo さんは書きました:
> How can I avoid this:
>
> DBD::mysql::st execute failed: The table 'Transactions' is
2003年 7月 9日 水曜日 00:55、Michael Iatauro さんは書きました:
> > I took once moe a sharp look now that you did a reply with another
> > sample. Actually I was wrong the SQL statement was NOT correct - you
> > forgot the semicolon in the first exapmple ;-)
>
> To my knowledge, the semicolon is unnecessary when u
Hi Rudy,
How about changing the port number in my.cnf and restarting the server ?
All clients will look on the wrong port number and not be able to connect.
That should do it while you take your backup.
When finished change the port number back to 3306.
Best regards
Nils Valentin
Tokyo/Japan
Hi Kalle,
I understood that you already received 4 answers in the meanwhile, why are you
reposting the same question like yesterday ??
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 14:06、Kalle Saarinen さんは書きました:
> Hello
>
> I'm trying to make mysqldump in a shel
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 11:55、Koh Swee Meng さんは書きました:
> i inserted a new re
dy on the list can give some advice on how to gracefully compile
a mysql version ?
Best regards
Nils Valentin
Tokyo/Japan
>
> Thanks,
> Kevin
>
> Nils Valentin wrote:
> > Is there a reason why you dont use the precompiled rpm
> >versions ?
> >
> >
TED]' IDENTIFIED BY 'password' WITH
GRANT OPTION;
Note the ' before and after [EMAIL PROTECTED]
However it is a bit unusual that you dont get an error 1064 - wrong sql
syntax. How did you install the mysql server (rpm or tar.gz ) ?
Best regards
Nils Valentin
Tokyo/Jap
Hi Dan,
2003年 7月 8日 火曜日 00:57、Dan Nelson さんは書きました:
> In the last episode (Jul 07), Nils Valentin said:
> > Thank you for the superfast reply. I actually was looking for other
> > information. I understood the actual feature difference of the
> > standard and f.e max version.
ssword of course ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 09:51、Kevin H. Phillips さんは書きました:
> Hi, Nils
> I was able to stop the mysqld daemon using the kill command. However,
> when I tried to start it using mysqld_safe --skip-grant-tables, a line
> would ap
Hi Michael;
I took once moe a sharp look now that you did a reply with another sample.
Actually I was wrong the SQL statement was NOT correct - you forgot the
semicolon in the first exapmple ;-)
'Y', 'Y', 'Y');\""
Best regards
Nils Valentin
Tok
|
+-++
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 07:22、Subhakar Burri さんは書きました:
> Hi,
> I tried SHOW VARIABLES LIKE '%innodb%';
> but I couldn't find any variables that show information about auto extend
> property. Please clarify...
>
> For my
thing with this part above. Perhaps the " at the very
end is not escaped correctly (double) or something similar. The actual SQL
statement works perfectly fine.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 08:28、Michael Iatauro さんは書きました:
> I've been having a little trouble
, but be aware that the one or the other statement
made by me on the page might be incomplete yet or contains perhaps even wrong
information. If this would be the case than I would certainly appreciate any
comment or feedback.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 7日 月曜日 18:49、Anthony
Hi Antony,
Eventually "key" is a reserved word ?? ;-)
nice one !!
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 7日 月曜日 18:20、Anthony Scism さんは書きました:
> I am relatively new at this, but is there any way to perform the
>
> following:
> | obs_date | date
my question a bit clearer.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 7日 月曜日 18:18、Delfim Machado さんは書きました:
> http://www.mysql.com/downloads/mysql-4.0.html
>
>
> The Standard binaries are recommended for most users, and includes the
> InnoDB storage engine. The Max v
2003年 7月 7日 月曜日 18:02、Rafal Kedziorski さんは書きました:
> At 17:58 07.07.2003 +0900, Nils Valentin wrote:
> >2003å¹´ 7月 7æ—¥ 月曜日 17:43ã€Rafal Kedziorski
ã•ã‚“ã¯æ›¸ãã¾ã—ãŸ:
> > > hi,
> > >
> > > I'm porting an PostgreSQL script to MySQL. I get
Hi MySQL Fans ;-);
I know that the MySQL Max Server Version is app. 7MB big while the Standard
Version is 10MB big. Having looked further into the downloaded files than I
see that the max version is dynamically linked while the standard version is
statically linked.
What is the reason for the
S `mandant` (`mandant_id`)
> ) TYPE=InnoDB;
The foreign key points to the table mandant. But the column mandant_id is not
indexed. (f.e no Primary key)
Best regards
Nils Valentin
Tokyo/Japan
>
>
> Regards,
> Rafal
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTE
Dear Bjoern,
it is better to send all mailing list requests in english.
Best regards
Nils Valentin
Tokyo/Japan
-Translation:
Hi Bioern,
es ist bessser alle anfragen an die mailing Liste grundsaetzlich in English zu
formulieren.
Besten Gruss
Nils Valentin
t;
> If I try shutting down without using a password, I get a message saying
> that access is denied; I need shutdown privileges for this operation.
>
> I have pinged the server and it *says* that it is "alive".
>
> Perplexing problem, no?
>
> Kevin
>
> Nils Val
2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました:
> Hi Kevin,
>
> try this:
>
> 1) stop the mysql server
> 2) mysqld_safe --skip-grant-tables
> 3) mysql -u root
> 4) mysql> SHOW GRANTS FOR root;
> 5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
6) restart the server (without --skip-grant-table option) and try to login
Best regards
Nils Valentin
To
the output.
Use the normal print command to print the file.
I hope that helps.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 7日 月曜日 07:27、Vince さんは書きました:
> I am new to SQL and was wondering if there was a query that would allow
> me to print to my printer. I have tried the TO PRINTER,
Hi Woody,
I can't answer your question, but I just wanted you to know that I like your
signature ;-). Thats definitely a good one.!!
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 4日 金曜日 18:02、woody at nfri dot com さんは書きました:
> I am in the process of setting up replication for
use safe_mysqld --skip-grant-tables to start the
server without any passwords required. This way you can reset your password
for the administrator.
Then restart the server and set your password. Then you should be fine and
safe again ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 4日 金曜日
Hi Mario,
Try this please:
1) stop the mysql server
2) delete the contents in the folder /var/lib/mysql/mysql
3) run mysql_install_db
4) start the server
5) log in to check that everything is reset
6) set your password
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 4日 金曜日 09:21、Mario さん
work.
Best regards
Nils Valentin
2003年 7月 4日 金曜日 04:49、Stefan Vunckx さんは書きました:
> I am deciding how to setup my MySQL database but i'm having some doubts.
>
> I just want to know which is faster, when I query:
>
> One table with a double primary key and one search field (
You are welcome ;-)
Best regards
Nils Valentin
Tokyo/Japan
;-)
> 2003年 7月 3日 木曜日 14:43、Sibananda Sahoo さんは書きました:
> > Thank you sir
> >
> > Rgds,
> > Sibananda
> >
> > --- Nils Valentin <[EMAIL PROTECTED]> wrote:
> > > Dear Sibanada,
receive replies from some friendly persons
;-).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 3日 木曜日 12:57、Sibananda Sahoo さんは書きました:
> Dear Sir
>
> I think you have replyed something. But I didn't get
> anything because of unknown format.
>
> My enquiry was:-
>
2003年 7月 3日 木曜日 11:30、Nils Valentin さんは書きました:
> Hi Dan,
>
>
> By default 2 anonymous user accounts are setup in the mysql database. You
> will have to delete them first. you should find that you can login with any
> name (except the specified ones) without password. This will pr
anonymous user
accounts. ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 3日 木曜日 06:18、Dan Ullom さんは書きました:
> I recently stumbled onto the ability to log into a mysql server from the
> command line with any table name, and a blank password. ie: mysql -u mysql
> My root account has
Hi Victoria,
2003年 7月 2日 水曜日 22:05、Victoria Reznichenko さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > Hi Victoria,
> >
> > I enclose a sample.
> >
> > http://www.mysql.com/doc/en/Resetting_permissions.html
> >
> >
2003年 7月 2日 水曜日 22:57、Sibananda Sahoo さんは書きました:
> Dear Sir
>
> Hope you to be fine. I know MS SQL supports the
> following query to reseed the seed value:
>
> DBCC CHECKIDENT ('tablename',RESEED,new-seed-value);
>
> Is there any support like the above in MySQL 4.0.13 to
> set new seed value ?
>
> A
Uups must have forgotten to copy the list ;-)
Thanks Heikki,
Also I dont fully understand the resulting context yet, I appreciate the
reply.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 3日 木曜日 00:07、Heikki Tuuri さんは書きました:
> Nils,
>
> at the lower level all mini-transactio
a lot of
interpretation or vague guessing room for some descriptions.
Anyway having spoken to "somebody" from MySQL AB I understand that they are
working on it and hopefully make the manual better than it already is. ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日
SELECT * FROM tablename where column>5 AND column<12;
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 18:26、Maciej Bobrowski さんは書きました:
> Hi,
>
> Let's say I have 1000 records in a 'table'. I want to select rows from 6
> to 11. How can I do this?
Hi Egor,
Thanks for the straight and short answer.
Much appreciated.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 17:44、Egor Egorov さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > does anybody know how to initialize a new added Innodb file w
Hi Harsh, Hi MySQL AB ;-)
I agree this section could be made a bit clearer.
Is this hint big enough for MySQL AB ;-) ??
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 18:08、harsh さんは書きました:
> Well its not your fault,its actually confusing
> the documentation says run the
Hi Heikki,
2003年 7月 2日 水曜日 18:10、Heikki Tuuri さんは書きました:
> Nils,
>
> - Original Message -
> From: ""Nils Valentin"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Wednesday, July 02, 2003 12:04 PM
> Subject: InnoDB logfile
Hello Heikki & other Mysql Fans ;-);
Does anybody know which requests or data the below logfils actually keep ??
If I understood correct than they are all in binary format (not readable in a
text editor.
log.01
ib_arch_log_00
ib_logfile0
ib_logfile1
Hi harsh,
perhaps I made a litttle mistake (havent done it recently ). try the
--skip-grant-tables option for safe_mysqld like this
safe_mysqld --skip-grant-tables
That should be doing it.
Best regards
Nils Valentin
Tokyo/japan
2003年 7月 2日 水曜日 17:02、harsh さんは書きました:
> I m sorry ,try
Hi Mysql fans ;-),
does anybody know how to initialize a new added Innodb file without restarting
the server ?
Best regards
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mai
password with mysqladmin like this:
mysqladmin -u root password xxx
mysqladmin -u root flush-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 rega
2003年 7月 1日 火曜日 04:11、David Brodbeck さんは書きました:
> > -Original Message-
> > From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
> >
> > It's true that mysqldump doesn't put the data for the index itself
> > into the dump file. That does not automatically mean that the dump
> > files will be sma
ubbish ;-)
So to come back to your question, you will need only 1 line
SET AUTOCOMMIT = 1 to activate the AUTOCOMMIT function.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 30日 月曜日 15:21、artem さんは書きました:
> please clarify use of set autocommit
>
> SET AUTOCOMMIT = 0 ==> mean
101 - 200 of 357 matches
Mail list logo