because there isn't any partners table in the FROM
clause!
--- Justin French <[EMAIL PROTECTED]> ha scritto:
> Hi all,
>
> I have three tables:
>
> partners (id,name,url,desc)
> services (id,desc,category)
> partner_service_rel (pid,sid)
>
> Each partner offers a range of services, and each
>
Hi all,
I have three tables:
partners (id,name,url,desc)
services (id,desc,category)
partner_service_rel (pid,sid)
Each partner offers a range of services, and each services has an id,
description, and category.
Now, it's EASY to search for partners that offer a certain service, but I
can't fig
Stephen Tiano wrote:
[snip]
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
and I was greeted with:
ERROR 1148: The used command is not allowed with this MySQL version
There has to be a way to load data into tables as far back as the
ancient 3.__. Could anyone share with me what the correct
The manual I was able to download, I now notice, is for version
4.0.3-beta of MySQL. So that's the official tutorial I'm working. That
and Kevin Yank's Building a Database-Driven Web Site Using PHP and
MySQL--a '10-week course' that I also was able to download.
Problem has surfaced due to my ha
If you download the binary, there is nothing to compile. Just follow the
instructions in the file INSTALL_BINARY and you are ready to go. I did the
same on 10.2.2 server and it worked great.
Hth/h
On 1/20/03 2:21 PM, "James LaFountain" <[EMAIL PROTECTED]> wrote:
>
>
> I've been trying to compi
At 15:09 -0900 1/20/03, Rich Allen wrote:
Paul/others,
/usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:477:in `load_driver': Could
not load driver (uninitialized constant Mysql at DBI::DBD)
(DBI::InterfaceError)
from /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:384:in `_get_full_driver'
from /usr/lib/ruby/s
[EMAIL PROTECTED] wrote:
Hi list,
I have migrated to SQLServer, so I wonder if some one can direct me how to unsubscribe please.
Thanks.
Sam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
Hi list,
I have migrated to SQLServer, so I wonder if some one can direct me how to unsubscribe
please.
Thanks.
Sam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Paul/others,
/usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:477:in `load_driver': Could not
load driver (uninitialized constant Mysql at DBI::DBD)
(DBI::InterfaceError)
from /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:384:in `_get_full_driver'
from /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:364:in `connect'
f
Hi.
On Mon 2003-01-20 at 16:51:53 -0700, [EMAIL PROTECTED] wrote:
>
> Just a quick question. I am just starting to learn MySQL. I am on a
> windows XP pro computer but want to create scripts using php and cgi for
> all platforms. If I create a database using MySQL on windows, is the
> database t
Hello,
Just a quick question. I am just starting to learn MySQL. I am on a
windows XP pro computer but want to create scripts using php and cgi for
all platforms. If I create a database using MySQL on windows, is the
database transportable to Unix and Linux?
Thanks.
--
Hi.
On Mon 2003-01-20 at 15:05:46 -0700, [EMAIL PROTECTED] wrote:
> We need to store numbers that exceed the precision of the DOUBLE
> datatype. The mysql manual makes no mention of a size bigger than
> DOUBLE. Storing the number as a string is not preferable because of the
> extra space a charact
sql, query,
Hi, all,
As you may knew, mysql will implement "rename database" in version 4.1
Right now, I need to rename a database, what I plan to do is rename each
table (INNODB type, version 3.23.53 on MAC OS) to another new database.
RENAME TABLE current_db.tbl_name TO new_db.tbl_name;
Do y
Doll,
> My web server only accommodates mysql.
I wouldn't say "only", though :)
> Now, what do I need to do get this table operational for my website?
I
> wanted to create a search program for users.
Use PHP. It's easy to learn and works smoothly with MySQL. You will find
lots of examples how t
List Members:
My web server only accommodates mysql.
I've started to trancribe an 1866 census record with 8 columns of
information. The file was created in excel and I used an csv extension
(delimited) to import this information into the mysql data table. The
tables is completed.
Now, wha
I've been trying to compile MySQL 4.0.8 on Mac OS X Server 10.1.4 with the
supplied Development Tools CD.
Thing so far appear to work fine. But when I connect remotely (from another
machine on socket 3306), the server restarts (crashes). I've read the news
threads and I see this was also a pro
Sql, query,
Hi, all,
I found on our clients mysql database machines, there is no my.cnf file by
doing a global search, but when I did the following command, it seems that
mysql process is referring to this file
(--default-extra-file=/export/mysql/data/my.cnf ).
Do you think it's normal?
Than
We need to store numbers that exceed the precision of the DOUBLE
datatype. The mysql manual makes no mention of a size bigger than
DOUBLE. Storing the number as a string is not preferable because of the
extra space a character string would take up. One thought is to store
two integers: the digits t
In the last episode (Jan 20), Maximo Migliari said:
> YES, pretty please, with sugar on top: from now on also make
> available for us binary distributions of MySQL optimized for FreeBSD
> 5.0's new threading implementation.
>
> There is a very large FreeBSD user base that must not be ignored :)
F
Octavian,
> mysql> create table test(id float);
> mysql> insert into test values(1.123), (3.1495);
> mysql> select * from test where id=1.123;
> Empty set (0.00 sec)
> Shouldn't this last query show me the record that has the id=1.123?
Well ... 1.123 is greater than 1.123, see:
mysql> select id
Jannie,
> /etc/my.cnf. But there is no my.cnf file at that directory.
> So my question is:How to generate my.cnf based on existing
configuration?
You can see the server options for the MySQL server by issuing
mysqld --print-defaults
The output is pretty ugly, but it will show you all settings
Hello.
On Mon 2003-01-20 at 09:26:18 -0500, [EMAIL PROTECTED] wrote:
> I'm brand-new to MySQL/PHP and to this list, spending an interesting
> holiday weekend devoted to trying to start learning the
> MySQL/PHP/Apached axis.
>
> There're three things that had me thinking of just giving it all up
I have a Red Hat 7.3 box running MySQL 3.23.49 (installed with the Red Hat
rpms). I am about to upgrade to 4.0.9 and would prefer using the RPMs from
MySQL. My plan was to just un-install the Red Hat rpms and then install
the new rpms (after backing everything up first, of course). Is there
sql, query
Hi, all,
I started to support on an old mysql production database on SunOS 5.8 and
mysql version 3.23.47 with only MyISAM type of tables.
I take a look on /etc/init.d/mysql file, and in this file, it will refer
/etc/my.cnf. But there is no my.cnf file at that directory.
I cannot sh
Hi everyone,
I want to run a query that will combine the results of 5 columns into 1
column, and then group them by similar results so that only 1 instance is
returned.
I currently have the following query:
"SELECT Category
FROM gs_Products
GROUP BY Category
ORDER BY Category ASC"
How would I m
YES, pretty please, with sugar on top:
from now on also make available for us binary distributions of MySQL
optimized for FreeBSD 5.0's new threading implementation.
There is a very large FreeBSD user base that must not be ignored :)
Thanks!
Maximo.
At 14:20 20/1/2003 -0500, you wrote:
Alrighty
On Mon, Jan 20, 2003 at 01:14:53PM +0100, Rafal Jank wrote:
> Hi,
>
> I've just downloaded version 4.1 from bk and have problem with building it.
> What version of automake is needed? Because after
> > aclocal
> I get:
> aclocal: configure.in: 459: macro `AM_PROG_AS' not found in library
Youw
I didn't test it but you may try something like:
SELECT ddi, sum(tot_dur)
FROM table
GROUP BY ddi
ORDER BY ddi
On Mon, 2003-01-20 at 12:59, Steve Mansfield wrote:
> Using mysql 3.23.51
> I have a mysql table that holds records for telephone traffic.
> The table fields are as follows:
>
> id
On Monday 20 January 2003 12:15 am, Zysman, Roiy wrote:
> Hi All,
> I'm trying to insert multiple lines to a table with 3 col. All 3 of them
> are a part of the primary key.
> But while inserting the data , sometime occurs the situation where I
> want to insert an already exist entry with the same
Check the REPLACE command...
http://www.mysql.com/doc/en/REPLACE.html
I think it suits your problem...
On Mon, 2003-01-20 at 08:14, Michael Watson wrote:
> This may be very simple, but the solution eludes me..
>
> I have two tables Products and NewProducts, The Products table contains a
> list
Hi,
[root@localhost root]# perror 111
Error code 111: Connection refused
You don't seem to have the mysql server running.
First, be shure that your mysqld is up and running.
Then, correct your command: to reload the server from the command line
you should use "mysqladmin" command instead of "mys
Alrighty then!
Now FreeBSD 5.0 has been released, what are the plans for mysql to evaluate
the new (really new :) thread implementation.
Peter
<^_^>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
> 1. Check if you really need an unsigned column - if not just alter the column to
>signed
this is the most appropriate answer. i.e your table design should cater for the
"limited set" or "modulus" arithmatics.
Casting wouldn't work simply because you may really want the actual unsigned val
At 11:48 +0200 1/20/03, Putte Koivisto wrote:
I use MYSQL TO_DAYS function to grab some statistics from database and I use
next
statement:
SELECT ID FROM database
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) >=7
ORDER BY ID DESC
I have IIS server and I use Dreamweaver MX to build the statistics page
At 9:47 + 1/20/03, Sean Burlington wrote:
Daevid Vincent wrote:
This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html
replace works very nicley and is IMO a good extension to standard SQL
another way that may be suitable is to delete first and then insert
(this may erase da
Hello there,
I'm trying to compile MySQL 4.0.9-gamma under FreeBSD 4.7-Stable with
linuxthreads.
I installed linuxthreads through the ports system by doing:
cd /usr/local/ports/devel/linuxthreads
make
make install
it installed just fine.
I downloaded the source distribution of MySQL (not using t
At 12:29 -0500 1/20/03, Bill Easton wrote:
It appears that the stable, production version, 3.23 doesn't give an SQL
error when an INSERT ... SELECT would cause a duplicate primary key.
I believe the default behavior for INSERT ... SELECT is like INSERT IGNORE
... SELECT for 3.23.
4.0
does no
sql
> Do you have any idea how the release for qnx will be ready?
>
> Juan Cruz
> Veracruz, Ver.
> Mexico
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
It appears that the stable, production version, 3.23 doesn't give an SQL
error when an INSERT ... SELECT would cause a duplicate primary key. 4.0
does not appear to have the problem. (I discovered it when replicating from
3.23.49 Linux to a 4.0.1 Windows 2000--the server did not detect the
duplic
On Monday 20 January 2003 08:22, Octavian Rasnita wrote:
> But I don't want to perform a 15 - id, meaning 15 - 10.
> I want to calculate 5 - id, meaning 5 - 10.
>
> It should give me -5 or 5 but not | 18446744073709551611 |
The result of the above expression is UNSIGNED, because column 'id' is INT
On Monday 20 January 2003 16:16, David T-G wrote:
> create table pieces
> (
> # ID number
> id smallint unsigned not null default 0 auto_increment primary key ,
> title char(50) ,
> index (title) ,
> words text (4095) ,
> fulltext index (words(4095))
> ) ;
David, "words
Hi,
There are several ways to solve the problem -
1. Check if you really need an unsigned column - if not just alter the
column to signed
2. A simple workaround for substracting unsigned values is to add a floating
point number to the operation - then all values will be converted to float
and the
Hi,
Please read
http://www.mysql.com/doc/en/Problems_with_float.html
It is a common problem when working with floating point numbers
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, January
I'm developing an application and trying to figure out a good
way to restrict a user's access to data based on the content
of particular fields. I'm sure there must be a standard way of
doing this, but I don't know what it is.
An example might be, in the canonical CD database, having
a user who c
On Mon, 20 Jan 2003, David T-G wrote:
> OK; here's some code (I didn't want to waste time posting junk, but
> perhaps it's applicable here after all. Thanks for the couple of
> responses so far!
>
> # a particular piece
> create table pieces
> (
> # ID number
> id smallint unsigned
On 1/20/03 6:18 AM, "Ram Kumar" <[EMAIL PROTECTED]> wrote:
> greetings
>
> can anyone help to get mySQL on Mac OS X (entropy pkg), work on TCP/IP
> rather than unix socket, please ?
>
> Is Marc Liyanage on this list ?
>
> regards, ram
I don't know if Mark is on the list, but I might have some
On Mon, Jan 20, 2003 at 03:49:00PM +0200, Egor Egorov wrote:
> On Monday 20 January 2003 06:36, MySQL wrote:
>
> > I'm woundering if Mysql can use Database link, like Oracle can???
> >
> > Eg. If i have some tables at my labtop, and want to make the same table(s)
> > at my server with this command
But I don't want to perform a 15 - id, meaning 15 - 10.
I want to calculate 5 - id, meaning 5 - 10.
It should give me -5 or 5 but not | 18446744073709551611 |
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "Stefan Hinz, iConnect (Berlin)"
Hi all,
I've tried the following SQL queries:
mysql> create table test(id float);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values(1.123), (3.1495);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from test where id=1.123;
Empty set
Jon,
> Where can I look to see the Warnings?
MySQL 4.1 will come with an enhanced error/warnings reporting system
where you can use SHOW ERRORS and SHOW WARNINGS (see
http://www.mysql.com/doc/en/SHOW_WARNINGS.html for details).
If you don't have 4.1 (as most of us) you can tell the server to log
1) I have administrator rights on the G3 PowerBook on which I'm doing
this learning. But that's not the same as MySQL recognizing me with
administrator acces, is it? How can I make MySQL give me administrator
access, so I can have permission to issue CREATE [and ALL other]
commands. As it is
I'm brand-new to MySQL/PHP and to this list, spending an interesting
holiday weekend devoted to trying to start learning the
MySQL/PHP/Apached axis.
There're three things that had me thinking of just giving it all up. But
after a night's sleep I can't deny still wanting to learn how to design
On Sun, 19 Jan 2003, M A wrote:
>
>
> HI
>
> i am new to mysql.. i have just installed the source code under
> /user/local/mysql
> but the commnads don't work unless i have "./" infront of the command
> for example: mysqladmin won't work unless its written "./mysqladmin".
>
> please let me know i
greetings
can anyone help to get mySQL on Mac OS X (entropy pkg), work on TCP/IP
rather than unix socket, please ?
Is Marc Liyanage on this list ?
regards, ram
--
+--+
Mac Solutions
http://www.macsolutionsindia.com
On Monday 20 January 2003 15:20, Jeffrey Powell wrote:
> I upgraded MySQL as a part of the latest RedHat up2date and now I get an
> error when I try to connect to the database.
>
> Any help appreciated.
>
> [root@jeff root]# mysqlshow
> mysqlshow: Can't connect to local MySQL server through socket
Hello,
When I reload mysql server settings with
'mysql -hlocalhost -p reload --port 3306'
'Enter password: *'
or
'mysql -hlocalhost -p reload'
'Enter password: *'
I get error: 'ERROR 2003: Can't connect to MySQL server on 'localhost' (111)'
I tried with new, old and no password!
So?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I upgraded MySQL as a part of the latest RedHat up2date and now I get an error
when I try to connect to the database.
Any help appreciated.
[root@jeff root]# mysqlshow
mysqlshow: Can't connect to local MySQL server through socket
'/var/lib/my
Hi Jon,
you can :
DELETE FROM db_test.tbl_dbaddr;
This would delete all data in db_test.tbl_dbaddr by first dropping the
whole table and then rebuild it again.
You can of curse add a 'WHERE CLAUSE' to determin which rows shall be
deleted.
This is from the HTML-manual:
Duplicates indicates the
Yup, I got exactly the same error.
Cheers.
-Dana
-Original Message-
From: Rafal Jank [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 6:15 AM
To: [EMAIL PROTECTED]
Subject: building 4.1 from source
Hi,
I've just downloaded version 4.1 from bk and have problem with building it
Using mysql 3.23.51
I have a mysql table that holds records for telephone traffic.
The table fields are as follows:
idstartstop
clidditot_dur
day_dureve_durwkd_dur
1 08/12/
Shalom, Lisi,
(Sure would have been nice if you had indented and simplified your
SQL statements so they could be read by a mere human instead of
just by a computer ;-})
You have
SELECT ...
FROM display
LEFT JOIN click
ON display.name=click.name
AND ...
AND DAYOFMONTH(dis
> -Original Message-
> From: Jon Miller [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 20, 2003 1:49 PM
> To: [EMAIL PROTECTED]
> Subject: query problem
>
>
> I ran a query as follows:
> Insert Into db_test.tbl_dbaddr (Client, Contact, Addr,
> OfcPhone) SELECT Client AS Client, Bus
My geuss would be to write a sql script
and run it from cron
mysql < script.sql
> -Original Message-
> From: Akash [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 20, 2003 1:52 PM
> To: [EMAIL PROTECTED]
> Subject: how to write a scheduled job for MySQL
>
>
> Hi,
> I want to per
Hi,
I've just downloaded version 4.1 from bk and have problem with building it.
What version of automake is needed? Because after
> aclocal
I get:
aclocal: configure.in: 459: macro `AM_PROG_AS' not found in library
P.S. MySQL, query,database
--
_/_/ _/_/_/ - Rafał Jank [EMAIL
Hi Akash
If using *nix investigate using the cron scheduler via crontab/at to execute
your SQL script at regular intervals. If you are running on NT/Win2K then
investigate using the task scheduler instead.
HTH
Rich
-Original Message-
From: Akash [mailto:[EMAIL PROTECTED]]
Sent: 20 January
On Mon, 20 Jan 2003 17:21:59 +0530
Akash <[EMAIL PROTECTED]> wrote:
> Hi,
> I want to periodically delete some records from a table. Is there any
> mechanism by which I can schedule a job, which will execute a particular
> query at periodic intervals ?
> MySQL currently doesn't support sto
> From: Akash [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2003 11:52
> To: [EMAIL PROTECTED]
> Subject: how to write a scheduled job for MySQL
>
>
> Hi,
> I want to periodically delete some records from a table.
> Is there any
> mechanism by which I can schedule a job, which will execute a
Hi,
I want to periodically delete some records from a table. Is there any
mechanism by which I can schedule a job, which will execute a particular
query at periodic intervals ?
MySQL currently doesn't support stored procedures and triggers... but I
guess, there must be some way around. If a
I ran a query as follows:
Insert Into db_test.tbl_dbaddr (Client, Contact, Addr, OfcPhone) SELECT Client AS
Client, Business AS Contact, Addr AS Addr, OfcPhone AS OfcPhone >From
AddressBook.tbl_addr;
I got the following Records: 8989 Duplicates: 16 Warnings:394
Where can I look to see the Warni
At 6:12 PM +0800 1/20/03, Jon Miller wrote:
I'm new to MySQL and loving it. So pardon my lack of the simple
things. I need to index a table where the field is indexed, so when
I look at the in the PHP script it is in order.
Use 'order by' in your select statement:
http://www.mysql.com/doc/e
hi,
i have this problem that mysql doesn't want to start.
I am using:
Mandrake Linux 9.0
MySQL 3.23.52
when i start mysql with
[adriaan@megatron adriaan]# service mysql start
then mysqld dies and give me this error log:
--- start of megatron.darkrealm.net.err ---
We will try our best to scrap
You asked:
I'm new to MySQL and loving it. So pardon my lack of the simple things. I
need to index a table where the field is indexed, so when I look at the in
the PHP script it is in order.
Also when I run a query how can I save the results as a new table?
I reply.
1. You need an ORDER BY cla
Hi,
Instead of using separate "CREATE INDEX" statements, you can build all
your index at once with "ALTER TABLE":
ALTER TABLE my_table
ADD INDEX ...,
ADD INDEX ... ,
ADD INDEX ... ;
Hope this helps,
--
Joseph Bueno
Salvesen, Jens-Petter wrote:
> Hello, everyone
>
> I have the following
Shutdown you mysqld sever and restart it with
> mysqld -u root -Sg &
then grant all privileges to root, make sure that your root password is okay. Make
sure that there is an entry in mysql.user table for root@localhost. Then, restart
your server and see how it goes...
Nasser.
-- [EMA
Hi,
It looks you haven't updated the mysql client configuration. Adding this
lines to your my.cnf file should solve the problem.
[client]
port=3306
socket=/raidarrary2/data/mysql/mysql.sock
HTH
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: "Michael Pelley" <[EMAIL PROTECT
I'm new to MySQL and loving it. So pardon my lack of the simple things. I need to
index a table where the field is indexed, so when I look at the in the PHP script it
is in order.
Also when I run a query how can I save the results as a new table?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Sys
Robyn,
> Could anyone please tell me how I write an SQL statement to seperate
> text from one field into multiple fields based on a aprticular
character
> (i.e. tab/comma/space). For example, I have a text field containing:
> Text=Robyn Bailey Brisbane
I understand you have all of this in just ON
This page (Section 5.2.9: Speed of INSERT Queries) might be of interest:
http://www.mysql.com/doc/en/Insert_speed.html
You might also want to investigate the INSERT IGNORE command (IGNORE
means ignore all inserts with duplicate unique keys), for example:
INSERT IGNORE
INTO your_table
(col1,
I use MYSQL TO_DAYS function to grab some statistics from database and I use
next
statement:
SELECT ID FROM database
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) >=7
ORDER BY ID DESC
I have IIS server and I use Dreamweaver MX to build the statistics page,
where we use ASP. Problem is, that I get row
Daevid Vincent wrote:
This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html
replace works very nicley and is IMO a good extension to standard SQL
another way that may be suitable is to delete first and then insert
(this may erase data if you are not inserting all columns)
---
greetings nug
we ar estuck in a project to connect to mySQL running on Mac OS X, through
TCP/IP, please suggest
regards, ram
--
+--+
Mac Solutions
http://www.macsolutionsindia.com +91 98102 70848
When I type "bin/mysqladmin -u root password mypass" (or without password,
because I didn't set it) then I get "Access denied for user: 'root@localhost'
(Using password: NO)" I need help ??
Thank you.
---
http://www.email.si
Would it (the replace command) save me performance time instead of just
using insert and ignoring the mysql error ?
It looks like that insertion flow using the replace command would cost
more..
Using insert --> insert , check for key existence & output an error
Using replace --> insert ,check for k
Hi,
you might want to ask the sales people some of these questions, this
is a users mailing list ...
Question 4: What are the appropriate fees associated with purchasing mySQL as a programming
company who would use mySQL as its database in its applications.
Mysql is available under two li
Hello, everyone
I have the following situation:
After "enjoying" problems related to deleting a large portion of a table,
subsequent slow selects and such, I decided to do an alternate route when
removing data from a table:
The table had transactions for one year, and the table really only needs
Hi,
I have the same problem the last week - I checked the manual and it seems
this is from the new way the unsigned columns are treated in MySQL 4.
Here is a quote from http://www.mysql.com/doc/en/Column_types.html
"Warning: you should be aware that when you use subtraction between integer
values
This may be very simple, but the solution eludes me..
I have two tables Products and NewProducts, The Products table contains a
list of all the current product line and prices Products.ProdCode,
Products.Price (amongst other details not relevent here). NewProducts
contains a list of changes to
On Mon, 2003-01-20 at 09:15, Zysman, Roiy wrote:
> Hi All,
> I'm trying to insert multiple lines to a table with 3 col. All 3 of them
> are a part of the primary key.
> But while inserting the data , sometime occurs the situation where I
> want to insert an already exist entry with the same keys. A
88 matches
Mail list logo
