Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_namesalary
employee_namesalary
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name & salary as the columns;
I use the command
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 t
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 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
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 sele
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
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
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 |
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 tab
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 user
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 scenari
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 records
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 joi
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
$2
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 a
I'm using MySQL-4.1 alpha because it's support sub-select.
But i've tried and the result takes very long time (more then 30 seconds).
The query is:
SELECT T.*, C.NAME FROM arTAGIH T, arCUSTOMER C, arBILL_LNS WHERE T.BILL_NO NOT IN
(SELECT BILL_NO FROM arBILL_LNS)
AND T.CUST_CODE=C.CUST_CODE
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 I
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 t
Ed,
I was able to repeat the error in MySQL-4.1.0 on XP, with the default latin1
charset. But 4.0.15a works ok. The bug fixes of 4.0.xx will be in 4.1.1,
which will be out around Nov 15th.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level lock
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 proces
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
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 4.6
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
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 makes
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 be
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,
> whe
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
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
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
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 (e
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) 9
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 si
> 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:
> >
> >
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 "mysql-connector-java-3.0
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 PROTECTE
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 --skip-
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
> 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 be
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
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
"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 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
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:
[
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
"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
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 woul
"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:
-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
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
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 unsu
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
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.
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.
/*
>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 PR
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> cre
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 v
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
f
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 All
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.
>
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 tru
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 Serv
"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
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 r
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 to
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 c
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 m
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
`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 backti
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 1
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 li
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
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 on
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.
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"
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
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 t
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 the
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?
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 archives:
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
Fortun
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
81 matches
Mail list logo
