Databases Forum

I need to design a website for music streaming. There will be a database of songs and the user can pick a song and listen to it. What database should I use and how should I store the songs on my server. I also need to have a very efficient …

[CODE]UPDATE movie_temp SET movie_release_year = ( substring_index(movie_title,')',1) ) WHERE movie_title IN (SELECT * FROM (SELECT movie_title FROM movie_temp) AS TEMP); [/CODE] When executing the above query (movie_temp table has more than 660,000 rows), after 600 seconds workbench throws me errors Error Code: 2013Lost connection to MySQL server during query followed …

good day, im practicing databases and .net, can you help me in relating multiple tables and manipulating a listview? my scenario is about school subjects of a student, i have a database with data that has 2 tables, which is 'fnsh_table' and 'ofrd_subjects' fnsh_table Student_No nchar(4) Subj_No nvarchar(10) Title nvarchar(20) …

Hi everyOne... I am new to sql Server and installed Ms sql 2005. i want to use command prompt for queries But whenever i use the sqlcmd command my computer gets restarted... Why it is so???? can anyOne plz Help...

I have SQL Server 2008 Developer installed in my machine. The thing is that I have this database backup with version 10.50.1600, SQL Server Developer 2008 SP2 has version 10.00.4000. Well, I know there is not an easy workaround or conversion, so I thought well, what If I installed the …

I have 2 tables and want to add the count column from the bottom table to the top table (join on “OID” and “OPTID”) and if no count is found set the cell to zero. How can I do this? [CODE] SELECT questions.pollid, questions.id, questions.title, questions.ordering, options.oid, options.qoption, options.ordering FROM …

Hi, we have pl/sql objects.for some pl/sql objects we found the object names in the scheduler list to run it.But we didn't found the some objects to run the jobs. the scheduler contains Object list. if you select one object and click on submit button then it will show u …

I am trying to define the table and fields in a mysql database I set up in my hosting account. I have the database name, username and password set up. I now need to define the table and fields. They want me to import a text file to do this. …

Hello, I'm currently designing a simple movie database. In a table I have a column called status. And for that there will only be a few possibilities like "pending", "watched" etc... What would be a good way to design it such that I have some kind of constant? Should I …

hi there, I asked this question before also. i have two date times in a table in the MS SQL server database, when i write the query as below. the Sstart Date and the Due Date is displayed as 12/11/2010 12:00:00 AM it shows correct in the MS SQL business …

Hi all, This is my first post on this forum, I hope someone here can help because the last few forums were at a loss... Any ways, I have this MYSQL command: [CODE]SELECT DISTINCT schedule_date, schedule_time, schedule_team_1, schedule_team_2, event_name, type_name, gen_duration, COUNT(DISTINCT((SELECT id FROM link_schedules WHERE schedule_id = schedules.schedule_id UNION …

I set a password to mysql console in wamp. I followed a video tutorial. And it was successful. But now I can't access phpmyadmin or localhost. It says invalid password ...And gives no option to type the password. How can I solve this??

I can't find information on this anywhere online. I am building a site using drupal. As you may know drupal installs its own database and runs on Apache. I have a backend mysql database that must be read and written from a vb.net app. I had to purchase a hosting …

what entities should i think about for making a data base project(using java + mysql) for a pharmacy. i thought about the 1- medicine entity 2- supplier 3- employees what else ? and how should be the relationships between these entities? PLEAse help!

Hey everyone! I am a student and am supposed to find some problems with this database design and eventually come up with ways how to fix them. I have listed some problems below that I have found, can someone help me with either fixes or additional problems that you see? …

Why my code in my VB-access database is not working. my add code is not displaying the inputted data it only displays the gridline in datagridview. I already connect the database access file. What's wrong? Can anybody help me? thankz.

I recently installed MS SQL Server 2008 Developer Edition (on my home PC with Win7 Ultimate 64-bit). I have been trying to get it set up for use, but am having some issue. I keep getting an error when trying to connect to the server. On the "Connect to Server" …

I have an html file that is supposed to do a search and return of a database I have created in phpMyadmin but is giving me nothing but one error after another!!:'( This is the html form[CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Directory List Request</title> …

I have two tables Banks(Bank_id, Bank) FX (ID, Bk_id, currency, trans, value) Banks and FX are innerjoined on Banks.Bank_id=FX.Bk_id. in the original table in database: [CODE]Code: ID Bank Transaction type Currency Value 1 X Buy EUR 1 2 X Sell EUR 2 3 X Buy USD 3 4 X Sell …

i have 3 months to learn my course Data Base Management System, where i must make a project. I have chosen to make a software to dentist clients. Please help me with any ideas, my entity , my relationships, is it easy to make or hard??? i am null in …

Hello there. I am wondering whether you'd be able to check this ER diagram for me please for an online job service for university students? I have it constructed but I get anxious with these things and am looking for tips on whether my design is currently accurate. [url]http://www.daniweb.com/forums/attachment.php?attachmentid=18943&stc=1&d=1295818361[/url] Thanks …

I HAVE LOADED ORACLE 8i ON WINDOWS XP. IT HAD LOADED SUCCESSFULLY AND I HAD WORKED ON IT. BUT ON NEXT REBOOT WINDOWS IS NOT ABLE TO START THE SERVICE CALLED OracleServiceORCL. WHEN I TRY TO START IT AGAIN IT ENDS WITH AN [quote] ERROR:- Could not start the OracleServiceORCL …

Hi guys, I'm learning PHP and MySQL now, so I did a simple forum database in MySQL Workbench. I hope you guys can check it out and point out anything I should that note of. Also I would appreciate it if you could share your learning resources (like blogs/tutorials, not …

I have these for entities and can not come up with a simple ERD. The entities are: ChairPerson, Faculty, College, Department, Certification, University, Journal, Company. I need to come up with a relational database design in Visio. I don't know what Journal or Company exactly refer to and I can …

hello, i was wondering whether someone could provide me with a couple of comprehensive links (tutorials) on database design with regards to optimization? what i'm looking for is a thorough example, that would explain each index choice and every other database optimization related aspect (for a beginner to intermediate level). …

Have a table in column a i have a list of part numbers p101, p101, p102, p102, p102, p103, p104 etc part no alternative p101 a178 p101 a196 p101 a192 p102 a135 p103 a165 p103 a145 p104 a179 i need to have it like this but i cant work out …

Date: January 22, 2011 Hi, Need some help to solve this error. Nothing similar in the forum, IMHO. [B]Environment:[/B] [QUOTE]phpMyAdmin – 3.3.9 with this info: # Version MySQL client: 5.0.51a # Version MySQL: 5.0.45 # Server: Localhost via WAMPSERVER 2.1 # PHP 5.2.6 # Apache 2.050 [/QUOTE] [B]TABLE [/B] DROP …

hi, I want to import a text file which delimited by tab to mysql. 1) using phpmyadmin => results ( exceed time limit even i've extend) 2) open using excel file save to .csv but still couldn't save all the record 3) using ms access with odbc connection => almost …

hey friends...i request you all to pls help me out...im damn confused... im planning to make a website by March,2011 in which i will be using HTML/JSP and Mysql as d/b. however, i have a few doubts abt. Mysql.... 1) on the mysql site, there are many packages available to …

I am new to SQL and databases in general. My problem is that I am trying to create a table that will store information about users in each row based on the date of that activity. So I need to create a table with 365 columns representing with one representing …

Hi everyone, I'm building a microblogging system like twitter and I need help in optimizing the database structure. I have tables "user_info", "posts" and "friends". Each time when user logs in, lets say user X, all latest posts of friends of X should be displayed. So it means that when …

Hello fellow database enthusiasts ! :) A friend of mine owns a print shop, and business isn't going well right now. So he has asked me to develop him a website. The website's aim is to allow people to make orders for prints. I'm stronger in ASP.NET than I am …

Guys... i need a database design on hotel search engine.....can anybody help me???? only searching for hotel(not restaurants) no hotel booking. its like justdial.com just a find hotel near u......please help me...... thanks....

*THIS IS THE CODE WHERE I CLICK A BUTTON TO SIGN UP FOR AN ACCOUNT* Set db = New ADODB.Connection db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\useraccount.mdb" Set rs = New ADODB.Recordset rs.Open "Select*from useraccounts", db, adOpenStatic, adLockOptimistic rs.AddNew rs!Lastname = Text1.Text rs!Firstname = Text2.Text rs!Contact = Text3.Text rs!UserName …

how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name')))

the following should return 1 row [code] $search= "Timothy"; $query4 = mysql_query("SELECT * FROM test1, test2, combination WHERE test1.IDONE = `combination`.IDONE AND test2.IDTWO = combination.IDTWO AND test1.NAME LIKE '%$search%'",$this->connect) or die(mysql_error()); [/code] instead it returns zero. the query should take values from all three tables according to the where clause. …

Hi, I'm wondering if anyone can help me with a query? I have 3 tables in phpmyadmin, vehicles, drivers, and bookings. I need to make a booking in the bookings table (primary keys are DriverID, VehicleID, BookingDate) this will ensure its a unique booking and the DriverID, VehicleID need to …

There are lots of stand alone programs (sqlitespy, sqlitestudio, etc) that give you nice spread-sheet style access to tables: [url]http://www.yunqa.de/delphi/lib/exe/detail.php/products/sqlitespy/sqlitespy.png?id=products:sqlitespy:index&DokuWiki=2oa8egb90q7fck3t3q2uk9nv61[/url] but does anyone know of a web based way to do this? Thanks, David

Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss

Hi all, DANIWEB saved me a few months ago, and I'm hoping the community can save me again :) I've found myself in the position of needing to extract a very small portion of data from a vast SQL database. I've got the specific table in question, and have isolated …

My SQL isn't the best. Here's my situation: My table consists of three fields. I'll call them A, B, and C (for simplicity). For each A, there should be only one B-C combination. No matter how many times A is in the table, it should always have the same B …

Hi, There is something wrong with my code. I can't seem to access the database anymore not can I add new data information. I am suppose to create a registration form with username and password. Then save it to a database on MS Access. Then login using the login form. …

Greetings, I'm having some trouble creating a trigger that, before I insert something in a table, it resets an existing record field to 0. Example I have in the table a field named "Name" and another named "Active". Each field has a diferent ID The last entry of a "Name" …

Hi, I have made simple database in MS access. I want the front end for that database which can be easy to use the database for 3rd person. Can anyone help me. Saroj

Can anyone help ? Im looking to find a MySQL query using regular expressions to allow me to remove any paragraph html tags within block quote tags. An example is : [CODE]<blockquote> <p>TEXT</p> </blockquote>[/CODE] Should be : [CODE]<blockquote> TEXT </blockquote> [/CODE] Thanks,

Hi, I have to insert fields in a table. I am using VB.net & SQL Server database. The code is: Dim userid As Int32 = Me.classname.UserID Dim strSQLD As String = "Insert into table1 (userid) values (Me.classname.UserID)" userid is of type int While debugging, i can see that variable userid …

Hi there, I am having trouble with making an inner join whilst concatenating two of the fields. I can do both separately but have not yet mastered both at the same time. Here is what I have. It does work, however not in the intended way. It produces the only …

hi guys, i`m new to the data base systems i currently work in a school and i have been asked to design a database for all the computer items in school the problem i have is because i no very little about how to setup and make a database i …

I experiencing problem in executing query on between date command. I got wrong result. [CODE]SELECT approval_date FROM itemdetail WHERE approval_date BETWEEN '01/01/2011' AND '15/01/2011'[/CODE] My Record in Mysql Database: |Approval Date| 05/01/2011 10/12/2010 12/12/2010 15/12/2010 10/01/2011 |Result| Like above Need result |Approval Date| 05/01/2011 10/10/2011 Anyone could help me. how …

Hi All, I have made a dynamic form details content table where the data is storing by comma separated values.All the form fields are stored as dynamic in the table. Fields : [CODE]n1_First_name,n2_bank_aaccount,piriod_to,n5_comments_by,n6_like,n7_comments[/CODE] Data: [CODE]nil@nil.com,test1,4-May-2010,test2,no,abc nil@nil.com,test1,4-June-2010,test2,no,abc[/CODE] Now as you see this field "piriod_to" refers to 4-May-2010 and 4-June-2010.....till now its …