MYSQL :: Linking To Other Databases

Linking Tables
In my database, I have two tables. The main table has a field named 'category'. The second table has a field named 'webcategory'. The main table is the table I use for all my queries as it holds all of the stock details. However, the category field is not suitable for web use, so someone (not me!) has created the second table which takes all categories and provides a web category.

I need to somehow link the 'category' field to the 'webcategory' field so that when displayed on a web page the 'category' changes to display the relevant 'webcategory'.

Linking With SQLBase
As a company, we are currently looking inot replacing our current Paradox (Yes some people do still use it) with MySQL and a Visual Basic 6/NET front-end.

However, we also use a rather large database run on Gupta SQLBase. Does anyone know if it is relatively easy and pain free to link MySQL with SQLBase?

Linking MySQL To MS SQL
I have a table in a Microsoft SQL Server database that I need to access from a MySQL database. Can I make a symbolic link between the two? I can't just import the data because it's something that gets regularly updated, but I need to work with it in MySQL.

Linking Three Tables Together
I have used MySQL to create a DB to keep track of baseball stats and player profiles. I have created one table to keep track of player details (name, age, ht. wt., etc.). I have created a 2nd table which holds stats for 2004 (ab, h, 2b, 3b, hr, etc.). I thought that I could link the tables together based on id which is the primary key.

I will have a 3rd table which will hold 2005 stats etc, etc, etc. Can I do this?? When I am making a query can I link the tables together? I am not sure how to do this. I have read a couple tutorials, but they are slightly different then the way I would like to use my data.

Linking Tables?
I have a table which stores user information...

User:
User_ID
Name

and i have a table the stores Contest Results

Contest_Results:
User_ID
Contest_ID
Votes

i have done this query

SELECT * FROM Contest_Results WHERE Contest_ID = $Contest_ID ORDER BY $Votes Asc

Now i want to list all the users Names Who have entered the contest which i just queryed... How do i do this? Code:

Linking To Access
Is there a way to create a database which will link and stay linked to an Access database?

Linking Tables
i have two databases set up, one is called test and contains phpbb2 data from my forums. the other is called chat and contains data for voodoo chat. What i would like to do is link or synchronise the tables that contain user data.

There is one in test called phpbb_users, i have imported this to the chat database for testing purposes. there are around 4 fields that i want to link which are:

DB from: Table From: DB to: Table To:
test phpbb2_users chat voc_users

Fields to match:

test: chat:
user_id id
user_name nick
user_sig user_info
user_lastvisit last_visit
user_email registration_email

Linking Indexes
I have two tables...

tbl_one
id two_id info_a info_b
tbl_two
id info_c

And what I want to do is link `two_id`, an index to the `id` field in `tbl_two`. Then I basically want to be able to display data (specifically `info_c`) by referring to the `two_id` field. What would be the easiest way to achieve this?

Linking An Echo
i have this messaging script that i use on a site and i added on the front page when the user logs in a box that says the last message received was on and i got an echo date.is there a way to link that date in the echo tag to the message?

Linking Telecom
I would like to know what technology(s) would enable a user to dial a phone number, then dial an "extension" number that retrieves data from a database and speaks the data back to the caller. An example of what I am describing is when you call an airline, dial the flight number, and you get a real-time update of that plane's progress.

Linking Two Tables
I need to join two tables, one is already popluated and distinguished by the listing ID. How do I link my reviews table to it. I know it will be by the listing ID, but how?

Linking To A Database
Newbie question: I want to link to table versus doing an import of that table. Is there a way to do this? I find that I can only do an import of data using the Import/Export Wizard

Linking Tables
If you have a number of linked tables is there some way to return just one row where fields with many values are put in an array? When I do my JOIN query I get a matrix of results showing every possible combo of the linked tables i.e.:
maintbl---tbl1---tbl2---tbl3
1-----------1------1------1
1-----------1------1------2
1-----------1------1------3
1-----------1------2------1
1-----------1------2------2
1-----------1------2------3
What I would like is:
maintbl---tbl1---tbl2---tbl3
1-----------1-----1,2---1,2,3

Linking Two Tables
I need to link two existing tables. One that is already popluated is ListingsDB and has a unique ID, the other is a review script that I want linked to the listings. How do i do that. I know it will be through the ID field

Linking Data
I have two tables that I am trying to link/join. One is a simple names table with each row identified by an id number the other is a functions table that contains id numbers related to certain functions as follows: nChairmanId, nSecretaryId, nTreasuretId, etc. and each of the values in the row are from the names table . What I want to do is join or link the two tables. I want to select all the rows from the function table and associate the value that is associated with a function with the actual name of the person (not the id number).

Linking Tables
Does linking tables with JOIN offer any significant performance
advantage or does it just make things more simple from a programming
standpoint?

Linking Tables Nightmare
I'm developing a site in mysql/dreamwever. Could anyone suggest why the query below is not working. 'colname' and 'colname1' are the result of a drop down which passes via URL - i.e. type1, type2. Its bassically suppost to query a bunch of fields in the table 'inst' - then link it to the members table it via the members field the in the 'inst' table - then the ID fields in the 'type1' table and 'type2' should link to the set of numbers in the 'inst' table.
You might get more of an idea by visiting on www.therecital.co.uk. Basically each member can have up to 5 instruments or specialities which are split up into sub categories (type1, type2). Please help
SELECT *
FROM members, type1, type2, inst
WHERE ((type1.ID1 = inst.type1a) AND (type1.ID1 = inst.type1b) AND (type1.ID1 = inst.type1c) AND (type1.ID1 = inst.type1d) AND (type1.ID1 = inst.type1e)) AND ((type2.ID2 = inst.type2a) AND (type2.ID2 = inst.type2b) AND (type2.ID2 = inst.type2c) AND (type2.ID2 = inst.type2d) AND (type2.ID2 = inst.type2e)) AND ((inst.type1a LIKE 'colname' AND inst.type2a LIKE 'colname1') OR (inst.type1b LIKE 'colname' AND inst.type2b LIKE 'colname1') OR (inst.type1c LIKE 'colname' AND inst.type2c LIKE 'colname1') OR (inst.type1d LIKE 'colname' AND inst.type2d LIKE 'colname1') OR (inst.type1e LIKE 'colname' AND inst.type2e LIKE 'colname1')) AND (inst.member = members.ID)

Linking Access To MySQL
Is there a way to link my Access database on my home computer to the MySQL database on my remote website, so that when I change something in Access, it changes it on the remote MySQL database automatically?

Linking To External Database.
Can anyone point me in the right direction.

I am looking to have one single database to manage nothing but User ID, Password and Permissions - we will call this database A.

I then have 6 (B - G)different databases which all have a Users table for ID's and Passwords. I want to have the database look to the A database for login information by somehow linking the backend of the database to DB A. rather than its own local table Users.

I have read that foreign keys come into place, however my 6 databases B - G are all MyISAM table structure rather than InnoDB.

Is there a good read somewhere that covers this? I tried doing some searches but as I am new to MySQL I think I am looking up the wrong terms. Screach.....the sound of your world coming to an end at the sight of the dreaded BSOD!

UPDATE Linking Other Tables
I am trying to do a simple update function in mySql.
NOTE. I am using version 3.0.9.4-beta

I have 2 tables:
Items and Sales_details

I want to update a field called >Sales_value< in Sales_details table using value from Items called >Sell< times (*) >Sales_qty< from Sales_details table.

This is the codes I have been trying:

UPDATE Sales_details inner join Items on Sales_details.fk_Item_ID = Items.Item_ID
SET Sales_details.Sales_value = (Sales_details.Sales_qty * Items.Sell)

Error msg:[development_DB] ERROR 1064: You have an error in your SQL syntax near 'inner join Items on Sales_details.fk_Item_ID = Items.Item_ID
SET Sales_details.S' at line 1

and

UPDATE Sales_details
SET Sales_details.Sales_value = (select (Sales_details.Sales_qty * Items.Sell)
from Items inner join Sales_details on Items.Item_ID = Sales_details.fk_Item_ID)
where Sales_details.fk_Item_ID = (select Item_ID from Items)

Error msg:[development_DB] ERROR 1064: You have an error in your SQL syntax near 'select (Sales_details.Sales_qty * Items.Sell)
from Items inner join Sales_detai' at line 2

DYNAMIC TABLE LINKING
I have two tables;

CREATE TABLE `s1` (
`product_id` int(11) NOT NULL default '0',
`product_sku` varchar(25) NOT NULL default '',
PRIMARY KEY (`product_id`)
) TYPE=MyISAM

CREATE TABLE `s2` (
`product_sku` varchar(25) NOT NULL default '',
`product_price` decimal(8,2) NOT NULL default '0.00',
PRIMARY KEY (`product_sku`)
) TYPE=MyISAM

I need to create a third table that links the product_price to product_id and dynamically updates when table s2 changes.

I tried the following but got errors.

CREATE VIEW s3 AS
SELECT product_id,
product_sku,
product_price
FROM s1, s2 WHERE s1.product_sku = s2.product_sku

Is it possible to link product_price to product_id?

Linking MYSQL Database
I'm trying to access mySQL db from a uni webserver using ASP. Uni have given a DSN and the user name and password but im unsure of the code that need to connect to it. Ive tried many times without joy and its getting very frustrating.

Linking MyODBC Drivers
Could someone please help me with the linker options for linking the MySQL ODBC drivers. I'm running on Redhat Linux, with gcc 3.4.6.

Linking Of HTML And Mysql
can u show me some example to link the HTML and the Mysql?

Force Linking Data
I use a Mysql database (V4.x) to run a Phpbb forum (v3) for an online gaming group.

One of the members maintains the frontend website, yesterday he posted the following:

***************************
with the Development of my new Web Script utilizing the new ASP.Net 2007 ... some irrelevant info ....

Utilizing the Forum Database I have developed a Pro-Synth v2 Script that Directly Force-Links all Data posted from any precise Region of his Database to My Host-Server... Now this Script is Highly illegal.. (and is not for Sale)
***************************

based upon whats stated above im going to presume that he already has access to the database, i dont know why he didnt simply ask me for access as it would have been given.

so my questions are;

How can i tell if he does indeed have access
How can i stop the access / prevent access of this type

Linking MySQL Database With C++ 5.0
I recently downloaded MySQL ver4.1. I seem to be getting the hang of importing files into databases and all that stuff, but I'm having trouble when it comes to my C++ program. I'm currently using VBC++ 5.0.

What my main question is what extra programs or libraries do I need to incorporate MySQL into my C program. Do I need a C++ wrapper or something of that nature?

DYNAMIC TABLE LINKING
I have a merged table of prices from different stores and I would like to create a second "price index" table. The second table would show the AVG(price), MAX(price) and MIN(price) per product as well as the number of prices COUNT(price).

The goal is to have this index dynamically updated like the merged price table whenever a store's product price changes. I've been trying to create a dynamic table using the following statement;

CREATE TABLE price_index
SELECT product_id,
AVG(price) AS AVG,
MIN(price) AS MIN,
MAX(price) AS MAX,
COUNT(price) AS COUNT
FROM prices
GROUP BY product_id

However, it's not dymaically linked to the prices table. Can this be done? If so, please tell me how. If not, can you suggest another way to create a dynamic price index? I've tried adding ROW_FORMAT=DYNAMIC but get errors.

The prices table is a TYPE=MRG_MyISAM. It has the following format;

CREATE TABLE `prices` (
`product_id` int(11) NOT NULL default '0',
`product_price` decimal(8,2) NOT NULL default '0.00',
`product_merchant` int(11) NOT NULL default '0',
PRIMARY KEY (`product_id`)
) TYPE=MRG_MyISAM INSERT_METHOD=LAST UNION=(store1,store2, ...)

Linking The Mysqlclient In XCode
I have been using Xcode to develop some mac programs.

I just found the C API for mysql, but I'm not sure how the library, can be linked using the XCode IDE.

Obviously, none of the API functions can be used in a program without this link.

I have been able to complie on the command line:

gcc -o test.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lz

I just don't know how to apply this to the Xcode environment.

Linking MySQL Tables
I have a Providex database that has a ODBC driver and I can import tables or queries into excel fine. The problem is I have to MANUALLY refresh the excel file DAILY so that the end of day report items are updated from the database into the excel sheet.

What I would like to do is link the necessary tables in Providex to a MySQL table and then run the queries on the MySQL table. In doing so, I would need the MySQL table to constantly refresh with the Providex database or at least make it where I could refresh it periodically throughout the day.

I know that it is possible to link tables in Access to automatically update when the source is changed, is there some of the same functionality in MySQL? I really don't have any experience with MySQL but have some experience with SQL queries from Microsoft Query and ASP webpages. Any examples or webpages that may outline the process would be great as well.

Linking C Program With Mysql API
I'm linking a simple C code with mysql. I compile the code with
this command:

linux> gcc -L/usr/lib/mysql -I/usr/include/mysql sqlTest.cpp -lmysqlclient -lsocket -lnsl

But it complains that "-lsocket" cannot be found. So, I removed "-lsocket" and
try again, then I got the messages like

/tmp/ccIelMdT.o(.eh_frame+0x11): undefined reference to `__gxx_personality_v0'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x66): In function `my_uncompress':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:85: undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x11c): Infunction `my_compress_alloc':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:58: undefined reference to `compress'

My system is SUSE Linux 9.1, and I installed mysql by downloading the rpm files
from this site, and use "rpm -i mysql-xxxx.rpm" to install them. The libraries
are installed at /usr/lib/mysql, and include files are at /usr/include/mysql.
Can anybody tell me how I can configure my system to make it work?

Linking Columns/tables
I have a series of tables setup, some of which contain columns named the same, such as 'clientid'. The first clientid value is generated by auto_increment in the 'clientaddr' table and when I add a client contact, this value is passed using a query string and inserted using a form field into the 'clientcontacts' table which also has a clientid column.

Storing & Linking Images
Ive been reading a lot of posts on this forum and have a general question. Is it generally better to store an image in the DB or just store a link to the image in the DB. In my case im going to be using this to create an online catalog and store and am wondering which avenue would be the best way.

Linking Site To MySql Database
I have bought the PHP and Database book and have created a database [windows](saved under the default directory under Program FilesMySql...) and I have created a server. How do I link the website (localhost - same PC as one with MySQL) with the database or is it done automatically?

Setting Up A Database And Linking It To A Website ?
Does anyone know how to setup a database linked to a website please ? I would like to setup a database so that when someone fills in their first name and email address to receive newsletters, it can automatically go into a database to be used later to email them their newsletters.

The (mysql ?), database in my cpanel is phpmyadmin version 2.8.0.2

Linking/Importing From Another Database On Same Computer
My accounts program is a substantial relatonal database with its own ODBC drivers.
I have for many years linked and imported the tables in my accounts progam into MS Access and manipulated my data in Access rather than in the accounts program (because it is much easier).

How do I link and import these tables into MySQL?
It is not via MyODBC - because that seems to be about linking to MySql tables from MS Access.

Linking Master Db With Other 3rd Party Plugin Dbs
I imagine this is a somewhat n00bish question, bear with my while I learn the ins and outs :)

I'm constructing a master product DB (MySQL) and have some other 3rd party (PHP) contributions I'd like to use in the interest of not re-inventing the programming wheel.

Specifically PHP Point of Sale, and osCommerce down the road. How can I link certain columns together so I don't have to re-enter information. For example, if I have my own master product table, with a column called 'description.' how can I link that with PHP Point of Sale's 'description' column?

Linking Two MySql Members Tables To = One
I have set up a forum as well as user auth into the heart of my site - however - I am still new to creating systems such as I have been working on and did not consider a repetitive user authentication system - I have two login forms - one for the forum on one database (in its own table) and one for the site itself on another database (in its own table) - Is there a way I can link the main site's user auth - to that of the forum auth and use only one members login and registration database for the whole site - instead of having multiple logins through out the site???

Linking Foriegn Keys To Primary
i am trying to connect a foriegn key with a primary there is a for. key textbox and a ref. table textbox when i put in the appropiate info in the textbox and hit change, nothing happens is there a special way to do this?

also how do i input specific information into the attributes ex: human_age = 23

Multiple Fields Linking To One Foreign Key
I have a table that is going to track project info, time, date, people working on the project, materials, etc.

My question is what would be the best way to have multiple fields for the people working on the project, for example this is my current layout (don't laugh too hard):

tbl_washLog (washID*, time, date, crewID**, crewID2**, crewID3**, tailID, paintID)

The crew ID fields need to be foreign keys back to the crewID field in the crew table which is:

tbl_crew (crewID*, firstName, lastName)

(* = Primary Key, ** = Foreign Key)

Is it possible to have crewID, crewID2 and crewID3 all be foreign keys of tbl_crew.crewID? If not, what would be the best way to go about doing this?

MySQL Query Linking OpenCrypt & PhpBB
I understand that this will seem very novice to you all as developers, but I really need some expert eyes on my question because frankly the other forums have offered no real assistance.

I have a customer database system called OpenCrypt installed and running on my website. OpenCrypt has built in features to connect to my mySQL database as to create phpBB accounts similtaneously as general website accounts are created on my website!

Now. I am new to mySQL and am working on getting the correct syntax to work with my phpBB database. The following are my current fields in question:

user_id -> I need these id's to be created sequentially when new rows are added to my table, phpbb_users.

user_regdate -> What date parameters does phpBB read?

Thanks for your help! This is my current simple syntax used to similtaneously add phpBB rows to the table, where %variable% refers to my OpenCrypt fields:

INSERT INTO kylebt_Forums.phpbb_users SET `username` = '%username', `user_password`=MD5('%password%'), `user_email`='%email%'

MSAccess And ODBC Problem Linking Tables
my environment is:
- windows2000 pro.
- Access2000
- mysql 4.1
- MySQL ODBC 3.5.1

When i try to link tables that exist on the mysql db to the access project,
through odbc, the dialog that asks me which tables to link does not appear.
The odbc window vanishes after i select the odbc driver.

Linking To Other Databases

In Access i can link across multiple databases. I can link to an Oracle database and run queries and local make tables. Can I do this in MySQL?

In Access i can link across multiple databases.

I can link to an Oracle database and run queries and local make tables.

Can I do this in MySQL?