Now I'm confused the auto-increment number reverted back to one (1)
after I truncated the tables in one of the DB's. I suppose as long as
the number is unique within the objects I'm making selections,
updates...ect in - who cares.
On Sun, 23 Jan 2005 02:18:33 -0500, leegold [EMAIL PROTECTED]
Hi,
I want to create indexes for temporary created tables in perl dbi.
The following is perl code that I tried, but perl dbi seems not allow
the syntax:
Unable to execute our query PastSales:You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
Sam,
You can use 'show tables' with a like clause if you prefix your temporary
tables with a string such as 'tmp_'. See the manual for syntax:
http://dev.mysql.com/doc/mysql/en/show-tables.html
Clint
From: sam wun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: show temporary table
Date:
Sam,
Remove the double quotes and semi-colon out of this statement:
$tmp_sql = qq{alter table tmp_pastsales add
index(salescode,basename,prodcode)};
Clint
From: sam wun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: create indexes for temporary table
Date: Sun, 23 Jan 2005 18:49:51 +0800
I have two tables:
DB 1:
Table A:
Userid:
Dept:
DB 2:
Table B:
Userid:
Dept:
Location:
How would I query from DB 1 Table A for the Dept if I want to use that value
for DB 2’s Dept?
Both DB’s and tables have the same Userid.
Does not work:
Use 2;
Select A.Dept from A where B.Userid =
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alex S Moore wrote:
| On Solaris 8, how can I force configure to not use /usr/lib/libcrypt.so
| without renaming that file? I changed config.h to undefine
| HAVE_LIBCRYPT, but configure just puts it back to defined and changes
| the Makefiles to
We are looking for buying a new server for running
MySQL database. The database is around 50-70G and
individual tables run to 5 - 15 GB. There wont be any
frequent updates instead we need maximum select
performance. There will be multiple table joins to
perform our query. I hope your experience
rmck wrote:
I have two tables:
DB 1:
Table A:
Userid:
Dept:
DB 2:
Table B:
Userid:
Dept:
Location:
How would I query from DB 1 Table A for the Dept if I want to use that value for DB 2's Dept?
Both DBs and tables have the same Userid.
Does not work:
Use 2;
Select A.Dept from A where B.Userid =
sam wun wrote:
sam wun wrote:
Hi,
Can anyone tell me how to optimize the following sql statement?
$sql_1 =
SELECT t.prodcode 'Product Code',
t.prodname 'Product Name',
ROUND(avg(t.salesvolume),2) 'PastSales Quantity',
ROUND(avg(tt.salesvolume),2) 'Sales Quantity',
You can look up error codes with perror.
: perror 28
Error code 28: No space left on device
You've run out of disk space.
Michael
sam wun wrote:
Hi,
I was trying to optimize a sql (for INNER JOIN) by spliting the sql into
2 temporary tables.
But I got error with the following sql:
mysql
On Sun, 23 Jan 2005 11:27:56 -0500
J. Wren Hunt [EMAIL PROTECTED] wrote:
I'm curious why you're interested in removing -lcrypt? Do you intend
to
replace it with another algorithm? Or are you just trying to minimize
size/processing, etc.?
The call to Sun Solaris 8 and 9 functions in
On Sun, 23 Jan 2005 11:27:56 -0500
J. Wren Hunt [EMAIL PROTECTED] wrote:
|
I'm curious why you're interested in removing -lcrypt? Do you intend
to
replace it with another algorithm? Or are you just trying to minimize
size/processing, etc.?
After further reading of what I disable, I see that I
i'm having problem starting mysqld-max,
when i use command line it just didn't start with
no error message.
I've shutdown the firewall, i'm using XP, and mysql 4.01
how can i get what have caused this
it ran well before but after i install firewall utilites
it began like this
thanks
--
i've restart the machine and it run ok
thanx
On Mon, 24 Jan 2005 07:42:41 +0700, Chenri [EMAIL PROTECTED] wrote:
i'm having problem starting mysqld-max,
when i use command line it just didn't start with
no error message.
I've shutdown the firewall, i'm using XP, and mysql 4.01
how can i
-- Forwarded message --
From: Chenri [EMAIL PROTECTED]
Date: Mon, 24 Jan 2005 08:22:01 +0700
Subject:
To: mysql@lists.mysql.com
i have a price table
no date price limit
01 1/1/05 5000 100
02 1/2/05 5010 100
03 1/3/05 5020 60
in order to input a record the price must be checked
Hi Michael,
Thank you for being so kind to explain the problem to me.
Michael Stassen wrote:
sam wun wrote:
sam wun wrote:
Hi,
Can anyone tell me how to optimize the following sql statement?
$sql_1 =
SELECT t.prodcode 'Product Code',
t.prodname 'Product Name',
Hi,
I created an index on a foreign in a table before. I need to drop this
index. but I got the following error:
mysql alter table transaction drop index prodcode;
ERROR 1025 (HY000): Error on rename of './datacube/#sql-30e8_3' to
'./datacube/transaction' (errno: 150)
mysql
mysql show index
Hello.
I'm looking for some help on a complicated query. I have data in 5 different
tables I want displayed on this page. The query I have now is
$query = SELECT Shows.Season_RID AS SEASON_NUM,
Shows.Show_Name AS NAME,
Shows.Show_RID
18 matches
Mail list logo