On Feb 28, 2008, at 2:06 PM, Rob Wultsch wrote:
What you are probably wanting is a join, but how does adminAll relate
to current?
adminAll will be for the administrators of my program to log into so
instead of getting redirected automatically to a certain table
(current.tableName in this case) they get a list of available tables
in the database (adminAll.displayTableName) so that I don't have to
have a separate admin login for each database I setup with my program.
Generally it is a good idea to have the column that
relates the tables (read http://en.wikipedia.org/wiki/Foreign_key if
you want to work at a much high level ) have the same column name if
possible (IMHO).
the column name won't be an issue since I'm writing it all from
scratch :) making it the same name to help improve readability between
the tables in the database I'm assuming?
In the example I sent I had a column in both tables
name t2_id. Take a look at http://www.w3schools.com/sql/sql_join.asp
for simple joins. The syntax in the first couple examples (without
using JOIN) is a good idea to avoid (also IMHO) .
I will look at those as soon as I'm done sending this e-mail! Thank you
The new table you sent is good, but it is more ideal to remove
unnecessary columns and make the table /column names generic.
Can I ask why? So far, everything I have done with MySQL would seem to
suggest setting column names so it makes sense what info is stored in
it? (IE: First Name would go into FName or firstname or namefirst or
something like that)
On Thu, Feb 28, 2008 at 11:49 AM, Jason Pruim <[EMAIL PROTECTED]>
wrote:
On Feb 28, 2008, at 1:29 PM, Rob Wultsch wrote:
On Thu, Feb 28, 2008 at 10:59 AM, Jason Pruim <[EMAIL PROTECTED]>
wrote:
Hi Everyone,
I am attempting to write a PHP application that reads info from a
MySQL database, and I'm wondering if I can set up a column in one
table that gets it's info from a field in another table
automatically?
Ie:
Table1:
field1
field2
field3
Table2:
field4
field5
field6 = field1
Does that make sense? Would that be a join? Or maybe a primary key?
I'm new to MySQL programming so RTFM's are appreciated as long as
"M"
is defined :)
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
Tip for future questions:
Figure out the simplest way to present the question and include the
SQL to create the relevant tables.
Next explain what you want, any non working sql you have, and lastly
give an example result of correct output.
Hi Rob, I will do this in the future, thank you.
And to that end:
CREATE TABLE `current` (
`customerName` varchar(30) default NULL,
`customerBusiness` varchar(30) default NULL,
`loginName` varchar(30) default NULL,
`loginPassword` varchar(32) default NULL,
`tableName` varchar(20) default NULL,
`email` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `adminAll` (
`dispalyTableName` varchar(20) default NULL,
`adminLevel` int(10) default NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1
What I want, is displayTableName on table adminAll to grab it's info
from tableName in current. Does that make more sense?
Example:
So lets say I have two tables:
CREATE TABLE `t1` (
`t1_id` int(10) NOT NULL auto_increment,
`t1_data` varchar(255) NOT NULL default '',
`t2_id` int(10) NOT NULL default '0',
PRIMARY KEY (`t1_id`),
KEY `t2_id` (`t2_id`)
);
CREATE TABLE `t2` (
`t2_id` int(10) NOT NULL auto_increment,
`t2_data` varchar(255) NOT NULL default '',
PRIMARY KEY (`t2_id`)
);
I want to show all the information in t1 and any information in t2
where the t1.t2_id is equal to t2.t2_id.
Output should be like:
t1_id,
t1_data,
t2_data
*Answer*
I really am not sure what you were asking, but take a look at this
query for the table structure above.
SELECT t1_id, t1_data, t2_data
FROM t1
INNER JOIN t2 USING(t2_id)
*Better answer*
Go buy an introductory book on sql. Read through a couple examples.
( http://www.w3schools.com/sql/default.asp is also very good)
I have been working with MySQL in various degrees for the past few
years, I've just never needed to grab info from another table and
import it to a different table.
My Main area of expertise is in web design (mostly HTML and CSS) and
some PHP.
From the above question you probably do not know enough to tread
water
in the very excellent MySQL manual.
From my original post:
"Does that make sense? Would that be a join? Or maybe a primary
key?
I'm new to MySQL programming so RTFM's are appreciated as long as
"M"
is defined :)"
--
Rob Wultsch
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
--
Rob Wultsch
(480)223-2566
[EMAIL PROTECTED] (email/google im)
wultsch (aim)
[EMAIL PROTECTED] (msn)
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
