Re: Unsubscribing my sql mailing list

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

Unsubscribing my sql mailing list

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

My sql Security

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

Re: My sql Security

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 vikkiatb...@yahoo.in wrote: Hi all, I have some security issues. I would like to have your

Re: My sql Security

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 name,

Re: My sql Security

from the other GUI/connecting tools though they have given a access to db? Thank you for the information. Vikram From: nwood nw...@plus.net To: Vikram A vikkiatb...@yahoo.in Cc: MY SQL Mailing list mysql@lists.mysql.com Sent: Wed, 28 April, 2010 3:39:23 PM

Re: My sql Security

Authentication screen; I request you guide me how can handle this. Thank you Vikram -- *From:* Johan De Meersman vegiv...@tuxera.be *To:* Vikram A vikkiatb...@yahoo.in *Cc:* MY SQL Mailing list mysql@lists.mysql.com *Sent:* Wed, 28 April, 2010 2:10:45 PM

Re: My sql Security

From: Johan De Meersman vegiv...@tuxera.be To: Vikram A vikkiatb...@yahoo.in Cc: MY SQL Mailing list mysql@lists.mysql.com 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

My SQl Master -Slave Setup

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

Re: MY SQL Slave Server

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 too. Regards, Thiyaghu CK www.mafiree.com On Sat, Feb 6

Re: MY SQL Slave Server

From: Thiyaghu CK theyaho...@gmail.com To: Vikram A vikkiatb...@yahoo.in 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

Re: MY SQL Slave Server

in a same system. Is there any other way to install? Please help me thank you From: Thiyaghu CK theyaho...@gmail.com To: Vikram A vikkiatb...@yahoo.in Sent: Sat, 6 February, 2010 3:05:25 PM Subject: Re: MY SQL Slave Server Hi Vikram, Ya sure, slave

MY SQL Slave Server

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: MY SQL Slave Server

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

Image Store @ My SQL

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

Re: Image Store @ My SQL

January, 2010 2:29:43 PM Subject: Re: Image 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

Re: Image Store @ My SQL

On Sat, Jan 30, 2010 at 19:03, Vikram A vikkiatb...@yahoo.in 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

Re: Image Store @ My SQL

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 has

Re: Image Store @ My SQL

Cc: MY SQL Mailing list mysql@lists.mysql.com 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 vikkiatb...@yahoo.in wrote: I am not clear with your answer, can you please explain it? Well, MySQL (as most databases) is not really

Re: Image Store @ My SQL

Heck wal...@openquery.com To: Vikram A vikkiatb...@yahoo.in Cc: MY SQL Mailing list mysql@lists.mysql.com 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 vikkiatb...@yahoo.in wrote: I am not clear with your answer, can you please

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

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

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

Здравствуйте, 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 my

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

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 :

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

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.

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

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

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

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

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

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 Subject: How can I use a value computed in my SQL query for further

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

[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/%y

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

[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

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

, 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 (totalviews, totalclicks, grandtotal) as well.. I'm using mySQL 5 and innodb

GMT-DST time conversion in (My)SQL ?

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

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

My SQL for OLTP Systems?

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]

RE: My SQL for OLTP Systems?

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 for OLTP Systems? Hello Felix, Max DB is in use

My sql download

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

Re: My SQL setup issue

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 prompted for Name and Password. I

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 prompted for Name and Password. I actually get a window

RE: My SQL Search

-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: SELECT

Re: My SQL Search

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 the

Re: My SQL Search

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

My SQL Search

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 ?

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 === Goodygood, Victoria

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

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

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 : 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 constraints

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

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\binmysqld -v mysqld Ver 3.23.55-max-debug for Win95/Win98 on i32

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

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 never

Re: I Specify explicitly 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 ? How can this be investigated ? C:\mysql\binmysqld -v mysqld Ver

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

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 : 7.5.5.2 Foreign Key Constraints Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table

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

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 ? How can this be investigated ? C:\mysql

My SQL

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

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

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

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

Problems installing DBD::mysql for My SQL 4

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

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

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

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

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

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

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

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

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

Help My Sql

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

My SQL

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

Re: My SQL

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 Architect Landover

missing big5.conf in my sql

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

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 notes:

Re: My SQL

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 SQL

My SQL

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

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

About index in my sql!

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

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

My SQL ++ Bug and Port

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

Re: My SQL ++ Bug and Port

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 Installation Problem

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

My SQL TIME_FORMAT

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

Re: My SQL TIME_FORMAT

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 time

Re: My SQL TIME_FORMAT

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 I've been reading about TIME

My SQL TIME_FORMAT

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

Re: My SQL TIME_FORMAT

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 time

Re: My SQL TIME_FORMAT

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 I've been reading about TIME

Subselect/set query..pardon my SQL

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, OR 37 b

My SQL for NT versus MySQL for Linux

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,

my sql driver

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

Re: my sql driver

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

Re: my sql driver

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)

Win2K/MS Access 2K/My SQL

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

my sql data base

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.

Migration from Access 2000 to my SQL

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: Migration from Access 2000 to my SQL

* * 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 have made up our mind to turn our

Re: Migration from Access 2000 to my SQL

] 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 database into a MySGL one. Could you please

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

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

RE: runnning my sql with windows98 and pws

]] 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 possible with mysql

Re: runnning my sql with windows98 and pws

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 you

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 possible with mysql version3,23?

my sql database query retrieval order

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 database query retrieval order

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 query retrieval(Urgent)

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

RE: my sql query retrieval(Urgent)

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: I want to

Re: my sql query retrieval(Urgent)

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

my sql and patter matching ....bug(Urgent)

Hi, I am facing the following problem in pattern matching: I want to check the pattern matching using LIKE on a field that is declared as Binary and also contains back slashes. eg: ID INT, NAME VARCHAR(128) BINARY I am using C-API of mysql to escape the characters like '\' for this field. The

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

On Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM Ravikumar Sarma Chengalvala wrote: Hi, Did mysql pattern search support a backslash character? Yes. Since it is a special character, make sure it is properly escaped. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk:

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

It depends on what you mean by pattern search? You probably have to escape the \ character. If you put a \ in front of a character it means this next character is what I say it is not it's MySQL representation. This would allow you to put a ; or ) in your query. Simply put \\ to mean a

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

It is not working even after escaping it.I am working on WINNT4.0 and mysql 3.23 --Regards, Ravi --- Scott Baker [EMAIL PROTECTED] wrote: It depends on what you mean by pattern search? You probably have to escape the \ character. If you put a \ in front of a character it means this next

my sql and pattern search--bug(most urgent)

Hi, Can someone get back to me at the earliest regarding mysql's support for backslash characters in pattern search.I am not able to search based on the string which contains a backslash character even after escaping.. Regards, Ravi Do

  1   2   >