Security using ODBC

Hi, I want to write a program with VB in win98 box and connect to mySQL in Linux. I think the only way to do is to connect thru ODBC with myODBC. But with using ODBC, all ID & password is given when setting up the DSN. And this means everyone using this computer could access the mySQL server

Re: compiling error

Hi, look at the latest patch: http://www.innodb.com/bugfixes.html > Dvořáček Michal wrote: > > > > i configured mysql with > > > > ./configure --prefix=/usr/local --localstatedir=/usr/local/var > --with-mysqld-ldflags=-all-static --disable-shared > --with-unix-socket-path=/usr/local/var/m

Install many server on same machine

I have a problem I'd like two instance of mysql on same machine but informations about installation are pour, because it's not clear which method have to follow for correct installation. In fact the script which I have to modify is mysql.server, but exist the option file for each server called my.

Re: Duplicating rows

Hi every body I want to know if there is some easy way to duplicate an entire row, in one table, only changing one field? Somethig like this, this is the original table: +---+-++-+ | ReleaseNumber | ReleaseDate | PrositeVersion

installing mysql

Hi all, Yes, its me again. I've re-installed the MySQL-3.23.27-1 packages in this order: DB Engine (included shared files as it then told me that the -shared- pkg was already installed) client (must be installed before devel) devel Didn't install bench (should I?) I still can't seem to find th

next compiling error

plase help, i'm trying compile mysql 3.23.41 on Linux RH 7.1 kernel 2.4.9 gcc 3.0 with CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local --localstatedir=/usr/local/var --with-mysqld-ldflags=-all-static --disable-shared --with-unix

Re: Security using ODBC

try driver vbmysql.dll at www.icarz.com/mysql/index.html SF At 16:00 24/8/2001 +0800, Jason Kwok wrote: >Hi, > > I want to write a program with VB in win98 box and connect to mySQL in >Linux. I think the only way to do is to connect thru ODBC with myODBC. But >with using ODBC, all ID & passw

Re: JDBC ResultSet

Hi, I am a relatively new user of mySQL. I have written a program that uses JDBC to access a mySQL database. I seem to find no other ResultSet metadata statements other than ResultSet.getMetadata().getColumnName(1), ResultSet.getString(1) etc and stuff. I can use ResultSet.getRow() though it

Mailing labels

Hi! Does anyone know the correct tag sequence to produce Mailing labels with the 1.7.5.1 version of mysql, I try every wich way to produced them, but I had to resort to export the data to excell or word in order to produce them. Bruno -

RE: installing mysql

ok, I'm not 100% sure about this but I've had what I think may be a similar prob trying to get MySQL working with a radius server - header files and shared libraries not being found by the radius server compile. I _THINK_ its because when you install from a rpm of the binary you don't get the hea

Re: compile problems with mysqlgui-src-1.7.5....

Ron DeAngelis writes: > > main.cc: In function `void if_conn()': > main.cc:464: no matching function for call to `MysqlConnection::clinet_info > ()' > main.cc:529: no matching function for call to `MysqlConnection::clinet_info > ()' > make: *** [main.o] Error 1 > > I am using mysql++-1.7.9, an

Re: GLIBC 2.2.4

Trond Eivind Glomsrød writes: > Peter Zaitsev <[EMAIL PROTECTED]> writes: > > > I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this > > somehow does not work with the following diagnose: > > It builds just fine with glibc 2.2.4 on a current development version > of Red Hat L

Re: Re[2]: GLIBC 2.2.4

Peter Zaitsev writes: > Hello Trond, > > Thursday, August 23, 2001, 8:01:33 PM, you wrote: > > > Yes. I'm shure it builds OK then glibc is installed as standart. > I'm having a system with glibc 2.2.0 and trying to compile MYSQL with > glibc 2.2.4 laying in a special directory. But if fails. Th

Tourn off Errors displaying

Hi How can I turn off the error displaying ... sometimes when the script could not connect to the DB or in fact I do not want to show these Errors at all OK for things like MYSQL_CONNECT or MYSQL_SELECT_DB I use OR DIE but what can I use for query's inside of other select's ... I can't put

Re: database action

Martijn Rotteveel writes: > Hi all, > > i need a SIMPLE method for performing some pre defined actions on my tables, > these actions involve retrieving strings, recombining them and inserting > into another table. > > i thought about MySql++, but is there a simpler way to accomplish this kind

joins with concatenated keys

table a has ak1 and ak2 as primary key table b has bk1 and bk2 as primary key how do I join these tables? if i write where a.ak1 = b.bk1 and a.ak2 = b.bk2 data are returned multiple times. /AM - Before posting, please check:

linking against mysql-only libpthread.a

Hi, I've read http://www.mysql.com/doc/L/i/Linux.html, and I want to build glibc 2.2.4 on RedHat 6.2 and Slackware 7.1 (currently 2.1.x glibc's). My question : how to build a glibc for MySQL-only, as recommended ? Thus, howto dump it in some directory, and use it in the build process ? Also, d

Re: joins with concatenated keys

[EMAIL PROTECTED] schrieb am Freitag, 24. August 2001, 13:43:15: > table a has ak1 and ak2 as primary key > table b has bk1 and bk2 as primary key > how do I join these tables? > if i write > where a.ak1 = b.bk1 and a.ak2 = b.bk2 > data are returned multiple times. Well this should be. You sho

Re: Select statement didn't return results though there should be results

>> But also consider, if you don't want to ask for >> >> select >> subject,subhead,subsubhead,data2,data3,see_also >> from npl_detail >> >> where (subject like '% asia %' >> AND NOT subject like '%winter%') >> OR >> ORDER BY >> s

Re: How to drop table from InnoDB after drop database from MySQL?

Dave, DROP DATABASE for InnoDB type tables is in my TODO list for August, and I am determined that the September distribution will have it implemented. But meanwhile, if you accidentally lose the .frm file of your table, but the table still exists inside InnoDB, you can use the following trick t

myODBC?

Hi, I am a newbie that has a question about what exactly is myODBC (for Unix) doing. Is myODBC, 1) a "wrapper" over the mySQL database to make it conform to the ODBC interface or 2) a plug-in driver that goes with a manager program to allow the access of mySQL db? I am using an Irix mach

Re: Tourn off Errors displaying

I know what you can do if you use php: prefix the function in question with @, that will turn errors off. Example: @mysql_connect( instead of mysql_connect( Christian Eichert schrieb am Freitag, 24. August 2001, 12:47:55: > Hi > How can I turn off the error displaying ... > sometimes

Re: Mailing labels

Please tell us some details: what are your tables, which program shall actually produce the labels etc. A database holds data. If you manage to get them and stuff them into Excel or Word, that sounds fine to me. How would you like to do it? Bruno Perozzo schrieb am Freitag, 24. August 2001, 11:3

Trying to do a set difference

>Date: Thu, 23 Aug 2001 17:39:14 +0100 >To: [EMAIL PROTECTED] >From: Lindsay G Mccracken <[EMAIL PROTECTED]> > > Trying to do a set difference, >select * from staff where NOT IN (select * from Supervises where Role='0' ); >Can't seem to get it to work, is there a different way of doing th

Re: myODBC?

In my understanding, myODBC is a middleware for programs which don't know how to deal directly with mySQL. So if you use perl or php, you won't ever use ODBC, as this only slows things down, obviously. ODBC is kind of a workaround in my understanding. Please correct me, if I'm wrong. Wen Tien sc

Re: replace/insert into ... 150,000 -plus rows

- Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Network" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 22, 2001 3:08 AM Subject: Re: replace/insert into ... 150,000 -plus rows > > > I'll not trust this task to anyone other than myself. > > T

Re: Trying to do a set difference

I think this is a subselect and not supported yet - read on subselects in the manual; I did a search and here we are: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html Lindsay G Mccracken schrieb am Freitag, 24. August 2001, 15:02:11: >>Date: Thu, 23 Aug 2001 17:39:14 +0100 >>To: [EMAIL PR

"not regexp"

Would someone explain what is going wrong here. obviously I'm not understanding something. If the next query searches for patterns at the beginning of the string in a column mysql> select count(*) from a where addy1 not regexp '^(apt)|^(rm)|^(room)|^(ste)|^(suite)|^(fl)|^(floor)'; +--+ | c

Re: "not regexp"

At 9:24 AM -0400 8/24/01, Network wrote: >Would someone explain what is going wrong here. >obviously I'm not understanding something. >If the next query searches for patterns at the beginning of the string in a >column >mysql> select count(*) from a where addy1 not regexp >'^(apt)|^(rm)|^(room)|^(

load data infile....

Dear all, I have the following problem with load data... Please excuse layout, but the linewidth is just too short // --- // Here is my table definition // --- mysql> desc customer; +---+

Table headings in OUTFILE

Hi, I am using the INTO OUTFILE 'filename' function, to create .CSV output files from my queries. Whenever I do this, the table headings are removed from the output. Is there a way to get the table headings displayed in the output file? Andrew -

Moving database from NT > Linux

Hi all, I'm getting closer and closer to having MySQL/PHP/Apache set up on my LinuxPPC box. Now, I haven't been sitting twiddling my thumbs while I was waiting. Instead I was building a database on MySQL on NT. I would like to move this to Linux asap. There are 6 tables with between 8 and 40 fi