2,403 Solved Topics
Remove Filter  | |
| | 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 … Databases mysql |
 | 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 … Databases |
| | 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 … Databases microsoft-access seo |
| | 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] Databases mysql |
| | Hi everyone. I'm using sqlite3 in Linux and I currently have a problem. I have a database and 2 tables in it: db1 and db2. db1 has 3 columns: empID, empName, empAddr. db2 has just 1 column: empID and its value is set to 0 by default. I created a … |
| | Hi, I need some help with this MySQL Update I've got three tables as below. tbl1 id eid quantity 1 3 2 2 4 3 tbl2 tid eid qnty status type 1 3 1 1 1 2 3 0 1 0 3 4 1 1 1 4 4 0 1 … Databases mysql |
| | Hello: I have a table where a column called [I]ActiveStatus[/I] (of datatype 'bit') I am trying to run a query on may contain values Boolean values or NULL. Which means, if there are 10 rows in the table, a likely scenario would have 5 NULLs, 2 FALSEs, and 3 TRUEs. … Databases mssql  |
| | Let's say that I want to retrieve rows from just one table and exclude rows with certain ID's. Hypothetical table: [CODE] +----+-------+------+ | id | value | type | +----+-------+------+ | 1 | foo | cool | +----+-------+------+ | 2 | bar | cool | +----+-------+------+ | 3 | lor … Databases mysql |
 | I have a stored procedure where I need to insert from some other tables when those items do not exist in the original table. Here’s the stored procedure that I wrote. [CODE] ALTER PROCEDURE [dbo].[sp_CreateRequestedItems] AS BEGIN INSERT INTO dbo.RequestItems ([request], [applicationProfile]) --select from requests and profiles table into requestitems … Databases mssql |
| | I have the following three tables: ClassHeader ClassID Major TeacherClasses TeacherID ClassID StudentClasses TeacherID Major I want to select all TeacherClasses where the a given Major = ClassHeader.Major Databases mssql |
| | Hello! I’ve got three tables that I want to link together. When I try to upload images and text throught a form, the web browser show this error message: [QUOTE]Error, query failed 1452-Cannot add or update a child row: a foreign key constraint fails (`mn000532_almacen`.`images`, CONSTRAINT `images_ibfk_1` FOREIGN KEY (`itemID`) … Databases mysql web-browser |
| | [CODE]<?php include("includes/connection.php");?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php echo $sql= "SELECT * FROM forms WHERE today >= CURDATE() - INTERVAL 30 DAY"; $result=mysql_query($sql); while($row=mysql_fetch_array($result)) {echo $City= $row['City']; echo $Name=$$row['Name'];} ?> </body> </html> [/CODE] i just … |
| | Hi, I've writen a stored procedure that is supposed to load 4 tables in a database that are to be used by a vendor to load their tables for an application we purchased from them. being that our data is on multiple servers, the query must read from two servers … Databases mssql |
| | Given the following two SQL operations: [CODE]select prod_Id, P.proposal_id, P.institution_Name from proposals P group by P.proposal_ID having mark >= 50 order by P.proposal_id desc select prod_id, P.proposal_id, PA.evaluator_ID, U.user_Given_Name, U.user_surname from users U, proposals P LEFT outer JOIN proposal_appraisal PA ON (P.proposal_Id = PA.proposal_id) where PA.evaluator_ID = U.user_id group by … Databases mysql  |
| | I have a machine logging production info to a database whenever certain conditions change state, so pretty much randomly throughout the day. The plant runs 24/7 so data is continuously flowing into it with about 500 entries in a 24 hour cycle. The shifts are strictly time based and are … Databases java-swing mysql |
| | Hi I am a bit rusty with SQL, not used it for about 8 years so would appreciate a bit of help. I have three tables, normalised, organisation, stores org_name and org_id ativities stores activity_name and ativity_id org_activity stores org_id and activity_id I need to get a list that contains … Databases mysql |
| | hi, i'm using phpmyadmin & would like to create an additional field in the following table. Field // Type Collation Attributes Null Default Extra Action user_id // int(10) first_name //varchar(20) last_name // varchar(40) email // varchar(80) pass // char(40) user_level //tinyint(1) active // char(32) registration_date// datetime the field would be … Databases mysql |
| | Can anyone please help me with installation of oracle 11g on windows 7 home basic 64 bit? On prerequisite check its giving an error that "this version is supported by os version up to 6.0 only and not by this version 6.1" Databases oracle  |
| | Wasn't sure whether to put this with PHP or Mysql I'm having trouble with the below code, it only does the inner while loop once, while still cycling past it every time. It should update the "favourite" integer column in each "link" by checking if it's in the favourites of … Databases mysql |
| | Hello Could help me get the right MySQL on my computer. I had it installed but it was a couple years ago. My cp crashed. I can't remeber how or what to install. All I have left is the script I used. I was running the command window one. that … Databases mysql |
| | Hello Everyone, I hava design just a register page and a login page ,a user can register then login..during registration i used the password() for password field insert value to database. During login I used as password('_POST[pass]') and comparing with the inserted value but its not working .... I just … Databases database-design mysql |
| | hi all i was wonder if its possible to join 3 tables, so i could see the result from the 3 tables. for example lets say that i have INVOICE(invoice_id, client_id,item_id) CLIENTS(id, client_name) ITEM(item_id, item_name) i want 1 table that shows: invoice_id, client_name,item_name is this possible? 10x! Databases oracle |
| | I've looked at this from every angle, but can see nothing wrong. The MS Access table "LocationLinks" contains only 6 fields. LocationLinkKey - autonumber, primary key. LocationKey - long integer, required, indexed, duplicates OK LocationType - string length 4, not required, not indexed RelatedLocationKey - long integer, required, indexed, duplicates … Databases java microsoft-access sql |
| | I'm trying to teach myself a bit more php/mysql so that I can implement better usability on my osCommerce site. I've set up a bit of space on the web server and the db server so that I can play about with stuff and I'm close to doing what I … Databases mysql php web-server |
| | Hi folks I need some help! I have two tables the first contains account information, and the second contains flags that records in the account table may have. These are joined by the account?id. One account record may have several flags from the flag table. ie the following select select … |
| | I have a query which generates an xml file from data collected. There are 2 columns in the data (reason, TotTime) but they are joined together into one column using the concat command. Currently the results are ordered by reason, but I want to limit my results to only the … Databases java-swing mysql xml |
 | Hi, I am developing a program which requires access to my websites' MySQL. I keep getting errors trying to connect to it. My firewall is allowing the connection but MySQL won't accept it. How can I solve this problem? Thanks in advanced Kieran :) Databases mysql |
| | Hi, I have a table `Categories` with fields (category_id, category, parent_category_id) I want to write in a single query to replace the parent_category_id with the corresponding category_name. [CODE] // OBJECTIVE: To return all category names and parent category names // if category is root (no parent), parent category name is … Databases mysql |
| | Would someone please try & modify this query in a way that it shows the count for how many users have registered for the current day ? So like right now it should display a count of 2 and then come midnight it would show 0 and then incrementally go … |
| | Hi! I've downloaded the MySQL Server 5.1 and developed a small database using the MySQL Command Line Client. However, now I must update a structure of some tables, include some foreign keys, etc. In my opinion, it is not very comfortable to use the MySQL Command Line Client and the … Databases client-server mysql user-interface |
| | I'm new to Access 2007 need some help in regards how to build expression for the following - Product Price $: * Product Quantity - % (any number). Started with the following expression: Total Cost $: [Product $:] * [Product Quantity:] - [Discount %:] Databases microsoft-access |
| | Hi I installed visual studio 2008 64bit.and i need MS sql server express 2005/2008 64 bit. plzz help me.i tried one.but installation is not completed.Is there a special way to install it. Databases mysql visual-studio |
| | Hi, Can anyone advise a good ER modelling tutorial/book or program? It is very time consuming to do ER diagrams in word. Also, has anyone else has come across the 'Pet Practice' database modelling problem? Thanks. Databases |
| | I have a table that a new line gets added to when the machine stops with reason for stopping, when the machine gets going again I want to add the time lost. So when the machine stops the table will look like this: [CODE]ID | reason | time_lost 1 | … Databases mysql  |
 | I'm in the middle of a project development, and I'm frustrated with this problem. Im running XAMPP under Ubuntu 10.04 (Lucid Lynx) mySQL version : Ver 14.14 Distribution 5.1.41 The problem is that, mySQL is accepting null values even if the field is declared with the NOT NULL constraint. Example: … |
| | Can anyone see what is wrong here? This is my first serious attempt at this.[CODE]<?php $query1 = mysql_query(" SELECT topics.url_big, topics.url_small, topics.title, topics.".$egroup.", quiz.passState FROM topics INNER JOIN quiz ON (topics.managerId = quiz.".$managerId.") WHERE topics.".$egroup." = 1 ORDER BY title ASC"); ?>[/CODE] Databases mysql |
| | I need to make a Registration show hide based on whether you are > 48 hours or =< 48 hours out... I wrote this before based on a start and end time... [CODE]<?php $startdate = $row_product['startdate']; $enddate = $row_product['enddate']; $todays_date = date("Y-m-d"); if ($enddate <= $todays_date) { header('Location: expired.php'); } … Databases mysql |
| | Hi, please help me to know how to backup and Restore the Database. I am newer in backup topics. please help me. thanks jack |
 | I'm having some difficulty trying to figure out how to write a certain query. The very basics are that I have two relevant tables: `containers` and `items`. `containers` have the fields: ContainerID, ContainerName, and ContentType. `items` have the fields: ItemID, ItemName, and ContainerID. The easy part of the query is … |
| | I am having a hard time understanding subqueries. I am pretty sure that is what I need to accomplish my task, but not sure how to put it together. I have a unique ID field that auto-increments, so that a new entry always gets a higher number assigned to that … Databases mysql |
| | Hi, I have the following extract from a table called results. StudentID Course Percent 1005 MAM1 63 1006 PHY2 55 1006 MAM1 71 I need to produce a list of student ID's WHO take MAM1 AND PHY2. I first selected all rows where course is MAM1 OR PHY2, but then … Databases mysql |
 | Hello Guys....i am very happy to interact with u all. Im new to database. i want to display database names into a dropdown list box and at the same time if i select a particular DB it will display all the tablenames into another dropdown list box... Can any one … Databases mysql |
| | hi, i am struggling and it will prob be a simple answer but cannot figure it out at all today. checked online but no use. my to create my view i need to compare a column to a yes or no. at the moment i have tried this but no … Databases mysql |
| | Hi, anyone can help me on how to connect PHPMyAdmin with java?  |
| | Good day: I'm creating a form to write SEO into my php page head and have run into a block on the mysql_query() UPDATE function. I just cannot seem to get it to write multiple fields in a row. What I've done so far is as follows: [CODE] <? if … |
| | hi, i have a view in the database which queries about 6 tables to produce the results and works great. however i need to create a view based on the info from this view along with data from another table. when creating the view that queries the view and table … Databases mysql |
| | I was trying to backup a database with the name test. I got the error as below: ERROR 1064 (42000): You have an error in your SQL syntax; check...... This error occurred when I am executing (command line) mysql> mysqldump -u root -p password test > test.sql; How could this … Databases mysql |
| | How to use TOP(1) keyword in MS Access query. select * TOP(1) from mytable orderby mycolumn desc; this querry gives me error; Any other alternate to implement this code; Databases microsoft-access |
| | I have the following data in a field in my SQL table. I want to break up the data in this field so I can use it in reporting: Sample records: Record 1: Player: (265613) Miss Linlde M Simonds, Promo Adjusted -> 10.00, Beg. Bal -> 0.00, End Bal -> … |
| | hi, i want to add an end time in my query using my time to call column. at the moment i have a time to call which will be the start time however i want to add timetocall as endtime which is 15 mins after the timetocall column. i am … Databases mysql |
The End.