Hello.
I have a problem on ALTER TABLE ... ADD FOREIGN KEY.
I'm using InnoDBs, and I wanna create Foreign Key after table has been created.
But, 'ALTER TABLE .. ADD FOREIGN KEY does not work.
Manual says :
The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything
And in my
Sorry, I missed PARENT's COLUMNs.
Corrects.
ALTER TABLE CONS_CHILD ADD FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES
CONS_PARENT(A, B ) on delete cascade ;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql SHOW
hi guyz
(pardon me fo this loong mail)
my mysql s runnin finally
accepting my user login n all thank heavens
now i m havin a bit of a prob with php myadmin
i found a backup of my last configuartion n i ve copied it on (since the new
one just wouldn work with me)
im gettin all these errors
MySQL performance query.
I've got a puzzle which is as follows:
I've got a new table which I'll be loading with approx 1 million rows per
day. This is being loaded from a C program which seems to work fine.
The table being loaded is as follows:
| Field | Type| Null |
Hi
Is it feasible to use replication to keep the database which powers my
website up-to-date? The database itself is on the hosting companies server
and contacted via dialup so the connection isn't there all of the time.
Naturally I keep a copy of the database on my local machine too.
Alex
Hi,
We are evaluating the storage of document and product information in a
MySQL database.
The product information that is stored will be product structures, that
then will be pointing to the document storage.
Anybody that has implemented such a database?
The first approach is something very
--- Weitergeleitete Nachricht / Forwarded Message ---
Date: Fri, 27 Sep 2002 19:52:25 +0200 (MEST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysqld always shuts down after running mysqld
Description:
hi mysql team,
i am a mysql newbie (my first time i install it)
i give up, i
Hi,
I was having problems because I had to rename my slave sever. Now I think I
understand the problem better. I looked in slave.cc and found my error
message and can see that it only applies to the slave. So I guess that
brings up two issues.
1. Why can't the relay-log deal with the name
In my first posting I had the following problem;
mike@cords-orj86jfje:/usr/bin safe_mysqld
[1] 1759
mike@cords-orj86jfje:/usr/bin cat: /var/lib/mysql/cords-orj86jfje.pid: Permission
denied
rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied
Fatal error: Can't
Sorry, but justs a quick remark on the top:
Have you looked at small and KAPITAL letters?
--
Franz Alt
[EMAIL PROTECTED]
at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23
and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and
php4.2.3. the problem is
Hi,
You indeed have to su to root to get things working.
safe_mysqld as root didn't work because your PATH environment wasn't
correctly set because you didn't use this: su -
su - makes the new shell the user's login shell, resetting environment
variables and reading configuration files to
Since mySQL at this time does not support sub query, Do I've to break this
into 2 SQLs and process:
select question_id from questions where abs_sort_order in (select
min(a.abs_sort_order) from questions a where a.abs_sort_order 1)
Ben
- Original Message -
From: DeNewbie [EMAIL
Dear all,
Hope this question did not disturb you.
I have one linux box with mysql install and working fine. Thank you MySQL.
Due to the information stored into database are really crittical data, I
decide to make another copy of the whole data into another linux box with the
same version of
Just a thought look in your my.ini file and make sure the paths are
correct. I too had this problem but I was upgrading to a binary from an
rpm and that was where my problem was. the my.ini file expected the
paths to be in /var instead of /usr/local.
Hope this helps
John Coder
On Sat,
Ben Goswami wrote:
Since mySQL at this time does not support sub query, Do I've to break this
into 2 SQLs and process:
select question_id from questions where abs_sort_order in (select
min(a.abs_sort_order) from questions a where a.abs_sort_order 1)
Ben
select question_id
from
Hello all,
I have yet to find this bit of information within the documentation. Is it
possible to copy the contents of a table? If so how?
Shaun
mysql, query
-
Before posting, please check:
http://www.mysql.com/manual.php
Check out
http://www.mysql.com/doc/en/mysqldump.html that should help you.
John Coder
On Sat, 2002-09-28 at 13:18, Shaun Bramley wrote:
Hello all,
I have yet to find this bit of information within the documentation. Is it
possible to copy the contents of a table? If so how?
Shaun
I am trying to link with the mysqlclient.lib to prove the myTest program
which comes with MySQL (with VC++ and Windows 2000) and I keep getting
errors like these myTest.obj : error LNK2001: unresolved external symbol
_mysql_list_tables@8
Thanks for your help
Ahora podés usar Yahoo!
select * from table1 insert into table2
both tables need the same structure
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
To where? Another table? More information is required.
- Original Message -
From: Shaun Bramley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 28, 2002 1:18 PM
Subject: Copying a Table
Hello all,
I have yet to find this bit of information within the
Greetings...
It is possible. Say for eg. If you want to copy the structure and data of
the db table in mysql table. you can use the following statement -
create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db`
If you cant to copy only the structure then you can use a query
On Friday, September 27, 2002, at 01:12 PM, Michael T. Babcock wrote:
Dawn Friedland wrote:
Prior to my client requesting that I add Japanese content to the
content
tool database, I had zero experience with characters sets other than
Latin. I always used notepad to filter out any weird
Kirk Samuelson wrote:
I've read lots of similar posts in the archives at
http://lists.mysql.com/. Many suggestions to use a BLOB
instead of a
text field. But MySQL supports double-byte languages. Why not use an
encoding it supports (SJIS or UJIS for Japanese) instead of this
kludge? If
I am a newbie and I have just recently installed MySQL. I am somewhat confused as to
why the tests that I am running from my command prompt are not showing any results yet
I believe that my MySQL server is running;
mike@cords-orj86jfje:~ cd /usr/bin
mike@cords-orj86jfje:/usr/bin su -
Thanks for your help.
But now I am stuck on another part.
I successfully use the script to login , but it does not respond to the
next line of the script which is use import_test1;
The script so far is like this:
./mysql -u 'root' -ppassword
use import_test1;
When it executes, it just
25 matches
Mail list logo