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) …

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 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 Everyone, I'm building an app that inserts data into table A, then I want a trigger to kick off before new data is inserted into table B to confirm that the value exists in column string_Value and then take the data and add it into TABLE C. Is this …

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 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 …

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 …

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 …

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 …

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 …

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'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! 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. …

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??

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 …

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?

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 …

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

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 …

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 …

   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 …

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)

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 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 …

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 …

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