Databases

NAVIGATION

SQLeonardo MMV.VII released :: java database fronte-nd

SQLeonardo is a powerful and easy-to-use tool that lets you querydatabases. Written in Java, distributed under the GNU GENERAL PUBLICLICENSE.More details and a download may be found at:Regards, Nickyb...

0 answers | 239 bytes |

How should I represent this constraint?

I have a set of USERs.Each USER can have multiple DEFAULT_LISTs that belong to it.Every DEFAULT_LIST belongs to one USER.Each USER can have multiple FILEs that belong to it.Every FILE belongs to one USER.Each DEFAULT_LIST can have multiple FILEs associated with it.Each FILE can be associated wit...

3 answers | 689 bytes |

Can 1 UPDATE SET more than 1 table?

update CST_TAB,PS_TAB,BJ_TABset cost_tab.f38=epl.pricesu,PS.F2119='1',BJ_tab.F22=E PL.UMFRM CST_TAB CST_TABINNER JIN EPL EPL N CST_TAB.F26 = EPL.SKU AND CST_TAB.F38 <>EPL.PRICESUINNER JIN BJ_TAB BJ_TAB N CST_TAB.F01 = BJ_TAB.F01INNER JIN VENDR VENDR N CST_TAB.F27 = VENDR.F27WHERE...

3 answers | 569 bytes |

Automatic database request

Hello,I will implemented a MySQL database on a Website. There will be a date fieldon this database and I want this field to be check automaticly to make anactrion if the date expired.The "program" must run by imself on the server.How can I do that? I was thinking that a CGI script on the server...

4 answers | 502 bytes |

Real estate modeling problem

Hello Guys, I am having this real estate project and i am looking forsuggestions. Any help will be appreciated.The answer should contain:1-A fully developed conceptual data model using EER. include a datadictionary including a description for each entity, relationship andattribute.2.A logical (r...

1 answers | 2085 bytes |

escaping strings that are to be inserted

MySQL escapes, among other characters, \n, \r, and \x1a, when stringsare being inserted into a database. I can understand why \, ', and "would be escaped (not escaping them could lead to SQL injectionattacks), but what about \n, \r or \x1a? What's the worst that couldhappen if those we...

1 answers | 406 bytes |

APPLY JOBS/SEND MATRIMONY MSGS & WIN MONTHLY GIFTS

Looking For Better Jobs?-Apply FREE Various Jobs And Win Monthly Gift-Browse Interveiw Calls Free-Employers Can Post 5 Jobs Free And Also Win Free GiftsLooking For Bride/GroomSend Matrimony Messages FREE And Win Monthly Gift-Browse Initiated Contacts FreeLovleen(Marketing Executive)...

0 answers | 342 bytes |

what is the different between "oracle" and "mysql"?

what is the differnent between them?thanks!...

7 answers | 66 bytes |

Indexes and -Null- values

My DBA friends once explained to me that null values, when usedas a part of a restriction clause in SQL do not take advantage of anyindexes placed on that specific column. As in the generic examplebelow:SELECT column_a, column_b, column_cFRM table_aWHERE column_a is not nullIt was explained to m...

7 answers | 825 bytes |

Global schema + web services

Hi,how in general web services use global schema of distributed database?Any help would be appreciated!regards,lmierzej...

0 answers | 162 bytes |

exec dynamic query doubt

I am trying to execute a dynamic query as followsbegindeclare @tablename char(46)declare @query char(1000)declare @Age intselect @tablename='People'select @query='select @Age = age from '+@tablename +' where name=xyz'exec (@query)endThis is giving error :QLException...

7 answers | 542 bytes |

US-NY-Looking for Junior or Mid Level SYBASE DBA - Long Term Contract

Junior or Mid Level SYBASE DBA LNG ISLAND CITY NY VERY LNG TERMDURATINExperience in Sybase version 12.xExperience with installing and configuring Sybase database.Experience with Shell scripting using Ksh, Csh and PerlExperience with tuning and troubleshooting production database issues.Experienc...

0 answers | 1105 bytes |