Lou Olsten [EMAIL PROTECTED] wrote:
If I'm using mysqldump to dump a database with referential integrity in place, does
MySQL
build the information in such a way that the referenced tables are loaded first to
avoid
invalid inserts into a table with a foreign key in place? I'm trying to
Hi,
Sorry. My english is not so good. :(
I try to explain.
I have table1 :
ID value
--
1 100
1 101
1 102
1 200
2 100
2 300---
2 310 |
3 100 |
|
and
Victor Pendleton wrote:
If you are going to do this, may I suggest starting MySQL with a non
standard port number?
Yeah, right. And a hacker will not perform a portscan? And he will not
recognize a response from that port (e.g. Host 'hostname' is not allowed
to connect to this MySQL server)???
I hope it should work:
Select table1.ID from table1 left join table2 on table1.value=table2.value
where table2.value is null
OR if you want distinct IDs
Select distinct table1.ID from table1 left join table2 on
table1.value=table2.value where table2.value is null
though I didn't test it, if it
Hi,
Thanx the answer! I have tried it, but didn't work correctly.
The result was 1,2,3 :((
Nitin [EMAIL PROTECTED]
2004-04-29 09:54 AM
To: Zoltan Gyurasits/GYO/COMP/[EMAIL PROTECTED]
Michael Stassen [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Hi,
I have found this too. I think it is as a result of a change introduced in
4.0.18. From http://www.innodb.com/ibman.php#InnoDB.history :
MySQL/InnoDB-4.0.18, February 13, 2004
- Do not allow dropping a table referenced by a FOREIGN KEY constraint,
unless the user does SET
You will need root privilege in order to install and start MySQL. After
the installation, you may have to edit some confs to get MySQL to start
automatically at every boot. Thereafter, you can access the database
server be creating a user account for Mysql admin (root), plus unlimited
number
No you don't. Mysql will run perfectly happily as a standard user.
If you're installing from an rpm you will however need root privilege unless
the rpm is configured as relocatable - and the standard mysql ones aren't.
What you need to do is get yourself the source tarball (.gz) and not the
rpm.
The oracle and MySQL create syntax is not completely compabitable. You will
have to identify and correct the errors.
For example text data type in MySQL may need to be either VARCHAR(N) or
CLOB.
...
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 4/28/04 11:37 PM
Per a response from Victoria (thanks, BTW!) I see that I can reload my InnoDB RI's
data by turning off SET FOREIGN_KEY_CHECKS = 0 during the restore. I then tried to go
to the machine where the dumps were going to be restored and set this variable in the
[client] section of my.cnf. But when I
I've solved the problem starting the server using the
option --character-set=dos.
The side effect is that searches become
accent-sensitive.
Best wishes.
--- Ricardo [EMAIL PROTECTED] escreveu: I have a
problem with SELECT DISTINCT if the target
field contains special characters.
Example:
hi Lou,
I believe this is a recent feature so make sure you on on 4.0.18 if
possible, I know is was added before 4.0.14. I am not sure this
works on 3.23.
Ken
- Original Message -
From: Lou Olsten [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 10:38 AM
Subject:
Place the SET FOREIGN_KEY_CHECKS=0 in the beginning of the file that
contains the backup or run this command from the command line before you
import the file.
-Original Message-
From: Lou Olsten
To: [EMAIL PROTECTED]
Sent: 4/29/04 9:38 AM
Subject: [client] var not working
Per a response
Lou Olsten [EMAIL PROTECTED] wrote:
Per a response from Victoria (thanks, BTW!) I see that I can reload my InnoDB RI's
data by
turning off SET FOREIGN_KEY_CHECKS = 0 during the restore. I then tried to go to the
machine where the dumps were going to be restored and set this variable in the
At 10:38 -0400 4/29/04, Lou Olsten wrote:
Per a response from Victoria (thanks, BTW!) I see that I can reload
my InnoDB RI's data by turning off SET FOREIGN_KEY_CHECKS = 0 during
the restore. I then tried to go to the machine where the dumps were
going to be restored and set this variable in
Is there a simple way to determine how fragmented a Innodb table is ?
Thanks,
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 23:28 +0200 4/28/04, Jochem van Dieten wrote:
Ricardo wrote:
Which collation are you using in MS SQL Server? And
in MySQL?
MS SQL Server 8
Collation = Latin1_General_CI_AS
MySQL 4.0.16
character_set = latin1
The charset determines which characters can occur. The collation
determines the sort
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it. Although, i'd like
that the next time i insert a row in this table, it's
index be
At 23:32 +0530 4/28/04, [EMAIL PROTECTED] wrote:
Hi,
I am trying to insert the records in the database. After the insertion of
3millions records, it fails to insert the records further. Can someone help
me in this problem. How do I go and increase the capacity of the database.
Moreover if someone
Hi,
Unless he is having some weird nightmare that doesn't involve reality, then I am
pretty sure he is talking about this in the my.cnf:
innodb_data_file_path = ibdata1:400M:autoextend
A while back I remember that the autoextend was not in the sample my.cnf files. I
think this was around
At 12:27 -0300 4/29/04, Leandro Melo wrote:
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it. Although, i'd like
that the next time i
On Thu, 29 Apr 2004 12:27:46 -0300 (ART)
Leandro Melo [EMAIL PROTECTED] wrote:
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it.
Hello,
I have a table with 3 columns:
mysql desc srv_ref_cities;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| state_id | char(2) | YES | | NULL|
Thanks, Paul. You appear frustrated that I didn't look in the docs first.
I had been to that page (and thoroughly read it) after Victoria's reply.
Prior to the reply, I tried searching but wasn't sure what to search for, so
didn't find what I was looking for. The real gist of my question was:
We are designing a new solution and I have not been able to find
functionality anywhere in the MySQL documentation or literature.
With an Oracle database you can bring up the database, recover what is
needed, all while leaving the listener down. The listener in Oracle
just allows clients to
Will Richardson wrote:
Hello,
I have a table with 3 columns:
mysql desc srv_ref_cities;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| state_id | char(2)
If you are getting table full error,may be your table
size is exceeding the maximum default size allowed.
check the table size and default size.
You can change the maximum size of the table using
Alter table command.
Somthing like following,but it is better so back up
the database before doing
At 12:22 -0400 4/29/04, Lou Olsten wrote:
Thanks, Paul. You appear frustrated that I didn't look in the docs first.
Um, no.
I gave instructions for finding the answer to a question that you were
asking. I don't think that translates into any frustration about your
use of the manual. I didn't
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
A note first. The column establishments is an int(10), as you see I am
taking this number through a formula, and I want the result of this
I think when adding the $ the number gets convert to a string. And then
the query orders it by alpha numberic.
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
A note first. The column
Yoed Anis wrote:
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
Hint: you've made this a string comparison using CONCAT, i.e.,
alphabetical, not numerical, sorting rules apply.
How
At 12:14 -0500 4/29/04, Yoed Anis wrote:
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
A note first. The column establishments is an int(10), as you see I am
taking this number through a
Both of you are right Daniel, and Robert.
I've written a PHP class that tabelizes the query directly and I haven't
built in formatting options. Doing so would make the object more complicated
then I would like it to be, so I wanted to see if there is a mysql solution
to this.
I think I'll end up
If it`s a InnoDB table :-? my case
--- Paul DuBois [EMAIL PROTECTED] escreveu: At 12:27
-0300 4/29/04, Leandro Melo wrote:
Hi,
i got a table wich its pk is an auto_increment
field.
I have 10 elements in this table, wich makes the
pk_id
field = 10.
I inserted incorrectly anoter row in
Paul DuBois wrote:
*snip*
Sounds like you want:
ORDER BY ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2)
Perfect. (I'm saying, duh over here to myself!)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Paul,
I tried doing that in one trial run, and I wasn't getting the $200 figure so
I gave up on that.
It seems like doing an order by that statement wouldn't have given me the
sort I wanted.
Don't know why that is though - in theory you should be right, I can try it
a bit more if your curious.
In the last episode (Apr 29), Sam Peterson said:
We are designing a new solution and I have not been able to find
functionality anywhere in the MySQL documentation or literature.
With an Oracle database you can bring up the database, recover what
is needed, all while leaving the listener
Dear All
I am using ASP. Can anyone give me the connection code to connect to a MySQL
database without using ODBC DSN?
Thanks
Michael Johnson
Director
BPEnet EMEA
Sun iForce Premier Solution, Sales, Change Management Development Partner
Part of the BPEnet Group Limited
13 Austin Friars
London
OK
I've just been completing some benchmarking comparing compiled queries (new
in 4.1.1 and above) with standard parsed queries.
For both INSERT queries insert into table( col1, col2,col3) values(?,?,?)
and SELECT queries select col1, col2,col3 where col1 between ? and ? the
compile query is
ConnectStr = Driver={MySQL ODBC 3.51 Driver};server=;DB=;UID=;PWD=
-Original Message-
From: michael johnson
To: [EMAIL PROTECTED] mysql. com
Cc: Joy Johnson
Sent: 4/29/04 1:33 PM
Subject: Connect string for ASP
Dear All
I am using ASP. Can anyone give me the connection code to connect
You will need to have MyODBC installed. You do not need to create a DSN.
-Original Message-
From: Joy Johnson
To: 'Victor Pendleton'; 'michael johnson '; '[EMAIL PROTECTED] mysql. com '
Sent: 4/29/04 1:50 PM
Subject: RE: Connect string for ASP
I presume I do not need myodbc installed
I want to count the passing and failing scores of a group of tests
so I have a table with a row that describes each test
Each test has a minimum passing score. Each test can be run an
arbitrary number of times so I have a table of scores, which uses
test id as a foreign key.
what I would like
The connection I am trying to make is from a website where the hosting
machine will not have Myodbc installed and the database I am trying to
connect to is on another Internet visible server where MySQL is installed
and myodbc is installed.
-Original Message-
From: Victor Pendleton
hi,
i have a huge database and i want to transfer the data to a file. can i
tranfer the result of a query to a file for eg.
if i say select * from tablename;
it selects all the tables. but the mysql window is small to see all the
records when the database has many records.can i send
On Thu, 29 Apr 2004 16:05:56 -0400 (EDT)
[EMAIL PROTECTED] wrote:
hi,
i have a huge database and i want to transfer the data to a
file. can i
tranfer the result of a query to a file for eg.
if i say select * from tablename;
it selects all the tables. but the mysql
Paul, please see below...
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Lou Olsten [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 1:00 PM
Subject: Re: [client] var not working
At 12:22 -0400 4/29/04, Lou Olsten wrote:
Thanks, Paul. You appear
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything.
Here's what happens:
- Sign in as root on the local host.
- GRANT ALL PRIVILEGES ON *.* TO
In the last episode (Apr 29), Lou Olsten said:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything.
Here's what happens:
- Sign in as
Thanks. Tried it with no luck. Moreover, I get the same results as below
when I try to connect with the mysql client from a different machine.
Really bizarre behavior. I have a 4.1 alpha running at home on my XP box.
I will do some testing there tonight to see if it's something I'm doing
unique
I am using MySQL 4.0.18 and trying to generate a list of the number of row in a table
with the same last name, by last name.
Is there any way to do this without creating another table?
Here is what I am trying:
mysql select count(distinct last_name) as LnameCnt, last_name from table_ABC group
What is the version of your mysql client? If it is pre 4.1 then it is likely being
bitten by the password length change from 4.0.xx to 4.1 from 16bytes to 41bytes.
You'll need to read the note on passwords in the 4.1 docs.
Hope this helps.
--
MySQL General Mailing List
For list archives:
hmmmif you are on the same machine, does it work if you do not specify the '-h
localhost'?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
just drop the 'distinct' - should give you what you want
mysql select count(last_name) as LnameCnt, last_name from table_ABC group by last_name;
hth
steve
[EMAIL PROTECTED] wrote:
I am using MySQL 4.0.18 and trying to generate a list of the number of row in a table with the same last name, by
Dear All
I work on a small application with database support. For development I use
the MySQL database which is just doing fine. During testing I experienced a,
in my opinion, strange bug.
I have the following source code:
Connection conn = p_GetConnectionFromPool();
try {
// Try to
Kevin,
I've been using 4.1.1 since it was released and I've never heard of compiled
queries. Are you talking about prepared statements?
Donny
-Original Message-
From: Kevin Cowley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 1:35 PM
To: [EMAIL PROTECTED] Mysql. Com
I have a program that is using (via a front end library) libmysql. If I set
up a signal handler before I initialize libmysql, my signal handler is not
called when that signal is sent to the process. If I move the line of code
that sets the signal handler to *after* the line that initializes
On Thu, 29 Apr 2004 23:59:05 +0200
Bjoern Wuest [EMAIL PROTECTED] wrote:
Dear All
I work on a small application with database support. For development I use
the MySQL database which is just doing fine. During testing I experienced a,
in my opinion, strange bug.
I have the following
...blind as a bat, it was right in front of me in basic SQL blush.
Thank you kindly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 16:21 -0500 4/29/04, Dan Nelson wrote:
In the last episode (Apr 29), Lou Olsten said:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with
access to everything.
Lou Olsten wrote:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything. Here's what happens:
- Sign in as root on the local host.
- GRANT ALL
Dan Nelson wrote:
In the last episode (Apr 29), Lou Olsten said:
I thought I had a handle on this, but now I'm all screwed up.
MySQL 4.1.1a-alpha-max-debug-log
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access
to everything. Here's what happens:
- Sign
A HUGE thank you to everyone who helped me with this. Everything is working
as expected now. That connection stuff (along with the blank user entry)
got me!!!
Finally, are you really sure you want someone to be able to connect as
(effective) root from *anywhere* on the net? Personally, I
Joshua J. Kugler wrote:
I have a program that is using (via a front end library) libmysql. If I set
up a signal handler before I initialize libmysql, my signal handler is not
called when that signal is sent to the process. If I move the line of code
that sets the signal handler to *after* the
erri wrote:
I'm trying to compile 4.0.18 version on Aix 5.2 ML2 (IBM 7044-270 with Two
cpu Power3-II), with gcc-2.95 with this parameters(note in mysql.com):
CC=gcc -pipe -mcpu=powerpc -Wa,-many \
CXX=gcc -pipe -mcpu=powerpc -Wa,-many \
CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti \
Kevin Cowley wrote:
OK
I've just been completing some benchmarking comparing compiled queries (new
in 4.1.1 and above) with standard parsed queries.
For both INSERT queries insert into table( col1, col2,col3) values(?,?,?)
and SELECT queries select col1, col2,col3 where col1 between ? and ? the
65 matches
Mail list logo