Databases Forum

Hi, I have tried to Google this but cant find anything. I want to use a select AS statement to select multiple columns. i.e. [CODE]Select unitno country price AS propertyref[/CODE] is this possible using multiple columns AS one reference? many thanks

hi there... i need to know the difference between varchar and varchar2 datatype in oracle

i have two tables like this i want retrive cname from person where cid duplicated at per_db and did at per_db=$value i want sql statment return "wael" from person person cname | cid ----------- gamal | 1 wael | 2 samy | 3 ------------- per_db cid | did ---------- 1 …

Hi there, I have two tables. The first one holds information about cities: Locations: [code] locID | locationID | locationName | countryCode | 1 | 2922239 | Berlin | de | 2 | 291074 | Paris | fr | 3 | 295522 | Orlando | us | 3 | 292345 …

Hi Guys, I have a predicament here which I think is really easy if you get it right. I just cant wrap my brain around it for the moment (probably been staring at the screen too long) I have two table (financial data) Table 1 looks as follows id account …

i have this scenario for a school project: You have been sub-contracted to design the database system for Marlowe Interiors. Marlowe Interiors is a medium sized interior design company that does building work and decorating. An initial analysis of Marlowe Interiors has identified the following requirements:  Marlowe Interiors keeps …

Hi everyone! I recently created a MySQL table that has three columns: (1) integer ID (2) integer num1 (3) integer num2 Now, I have a C program that waits for the user to input an integer ID and when there is an input, the corresponding num1 and num2 in the …

Hi Guys, Back again. I'm having an issue with my java with mysql. I have the following query generated through my java, which reads in about 3k records from an excel file and churns out an sql query for me. For the purpose of this forum, ill show the first …

Hi I am trying to write a function in which I customize my select statement. But it is not working as i desire... It is as [CODE] declare @column_name nvarchar(10) set @column_name = 'original' select @column_name from data [/CODE] Here original is the name of one of the columns. I …

Hey guys, I'm a newbie to mysql and wanted to know how can I connect 2 tables together with a many-to-many relationship. This is what I have. [CODE] create table pharmacy ( pharmacy_id int not null primary key auto_increment, businessName varchar(25) not null, location varchar(25) not null ); [/CODE] [CODE] …

Hi I would like to save one table's data to another table. The code that I have wrote is this: [code] con.Open(); string copyData = "INSERT INTO Changes(IP,ServerName,[Type of Server])SELECT IP,Server,Name FROM Server"; cmd = new SqlCommand(copyData, con); int returnValue = cmd.ExecuteNonQuery(); con.Close(); [/code] and it seemed working but when …

Using javascript, a field in an html form is formatted for time. When the user types in 344, the field formats onblur to 3:44. This field is then echoed in PHP an appears properly formatted. However, in the MySQL database it is inserted into, it appears as only "3". Everything …

This is not a homework assignment. :) I'm a MySQL newbie and we just bought a product that uses it. The vendor has indicated that what I want is a special request and wants to schedule professional services time (several weeks in the future) to write us a personalized script. …

I'm currently building a website for a small charity and they've asked me if it was possible to make an admin area where they could access some of their work when they're out and about so they don't have to fill in forms twice. I can do this as I …

Hi, I have been trying to execute a query and for some reason it returns 0 when there should be 1 in the result. [CODE] SELECT count(TaskID) AS DueToday FROM tasks WHERE TaskDueDate = CURRENT_DATE AND Completed = 'No'[/CODE] I have tried NOW() and various others reference [url]http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_current-date[/url] however it …

hi 2 all m new to mysql and want to make a table in mysql so please help me Table for Name Email Phone number Comment

hi when i check apache status there is too many line like 198-92 - 0/0/4 . 0.00 78719 0 0.0 0.00 0.00 127.0.0.1 noc1.server.com OPTIONS * HTTP/1.0 i think this is related mysql or not is there anyway to close this pid in 5min or 10min? [CODE]0-112 1881 0/16/24053 _ …

Hi, I have table structure as follows Table Name- facilities facility_id | hotel_code | facility_name 1 1 Parking 2 1 AC 3 2 Parking 4 3 Parking 5 3 AC 6 4 AC Now i have to find the 'hotel_code' that having 'Parking' and 'AC' both facilities ie 'hotel_code' as …

Hello Good People. I need help with my database script,to an extent i have created all the tables i need...for 5 straight days i cant seem to find the solution to this please read my script below 1. i have a database with 2 tables, the admin andm users_cv tables …

I have been searching for ways to do this but I was not able to find any. What I want to do is this: movie_genre (Table) movidId movieTitle movieGenre (Varchar) 1 Copying Beethoven (2006) Biography 2 Copying Beethoven (2006) Drama 3 Copying Beethoven (2006) Music movie_plot (Table) movieId movieTitle moviePlot …

Hi there, Noob here sry. Mysql DB 1. How can i insert an H1 tag <h1>Listings</h1> to a table structure as field ? A functional H1 tag. 2. How can i insert or import a nationalities csv file to a table ? Thx a lot and happy new year!!

I'm trying to run a date range query which works, but I also need to get data outside of the date range inside of the same query which I get to work. The issue I'm having is when the start date is in say 2011 and the end date is …

hi guys, thanks for viewing my thread. i have a program in java application and i want to connect to mysql database because i need to use database for a few parameter.the result will b showed in web-page using php. my question is how can i connect my program to …

I am displaying data from an sql database in a textarea which will be altered by the user then re-submitted to the database. The problem is displaying a line break. I get <br /> displayed in the textarea rather than the newline. Can anyone help?

I'm building a local database with VS.Net, using C#. I have constructed the database and filled it with data. I've already been through the process of connecting to the \bin copy of the Db and setting the file to "Do Not Copy". Now, I want to design Views in the …

Hi, can anyone help with formatting a date range query in MySQL? It's just a form to enter two dates, and a second page to run the query and show the output. The form looks like so: [CODE]<form id="getdate" action="tracking_result.php" method="post"> <table> <tr> <td> <input type="radio" value="single" checked="checked" name="type"/> </td> …

Hi, I have two tables where both contain the ID number and Date. The first table will always have a date and the second table will never have a date. Basically I want the query to bring back a result set that if the ID is in table 1, then …

Hi everyone! Is there a way to set a MySQL server to not automatically start execution until prompted by the user? I recently installed a MySQL server on Windows and I'm having a little bit of problem at start up. Everytime I go to the command prompt to type the …

Hello all, I am new to MYSQL programming, although i have been working with MSSQL for a while now. I am using delphi on a project and the query below does not return any results, just cant find what is wrong with it Select Airwaybill, SDate, BLAccount, RCountry, PackageCodeDesc, TotalWeight, …

:?: how to delete all the tables in the a user at a time?

when i put this in phpmyadmin i get errors... can anyone look over it and find a mistake.. [code]CREATE TABLE Student { SID int NOT NULL default, SNAME varchar(200) NOT NULL default, ADDRESS text NOT NULL default, POST_CODE varchar(10) NOT NULL default, PHOTO mediumblob NOT NULL default, Primary Key (SID) …

Hi, Is there anyway to insert/add a new column between two column in a table without deleting any other column???

Hi, I have three tables as below. tbl1 [CODE]eid qnt pb 12 3 1 13 1 1 23 3 1[/CODE] tbl2 [CODE]tid eid fx so 1 12 0 1 2 13 0 1 3 23 1 1 4 23 0 1[/CODE] tbl3 [CODE]tlid tid eid fx 1 1 12 0 …

Hi geeks, I really need your help. I want to query in a table in MS SQL using a data in another table. This might give you an idea on what I am talking about. This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2 WHERE TABLE1.FIELD3 = …

I have been trying to download the community server edition of MySQL for 2 days with no success. I was able to download the installer and found the ZIP archive (both downloaded and mirrored properly) which I was also able to download but I cannot for some reason open the …

[b]How to speed up the Group By Clause for a large 3GB database.[/b] I am using Group by clause for a large database having 148 columns and 5 million rows with approx 3GB of size. We need to apply the Group by clause on approx 1,00,000 rows at a time …

I want to find out days gap between two dates excluding sunday. How can i do this in oracle. Please help me.

Hi, I am working on web application in java. I need to copy table from local database to web table database. So please help me solve this query. Thanks in advance.

Hello, I have table with test results. Every user have 3 records in the table RESULTS Table RESULTS contains fields USERID (int), TEST_POINTS (int), TEST_TIME (int); I need query to sort up results, but only the best result per user. Best result for user is one with MAX points for …

I have a database, test.db, with a table called Events. I tried this: [code] <?php try { // open the database $database = new PDO('sqlite:test.db'); $result = $db->query('SELECT * FROM Events'); foreach($result as $row) { // both of these lines produce a blank page //echo $row['EventName'] . ' | ' …

I have a table with one record per certification a user has. So, user SMITH can have multiple records, one for DMV another for CPT and another for ICD. SMITH has three certificates but can have up to 20. The desire is to have a second table with one record …

Hello fellows. I'm creating a new oracle database table. My table name is [B]tblTest[/B]. But it returns an error code ORA-00903: Invalid Table Name. I dont know why this happen. I think the table name is right. But what is the problem actually. [URL="http://img820.imageshack.us/img820/3946/nonametgm.jpg"]http://img820.imageshack.us/img820/3946/nonametgm.jpg[/URL] Thank you.

Hey there, I was wondering if I could get some guidance on how I could go about handling this problem. I'm creating a simple version control system database. The tables look like the following: [CODE]CREATE TABLE Users ( [UserID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, FirstName VARCHAR(32) NOT NULL, MiddleInitial …

I am new to SQL .. [code]SELECT status FROM statuses ORDER BY date;[/code] I know this will order by date but i want to alter the table and rearrange them by datestamp.. Is it possible to alter like that ?

I have table names 'payroll' with following data month , pay January , 1200 March , 1500 December , 2000 I want the following result Janury , 1200 February , 00 March , 1500 April , 00 May , 00 June , 00 July , 00 August , 00 September …

Hi all, I am transitioning a bunch of data from html (yuck!) to some sort of separated schema. I was going to use xml: [code] <events> <event> <title> <date> <speaker> <description> </event> </events> [/code] but now I am wondering if I should use a real database instead. Can anyone comment …

Hi I am running a PHP-based intranet site where the main page has to refresh its view every minute in order to show the most up-to-date information from an MSSQL database. At any one time there are only about 20 entries that need to be shown, but the main database …

Hi, As i was experimenting stored procedure's TRY-CATCH with RAISERROR, came across this issue. Would like some opinion on this. Microsoft sites documented as follows: SQL Error 0 - 10: caught in the TRY-Block, i.e. will not reach CATCH-block. SQL Error 11 - 19: caught in CATCH-Block SQL Error 20 …

Hi Guys I have an application that developed using ASP.net.There is cancel option,user can select number of item code and cancel it,but there is isssue.The issue is once user select more than 200 item code to cancel then it generate the error messsage.Error message is "Time Expird or server is …

hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database.. now what i want is to retrieve the data for each four hours.. i.e i want to execute …