2,403 Solved Topics
Remove Filter  | |
| | 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 … Databases mysql |
 | 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) … Databases android visual-studio |
| | 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 … |
 | 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 … Databases  |
| | 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 … Databases mssql |
| | 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 … Databases first-post mysql |
 | 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 … Databases  |
| | 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 … |
 | 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 … Databases mysql |
| | 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 … Databases mysql |
 | 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 … |
| | 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 Databases mathematics mysql sql |
| | 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 … Databases mysql |
| | 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 … Databases |
| | 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 … Databases oracle |
 | 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 Databases mssql |
| | A Database Error Occurred Unable to connect to your database server using the provided settings. the above error am getting when i load the localhost and my database.php and db_driver codings are given below $db['default']['hostname'] = "etc.com"; $db['default']['username'] = "etc"; $db['default']['password'] = "etc@etc"; $db['default']['database'] = "visiting_link"; $db['default']['dbdriver'] = "mysql"; $db['default']['dbprefix'] … Databases mysql php-codeigniter |
| | Hi Experts, I have to Pad some numbers that have decimal points and I have done it successfully as follows: SELECT case when len(myValue)=1 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(5)), 2) when len(myValue)=2 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(4)), 2) when len(myValue)=3 then RIGHT('000' + CAST(CAST(myValue … |
 | Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. … |
| | HI Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a row in tab2. tab 1 has 360000 rows tab 2 has 477 rows The update query runs for ages and … Databases mysql  |
| | I have a question that may be a bit complicated, so let me set it up with what I am working with first. I am dealing with a 3 x 10 matrix, which I’m sure you realize means on level 1 there are 3 potential positions, and on level 2 … Databases  |
| | |
| | Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks  |
| | hi..please help.. i have 2 tables tblStudents and tblGrades. in tblStudents, all details of students and in tblGrades, grades of the students. column "StudId" is their only common column.. in tblStudents: StudId LastName FirstName in tblGrades: columns are: StudId SubjectCode Grade what i want to achieve is to query on … Databases mysql |
| | hi.please help me with mysql query. i have a table tblGrades with fields ID, Subject, Remarks. how can i create a stored procedure that will display the students that have subjects(user input) and Remarks='Passed'? the Subjects will depend on the user, therefore it may be one or two or three … Databases mysql |
| | I have following quary example. SELECT t1.TeamID, MemberList = substring((SELECT ( ', ' + FirstName ) FROM TeamInfo t2 WHERE t1.TeamID = t2.TeamID ORDER BY TeamID, FirstName FOR XML PATH( '' ) ), 3, 1000 )FROM TeamInfo t1 GROUP BY TeamID Its giving error "Incorrect syntax near the keyword 'FOR'." … |
| | I wrote a sample program in notepad begin dbms_output.put_line('welcome'); end; / and saved it as p1.sql i opened sql prompt and gave @p1 it didnt worked??? i tried exec p1; still not working?? how to execute a pl/sql program???pls help |
 | I have been researching this as I am getting the distinct feeling I will have to transition my code to this soon, eventually. From your experience, can someone provide a brief overview of the benefits of MySQLi and why I should transition. Is it even necessary? I'm not sure. Any … Databases mysql |
| | Hi I want to do a silent install of sql express 2008 (free edition) In my configuration file, how can I set the default language to British English and date format to "dd/MM/yyyy". Thanks for your help SQL Newbie |
| | Hi, I am trying to merge below two queries in a single query such that company_id,company_name,noOfOpenTickets,noOf PendingTickets Need suggestions?? No Of open Tickets: select c.company_id, (select company_name from company where id=company_id) as companyName,count(s.complaint_id) as noOfOpenTickets from complaint3 c ,complaint3_status s where s.id =(select max(d.id) from complaint3_status d where d.complaint_id =c.id … Databases mysql |
| | Hi Guys I have a "StudentNames" column in an sql table. Each student in the table has atleast two names all in one column. Assume that the following as studentNames. StudentNames ------------- John Smith Joseph Smitter Johan Smittin How can I use the LIKE statement to select students with same … Databases mssql |
 | So I am reading a book from Pratt and it is called A Guide to MySQL. Apparently the book stinks and I am trying to answer some of the questions from the book. #fc1 show tables in the current selected database # for your current database it should be two … |
 | I was wondering if you could help me with a current issue I am having whilst developing an ER diagram. The problem I am having is with identifying the correct Entities. Question:- students can fill registration form online (of 8th,9th and 10th only) they can give online exam. any user … Databases  |
 | I'm having a brain fart and for some reason it's not coming to me how to do this right now. I'm trying to tally up a table, and store the results in a different table. Like so user score ---- ----- 1 4 1 5 1 2 2 1 2 … Databases mysql |
| | I need help with the queries I wrote and I don't understand what is wrong with them? Can someone help me correct them? #11 SELECT BOOK_CODE, TITLE, PUBLISHER.PUBLISHER_CODE, PUBLISHER_NAME FROM BOOK, PUBLISHER WHERE PUBLISHER.PUBLISHER_CODE = BOOK.PUBLISHER_CODE ORDER BY PUBLISHER_NAME; #12 SELECT BOOK_CODE, TITLE, PRICE FROM BOOK, PUBLISHER WHERE PUBLISHER_NAME = … Databases mysql  |
| | hi can anyone see why this is not working please ? `mysqli_query($con,"UPDATE goodship SET brick=brick+1 WHERE id= $_COOKIE['id']");` all i am trying to do is add one to the sessions id col brick, thanks. Databases mysql  |
| | Hi there. I was kinda researching on how I could store data at best (in my opinion). I came on "CSV" files. Which looked great to use. I found out there are two functions that can operate file. So I keep Googling on how to use the syntax and how … |
| | Hi.I'm Nizam. Sorry if the question I asked is unclear. I have the table as below **Classroom** - id - capacity - code - ...... **Schedule** - id - group_id - classroom_id - ...... The schedule will be filled with the group and classroom. My problem now is how can … Databases mysql  |
 | I have one table that I want to separate them into two to normalize the data. I want a opinion of the best way of doing it. My table has lots of columns and one of them I was storing Varchar values separated by comma, for instance: John, Mary, Joseph … Databases mysql  |
 | Having problem with looging in my server. Before it runs smoothly. While learning this system, I came accross the idea of exploring the contents of Microsoft SQL Server in Program Files. I found some exe files inside and tried to run them with the curiosity of what are those for, … Databases client-server sql web-browser |
 | Hey all, I have a query like this one: `select * from topic order by topic_view_time limit 10` the topic table has a PK topic_id and some other varchar fields. It also has topic_view_time which is int and has the value of time() (in php) updated whenever a user view … Databases mysql |
 | Hi , I am working on a list : Name Town Street House ID_Number Marco Valletta Triq l-Ajkla 10, Fl 1 53290M Mary Valletta Triq l-Ajkla 10, Fl 1 4748M Victor Valletta Triq l-Ajkla 10, Fl 4 37867M Krystle Valletta Triq l-Ajkla 14, Fl 1 52467M Mariella Valletta Triq l-Ajkla … Databases sql |
| | I am trying to create stored procedure which will insert one row in the first table and identity of inserted row in other two tables. For some reason I am receiving error "Procedure or function expects parameter '@id', which was not supplied.". My code is as follows: ALTER PROCEDURE InsertProf … Databases mssql |
 | Hi there I got a little problem with a small bit of code am unfamiliar with orcale database the scripts I have were done by a other person for version 6/7 am currently using version 8i for compatibley reasons with the server software I am currently setting up. the script … Databases oracle |
| | Hey all, I would like to know why when having big data in mysql table, executing a query for the first time takes 0.1.. sec, but if executing again the same query later, it will take only 0.0006 sec ? Exemple: SELECT name FROM `users` where id > 310000 limit … |
| | Hi Just asking for a better solution for my approach in getting sql result with different multiple conditions based on comboboxes. I have a 4 comboboxes, for Branch, Type, Status and other info. User can select conditions from this comboboxes. The default value is "All", meaning no specific condition at … |
 | I have some problem about uploading and database. I upload the file (abc.jpg) and the file already insert to the folder name (uploads). But when I check in database (php), the file did not enter. Here is my code. Hope anyone can help me.Thank you. <? include "conn.php";?> <?php error_reporting(0); … Databases file-system html-css mysql |
| | Hi! Can anyone know the result of this query: SELECT COALESCE(MAX(ID),0) + 1 FROM Table123 |
| | Hi, Im having a hard time figuring this maybe a simple query. This is my first time to use sql compact edition. How can I query a select statement inside a select statement which tables are not related at all. What i need to accomplish is to insert a logo … Databases mssql sql visual-studio  |
| | Hi Everyone, Thank you for the time you spend to look at the post. I am required to retrieve report based on a date field in the table. the date field filtering must be from the previous month of the 6th till this month of the 5th. For example, today … |
The End.