Re: varchar and java string in sql query ?

2003-02-21 Thread Max Morawski
Jianping Zhu wrote: I and using mysql-jdbc to do some program. I can insert record to my db by following code: - stmt.executeUpdate(insert into apidbusers values('id', 'jp','zhu','em1','jian180'));

Re: Connect to Mysql from java(linux)

2003-01-29 Thread Max Morawski
vim m wrote: Hi: I am new to Mysql. I have installed mysql3.23.55 on linux RH7.1. Now mysql is running successfully on my system. When I try connecting thru java(mysql-connector-java-3.0.1) I am getting an Access Denied error. It says mysql@machinename access denied. Now i tried from command

Re: Newbie: MySQL + Java + web?

2003-01-03 Thread Max Morawski
Brynley wrote: Anyhow - basically it appears he writes some Java code that contains a MySQL query (which I'm still not sure how is done - but I think I can nut it out) and then calls that piece of Java code from within the browser (via HTML) - it is this part that has me bamboozled. Seach

Re: Ok, i want to restart the mysql

2002-11-08 Thread Max Morawski
Fajar Priyanto wrote: Hmm, thanks all.. But, before I remove the mysql installation, I want to restart it first so that it reads my.cnf file, and see if it corrects the problem. How do I restart the mysql from command prompt? I'm using RH6.2 without XWindows. /etc/init.d/mysqld restart Max

Re: Unable to connect to MySQL using java

2002-10-20 Thread Max Morawski
Muhammad Farhan wrote: HI, I am trying to connect to MySQL using java. I have placed mm.mysql drivers in jakarta-tomcat/lib folder. but whenever i try to connect to mysql, i receive this error: Cannot connect to MySQL server on . Is there a MySQL server running on the machine/port you are

Re: JDBC problems

2002-10-18 Thread Max Morawski
mysql,query Lee Denny wrote: I'm trying to use the mm.mysql JDBC drivers on windows NT I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted it into my jdk1.2.2/jre/lib/ext folder. You need to put .jar file (ie. mysql-connector-java-x.x.x-beta-bin.jar) into

Re: MySQL newbie installation question

2002-10-18 Thread Max Morawski
CM Miller wrote: Very new to MySQL and I've done a search on google.com, but really couldn't find the answer that I am looking for. Where should I install MySQL? I'm running RH 7.3 and I've installed the tgz file under my directory /home/CMMiller, is this right, or anywhere else? I see it is

Compressed JDBC protocol

2002-10-15 Thread Max Morawski
mysql,query Hello! Maybe I've missed something in the docs... how can I turn compression on using JDBC with Connector/J? Or is it turned on by default? If so, how can I check if it's on or off? Regards, Max - Before

Re: ERROR 1146

2002-09-23 Thread Max Morawski
hans schneidhofer wrote: hi list, trying to do my first steps with mysql, i have done the following : mysql USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql INSERT INTO mysql

Re: Hans Needs Help :D

2002-09-13 Thread Max Morawski
The solution that works best with all broken rpm dependiences is to use --force --nodeps (verify with the man page). HTH, Max spam filter pass: sql,query - Before posting, please check: http://www.mysql.com/manual.php

mysql console buzzer problem

2002-08-16 Thread Max Morawski
Hello! I can't find a way to turn off buzzer (PC speaker) in mysql console. Am I missing something or is it impossible and I should report user interface bug to bugs mailing list? mysql console version : 11.18 distribution 3.23.51 System: Windows 2000 Max

Re: mysql console buzzer problem

2002-08-16 Thread Max Morawski
Mikhail Entaltsev wrote: What's wrong with your PC speaker in mysql console?! I am using the same version and have no problem with it. It's making loud noise on each error. It is *extremely* annoying. Max - Before

Re: mysql console buzzer problem

2002-08-16 Thread Max Morawski
Mikhail Entaltsev wrote: It's making loud noise on each error. It is *extremely* annoying. Try to use these ways: 1. -s, --silent option in mysql console. I don't know what does it mean (in doculmentation I found only Be more silent.), but may be it will help you. No change. 2.

Re: mysql console buzzer problem

2002-08-16 Thread Max Morawski
Victoria Reznichenko wrote: Max, Friday, August 16, 2002, 11:36:19 AM, you wrote: MM I can't find a way to turn off buzzer (PC speaker) in mysql console. Am MM I missing something or is it impossible and I should report user MM interface bug to bugs mailing list? Option --no-beep for mysql