2,403 Solved Topics
Remove Filter  | |
| | Hi, in oracle 10g express, I logged in system/HR. I typed: CREATE USER SHIPU IDENTIFIED BY SHIPU1. click Run. Then I typed, GRANT SELECT, INSERT, UPDATE ON EMPLOYEES TO SHIPU WITH GRANT OPTION click Run. I logged out and logged back in as SHIPU/SHIPU1 I typed SELECT * FROM EMPLOYEES. … Databases oracle |
| | Hello all, I have a database which has 10 tables. Each table has an id, a title and a date. Now i'm having difficulty finding the best way to extract the [B]latest date[/B] from each unique table, while also doing a count(*) attribute to show how many rows I have … Databases mysql |
| | [B]Hi... I have a table named empl with following fields(eid,ename,esal) I had inserted the following records to empl table 1 Govind Raj 20000 2 GovindRaj 600000 3 Govindraj 10000 4 govindraj 50000 5 Govind.Raj 50000 6 Govind-Raj 20000 7 Govind_raj 2000 8 Govind.raj.3000 9 govind,raj. 4000 10 Govind'raj 6000 11 … Databases mysql |
| | Hi everyone, Thanks for viewing this post. I have a question about SQL. May i know how to remove rows that have NULL value in one of the colums. SELECT name, grade, age FROM education If let say grade 1 of the rows is NULL, how do i remove that … Databases mssql |
| | Can anybody plz help me.. i need to find all the users who are grater than 10 days old. table name users ,fild contain with registration dates.to store date i used DateTime.Today with C#.Can any body give me a sql query to slow this |
| | Hey guys.. could someone please help me with.. What wrong with this: [CODE] echo "<td width='25%'><img src='images/Lock.png' title='" . $row['username'] . "' - '" . $row['password'] . "'></td>";[/CODE] i Get only the username.. Cheers, Sagive |
| | Hi everyone! So I'm finishing a shopping cart, and there is just one thing that annoys me - the currency is on the left side. Its like this: $10, but I want it to be like this: 10$. Is there any way that I can do this? Thanks! Databases mysql |
| | I design an academic information registration system. I have 3 types of users namely teachers, students and operators. As all these have some properties in common I thought of designing it in the following manner. teacher([U]id[/U], profile_id) student([U]id[/U], profile_id) operator([U]id[/U], profile_id) profile([U]id[/U], first_name, last_name, tel) teacher_specific([U]teacher_id[/U], academic_qual) - teacher_specific has … Databases web-design |
| | Hi, I have to design an ERD based on these order and delivery note samples. Order sample -Order ID (random) -Customer's name -Customer's address -Date of order -table (list of item ordered) ID (ordered number, random) | Item's name | Description | Unit | Quantity Delivery note sample -Delivery note … Databases |
| | I have two tables, Episodes and Seizures, with their respective Forms. On Episodes, I have a button the user clicks to open the seizure Form and its internal working is below. The problem is when the form is opened and filtered by parent form, the seizure form instead of filtering … Databases microsoft-access |
 | This question seems to always have 2 sides to it. If I make a [COLOR="Red"]register.php[/COLOR] with the registration form, should I have it submit to [COLOR="green"]processreg.php[/COLOR] or should it just process all on the same page? Same thing for login. I have read that it may e more secure to … Databases mysql |
| | Alright, so I am embarking on a fairly large project that is complete with user profiles. My question is, what's the fastest, most efficient way to store user meta like books, movies, etc. I was planning: metaid | userid | firstname | lastname | movies | books | biography | … |
| | I am developing a project which is going to use this database table, but I am not getting the complete normalized form of this table. I am not practically strong with normalization so every time I try to make it I end up in no where. The table is attached … Databases |
 | I am using oracle 9i database with VB.NET when i am trying to insert record in my PR_REC table it gives me error "ORA-01722 Invalid number" here is my insert statement and the structure of the table [CODE]com = New OleDbCommand("INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES ('" & Me.txtprno.Text.Trim & "','" & … Databases oracle |
| | I've been trying to solve SQL exercises from [url]http://www.sql-ex.ru/[/url] for some time. You can find database description below: Short database description "Computer firm": The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, … |
 | EDIT* Sorry I didn't mean to add that error message in the topic title. Hey guys, I'm new to PHP and MYSQL and I have been searching for hours for a way to copy the data from a row in one table (all columns) and insert it into another table … Databases mysql |
| | [code=text]mysql_query() [[url]http://www.mysql.com/doc]:[/url] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into kiwanis_info ( 'identity', 'firstnam', 'lastnam', 'phonenum', 'emailaddr', ' at line 1[/code] Above is waht I get when inserting into a file from … |
| | Hi there. I'm having a problem getting values from a drop down to insert into a table. What I want to do is get the key for the value and then insert that. For example: I have a table called format which holds an auto incremented ID key and a … |
| | I'm having trouble getting my queries to insert properly. this is my table structure books(ISBN(pk), authorID(fk), formatID(fk), publisherID(fk), titleID(fk), yearPublished) the ISBN and year are past directly via a form but the foreign keys are all auto incremented in their own tables. I was trying this: [code] mysql_query("insert into authors(authorName, … Databases mysql |
| | Hi all, I have a problem in creating a matrix table using a PL SQL select query. The table should look like: [CODE] |---------------------------------------------------------| |--|-1-|-2-|-3-|-4-|-5-|-6-...-----------------------|100 | |---------------------------------------------------------| |A |A1 | A2| A3| A4| A5| A6|.........................|A100| |B |B1 | B2| B3| B4| B5| B6|.........................|B100| |.........................................................| |Z |Z1 | Z2| Z3| Z4|.................................|Z100| …  |
| | I have a table for Account Transaction. For each transaction a user must select a transaction category. These are stored in a second table which has a categoryID, description and a text box with only two values {'Income', 'Expense'}. Now in the report, I am grouping by Income/Expense. However, I … Databases microsoft-access  |
| | I am thinking to use MySQL with my new Java project, it contains some code that creates database locally and store data in it. It is all fine on my machine as I have all requisites installed like MySQL server but what will happen when I give this developed software … |
| | I'm trying to create a database for a public library and I'm running into a snag when trying to formulate my tables based on the requirements I've come up with. Authors • Write books • Have publishers Publishers • Publish books • Have addresses and phone numbers Books • Have … Databases |
| | Hello, I need help with a query. I need to find the Sum of Distance of T# 1 But there isn't Adelaide -> Melbourne So I'll have to take the value of Melbourne -> Adelaide which is 400 How can I handle this problem? I can do them in a … Databases oracle |
| | Hey all, Can any when tell me how to loop and put if-conditions in sql query? as I am new in SQL i am a bit confused about this please help me i have very short time. Thanks in Advance Databases mysql |
| | Hi, I have a MySQL DB and I am trying to set up a report page. To do so I need to be able to add the data in 6 or 7 fields into a single field for use in a summary report. How can I do that? SUM() seems … Databases mysql |
| | Hi I have a PHP/MYSQL driven site. When a user creates a new account or updates their existing username or email address I do a quick check to make sure the requested entries are not already in use. I am concerned that in the few milliseconds between the SELECT and … |
| | What is the diffrence between Key and Superkey how can we understand ? help me please Databases |
 | Hey all... I have assigned a job to create back of the databases of our company, maintain it for 7 days and after 7 days delete the back... I have worked on this and make it up the following query but still confused on its authenticity. Please Check and tell … |
| | Thanks so much guys! That solved my problem.. I have another question.. Find the names of all restaurants together with the names of diners who visit the restaurants on 24 April 2011. IF no diner visited a restaurant on the day, include a name of restaurant with no value in … Databases oracle |
| | I;m trying to move a database created with WAMP from one computer to another. I've exported it as a .sql file and imported it by creating a new database and then importing into it. The problem I'm facing with this approach is that none of the data in the tables … Databases data-structure mysql |
| | I'm having trouble with a MySQL INSERT query. I've used this exact code in many places, and even in different pages on the same web server. I feel like I've tried every variation of INSERT query with no luck. Here are a couple that I've tried so far: [CODE] $name … Databases mysql web-server |
| | Hi, I'm having a little trouble figuring out how to show some of my relationships in an ER diagram and was hoping for some help: Authors([U]aID[/U], aname, abio) Books([U]bID[/U], title, summary, quanity) Format([U]fiD[/U], formatType) hasFormat([U]fID[/U],[U] ISBN[/U]) bookFormat([U]bID[/U], [U]fID[/U]) libraryBook([U]libRef[/U],[U] bID[/U]) Section([U]sectionId[/U], sectionName) Cardholders([U]cardNum[/U], cname) Address([U]addID[/U], streetName, City, PostalCode) cardholderAddress([U]cardNum[/U], [U]addID[/U]) … Databases |
 | What is a superkey?(better,with examples).what is the difference between composite key and a superkey? composite key= compound key? Databases |
| | I'm not sure where to begin on this... I have a survey engine that supports 7 types of questions and really an unlimited number of entries per question (yes/no being one exception). So, I have 7 tables and each table correspondes to one answer type so I have: response_bool (true/false … Databases mysql |
| | Trying to import a flat file into SQL Server using SSIS. The file format is like this: [CODE] Image: C:\folder1\1234\5678.jpg ColHead1 ColHead2 ColHead3 Data1 Data2 Data3 [/CODE] I need a result that looks like this: [CODE] ColHead1|ColHead2|ColHead3|ColHead4 ----------------------------------- 5678 |Data1 |Data2 |Data3 [/CODE] So the idea is that we extract … Databases |
| | I have a class registration form. The database has a semester table, class table, student table and registration table. I want a query to return a list of students that are registered for a class in an active semester. I have the query, but it returns each student twice. I … Databases mssql |
 | Hi, I wrote a qyery: [CODE] SELECT introtext FROM jos_content JOIN jos_sections ON jos_content.sectionid = jos_sections.id WHERE jos_sections.title = 'Redaktores zodis' ORDER BY publish_up, DESC; [/CODE] If I don't use ORDER BY then it works. But with it it throws error: Query : select introtext from jos_content join jos_sections on … Databases mysql |
| | I have to: Find the distinct names of all diners who ordered 2 or more portion of the same foods on the same day in the same restaurant. [CODE] SQL> select * from foodorders order by diner; DINER RESTAURANT ODATE FOOD ------------------------------ ------------------------------ --------- ------------------- ALICE BEST FOOD 09-APR-11 BAKED … Databases oracle |
| | What would the diagram look like and what [B]relationships[/B] would there be? It [B]stores[/B] the [B]customers (patients)[/B][B] details [/B]and [B]drug information(prescrip?)[/B]What[B] entities [/B]would there be ? e.g. customer/patient, pharmacist or doctor? or both? Databases |
| | hi there, i have a question in connecting to the server. when i log in to the server and connect to the ms sql server i can connect to the databases. but when i login to another computer and try to login to the MS SQL server management studio i … |
| | This question is more specific than general. I understand SQL a good amount, and understand JOINs and UNIONs etc, but I am having a real problem with a query I need. I have three tables: [CODE] ITEM: ITEM_ID ITEM_NAME WISH: ITEM_ID CUST_ID SELL: ITEM_ID CUST_ID [/CODE] What I need from … |
| | We're having issues with database performance, and up till now, have done very little with indexing. We try to turn on full text indexes when available, but we do support (though we are phasing this out of our support)MSSQL2000, we try to advise our clients to use the newest available … Databases mssql |
| | Dear all..before i give up after multiple trial and error attempts,can someone please help me with below query. I am trying to replace the path name D:\Downloads\Music\ (note the slash) to [url]http://mysite.com/Music/[/url] in mysql field name called "filename" under "songlist" table. Below is the query code that I tried ,but … Databases mysql |
| | Hi. I'm having a problem on deleting a record using a function on SQL. DELETE FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' This query shows and error saying: Cannot group on fields selected with '*'. I tried adding a specific field, like this: DELETE ServiceID FROM tblServices GROUP BY ServiceID … |
| | Hi, I want to get the count(*) from all tables under a schema. How to can do this using a loop? I'm a noob at PL/SQL. I'm unable to find how to use the loop variable in the select statement. Here is what I've tried so far: [CODE]spool $DD/get_oid_dump.log; SET … Databases oracle |
| | here is my code want to get records between two dates [CODE] $sql=mysql_query("SELECT * FROM `expense` WHERE `date` BETWEEN '2011-04-26' AND '2011-04-28'") or die(mysql_error()); echo $r=mysql_fetch_assoc($sql); [/CODE] i getting "Array" in output instead of the data please sort it out for me i am not getting it right Databases mysql |
| | I'm using mysql 5.5.9 I used create database query to create a new database but this new database is not coming in mysql.db table can anyone tell me the reason y and even how to get the database in that table. Databases mysql |
| | hi i get an error saying cannot login to the ms sql server, i did all the things restarted the server, and changed the authentication mode to mixed mode nothing doesen't work, i created an another login with mixed mode authenitication the same error saying login falied to user sa … |
| | Hello Everybody! My problem is connected to the SQL Server Enterprise Managager. I worked with it for a day testing a database attaching/detaching it and after I closed the Manager the following problem occured. The local database seems to be dissapeared. However, the applications through the network reach it because … |
The End.