7,494 Archived Topics
Remove Filter  | |
| | hi I am learning mysql and have created a table for auditing purposes with fields below , but my problems is I dont know how to go about inserting data into it whenever an event ocurs on my primary tables.especially getting the oldvalue,newvalue,column and table name fields after updates are … Databases mysql |
| | I design a database on Mysql , one of the tables is call 'account' which contains user related information like username, email address etc. Due to large amount of user data running in millions of record, I have decided to partition the account table. The first partition should contain username … Databases database-design mysql |
| | I've got quite a slow query, that I need to get a random record from, however this is proving painfully slow, can anyobdy suggest ways to speed up the following query. SELECT * FROM people WHERE names like "%bert%" or names like "%john smith%".......... or names like "%eric%" ORDER BY … Databases mysql |
| | hi all, can some one help me how to display the fields which enter in current week,current month like that  |
| | Hi can someone shed some light on this problem I'm having please? 2 tables SHOWS_ARCHIVE (TABLE 1) ID SHOW_ID AUTHOR SHOWS (TABLE 2) ID When the member logs in they are a loud to see their shows because of the $author permissions; [code] if ($_SESSION['MEMBER_PERM'] == "2") { $author = … Databases mysql |
 | [B]Can someone let me know how the date syntax work. example working with "greatest" 01-oct-02 and 20-may-2003, it accept 20-may-2003 to be the greatest instead of 01-oct-02 which the oldest (greatest) can someone explain this to me. please let me know the logic behind. I have alot of problems with … Databases oracle |
| | Hello All, Can anyone help me how to insert html code in mysql database coloumn and also how to change the var char to 1000, for now it is 100. Please help me out thanks 7 regards Raj |
| | status teacher build exam (question and answer) and student take the exam form build_pre_exam add data into pre_exam table when form run , user(teacher ) have to insert question and four cooses then choose from list item which one i correct answer (to enable to check exam for student) ,after … Databases oracle |
| | Hi, Can anyone help me how to retrieve data from table in the following manner. In my application I have five button namely First,last,next,previous,and Query. When I will press the query button, it should show me last data that I had feed to the table. When I press first button … Databases oracle |
| | I am doing a project using oracle10g XE and JSP. Here i am using a table where data type of a field is autonumber. It is working fine when i insert or update record. but it does not continue its sequence when i delete a record. For example i have … Databases oracle  |
 | hi; here is a part of my ERD "Hotel Reservation system" and there is a relationship with 3 entities included in it. they are: customer Reservation Room the relationship between them is "assign to" I make it as 1 to 1 relationship and i want to know than , how … Databases |
 | Does anyone know how Oracle's PL/SQL handles subtraction with a negative number? Really what I need to know is, given the following: (NOTE: this is NOT the code I'm working with. It's just an example to give and idea of what I'm trying to do.) [CODE] DECLARE number1 NUMBER; number2 … Databases oracle |
| | Hi all, I using PHP & MySql. Here's the situation: 1. I have a website which is a meeting place for employees & employers. Employees can sign up for an account & select the skills they have. These skills list will be shown on their resume. I have an array … |
| | Hello Again, Again being a novice at MS Acces 2003 this is definitely outside my ability. I was told that using visual basic it is possible to show a month calender in a form instead of just entering the date in a field. The user should be able to have … Databases microsoft-access visual-basic |
| | hi, i need some advise regarding storage of data is it good to store data in files rather than storing into database? (eg data like comments or additional features of products that users advertise on our website.) will it help for speed optimization. Databases file-system mssql storage |
| | Hi, I have this problem to solve [quote]Create a set of tables to store data for an address book (contact) application. Bare in mind the following design criteria. * The application will be used by multiple people so the database should also store a list of users. * The people … Databases database-design mysql |
| | Hi i need help on how to create a query so that the result will be like in my attach screenshot Databases mssql  |
| | Hello all, lets say i have a table like this which has 3 columns and 3 rows; -----------------------------------------------------------+ COLUMN_A.....|.....COLUMN_B.....|...COLUMN_C | .........X............|...........X............. |.........X...........| .........X............|...........-...............|.........X...........| ..........-............|...........-...............|.........X...........| -----------------------------------------------------------+ So, now i have an input like; (user submits a form) ----------------------------------------------------+ ......X............|...........X............|..........-.......| ----------------------------------------------------+ now; the first column of row#1 is X so it is … |
| | Hey guys, I'm currently testing my application with some scripts I have written. I'm using the following query to list known errors within my application, and the status of the tests that are are affected by each error: [code=sql]SELECT ERROR.BG_ERROR_ID, ERROR.BG_USER_03 as HardwareID, count (RUN.CY_RUN_ID) as NumAffected, sum (CASE RUN.RESULT … Databases mssql |
| | Hi I'm having trouble with a subquery and really need some help. I'm trying to count to count the number of beats sold by a particular producer. So the first thing I did was SELECT all the beats sold by that producer so I wrote the code [CODE] select name, … |
 | Hi! I've got a table of, let's say, widgets. Each has a unique id (primary key) and a few other attributes such as widgetid (unique, number) widget_name (string) widget_price (varchar) widget_color (string) BUT, for each widget, I also want to list other widgets (that are listed in the same table) … Databases database-design mysql |
 | Hey can anyone give me the query to retrieve a list of databases on a server rather than this query [code]SELECT NAME FROM sysobjects[/code] which gives me a list of tables ???? Thank you Databases mssql |
| | i get an excel report each month, There are two columns (person`s name and Salary) in this month report there was 99 persons. my question is , if in next month excel report there are less persons...say 75, and also 23 persons raised their salary.. how can i updatae this … Databases mysql |
| | was directed here by another member...great site! (am a newbie and I recently posted this on MSDN with 0 replies, am hoping someone can help here - you do not need to know VFP, just need help formatted a correct string that ASP will honor), Current Setup: Using: Visual Web … |
| | I need to get the 'customers_info_date_account_created' from the 'customers_info' table where the field 'customers_info_id' matches with the field 'customers_id' in the following query: [code=sql]SELECT * FROM customers WHERE customers_id NOT IN( SELECT customers_id FROM orders )[/code] I basically have all the information in columns from the query and need an … Databases mysql |
| | The following stored procedure is supposed to add a new record to the database OR update Mdescript if it already exists. However I keep getting errors such as primary key violations. Please take a look, many thanks :) [CODE=SQL] USE [COSHH2008] GO /****** Object: StoredProcedure [dbo].[CHSP_OR_ACTIVITYAREA_001] Script Date: 12/02/2008 13:59:33 … Databases mssql |
| | Author Table INSERT INTO Author VALUES (12,'James Smith' ); Using join conditions Find memebers (by name) who have ever borrowed a book written by certain authour (JAMES SMITH) |
| | hi all how to run the multiple sql statements same time in mysql querybrowser? for example i am write two sql statements, i want run the second statements in mysql query browser, how to terminate the first statement thanks Databases mysql |
| | Good day everyone and are there any Access geniuses out there who can help Jose and myself with some links, dates and logic for our HR database that we are stuck with? Cheers, Murdo PS My ady is <EMAIL SNIPPE> Databases microsoft-access |
| | |
| | I'm quite knowledgeable with T-SQL and know a little VFP. I would like to code what I think would be a very simple program. I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a … |
| | Hi, Please help me with Expression builder for my FOrm. Weight_likely - back end DB Column I want an expression, where if Weight_likely is blank then in form 0 should be populated or if Weight_likely has a value then the value itself should be populated. =IIf([Weight_likely]="",0,[Weight_likely]) Please help me on … Databases microsoft-access |
| | hi, I need to know how to get only the upper case currency from a table using oracle. e.g:- data for currency will be as follows USD AUD EUR SGD AUd uSD EuR I need to get only the upper case currency among all the other currency such as USD … Databases oracle |
| | Hi, I was wondering how I would enter something like a paragraph in MySQL if you declared it as type TEXT. So how would I enter something like: [COLOR="Red"] John 3:16 (New International Version) 16" For God so loved the world that he gave his one and only Son,[a] that … Databases mysql |
| | I'm trying to display data in cold fusion but when I add my history table I get duplicate listings. I've tried select distinct different joins. How do i join my history table and not get duplicate listings My store procedure in MS SQL is [CODE]USE [Website] GO /****** Object: StoredProcedure … Databases mssql |
| | Hi all, I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i try it errors. Do I have to reword the statement … Databases microsoft-access sql |
| | I have 2 related tables, master and a child, the master table have a primary which is an autonumber and I reference that autonumber to my child table as a foreign key so my problem is to get the value of the autonumber from a master table and write it … Databases mssql |
| | Hi, For 2 lakh records, this works well but when the total number of queries is more than 5 lakh it does not . Actually i have 64 lakh records to work with and this gets forever. [code=sql]UPDATE tmp_yk_contributor set score_last_update = '$date' , ykscore = (IFNULL((select avg(score)*0.8 from yk_entity_score … Databases mysql |
| | hi experts, Is it possible that i could get the 3 queries made into one single query.Any help could make me understand and correct myelf in better queries. Each query is taking long time and sometimes the first query crashes , with > show processlist showing status as 'copying to … Databases mysql |
| | I have a busted five table design for a food item guest ticket . Here are the names(Actual) of those tables: GuestTicketType, GuestTicket, GuestTicketOrderCategory, GuestTicketOrder & GuestTicketPayment. The incomplete(busted) design looks like this: guesttickettype has a field named guesttype, which is one of three guest types: dinein, takeout, delivery. The … Databases microsoft-access |
| | hi all, i have a auto suggestion box which displays countries when we type [B]a[/B] it will display all countries starting with letter [B]a[/B] like alaska,australia etc...,but i want to display every name which has letter [B]a[/B] in names like [B]a[/B]ustr[B]a[/B]li[B]a[/B],indi[B]a[/B], etc... Databases mysql |
| | OK .. I was migrating an application from a staging server where the MySQL version is 4.1.10a to a live server where the MySQL version is 5.0.45. There apparently is quite a difference between query syntax on one versus the other. For example, in version 4, this worked: [CODE]SELECT uas.usr_id_users, … Databases mysql |
| | I have converted around 395 Excel survey forms to MS SQl database with that many tables. Well, I run a script to assign a primary key on all the tables on my database.First I set the column property to NOT NULL and then i assign the primary key to it. … Databases mssql |
| | I would like to create a variable in my trigger - @DBNAME. When the trigger executes, this value should be set to the name of the database it was executed in. E.g. for the master database the value of @DBNAME would be master. How would I go about figuring out … Databases mssql |
| | Hi, anyone can help me convert or set my .mdb with form in ms access file to an application? i mean an application open the interface(form) without open microsoft access. Databases microsoft-access |
| | I am writing my first database app (windows form in c#) and I am using an access database. I have 2 tables with the following fields: payroll --Store --lastName --PayFreq --SSN (PK) --HireDate --EffectiveDate --TermDate --DeductionCode --Deduction --NAD CHAR hrconnection --Store --lastName --CoTime --Plan --Dependants --HireDate --EffectiveDate --TermDate --SSN (PK) … Databases app-store microsoft-access |
| | Hi all, Just a quick question: I have my website done and the database I used is MS Access. Problem is MS Access' return of results are really really really slow. Now I want to shift to SQL server, but the web hosting site we paid does not support this … Databases mssql storage web-server |
| | How would I draw an ERD for a situation like this: professors can teach the same course in several semesters, and each offering must be recorded. If I know that: Professorss can have an SSN and courses can have a courseid. Any helpful suggestions are welcome. Databases |
| | I was wondering how do you countdown to a given date, like for and enevnt or something. Let's say you know the target date is let's say Christmas and you have the current date, how do I calculate how many days are between them? Databases mysql |
| | Hi , Wishes! I am doing a iterative calculation and in the last iteration, i update few of my tables. What i am trying to do is , make this update more perfect. Is it possible for me to do updates in small steps with using LIMIT. i do not … Databases mysql |
The End.