Re: Before I shoot myself in the foot...

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 [EMAIL PROTECTED] wrote: Many thanks to all who took the time to reply. :) :) -- MySQL General Mailing List For list

Re: Understanding mysql NULL handling ...

Hi, Because NULL is not a value. Operators [!=] must be suceeded by a value. These orphans must be selected in a correct way using is clause. Thanks ViSolve DB Team - Original Message - From: Mufaddal Khumri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, June 14, 2007

Re: Design Help Needed

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

Re: How can I do something like this SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); ?

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:

Re: Before I shoot myself in the foot...

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

Re: Before I shoot myself in the foot...

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 x

Re: Before I shoot myself in the foot...

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

Re: Before I shoot myself in the foot...

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

RE: Design Help Needed

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

Request: Schema suggestion for items which change over time...

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,

Creating a Cache field

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

Re: Request: Schema suggestion for items which change over time...

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 particular

Re: Creating a Cache field

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,

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 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

RE: Design Help Needed

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

Re: MySql Host through Heartbeat

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

SQL question

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

Re: SQL question

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

Re: SQL question

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

Re: need help with delete query

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

mysqldump for myisam tables.

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.

Re: mysqldump for myisam tables.

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

Re: need help with delete query

- Original Message - From: Ben Liu [EMAIL PROTECTED] To: mysql@lists.mysql.com 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