7,494 Archived Topics
Remove Filter  | |
 | Hello Friends, I have three table ->PatientDetails ->ParentDetails ->InsuranceDetails -Patient id is the common column in all the three tables... While saving the data in table using VB.Net there is a column in PatientDetails i.e. Insured If the patient is insured then only the values from text boxes and the … Databases mssql |
 | Hey guys. Can you have a look at my queries? I can't spot the error with my foreign key linking. As of now, the table staff has already existed: StaffID char(7) Staff_Name varchar(50) Position varchar(50) And now I'm trying to create a new table called SalesInvoice: create table SalesInvoice( SalesInvoiceID … Databases mysql |
| | List the customer number and name for all customers located in the city of Grove. Your query should ignore case. For example, a customer with the city Grove should be included as should customers whose city is GROVE, grove, GrOvE, and so on. Can someone explain if I am doing … Databases  |
 | I need a really good tutorial on how to alter MySQL databases, and to know how far you can alter a database without loosing or changing the information in the database. Thanx in advance for any help Databases mysql |
| | Hi Guys, I've been asssigned to do a pharmaceutical supplies database using Microsoft Access in 1 week time. I only think of 3 tables, that is Clinic, Supplier and Items. Can I put supplies as a table too? If yes, what will be the content of the table? If no, … Databases microsoft-access |
| | Hi, I have a query that I would like to be able to decide what fields to select based on the value of the fields in the database... Here is the query I have SELECT mem_id, company, fname, lname, addr1, addr2, city, state, zip, country FROM dc_order WHERE STATUS='W' What … Databases mysql |
| | |
| | Hi all, I created a database for my web application in VB and I'm trying to insert data in my login table but its keep giving me error i have login table which contains loginID UserId Acctype Password My PK is LoginID MyFK is User Id which connected to three … Databases mysql |
| | Ok I am not getting any other errors in php or mysql but I keep getting returned Query was empty in my table. Any help is appreciated, if anybody needs more info on the code just let me know. This is basically a multi search tool for a huge database … |
| | I have a table called Product. In the Product table we have something called ProductCode and NewProductCode. When we first built the tool we were anticipating the NewProductCodes to be coming down the pipe at a later date. So we added this column with NULL. So right now the DB … Databases mssql |
| | I have an sql table that stores English words and second table that stores meanings of those words in related maner. Here are some informations about table structures: Table1 name: Words WordID int IDENTITY(1,1) NOT NULL, //This is primaryKey Word varchar(50) NOT NULL, Table2 name: Meanings MeaningID int IDENTITY(1,1) NOT … Databases mssql |
 | hello every one , ! i have same prob as the user had in this thread [Click Here](http://www.daniweb.com/web-development/databases/ms-sql/threads/421214/remote-server-access) first i thought to post my question in that thread but then i thought it is better to open new thread . in above mentioned thread a user have prob to connect … Databases client-server mssql |
| | create trigger ins_notification after insert on transaction_detail for each row Begin insert into sell_notifications(user_id, product_id, quantity) values(new.transaction_id , new.product_id, new.quantity); End; Can any one see where's the problem? :( Databases mysql |
| | I am trying to insert values from a table to another table. The thing is I want it such that only a row in the source table that does not exist in the destination table should be inserted. I have set each table to have a column that automatically increments … Databases mssql |
| | Hi I have never done this before and am having some trouble. Could someone tell me where I am going wrong: $sql = mysql_query("UPDATE `gigs` (txnid, payment_amount, payment_status, itemid, createdtime) VALUES ( '".$data['txn_id']."' , '".$data['payment_amount']."' , '".$data['payment_status']."' , '".$data['item_number']."' , '".date("Y-m-d H:i:s")."' )WHERE (gigname)=".$data['item_number']."'" , $link); In case I have … Databases mysql |
| | i have a table with day_date and price each record is displayed as below: Day_date Price Allotment 2012-05-20 500 2 2012-05-21 500 2 2012-05-22 500 2 2012-05-23 600 4 2012-05-24 600 4 2012-05-25 500 7 2012-05-26 500 7 2012-05-27 700 2 2012-05-28 700 2 what i want to do is … |
 | I want to pass my all database from windows to ubuntu on my computer. I think passing all releated data files will be enough so I need to find the files in my windows. Do you know what isthe directory path for these files? Also is it enough to carry … |
| | Hi Colleagues I would just like to wether it is possible to link a Database to a website. my website would be one whereby members have to create accounts and put money in their accounts by transfering the funds to our Business Bank Account and then we use that reference … Databases  |
| | Good evening guys, i just want to ask if the dbname.ssmssln something is sendable and usable on other computer or not. because i created a database and my other friend wants to see it and i send the ssmssln file i just want to know if he can access it. … Databases mssql |
| | Hi in my database data stored in the below format. r{iq7, z|th{op, xzqiiu. i want to know the which type of format is this one and how to get orginal data using these texts... Thanks in adv.. .. Databases |
| | I don't have any proper experience with MySQL but need to make a query from python to a database that would return a list of vacant apartments. So, I know the number_of_beds, start_date and end_date and need to get a list of available apartments. The two MySQl tables that I … |
| | I need help with the format for single qoutes. I am using dynamic sql in an SSRS for error trapping records inserted with single qoutes during bulk imports but I cannot seem to format the actual select statement properly. SQL Sever 2005 Dev edition. Any help is great. Declare @DB …  |
| | hi, I’ve got a big problem. Could anyone give me a hand? My aim is:Remove the duplicate data, that is, the various entries of EndTime and Qos for a same ServiceID due to the repeated feedback. The rule is to only keep the records with the lowest Qos for a … Databases data-structure mysql |
 | During some recent project issues I found myself asking this very question: **Does MySQL short circuit WHERE clause statements?** After doing some research and finding that several other people and technical forums have posed this question, with several answers pertaining to be intelligent but that amount to *"i don't know"*, … |
| | I have created a simple database designed to accept domains and their associated TLD values: **CREATE TABLE domains(name VARCHAR(50) NOT NULL, PRIMARY KEY(name), tld ENUM('.com', '.net', '.info', '.org', '.co.uk', '.co', '.biz', '.info', '.de', '.me', '.nl', '.it', '.ch', '.li', '.us', '.name', '.ws'));** ...and I now need to display a form with … Databases mysql |
| | |
| | i have little problem with one algo . first i have two tables there are above one lac records in each table . table 1X structure id domain 1 google.com 2 daniweb.com 3 yahoo.com table 2X structure id domain 1 google.com 2 facebook.com 3 youtube.com now my task is to … Databases data-structure mysql php |
| | Hi, I want to know what would be your preferences in this case. I'll have a login and sign up process and want to develop its database tables. - 1:1 version needs JOIN everytime when loging in, T-SQL when signin up new user. - Single table version doesn't need two … Databases |
| | Ok, so the scenario is a database which stores customer contracts (to keep it simple) so that every time a contract is expired and renewed a new version is created in the database to reflect any changes (terms, price etc). My page needs to display a list of the latest … |
 | Hey I want to search for a text string but I dont know what table or column it is in. I just know the database that it is in. I know also that the type is a text type. Any query I can do or in MySQL Workbench? Thanks! Databases mysql |
| | Need some help, practising for an exam and need to make sure I have got this right as it has came up a number of times. Here is the information from a relational representation and I have drawn a ER diagram for this, can someone please tell me if I … Databases engineering |
| | OK, this is probably a variation on a previous question but the original question was never resolved, so I will present it on it's own to avoid confusion. I have a member data table called 'members' Primary key is 'mem_id' I have 7 different 'position' tables called position_1, position_2, position_3, … Databases mysql |
| | Two parted question really... First off, I've been trying to enable my SQL Server 2008 R2 to allow remote access so my friend can view it from his RDBMS (also SQL Server 2008). I've enabled TCP/IP, I've allowed Remote Access/Connection, I've opened TCP and UDP Ports and also added the … |
 | I need to transfer the sql server databse tables to mysql . How can i do that?.  |
| | Hey all, Some rows of a single table in a database that I administer manage to have gone missing. Not that big of a problem: I have a backup. The issue is that there has been more information added since the old data was lost, so I can't do a … Databases mysql |
| | I have a query in which I need to display some group function figures SUM COUNT etc from a joined table. I also need to select the latest version (by datetime) of a matching record from a separate table, which I can do using an ordered subquery in the join. … |
| | Good Morning, I have an ever growing member database that is currently at around 6000 (developed over the past 2 weeks), and expect it to be in the hundreds of thousands within a few more weeks... My problem is that alot of members are using a single email address for … Databases mysql |
| | Hello ppl... How to insert a list of lines to sql through php and create a id for each line example....i have flames flintones flames1 .... .... so on after submitting these lines i need a short id for these lines like (short id can be anything) 1232 1546 1578 … |
 | # EER for Rental store, to be put into Oracle for a database. # I have a databases project due monday. I'm still very new to databases so my understanding is minimal. I'm sorry if the answer to this is already on the web or somewhere on daniweb but I … Databases database-design oracle sql web-design |
| | hi everyone i have to 4 table and two different database ----------------------- first db = rotadb first table =Rota rota pRotabos ldchangetime 101 6 NULL 102 7 NULL 103 8 NULL 104 9 NULL 105 10 NULL ------- second table = Rotabos Rotabos_rowid pRotaBa 6 1 7 2 8 3 … Databases mssql |
| | This is my query SELECT DISTINCT brand, category FROM product WHERE subcategory = '$subcategory' My problem is that i want the distinct to work on both brand and category, but it is only working on brand. How could i fix this? |
| | Hello! I need to ask for a little help to build SQL query to delete some records! Table structure: `charId` int(10) DEFAULT NULL, `schameid` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(250) DEFAULT '', `skills` varchar(500) DEFAULT '', PRIMARY KEY (`schameid`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; Some times record `skills` is empty … Databases data-structure mysql |
| | #**Can anyone please tell what are the differences between Microsoft Access and traditional DBMSes (i.e. SQL Server, Oracle, Postgres, and MySQL) in reference to how they handle record-locking, rollbacks, and database updates? **# Databases microsoft-access oracle sql |
 | I have the following queries (as examples): ~~~ sql SELECT articles.* FROM articles WHERE articles.forumid IN (2,8,118,9,61,58,34,114,112,113,125,124,4,134,42,14,71,181) ORDER BY lastpost DESC LIMIT 0, 30 ~~~ ~~~ sql SELECT articles.* FROM articles WHERE articles.forumid IN (2,8,118,9,61,58,34,114,112,113,125,124,4,134,42,14,71,181) AND NOT deleted ORDER BY lastpost DESC LIMIT 0, 30 ~~~ ~~~ sql SELECT articles.*, … Databases mysql |
| | hello all! I have this SQL code that I am supposed to write and am worried that my code may be wrong. I am fairly confident that the first 2 questions are correct but after that......who knows! I have attached an ER diagram( which is acutally really messed up...but whatever) … |
| | I need to have a text field in a search form that pulls from our DB, to default to uppercase for the search. I tried to use java script in the html part of the form for that field but it bombs out after you submit the search. Here is … |
| | I am trying to change the data type of a primary key in table A from INT(11) to CHAR(11). However, this primary key is a foreign key in tables B and C. SQL is giving me an error whenever I try to change the value type of the primary key. … Databases mysql |
| | Hi all. I am not sure if this should be in PHP or MySql, but it is more relevant to MySl. I am designing a helpdesk for my department. Currently I am entering data into a form, which submits that data to a MySql table. That table is then displayed … Databases mysql |
| | I have this: [code] DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `linkacorte`(vid_pedido int(11), vid_producto int(11),vtiempo varchar(50),vid_pastelero int(11),vcorte varchar(200),vnum int(2)) begin declare campo varchar(20); DECLARE EXIT HANDLER FOR SQLSTATE '42000' SELECT 'Ha introducido un campo incorrecto. Solo se permite 1,2 o 3'; if vnum=1 then set campo='programa_corte_1'; elseif vnum=2 then set campo='programa_corte_2'; elseif … Databases mysql |
| | I have a database with structure like users: usr_id usr_fname usr_lname usr_uname usr_pass organizarion: org_id org_name org_address org_tel org_web org_email org_cat org_desc departments: dpt_id dpt_name dpt_desc sections: sec_id sec_dpt_id sec_name sec_desc designations: dsg_id dsg_sec_id dsg_name dsg_desc employee: emp_id emp_fname emp_lname emp_phone emp_email emp_addr emp_join_dt emp_salary emp_card_no emp_dsg_id emp_sft_id shifts: sft_id … Databases sql |
The End.