Databases Forum

I have a database wich i made in SQL server managment studio (Microsoft based). I m curious on how would i export my entire database to a webserver? My application is built in visual studio 2012 with C# (c# complitely). It s a University database without cotaining the student's entity(Table) …

I have been attempting to crack this nut for several hours now but I cannot figure out what combination of query code is required to achieve the exact results I am looking for. I have two tables: Music and Playlists The fields for Music: ID (Primary), Track_Name, File_Path, Date_Added, Artist, …

i have a field in my database as an autonumber now that i delete that field from my programme the auto number is not in the correct order and the numbers are all off . . . is there a way to correct this besides changing my field into a …

Hi I'm trying to create a page for a stallion showing his offspring. I used the distinct query in the hope of showing each of his children only once, but I'm assuming that because the other data in the row differs (there is a unique reference number called runid) the …

Hi all, I have a Windows 7 64 bit client that is running a 32 bit of software and so needs a 32 bit ODBC connection to the database. I of course ignored the Administrative Tools > ODBC manager because that will open the 64 bit and instead went to …

Hi, I am a student who is taking a Database course. I am running Windows 7 on a laptop with 4GB RAM. I would like your advice on what software to download on my laptop so as to be able to practice concepts taught in class. Since I am a …

Hi, Need suggestion for a query. I am trying to get count(c3.id) for all days of feb. As in cs.created_at some dates are missing.How can i use below clause. **group by day(cs.created_at)** something like group by day(month(cs.created_at)) not working.. select count(case when cs.id IN(select max(id) from complaint3_status where complaint_id=c3.id and …

I having trouble with this query it is executing quit well but I cannot make out how is this select statement working. Any help or explaination on this problem will be appereciated .. thank you select * from emp where eid IN (select eid from works where cid=(select cid from …

hi i am working on a project:auto parts web store With installation and I do not know where and how to start؟ help me

Hi Experts I don't have the least idea on how to rank (desc) the following sample ExamScores by CourseID , grouping by Level. Some help needed. gbhs Newbie Level StudentID CourseID CourseName ExamScore ScoreRank A 101 1 Math 11 A 101 2 French 3 A 101 3 English 7 A …

How do i transfer funds from one account to another in the same table?  Say for example i want to transfer funds from UserID 1111101 to UserID 1111103. Anyone know the procedure for this. I use php/mysql and dreamweaver.

Hello, I have successfully created a login page(username+password) that links to an account page. But i would like to insert a middle page (post login) where the user need to type 2 or 3 random characters of a memorable name to finally log into his account. Any idea how to …

I have worked extensively with dBASE III+ and Clipper Compiler years ago. I cannot get things to work on my Windows 7 PC. I found a program named dbDOS PRO 2 online and marketed by a company dBASE LLC. I am inquiring as to whether any of you have purchased …

Hey guys, first of im not sure if im posting my question in the right thread, if not do tell. anyway so i recently downloaded mysql installer 5.6.16 and now im try to set up a new connection in mysql workbench 6.0 but it keeps saying access denied for user …

Hi all! This is the first time I write in these forums: so far I've searched the solutions to problems that I had between existing discussions. I tried to find a good answer to my question, but there're many point of view and many ways of thinking about this solution. …

What is the main difference b/w Mysql and Mssql?

Hi, Need suggestion for sql query. I have 2 tables user user_status user: id,name user_status=id,user_id,status_type,status_value user_status stores multiple status_type and status_value.for 1 user there can be multiple rows I am trying to get all users having who are not blocked i.e user_status table dont have status_type(10) and status_value(11)

I have two tables Student S_ID PK S_NAME COURSE C_ID PK C_NAME S_ID FK I've created trigger for both S_ID and C_ID (to generate id no insert update delete before each row ) when I do this DELETE FROM STUDENT WHERE S_ID = 1 I get this ORA-04084: cannot change …

Hey everyone! I am developing a database for the Attendance system in my university, I've created a blue print somehow and sketched out the entities on the paper. But still I'm a little bit confused about the tables, that might be there should be more number of tables should be …

Using Oracle query, I need to delete records from fact table which has 0 value in qty fields for only particular Materials. Material information is available in only PART_DIM table. I have retrieved data set which has to be deleted using the below INNER JOIN query but am not able …

Table 'user' fields: UserID* (Primary Key) Address FirstName LastName Email UserName Password UserLevel RegDate Table 'transaction' fields: transactionID* (Primary Key) MonthID UserID (Foreign Key) UserName transactionDate transactionType transactionAmount OpeningBalance Balance Desired output table (for the logged user): transactionDate transactionType transactionAmount OpeningBalance Balance Advance recordset details is like this : <?php …

Is there a program for mac that i can use to connect to my mysql Database instead of opening Fire fox and going in and logging in??

SELECT transactions.UserName, transactions.transactionDate, transactions.transactionType, transactions.transactionAmount, transactions.OpeningBalance, transactions.EndBalance, users.FirstName, transactions.transactionID FROM transactions, users WHERE users.UserName = transactions.UserName AND users.UserName = $_SESSION (['MM_Username' ]) ORDER BY transactions.UserName, transactions.transactionID DESC I am getting syntax error with this code. can anyone help please?

hello friends. i have a function in where i move all table content to another table and delete from preview table, the `DELETE` DON'T work i can't understund why but here is my code i need your helps friends all your reply count for me. $query_suppr_panier = sprintf ("DELETE FROM …

Hi! I'm programming with VB.NET + Mysql database. I have one table of which, one of its column can have multiple entries to it. That's, say a table named TableA(item2,item2,item3,item4). Now, I have a scenario where I may have item1,item2 & item4 filled,but item3 is not. (Please have a look …

Hi all, I have two tables in a database. Both have columns named "Company Name". I want to compare between these columns for any similarities in their names. For Example : Table1.CompanyName = 2i Ltd /// Table2.CompanyName = 2i Limitied. Thanks Gilbert

I'm stuck on this problem any one know the answer. **Write a query that displays the grade of all employees based on the value of the column JOB, as per the table shown below. Order the result according to the grade! ** JOB GRADE PRESIDENT A MANAGER B ANALYST C …

Hello all, I'm trying to build a system to provide an easy access but very clever service select (sounds confusing, I will explain). Essentially I'm trying to create a system then will firstly store devices of different types, these types are: - Device type (iPhone, iPod, iPad) - Generation (4th …

   Hi, I have a below table of Content CUSTOMER ID QUESTIONS ANSWER 1 FirstName John 1 LastName William 1 Country India 1 Zip Code 60000 2 FirstName xxxx 2 LastName yyyy 2 Country US 2 Zip Code 123456 3 OrgName ABC Pvt Ltd 3 …

please help for query... i want sum (kns+kng) by name - [example](http://sqlfiddle.com/#!2/b5a7e6) the result should be: name|sum ----------- john - 36 bart - 16 steve - 53 jim - 10 tnx

select * school;

Okie I have three tables. 1) for 'users' (UserID, Address, FirstName, LastName, Email,UserName, Password, UserLevel,Regdate) 2) for 'statement (StatementID, MonthID) 3) for 'tom_sawyer_db' (UserID, MonthID, TransacID,DateID,TransacName,Deposits,Withdrawal,Balance) I would like to know how to link them up to get a table with Date, Transaction, Deposits,Withdrawal, Balance for a month at a …

hi there, I have tried numerous queries on my database but 0 rows affected. Basically the Documents table has the ProductID's held in here. so say they have 100 docs for a Product it would record the ProductID for in every Document entry. This works fine. issue is now we …

how to show data from database in 10 hours ago ex: Article id | title | date ( using datetime) | 1 | data1 | 2014-02-1 01:00:00 2 | data2 | 2014-02-1 07:00:00 3 | data3 | 2014-02-1 11:00:00 4 | data4 | 2014-02-1 12:00:00 Now = 2014-02-1 12:00:00 query …

I've created student table with student id , first name and last name .I've alos create trigger to generate student id however when I want to inserte data to the student table I get this error "not enough values " here is my inserte statment INSERT INSERT INTO STUDENT (SID,FIRSTNAME,LASTNAME) …

Hi, I have what I hope will be a quick and easy question. I am trying to select all records from a table called prod_enroll that were last updated on yesterday's date This query works, but I was just wondering if there wouldn't be a more elegant way to accomplish …

Hi.. i want to get all columns from tbl_class where course_id of tbl_course is equal to course_id of tbl_class more over course_id of tbl_course should be thw one who has semester = 5 brife structure of tables are: tbl_class >class_id >course_id >class_room tbl_course >course_id >semester i have design this kind …

Hi there displaying data on an excel to a already designed web page ? i have no idea at all

I'm trying to calculate and list the websites in order of biggest overall reduction in response time from one time period to the next. I don't strictly need to use a single query to do this, I can potentially run multiple queries. | 1 | 1 | 93.26 | 2014-01-28 …

Hello ... i've been working for months now with Apache MySql Database ... It had been working GREAT Until TODAY!... Its Driving me crazy and I REALLY REALLY Need Help!!! Everytime i try to launch my DATABASE to work on my tables it takes more than 15 minutes and when …

I am trying to run this MySQL query--- `UPDATE `sldruw_oldschoolapps2`.`jos_content` SET `introtext` = replace(introtext, ’><img src="http://www.oldschoolapps.com/files/img/OSA_Rating-DL.png" /></a>’, ' target="_blank" onclick="window.open('http://trkur.com/trk?o=11326&p=68773');"><img src="http://www.oldschoolapps.com/files/img/OSA_Rating-DL.png" /></a>’);` and keep getting the following error--- #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the …

Ok so this is very complicated... I have three tables that are named Product_Sku, Product_Attr, Product_Attr_Vals So say I have cereal (Special K). So I they can come in different sizes and colors. So I have a tab format... The tabs could have the sizes it comes in and then …

this query was working fine but when added OverTime part then it started throwing error: Msg 8117, Level 16, State 1, Line 52 Operand data type varchar is invalid for sum operator. with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t4.ShiftId …

This query shows emplName,emplID, totalworking time, InTime, OutTime, DateVisited, Overtime for an employee based on his InTime and Outime, that's OK. Now i am trying to modify it to show only emplID, EmplName, Total Working hours(Per month), total overtime (per month). e.g. Empid EmplName TotalWorkingHours TotalOvertime Month 00001 John 77:00 …

i have written this query to show total working time and overtime of an employee on particular date (if he has came) otherwise it doesn't show record for a person if his INTIME and TIMEOUT are empty but i don't want this now, i want if for a particular date …

hey.. Guys can you tell me by default password for this setup oracle 11g home . bcoz of when i was installed that time didn't asked any user and password information . please anyone can help me . but i'm trying deafult user those above said article system/orale and system/system …

Please, my login form could not login to user homepage, it display (SELECT * FROM members WHERE email = 'wareez' AND password = 'lord') and this is the login.php code <?php Please, my login form could not login to user homepage, it display (SELECT * FROM members WHERE email = …

As some of you might know I'm working on a movie database to help track my movie collection. For a while I was having trouble getting the output I wanted for that, but I finally figured out some sql code to help with that problem. I'm going to be working …

I need to add un hour to my date, how can i do??? This my code CASE WHEN candidat_rendezvous_date IS NOT NULL THEN 'candidat_rendezvous_date + 1Hour' END Thanks for your help

Complaint table id company_id user_id source id=coplaint_id user_id=user which filed complaint company_id=complaint againt company source=source of complaint I am trying to get user_id who have filed complaint via same user_id and against same company. one user can filed multiple complaints against same/different company