Dear All,
I have 2 tables Table1 and Table2. In Table1 rowid is primary key and in
Table2 rowid is primary key as well as foreign key (referring to rowid in
Table1).
There are several other columns in Table1, but Table2 has only one col -
rowid.
I want to insert rowid into Table2
Hi all,
I am trying to install mysql-standard-5.0.24. My OS is Sun Solaris 9. I down
loaded the binary package mysql-standard-5.0.24-solaris9-sparc.pkg.gz from
your web site.
I can unzip the file with no problem using gunzip. The file is at
/var/spool/pkg. While in this directory I am typing the
Hi Dan,
Dan Buettner [EMAIL PROTECTED] writes:
The answer is - it depends.
Thanks for your suggestions.
A multi-column index can be helpful for performance over single-column
- or it can do you no good at all, depending on how you build it and
how you use it.
MySQL currently uses (at
Not sure iam right . Try without gunzip 'ing the pkg .
zehra cagnan wrote:
Hi all,
I am trying to install mysql-standard-5.0.24. My OS is Sun Solaris 9.
I down
loaded the binary package mysql-standard-5.0.24-solaris9-sparc.pkg.gz
from
your web site.
I can unzip the file with no problem
Hi Mike,
yes it works:
mysql CREATE TABLE tablea (a_id int unsigned);
Query OK, 0 rows affected (0.09 sec)
mysql CREATE TABLE tableb (b_id int unsigned, a_id int unsigned, flag
char(1));
Query OK, 0 rows affected (0.08 sec)
mysql INSERT INTO tablea values (1),(2),(3);
Query OK, 3 rows
Dear all,
our DB server crashed and when I try to start Mysql
/etc/init.d/mysql/start
I get these lins in my error log
060921 13:00:14 mysqld started
060921 13:00:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the
Hi,
Your query was understood as - you want to retrieve the current value of
the autoincrement column, where mysql_insert_id also reveals the same.
Try either of this.
Use LIMIT:
select ID from tablename
order by ID DESC
LIMIT 1.
or
Use MAX()
select MAX(ID) from tablename
I'm trying to create stored procedure, but after reading mysql's online
document, I was not able to comprehend its usage. Here is what I do, put in
target zip code and miles range, then find a list of zipcode, city, state
and miles from target zip code. How do I get around to it?
[code]
SET
hello all
i installed debian linux netinst which installed well; and proceeded to
install mysql with the command below
apt-get install mysql-server
that also went well, i proceeded to configure etc etc
when i logged in from a client i noticed that the mysql server version
is 4! is there a
Worked under version 4. Does not work under version 5.
$Qstr = select distinct replace(reftraffic.refurl,'http://',''),\
count(*)\
from reftraffic,site\
left join links\
on
Hello!
Jangita @ FSA wrote:
hello all
i installed debian linux netinst which installed well; and proceeded to
install mysql with the command below
apt-get install mysql-server
Then this must have been a deb package, AFAIK.
MySQL currently does not offer deb packages, so you must be
Ravi Kumar. wrote:
Dear All,
I have 2 tables Table1 and Table2. In Table1 rowid is primary key and in
Table2 rowid is primary key as well as foreign key (referring to rowid in
Table1).
There are several other columns in Table1, but Table2 has only one col -
rowid.
Then what is the reason
Mailing List Receiver wrote:
Worked under version 4. Does not work under version 5.
$Qstr = select distinct replace(reftraffic.refurl,'http://',''),\
count(*)\
from reftraffic,site\
left join links\
on
Mailing List Receiver wrote:
Worked under version 4. Does not work under version 5.
$Qstr = select distinct replace(reftraffic.refurl,'http://',''),\
count(*)\
from reftraffic,site\
left join links\
on
Hello,
You can get MySQL 5 either by a backport (www.backports.org) or by
changing to Etch that will be the new stable release in december. See
www.debian.org for more information.
Greetings,
Anders
Jangita @ FSA wrote:
hello all
i installed debian linux netinst which installed well; and
I don't think you can do this with mysqlimport. It wouldn't be hard to do
with Perl or PHP, though, and that could be automated any way you want with
a shell script.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX:
Thanks for the tips. So it seems that:
1) I should index the most often used ones.
I am not sure what OLTP/OLAP means?
Peter
On 9/20/06, Peter Brawley [EMAIL PROTECTED] wrote:
Peter
It doesn't seem like it would make sense to make an index for every
possible combination... but there
On 18/09/2006, Ahmad Al-Twaijiry wrote:
I want to run SQL query that will return to me the first records that
the SUM of Total field = 100
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
id INT UNSIGNED NOT NULL PRIMARY KEY, total INT NOT NULL);
INSERT INTO foo VALUES
(1, 20), (2,
What about
SELECT tablea.* FROM tablea AS a JOIN tableb AS b ON a.a_id = b.a_id
WHERE b.b_id IS NULL
OR b.flag != Y;
The WHERE clause should exclude existing records where the flag is Y,
include
existing records where the flag is not Y, and include records from tablea
that don't have matching
Dear Gerald,
Thanks for the reply.
Here is what I was looking for (Google helped me find this):
insert into Table2 (rowid) select T1.rowid from Table1 T1 left join Table2
T2 on T1.rowid = T2.rowid where T1.rowid is null and T1.somecolumn =
'somevalue'
The 'T1.rowid = null' section prevents
Hi Jerry,
I don't think that will work as I think
you'll only get hits in tablea on what exists in
tableb, i.e. you wont get 1/a as your JOIN will exclude
that as it will only join for non null existencies.
Your query will return 2/b and 3/c as they exist in tableb
and have flag != 'Y' and miss
how do you find where mysql data resides?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you nick, being beginner is a good thing and highly appreciated.
One question though; i just want to upgrade mysql and thanks for letting
me know how; but i want to upgrade to a stable released version because
i want to run a critical public application on the linux box. ive been
using
I have a query that searches on a number of criteria and would like help on
the last line
I have included my code below:
where
jobs.statusid in (6) and
ifnull(jobs.currworkerid,'') like '%' and
jobs.dictatorid like '%' and
jobs.custcode like '%' and
Hi,
what I see is that you at least will get everything
where Approveddate IS NULL. You will have to add on
parentheses around (Approveddate between '2006-09-14' and '2006-09-21'
or Approveddate Is Null) as AND has precedence over OR.
Also if your query always will be against like '%' you should
molemenacer wrote:
I have a query that searches on a number of criteria and would like help on
the last line
I have included my code below:
where
jobs.statusid in (6) and
ifnull(jobs.currworkerid,'') like '%' and
jobs.dictatorid like '%' and
jobs.custcode like '%' and
Have you tried using parentheses around your last line?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: molemenacer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006
Peter
I am not sure what OLTP/OLAP means?
T=transaction (processing is mostly inserts, updates),
A=Analysis(processing is mostly for reports), see
http://wiki/en/wikipedia.org/OLAP. You keep 2 versions of your data, one
optimised for inserts/updates, one optimised for reporting, you update
The error message says to go to
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html to learn
how to set the different recovery options for innodb.
On 9/21/06, Sayed Hadi Rastgou Haghi [EMAIL PROTECTED] wrote:
Dear all,
our DB server crashed and when I try to start Mysql
Hi.
What binary relase use for CentOS 4.4:
* Linux (x86, glibc-2.2, standard is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
In http://dev.mysql.com/doc/refman/5.0/en/binary-notes-linux.html says
I am looking for a way to write a client program that will wake up when
there is new data in the database, much like replication.
So instead of my client pulling the database on some fixed interval, I
would like the mysql daemon to push the data to my client when there is
new data. I assume this
Hi David
Sybase and MS-SQL have a built-in stored procedure called xp_cmdshell
which lets you execute shell commands from within a stored procedure
or otherwise within the database process.
MySQL doesn't (I'm fairly sure) provide anything like that (although
I think someone had written a
Hal Wigoda wrote:
how do you find where mysql data resides?
The my.cnf file contains a line like this:
datadir=/var/lib/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi.
What binary relase use for CentOS 4.4:
* Linux (x86, glibc-2.2, standard is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
In
Hello.
Add to /etc/apt/sources.list
#Debian backports
deb http://www.backports.org/debian/ sarge-backports main
or,
#DOTDEB.
deb http://packages.tribal-dolphin.be/ stable all
deb-src http://packages.tribal-dolphin.be/ stable all
Then:
apt-get update
apt-get install mysql-server-5.0
You can
Hi,
From the mysql itself try this --
mysql show variables;
This will list data_home_dir path, arch_dir path, group_home_dir path,pid_file
path, socket path etc. along with other variables.
Thanks
ViSolve DB Team.
- Original Message -
From: Hal Wigoda [EMAIL PROTECTED]
To:
Hi,
If you get
Sorry, the host '' could not be looked up error message when you run
mysql_install_db, or if you get the
getpwnam: No such file or directory error message while running mysqld
with --user option,
Then try any of these solutions:
a.. Get a MySQL source
37 matches
Mail list logo