Re: Unsubscribing my sql mailing list

2015-07-23 Thread Reindl Harald
why do you think we could do that for you and what do you think is that link in every mail for? YES i send this to the list hopefully to save a few of this "meh i can't handle my mail". To unsubscribe:http://lists.mysql.com/mysql Am 22.07.2015 um 18:08 schrieb Charles Turner: Dear Sir

Unsubscribing my sql mailing list

2015-07-22 Thread Charles Turner
Dear Sirs, I'd like to unsubscribe my subscription to this mailing list. Thank you so much. Regards Andrea Fanni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: My sql Security

2010-04-28 Thread Vikram A
From: Johan De Meersman To: Vikram A Cc: MY SQL Mailing list Sent: Wed, 28 April, 2010 9:55:38 PM Subject: Re: My sql Security Rip out the DB authentication part, and store those credentials in-code, in some config file or the registry, or some remote mechanism like LDAP. If your

Re: My sql Security

2010-04-28 Thread Johan De Meersman
y login Authentication screen; I request you guide me how can > handle this. > > Thank you > > Vikram > > -- > *From:* Johan De Meersman > > *To:* Vikram A > *Cc:* MY SQL Mailing list > *Sent:* Wed, 28 April, 2010 2:10:45 PM > >

Re: My sql Security

2010-04-28 Thread Vikram A
from the other GUI/connecting tools though they have given a access to db? Thank you for the information. Vikram From: nwood To: Vikram A Cc: MY SQL Mailing list Sent: Wed, 28 April, 2010 3:39:23 PM Subject: Re: My sql Security On Wed, 2010-04-28 at 13:58

Re: My sql Security

2010-04-28 Thread nwood
On Wed, 2010-04-28 at 13:58 +0530, Vikram A wrote: > Hi all, > I have some security issues. I would like to have your suggestions/solutions. > > I have winserver2003 with mysql 5.1.45. We have client serve application that > allows multi-login system with various people. > > I am getting user na

Re: My sql Security

2010-04-28 Thread Johan De Meersman
I'm afraid you can't discern between clients and applications on the MySQL level. Your application authentication should be separate from the MySQL one. On Wed, Apr 28, 2010 at 10:28 AM, Vikram A wrote: > Hi all, > I have some security issues. I would like to have your > suggestions/solutions.

My sql Security

2010-04-28 Thread Vikram A
Hi all, I have some security issues. I would like to have your suggestions/solutions. I have winserver2003 with mysql 5.1.45. We have client serve application that allows multi-login system with various people. I am getting user name, password for database login when the try to use login [

My SQl Master -Slave Setup

2010-02-16 Thread Vikram A
Dear Sirs, I would like to have the MYSQL master and slave on my application setup. I am using windows vista and mysql 5.1.x what are the needed things for this master salve setup? So that, I can proceed further with manuals available. Thank you VIKRAM A The INTERNET now has a person

Re: MY SQL Slave Server

2010-02-07 Thread Thiyaghu CK
dows vista? As per your information, th >> emysql has to be installed once again another port; Is it possible to >> install 2 setups in a same system? >> >> Thank you >> >> VIKRAM A >> >> >> -- >> *From:* Thiyagh

Re: MY SQL Slave Server

2010-02-06 Thread prabhat kumar
0:08 PM, Vikram A wrote: > I tried to install once again mysql at vista? but deducts the previous > installation. and it is ask for the modify , repire and remove options > > You said that we can install any number of setups in a same system. > > Is there any other way to install

Re: MY SQL Slave Server

2010-02-06 Thread Vikram A
From: Thiyaghu CK To: Vikram A Sent: Sat, 6 February, 2010 3:05:25 PM Subject: Re: MY SQL Slave Server Hi Vikram, Ya sure, slave can be in vista. Yes, you can install 2 or more setups in same system but port has to be different, and if its linux platform change the sock name

Re: MY SQL Slave Server

2010-02-05 Thread Thiyaghu CK
Hi Vikram, So as my understanding you need to have a master slave setup in a single machine(FEDORA 11). 1. Make the already running mysql instance as Master 2. Install a new mysql in the same machine in different port which will be your slave 3. Replicate 4.You can also add more slave in same mac

MY SQL Slave Server

2010-02-05 Thread Vikram A
Dear Experts, I would like to configure the slave for my main server. My server is running in the FEDORA 11. I would like to make another mirror of the DB in the same server/ The copy of the DB can be kept at win server / another Fedora server. Can you suggest how to do the above? Thank you

Re: [MySQL] Re: Image Store @ My SQL

2010-01-30 Thread Ashley M. Kirchner
Vikram A wrote: Is it So? then i may have the following, when ever i want the image of a i need look for the share machine! If it is not available it may cause some difficulties. 1) NFS sharing a file (any file) is better suited for this task. 2) The DB should only hold the file path

Re: Image Store @ My SQL

2010-01-30 Thread Colin Streicher
Please share your knowledge > > Thank you > > > > > > > ____________ > From: Walter Heck > To: Vikram A > Cc: MY SQL Mailing list > Sent: Sat, 30 January, 2010 3:16:11 PM > Subject: Re: Image Store @ My SQL > > On Sat, Jan 30, 2010 at 19:03, Vikram A wrote: > >

Re: Image Store @ My SQL

2010-01-30 Thread Vikram A
may have the following, when ever i want the image of a i need look for the share machine! If it is not available it may cause some difficulties. Please share your knowledge Thank you From: Walter Heck To: Vikram A Cc: MY SQL Mailing list Sent: Sat, 30

Re: Image Store @ My SQL

2010-01-30 Thread Walter Heck
am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32). > > We have an client server application, server is located at another end of an > intranet and the nodes are connected from different ends of intranet. > > In this modal, I need to store image of the student fr

Re: Image Store @ My SQL

2010-01-30 Thread Walter Heck
On Sat, Jan 30, 2010 at 19:03, Vikram A wrote: > I am not clear with your answer, can you please explain it? Well, MySQL (as most databases) is not really suited for storing images. If you create a networked storage that you can share between both locations, that would solve your problem, right?

Re: Image Store @ My SQL

2010-01-30 Thread Vikram A
Store @ My SQL Bad idea. Sotring images is what a file system is for. Create an NFS or other networked storage and store your images there. I don't see the problem? good luck, Walter Heck Engineer @ Open Query (http://openquery.com) On Sat, Jan 30, 2010 at 18:54, Vikram A wrote: > Hi,

Image Store @ My SQL

2010-01-30 Thread Vikram A
Hi, I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32). We have an client server application, server is located at another end of an intranet and the nodes are connected from different ends of intranet. In this modal, I need to store image of the student from one node that

Re: Please solve immediately Error found in migration from MS SQL 2000 to My sql

2006-07-11 Thread Vitaliy Okulov
Здравствуйте, Kishore. Вы писали 10 июля 2006 г., 16:52:29: > Database Migration Error: > My database is stored in MSSQL Server 2000 in a standalone system in windows > authentication mode means without any username and password. I am writing my > whole process & problem if you people could solve

Re: Please solve immediately Error found in migration from MS SQL 2000 to My sql

2006-07-10 Thread Daniel da Veiga
On 7/10/06, Kishore Kumar Barik <[EMAIL PROTECTED]> wrote: Database Migration Error: My database is stored in MSSQL Server 2000 in a standalone system in windows authentication mode means without any username and password. I am writing my whole process & problem if you people could solve my probl

Re: Please solve immediately Error found in migration from MS SQL 2000 to My sql

2006-07-10 Thread Jake Peavy
On 7/10/06, Kishore Kumar Barik <[EMAIL PROTECTED]> wrote: < snip > Please send me solution immediately. anything else, your highness? -- -jp Chuck Norris got in touch with his feminine side, and promptly got her pregnant.

Please solve immediately Error found in migration from MS SQL 2000 to My sql

2006-07-10 Thread Kishore Kumar Barik
Database Migration Error: My database is stored in MSSQL Server 2000 in a standalone system in windows authentication mode means without any username and password. I am writing my whole process & problem if you people could solve my problem. In Source Connection Parameter Stored Connection : myL

RE: How can I use a value computed in my SQL query for further computations? [solved]

2006-04-17 Thread Daevid Vincent
PROTECTED] > Sent: Monday, April 17, 2006 7:42 PM > To: mysql@lists.mysql.com > Subject: RE: How can I use a value computed in my SQL query > for further computations? > > To add to this, I will also want to be able to "ORDER BY" > those three new > columns (total

RE: How can I use a value computed in my SQL query for further computations?

2006-04-17 Thread Jay Blanchard
[snip] Here is a paired down version of a query I want to make. How can I get the "grandtotal" column? I know about the "HAVING" clause, but that's only going to be good for weeding out rows I don't want. I just want to do some basic math here. [/snip] More http://dev.mysql.com/doc/refman/5.1/en/e

RE: How can I use a value computed in my SQL query for further computations?

2006-04-17 Thread Jay Blanchard
[snip] Here is a paired down version of a query I want to make. How can I get the "grandtotal" column? I know about the "HAVING" clause, but that's only going to be good for weeding out rows I don't want. I just want to do some basic math here. SELECT a.*, DATE_FORMAT(a.created_on,'%m/%d

RE: How can I use a value computed in my SQL query for further computations?

2006-04-17 Thread Daevid Vincent
database, and it seems silly that I should have to use PHP to do basic math on the table when mySQL can do it probably faster. > -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED] > Sent: Monday, April 17, 2006 7:33 PM > To: mysql@lists.mysql.com > S

How can I use a value computed in my SQL query for further computations?

2006-04-17 Thread Daevid Vincent
Here is a paired down version of a query I want to make. How can I get the "grandtotal" column? I know about the "HAVING" clause, but that's only going to be good for weeding out rows I don't want. I just want to do some basic math here. SELECT a.*, DATE_FORMAT(a.created_on,'%m/%d/%y %h:

GMT->DST time conversion in (My)SQL ?

2004-04-08 Thread Rainer Krienke
Hello, i have a table that contains datetime entries which are stored in GMT. Now I would like to convert these datetime values in a select statement to local time. I first thought of someting like this (in germany DST starts at 2004-03-29 02:00:00 and ends "2004-10-31 03:00:00" this year. The

My SQL Database Synchronization Question

2004-02-04 Thread Paul Maine
I have two MySQL databases that are networked together. If changes can be made independently to each of the databases - what is the best way to synchronize them? How can I synchronize them in real time? If the network link goes down, can the synchronizations be placed upon a queue until the connect

RE: My SQL for OLTP Systems?

2004-02-03 Thread Félix Beltrán
Hi Alexander, How do you compare MaxDB features against other DB products, for example SQLServer? Regards FBR "Schroeder, Alexander" <[EMAIL PROTECTED]> 03/02/2004 09:38 a.m. To "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc Subject RE: My SQL

My SQL for OLTP Systems?

2004-02-03 Thread Félix Beltrán
Has anyone used MySQL as the database for an Online Transaction Proccessing Systems? (for example an ERP) What about MaxDB? FBR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

My sql download

2003-12-24 Thread Cordoba-Ruiz, Laura
Dear Sir/Madam, I would like to download MySql to my computer and I think I am not downloading the correct file. My computer is a Mac and the sytem is OS 10.1. Is there a version of MySql for 10.1? Thank you Laura Co

Re: My SQL setup issue

2003-12-15 Thread Gerald Jensen
4, 2003 1:51 PM Subject: My SQL setup issue > Hello, > > I am unable to start MySQL 4.0. I tried installing it from a mirro image. All looks OK, but when I try to initiate it, I reveive ERROR moving data -103 server. Then I initiate WinMySQLAdmin and I believe I am supposed to be p

My SQL setup issue

2003-12-14 Thread Will5W
Hello, I am unable to start MySQL 4.0. I tried installing it from a mirro image. All looks OK, but when I try to initiate it, I reveive ERROR moving data -103 server. Then I initiate WinMySQLAdmin and I believe I am supposed to be prompted for "Name and Password". I actually get a window wi

RE: My SQL Search

2003-08-26 Thread Granzow, Doug (NIH/NCI)
> -Original Message- > From: Nathan Simms [mailto:[EMAIL PROTECTED] > The problem is that I need my statement to search the > product_name and > description fields as well. However when I add them to my > statement, it > doesn't work??? > The statment below does not work: > > SELE

Re: My SQL Search

2003-08-23 Thread Nathan Simms
I am searching for a specific company name that gets passed to this page. I tried adding the mysql statement: SELECT product_id, company_name, product_name, url, description FROM product, company WHERE product.product_id = company.company_id AND description LIKE '%FORM.query%' AND company_name L

Re: My SQL Search

2003-08-23 Thread Antony Dovgal
On Fri, 22 Aug 2003 23:28:18 + "Nathan Simms" <[EMAIL PROTECTED]> wrote: > Hi, I'm currently using the following mysql statement to perform a search. > Right now it is only returning the results which are found in the > description field. How do I modify this statement so that it is searching

My SQL Search

2003-08-22 Thread Nathan Simms
Hi, I'm currently using the following mysql statement to perform a search. Right now it is only returning the results which are found in the description field. How do I modify this statement so that it is searching the following fields: company_name, product_name, description. SELECT product_id,

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-08-01 Thread Victoria Reznichenko
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > mysql> SHOW VARIABLES LIKE "have_innodb"; > +---+--+ > | Variable_name | Value| > +---+--+ > | have_innodb | DISABLED | > +---+--+ > 1 row in set (0.02 sec) > > mysql> > > === > >

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-07-31 Thread Morten Gulbrandsen
ly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ? "Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > > according to what I experience, > I do definitely run the default binaries, perhaps the daemon mysqld > has to be started with an option in order to support InnoDB

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-07-31 Thread Morten Gulbrandsen
MAIL PROTECTED] Gesendet: Donnerstag, 31. Juli 2003 14:59 An: Morten Gulbrandsen Cc: [EMAIL PROTECTED] Betreff: Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ? Hi, On Thu, Jul 31, 2003 at 02:46:06PM +0200, Morten Gulbrandsen wrote: > According to the manual : >

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-07-31 Thread Victoria Reznichenko
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > > according to what I experience, > I do definitely run the default binaries, perhaps the daemon mysqld > has to be started with an option in order to support InnoDB ? > > How can this be investigated ? > > C:\mysql\bin>mysqld -v > mysqld V

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-07-31 Thread Fred van Engen
Morten, On Thu, Jul 31, 2003 at 03:27:51PM +0200, Morten Gulbrandsen wrote: > according to what I experience, > I do definitely run the default binaries, perhaps the daemon mysqld > has to be started with an option in order to support InnoDB ? > > How can this be investigated ? > Well, I ne

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-07-31 Thread Morten Gulbrandsen
Dear Fred, according to what I experience, I do definitely run the default binaries, perhaps the daemon mysqld has to be started with an option in order to support InnoDB ? How can this be investigated ? C:\mysql\bin>mysqld -v mysqld Ver 3.23.55-max-debug for Win95/Win98 on i32 C:\mysql\b

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-07-31 Thread Fred van Engen
Hi, On Thu, Jul 31, 2003 at 02:46:06PM +0200, Morten Gulbrandsen wrote: > According to the manual : > > "7.5.5.2 Foreign Key Constraints > Starting from version 3.23.43b InnoDB features foreign key constraints. > InnoDB is the first MySQL table type which allows you to define foreign > key constr

I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

2003-07-31 Thread Morten Gulbrandsen
Dear MySQL developers, Could some experienced Database developer please take a look at this ? It is supposed to be plain SQL2. How can it be coded under MySQL Especially all referential triggered actions. According to the manual : "7.5.5.2 Foreign Key Constraints Starting from version 3.23

My SQL

2003-07-24 Thread Phi11w
You won't remember but !!! Back in august 2002, you sent me the upload address to get the pkg for Mysql from apple.com. All was well in the world, it ran fine. However I have had a disk crash & had to reinstall everything !! 2.6.5.1 of the manaul states MySQL is okay for 10.x, but 2.1.3 states

Re: My SQL ERROR 2002

2003-06-09 Thread Egor Egorov
"skjois" <[EMAIL PROTECTED]> wrote: > I get this error > > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > how can i get rid of this? Easily. Start MySQL and get rid of the message. :-) -- For technical support contracts, goto https://order.mysql.

My SQL ERROR 2002

2003-06-09 Thread skjois
Hello, I get this error ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) how can i get rid of this? Regards, Shashi Kiran.

Re: Problems installing DBD::mysql for My SQL 4

2003-06-02 Thread James Marcinek
> I believe the package you are looking for is > > zlib-devel > > The latest version from redhat is available at > http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm > > Thanks, > Ryan Yagatich > > ,_, > \ Ryan Yagatich

Re: Problems installing DBD::mysql for My SQL 4

2003-06-02 Thread Ryan Yagatich
I believe the package you are looking for is zlib-devel The latest version from redhat is available at http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL

Problems installing DBD::mysql for My SQL 4

2003-06-02 Thread James Marcinek
I know this isn't the perl list but I'm thinking that some one out there has installed MySQL 4 on Red Hat 8. I couldn't upgrade from MySQL 3. I tried to uninstall MySQL 3 but I had too many dependency errors. I keep trying to install the necessary packages but I have a problem with the DBD::mysql m

Re: My SQL & OS X setup - utterly, completely, 100% stumped

2003-04-06 Thread Ken Tozier
On Sunday, April 6, 2003, at 10:28 AM, B. van Ouwerkerk wrote: You don't explain your problem. First problem is that after doing a clean install of mysql-standard-4.0.12 and following the instructions cd /usr/local/mysql sudo ./bin/mysqld_safe (Enter your password) (Press CTRL+Z) bg

Re: My SQL & OS X setup - utterly, completely, 100% stumped

2003-04-06 Thread B. van Ouwerkerk
You don't explain your problem. You don't even tell which versions you're running. If there is no mysql table then you didn't create it, or you trashed it. In the manual you will find references to how to install MySQL on MAC OS X. http://www.mysql.com/doc/en/Mac_OS_X_installation.html IMHO you

My SQL & OS X setup - utterly, completely, 100% stumped

2003-04-06 Thread Ken Tozier
Anyone willing to help a newbie walk through setup and install? I've tried everything specified in the online documentation, the tips on Marc Lynnage's page, install tips in several MySQL books multiple times. I've read all error messages and tried my best to figure out how to work around them.

Help My Sql

2003-03-05 Thread Asif Solkar
Please Send me a link from where i can download MySql Database for windows and MySqlGui for windows i have been trying to download from the site (MySql.com) but was unable to do so please send me at earliest Awaiting for ur mail Asif __ Do you Yahoo

Re: My SQL

2003-01-24 Thread Brent Baisley
hen design a web interface to your database using PHP, Perl or many other things. The OS9 machines would access it through their web browser. On Friday, January 24, 2003, at 01:34 AM, Jonas Rosenbloom wrote: How do I download and install My SQL for Mac OS 9? -- Brent Baisley Systems Architec

My SQL

2003-01-24 Thread Jonas Rosenbloom
How do I download and install My SQL for Mac OS 9? Thanks, Jonas *-*-*-*-*-*-*-*-*-*-*-* Jonas Rosenbloom 1042 Shirley Drive Henderson, NC 27536 Phone: 252-492-5754 [EMAIL PROTECTED] *-*-*-*-*-*-*-*-*-*-*-* - Before posting

missing big5.conf in my sql

2003-01-15 Thread Warren
Dear Sir/ Madam, I noticed that the character set big5 is missing in the installation file of My SQL but the index file indicate that MySQL does have this character set. Is there a place to download it? Please help me. Thank you in advance. Yours, Warren

Re: My SQL

2002-11-26 Thread Jan Steinman
>From: Miki Tan <[EMAIL PROTECTED]> > >I am Miki Tan from Gleneagles Medical Centre. >I am interested in MySQL database development. > >1.Can I know with platform is suit for MYSQL ? It works very nicely with MacOS X. The only time it ever goes down is when I install an update. SQL SQL SQL

Re: My SQL

2002-11-26 Thread Iikka Meriläinen
On Mon, 25 Nov 2002, Miki Tan wrote: > Hello, > > I am Miki Tan from Gleneagles Medical Centre. > I am interested in MySQL database development. > > 1.Can I know with platform is suit for MYSQL ? Hi, and welcome to the wonderful world of open-source database development! See this for platform no

My SQL

2002-11-25 Thread Miki Tan
Hello, I am Miki Tan from Gleneagles Medical Centre. I am interested in MySQL database development. 1.Can I know with platform is suit for MYSQL ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -

my SQL table Utility question

2002-09-20 Thread Menard, Paul
All, Anyone know of a utility that will perform basically a diff between 2 MySQL tables? I have a development project I was handed that someone else started. The project was to extend functionality of a set of programs and required changes/additions etc to various database table. I'm reall

About index in my sql

2002-05-21 Thread ???
Create a table like this: CREATE TABLE itg_passwd ( Username char(20) NOT NULL default '', Password char(20) NOT NULL default '', PRIMARY KEY (Username), KEY (Password(4)) ) TYPE=MyISAM; And insert some data; insert into itg_passwd values('1','h1'), ('2','h2'), ('3','h1/a'); Then

About index in my sql!

2002-05-21 Thread ???
Create a table like this: CREATE TABLE itg_passwd ( Username char(20) NOT NULL default '', Password char(20) NOT NULL default '', PRIMARY KEY (Username), KEY (Password(4)) ) TYPE=MyISAM; And insert some data; insert into itg_passwd values('1','h1'), ('2','h2'), ('3','h1/a'); Then

Re: My SQL ++ Bug and Port

2002-04-19 Thread Sinisa Milivojevic
Thank you for your report. Yes, I know about this leak in Windows version. It is due to it's stack limitations. Current developrment branch has this leask fixed already ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_

My SQL ++ Bug and Port

2002-04-19 Thread Edward Riede
I am working with the MySql++ 1.7.9 on windows98 using borland C++ 6.0. I have found and fixed a memory leak ( applicable on all platforms that need the __USLC__ conditional defined) , and sucessfully ported the system to borlanbd C++ 6 with a very minimum of modifications. (mostly resolving in

MY SQL Installation Problem

2002-03-21 Thread Egor Egorov
Suresh, Thursday, March 21, 2002, 6:48:47 AM, you wrote: SRS> I am getting following error msg when I try to install SRS> MySQL using rpm -i My* SRS> error: MySQL-3.23.49a-1.i386.rpm cannot be installed SRS> error: failed dependencies: SRS> data-showtable is needed by SRS> Msql-Mysql-DBI

MY SQL Installation Problem

2002-03-20 Thread Suresh R. Soni
Hi All, I am getting following error msg when I try to install MySQL using rpm -i My* error: MySQL-3.23.49a-1.i386.rpm cannot be installed error: failed dependencies: data-showtable is needed by Msql-Mysql-DBI-perl-bin-1.1823-1 DBI-perl-bin is needed by Msql-Mysql-DBI-perl-bin-1.

Re: My SQL TIME_FORMAT

2002-02-12 Thread mike
Hello, Removing the quotations worked. Thanks for the help. Mike - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, February 09, 2002 5:54 PM Subject: Re: My SQL TIME_FORMAT > Hello mike

Re: My SQL TIME_FORMAT

2002-02-12 Thread DL Neil
Hello mike > I've been reading about TIME _FORMAT in the mysql manual. Does this only > work > with a manually entered time? > SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name; > > I tried this, > SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name; > to format my ti

My SQL TIME_FORMAT

2002-02-12 Thread mike
Hello, I've been reading about TIME _FORMAT in the mysql manual. Does this only work with a manually entered time? SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name; I tried this, SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name; to format my time column, But it di

Re: My SQL TIME_FORMAT

2002-02-09 Thread mike
Hello, Removing the quotations worked. Thanks for the help. Mike - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, February 09, 2002 5:54 PM Subject: Re: My SQL TIME_FORMAT > Hello mike

Re: My SQL TIME_FORMAT

2002-02-09 Thread DL Neil
Hello mike > I've been reading about TIME _FORMAT in the mysql manual. Does this only > work > with a manually entered time? > SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name; > > I tried this, > SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name; > to format my ti

My SQL TIME_FORMAT

2002-02-09 Thread mike
Hello, I've been reading about TIME _FORMAT in the mysql manual. Does this only work with a manually entered time? SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name; I tried this, SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name; to format my time column, But it di

Subselect/set query..pardon my SQL

2002-01-07 Thread jerry
Hi- I know this is wrong because it doesn't work: select name from table1 where id="03" and not in (select id from table1 where (id <> "10") AND (id <> "20") AND (id <> "37") table1 name id a 03 a 11 a 12 a 13I want a returned because it has a 03 and not a 10, a 20,

tunning up my sql

2001-12-12 Thread Hernan Del Boca
Hello, im wondering if anybody can tell me how can i tune up my sql so that can run smoothly... if there is any packet i should install... i have a debian linux in a pentium 3 800 mhz with 256. thanks Hernan - Before posting

My SQL for NT versus MySQL for Linux

2001-10-25 Thread Mark Holder
My website is currently being hosted on a Linux box, and I am wanting to incoporate a database using MySQL. I have downloaded the NT version of MySQL to develop the db with, and am wondering what impact, if any, running it on the Linux box will have. Are the compatible ??? Thanks in advance, M

Re: my sql driver

2001-10-04 Thread alec . cawley
You need the mm.mysql driver, which can be downloaded from http://sourceforge.net/projects/mmmysql/ Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: my sql driver

2001-10-04 Thread Carl Troein
sha writes: > hello sir What an odd way to address a crowd. :-o > i have a problem that is when i installed mysql in my system it's driver was not loaded in my system. from where can i get this and how can i use it i m to use it for jdbc and my operating system is windows 2 000 prof. If w

my sql driver

2001-10-04 Thread sha
hello sir, i have a problem that is when i installed mysql in my system it's driver was not loaded in my system. from where can i get this and how can i use it i m to use it for jdbc and my operating system is windows 2000 prof. thank u. -- sha Join 18 million Eudora users by signing

Win2K/MS Access 2K/My SQL

2001-10-01 Thread Paul @ KB Technology
Hi, I have an application written in MS Access 2000 which has linked tables from a MYSQL database. I'm having a problem running queries which update the linked tables. I can update individual records ok from Access, but as soon as i tried to run a query, the query failes saying X number of recor

my sql data base

2001-07-25 Thread VVM Ravikumar Sarma Chengalvala
Apologies in advance: I am a developer with mysql and active and my work involved CAPI of MYSQl,Database DeZign with Dezign and database development. Currently looking out for job opportunities in mySQl related areas.Can suggest me any exclusive websites and openings in mysql related areas. ..

Re[2]: Migration from Access 2000 to my SQL

2001-07-09 Thread Werner Stuerenburg
You find a list of converters on page http://www.mysql.com/downloads/contrib.html#SEC596 for example dbf2mysql-1.14.tar.gz Convert between `.dbf' files and MySQL tables exportsql.txt A script that is similar to access_to_mysql.txt, except that this one is fully configurable, has better type con

Re: Migration from Access 2000 to my SQL

2001-07-09 Thread Ken Menzel
PROTECTED] Amicalement, Ken - Original Message - From: "Matthieu Neukirch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 10:30 AM Subject: Migration from Access 2000 to my SQL Cordialement, We have made up our mind to turn our Access 2000 data

Re: Migration from Access 2000 to my SQL

2001-07-09 Thread Cal Evans
Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Matthieu Neukirch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 09:30 Subject: Migration from Access 2000 to my SQL Cordialement, We ha

Migration from Access 2000 to my SQL

2001-07-09 Thread Matthieu Neukirch
Cordialement, We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33

Re: runnning my sql with windows98 and pws

2001-06-26 Thread Seung-woo Nam
lipp & maimone wrote: > is someone abble to tell me how can i do for running an sql database with windows98 >without crashing my systeme? > Also, using asp ( activex server page ), is it possible with mysql version3,23? > > Its most likely that you don't have enough memory on your system. If

RE: runnning my sql with windows98 and pws

2001-06-26 Thread sean . odonnell
MAIL PROTECTED]] Sent: Tuesday, June 26, 2001 2:12 AM To: [EMAIL PROTECTED] Subject: runnning my sql with windows98 and pws is someone abble to tell me how can i do for running an sql database with windows98 without crashing my systeme? Also, using asp ( activex server page ), is it possi

runnning my sql with windows98 and pws

2001-06-25 Thread lipp & maimone
is someone abble to tell me how can i do for running an sql database with windows98 without crashing my systeme? Also, using asp ( activex server page ), is it possible with mysql version3,23?

Re: my sql query retrieval(Urgent)

2001-06-22 Thread Benjamin Pflugmann
Hi. On Fri, Jun 22, 2001 at 05:31:32PM +0100, [EMAIL PROTECTED] wrote: > Hi, > Is there a way to retrieve the field values in the > same order as during insertions based on something > like rowid or so?? No. Insertion order is not kept anywhere. Use an AUTO_INCREMENT column to obtain an key to O

RE: my sql query retrieval(Urgent)

2001-06-22 Thread Don Read
On 22-Jun-01 VVM Ravikumar Sarma Chengalvala wrote: > Hi, > Is there a way to retrieve the field values in the > same order as during insertions based on something > like rowid or so?? > Eg: > Insertion order into a table for a text field: > bbb > > abaa > aa > > Retrieval order: >

my sql query retrieval(Urgent)

2001-06-22 Thread VVM Ravikumar Sarma Chengalvala
Hi, Is there a way to retrieve the field values in the same order as during insertions based on something like rowid or so?? Eg: Insertion order into a table for a text field: bbb abaa aa Retrieval order: I want to have the retrieval order also the same.The output of the query on tha

Re: my sql database query retrieval order

2001-06-22 Thread Benjamin Pflugmann
Hi. There may be some internal order, but according to the SQL specification, you may not rely on it. The order of records of a query without ORDER BY is undefined on purpose. Bye, Benjamin. On Fri, Jun 22, 2001 at 01:43:33PM +0100, [EMAIL PROTECTED] wrote: > Hi, > I wonder to know if

my sql database query retrieval order

2001-06-22 Thread VVM Ravikumar Sarma Chengalvala
Hi, I wonder to know if mysql follows any order in retrieving the data from a table.i.e Is it based on ascending row order or descending row order. --Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or

Re: my sql pattern search and support for backslash??

2001-06-18 Thread SDiZ Cheng
try some more then.. try // or / or .. . > Hi, > I donot even get that with an additional backslash > also.In my case it just ignores the backslash and goes > ahead with the search . > Regards, > Ravi > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On > Mon, Jun 18, 2001 at 04:32:5

Re: my sql pattern search and support for backslash??

2001-06-18 Thread VVM Ravikumar Sarma Chengalvala
Hi, I get the following based on my requirement: This time it returned an empty set.See the last.Sometimes it is ignoring the backslash altogeather. I want to search a string like "ah\bl" in "blah\blah". Regards, Ravi mysql> use dbhub; Database changed mysql> CREATE TABLE slash_test ( foo VARCH

  1   2   >