- Original Message -
From: "Ben Liu" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 14, 2007 3:11 PM
Subject: need help with delete query
I'm trying to delete a subset of items in a table. The problem is, I don't
want to query for the subset first, store the results and then run a
se
Hi All,
What are the parameters that i need to use to take consistent backup of
myisam tables using MYSQLDUMP.
regards
anandkl
On 6/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All,
I am taking mysqldump of myisam table for the first time on a production
database. Can you please let me k
Hi All,
I am taking mysqldump of myisam table for the first time on a production
database. Can you please let me know what all necessary thing i need to take
care before i start mysqldump. Its on a running database. Also please tell
me what all important parameters i need to use in mysqldump.
Th
Thanks Brent, good tip. Works like a charm.
On Jun 14, 2007, at 7:42 PM, Brent Baisley wrote:
Here's a little trick. Get your DELETE query working as a SELECT.
Then replace everything before FROM with DELETE tablename.
SELECT order_items.ord_id FROM order_items LEFT JOIN orders ON
order_item
Thanks - that's what I thought. I really don't have much experience with
mySQL. If it's not too much trouble, could someone give me a bit more help
on how to do that please?
Ed.
no, those won't match based on just the datatype change.. you will
have to define a user defined function to do
Thanks, that's interesting. Actually the uc.ID column is still type tinyint
as it holds only one number, but are you saying if I change this to varchar
my query will work e.g. 15 = 15:17 would work?
What is the type of the 'uc.ID' column? If it's varchar, your match
will work fine. If it
Hi,
I have the following mySQL query in my script which has been working fine
but due to a recent change, I had to modify one of the columns,
bt.category_ID. This used to be defined as tinyint(3) but I've changed that
now to varchar(20) as it needs to hold values such as 15, or 74:79 or
43:56
The "\!" command is specific to the mysql client and executes locally,
making it useless for this purpose.
If you don't have access to 5.0.41+ and the database you are querying is a
replicated slave, you can use the 'server_id' variable to tie the server
to an actual hostname (SHOW VARIABLES LIKE
Because you are a novice to data base design, you have fallen into a common
trap. If you think about an array, you don't want to store multiple users in
a row, you want to store them in a column. In other words, you want to have
one table that stores businesses (once per business, probably) and ano
I'm trying to delete a subset of items in a table. The problem is, I don't
want to query for the subset first, store the results and then run a series
of delete queries. I believe this is a rather basic issue that has a
well-accepted, simple solution which I am ignorant of. There are two
relevant
At 10:22 AM 6/14/2007, Ins wrote:
Hi,
I have a MySQL database of thousands of external webpage links. I want to
extract cache page for each and put the content in my database, so that I
can display, just like google, a cached page for each weblink.
How do I go about it? How to extract cache, h
Hi,
On Thu, June 14, 2007 18:16, Jake Peavy wrote:
> Hi all,
>
> Can someone suggest a good method or normalized schema for storing product
> information (id, description, price) which changes over time so that as a
> product is gradually discounted, an order will reflect the cost of that
> partic
Hi,
I have a MySQL database of thousands of external webpage links. I want to
extract cache page for each and put the content in my database, so that I
can display, just like google, a cached page for each weblink.
How do I go about it? How to extract cache, how to store it and how to
display it
Hi all,
Can someone suggest a good method or normalized schema for storing product
information (id, description, price) which changes over time so that as a
product is gradually discounted, an order will reflect the cost of that
particular product at that particular time?
--
-jp
At birth, Chuck
Hi Sudheer,
First of all there a number of ways to design this database.
You will need to choose the one that you feel suites your needs best.
Here one possible design.
Because you have different type of users/accounts, it looks like
"ACCOUNT_TYPE" table is needed
ACCOUNT_TYPE table
Account_
> You mean stored procs and functions are not dependent on tables?
They can, but not "have to" use tables.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development que
> You mean stored procs and functions are not dependent on tables?
They can, but not "have to" use tables.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development que
You mean stored procs and functions are not dependent on tables?
On 6/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Stored procedures and functions are not associated with tables. Triggers
are, and I
don't know about those.
Ananda Kumar wrote:
> Hi All,
> Will the rename of table from y to
Stored procedures and functions are not associated with tables. Triggers are, and I
don't know about those.
Ananda Kumar wrote:
Hi All,
Will the rename of table from y to x cause for all the stored procs,
functions on this table to be come invalid?
regards
anandkl
On 6/14/07, Brian Dunning
2007/6/13, Ricardas S <[EMAIL PROTECTED]>:
ops again you probably needed just
select greatest(col1,col2,col3) from t order by 1
Thanks, it's work very well.
best regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
HI Sudheer,
THIS DESIGN IS BASED ON MY MANY->TO->ONE DIRECTION PATTERN
OF DATABASE NORMALIZATION DESIGN... PLEASE MODIFY/CORRECT IT ACCORDING TO YOUR
TASTE. AS A JAVA DEVELOPER I'M USING HIBERNATE FOR MY CREATE-UPDATE-DELETE(CUD)
AND DIRECT JDBC FOR MY QUERIES(R).
YOU MAY VARY.
HERE, HOPE TH
21 matches
Mail list logo
