7,494 Archived Topics
Remove Filter  | |
| | 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 |
| | Hello everybody!!! I just want to ask some internet sites where I can download Oracle server like mysql and sql server because I want to learn about how to use it. I have already knowledge about sql and mysql and how to access them using vb.net, and for more improvement …  |
| | hi all, i had 4 text boxes. 1.Emp_id 2.Emp_Name 3.Mobile No 4.Blood group and a search Button. so when i fill any textbox or all the textboxes then it should display the required data. For example: If i want some person details. i know only his name.Then if i enter … Databases mysql |
| | hi all, i am trying a query but i am not getting the result properly.. Is there any error in my query.. [CODE]$query ="select Emp_Id,First_Name,Last_Name,Gender,Mobile_No,Email_Id,Blood_Group from Employee where"; if($empid!='') { $query1=$query . " Emp_Id like '".$empid."%' and"; // echo $query1; } if($empname!='') { $query1=$query . " First_Name like '%".$empname."%' and"; … Databases mysql |
| | Hello I want to do that after submitting form it will insert in a table. the table has auto increment field. name of the field is ID. Now how can I get the ID number of that inserted data's ID number. for example I have a table which field are … Databases mysql |
| | Hi. I want to have a query as below. [CODE] $sql = "SELECT amount FROM payment WHERE id = '$a'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $amount = $row['amount']; [/CODE] The value for $a variable is getting from the selection on drop down list. For example, the user select id=11, … Databases mysql |
| | I have a table like below format. [CODE] CREATE TABLE Customer ( number VARCHAR(40) NOT NULL, --col 1 name VARCHAR(100) NOT NULL, --col 2 ssn VARCHAR(50) NOT NULL, --col 3 age INTEGER NOT NULL, --col 4 ) [/CODE] I want to add a new column in the table. If I … Databases mssql  |
| | Hello I had a question about MS-SQL. I am trying to write a query which will select a group of values from several tables (prodId, Amount, BreakLevel, TotQuantity, Price) There are several amounts associated with different break levels. i.e. a break level of 15 might get an amount of .10, …  |
| | According to Codd's Tweleve rules which are considered as a basics of the relational database system, which one of the following three systems: Oracle, DB2 and SQL server is most applied and relational than the others? Please give me your opinion and why.  |
| | 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?  |
| | Hi, I'm fairly new to database design. I am working on a personal project and I had a question about general design structure. I am trying to design a database that I want to create for a collectible card game. The idea is that each different type of card will … Databases database-design |
| | I have a Subjects table with a field Prerequisites, which contains data similar to the Subject IDs in the same table. So for example a subject4 may have the prerequisites subject2 and subject3. The contents of the Prerequisite field are delimited by ORs and ANDs, meaning if there are more … Databases microsoft-access |
| | Hello I want a query to get my result I have two tables: 1) articles 2) comments 1) This is my articles table: [code] -------------------------------------- id | article_title | article_body | -------------------------------------- 1 | dummy article | some body | 2 | article2 | body2 | 3 | article3 | … Databases mysql |
| | 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 … |
| | I'm currently working on a data model for "Project Allocation System" and I have done most of the ER-to-SQL transformations, but I'm struggling to deal with the two ternary relationships that exist in my model. So far, I have the following: [B]1 Mapping entities and their attributes[/B] [B]Module_schema[/B] = (module_ID*: … Databases |
| | Hi, I am looking to create a Jobs Board Database which will work with PHP 5 and PayPal, but I am having trouble figuring out the relationships: I know I might have a table for Company details and another one for Job Details but what do I do with regard … Databases mysql |
| | Hi I have a dynamic page that doesnt validate because I have special characters such as "&" in the data. I was wondering if I should do a find and replace of all those ampersand signs and replace them with the safe "&" code. Thanks for any help or suggestions … Databases mysql |
| | 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 use mysqldump.exe (Size 2.281 Kb, date 22-2-2010, time 18:06) I use MySQL Workbench 5.2 OSS Revision 6091 I have database [COLOR="Red"]TEST [/COLOR]with table [COLOR="red"]NAW[/COLOR] I use the i use the following statement to export table [COLOR="red"]NAW[/COLOR] [CODE] C:\mysqldump.exe --user=XXX --password=XXX --host=localhost test naw > c:\MybackupNAW.SQL [/CODE] This export file … Databases mysql |
| | Hello everyone, I have a little bit problem here.I have installed PHP version 4.4.1 and it's working well. I want to connect PHP with MySQl . I have also installed MySQL and it installed successfully. Inorder to configure PHP to work with Mysql, I did the following changes in the … Databases apache client-server mysql php sql windows-server |
 | Not sure if this actually qualifies for this forum so please by all means move this topic to the appropriate place if it isn't. I'm writing a C# Windows Application (not a web app) and it uses either an SQL or Access database to store its data for multiple network … Databases app-store database-design mssql sql web-design web-server  |
| | 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 |
| | |
| | Hi Friends I have a challenging task in SQL (Oracle). Let me know if you have any answer. I have 2 tables. 1. Dept 2. Employee Dept [B]Dept_No Dept_Name[/B] 10 Admin 20 Data Warehousing 30 HR Employee [B]Employee_No Employee_Name [/B]Dept_No[/B] E01 Sangeetha 10 E02 Michael 10 E07 Immanuel 20 E11 …  |
| | hi i am using oracle 9i and now a days i am learning sql. due to some problems i have to change my system and i will install oracle 9i in my new system, but problem is that after installing i need all that old tables that i have created … |
| | 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 |
| | Hi all, Fairly new at SQL, and running into the following problem. I am trying to create a query to count the number of unique fields in a column and display, but can't seem to get it right. For example, each day there are x number of entries from y … |
| | Hi There, I am using a sql query to show a row to users. The Problem is in the database there are single as well as duplicate records. My 1st code is – Works good if user has no duplicate records; [CODE] SELECT contacts.forenames, contacts.surname, addresses.postcode, contacts.contact_number FROM contacts LEFT … |
| | |
| | hello guys i have a question bout my sql. I create a system in vb.net using my sql database but the problem when i create a report using microsoft report viewer it does not detect mysql database whether i create a new connection..what is the problem??.. |
| | For an ER diagram, I have to: 1. Produce a set of relations. Indicate all primary and foreign keys. 2. For each relation give the minimal basis for all FDs on the relation, and state whether the relation is in 3NF or BCNF and why. I am fine with doing … |
| | Hi I have table consist of [B]ID,name,father & mother[/B]. Id is uniq. Now I want that when anyone enter id, it will give [B]name,father and mother[/B]. what is the easy and small way or script. please help me me Databases mysql |
| | I would like to calculated an expected profit. I have got the following table: OrderID productID regionID available_volume price sales_per_day What I would like to have: A table grouped by productID and regionID each with the (expected) profit per product and region. Profit is calculated by price*expected_sales with following conditions: … Databases mysql |
| | Hi all, I am trying to get a SQL Server statement to work for a class I am taking on MS SQL Server. Here is what I am supposed to do; 1) Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record … |
| | I want to create a social website which people can share their photos with friends and I don’t know if it is correct or there is something wrong with it. I would be very grateful if someone could have a look at it and give me some feedback on it. … Databases database-design social-media web-design |
| | HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack Databases client-server microsoft-office mysql sql |
| | Hello. To start off I am pretty bad at MySQL and PHP. I want to set something up that people can enter their cell phone numbers and it would be added to a server. Then I could go and send a message out to all of these numbers. I want … Databases client-server mysql php |
 | Hi! I'm looking for a way to search and replace certain strings in a database table I have. Those are the commands I execute now from within phpmyadmin: [CODE]UPDATE `feeds` SET `title` = REPLACE(`title`,"ă","a") UPDATE `feeds` SET `title` = REPLACE(`title`,"î","i") UPDATE `feeds` SET `title` = REPLACE(`title`,"ÅŸ","s") UPDATE `feeds` SET `title` … Databases mysql |
| | Hi all, I'm currently working on a holidays database where i need to retrieve the latest offers and display them. I've managed to get that working fine. However what i want to be able to do is kinda like a SELECT DISTINCT to only show 1 destination, and have the … |
| | Hi ok I have a table: "rlbTerms" that contains basically a list of terms and their definitions. I create a page with a query that returns all the terms and definitions in a table layout and are order by terms ASC. What I want is a way to create anchor … Databases mysql |
| | Hi There, I do have 2 tables; Contacts table, Communications table Contacts table rows are; contact_number, forename, surname Communications table rows are; contact_number, number (number is used for emails) What I have is a little form to check/find out the contact number by filling; surname forename and email. Once they … |
| | Hi All, I am working on a booking system for vacation rental properties. I have two (simplified) tables properties and propertyAvailability: properties:- propID propName propertyAvailability:- propID dayOfTheYear availabilityStatus Rather than use dates for the bookings I convert everything to dayOfTheYear (using ColdFusion) and each DOTY for each property has a … Databases coldfusion mysql sql |
| | Hey guys, I have a table called 'rank' which contains information about music - more definitively, it stores peoples votes (1 to 5) on a particular song. The table layout is as follows: id | songid | userid | blurb | useful | useless | thetime I have written a … Databases mysql |
| | There is an a problem on declaring variables on MYSQL stored procedure.The code I used I used is shown below. [CODE]DELIMITER $$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ PROCEDURE `emp`.`third_SP`() /*LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES … |
| | Hi I am using the following query: [CODE]"SELECT * FROM members WHERE name LIKE '$searchKey%';"[/CODE] Where $searchKey is a variable that contains the string to be searched. The problem is that the code only searches until it has found a space and even if characters after space match the value, … Databases mysql |
The End.