Well, if you are combining the 2 tables like that into 1, then there is an
easier way without the need for an array.
Make sure you have a unique index on email for tableA and then
INSERT INTO tableA(email) SELECT email FROM tableB
The unique index will stop the duplication while adding values
I've expirienced the same problem
And it's not a PHP bug no doubt...
here the code
$sql=insert into
login_signup(createdate,logindate,uid,user)values(0,now(),$uid,'$user');;
$res=mysql_query($sql);
if (!file_exists(r1.txt)){
$f=fopen(r1.txt,w);
fwrite($f,1,1);
You are the man...thanks a bunch! that's what I needed.
=
r a n d y / sesser at mac.com
From: Rolf Hopkins [EMAIL PROTECTED]
Date: Fri, 6 Jul 2001 14:39:59 +0800
To: { randy } [EMAIL PROTECTED], MySQL [EMAIL PROTECTED]
Subject: Re: Syntax question for a
Hi everybody
I am able to connect to my remote mysql server
but fail to create, user any database ...
I let you know step by step.. what I have done
1. First I have connected to my remote server through
Telnet.
After becoming root...
I had supplied following command...
2. mysql -h
can i create a new user and 'grant all' to that user on all dbs and
THEN add/import new databases and that user will still have all
permissions on those as well?
-
Before posting, please check:
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hi, have you created the directory. InnoDB can't create directories.
Regards Gerlinde
At 16:56 05.07.01 -0400, Brandon Berry wrote:
These are the options I used.
[mysqld]
innodb_data_file_path = ibdata;
innodb_data_home_dir = /usr/local/mysql/data
set-variable = innodb_mirrored_log_groups=1
Hello
which hardware will be more fast and heavy duty for mysql to run?
PC 2x866 2G RAM RAID
Sun enterprice with dual sparc-III 750 with solaris and some ram
--
Kissandrakis S. George [[EMAIL PROTECTED]]
Network and System Administrator [http://www.phaistosnetworks.gr/]
I'd go with the SUN...can't tell you why or back up my answer, but I'd just
go with the SUN
=
r a n d y / sesser at mac.com
From: Kissandrakis S. George [EMAIL PROTECTED]
Date: Fri, 06 Jul 2001 10:41:50 +0300
To: [EMAIL PROTECTED]
Subject: Looking for best
this page is helping me A LOT!
thank you.
At 3:46 PM +0300 7/5/01, Ilan Fait wrote:
Hi,
Check out this URL it is very good to start with.
URL: http://home.ubalt.edu/abento/797/mysql/
I hope that it will help
Best Regards,
Ilan
Hi,Sir
I encounter a problem while using mysql. My Mysql version is Mysql 3.23.38!
I'm in WindowsMe system. I encouter a problem in Replication. I set master/slave
replication according to the manual in your website(chapter 11).It works, but I
have trouble to stop the slave thread. I set
Hi,
Is there any mean to not log the Aborting Connection line in the .err file ?
Thank you
Jocelyn Fournier
Presence-PC
www.presence-pc.com
Hi!
There are two tables:
create table a(
id int primary key,
name char(10),
unique anamei (name)
);
create table b(
id int primary key,
name char(10),
unique bnamei (name)
);
TASK:
select all ids for names which are unique among both tables:
example:
A:
1 a
2 b
3 c
4 d
Hi,
as I am using PERL to operate my MySQL-Database, I need the following
statement to carry out the new entries:
(Id is an auto-incrementing column)
$sth2 = $dbh2-prepare(SELECT * FROM mywartungstermine WHERE (Id (Id
- $id_max)));
Refering to the manuals, it is allowed to use subtraction
On 5/7/01 4:40 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi --
Has anyone installed MySQL on MacOS X Server and has safe_mysqld start
automatically at boot?
On my LinuxPPC box, I add the provided startup script to the /etc/rc.d dir
structure.
In MacOS X, there is no such
At 16:11 06/07/2001 +0800, rqhuang wrote:
Hi,
I would like to ask you a favour for to make a test when you not
are able to stop the slave. There is a tool called NETWATCH.EXE
from Microsoft to be used on Win9x machines, this tools it isn't
installed by the default and you can find instructions
i'm in the dbs and the book i wanted to be in!!!
it was
http://home.ubalt.edu/abento/797/mysql/
that helped so much.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
Current mysql version:
mysql Ver 10.11 Distrib 3.23.24-beta, for pc-linux-gnu (i686)
I realize it's old, but got length mismatch on t/merge for 3.23.39 --
still checking on it.
I used the fulltext example from the manual: manual_Fulltext_Search.html
Then I tried something like this:
Sorry,
I failed the obligitory full-read of the mysql manual page ..
One question answered:
Default sort order is descending score .. my bad.
-Jay J
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Jeremy Zawodny writes:
On Thu, Jul 05, 2001 at 09:52:43AM +0200, Matthias Urlichs wrote:
Hi,
did anybody ever try to run the standard test suite with another
table handler?
I thought the MySQL team did that...
You will find some on InnoDB site.
We think about switching to
chris writes:
Are there any know issues or bugs with MySQLGUI running on Solaris 8
thanks
No, if properly built.
Use g++ 2.95.2 and it's STL lib, plus follow instructions closely.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL
Fernando Ibaven M. writes:
I cant download in this link:
Win32 static binary of MySQLGUI 1.7.5-1
The client software.
Thanks
I just tried and had no problems what so ever.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
On Thu, 5 Jul 2001 [EMAIL PROTECTED] wrote:
[MySQL]
what does this mean and how can i fix it?
Access denied for user: 'niban@localhost' to database 'tracking'Could
not drop database tracking
thanks.
It means what it says :) The user niban, coming from the local loopback
interface (the
On Thu, 5 Jul 2001, alexus wrote:
hi again
another security related question...
is it possible to do so user won't be able to access anyone else's database
but his or her own?
Read the fine manual, especially the part about granting privileges.
Grant each user the privileges to their db
On 6 Jul 2001, Anoop K Gupta wrote:
it prompts for password : it is blank so I just pressed enter. and Mysql prompt
appeared..
mysql
Well, do you have a password for the root user? If so, type it in!
Note, root in mysql is NOT the root login for the server, so the
passwords are probably
Volker Paepcke writes:
Hi!
One year ago Michael Widenius posted this:
We have on the other hand played with the idea to at some point
implement SQL commands of type:
ISAM INSERT table_name (...)
ISAM UPDATE table_name SET ... WHERE
Hi all!
Sorry for the dumb question, but am I right in the following suggestion:
I have the following table:
create table tab_1 (
field_1 integer not null,
field_2 integer not null,
primary key (field_1, field_2));
Does it mean that this key requires unique
üÄÕÁÒÄ óÕÒÏ× wrote:
Hi all!
Hi,
Sorry for the dumb question, but am I right in the following suggestion:
I have the following table:
create table tab_1 (
field_1 integer not null,
field_2 integer not null,
primary key (field_1, field_2));
Does it mean
Platform: W2k/Advanced Server
DB: mySQL 3.23.33
Language: ASP/VBScript
Issue: I'm creating a backend administration program that will allow
updates, deletes, additions, etc. All is well expect for in one table in
particular when I choose to delete a record it gives me a type mismatch
Error. I've
the combination is unique so
iyou dont get an error
On Fri 6. July 2001 14:04, you wrote:
Hi all!
Sorry for the dumb question, but am I right in the following suggestion:
I have the following table:
create table tab_1 (
field_1 integer not null,
field_2 integer not null,
why do you use Replace if deleteheadline is an integer?
On Fri 6. July 2001 14:26, you wrote:
Platform: W2k/Advanced Server
DB: mySQL 3.23.33
Language: ASP/VBScript
Issue: I'm creating a backend administration program that will allow
updates, deletes, additions, etc. All is well expect
Hi,
the following query yields:
mysql SELECT DISTINCT (@c:=@c+1), p.*,
count(k.keywords) AS found FROM keywords k, poll_keywords pk, poll p ,
section_poll sp WHERE 1 AND k.keywords IN ('quarto') AND
k.id_keyword=pk.id_keyword AND pk.id_poll=p.id_poll AND sp.id_section IN
(29, 0, 1, 2, 3, 4,
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 1 42 77 21 02
We would be peased to be subscribed to My SQL mailing list.
Regards,
Dominique Vellin
Business developement
Azentis Technology
Your Outsourcing Provider
Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90
E-mail : [EMAIL PROTECTED]
On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote:
Volker Paepcke writes:
Hi!
One year ago Michael Widenius posted this:
We have on the other hand played with the idea to at some point
implement SQL commands of type:
ISAM INSERT
Hi, this is a follow-up to the previous message.
As far as I've understood when Innodb parses a Having clause it creates a
temporary table where it stores the results of the query satisfying all
the conditions except the HAVING clause, then it makes a
SELECT * from temp_innodb_table ... WHERE
Hello All,
Our company is going to be setting up on a dedicated server, so I am in the
process of doing some crash course learning as a system admin. We are looking
at a server with RedHat Linux 6.2 O/S and we want to install MySQL laster stable
version w/InnoDB enabled. Now from the docs, it
Hi
I use Delphi 5 and MyODBC to access a MySQL database.
In my program, I've sometimes a tables locked and I don't understand why ! I am the
only user on this database and I change records correctly (as I do it for other
programs on other databases).
Does somebody have this problem ?
Can you
Tim Bunce writes:
On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote:
It may have been implemented 2 months ago (for v4.0), but it doesn't
seem to be documented.
Will is be documented soon?
Tim.
It is in the manual under this heading :
`HANDLER' Syntax
Tim Bunce writes:
It may have been implemented 2 months ago (for v4.0), but it doesn't
seem to be documented.
Will is be documented soon?
Tim.
Forgot to mention that it is implemented on MyISAM, not ISAM tables.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
Thanks. Which files would I need to download then?? Just the RPM's or RPM's and
the tarball binary?
On Fri, 6 Jul 2001 16:41:05 +0300, Sinisa Milivojevic [EMAIL PROTECTED] wrote:
Use our MySQL-Max binary as it contains InnoDB. Our binaries are built
in the most optimial manner, and LInux
MikemickaloBlezien [EMAIL PROTECTED] writes:
Thanks. Which files would I need to download then?? Just the RPM's or RPM's and
the tarball binary?
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
I assume this is the correct one to download then:
mysql-3.23.39-pc-linux-gnu-i686.tar.gz
MikemickaloBlezien [EMAIL PROTECTED] writes:
Thanks. Which files would I need to download then?? Just the RPM's or RPM's and
the tarball binary?
On Fri, 6 Jul 2001 16:54:12 +0300, Sinisa Milivojevic
I am getting an error when I try to use mysqldump on a database.
/usr/local/mysql/bin/mysqldump: Can't get keys for table agora (Lost
connection to MySQL server during query)
When this happens, I get a message in the mysql error log saying the
database has been restarted.
mysqld restarted on
Hi!
The first thing that catches my eye is that you have not specified the
data file ibdata size. Also there is an extraneous ; there. Look at
the manual at www.innodb.com for an example how to specify
startup options.
Regards,
Heikki
Copied message:
..
These are
Hello all
I need some help. My OS is Windows 98. Here the problem I go though the install
for MySQL everything seem to work. But MySQL will never start up. What am I doing
wrong?
Paul Castiglione
[EMAIL PROTECTED]
Has anyone seen any documentation for using mysqld as a library.
I am building an embedded device on a machZ chipset, and I would really
like to be able to use mysql for some internal querying of our data
collection.
I can get it to run (barely) as is, but need more room and memory for other
I have a database of 5.6 million records and I need to choose 5000 random
records. What would that query look like?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On 06-Jul-01 Artem Koutchine wrote:
Hi!
There are two tables:
random snipage
TASK:
select all ids for names which are unique among both tables:
snip
RETURNS: 3,4,5,6
The trick is to do it in ONE SQL statement.
Why one ? is this a test ?
mysql create table t (id int not null, name
I am looking for a Win32 front end/client for mysql. I want to be able to
run it on my local machine, but modify a remote mysql db. I would like it
to be as user friendly as possible, with the user having to know as little
sql as possible. Any suggestions?
Or maybe a web client that I can run
I am working on a website which will make use of a MySQL database. I know
little if anything about the best way to design my db for efficiency, or
anything else for that matter. The information which I need to put in the
database will be contact/profile information on various people: Name,
I have a database of 5.6 million records and I need to choose 5000 random
records. What would that query look like?
select * from records order by rand() limit 5000;
destiney - (des-ti-ny) - n. 1. deity of all things
Hello All
What is the best way to create table in a database under Win9X
Paul
[EMAIL PROTECTED]
On 06-Jul-01 Roger Ramirez wrote:
I have a database of 5.6 million records and I need to choose 5000 random
records. What would that query look like?
SELECT foo from bar ORDER BY RAND() LIMIT 5000
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's
Hello
I´m trying to install MySQL binary in a FreeBSD 3-4. I´ve gone thru all the
installation steps but I still get the following message: floating point exception
--core dumped whenever I start mysql daemon.
I just don´t have a clue of what this might be...
If anynone has a documentation on
Patrick Prémartin wrote:
I use Delphi 5 and MyODBC to access a MySQL database.
In my program, I've sometimes a tables locked and I don't understand why ! I am the
only user on this database and I change records correctly (as I do it for other
programs on other databases).
Does somebody
- Original Message -
From: Gustavo Santos
To: [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 12:43 PM
Subject: Installing on FreeBSD 3-4
Hello
I´m trying to install MySQL binary in a FreeBSD 3-4. I´ve gone thru all the
installation steps but I still get the following message:
Matthieu Neukirch wrote:
We would be peased to be subscribed to My SQL mailing list.
Regards,
Dominique Vellin
Business developement
Please use the http://www.mysql.com always before posting any questions
or enquiries into list! There is a simple technical procedures you should
You might want to have a look at urSQL
(http://www.urbanresearch.com/ursql).
There are several options for editing and viewing data.
On Fri, 6 Jul 2001, Ed Peddycoart wrote:
I am looking for a Win32 front end/client for mysql. I want to be able to
run it on my local machine, but modify a
On Fri, 6 Jul 2001, Ed Peddycoart wrote:
I am looking for a Win32 front end/client for mysql. I want to be able to
run it on my local machine, but modify a remote mysql db. I would like it
to be as user friendly as possible, with the user having to know as little
sql as possible. Any
alexus wrote:
hi
is it possible to make mysql db inaccessable from other users but root?
This is the default behaviour of MySQL server. You should just have password on root
user of MySQL.
Tõnu
-
Before posting,
not true.. one of the user was able to give himself all the rights inside of
mysql db in user table
- Original Message -
From: Tonu Samuel [EMAIL PROTECTED]
To: alexus [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 12:03 PM
Subject: Re: inaccesable mysql db from
James Gosnell wrote:
If I connect to mysql:
mysql -u username -p wherever.net
is that encrypted at all?
No and never will be default behaviour to encrypt communication as this reduces
performance.
and if I make a network program via the C API, would that be encrypted
too? Thanks
i have designed a system that works on MSSQL but i have decided to port it over to
mysql. One of the problems i have come across is i need to figure out how to get the
autoid back. so just say i insert a record, and MYSQL gives it the auto id of 6, how
do i know that from my VB program?
Hi!
You can download new InnoDB-3.23.39b source from
http://www.innodb.com
You should first download the MySQL/InnoDB-3.23.39 source
from the MySQL website www.mysql.com and extract it
to form a source tree.
Then extract the files in innodb-3.23.39b.tar.gz into the
/mysql/innobase subtree in
I have it running on FreeBSD 4.3-RELEASE. I just installed it form the ports
collection: /usr/local/ports/database/mysql323-client mysql323-server
Everything seems to work well.
=
r a n d y / sesser at mac.com
From: Gustavo Santos [EMAIL PROTECTED]
Date: Fri, 6
Thanks to all those who offered suggestions...However, I just found out that
my webhost does not remote connections to the mysql server. It was
suggested that I use a Perl program to modify my database. Any suggestions
on something I can load on my website to modify the db?
Ed
-Original
Hi!
I will send you a special version of row0sel.c
with which you can print a lot of trace info on
SELECT execution. Those traces may reveal what is wrong.
Regards,
Heikki
Hi, this is a follow-up to the previous message.
As far as I've understood when Innodb parses a Having clause it creates
Hi,
We are looking for MySQL expert that can convert a
MySQL database tables to another.
We are using a CFBoard forum (programmed by Cold
Fusion and using MySQL database).
We are moving to vBulletin Forum (programmed by PHP
and using MySQL database).
We need an expert to export our database
Thought I might ask before I dig into a new project. I am looking for a race program
built on MySQL and PHP. By race I mean running, biking, swimming not carsg
Anyone seen anything like this laying around somewhereg It's for a non-profit group
that I do some work for..
Cheers
M;-)
Hi
I want to make query like this
Selectp.name
fromtab_person p, tab_list l
wherel.id_tab_list = 18
if (l.id_person != 0){
AND l.id_person = p.id_person
}
table person
id_person,name,tel
table list
id_list,id_person,title
how can i do?
Fournier Jocelyn [Presence-PC] wrote:
Hi,
Is there any mean to not log the Aborting Connection line in the
.err file ?
Nothing except programming application to close unused MySQL
connections. This
is the common cause of this error message.
Tõnu
Selectp.name
fromtab_person p, tab_list l
wherel.id_tab_list = 18
and ((l.id_person != 0 AND l.id_person = p.id_person)
or l.id_person = 0)
}
-Original Message-
From: franky [mailto:[EMAIL PROTECTED]]
Sent: 06 July 2001 19:35
To: LIste de Mysql
Subject: conditional AND
Hi
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: Tonu Samuel [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 6:16 PM
Subject: Re: Annoying Aborting Connection in .err file
In fact pconnect aren't close at the end of the PHP Script. The MySQL
process stay
may need to double quote the % sign.
trav
On Thu, 5 Jul 2001, Chris M wrote:
I've got a question.
In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
about how you can do this:
GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY dirt;
So I tried something
I have a dealer database with 3000+ records and I'm building a manager to
sift through the items.
Currently I ORDER and LIMIT by name so I can come up with names that begin
with A and LIMIT the returns to 25, and then click to see the next 25
names beginning with A etc.
Now here's where I'm
Hi,
I have a perl script that loops through and executes 2 queries 50
times. I need to make sure that I have done all I can to make these
queries and the indexing on the table as efficient as possible.
Would someone do me the gargantuan favor of taking a peek at the info
below and offer any
Actually neater code would be
Select p.name
Fromtab_person p, tab_list l
Where l.id_tab_list = 18 And
l.id_person = 0 Or
l.id_person = p.id_person
If its important, you might want to add
And p.id_person 0
-Original Message-
From:
OK, I thought that might be the case, I wasnt thinking too clearly, but its
because there is no JOIN with the second table.
MS SQL is my area of expertise, Im just learning MYSQL, let me have a look
through my books, Im not sure what JOIN syntax is supported by MYSQL.
Give me a little while, if
I write this:
Select p.name
From tab_person p, tab_list l
Where l.id_tab_list = 18 And
l.id_person = 0 Or
l.id_person = p.id_person
i will receve all name in person table!
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
François Boucher
[EMAIL PROTECTED]
___
_ (
OK, Im going to have to look more carefully at MYSQL, I think that when
there is no JOIN between the two tables l.id_person is evaluating to 0,
when I expected it to evaluate to NULL.
Let me do some more research!
Jason
-Original Message-
From: franky [mailto:[EMAIL PROTECTED]]
Sent:
Hi there,
I am trying to install mySQL mysql-3.23.39-sun-solaris2.7-sparc on my
solaris(sparc)2.6 box. After I ran the mysql_install_db I got the message
below can anyone of you pleas help me?
ORCSUN01 scripts/mysql_install_db
ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open
On Fri, Jul 06, 2001 at 04:36:08PM +0300, Sinisa Milivojevic wrote:
Tim Bunce writes:
On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote:
It may have been implemented 2 months ago (for v4.0), but it doesn't
seem to be documented.
Will is be documented soon?
Hi all
Can anyone tell me how to properly get a conditional in my select
statement? This is being used for an authorization scheme using a Radius
authentication server. What I'm trying to do in psuedo mysql is the
following with english where I'm stuck:
select password, ip_address, num_ips,
Hi,
being new to mysql on nt4, how do those of you running Mysql on NT4
server, backup and restore you databases.
I understand that transactions are not supported on nt, if so, is a tape
backup all that I have to fall back on in the event of a crash?
What about all the records that will be lost
On Fri, Jul 06, 2001 at 04:36:08PM +0300, Sinisa Milivojevic wrote:
Tim Bunce writes:
On Fri, Jul 06, 2001 at 02:51:34PM +0300, Sinisa Milivojevic wrote:
It may have been implemented 2 months ago (for v4.0), but it doesn't
seem to be documented.
Will is be documented soon?
On Fri, Jul 06, 2001 at 08:31:56PM +0100, Tim Bunce wrote:
It is in the manual under this heading :
`HANDLER' Syntax
Perhaps, but it's not listed here:
http://www.mysql.com/doc/manual.php?search_query=handlerdepth=0
I *think* that only searches the 3.23.xx
Hi,
Try to keep the simple attributes in one table and the repetitions in
separated tables
For example:
A person has only one gender, one name, one marital stauts , etc
however a person can have none,one or more than one kid. Create another
table and create a relationship between both.
sorry I typed my website wrong. The right url is:
www.geocities.com/hisiomara
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: db design questions
Date: Fri, 06 Jul 2001 18:07:36 -0300
Hi,
Try to keep the simple attributes in one table and the
WS Oh, I see, you would like to connect this information with the
WS pid, right? I wouldn't know how to do that. How do you get a pid?
WS Is this something MySQL could provide?
No, not with the pid.
With the number of places from where sql queries are executed and
the number on
Hi All
to many hours anyway I am struggling with what seems to be an easy task but I am stuck.
I am trying to total the fields with numbers (run + swim + bike) from a racer
name=joe
and insert the ammount into a field called totals in a table called runner.
UPDATE runner SET totals=SUM(run +
Do you know - would that be of any help?
23.2 The Query Log
If you want to know what happens within mysqld, you should start
it with --log[=file]. This will log all connections and queries
to the log file (by default named `'hostname'.log'). This log can
be very useful when you suspect an error
Pete:
I think I would go for replication
(http://www.mysql.com/doc/R/e/Replication_Implementation.html)
If replication isn't in the cards, then look at using CD-RW ... tape is too
slow.
Gerald Jensen
- Original Message -
From: Pete Kuczynski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Thanks but I got it working
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Fri 7/6/01 15:49
SUBJECT: Adding fields
Hi All
to many hours anyway I am struggling with what seems to be an easy task but I am stuck.
I am trying to total the fields with numbers (run
At 12:14 AM +0200 7/7/01, Fournier Jocelyn [Presence-PC] wrote:
Hi,
Is there any structural difference between a PRIMARY KEY and a UNIQUE key ?
Thanks ;)
Jocelyn Fournier
Presence-PC
www.presence-pc.com
They're mostly the same, with these differences:
There can only be one PRIMARY KEY per
Description:
After installation of using the RPM on Linux-pc-intel-i686 version,
the script gave the message to set the password using /usr/bin/mysqladmin.
But the mysqladmin program was not found.
How-To-Repeat:
Install the rpm on a Linux-pc-intel-i686.
Fix:
Don't know
Hi.
On Fri, Jul 06, 2001 at 03:45:48PM -0600, [EMAIL PROTECTED] wrote:
to many hours anyway I am struggling with what seems to be an easy task but I am
stuck.
I am trying to total the fields with numbers (run + swim + bike) from a racer
name=joe
and insert the ammount into a field called
I am running MySQL on a LINUX System. I am having trouble starting the
server as a non root user. I set up a non user account and changed the
permissions on the necessary files but I still can't start the server unless
I do it as root. It just hangs there until I abort it. If I installed
Thanks for the great tutorialg I added it to my MySQL notes database. I
like the way you explained it start to finish..
TIA
M;-)
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 6:13 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
UPDATE runner SET totals = (run + swim + bike)/60 WHERE name='jim'
I had to use the /60 to divide the minutes by 60 to get the hours
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 6:13 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
1 - 100 of 111 matches
Mail list logo