Theory question regarding tables & sql, foriegn keys

> So far I have successful set up tables in mysql > InnoDB > with primary and foriegn keys. Unfortunately I am > having some difficulty in getting the proper results > as I am new to sql and databases. I would be most > grateful if someone took a minute and explained or > helped with the follow

Question regarding tables & sql, foriegn keys

> > So far I have successful set up tables in mysql > > InnoDB > > with primary and foriegn keys. Unfortunately I am > > having some difficulty in getting the proper > results > > as I am new to sql and databases. I would be most > > grateful if someone took a minute and explained or > > helped

Help: Innodb warning operating error number 3

I got this error when I was trying to get INNODB working on my machine: I am using mysql version 4.0.1 alpha = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -

Foreign keys, mysql ??

Below are two tables.. How can table 'regs' populate 'type' from table 'equip'?? $sth=$dbh->prepare (" CREATE TABLE equip ( typevarchar(255), type_id smallint unsigned not null auto_increment, primary key (type_id) ) "); $sth->execute (); $sth->finish

Error with code utilizing perl DBI & mysql ??

This is a bit strange, but I was writing code and adding some select statements that seemed to be working fine until about the 5 th one, ... then i get errors : I am a bit of a newbie at mysql & dbi. any help much appreciated Error: Can’t set DBI::db-HASH(0x1b73b70->{Printerror}: unrecong

with sql select statement from mysql ??

Below code does not print contents of the select sql statement to file ?? When I run a select on the table i get results in the dos shell. All the code below does is print column names and nothing more ?? code: open(file,">C:/perl/bin/mysql.txt") or warn "did not open file\n"; undef $sql; $sq

mysql_install_db problem

I am running mysql on windows 98 & could not get the mysql_install_db to work. Anyone familar with this problem or know a way around? I checked the folder 'scripts' but did not see mysql_install_db in there ??? thanks in advance = Regards, Investorclb

Trying to get website set up

I have apache running on a windows 98 machine and I just installed mysql on it. Also I use perl 5.6. However this is for local testing. I need to go online with my website soon. I was wondering if it is possible to use this setup to get a mysql db driven website going, then send it to a linux

user / pwd access to db driven website

HI all, I would be extremely appreciative with solution suggestions to the problem I am having. I really could use some help right now !! I am trying to get a database driven website up and running that has some amount of security on it (which i intend to make progresively better). It needs us

RE: ms acess to mysql-More information

ss, but can't get it > to work. Anybody have > > any experience with this? > > > > I know about the "Port 3306", I know about the > wildcard permissions to > > access MySQL from any domain, but still can't get > it to work... > > > > &

ms access to mysql, anyone familar with this?

I need to convert ms access to mysql. Has anyone done this successfully ?? thanks = Regards, Investorclb __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -

Re: ms acess to mysql

I found an article at www.devshed.com/Server_Side/MySQL/ODBC/page1.html about access and mysql --- Duncan Hill <[EMAIL PROTECTED]> wrote: > On Fri, 4 Jan 2002, Investor wrote: > > > Has anyone converted data in MS Access to Mysql? > > > > I would think

ms acess to mysql

Hi, I am new to mysql and this list. Has anyone converted data in MS Access to Mysql? I would think this is possible!! What would you recommend to enter data into Mysql, For example if someone entering the data is not mysql proffecient. Could they enter data into a form or something, then I