Databases Forum

Hello, I'm running 3.25.54 on a linux RedHat server. Here is my scenario and what I'd like to do. I have two databases d1 d2 d1 has some tables in it that I want to be in d2 instead of being in d1. My task is to get some of …

-------------------------------------------------------------------------------- This is my table structrue Tbl1 -----Record1-----Record2----- Record3 Tbl1_id --------1------------2-------------3 Tbl2 -----Record1-----Record2----- Record3 Tbl2_id --------1------------2-------------3 Tbl1_id --------1------------1-------------1 Tbl3 -----Record1-----Record2----- Record3 Tbl3_id -------1-------------2-------------3 Tbl2_id -------1-------------2-------------3 Tbl3_Name ---Test1---------Test2--------Test3 Tbl3_Flag ----N-------------Y-------------Y Tbl4 -----Record1-----Record2----- Record3 Tbl4_id -------1-------------2-------------3 Tbl2_id -------1-------------2-------------3 Tbl4_Name ---Temp1--------Temp2--------Temp3 Tbl4_Flag ----N-------------Y-------------Y I wanted the result as Tbl3_Name--Tbl4_Name--Tbl3_Flag--Tbl4_Flag Test1 -----------Temp2--------Y-----------Y The rule …

Is there a way to drop a PK from a table by selecting the name into a variable from all_constraints, I need to run this script on multi databases that the actual name of the PK could possibly be different. I can get the name in a variable but don't …

How can i display result of a single cell query? my query is [code]$author=$_POST["authorname"]; $q="Select authorid from authors where AuthorName=$author"; $resultauthor=mysql_query($q,$connect); $num=mysql_num_fields($resultauthor); [B]<<Error coming here![/B] :( mysql_num_fields(): supplied argument is not a valid MySQL result resource in[/code]

Ok, so i created a db, with the help of the MYSQL manual ;) and think i'm on the right track (well, i'm on a track at least). this db is for our members area (car club web site). I put 3 tables in there users auto_info auto_mods all 3 …

Hi folks...... I'm a bit new to this... played with DB's on an off for years...... now getting back to programming and web design, learning to play with all the big boy's toys etc. LOL Yet I must admit that I have fallen for the simplicity of access's ability to …

Hi guys Lemme explain the situation in 2 lines: DB Structure: [url]http://img133.echo.cx/img133/6610/dbstructure6hs.jpg[/url] Client goes to computer shop. Shop has 1 or more NORMAL promotions (of the kind: for each u$sXX ammount you buy, you get X qtty of points to exchange them later by gifts). EACH NORMAL PROMOTION can have …

:cry: I'm new to this MS SQL and I've been trying to understand this Primary key and Foreign key. I know that I use the foreign key to reference a table but for some reason I'm not getting this down right can someone point me to the right direction. Also …

I created a database in Sql Server 2000, unless I made atleast one field in the table as "Unique", I could not insert data into table. But no-where in the documentation , books or Sql server online I could get a text saying we need atleast one Unique Key per …

Hi! i have a table with 3 fields: ParentFolder,DocumentNo and VersionNo the DocumentNo give each document a unique number. ParentFolder is a number specifying which folder a document is in. and each document(with same name) can have many VersionNo(1,2,3 etc). i am creating a house keeping function for user. this …

i have two tables table1 has the folowing fields lastprice symbol time table2 has the same fields now table1 stores only the last data of the corrosponding symbol but table2 goeson adding the data as it comes in now i want to write a query get the difference of the …

hello everyone.. i'm a newby in mysql but i'm trying hard. So i won't lose a minute, and i'll go straight into the heart of the problem. I have the following mysql dumps: DROP TABLE IF EXISTS location_tree; CREATE TABLE location_tree ( id int(11) NOT NULL auto_increment, pid int(11) NOT …

Is there a way I could create a variable that belongs to a table much like a static variable belongs to a class? So it "thing=1, person=2" were variables belonging to the table structure (not each row), then I could do something like this: SELECT * FROM table WHERE type …

Hallo, ich möchte in einer Tabelle die Zahlen einer Spalte nach Grösse sortieren. Das Problem ist, dass das die Zahlen aus bestimmten Gründen Kommazahlen sind, also z.B. 1,3 45,3 etc. Kann mir jemand sagen wie das möglich ist? Ich habe leider nicht so viel Erfahrung in mysql..... Grüsse Kathrina

I am looking to setup a site that searches inventory. Something like AutoTrader (as far as the searching goes). Basically just enter vehicle make, year, etc and the results appear. What language would I write this in? As you already guessed I know nothing about databases, can someone give me …

I want to create a database to store information about my music collection. I want to be able to query the database for each of the following attributes: •a particular title (for example, Tapestry or Beethoven’s Fifth Symphony) •artist (for example, Carole King or the Chicago Symphony Orchestra) •format of …

Hello, I am trying to set up the phpbb forums on my site using MySql and I don't understand how to link MY site to the DATABASE. I also can't seem to figure out where my username, password, and the name of my database as I need them for the …

i want to generate a unique primary key, something similar to the auto increment feature, but i do not want it to be auto increment. The reasoning for this is: this table will have rows deleted by the hundreds every day, and maybe even thousands in a few years (I …

Hi everyone, im really stuck! I need to create a front end web site with a back end access database for my module at university. i have no idea how to do it!! do i create the web page and then create forms within the page and then link it …

Hi guys, can anybody help, plase. Is there an instrument to manage .edb file (as far as i know Oracle's Enterprise DB but under free licence)?

HI all, Im looking for a program that will work with WinXP(shareware or freeware preferred) that works basically like the startmenu. Its for and inventory thing im trying. Needs to give a list of choices and if you click one, it will open a sub box with a new choice …

Hello, How can a timestamp field (int, 4) witch displays as hhmmss be converted that it looks like hh:mm:ss? Can anyone help?

Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL versios. TABLES IN MY DATABASE: Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, …

This is going to sound crazy - but is there any way to to a search for a phrase of text within my SQL database? (I am obviously not very knowledgeable) except on how to get there! :) Thanks for the help!

Have any of you used Dadabik as a end user app for MySQL? I am currently using PHPBB and MySQL for a forum. I have another db in MySQL that I want users to be able to search the db, add records, etc. (non profit, db would be used as …

I have a form that should write to MyDQL Database but isn't I have been looking at it for hours and it is driving me crazy. [CODE]$sqlquery = "INSERT INTO $table VALUES '$id','$Name','$DoB_Day','$DoB_Month','$DoB_Year','$Address_1','$Address2','$Town','$Postcode','$Telephone','$Mobile','$Email','$6th_Form','$6th_Form_Year','$6th_Form_Institution','$6th_Form_Course_Title','$College','$College_Year','$College_Name','$College_Course','$E2E','$E2E_Provider','$Apprenticeship','$Apprenticeship_Level','$App_Employer_Name','$App_Work_Area','$Employment','$Employment_Basis','$Emp_Employer_Name','$Emp_Job_Title','$Emp_Training','$University','$University_Name','$Uni_Course_Title','$Gap_Year','$Unemployed','$Other')";[/CODE] I have used this method before and it worked fine but it just isn't playing nicely today. …

PROBLEM: ____________________________________________________________ Im trying to create an update on an oracle database and Im having some real trouble with it. If anyone has experience creating transactions and stored procedures from .net or asp and can help out I can use the assistance. My code is returning the following error and …

Apologies if this is a simple query, I only get to use Oracle on the odd occasion so I tend to get a bit rusty. At present I am attempting to create a view that gathers data from 4 tables, this information will then be queried by an external application. …

Please, please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version: The query should retrive any availble rooms from the database MY ATTEMPTED SUB-QUERY: Select * From Room R Where R.room_no NOT IN( Select B.room_no From R.room_no = B.room_no And R.room_type = ‘single’ …

Hi, Accidentally one the member has compressed the disk drives in the SQL Server. Before we go ahead an uncompress the disk drives, we need to make sure that the database is unaffected. 1. What is the normal database compression ratio when Hard Disk is compressed? 2. Do uncompression of …

Hey folks, I need your help. I stuck with my Database project. I have five tables on the database: These are Room, Guest, Booking, Employee and Admin Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address,…) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, user_name, password) Employee …

I've been impressed by MySQL's ability to run as a database on a server with clients connecting using a client-server or web based architecture. I'm now wondering if a version of MySQL can be cost effectively licenced to run with application software (which might traditionally have used a Jet database) …

hi, please anyone help me with this.I have a database 'hbm' which contain a table called hitted having 2 columns(id,hit). I inserted a record with id=1. Now i need to query this database. define("hit_TBL","hitted"); "select hit from" . hit_TBL. " where id=1 and LIMIT=1"; throws error. request members to help …

I'm having trouble figuring out how to query multiple tables. (Note: I've greatly simplified the tables for clarity purposes) I have 2 tables: Invites and Purchases The invites table has the following fields: email & invitee The purchases table has the following fields: useremail & product Invites tables +------------------+----------------------+ | …

I am working on a site for a school project and all I have access to is php and html. I would like to be able to run some MySQL - but I am unable to find a place that will remotly host it for me. Does any one know …

Please tell me the difference between the two thankz

Can anyone help me by advising me on how it would be possible to capture a still image (from a web cam) directly into an HTML screen (running via IE 5.5) and the image being stored (along with other manually supplied text) back into the Oracle 9i database??? I would …

Hello, Can anyone explain to me how I can create a function that I can use in SQL. Thanks

Is there a way to get the current value in the process of a select statement? Such as [CODE] SELECT pk_ID, columnN and be able to evaluate what pk_ID is at this point WHERE This = That [/CODE]

Hi, I hope I put this into the right category On my [url=http://www.national-real-estate-directory.com/real-estate-forum/] Real Estate Forum [/url] the vBulletin options are not working. Could someone tell me where to start troubleshooting. Thanks, Mike

Okay, not new to MySQL, or PHP, but I'm really lost on this one. I have a query (simple one really) that is supposed to return the requested values from a database. I've tested the query with MySQL direct and it works fine, but when used via the web interface, …

Hi all, I have a array of 96 integers and I want to store each one in Database. I want to access all these 96 integers in a Java program. Now I am confused about how to store it? 1> wheather i have to store it as 96 fields. ( …

Hi guys, sorry to trouble u guys,but can't resist Actually i have a table (transaction table) in which i have got customer id(can have more than one record with same id) ,acc no, and type (either credit or debit). Now i want to find the balance of the customer by …

I have the following code: [php]$rebate_query = tep_db_query("select * from " . TABLE_REBATES . " where product_id = " . (int)$HTTP_GET_VARS['products_id']); $rebate_information = tep_db_fetch_array($rebate_query);[/php] This should return only 1 row of data I have this code - " [php]$rebate = $rebate_information['rebate_amount'];[/php] " for extracting the rebate amount. For the life …

Hi i am currently doing a database for my major project in gcse ict and i am tryign to find out what the validation rule is for. uk post codes so you can only type in a maximum of 7 digits? can anyone help? i need it urgently thanks

[B]Symptom:[/B] Error "database unavailable" when trying to connect to a Firebird database even if fbserver is running fine (and Java applications connect, isql works great, remote clients can connect great, etc.). [B]Scenario:[/B] You have just installed Firebird on a machine that previously had Interbase installed and are trying to run …

Over Christmas I've taken on the task of putting together a database for work; I don't have a deadline but it would be nice to have something to show in the new year. The database I am intending to build is to track the location of wheelchairs in the hospital …

Hi, I am working on a project that entails one beast of a database. A friend asked me to write a program into which he could catalog all of his cards by sport and then further by player, team, manufacturer, etc. The tools I will be using: 1) MS Access …

I have a web portal from a buddy's website using PHPNuke that I administer. The site has user accounts for the site itself and for the forums. I recently purchaced my own domain and am currently designing it the same way using PHPNuke. Is there any way I can transfer …

Hi everyone can anyone please help me to define the dimension table for EMPLOYEE I need to design the dimensional table with the hierarchy starting with Board of Directors(which is sub categorised into Staff for Board of Directors which again is subcategorize into Technical, Administrative and Accounts) Then we have …