No there isn't. You'll need to DELETE first and then UPDATE. Ie. delete 4
first and then update 2.
- Original Message -
From: Artem Koutchine [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 29, 2001 22:43
Subject: UPDATE/REPLACE command
Hi!
Was UPDATE/REPLACE command
Hello,
I am having a lot of trouble trying to find the best
way to write the SQL to do the following:
I have a table called referrals. In this table I
have a column called ref. The data in the ref column
are of the form p/$promo_id/$date. An example would
be p/26/20010629 which says
P.S. You could also UPDATE 4 first with the new value and then DELETE 2.
- Original Message -
From: Rolf Hopkins [EMAIL PROTECTED]
To: Artem Koutchine [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, July 01, 2001 15:03
Subject: Re: UPDATE/REPLACE command
No there isn't. You'll
You'll need MyODBC to connect from Access to MySQL.
- Original Message -
From: Manuel Mesquita [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 0:52
Subject: Access to Other Databases Thru MySQL
Dear Sirs,
We are new in MySQL. We work basically with Microsoft
- Original Message -
From: Felicia [EMAIL PROTECTED]
To: mysql post [EMAIL PROTECTED]
Sent: Sunday, July 01, 2001 2:06
Subject: mysql/php query from 2 tables
im having problems getting results querying two tables but I am not sure
of
the correct php syntax for the query statement
This is way off topic and you should seek an MS Access help list. [Zip Code
Distance Extractor] could refer to any number of diff things such as a
column in a table, a table name, a field on a form. The ! also has several
different meanings and you should be able to find it in help files.
MySQL.
i installed a a package install of the latest MySQL -of the unix [Mac
OS X] variety.
here's what i did (after the package installed installed itself):
- i did this logged in as an administrator (me) AND below wherever it
says mysql (as username) i entered my own username... so on the
Hi everyone!
I'm starting with mysql!
I wish to know if it is possible to make a table that has to columns linked by
a mathematic expression. For example:
My table is my_tbl;
And it has three colums: column_1, column_2 and column_3;
Every column have int or float values;
And for example, I want
Hi,
Recently I tried to move mysql databases to another location where much more
space.
First I copied all databases to new location
Then renamed /usr/local/var to /usr/local/var_old
Then make a symbolic link: ln -s /mnt/1 /usr/local/var
after that I reboot the system and it doesn't work
:
Hi,
Does anyone know how to fix the following error?
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I get this by typing mysql at the shell prompt (ie C:\mysql\ mysql
[return])
MySQL is installed in the default C:\mysql. I'm running NT 4.0 with SP4
the Option Pack and version
[EMAIL PROTECTED] wrote:
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:
database,sql,query,table
If you just reply to this message, and include the
Rolf Hopkins wrote:
This is way off topic and you should seek an MS Access help list.
Excuse me. I am working in MySQL. I see no reference whatever to MS Access
in my message. How do you
figure this is off topic?
[Zip Code Distance Extractor] could refer to any number of diff things
Dear friends,
I have tried to access the tables in the mysql database (the user, host tables) so as
to grant some privileges to a user and I think I accidentally deleted an entry for
root - the one that granted me access to mysql and now I cannot get in anymore from
any machine, it says access
I am getting a few errors on the index page of
my site. I am running the page on a windwos 2000 adv
server with Mysql and PHP. I have also installed the
ODBC module. The errors I am getting are as follows:
Warning: MySQL Connection Failed: Access denied for
user: 'mark@localhost' (Using
A client has asked us to make him an application that requires us keeping
Credit Card Numbers. I'm a bit concerned as it immediately remined me of
egghead.com (having all their CC #'s stolen).
One of the ideas was to have the users password encrypted as an md5 hash,
and then to encrypt the users
- Original Message -
From: Chris Cameron [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 01, 2001 2:27 PM
Subject: Storing Credit Cards
One of the ideas was to have the users password encrypted as an md5 hash,
and then to encrypt the users CC with their password. So we
I am running a website that users enter a credit card # (we have several
hundred thous users and this works fine) and they are stored in the
database, and their membership is renewed monthly. I keep the credit card
#'s in a seperate database with strict permissions, and ALL data is
encrypted
for what company do you work if you dont mind me asking?
- Original Message -
From: Derick Dorner [EMAIL PROTECTED]
To: Chris Cameron [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, July 01, 2001 3:23 PM
Subject: Re: Storing Credit Cards
I am running a website that users enter a
well the one that hold the credit cards. what company do you work for ?
- Original Message -
From: Luis [EMAIL PROTECTED]
To: Derick Dorner [EMAIL PROTECTED]; Chris Cameron [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, July 01, 2001 3:51 PM
Subject: Re: Storing Credit Cards
for
I'm running mysql on a lan with out a connection so I just copied the report
here.
When I run ./configure /usr/local/mysql it ends with the error
./configure ends with error: checking for termcap functions library...
configure: error: No curses/termcap library found
I sure it's just a library
Hi everyone!
I'm starting with mysql!
I wish to know if it is possible to make a table that has to columns linked by
a mathematic expression. For example:
My table is my_tbl;
And it has three colums: column_1, column_2 and column_3;
Every column have int or float values;
And for example, I want
Rolf Hopkins wrote:
This is way off topic and you should seek an MS Access help list.
Excuse me. I am working in MySQL. I see no reference whatever
to MS Access
in my message. How do you
figure this is off topic?
Sir, Rolf had no way of knowing that you didn't know that you were
On 01-Jul-01 Tim wrote:
I'm running mysql on a lan with out a connection so I just copied the report
here.
When I run ./configure /usr/local/mysql it ends with the error
./configure ends with error: checking for termcap functions library...
configure: error: No curses/termcap library
- Original Message -
From: Thomas J Keller [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 2:49
Subject: Re: Strange pseudo-coded query
Rolf Hopkins wrote:
This is way off topic and you should seek an MS Access help list.
- Original Message -
From: help [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 3:55
Subject: Mysql error (Index page)
I am getting a few errors on the index page of
my site. I am running the page on a windwos 2000 adv
server with Mysql and PHP. I have
Take a look at http://www.devshed.com/Server_Side/PHP/PHP101_4/ there are
also some other good reference material there on this.
Cheers
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 01, 2001 7:54 PM
To: help; [EMAIL PROTECTED]
Subject: Re: Mysql
Hello All!
I am just starting to learn mysql so forgive if i sound so beginner here.
I have 2 tables, table1 and table2. At table1, i have username and consumed
field_names. at table2, i have username and duration fieldname.
I need to put the value of duration to consumed. How will I do that?
Hi all,
I try the solution from David but seem it didn't work.
Here is my steps:
1) Stop the mysql services.
2) Move the ecom database directory from '/var/lib/mysql/ecom' to
'/home/ecom'
3) Make symbolic link in '/var/lib/mysql' using 'ln -sf /home/ecom ecom'
4) Start the mysql services.
5)
On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote:
Hi, everybody here,
Anybody can help with telnet to Linux and login to mySQL, show
information about current mysql setting, create new DB, and table?
What on earth does this have to do with MySQL on NFS?
--
Jeremy D.
On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote:
On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote:
Hi, everybody here,
Anybody can help with telnet to Linux and login to mySQL, show
information about current mysql setting, create new DB, and table?
What
On Sun, Jul 01, 2001 at 08:12:37PM -0700, Kelsey Cummings wrote:
On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote:
On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote:
Hi, everybody here,
Anybody can help with telnet to Linux and login to mySQL, show
On Sun, Jul 01, 2001 at 08:21:39PM -0700, Jeremy Zawodny wrote:
On Sun, Jul 01, 2001 at 08:12:37PM -0700, Kelsey Cummings wrote:
On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote:
On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote:
Hi, everybody here,
I am trying to connect to my database with mysqlgui
as root. I have gone into options and entered the
port number and the path to the socket. I have ask for
password checked on and am using the same password that
works when I do mysql -u root -p. I have tried accessing
the mysql db and a test
Hi Everybody,
1. I am unable to login on my remote Mysql Server
installed on Linux..
Perhaps I forgot the password or something else..
How can I solve this problem.
2. My Second problem earlier I use to login successful and when trying to create or
use database it gives authontication
Hi all,
I am a newbie in MySQL and would like to know if there is a list of error
codes for accessing MySQL database.
What I am asking is something like What is the return error code for record
(or row) not found? or What is the return error code if table doesn't
exist, etc?
Thanks in advance.
On Sat, Jun 30, 2001 at 03:40:53PM -0400, Jason Brunk wrote:
i was wondering if anyone could help out with some replication
stuff. i went through the instructions from mysql.com and when i
restarted the slave, it said that it was not configured correctly.
We're gonna need more details than
On Sun, Jul 01, 2001 at 08:25:01PM -0700, Kelsey Cummings wrote:
I wondered about that too. I managed to find the list archives
so I answered my own questions.
Great. I was just about to answer you. :-)
Well, just to be clear then, lots of people are using NetApp NFS
backends
37 matches
Mail list logo