In mysql 4.1 (and since mysql 4.0.14 or something like that) I believe
it's documented that an insert into X select * from X should work.
It's not working for me on MySQL 4.1.0 alpha, anyone else have this
problem? is it a bug? I haven't found any other reports of this not
working for anyone
I have a user who unfortunately named one of his tables order. He also
has table names with a dash in them. mysqldump is unable to dump the
order table and I'm unable to use the ALTER command on it and the tables
with the dashes in their names to rename them. Is there any way to quote
the table
Mark Matthews wrote:
MySQL doesn't have schemas (currently). They are being developed in a
future version. The DatabaseMetaData interface in JDBC has a method,
'getSchemaTerm' which tells you whether a certain database supports
schemas or not (returning when schemas are not supported). MySQL
Hi all,
We want to migrate to MySQL, and because of its speed, we want to use
MyISAM db. I plan to write code as an alternate transaction mechanism.
But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like).
In PL/SQL it is possible to use in your stored procedures
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote:
Hi all,
We want to migrate to MySQL, and because of its speed, we want to use
MyISAM db. I plan to write code as an alternate transaction mechanism.
But I have read that MySQL version 5 supports Stored Procedures (PL/SQL
Excuse me,
I get an automatic reply from the mailinglist that my message wasn't send
so I send it again.
regards
hans
At 23:50 28-9-03 -0700, you wrote:
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote:
Hi all,
We want to migrate to MySQL, and because of its speed, we want to
Try putting the name inside of backticks;
From the Manual:
6.1.2 Database, Table, Index, Column, and Alias Names
---
Note that if the identifier is a restricted word or contains special characters you
must always
quote it with a
I did the following (not much different):
CREATE TABLE `foo` (
`pri_1` INT UNSIGNED NOT NULL,
`pri_2` INT UNSIGNED NOT NULL,
`pri_3` INT UNSIGNED NOT NULL,
`test_data` VARCHAR(120) NOT NULL,
PRIMARY KEY (`pri_1`, `pri_2`, `pri_3`)
) TYPE = InnoDB;
Regards,
Ritter
--
Jason k Larson
Greetings,
I use WinXP and MySQL.
I have a customer table, which contains about 200 records.
Now I want to print all the records of the table out. How can I achieve
that?
Can I send them to a .doc OR .txt file before printing?
cheers,
feng
--
MySQL General Mailing List
For list
http://www.mysql.com/doc/en/SELECT.html
Look at INTO OUTFILE for what you need.
Simon
-Original Message-
From: Wang Feng [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 08:54
To: [EMAIL PROTECTED]
Subject: Newbie Q: how to send the records of a table to a file and then
print them out?
Hi
In mysql 4.1 (and since mysql 4.0.14 or something like that) I
believe it's documented that an insert into X select * from X should
work.
IIRC, the table you're INSERTing into cannot be the same table you
SELECT from - you're trying to take records from the table 'foo' and
insert them
Rusty Wright [EMAIL PROTECTED] wrote:
I have a user who unfortunately named one of his tables order. He also
has table names with a dash in them. mysqldump is unable to dump the
order table and I'm unable to use the ALTER command on it and the tables
with the dashes in their names to rename
Tedman Leung [EMAIL PROTECTED] wrote:
In mysql 4.1 (and since mysql 4.0.14 or something like that) I believe
it's documented that an insert into X select * from X should work.
It's not working for me on MySQL 4.1.0 alpha, anyone else have this
problem? is it a bug? I haven't found any
Hello,
I am installing mysql 4.1.0 rpm on SuSE 8.2.
I am logged in as root and run the rpm command as follows:
rpm -Uvh MySQL-server-4.1.0-0.i386.rpm
The script completes but gives two errors. The errors in mysql_install_db
are on lines 166 and 383.
Both lines are the same:
if test $in_rpm
Hello
Everybody,
With reference to the above
subject we would like to inform you that we are one of the leading companies
specializing in providing the IT consulting / IT staff augmentation business. We
are based at London and have our offices with
support centers in USA,
India and UAE.
Access denied for user: '@localhost' to database 'database'
I have a database named 'database' and i got this problem while trying to
get it run. I am connecting that database to localhost without user and
password, it works just fine on my previous windows box, but since lately
when i move it
Hassan Schroeder [EMAIL PROTECTED] wrote:
Is there a problem with 'IF NOT EXISTS' in the following scenario?
This statement creates the table as expected ...
CREATE TEMPORARY TABLE IF NOT EXISTS
showcase (
PRIMARY KEY (product)
)
SELECT product
I think this should be reported as a BUG for version 4.1
Below is a small text retreived from the URL
http://www.mysql.com/doc/en/INSERT_SELECT.html
---
Prior to MySQL 4.0.14, the target table of the INSERT statement cannot
appear in the FROM clause of the SELECT part of the query. This
Hi group?
Suppose I run a query by mistake that for example deletes my records.
Is there a way to go back to a previous state?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50
`TableNamesOr FieldNames`
- Original Message -
From: Kelley Lingerfelt [EMAIL PROTECTED]
To: Rusty Wright [EMAIL PROTECTED]; Mysql List
[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 09:10
Subject: Re: mysqldump error (mysql 4.0.14)
Try putting the name inside of backticks;
From
Read the docs at:
http://www.mysql.com/doc/en/INSERT_SELECT.html
They said that with 4.0.14 and up, that should work!!!
Thanks
Emery
- Original Message -
From: David Precious [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 10:09
Subject: Re: insert into x
Hi Jennifer,
On Fri, 2003-09-26 at 20:55, Jennifer Goodie wrote:
I have recently re-entered the job market and I was wondering if anyone has
found that having certification really helps in landing a position. If so,
which cert do you have?
I can only answer in general terms, but hope you
gamalt tant [EMAIL PROTECTED] wrote:
hi
i can locate my.cnf on my redhat8. should i uninstall
the mysql package and reinstalled to have my.cnf in
etc directory? i remember i get flag erros when i was
installing it?
No. If you want to have my.cnf, you should create it by yourself. You can
While connected to MySQL, issue the following instruction:
GRANT ALL PRIVILEGES to 'YourChoosesUsername'@'%' ON `database`
I don't remember exactly the syntax, but I think this should work. It means,
you giving all the permissions to the user YourChoosenUsername and you are
allowing him/her
It seems Victoria didn't understand the real problem:
I think that query should be stopped as soon as the table exists.
But if it doesn't exist, the query should create it and insert some records.
The problem is: WHY is MySQL trying to insert records while the table
exists? It should only insert
ketvin [EMAIL PROTECTED] wrote:
Access denied for user: '@localhost' to database 'database'
I have a database named 'database' and i got this problem while trying to
get it run. I am connecting that database to localhost without user and
password, it works just fine on my previous windows
Hi,
Read the manual about transactions.
Hans
At 11:56 29-9-03 +0200, you wrote:
Hi group?
Suppose I run a query by mistake that for example deletes my records.
Is there a way to go back to a previous state?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing
hi,
i found a strange user comment in the current documentation of c api
for mysql_real_connect.
http://www.mysql.com/doc/en/mysql_real_query.html
If a result set (MYSQL_RES) is in use, then mysql_free_result(...)
must be called before a call to this function will be successful.
if this is
On Mon, 29 Sep 2003 12:30:28 +0200
Director General: NEFACOMP [EMAIL PROTECTED] wrote:
It seems Victoria didn't understand the real problem:
I think that query should be stopped as soon as the table exists.
But if it doesn't exist, the query should create it and insert some records.
The
www.securityfocus.com ran a three part article,
http://www.securityfocus.com/infocus/1722, that discussed SQL Injections and
MySQL.
-Original Message-
From: Tony Thomas [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 28, 2003 11:36 PM
To: [EMAIL PROTECTED]
Subject: SQL Injection
Hi
When I replied I was not meaning the aim of this query but the aim of Mr.
Hassan who first asked that question on September 28, 2003.
I just rephrased his question!!!
Below is a text he wrote.
Please note where he said:
. I expected it to simply exit silently when it
On Mon, 29 Sep 2003 15:16:57 +0200
Director General: NEFACOMP [EMAIL PROTECTED] wrote:
Now, do you think I was right in my rephrasing?
To me, I think that is a bug and should be reported to MySQL. When the IF
condition is false, it should break the rest of the statement.
What is your view on
Hi
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to create table with just one spatial column I'm
getting following error:
mysql
From a Java connection object, Show Slave Status returns no rows
Running mysql on linux.
Also testing the SQL through mysql control center 0.8.9
Thanks,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
It is good that we both understand his problem.
Do you have a solution for his problem?
For me, I think he may use two statements:
1. Create the table if it does not exist.
2. Insert data if that will not create duplicates.
Hello,
I would like to use the unicode character set instead of the latin1. Can anyone tell
me how to do that please?
Thanks in advance,
Julien.
On Mon, 29 Sep 2003 16:02:23 +0200
Director General: NEFACOMP [EMAIL PROTECTED] wrote:
For me, I think he may use two statements:
1. Create the table if it does not exist.
2. Insert data if that will not create duplicates.
Yep, IMHO this is the only solution.
Another alternative is to first
Try taking out the identifier name for the primary key (pk_foo). The
way I read the documentation, MySQL does not support identifiers or
names for primary keys although it does for other index types.
HTH
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
This irritating rather than life-threatening: I can connect to the
MySQL database on my Linux box, from my Win2K box, using the command
line environment just fine:
c:mysql --protocol=TCP -h host_name -u my_name -p mysql
No matter what I try, however, I can't connect using MySQLCC. I
always
get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andy Jefferson wrote:
Mark Matthews wrote:
MySQL doesn't have schemas (currently). They are being developed in a
future version. The DatabaseMetaData interface in JDBC has a method,
'getSchemaTerm' which tells you whether a certain database
Julien Martin [EMAIL PROTECTED] wrote:
Hello,
I would like to use the unicode character set instead of the latin1. Can anyone
tell me how to do that please?
Unicode is supported from MySQL 4.1. You can find more info about new charsets in the
following chapter of the manual:
Hello,
I am trying to store our timesheet data in the Mysql database.
I would appreciate suggestions on the database scheme to use.
One of the possible ways to do it is to have a table indexed with the employee ID and
then having as many columns as there are days in the year.
This approach
Randy Chrismon [EMAIL PROTECTED] wrote:
This irritating rather than life-threatening: I can connect to the
MySQL database on my Linux box, from my Win2K box, using the command
line environment just fine:
c:mysql --protocol=TCP -h host_name -u my_name -p mysql
No matter what I try,
In the last timetracking system I built, I used a 'timeentry' table which was basically
timeentry_id (pk)
employee_id
date
num_hours_worked
task_id
I put a few other indexes in there based on the searching that I had to do, but to
each their own...
-Original Message-
From: Syed
I am trying to run the initial configure program on a Cobalt RaQ2 appliance, following
the instruction from http://www.ospex.com/raq2-php-mysql-apache.html
It seems, that some initial parameters are missing, like --host. What are the right
ones I have to use?
Here are the errors it displays:
I am having a problem in one of my scripts and I need to use
transactions to fix it. When I looked it up on the mySQL documentation
I found:
If you are using transaction-safe tables (like InnoDB or BDB), you can
put MySQL into non-autocommit mode with the following command:
Does this mean that
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to create table with just one spatial column I'm
Director General: NEFACOMP wrote:
To me, I think that is a bug and should be reported to MySQL. When the IF
condition is false, it should break the rest of the statement.
Exactly what I thought :-)
and Antony Dovgal responded:
For me this is not a bug, just poorly documented feature.
So, Hassan
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
Hmm... am I missing something?! IIRC there is nothing manual about Innodb
not supporting spatial extensions. And on windows it seems that all is working
fine. This is from my Win2000 box with the same Mysql version:
mysql create table
Hello All,
I think the passwd on my installation of mysql of
mysql-standard-4.0.14-pc-linux-i686 is corrupted. I can't login with the
root account. I was able to do so till last week.
I trying to follow the instructions on resetting the passwd, but I get the
following err msg.
# ./mysqld
Solved issue.
Sorry. Connection was connecting to Master not slave...
Hence... Master possessed no Slave Status information.
_A
Deduction, dear Watson...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi all,
when I used JDBC driver (Connector/J3.0.8) to run my java database agent
codes, It always have following errors:
java.lang.classNotFoundException : com.mysql.jdbc.driver
at java.net.URLClassloader$1.run(URLClassLoader.java:198)
I set the Classpath to
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
Hmm... am I missing something?! IIRC there is nothing manual about Innodb
not supporting spatial extensions. And on windows it seems that all is working
fine. This is from my Win2000 box with the same Mysql version:
mysql
At 21:33 +0400 9/29/03, G B U wrote:
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case,
So if you needed to know status of a work day for an employee day (say 9/1/2003), how
did you go about looking it up in your table?
Assuming that a employee can be present (p), on vacation (v), sick day (s)?
Your table seems to store only the number of hours worked
Thank you,
Syed Ali
(609)
I have a database with the name design-network
when I use mysqldump the database name is write:
design-network instead design-network
in table name, field name, etc all work fine.
The dump finish correctly but when I try use generated SQL I get an
error. The problem is -.
Other dump tool (ex.
On 29 Sep 2003 at 20:47, Lorenzo Sicilia wrote:
when I use mysqldump the database name is write:
design-network instead design-network
If you have odd characters in your names, then you need to use the
--quote-names option on mysqldump, so that it puts backticks around
them.
--
Keith C.
At 22:05 +0400 9/29/03, G B U wrote:
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
Hmm... am I missing something?! IIRC there is nothing manual about Innodb
not supporting spatial extensions. And on windows it seems that
all is working
fine. This is from my Win2000 box with the
In the system, there was a task_id associated with pretty much anything an employee
could work on per project...
In addition there was a project for 'overhead', which had tasks like vacation, sick,
maternity, etc...
so when the person entered their time, they put 8 hours toward their vacation
hi
it seems that the mysql-connector-java-3.0.8-stable-bin.jar file is not in
the classpath.
best regards
benny
- Original Message -
From: Joe Yan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 7:58 PM
Subject: Using mySQL connectJ issue
Hi all,
when I
I've fixed my swapping issues, but the system continues to get stuck in
a 'sending data' phase from time to time.
With mod_perl + mysql, this phase SHOULD be when mysql collects the rows
(after sorting, etc) and sends them to the perl handler for processing.
Any ideas why this phase would ever
Hi all!
I want to create an application that transfers data from FoxPro (*.dbf)
tables to MySQL. Does MySQL have a DUMP like or LOAD LIKE function that
transfers this data in one step?
I just don't want to loop into thousands of records to insert them one
by one into my MySQL database. It
you can export the foxpro table to a text file and import to your mysql
table. like this:
mysql SET AUTOCOMMIT=1; # Used for quick re-create of the table
mysql DELETE FROM pet;
mysql LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet FIELDS TERMINATED BY
',' ENCLOSED BY '' LINES TERMINATED BY
I installed a fresh copy mySQL-4.1alpha on XP. I ran
it standalone as follows:
mysqld-max --standalone --console
--default-table-type=innodb
I get the same results with my script.
Since I didn't specify a character set, I assume it is
the default (ISO-8859-1) set as specified in the
Section
Saqib,
I think the passwd on my installation of mysql of
mysql-standard-4.0.14-pc-linux-i686 is corrupted. I can't login with the
root account. I was able to do so till last week.
I trying to follow the instructions on resetting the passwd, but I get the
following err msg.
# ./mysqld
On Mon, 29 Sep 2003, Kevin wrote:
I've fixed my swapping issues, but the system continues to get stuck in
a 'sending data' phase from time to time.
With mod_perl + mysql, this phase SHOULD be when mysql collects the rows
(after sorting, etc) and sends them to the perl handler for
At 15:59 +0300 9/28/03, Victoria Reznichenko wrote:
Ed Smith [EMAIL PROTECTED] wrote:
Greetings. When I execute the SQL script below in
mySQL 4.1, I get
ERROR 1216: Cannot add or update a child row: a
foreign key constraint fails
It is, of course, choking on the enroll row insert.
Why is
Hi,
I'm in the process of setting up a new database server that will run on
redhat linux.
The machine will be dual processor with 4GB ram and about 16GB disk.
The machine is going to be used purely with InnoDB tables and will have a
few very large tables acting as cache data.
The amount of data
Marvin Wright said:
Hi,
I'm in the process of setting up a new database server that will run on
redhat linux.
The machine will be dual processor with 4GB ram and about 16GB disk.
The machine is going to be used purely with InnoDB tables and will have
a few very large tables acting as cache
All,
ok, I found the reason why the non-latin1 bug of 4.0.12 affects also the
default latin1 charset in 4.1.0.
The reason is that the charset 'name' (really the collation name) is
internally 'latin1_swedish_ci', and InnoDB thinks it is a non-'latin1'
charset!
(gdb) print *default_charset_info
I've the same problem with sub-selects too.
One way to resolve this problem is creating index on the attribute that you are
using in the sub-select (in your case, you are doing a full scan, so the index
don't works).
Another way is re-creating the query. You can transform the sub-select in a
On Monday, September 29, 2003, at 03:29 PM, Carlos Vazquez wrote:
I want to create an application that transfers data from FoxPro (*.dbf)
tables to MySQL. Does MySQL have a DUMP like or LOAD LIKE function
that
transfers this data in one step?
I just don't want to loop into thousands of
Victoria Reznichenko wrote:
MySQL 4.1 provides new password hashing mechanism. This error appears if you connect
with pre-4.1 client to the server 4.1. ook at:
http://www.mysql.com/doc/en/Password_hashing.html
In the above section of the manual you can find description of possible
Is it possible, desirable, etc. to convert the mysql grant, system,
etc. tables to innodb? I.e.,
use mysql;
alter table columns_priv type = innodb;
alter table db type = innodb;
alter table func type = innodb;
alter table host type = innodb;
alter table tables_priv type = innodb;
alter table
On Mon, Sep 29, 2003 at 06:06:56PM -0700, Rusty Wright wrote:
Is it possible, desirable, etc. to convert the mysql grant, system,
etc. tables to innodb? I.e.,
use mysql;
alter table columns_priv type = innodb;
alter table db type = innodb;
alter table func type = innodb;
alter table host
Could it be possible that the number of rows returned causes the
slowness?
There is a 'limit 0,30' in the query, but does it still lookup the join
for each row?
--+-| poems | index | NULL | created | 4 | NULL |
272319 | Using where |
| poets | eq_ref | PRIMARY |
At 18:06 -0700 9/29/03, Rusty Wright wrote:
Is it possible, desirable, etc. to convert the mysql grant, system,
etc. tables to innodb? I.e.,
use mysql;
alter table columns_priv type = innodb;
alter table db type = innodb;
alter table func type = innodb;
alter table host type = innodb;
alter table
Hi Kevin,
- Original Message -
From: Kevin
Sent: Monday, September 29, 2003 2:21 PM
Subject: slow 'sending data' phase
I've fixed my swapping issues, but the system continues to get stuck
in
a 'sending data' phase from time to time.
With mod_perl + mysql, this phase SHOULD be when
Hi,
4.1.0 was released before 4.0.14 so it wouldn't have the new
functionality in it. It should be in 4.1.1 but hasn't been added to the
change-log yet.
Matt
- Original Message -
From: Director General: NEFACOMP
Sent: Monday, September 29, 2003 4:51 AM
Subject: Re: insert into x
Hi Matt,
Thanks for the excellent play-by-play for my query. I can't believe I
didn't see the problem - you're right exactly, its using the 'created'
index instead of 'mid', and so loading every row into memory, which when
the site is under high load causes wicked slowness.
This appears to be a
Anyone know how the index chooser works, and why it is often so bad?
For example, with the following query:
SELECT lid,brief,title FROM poems left join poets on poems.mid =
poets.mid WHERE poems.mid =9365 ORDER BY created DESC LIMIT 0,10
With an explain of:
*** 1. row
Hi,
I am trying to learn PHP using MySQL, I downloaded Abriamerlin package for a start as
I used this software when I was in uni. But I am having problem to install the
connection. When I open the MySQL administrator, my server connection cant be found.
Would you mind let me know what I need
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_nametabsalaryenter
employee_nametabsalaryenter
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name salary as the columns;
I
85 matches
Mail list logo