Databases Forum

want to build an application that allows a user to build its own form(s). A user can input data into its form and query the data too. the form can be edited after being created and used ( add/remove fields from it ). the form can have fields like: small …

Hello Is there a querry to convert a whole column into MD5 but i only need the first 19 characters of the MD5 thanks

Hi everyone. I'm trying to export my C program that used MySQL from Linux to WindowsXP and to make the exportation simpler, I'm thinking of downloading Cygwin. May I ask if I still need to download anything to help me use MySQL in Cygwin? Links to download sites and/or tutorials …

[B][COLOR="Green"]Hello Guys I have learned c++ and some of java and I wish if anyone can help in starting the database design and how can connect it to a program , I mean by giving me some useful books and programs in which I will program in(MYSQL and ORACLE ) …

Hi, I require some help in making the following possible with mySQL. My [simplified] database layout is as follows UserID Timestamp League Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Fields 1-6 values are either "yes" or "no" Basically a user submits a form selecting the …

Dear All, im given a hard copy of a form that is used by a hospital to gather information about its patients ! the form is divided into sections and each section has A LOT of YES/NO check boxes. [B][U] For example, one of the section is the History section …

As the title goes how can i transfer a table from one DB to another but first i need to delete the table1 from DB1 coz table2 from DB2 has the same name as table1...

hi there, i have a question in giving access to separate table to users. i have a database call Admin and in that there are some tables that the one user should not aloowed in viewing, how can i restric that user in avoing looking at that table i am …

Hi, I have 2 tables i am querying. The first table has 2 columns, one for folder ID and the other for Category ID. I want to query that table to get a loop of all the folder ID's based on the category ID chosen. Then i query the second …

Hi ALL, When i run this query it's take too much time to execute. SELECT ptnt.*,ptntF.familyName FROM -> (SELECT ptntPatientDetails.*,ptntPatientDetailsLang.occupation,ptntPatientDetailsLang.notes,pracStatusMasterLang.statusDesc, -> IFNULL((select countryName from genCountry where ice_global.genCountry.countryID = ptntPatientDetails.country),'') as countryName, -> IFNULL((select stateName from genState where ice_global.genState.stateID = ptntPatientDetails.state),'') as stateName -> FROM ptntPatientDetails,ptntPatientDetailsLang,pracStatusMasterLang -> WHERE ptntPatientDetails.patientID = ptntPatientDetailsLang.ptntPatientID …

hi, i need to do a query which joins multiple tables but i need to join the same 2 tables multiple times. is that possible? [CODE]SELECT timeline.TimelineID, timeline.SIPPorCASH, timeline.clients_ClientID, timeline.UserID, timeline.IFAID, timeline.RegionalSalesManager, timeline.AreaSalesManager, timeline.AgencyTradingAgreementSigned, timeline.DateOfClientMeeting, timeline.EstimatedPensionFundAmount, timeline.DateAuthorityMandateSentToIFA, timeline.DetailsOfPensionFunds, timeline.ProductID, timeline.PropertyRef, timeline.NPW, timeline.CaseComplete, clients.ClientID, clients.App1FirstName, clients.App1LastName, clients.App2FirstName, clients.App2LastName, users.UserID, users.FullName FROM …

Hi there I'm having trouble a with a forum query here are my 3 tables [B]categories[/B] [U]category_id[/U] category_name category_description [B]threads[/B] [U]thread_id[/U] [I]category_id[/I] thread_title thread_text [B]posts[/B] [U]post_id[/U] [I]thread_id[/I] post_text I want a query that selects all of the top level categories and displays them however in that query I am aware …

Please advise me on any good performance monitoring softwares for Oracle Database. Budget is no issue. I want to find and fix performance bottlenecks in Oracle Database (Oracle 9i Rel2), as well as generate graphs on statistics collected over a period of time. At present I am evaluating: 1) Spotlight® …

hello, I need to display contents with their tags, and in same page all the tags of the page contents the problem is having a limit on contents doesn't work if join tags on them (the number of tags change the number of select contents) [B]THE TABLES ========== [/B] I …

Hey everyone. I have a mysql project that requires only some basic queries except one. Nothing more challenging than some really basic select/insert statements. No problem there. But the one complex one isn't working out. I typically work a little with SQL server and wrote the following at work in …

Can we call a single trigger for multiple tables.... say I have two identical tables a and b. now we have a trigger that is needed to be called by each table. It is possible in POSTGRESQL using Triggers function.... these functions allow to call a single trigger function from …

Hello all. I created a C program that used MySQL in Linux and now I'm transferring the program to Windows. I would like to ask what software do I need to download/install in Windows to be able to compile and run the program there? Also, when the program is already …

Hi guys, I'm doing a web app that will be available in various countries and I need it to be quick enough. That's why I'm wondering if keeping a separate database for each country would be faster than using a common database and filtering the results by country?

This looks pretty simple on the face of it but I can't get my head around it. I have two tables that I'm querying: dbo.tblrespondents RespondentID FirstName Surname dbo.tblrespondentschildren RespondentsChildID RespondentID ChildFirstName ChildSurname ChildDOB ChildSex I am trying to find which Respondents who have only sons - one must be …

Hi, this is what i've got so far: [CODE]$sql = "SELECT * FROM ".$_SESSION[dbprefix]."users, user_skills WHERE user_skills.userid=users.id AND ((users.username LIKE '%" . $queryString . "%') OR (users.email LIKE '%" . $queryString . "%') OR (users.firstname LIKE '%" .$queryString . "%') OR (users.lastname LIKE '%" . $queryString . "%') OR (user_skills.skill …

is it possible to create an index using substr ? say for example i have a field called num which has char(8) as its datatype and length. an example of num's value would be something like 09092010 now what i want is to create an index using the last 4 …

Hi! Could someone tell me please how to configure MySQL DB for storing both latin and cyrillic data sets in the same table? Thanks!

hi, M'soft sites documented that [CODE]RECEIVE TOP (n) FROM Target[/CODE] should fetch the n number of message from the specified queue. I am having problem with this, and do not know why because not much resource is available pertaining this. Tried finding for an answer on Klaus Aschenbrenner's book, failed. …

Table name = Contacts. Table attributes = first_name,last_name,email_address,other_email,address,phone,notes. I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show. Is there any SQL data for this kind of situation?

hi, i have a problem in login in to the MS SQL server 2008, i installed the MS SQL with the authentivcation mode as Mixed mode and and for the SQL server administrator i added the current user and for the password i gave a different password, which is not …

Hi every body i need you to help me to find the solution of exercise and review questions for (Thomas M connolly database systems practical approach to design implementation and management)four or five edition (chapter 9 - 10 - 13 - 14 - 19) or • Briefly, describe the main …

Hi all, i'am having a problem with my sql database.I'm able to insert and retrieve data.but i couldn't able to view the data in my sql interface.all the columns are empty.so where the data being stored ? why it is not appear to the sql interface ?

Hi, I want to take backup of all my tables in my system and i want to use in other system.Tell me how to take back up tables in oracle 9i and how to import or use those backup table in another system???

Ok, I am trying to access my table via php. I have a successful connection to the server and a successful selection of the right database on the server. But I keep getting this error message when I try to run my query line through the mysql_fetch_array() finction: Warning: mysql_fetch_array(): …

Hi Everyone, I got a problem while creating a views in sql server 2005. In my database there are several tables which are accounts_transaction bill_info member_bill member_info relationship is exist between “member_info and accounts_transaction, member_info and member_bill, bill_info and member_bill” but there is not any relationship between bill_info and accounts_transaction. …

Hi, I'm new to mySQL and I've got to run a bunch of queries on a database that I've been designing for a hypothetical record company. If anyone could check my queries, I would appreciate it greatly as they don't seem to be returning the correct results and I'm not …

Hi Guys, I'm having an issue with my sum() function on my queries. My DB has 3 tables 1. plans 2. handset 3. matrix [B][U]plans;[/U][/B] - planNum - planCode - planName - planLength - simRebate - commission [B][U]handset;[/U][/B] - handset - RRP [B][U]matrix;[/U][/B] - planNum - handset - subsidy The …

I've spent a good while looking, but keep coming up empty. Can anyone provide any advice for reading from a database (Google search has lead me to believe it is Paradox, of some type) with the file extension T.

This trigger is making me nuts! I've written about a dozen triggers before but nothing where I have ever pulled data from another table. What this is supposed to do is make sure that any inserted rows have a latitude/longitude (lat/lon) value. The users table has the lat/lon and these …

Hello, I'm using SQLBulkCopy to import data from a text file. There is a lot of data involved and I would really rather not import it row by row. There seems to be a problem with fields containing both numbers and text. (for example, a phone number '555-1212'). All fields …

I'm having problems creating the following trigger as I keep getting the syntax error listed below the sql code and well, that error is about as clear as mud! LOL Two things to note: users is a valid table name and it does contain fields called lat & lon (latitude …

Hi i'd like to know how to store dynamic string into MySQL database from c#.net desktop application. I was able to store only fixed data . Help me pls as i 'm new in database . thanks

Table name: upload [B][U]Id[/U][/B] [U][B] Name[/B][/U] [U][B]Email[/B][/U] [U][B]File[/B][/U] 153 Jegan [email]jeg@yahoo.com[/email] id.doc 154 Alex [email]Alx@gmail.com[/email] de.doc Consider the above table, I want to delete the [email]Alx@gmail.com[/email] in 154. Plz give the idea.

Hi, I am designing a new db for my website. It is a database of events with the following tables. Events Category Owners Countries Regions Subregions I am left with the following dilemma, I use foreign keys to ensure fast links between the table Events and other tables (category, countries,...) …

Hey, I have a problem in my database. I have these two tables: [CODE] Table "File": +----------+--------------+-----+----------------+ | Field | Type | Key | Extra | +----------+--------------+-----+----------------+ | idFile | int(11) | PRI | auto_increment | | path | varchar(255) | | | +----------+--------------+-----+----------------+ Table "Media": +----------+--------------+-----+----------------+ | Field | …

I'd like to make standalone desktop application which is connected to mysql. i mean my app will be used in different network rather than mysql DB . DB will be set up in other network. Is it possible to build this kind of application? If so, how can i implement …

Hi Guys, I am looking to query a db having multiple brands of cars then from those results I want to further filter it based on the type of oil they use. I have written the below but it does not work and I am not sure how I can …

hello all i have allready created table and wan to add Composite primary key into that so for that i am using following statement [CODE] ALTER TABLE pqrimasterdetail ADD primary key (PQRIMasterID,Type,Year,PhysiciansID);[/CODE] but in not executed successful it gives the query could not be Executed. Multiple Primary key Defined if …

Hello friends. I need a good article or book that compare storage engins _such as MyISAM, InnoDB, Falcon and etc_. if any one know a good source please introduce me. Tanks if help me.

hi dears i want designing a db.mdf Bank for a website of school that student can see their record (grade) and news of the school on web site. the principal can send email for students and teachers. whether the structure tables are apparopriate? help me in dtermining the types of …

hey i have a mdf file which i made an application in visual studio 2008 and i want to migrate all the data and the tables in to the MySQL server, can someone help me in this thanxxxxx appreciate a lot

hi, im having a problem on my project dont know how to normalize the customer information and the flight details

I have quite a long list on my listbox. And when I wanted to search for words like "Boy", I need to go through all the letters before 'o', for example, 'bacon', 'banned', 'because' and so on. I know that the listbox allow the user to search for the first …

Hello all, This isn’t a strictly MySQL issue, it has to do also with PHP Apache and cPanel but I believe the core is MySQL so I decided to post it here. Recently I had a SQLSTATE[08004] [1040] Too many connections issue. I use PHP PDO for the connection and …

I've been knocking my brains for a while with this one. I need to search a particular table for any records that contain an equal sign [B][COLOR="Red"]=[/COLOR][/B]. This works for any criteria except [B][COLOR="Red"]=[/COLOR][/B] : [CODE]SELECT id, mystuff FROM db1_user WHERE email LIKE '%=%'[/CODE]