7,494 Archived Topics
Remove Filter  | |
| | I have a problem with retrieving a value from a query. I know what the problem is but not sure how to solve it. Pretend I have this code: $sql = mysql_query("SELECT * FROM sometable WHERE thisvalue = '$_SESSION["value"]'"); // This will always return one result. $result = mysql_fetch_row($sql); echo … Databases mysql |
| | Hello :D I am using the twitter API to perform a search for a certain author, and storing the results in a database so that I can perfrom an action on each entry. However, there are many duplicate results that have small differences at the beginning of the string or … |
| | hello. i got a project to do using oracle pl/sql and i want to add a interface (preferably, web) so there aren't just some plain sql scripts. some text boxes, buttons, etc. so it looks nice :D. any suggestions? thank you. Databases oracle sql user-interface |
| | I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 … |
| | Hi, In order to be able to display the graph I want I have to run two queries. The first query looks like this. SELECT PercentageScore,COUNT(*) AS 'IndividualFrequency' FROM resultsets GROUP BY PercentageScore I than want to take the IndividualScores and use them again in this Query. SELECT PercentageScore,CONCAT(100*(IndividualFrequency/32),"%") AS … Databases mysql |
 | I habe table one with Col 1 (PK) Col 2 (NN) Col 3 (NN) Col 4 (NN) Col 5 (NN) Col 6 Col 7 Col 8 Then I create table two with Col 1 (PK) (AI) Col 2 Col 3 (FK) That col 3 from table two is col 1 … Databases mysql  |
 | Hi all, This is something I should know but for some reason the answer is eluding me. In a SSIS Script Task Editor, I am trying to set a package String variable called ReNameFile with the following VB.NET line using DateParts for month and year: Dts.Variables("User::ReNameFile").Value = Dts.Variables("User::fileName").Value.ToString + DatePart(DateInterval.Month, … Databases mssql |
| | I am creating a basic PM system for my website. I have just a basic table for a pm: mysql>describe PM; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | PMID | mediumint(9) | NO | PRI | NULL | auto_increment | | … Databases mysql |
 | Dear All! I want to get my columns value into rows . i am taking sum of qty of each month . like this select sum(Case when month(invoicedate) = 1 then qty else 0 end) as janQty, sum(Case when month(invoicedate) = 1 then qty else 0 end) as febQty, sum(Case … Databases mssql  |
| | |
| | Hi all, I have a csv that has over 800,000 records that gets loaded into my db via SSIS package routines. However, there are about 190 records that I do not want to be loaded into the the database. The csv comes from an external source and is unaltered at … Databases mssql  |
 | i have tblScrutiny , COLUMNS: teamid name userid now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ? Databases client-server sql |
 | Hey there, I need help with a query. The typical situation is like this: I expect, say, 1000 rows out of a query that is based, say, on lastName column. One column is, say, firstName. I know I only have like twenty unique names that occur on multiple rows. I … Databases mysql |
 | Hello Community, Is there a website that has a database like phpmyadmin that i can access from my website? Please help... Databases mysql |
| | Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) … |
| | I have the following code which is intended to supply the family and given names of people who are in the users table but not in the quiz table. Can I even do this, and this throws an error anyway? `$query = mysql_query("SELECT quiz.userGroup AS q_userGroup, quiz.userDate, users.userGroup AS u_userGroup, … Databases mysql |
| | Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) …  |
| | I have a table in a database that contains two columns username and bids.I want to select the unique and lowest value from the bids column.I tried using SELECT DISTINCT and then limiting with one,it shows the lowest value but the value is repeated a number of times in the … Databases mysql |
 | i have a view named vw_admissionform with columns familycode,Regno,studentname,class for admission form . now if i want to print a student admission form by enetring registration no "regno" in txt1.text then his siblings should also be mentioned on the admission form as requirment by client. for this am using familycode … Databases mssql |
| | Does anybody have any experience with changing an INT column to BIGINT so it will handle larger integer numbers? I have read a lot from searching the subject, but still a little leary of changing it on a live database. Would be nice if someone here has done it without … Databases mysql |
| | I have Table1 with a VARCHAR(MAX) column which contains values like 4, 1.4, 0.3, 4.25 and I'm trying to take these decimal values and populate them into another table (Table2) with a DECIMAL (18, 2) column with the following Scalar-Valued Function: Convert to Number. (The reason why the column in … Databases mssql |
| | SQL server 2012 query. declare IDList cursor for (SELECT ID FROM [dbo].[News] WHERE PublishFromDate BETWEEN cast(@fromDate as datetime) AND cast(@toDate as datetime)) order by PublishFromDate The above cursor wrks fine. But when add order by "desc" make it is not working. declare IDList cursor for (SELECT ID FROM [dbo].[News] WHERE … Databases sql  |
| | Dear all, I have a huge problem and cant figure it out how to resolve it. I have a mysql database. which has plenty of entries in the table. I have linked my search.php page with my database everything is working fine the data is being fetched and showing the … |
 | Hi all, I've problem with inserting data values from .csv file to MySQL data table. My query as follows; LOAD DATA INFILE 'C/Customers.csv' INTO TABLE pc.customers FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (CustID, RegDate, CName, CAddress, CPhone1, CPhone2, Order_OrderID) It returns error msg as follows; **Error Code: 1406. … Databases mysql |
| | Hi, I am a complete novice with MySQL but have been persevering with it for a project I am doing at work. I have created a results server to analyse and collect data I receive from quizzes I have created using QuestionWriter HTML5. I have figured out how to run … Databases mysql |
 | I have a sproc that pulls six years of records for a report. The person who set it up years ago set it up using statically defined years which ended in 2009. I am rewriting this sproc to pull the current year and five years previous. In the process of … |
| | HI, I am new to mysql and have two problems. 1. I have two tables that need to have same values from one field , if that values are not same in second table change it to value of first table Frist table is ps_product and they all need to … Databases mysql |
| | I have two tables of employee information from two different sources, one from Active Directory and one from our Billing Department. The AD table has the following columns: EmployeeID Surname Givenname Company Office. The Billing Dept table thas the following columns: EmployeeID Company Office First Last. I want to compare … |
 | I have a table with columns id,month,year,user_name,...etc in this table i want to make month,year and username unique.is it possible?IF it is ,please tell me, i required. Databases |
| | I'm new to MySQL and following a tutorial in a book to design a PHP MySQL website. Following this tutorial, I created a PHP page from which I can update entries in the MySQL database. What's strange is that only specific entries in the database will not update, while others … Databases database-design mysql php |
 | there is a table. both "age" and "DOB" columns are there. how to give a SQL command to make "AGE" a derived attribute from "DOB"? thanks Databases mssql |
| | I'm trying to use Microsoft Access to produce a contacts database for a local charity. Unfortunately I can't get my head completely round relational databases. I understand the basics but can't solve a particular problem. Can anyone help? I currently have four tables (Contact, Organisation, Children, SpecialNeeds) that need the … Databases microsoft-access |
| | Hi All, I need to optimise the below query. The below query takes 13 seconds to run on live. Kindly, suggest how I can optimise this query and how can I index the table? The query is as mentioned below:- SELECT *, a.forxmlfeed, a.lastupdated, a.mark_for_deletion, a.is_mixed_use, p.value as projtypeformixuse, b.active … Databases mysql |
| | my xampp was giving me problem so i del it and download a new one. now the problem is that all my database and table got del. however i did safe my old xampp folder before del it. if there a way i can get my sql table script from … Databases |
| | I'm not sure that my title is descriptive enough, but here is what I need to do... I had a bit of a screwup today with launching a site... Within about 10 minutes of opening the site, the members created 337 transactions (stored in trans_table) Each of those transaction should … Databases mysql |
| | let say i have two tables called user and cart user-table id username password 1 dave dave 2 dan dan cart-table id user-id item_name 1 2 car 2 2 table 3 1 laptop now i understand that bother id's will be primary key. i can also create user-id f-key bc … Databases |
 | Hi, I made a table named staff_info containing 4 column name,day,duty_start,duty_finish. This table still have no parimary key. Now assume that there are 4 staff and they do their work in each day of the week.That means in each day there work 4 staff and 1 staff work in 7 … Databases mysql |
| | Hi All, Something strange just happened. I just tried to open a package that I have been working on but nothing opens in Recent Projects on the Start Page in SSIS. The package title is also grey. I have no idea what happened or what I could have done to … Databases mssql |
| | Hi all, using these tables, Im trying to write a query that will list the students that have taken any type of class (class_level) and how many of that particular type they have taken so using a count of somekind. Tables: ATTAIN PK FK Rank_Num integer refers to RANK PK … Databases mysql  |
| | I am not a programmer just learning. I would like to know how to save the scheme info into a table ? I have this sql statement that seems to work but how do i save the info into a table Dim CmdStr As String = " SELECT TABLE_NAME FROM … Databases |
 | Hi guyz , PHP newbie and this piece is givin me a hard time please Help, have indicated the source of the error with a comment <?php ob_start(); include("dataaccess.php"); ?> <?php $strAction = "list"; $num = ""; $strTable = ""; $strkey = ""; if(!empty($_POST)) { if (trim($strTable) == "" ) … |
| | Hello all: I have the following mysql query statement: SELECT COUNT(*) as ttl_rows FROM (SELECT DISTINCT(date(timeentry)) AS day, COUNT(*) AS total FROM history where MONTH(CAST(timeentry as date)) = MONTH(NOW()) AND YEAR(CAST(timeentry as date)) = YEAR(NOW()) GROUP BY DATE_FORMAT(timeentry, '%d') ASC) as ttl_row the statement performs a search for all records … |
| | Hi all, This is going to be difficult for me to describe but I'm going to give it a go! I have tables called tblCPI, tblCPI_Staging, & tblVSeriesList. Please see the diagram.  Right now I am using SSIS 2008 to get data from Statistics Canada and load the … Databases java-swing mssql |
| | Hello, I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format: Case CASE_ORDER MANAGER CURRENT_MONTH_CASES FISCAL_YEAR_CASES ------------------------------------------------------------------------------- case_1 1 John 15 84 case_1 1 Jeff 10 80 case_2 2 John 20 90 case_2 2 Jeff …  |
 | Query to make movement of a record I have this tables User Description Item UID Name DeID Dgroup ID DeID Name 1 Jose 1 Printer 1 1 Stylus 2 James 2 Monitor 2 1 Epson 3 2 Viewsonic Transaction Details Ttype IID UserName NewUser Release 1 Jose Release 2 Jose … |
| | Hello, everyone I'm new into databases. I have an Oracle insert sequence that I need to convert to SQL server if anyone could help me to get this to work. I'm not sure if nextval is compatible with SQL Server. Here is the code: // original insert into invoice select … |
| | I'm having some trouble with selecting the Max values of three different tables in my SQL. I have 3 tables Car [CarID, Name] - Price [CarID, Price] - Group [GroupID, CarID] With these Values Car: CarID --- Name 1 ------- Car1 2 ------- Car2 3 ------- Car3 Price: CarID --- … Databases mysql |
 | Hi! I cannot figure out how to install and use a database that I am given for a project. I'm running Windows 7. Can anybody help me? Databases mysql  |
| | i have this query: $item_query = mysql_query("SELECT * FROM item"); this will always get the data from 1st row to bottom row. how can i get random data? SELECT * FROM item ORDER BY RAND() or SELECT * FROM item ORDER BY NEWID() i want the best way to get … Databases sql |
 | Hi; I have an sql database with a table called: "stardate" with default value set up with "dat" I want to modify this column default value to current date (server side) I'm trying this: Alter table my_table Modify startdate DATE DEFAULT CURRENT_TIMESTAMP; with this error: Error Code: 1067. Invalid default …  |
The End.