7,494 Archived Topics
Remove Filter  | |
| | hi all, I need one help.i want to give OCA exam the name and number of exam is "1Z0-047 Oracle Database SQL Expert" these is for "10g".But i don't have any material for that.please send me the material for that. only i know the exam topics which i am send … Databases data-structure oracle  |
 | 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 … |
| | According to my professor's program, it says that the snippet of code that i wrote has a syntax or runtime error. This is my code: #S3 display fruit name, inventory quantity sum, price and sum quantity*price displayed as value for each row in fruit SELECT name, sum(quantity), price, price * …  |
| | I wrote 2 queries and I am not sure what is wrong with them. Can someone tell me what to do in order to fix them? #T8 select sum( quantity ) * (select price from fruit where name like 'apple') from inventory where fruitID=(select fruitID from fruit where name like … |
 | I am trying to get a total of all the records for playerid from table1, table2 and table3 by playername. There are 4 tables, table-1, table-2, table-3, and players. I am not great with queries and I expect somebody here can instantly see where I am going wrong. This is … Databases mysql |
| | These are my queries for an assignment. It says that I made a mistake on query 8 and 9... problem is that I don't see any mistakes? Can someone tell me what is wrong? #T1 SELECT * FROM `inventory`; #T2 SELECT fruitID, sum( quantity ) FROM `inventory` group BY fruitID; … |
 | Hi All Daniweb PHP Group, I have a big favor to ask (well for me this is big lol). I have 3 databases first (LOCAL),(AIMIS),(ERM). Here's the table (namely account_manager) of LOCAL.  and Here's the table (namely customer_call) of AIMIS.  and Here's the table (namely quotations_header) … |
 | Hello I have two tables: Students and Professors (both with usual info like name, last name, email... etc) I also need to have info about their knowledge of foreign languages, and I guess that should be a third table (languages for example) it should look like: Language_id, Language, Speaking, Writing, … Databases sql |
 | dear all i have tables(aztrd) it conatis invoice deatils like itm_code , date,loc_cd ..... ect - in each in invoice they are itmes (itm_cd) from loc_cd "1" or loc_cd "2" and some invocies has items from loc_cd "1" only or loc_cd "2" only i try this query to get only … Databases mssql |
| | Hello all, I need to make a simple database, and then some windows application (possibly C#) connecting to it... but first... First I need to design and model a good and functional database, right? So I am stuck in it now :) and please help if you can. I dont … Databases database-design |
| | i need database for english words and their meanings so i can create an application for English Dictionary. do you have any database for such requirments ? if you don't have then you can recommend me a link where i can find it . I think that's the important part … Databases  |
 | CREATE TABLE Artist ( A_id INT NOT NULL, A_song varchar(100), A_name varchar(100), PRIMARY KEY(A_id,A_song) ); CREATE TABLE Instrument ( I_id int NOT NULL, I_keys varchar(100), I_name varchar(100), PRIMARY KEY(I_id,I_name), a_id int NOT NULL, FOREIGN KEY (a_id) references Artist(A_id) ); CREATE TABLE Song ( S_id int NOT NULL PRIMARY KEY, S_vocalist … Databases mysql |
| | seems like a simple issue but i can't wrap my head around this. i need to get all rows where date is today BUT a new day starts not at 00:00:00 but at 02:00:00 the results are displayed all the time (page is refreshed every few minutes) so the current … Databases mysql |
| | 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 have these tables and I want to show the percantege of customer with deliverd to pending and the in another sql statment show the number of customer with deliverd to pending I'm not sure how to calulate these two. I tried the build query on APEX , but it … 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 |
| | I have three table **customer** c_id NUMBER c_name VARCHAR2 c_address VARCHAR2 **order** o_id NUMBER fk_c_id NUMBER o_name VARCHAR2 o_price NUMBER o_orderDate DATE **order_history** oh_id fk_o_id fk_c_id oh_status VARCHAR2 oh_dateChanged DATE When the customer make an order it will show default status as pending then if the status change to approve … Databases mysql |
 | 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 |
| | Ok so I have three tables Customers,Invoices,and Delivery with the fields: Customers: CustomerID Address ........ Orders: OrderID DeliveryID ....... Delivery: DeliveryID DeliveryToAddress ...... So what I want to do is update my delivery table for the DeliveryToAddress for when the customers address changes within the customers tables. To get the … |
| | 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 All, I have a problem with my Microsoft SQL Server. When I execute my queries, it did not appear. The screen says, "Save Result as". I already unchecked the "Prevent saving from changes...." from >>Tools>>Options>>Designers>>Tables and Database Designers but it keeps in appearing. Please help! Thanks in advance :) |
| | 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 |
 | I have a query that used union all.. and produces a table like this: `+-------------+------------------------+-----------+--------------+ | Type | Name | IDNum | Warnings | +-------------+------------------------+-----------+--------------+ | M | sample | 2013-1 | 4 | | L | sample | 2013-1 | 2 | +-------------+------------------------+-----------+--------------+` now i made a while loop … Databases mysql |
| | i wish to capture user input regarding workhistory on one form - how do I catch the same infor structure, ie. company name, position, duration, job description, for 3-4 companies, dynamically in PHP and write it to mySQL. I need direction on how to do this re...form structure and table … Databases mysql |
| | Hi! I have in my database few tables and each table have a column with dates of inserting records. I don't know how to go through the database, through all tables, in chronological order, from the first inserted record until the last, can anyone help? tnx! Databases mysql  |
| | Hi! Can anyone know the result of this query: SELECT COALESCE(MAX(ID),0) + 1 FROM Table123 |
| | Hi friends, I am having a doubt in insertion of data create table table1(name varchar(10)) In this table, when i insert the following record manually, it produces me an error that it cannot insert. insert into table1 values('asdfghjklqwe') But when I try to insert it with the procedure, it trims … Databases mssql  |
| | 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 I have an issue to update data between two table. I want to update data from one table to another using Store procedure. My code is SELECT NoMonth,ACC_P,StartDate FROM dbo.tbl_Accural_Basic UPDATE WEB_tbl_Accural_Audit SET NoMonth=nomonth,ACC_P=ACC_P, StartDate=Startdate But Nothing happend. It will show the data in select command Pls help me … Databases mssql |
| | Hi all, i am passing comma separated values to my stored procedure. something like below: @id=1,2,3,4 @firstname='a','b','c','d' now if i write select statement then i want single data from @id and @firstname. something like below: id firstname 1 a 2 b 3 c 4 d thanks Databases mssql |
| | i have a problem in choosing data type for this column in SQL..can anybody help me??? result (tournament_id*, player_id*, round) i've done the first 2 columns, i'm confused about the data type of round=='...i wondered if it was cstring or text or numeric here's my code : tournament_id int, player_id … |
| | Hi friends Has anyone done a db for a multi-level compensation structure? I'm talking about a company that is MLM or a multi-level marketing network. Where distributors sign up under other distributors and the "downline" can go down many levels(but limited levels!). I need a sample MLM structure.Could anybody help … Databases  |
| | Hi, I need data table desgin for transaction table. I want transaction history for particular client having unique client_id but many having many transaction id's. transactions relate to credit, debit, transactor name and date. Regards Kaustubh Databases mssql  |
| | 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 … |
| | I have a query that starts like this... SELECT COUNT(A.FISH), COUNT(B.MEAT), COUNT(C.FRUIT).... now my problem is this, how could I count when I need to consider an expiration date for each column,...and the expiration dates varies for each column... Can I do this in one query? Or is there any … Databases mathematics mysql |
| | I have a database with a table, jobs and i have written this query to get information from this table. But i am getting no results with this data and i have no idea why? SELECT startDateTime, endDateTime FROM jobs WHERE startDateTime BETWEEN '19/11/2013' AND '20/11/2013' Database Structure: 1 jobId … Databases data-structure mysql sql |
| | Hi guys, I have a table called "goodsbalance" qtyBalanceID | k8goodsID | goodsIn | goodsOut | qtyBalance ---------------------------------------------------------------------------- Can I do some calculation like this? $query_recgoodsbalance = "SELECT * FROM goodsbalance"; $rs_recgoodsbalance = mysql_query($query_recgoodsbalance); $rec_goodsbalance = mysql_num_rows($rs_recgoodsbalance); while (($reck9goodsout = mysql_fetch_array($rs_recgoodsbalance) )!= false) { $query_UgoodsOut = $rec_goodsbalance['goodsOut'] - $_POST['k9goodsQty']; $rs_UgoodsOut … Databases mysql |
| | We have ERP application that store the data to ORACLE database and also we have a lot of another web applications that use the ERP database. We got the performance issues when ERP and another application use the same database. We are planning to do mirroring of oracle database into … |
| | Is it required to use index when the MySQL table has only 100 rows? Justify your answer. Databases mysql |
| | So I have the following MySQL query, which works fine: select year(created_at) as year, month(created_at) as month, day(created_at) as day, item_sdb_id, price_per_unit from (select l.item_sdb_id, l.list_price / l.quantity as price_per_unit, l.created_at from listings as l inner join purchases as p on l.purchase_id = p.id where l.item_sdb_id in (12345) and p.created_at … Databases mathematics mysql |
| | I am trying to copy data from one database table to another. Below is the MySQL syntax I am working with: $array = []; $q1 = DB::inst()->select( "stu_term" ); foreach($q1 as $r1) { $array[] = $r1; } $bind = [ ":stuID" => $r1['stuID'],"termID" => $r1['termID'],":level" => $r1['level'] ]; $q3 = … Databases mysql |
| | Am looking for a way to get the maximum value of an integer data type in a function. Since FB doesn't have an unsigned type, casting from -1 doesn't work. Nor can I find any built-in constant or function to get it. Any other ideas? (Am not looking to hardcode … Databases |
The End.