The English version of KaneyanMySQLAdmin currently exhibited in Japan was
made.
Please use, although it does not know whether to operate normally since
there is no English development environment.
This software is free software.
http://sql.jnts.ne.jp/english/
Do not include "-p". Then it won't ask you a password
David Loszewski wrote:
After intsalling mysql is there a default password assigned to root?
I type "./mysqladmin -u root -p password 'new-password'"
Well, I don't know what the old/default password is deermind for the
american
How do I
Hi
My PHP Websites all terminate with that error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255
I already set User rights, but what can i do against that.
On my CGI modules that error occurs:
On 14 Apr 2001 09:56:41 +0200, Andreas Iwanowski wrote:
Hi
My PHP Websites all terminate with that error:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255
I already set User rights, but
Hello,select ... in (select ) dosn't work, can I
return the second query in array and use it in the
first?
Thanx
___
Do You Yahoo!? -- Pour dialoguer en direct avec vos amis,
Yahoo! Messenger : http://fr.messenger.yahoo.com
On 13 Apr 2001 18:02:19 -0400, bryan wheelock wrote:
Is a more complex single query going to run faster on a server than
several smaller queries where the results are set to variables and then
used as criteria in tertiary queries.
Usually yes as you do not have network and parsing overheads.
On 13 Apr 2001 07:30:23 -0500, Das Lekha wrote:
Could you please let me know whether MySQL database can be used with QNX
Neutrino Realtime Platform ? If so, what version?
I believe we do not have such version of MySQL. But if this platform
have decent threads and compiler we can try to make
Well I have managed to rewrite alot of my coding from MS SQL in a downward
and more portable style using MySQL and ASP. I too have now hit apon where
I need to have Sub queries on some basic searching of products. Rather than
just telling people "the manual says..." that Sub Selects are
Hello!
I am using mysql with VB ADO under Windows 2000 Proffesional.
I add data with:
RS.Open "Query WHERE 0=1", Cn, , , adCmdText
RS.AddNew
RS.Fields(Cols).Value = xx
.
RS.Update
After RS.Update RS.Fields(Cols).Value is NULL.
If I use Access database, RS.Fields(Cols).Value has value of
Dear MySQL experts
In the following example I created simple table with two-column primary key ID,IDT.
After some inserts there came insert with ID, IDT values, that are not equal to none
of the previous couples, but MySQL still reported error "Duplicate entry". In the
lines below there is
Hi,
On Sat, Apr 14, 2001 at 11:53:52AM +0200, Filip Trojan wrote:
In the following example I created simple table with two-column primary key ID,IDT.
After some inserts there came insert with ID, IDT values, that are not equal to none
of the previous couples, but MySQL still reported error
the 'integers' you insert as key are too big to fit in the size of a
integer.
mysql replaces such a big or small integer by the biggest or smallest value
possible.
if you look closely at your query, you see that the key returned by mysql
are not the same values as you inserted.
you have to: or
MyOdbc Silent Install is available for download at:
http://www.avukatpro.com/mysql.html
Regards
Avukatpro Limited Sirketi
Stupid Robot :) database mysql vb asp
Unfortunately, it doesn't seem like all ADO methods and properties and
supported when working with MySQL. Update, as you know, is one of them,
along with others like RecordCount.
I would recommend using a connection object and then passing an SQL
statement to run. If need be, you can add the
Hi!
New version of mysqlgui, version 1.7.5 has been released at it's usual
place.
An excerpt from readme for this version :
Regarding bug fixes, foremost of all, some of FLTK widgets have been
updated, which has caused some changes in mysqlgui source code. Some users
have reported problems
Just a quick note about RecordCount. RecordCount only returns the number of
records or rows from the recordset that have been 'seen'. Therefore it is
only reliable if you have traversed the entire recordset before calling it.
I agree, however, that direct SQL calls will generally produce a
N6REJ writes:
I've having a HORRIBLE time compiling this new version of MySql. Can
someone please tell me what could be wrong?
I have upgraded glibc to 2.96 per recommendations on the website, with no
change in results.
Here is the error I get
6 -DDBUG_OFF -c my_error.c
my_error.c: In
xuan li writes:
Hello all, When I use mysql_create to create the struce to access table,
I have a question about the BOLB type.
My table defined as follow:
drop table ClipBoard; #4-13
create table ClipBoard( # added 4-12 xuan li
id INTEGER NOT NULL,
data blob,
primary key(id)
);
Sofiane Sakhri writes:
Hello,select ... in (select ) dosn't work, can I
return the second query in array and use it in the
first?
Thanx
Yes, you could.
SELECT ... WHERE column IN (1,2,3,4,5);
You have to fix it in your application.
Most of the nested selects, like yours above can be
UTF-8 is just another encoding scheme.
You can store UTF-8 just fine in MySQL (using BLOB, or perhaps even
CHAR), however you cannot do much more with it beyond storing.
Comparisons aren't likely to work, character-length calculations will
not work, etc. So if all you wanna do is store and
Fist of all thank you for your help!!!
Sorry, but I disagree with you.Record is inserted correctly in database.
The only problem is that Resultset remains empty after RS.Update.
Any solution how to get Id of that inserted record without using MySQL
specific solution?
Thanks all!
Simon
Troy
[EMAIL PROTECTED]
"I do not understand what I do, for what I want to do I do not do but what I
hate I do"
Rom 7:15 NIV
- Original Message -
From: "WHSSB/ERNE/POSTMASTER" [EMAIL PROTECTED]
To: "N6REJ" [EMAIL PROTECTED]
Sent: Saturday, April 14, 2001 17:26
Subject: Mail failure
I've having a HORRIBLE time compiling this new version of MySql. Can
someone please tell me what could be wrong?
I have upgraded glibc to 2.96 per recommendations on the website, with
no
change in results.
Here is the error I get
6 -DDBUG_OFF -c my_error.c
my_error.c: In function `my_error':
HELP!
I want to get the result of "show table status" into a ADO2.6 Recordset.
But the result of my query is EMPTY. But only in VB6. When I use the
"admndemo.exe" program it works.
Note:
"show status" works perfektly, only "show table status" and "show
processlist" makes trobble...
I need the
Actually, we are looking to do just the same thing for a pretty large
database. We've come across a project at sourceforge that claims to do
this (upsize bcp) and will be investigating how well it works next week.
Sourceforge page is http://sourceforge.net/projects/upsize-bcp/.
On Fri, 13 Apr
it tells me that I'm missing a command if I take away the -p
Dave
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Guray Sunamak
Sent: Saturday, April 14, 2001 3:27 AM
To: David Loszewski
Cc: [EMAIL PROTECTED]
Subject: Re: default password?
Do not
Can't MS SQL export to an "SQL Script?" I imagine it would be a simple
matter of cat'ing said script and piping it into the MySQL CLI client.
(Are you on a UNIX box?)
On Fri, 13 Apr 2001, AJ wrote:
Does anyone know any good source of info for the conversion of MS Sql
databases to MySql?
take away the -p AND the password
Cal
http://www.calevans.com
-Original Message-
From: David Loszewski [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 14, 2001 10:25 AM
To: Guray Sunamak
Cc: [EMAIL PROTECTED]
Subject: RE: default password?
it tells me that I'm missing a command if
You can use MS SQL's Scripting tool to produce the table structure, but MS
SQL's scripts need to be massaged a bit before you can use them with MySQL
to create the database.
The data is another story. MS discontinued the 'DUMP' command after SQL
Server 6.5 (it is in 7.0 for backward
Open your datasource (via control panel/ ODBC datasource administrator) and
make sure the option "Change BIGINTcolumns to INT" is checked. This will
correct your problem with "show table status" and "show processlist"
Regards,
Gary "SuperID" Huntress
Hello,
I am a translator with quite a good knowledge of programming and of
HTML/CGI/Perl/Apache and many other web related topics.
I am translating part of a book on PHP and, for the reasons
above, I have had no problems so far.
I am having problems however, in translating a short section
Redirecting file output (for user bpc) with a command such as
select * into outfile 'home/bpc/test.txt' from table
gives the error ERROR 1: Can't create/write to file
"/home/bpc/test.txt" (Errcode: 13). The documentation
recommends setting parameter tmpdir. I have RedHat 7
with MySQL 3.23 and so
since the outfile is being written as the user that owns the mysqld
process you'll need to make sure that, that user has write access to the
location specified.
Brian Cassidy wrote:
Redirecting file output (for user bpc) with a command such as
select * into outfile 'home/bpc/test.txt' from
I've noticed, by doing "show processlist", that a few users end up with
dozens (sometimes 50) sleeping processessome are 4 hours old. What is
this typically caused by? I believe that most of my users connect using
php, and I believe that if they omit mysql_close() that the connection is
$result=0;
$query="select * from users where user_id='$user_id'";
$result=mysql_query($query,$link);
if(mysql_fetch_row($result)) $result=1;
else $result=0;
I use the function of "mysql_fetch_row()" in register2.php
and it's output is the follow list:
Warning: Supplied argument is not a valid
35 matches
Mail list logo
