Lew E. Lefton wrote:
Hi,
I hope this is an appropriate place to ask this question, if you think
it is better suited for another list/forum, please let me know.
I have a table that looks like this:
mysql select polynomial_id, term_id from polynomial;
+---+-+
|
Hi,
I hope this is an appropriate place to ask this question, if you think it
is better suited for another list/forum, please let me know.
I have a table that looks like this:
mysql select polynomial_id, term_id from polynomial;
+---+-+
| polynomial_id | term_id |
Lew,
If I have another polynomial, say the sum of terms 1,3,4, and 5, how
can I quickly search this
database to see if it's already been stored?
SELECT DISTINCT polynomial_id
FROM polynomial p1
INNER JOIN polynomial p2 ON p1.term_id=1 AND p2.term_id=3
INNER JOIN polynomial p3 ON p2.term_id=3
2006/5/31, Peter Brawley [EMAIL PROTECTED]:
Lew,
If I have another polynomial, say the sum of terms 1,3,4, and 5, how
can I quickly search this
database to see if it's already been stored?
SELECT DISTINCT polynomial_id
FROM polynomial p1
INNER JOIN polynomial p2 ON p1.term_id=1 AND
This is my first trigger I'm trying to write.
I have two tables. 'stores' and 'zipcodes'.
I want to automatically set the latitude and longitude of the store using
it's zipcode lookup in the zipcode table.
DELIMITER $$;
DROP TRIGGER `store_coord`$$
create trigger `store_coord` BEFORE INSERT
Daevid,
This is my first trigger I'm trying to write.
I have two tables. 'stores' and 'zipcodes'.
I want to automatically set the latitude and longitude of the store using
it's zipcode lookup in the zipcode table.
DELIMITER $$;
DROP TRIGGER `store_coord`$$
create trigger `store_coord`
Hello everyone!
The mysql documentation doesn't show any good infos er examples about
writing procedures.
To be more specific:
I have a table with saved clicks by users.
Now i want to draw a graph with a php extension.
Problem is: if i let me show the clicks, one day is missing.
Because on
Hi Comunity,
I need some help from you. In replication i want to update old binary files,
but server is not updating old files. It is updatin only current using
binarylog only.
The scenario is, my master is updating log-5 file(say) and slave is reading
data from it, and updating itself to
Hello everyone!
The mysql documentation doesn't show any good infos er examples about
writing procedures.
To be more specific:
I have a table with saved clicks by users.
Now i want to draw a graph with a php extension.
Problem is: if i let me show the clicks, one day is missing.
Because on
You cannot get data out of a database if it's not in the database. If
there's no data for a day, you cannot get 0 for that day, because the
day does not exist in the database. You could make a calendar
table, one row per day, and join it with a count to get 0 for the day.
-Sheeri
On 5/15/06,
I've had this same problem -- if the database loses connection at the
same time the log file flushes, you need to SET MASTER_LOG_FILE and
MASTER_LOG_POS again and restart. I believe this probably qualifies
as a bug if you want to report it.
The reason the slave isn't updating log5 is because
Barry wrote:
Hello everyone!
snip
I have a table with saved clicks by users.
Now i want to draw a graph with a php extension.
Problem is: if i let me show the clicks, one day is missing.
Because on that day noone clicked on the link.
I use this query:
SELECT DATE(c_clicktime) AS clicktime,
This is my first trigger I'm trying to write.
I have two tables. 'stores' and 'zipcodes'.
I want to automatically set the latitude and longitude of
the store using
it's zipcode lookup in the zipcode table.
DELIMITER $$;
DROP TRIGGER `store_coord`$$
create trigger
May 2006 2:41 p.m.
To: 'Martijn Tonies'; mysql@lists.mysql.com
Subject: RE: Need help with triggers
This is my first trigger I'm trying to write.
I have two tables. 'stores' and 'zipcodes'.
I want to automatically set the latitude and longitude of
the store using
it's zipcode lookup
Daevid,
This is my first trigger I'm trying to write.
I have two tables. 'stores' and 'zipcodes'.
I want to automatically set the latitude and
longitude of the store using
it's zipcode lookup in the zipcode table.
DELIMITER $$;
DROP TRIGGER `store_coord`$$
create trigger
hi,
Just to add up i have read some where ( i assume in the mailing list
only) that OS recognizes the file based on few codes added at the
starting / ending of a file. So there are ways to create a MYD file
through vi editor as well (this is not from the angle of restoring the
data in that
*Ok Daniel,*
**
* Thank you.*
**
*regards,*
*bala*
**
Hi,
please tell me the server uptime and also the master logs as
show master logs;
in mysql prompt.
Yes u can restore data from the binlog if you have the binlogs.
balaraju mandala wrote:
Hi Dilip,
it means i loosed the data, correct Dilip. is there any other way to gain
that data, any
Hi Dilip,
I got two binary logs in Server. I don't know how to find server uptime?
mysql show master logs;
+--+
| Log_name |
+--+
| localhost-bin.08 |
| localhost-bin.09 |
+--+
2 rows in set (0.00 sec)
if i ask for
On 5/9/06, balaraju mandala [EMAIL PROTECTED] wrote:
Hi Dilip,
I got two binary logs in Server. I don't know how to find server uptime?
mysql show master logs;
+--+
| Log_name |
+--+
| localhost-bin.08 |
| localhost-bin.09 |
Thank you Daniel for reply.
Just in curiocity i want ask u, how u r taking daily backups, just using
'mysqldump' or using any Tools.
regards,
bala
On 5/9/06, balaraju mandala [EMAIL PROTECTED] wrote:
Thank you Daniel for reply.
Just in curiocity i want ask u, how u r taking daily backups, just using
'mysqldump' or using any Tools.
I'm using mysqldump plus bzip2 to compress data for about 2 years now.
Tried many tools, mysqldump
Dear Comunity,
I need your help. I accidently deleted some '.MYD' files. I want to restore
them, without stopping the running server. how i can do this. i am using
Linux OS, i tried to create file using --- vi tablename.MYD(a blank file)
but it is not accepted by MySql.
regards,
bala
Hi,
If you have deleted .MYD files then truncate the table and restore it
from the backup if yu have.
MYD means your precious data which contains.
balaraju mandala wrote:
Dear Comunity,
I need your help. I accidently deleted some '.MYD' files. I want to
restore
them, without stopping
Hi Dilip,
it means i loosed the data, correct Dilip. is there any other way to gain
that data, any binary logs etc?
regards,
bala
On 4/26/06, Shawn Green [EMAIL PROTECTED] wrote:
--- Patrick Aljord [EMAIL PROTECTED] wrote:
On 4/26/06, Patrick Aljord [EMAIL PROTECTED] wrote:
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table conf_ip like this:
id int 5
--- Patrick Aljord [EMAIL PROTECTED] wrote:
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table conf_ip like this:
id int 5 auto_increment primary key;
conf_id int 5; ==foreing key of confs
ip varchar 150;
I would like to
select id,
On 4/26/06, Patrick Aljord [EMAIL PROTECTED] wrote:
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table conf_ip like this:
id int 5 auto_increment primary key;
conf_id int 5; ==foreing key of confs
ip varchar 150;
ok, sorry all for not being
--- Patrick Aljord [EMAIL PROTECTED] wrote:
On 4/26/06, Patrick Aljord [EMAIL PROTECTED] wrote:
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table conf_ip like this:
id int 5 auto_increment primary key;
conf_id int 5; ==foreing key
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table conf_ip like this:
id int 5 auto_increment primary key;
conf_id int 5; ==foreing key of confs
ip varchar 150;
I would like to
select id, conf from confs where ip!='some val';
how can I do this?
: Patrick Aljord [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, April 25, 2006 8:48 PM
Subject: need help for my jointure
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table conf_ip like this:
id int 5 auto_increment primary key;
conf_id
hey all,
I have a table mytable that looks like this:
id tinyint primary key auto_increment
row1 varchar 150
row2 varchar 150
I would like to remove all duplicates, which means that if n records
have the same row1 and row2, keep only one record and remove the
duplicates. Any idea how to do this?
Sample Data:
ID-Row1-Row2
1-A-B
2-A-B
Row1 and Row2 are duplicate, so you only want one. Which ID do you want?
-will
On 4/17/06, Patrick Aljord [EMAIL PROTECTED] wrote:
hey all,
I have a table mytable that looks like this:
id tinyint primary key auto_increment
row1 varchar 150
row2
If the ID doesn't represent anything, you can
CREATE TABLE new_table SELECT DISTINCT Row1, Row2 FROM old_table
And then recreate your index(es).
All your autoincrement IDs will be changed.
On 4/17/06, Patrick Aljord [EMAIL PROTECTED] wrote:
On 4/18/06, William Fong [EMAIL PROTECTED] wrote:
why cant i get this to sum ???
?
$link = mysql_connect(localhost,root,goobers) or
die(mysql_error());
mysql_select_db(workorder, $link);
$result = mysql_query(SELECT SUM(`ElecRem`) AS
total FROM orders, $link);
- Original Message -
From: Brian E Boothe [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, April 14, 2006 5:09 AM
Subject: arrg need help summing Colum's
why cant i get this to sum ???
?
$link = mysql_connect(localhost,root,goobers) or
die(mysql_error
I don't think your code should work anyway, you should really check PHP
manual to get this work. mysql_query doesn't actually return the result, but
a resource id that can be used with mysql_fetch_xxx functions. Try this :
$link = mysql_connect(localhost,root,goobers) or die(mysql_error());
clint lenard wrote:
Hey Guys,
I was wondering if I could get some assistance with building a
Simple Import Script using PHP and MySQL. Basically I'm trying to pull
info out of one Table and Insert it into the other Table.
Can anyone show me a simple example of this? I can figure out how to
Hey Guys,
I was wondering if I could get some assistance with building a
Simple Import Script using PHP and MySQL. Basically I'm trying to pull
info out of one Table and Insert it into the other Table.
Can anyone show me a simple example of this? I can figure out how to
do the rest if I had a
That SQL 101.
It's a basic INSERT / SELECT.
http://dev.mysql.com/doc/refman/4.1/en/insert-select.html
Scroll down for the examples.
-Original Message-
From: clint lenard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 8:54 PM
To: mysql@lists.mysql.com
Subject: Need help
, 8 Mar 2006, clint lenard wrote:
To: mysql@lists.mysql.com
From: clint lenard [EMAIL PROTECTED]
Subject: Need help with a Basic Query.
Hey Guys,
I was wondering if I could get some assistance with building a
Simple Import Script using PHP and MySQL. Basically I'm trying to pull
info
I have a customer who has been in production for a few weeks now having
converted from MyISM to INNODB. We have been experiencing a few problems
with our application. With that said, could you take a look at the info
below from my show INNODB status and let me know if you see any problems
based
What are the problems you've been experiencing? Did you convert all tables?
How big is the database?
On 2/9/06, Shaun Adams [EMAIL PROTECTED] wrote:
I have a customer who has been in production for a few weeks now having
converted from MyISM to INNODB. We have been experiencing a few problems
tables
http://www.innodb.com/order.php
- Original Message -
From: Shaun Adams [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, February 10, 2006 5:58 AM
Subject: Need help configuring INNODB (Customer is ready to sue)
--=_NextPart_000_00F7_01C62DCC.4BFFEE40
Content
Hi,
I am using Pro*c to connect to oracle and get the results. All I want to
do is send a query as parameter and get the results in some two dimensional
character, Oracle Pro*c does not provide enough flexibility with its EXEC FETCH
variable which forces use to declare variables to fetct
Vinay [EMAIL PROTECTED] wrote on 02/07/2006 09:28:05 AM:
Hi,
I am using Pro*c to connect to oracle and get the results. All
I want to do is send a query as parameter and get the results in
some two dimensional character, Oracle Pro*c does not provide enough
flexibility with its EXEC
I am running mysql 4.0.24 on Debian sarge.
I have a table with two columns, team and division, both varchar(255).
There are some errors in the table where division has a value but team is
blank. Given that I am getting new data, and the data entry folks may create
a record with a blank
Mark Phillips wrote:
I am running mysql 4.0.24 on Debian sarge.
I have a table with two columns, team and division, both varchar(255).
There are some errors in the table where division has a value but team is
blank. Given that I am getting new data, and the data entry folks may create
a
On Monday 23 January 2006 03:33 pm, Michael Stassen wrote:
Mark Phillips wrote:
I am running mysql 4.0.24 on Debian sarge.
I have a table with two columns, team and division, both varchar(255).
There are some errors in the table where division has a value but team is
blank. Given
OK, turns out this was a two fold issue.
The server I was on had 4.0 mySQL, which was severely limited in it's
abilities to use subqueries. The server has since been update to the 4.1
series, and now the following 2-subquery query work just fine.
SELECT firstname, lastname, B.playerid,
How do I simply find out who the bubble is now in my db now that we track more than 1 $0 person. I need just the person
with $0 in the amount column with the lowest Place for each date.
I can iterate through it all if needed in PHP, but I am always looking to learn
more SQL tricks.
I am
Thanks for your kind words of opinion, if you feel you have a better
way please do go ahead , i am going to show you the sql i ended up
using which was a union to append the current summary at the end, i
then had to use php afterwards to add up the totals as i was getting
unexpected results
Dan Rossi [EMAIL PROTECTED] wrote on 12/29/2005 07:19:13 AM:
Thanks for your kind words of opinion, if you feel you have a better
way please do go ahead , i am going to show you the sql i ended up
using which was a union to append the current summary at the end, i
then had to use php
mysql@lists.mysql.com
Sent: Tuesday, December 27, 2005 4:34 PM
Subject: Need Help Writing a Trigger
I'm trying to write a trigger that will update the age of a camper when
ever a record is updated or inserted. I have a table named Campers which
contains basic information about the camper as well
PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Tuesday, December 27, 2005 4:34 PM
Subject: Need Help Writing a Trigger
I'm trying to write a trigger that will update the age of a camper
when ever a record is updated or inserted. I have a table named
Campers which contains basic
You seem to be coming at SQL with a COBOL perspective. Views are something
you typically create just once and they stay updated automatically. They
work like tables not like queries. Assigning variables to each column of a
view doesn't make any sense (in the SQL sense of view) as each column
,
Jesse
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Jesse [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, December 28, 2005 10:20 AM
Subject: Re: Need Help Writing a Trigger
Jesse,
Therefore, instead of putting that long calculation in my query
]
To: Jesse [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, December 28, 2005 10:20 AM
Subject: Re: Need Help Writing a Trigger
Jesse,
Therefore, instead of putting that long calculation in my query every
time,
I'm looking for a simpler solution, a more automatic one
]
To: Jesse [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, December 28, 2005 1:48 PM
Subject: Re: Need Help Writing a Trigger
Jesse,
BTW, is there a way to change this function so that it does away with the
today variable, and uses a field from a different database? For
instance
Um, thast exactly right each select is a list of results , i want to
merge them then manipulate the data after putting them into a view,
maybe a temp table is needed for this but i dont really want to do an
entire create table statement aswell :\
On 29/12/2005, at 2:48 AM, [EMAIL PROTECTED]
Btwi dont want the column of a view to be a variable, i think thats
what it thinks ! Im just needing to send the value of the current
primary key field top a sub query !
Read my latest post if i can get around not using variables, and still
manage to get the right values of a current row
I just tried to create a Function or Stored Procedure instead of making
variables but it didnt even let me do this
CREATE FUNCTION test (customerID, month, producerID)
RETURN SELECT SUM(fu.bandwidth) FROM feed_usage fu WHERE
fu.customerID=customerID AND fu.month=month AND fu.feedID IN (SELECT
Dan,
You need to shoot your SQL tutor. Whoever taught you to write aggregate
queries seriously took your money. You DO NOT need to use subqueries to do
what you want to do. You do not need to write a full CREATE TABLE
statement to create a temporary table (see other response). You do not
need
I'm trying to write a trigger that will update the age of a camper when ever
a record is updated or inserted. I have a table named Campers which
contains basic information about the camper as well as their birthday. I
have another table named Config which holds various settings, including the
On Tuesday 27 December 2005 2:34 pm, Jesse wrote:
I'm trying to write a trigger that will update the age of a camper when
ever a record is updated or inserted. I have a table named Campers which
contains basic information about the camper as well as their birthday. I
have another table named
Hi there i am trying to use usewr variables in a select statement to
add to a where clause in a sub query. Ie
select @id:=id,@month:=month, (select SUM(totals) from table where
[EMAIL PROTECTED] and [EMAIL PROTECTED]) as totals from table
its happened on other occasions ie with calculations
Dan Rossi [EMAIL PROTECTED] wrote on 12/27/2005 11:39:57 PM:
Hi there i am trying to use usewr variables in a select statement to
add to a where clause in a sub query. Ie
select @id:=id,@month:=month, (select SUM(totals) from table where
[EMAIL PROTECTED] and [EMAIL PROTECTED]) as totals
I have an unfinished query, i am trying to test, basically im required
to get the value of the current field in a row and use it for a
subquery in that row :| Its not a working query, and im not asking for
someone to fix it, however as u can see i need to send the customerID
and month to the
Mark Phillips wrote:
David,
This is what I got:
[EMAIL PROTECTED]:~$ aliases
bash: aliases: command not found
Your shell is bash, so the correct command is `alias`.
[EMAIL PROTECTED]:~$ which mysql
/usr/bin/mysql
Since you are using bash, it's a better idea to use `type` instead of
Here are the results of alias and type
[EMAIL PROTECTED]:~$ alias
alias ls='ls --color=auto'
[EMAIL PROTECTED]:~$ type mysql
mysql is /usr/bin/mysql
And for the emily account:
[EMAIL PROTECTED]:/home/mark$ alias
alias ls='ls --color=auto'
[EMAIL PROTECTED]:/home/mark$ type mysql
mysql is
You will experience the same problem with old-client vs. new-server
authentication as you did when you first set up your user accounts for 4.1
but other than that , it should be compatible.
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
Shawn Green
Database Administrator
Unimin
Hello.
In my opinion, if it works in general with 5.0. MySQL tries to keep
backward compatibility for its products as much as possible. So it
should work, however, not all features of 5.0 could be available. MyODBC
3.51.12 is suitable for use with any MySQL version including MySQL 4.1
or
Hi,
I am presently using MySQL ODBC driver version 3.51.06 with MySQL 4.1.
Now I need to upgrade the MySQL to latest i.e 5.0.17. Can I still use
the old ODBC driver (3.51.06) with the latest MySQL?
Thanks in advance.
Regards,
Abdul Rasheed.
The information contained in this
I have the following setup - mysql 4.0.24 running on Debian Linux stable.
I set up a user 'mark' with a password. When I log into my Linux box as user
'mark', I cannot connect to mysql - I get this funny error message:
[EMAIL PROTECTED]:~$ mysql -h localhost -u mark -p
mysql: unknown option
Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:02 PM
To: MYSQL List
Subject: Need Help Connecting
I have the following
:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:02 PM
To: MYSQL List
Subject: Need Help Connecting
I have the following setup - mysql 4.0.24 running on Debian Linux
stable.
I set up a user 'mark' with a password. When I log into my Linux box as
user
'mark', I cannot connect to mysql - I
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:21 PM
To: mysql@lists.mysql.com
Cc: Logan, David (SST - Adelaide)
Subject: Re: Need Help Connecting
David,
How do I do that?
Thanks
8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:21 PM
To: mysql@lists.mysql.com
Cc: Logan, David (SST - Adelaide)
Subject: Re: Need Help Connecting
David,
How do I do that?
Thanks!
Mark
On Wednesday 21
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:36 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Need Help Connecting
David,
This is what I got:
[EMAIL
Hi,
I am using Mysql
4.1.15(mysql-standard-4.1.15-sun-solaris2.8-sparc-64bit)on
a solaris machine. My application is running on
weblogic8.1 sp2.
I have configured the mysql connection pool on
weblogic and tested from configuration wizard. I am
facing issues when connecting to Mysql pool from my
Hello.
You may use these queries:
select flight_id
,baseline*tan(radians(angle)) as attitude
from flights
where (baseline*tan(radians(angle))) =
( select max(baseline*tan(radians(angle)))
from flights f2);
I have a table with several columns. The ones of interest are flight_id,
angle, and baseline. I want to find the flight_ids for the flights with the
maximum and minimum altitudes, where altitude=baseline*tan(radians(angle)).
For example,
Flights
+++---+
Oops, I meant to copy the list on this reply so that others could
benefit
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Mark Phillips [EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 6:19 PM
Subject: Re: Need Help with a query
- Original Message
I forgot to copy the list as well
Mark
-- Forwarded Message --
Subject: Re: Need Help with a query
Date: Sunday 11 December 2005 06:47 pm
From: Mark Phillips [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Rhino,
My apologies for leaving out the version of mysql. I agree
Hi,
I keep getting errors on this query and I'm not sure
why. I'm using mysql version 4.0.22.
Any ideas?
SELECT pn_coupons_store.store_name,
pn_coupons_store.store_name_short,
pn_coupons_coupons.store_id,
pn_coupons_coupons.coupon_id,
pn_coupons_dealtype.dealtype_name,
For me, it looks as if you confused the order of join and where. It should be:
select ... from ... join ... where ... order by ...
Stefan
Am Sunday 23 October 2005 13:21 schrieb Grant Giddens:
Hi,
I keep getting errors on this query and I'm not sure
why. I'm using mysql version 4.0.22.
--- Kishore Jalleda [EMAIL PROTECTED] wrote:
check the permissions on the mysql data dir, may be
the user mysql or
who ever runs mysql does not have sufficient
privileges
Kishore Jalleda
I agree with Kishore, to elaborate his answer a little
longer I would ask the following.
- is
ps, I meant to delete the note from my draft
folder... sorry
Enrique Sanchez.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often easier to fight for one's ||We live in the outer space
--
Philippe Poelvoorde
COS Trading Ltd.
+44.(0)20.7376.2401
---BeginMessage---
Hi,
Good day!
I read the forum in this link http://archives.neohapsis.com/archives/mysql/2005-q2/1532.htmland somehow I guess you people had tried programming MySQL in C successfully. I just hope that I can
getting during the compilation. There is a win32 specific list, which
might be a better place for you letter:
http://lists.mysql.com/win32
Philippe Poelvoorde wrote:
Subject:
MySQL in C - I need help
: need help with foreign keys, new to mysql
Sorry to reply to my own message, but I meant to add that you can read about
defining foreign key constrints in the manual
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html.
[jg.] thanks, this is what I originally based my command off
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote:
CREATE TABLE `journal` (
`journal_id` int(10) unsigned NOT NULL auto_increment,
`journal_category` int(10) unsigned NOT NULL default '1',
`journal_datetime_created` timestamp NOT NULL default CURRENT_TIMESTAMP,
Pat Adams wrote:
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote:
CREATE TABLE `journal` (
`journal_id` int(10) unsigned NOT NULL auto_increment,
[snip]
CREATE TABLE comments
(
comment_id INT,
comment_journal_id INT,
INDEX jrn_id (journal_id),
Here you are defining an index
Wow, thanks both of you. It worked... =)
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: August 24, 2005 9:17 AM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Re: need help with foreign keys, new to mysql
Pat Adams wrote:
On Wed, 2005-08-24 at 06:11
i am logged in as root
-JG.
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: August 19, 2005 10:35 PM
To: John Gonzales
Cc: mysql@lists.mysql.com
Subject: Re: need help with foreign keys, new to mysql
check the permissions on the mysql data dir, may be the user
Yes but is the MySQL daemon running as root? I hope it isn't...
Jasper
John Gonzales wrote:
i am logged in as root
-JG.
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: August 19, 2005 10:35 PM
To: John Gonzales
Cc: mysql@lists.mysql.com
Subject: Re: need
honestly... i don't even know. =( i'm new to mysql...
how would i check?
-jg
-Original Message-
From: Jasper Bryant-Greene [mailto:[EMAIL PROTECTED]
Sent: August 20, 2005 2:18 AM
To: mysql@lists.mysql.com
Subject: Re: need help with foreign keys, new to mysql
Yes but is the MySQL
Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit :
Hi John,
#1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150)
I've seen this error before.
now before i go and do something stupid, i thought i might ask for some help
on this issue :D both my blog and
.
-Original Message-
From: Thurgood Alex [mailto:[EMAIL PROTECTED]
Sent: August 20, 2005 3:22 AM
To: John Gonzales
Cc: mysql@lists.mysql.com
Subject: Re: need help with foreign keys, new to mysql
Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit :
Hi John,
#1005 - Can't create table
John Gonzales wrote:
i am creating my own little blog and i am trying to create a comments table
that uses the primary key of my blog table as a foreign key. i've tried the
only two ways that i know how and both ways yielded the same error:
#1005 - Can't create table '.\mydatabase\comments.frm'
201 - 300 of 912 matches
Mail list logo