Re: transaction isolation level

Hi! - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, October 08, 2002 5:07 AM Subject: Re: transaction isolation level > Jianliang Zhao wrote: ... > >>I am connecting to MySql 3.23(innodb) with > >>mysql-connector-java-2.0.

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

All Remote requests hang server

I am having a problem getting any kind of remote connections. Connections to localhost work just fine. It doesn't matter which mysql client I use or if I just attempt to telnet to port 3306, the result is the same. The server restarts. The log reports this; Number of processes running now:

Re: Recommended Books

Hi Thomas, This is Tarun Khandelwal from Jaipur, Rajasthan, INDIA !!! 'N' I hav also bought a book on MySQL whose name is: MySQL by Paul DuBios ( Forwarded by Michael "Monty" Widenius,MySQL Moderator) This all is written on the book 'n' it one of the best book available. There

Re: how to check .MYI file withour shutdown database

In the last episode (Oct 08), Patrick Hsieh said: > Hello list, > > Can I use myisamchk to check the index without shutdown the mysql > server? As long as your mysqld is running with locking enabled. You can check by running " SHOW VARIABLES LIKE 'skip_external_locking' ". If it's set to NO, y

Re: problem

HI You may NOT have create privileges. check your privileges by doing show grants for @; You can give CREATE privileges for databases & tables GRANT CREATE ON *.* To IDENTIFIED BY '' Refer to http://www.mysql.com/doc/en/GRANT.html Phung Huu Phu wrote: >Dear Sir or Madam: >I have install

Re: Problems with LOAD DATA LOCAL INFILE

the permissions on the file and the enclosing directory (all the way up to the root dir) must allow for execution also, my.cnf need to have [mysqld] local-infile=1 #!/usr/bin/perl use DBI; $dbh = DBI->connect( "dbi:mysql:databasename", 'user', 'password', { PrintError => 0 } ) or die

how to check .MYI file withour shutdown database

Hello list, Can I use myisamchk to check the index without shutdown the mysql server? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

RE: Remote Connection Probem

I have the exact same problem. Nothing has changed other than I upgraded from RH7.3 to RH8.0. I've tried at least five (5) different mySQL windows clients and all refuse to connect. However I can use phpMyAdmin locally (via web) and also all my web based database pages work fine too. I've tried ad

RE: .Optimize mySQL memory usage ? 41MB threads ??

On Mon, 7 Oct 2002, Jon Shoberg wrote: > Ok, > > So how do I optimize memory usage? Where to start ? > > -Jon > > -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 9:16 PM > To: Jon Shoberg > Cc: [EMAIL PROTECTED] > Subject: Re: .

Re: .Optimize mySQL memory usage ? 41MB threads ??

In the last episode (Oct 07), Jon Shoberg said: > From: Dan Nelson [mailto:[EMAIL PROTECTED]] > > In the last episode (Oct 07), Jon Shoberg said: > > > I have a small PHP website that gets a fair amount of traffic. > > > It's a simple layout with two tables. I average about 50 > > > concurrently

Re: Problems with LOAD DATA LOCAL INFILE

I just tried the following and got ysql> load data local infile "/home/repett0/contact.data" into table CONTACT; ERROR 1148: The used command is not allowed with this MySQL version mysql> I too use perl and dbi What is going on? Thanks Ron

problem

Dear Sir or Madam: I have installed MySQL database to Sun Enterperise 250 with Solaris 8 OS. I can run database server and query but I can't create database. Please tell me know how can I correct it ? Thank in advance. Phu - Bef

Remote Connection Probem

Hi, I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL from the local machine without any problem and I created a user with remote login privileges. Trying to connect to it from another machine (on the same network as well as the same subnet) gives "ERROR: 10061 Connection to mysql ser

Re: Install Problem

On Mon, 2002-10-07 at 19:18, Daniel Miller wrote: > > I have been trying to install the > mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine. > Everything seems to be going smoothly until I entered the command > > ./scripts/mysql_install_db > > I got this output which i belie

RE: .Optimize mySQL memory usage ? 41MB threads ??

Ok, So how do I optimize memory usage? Where to start ? -Jon -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 9:16 PM To: Jon Shoberg Cc: [EMAIL PROTECTED] Subject: Re: .Optimize mySQL memory usage ? 41MB threads ?? In the last epi

Re: .Optimize mySQL memory usage ? 41MB threads ??

In the last episode (Oct 07), Jon Shoberg said: > I have a small PHP website that gets a fair amount of traffic. It's > a simple layout with two tables. I average about 50 concurrently open > apache sessions and 40 open mysql connections. I am calling for > persistent connections from the mySQL/

Re: Error with LOAD DATA INFILE

check the permissions of the enclosing directory - hcir On Monday, Oct 7, 2002, at 17:43 America/Anchorage, Unidux (MIS) - K Sudhir wrote: > Hi, > > When i try to query ... load data infile ... > i am getting the following error ... > ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Err

Re: transaction isolation level

Jianliang Zhao wrote: >Thanks Jeremy. It turns out the JDBC SQL query tool(ViennaSQL) I am trying is causing >the problem. I couldn't reproduce the problem by writing a test case. > >Thanks, > >Jianliang > >-Original Message- >From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] >Sent: 2002?1

Error with LOAD DATA INFILE

Hi, When i try to query ... load data infile ... i am getting the following error ... ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Errcode: 2) The above mentioned same query i have used in many other modules, but i never get the error. The file from which i am trying to load the data

Further info for my problem

Hi again, Just did a stack trace, as the error log advised, and can't make heads or tails of it. The error was brought about by me typing "mysql -u root -p mysql" at the command line, and hitting enter (and entering root's password): 0x808476a _Z15handle_segfaulti + 398 0x813152c __pthread_si

RE: transaction isolation level

Thanks Jeremy. It turns out the JDBC SQL query tool(ViennaSQL) I am trying is causing the problem. I couldn't reproduce the problem by writing a test case. Thanks, Jianliang -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 2002?10?7? 17:36 To: Jianliang Zhao Cc:

Problems with RH8 doing a source install

Hi, Like a number of other people on the list, I've been having considerable difficulty getting MySQL (i've tried both 3.23.51 and 3.23.52) to work on RH8.0 Initially, I ran ./configure with --localstatedir=/server/local/mysql (among a number of other directives - note that I install the soft

Re: transaction isolation level

On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote: > Hi, > > I am connecting to MySql 3.23(innodb) with > mysql-connector-java-2.0.14-bin.jar. I set the global transaction > isolation level to READ COMMITTED. However, I still couldn't see the > committed changes through JDBC client.

transaction isolation level

Hi, I am connecting to MySql 3.23(innodb) with mysql-connector-java-2.0.14-bin.jar. I set the global transaction isolation level to READ COMMITTED. However, I still couldn't see the committed changes through JDBC client. Does anyone know about this issue? Thanks, Jianliang --

Re: mysqlimport problem.

> Greetings, > > I have an application that creates an SQL file from the data it > produces, but in some of that data, there might be a , or ' which > mysqlimport does not like. I need to use the mysqlimport utility, and I am > wondering if there is a way around this. I admit I have not tr

Install Problem

I have been trying to install the mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine. Everything seems to be going smoothly until I entered the command ./scripts/mysql_install_db I got this output which i believe is ok; cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/m

RES: gcc 2.96 & sourcecode

Hm... No offense, but I believe the [EMAIL PROTECTED] just spammed itself... As it clearly says 'if you just reply to this message, and include the entire text...' I also believe JK did just as instructed by the list itself, which resulted in spam... or what :) Hmz Cheers Rob. -Mensagem or

MySQL Question

Hi everybody... Does anybody knoy what is equivalent stmt in MySQL? select * from table1 where col1 in (select col1 from table2) thanks in advance. David. - Before posting, please check: http://www.mysql.com/manual.php

BUG: Table locking under ISAM/MyISAM can easily fail

(Perl Script mysqlbug not used as Perl is not installed) SUBJECT:Table locking under ISAM can fail ORGANIZATION: Owens Services B.O.P. Ltd, New Zealand LICENCE:None (expired support license) SYNOPSIS: User can cause table locking to fail by USE'ing the same database but sp

.Optimize mySQL memory usage ? 41MB threads ??

I have a small PHP website that gets a fair amount of traffic. It's a simple layout with two tables. I average about 50 concurrently open apache sessions and 40 open mysql connections. I am calling for persistent connections from the mySQL/PHP API. But here is the kicker. Each mySQL thread ta

FW: REVISED: Connecting from web server to a MySQL server using Apache+PHP

OK now I am getting this error: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /usr/local/htt

REVISED: Connecting from web server to a MySQL server using Apache+PHP

I messed up in the ip addressing sorry! -- People, I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3) I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2) My connecting string is mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd); And I ge the error: W

REVISED: Connecting from web server to a MySQL server using Apache+PHP

People, I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3) I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2) My connecting string is mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd); And I ge the error: Warning: Can't connect to MySQL server on '10.1.1.3'

Re: JDBC RowSets in Mysql Connector

Vincent Stoessel wrote: >Yeah, I was thinking about doing the scrolling results thing >using a pure java solution. I will look into the CachedRowset >from Sun, thanks for that info. I still believe the mysql driver >is cool. What's up with the docs, though? > JDBC-2.0 result sets are fully scroll

Connecting from web server to a MySQL server using Apache+PHP

People, I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3) I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2) My connecting string is mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd); And I ge the error: Warning: Can't connect to MySQL server on '66.161.11.

RE: HA of MySQL

The problem isn't so much with the failover. It's with data integrity. Binlogs control replication. You can place a failover master in between the master and slaves. In the event of a master failure, you eliminate the loss of writes by directing them to the failover. If you lose your failover,

Re: JDBC RowSets in Mysql Connector

Yeah, I was thinking about doing the scrolling results thing using a pure java solution. I will look into the CachedRowset from Sun, thanks for that info. I still believe the mysql driver is cool. What's up with the docs, though? Mark Matthews wrote: > Vincent Stoessel wrote: > >> Hello, >> I a

Re: The secure mode in InnoDB

Hi! - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 07, 2002 10:10 PM Subject: Re: The secure mode in InnoDB > On Mon, Oct 07, 2002 at 01:53:2

Re: JDBC RowSets in Mysql Connector

Vincent Stoessel wrote: >Hello, >I am working on a J2EE app and I really would love to take >advantage of jdbc 2.0's RowSet functionality. >Is Connector J (2 or 3) compliant >with this part of the standard? > > No. There hasn't been a large demand for support of that API, and it's not requir

mysqlimport problem.

Greetings, I have an application that creates an SQL file from the data it produces, but in some of that data, there might be a , or ' which mysqlimport does not like. I need to use the mysqlimport utility, and I am wondering if there is a way around this. I admit I have not tried yet, bu

Problems with LOAD DATA LOCAL INFILE

I have found to do a LOAD DATA LOCAL INFILE is no longer possible using perl-DBI, even though local-infile=1 is in the [mysql], [mysqld], and [client] sections of my.cnf. I am not sure what prompted the engineering powers-that-be to change the default for this version, 3.23.49, of mysql, but it

gcc 2.96 & sourcecode

Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go

Loading data into a table

I seem to have run into a rather peculiar problem. I was attempting to load data into a table from a file. I checked with the online documentation and found the following syntax: LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; I used this format exactly (with my own file and table names of co

Re: The secure mode in InnoDB

On Mon, Oct 07, 2002 at 01:53:25PM -0300, Dyego Souza do Carmo wrote: > Hello Heikki ! > > what is the best secure mode to use innodb ? ( min time to write data > in disk ) You're confusing two ideas. The most secure (reliable) is 1. The fastest is 0. You can't have both. Jeremy -- Jeremy D

replace

I have a table with two column; the first column contain unix timestamp(of type double ) which is the primary key. I would like to round the time. could I do : mysql> insert into mytbl(time) values(round(time)); should this work? Thanks Nissim -

RE: Protecting CC Numbers

Michael, Thanks for the input. Feel confident that you are in good company with your recommendations. After many replies to my original post and some discussion, I have decided that I will encrypt the card numbers using command line PGP before sending the using sendmail to myself. Only a s

JDBC RowSets in Mysql Connector

Hello, I am working on a J2EE app and I really would love to take advantage of jdbc 2.0's RowSet functionality. Is Connector J (2 or 3) compliant with this part of the standard? Thank You sql,query -- Vincent Stoessel Linux Systems Developer vincent xaymaca.com --

Re: protecting CC numbers

On Sun, 6 Oct 2002, David Gerler wrote: > Date: Sun, 6 Oct 2002 14:21:11 -0400 > From: David Gerler <[EMAIL PROTECTED]> > To: Mysql <[EMAIL PROTECTED]> > Subject: protecting CC numbers > > Hi, > I am working on an application that will need to store users CC > numbers so that they can be c

Question regarding processes

Hello, When I do ps aux, mysql shows a lot of child processes. Why doesn't it close them down? The load is low, at 12.00 I performed some heavy stuff, but that's almost 6 hours ago for me. Can anyone tell me? mysql24020 0.0 11.8 78972 61368 ? SOct04 0:28 /usr/local/libexec/mysq

Problem with encode() and decode() functions

We am having a problem with the encode() and decode() functions. When the second argument to the functions is a quoted string, the functions return values as expected. When the second argument to the functions is another function call, i.e. the char() function, encode() and decode() return SQL s

The secure mode in InnoDB

Hello Heikki ! what is the best secure mode to use innodb ? ( min time to write data in disk ) innodb_flush_log_at_trx_commit=0 ? or innodb_flush_log_at_trx_commit=1 ? or innodb_flush_log_at_trx_commit=2 ? My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and linux 2.4 ( with

Re: HA of MySQL

On Mon, 2002-10-07 at 10:30, Jeremy Tinley wrote: > Howdy, > > There has been some interest lately in HA of MySQL services both in my > company and on the list. A few of us here sat down on Friday (at 5PM no > less) and started hashing out the details of providing such a service. > Following sev

re: 3.22.52 log rotation crash

Matthew, Wednesday, October 02, 2002, 5:29:38 PM, you wrote: MJF> My company runs a moderately large and loaded MySQL replication network MJF> across four Solaris machines. While upgrading from a fairly old 3.23.4x MJF> installation to 3.23.52 we've encountered a problem with replication and MJF>

Major MySQL Server Problems

Greetings, We're experiencing some severe problems with MySQL and I'm at a loss as to what to look at ... It seems we've encountered some sort of a loop but I'm not sure what's causing it. The system will run fine for a while and then begin using 100% cpu on both processors in the syste

syntax help , sql,query

sql,query Hi, I am trying to run this update statement, but I got an error syntax...near offsetCould You please point out what is wrong? Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where ABBREVIATION is null; Thank You, Best Regards, Madalin. --

FW: Bug #19529 [Com]: Occational "Commands out of sync" errors

I thought I'd cross post this thread here. Maybe someone with MySQL API experience can assist. Is there a way to reset a connection? That is, send one command that can keep a connection open, but reset all the variables and rollback unfinished transactions? I don't use transactions, but I can se

Getting Fields from a sql table

Hello everyone, Can someone please tell me how I can do the following: >From the query below, I want to get the details of the header of the message and display them on a page, one per line. If I just query the Header field, it displays them in one long line. What can I do to display the them one

thread creation problem

Hello, i have a problem with the mysql database. mysql seems not able to created ne threads sometimes. the system is running several deamons, like a webserver and a ftpserver. RAM was short so i added more. now there are 2 GB RAM available. first, here is the error message: Can't create a new t

re: Re: DISTINCT and ORDER BY

Marc, Saturday, October 05, 2002, 9:59:57 PM, you wrote: > It seems that ORDER BY interferes with DISTINCT when > I > use the 2 in the same statement. When I append order > by to the end of a MySQL statement, I get all the > matches instead of the distinct ones. Is this normal > behavior? Could

re: sql syntax help

Scott, Saturday, October 05, 2002, 7:45:16 AM, you wrote: SJ> I have a db with slightly over 614,000 records of names and addresses. In SJ> the address column, there are quite a few records like SJ> "123 any rd # 2" SJ> "319 w. 1st st # B" SJ> "4321 test blvd # 42" SJ> etc SJ> I want to replac

re: SELECT...LIKE... bug with cyrillic

Dimo, Friday, October 04, 2002, 6:26:16 PM, you wrote: >Description: DV> I have a table with columns containing DV> keywords in cyrillic. If I write i.e. DV> select * from imgs where kw_1 like '%xx%' DV> (xx are two cyrillic letters and kw_1 is the first DV> keyword-column. The table con

re: Problems with LOAD DATA LOCAL INFILE

Sorin, Saturday, October 05, 2002, 8:33:23 AM, you wrote: SC> 1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration SC> file? SC> My.ini file is below: SC> [mysqld] SC> basedir=C:/mysql SC> datadir=C:/mysql/data SC> enable-local-infile SC> local_infile=1 SC> When I perform th

re: table limitations

Kip, Sunday, October 06, 2002, 11:20:25 PM, you wrote: KK> Mysql - how many tables will it handle? KK> I currently have no access to docs, so forgive me as I'm sure it is KK> documented. The only limitation is how many files can be stored in the directory. -- For technical support contract

re: Unicode Support with MySQL

Schmid, Monday, October 07, 2002, 10:23:52 AM, you wrote: SM> we are very interested in using MySQL with our machines, but we need a full SM> Unicode-support with the database. SM> Can you give us information's about the time, when MySQL will com with a SM> full Unicode Support? Unicode support

re: Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

Edwin, Monday, October 07, 2002, 1:09:37 PM, you wrote: >>>On Monday 07 October 2002 12:04, Edwin Raj wrote: >>> When I type mysql in the command prompt it is giving the error "ERROR 2002: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)" There

re: mysql can't connect to the localhost

junhuazhu, Monday, October 07, 2002, 4:54:35 AM, you wrote: ja3dn> After I used the comment "mysqld",I used the "mysqladmin ping" comment,then the following infomations appeard(c:\mysql): ja3dn> mysqladmin: connect to server at 'localhost' failed ja3dn> error: 'Can't connect to MySQL server

re: Initial Connection

Cohan, Monday, October 07, 2002, 5:13:39 PM, you wrote: CS> How do I initially connect to mysql on linux. I've successfully installed CS> from the rpm and the daemon is up and running. If I try to connect to root CS> without a password, I get the following message: CS> error: 'Access denied f

re: Question

Andrej, Monday, October 07, 2002, 2:51:29 PM, you wrote: AF> May name is Andrej and I'm from Slovenia. I downloaded and tried mysqlGui AF> program. I have one question. Tell me please how to create a new table in this AF> program. I select Create table in menu, but the program do nothing. Maybe

re: Re: show tables .question

Kip, Monday, October 07, 2002, 4:03:05 AM, you wrote: KK> Is it possible to do a "show tables" similar to a select statement KK> where ... KK> similar to: select field where anotherfield like "ABC%" gives matches KK> for all "field" which begins with ABC KK> I'd like to say KK> show tables li

re: Not inserting into MySQL table and not showing any error msgs

Fabiana, Monday, October 07, 2002, 1:51:06 AM, you wrote: FMPdA> I'm trying to insert some data into a MySQL table and I'm just not getting FMPdA> it to work. It's not a problem with the connection with the database because FMPdA> I get to SELECT and show the data, but when I try to INSERT or UPD

Re: Server comparison running Mysql

You don't give operating system versions for the two machines. James Riordon wrote: > Hi, > > I have two servers. > > Server A: > Dual 1GHz processors > 1GB of RAM > MySQL-Max 3.23.49a > PHP 4.2.1 > > Server B: > Single 1.7GHz processors >

Re: Innodb - row locks?

>Hi, > >I was just wondering. Is it a common issue to have problems with INSERTS or >UPDATES that have not been commited stick(not commit ) even though the >connection gets killed? The thing is autocommit is on. But I still am >getting this kind of behavior from scripts that are not persistent

Full-text search and extended characters

I'm working on an application that uses the MySQL full-text search to search for words in pre-existing content. This content can and does contain HTML entities like "ö". At least in my setup, if I place words like "mögliche" in an AGAINST() clause, incorrect results are returned. For example: SE

Re: sql syntax help

You almost got it. Your syntax will be something like this: UPDATE Table SET address=REPLACE(address,'#','Number') WHERE column like"%#%" When I am trying to figure out the syntax for something, I always add a LIMIT 1 at the end so that only one record gets changed. On Saturday, October 5, 200

Re: A little hair-pulling can be a "good thing" (or not)

Check youry my.cnf file. You have the temp directory set to /root/tmp instead of /tmp. If this is not the case, add an entry to redefine the temp directory. Bob Nelson wrote: >I'm encountering a situation with MySQL that's really driving me crazy and I >have been unable to locate a solution. I

FW: Initial Connection

Nevermind. I just had to use root's OS password. -Original Message- From: Cohan, Sean [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:14 AM To: MySql (E-mail) Subject: Initial Connection How do I initially connect to mysql on linux. I've successfully installed from the r

Re: Truncated Text data Type

The file must reside on the SERVER in a directory accessible to the user 'mysql'. Oswaldo Castro wrote: >Hi List, > >I am new to mysql so I ask for your patience... > >1 - I am trying to load a text file (with mysql-front) to a table that >contains a TEXTdata type field. Despite of the documenta

HA of MySQL

Howdy, There has been some interest lately in HA of MySQL services both in my company and on the list. A few of us here sat down on Friday (at 5PM no less) and started hashing out the details of providing such a service. Following several possible approaches, we ran into major stumbling blocks o

Re: Recommended Books

Actually, I'd suggest the New Riders Book by Paul DuBois, "Mysql"...what was it you wanted to achieve with your book: * do you want a reference * a tutorial ...? mysql,query DSL - Before posting, please check: http://www.

Re: bug report

Quasimodo wrote: >This occured while using phpmyadmin 2.3.0-rc4: > > >You seem to have found a bug in the SQL parser. >Please submit a bug report with the data chunk below: >--BEGIN CUT-- >JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05 >[snip] > This is reporting a bug i

Re: Protecting CC Numbers

Hack Hawk wrote: >> This implies hard-coding a private key and password somewhere on your >> system. This type of system (IMO) should NEVER be connected to the >> Internet. > > Agreed and doubly agreed. In fact, I'd say you should never save a CC # in your database _ever_ unless you're

Initial Connection

How do I initially connect to mysql on linux. I've successfully installed from the rpm and the daemon is up and running. If I try to connect to root without a password, I get the following message: error: 'Access denied for user: root@localhost (Using password: NO)' Is there a password for

Re: Performance Question

> I am writing a serverside application in Java which needs to query/search > 200 000 rows and update affected records once every 2 minutes. > As performance/speed is of importance here - and this Table only contains > 5-10 Columns of Integer numbers, I figured that using a HEAP type of table >

bug report

This occured while using phpmyadmin 2.3.0-rc4: You seem to have found a bug in the SQL parser. Please submit a bug report with the data chunk below: --BEGIN CUT-- JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05 IEV4 cCAkPGJyIC8+CldoeSBkaWQgd2UgZ2V0IGhlcmU/IDE0MiAxNDMgMTk

Kylux

I need use MySql to Linux ( Connectiva 7 )and Kylux. What version of the MySQL? Do I need MyODBC? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

The secure mode in InnoDB

what is the major secure mode to use innodb ? ( min time to write data in disk ) innodb_flush_log_at_trx_commit=0 ? or innodb_flush_log_at_trx_commit=1 ? or innodb_flush_log_at_trx_commit=2 ? My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and linux 2.4 ( with ReiserFS ) :D

evaluation

hi! i am a trainee at westlb-systems in duesseldorf, germany and it's my task to evaluate different dbms' like Postgre SQL, MySQL, MS Access ´97 ;), SAP DB and Oracle well i searched the web and various documentations but i'm not really sure if all of this is still correct or if i may have misund

Re: Recommended Books

For now, Joe Celko, "SQL for Smarties". But stay tuned :-). - - Original Message - From: "Curley, Thomas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 07, 2002 5:28 AM Subject: Recommended Books Hi, Any anyone have recommendations on MySql books currently in

Recommended Books

Hi, Any anyone have recommendations on MySql books currently in print. What's the best or is the online manual all that's needed ! Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Question

Hello, May name is Andrej and I'm from Slovenia. I downloaded and tried mysqlGui program. I have one question. Tell me please how to create a new table in this program. I select Create table in menu, but the program do nothing. Maybe I do something wrong. Thank you in advance, Andrej --

ÖйúÕÐÉÌÒý×ÊÍø£º×£¹úÇì½Ú¿ìÀÖ£¡

ÖйúÕÐÉÌÒý×ÊÍøΪÄúÀ©´óÕÐÉÌ£¡