Hal Vaughan h...@halblog.com wrote:
I'm having the strangest issue. I am using a Perl program to test out some
other Perl programs and all the Perl connections with MySQL are normal, as
in I use the standard interface. But in the test program I'm just using this:
[... cut ...]
On Jan 26, 2011, at 5:11 PM, mis...@poczta.fm wrote:
Hal Vaughan h...@halblog.com wrote:
I'm having the strangest issue. I am using a Perl program to test out some
other Perl programs and all the Perl connections with MySQL are normal, as
in I use the standard interface. But in the test
On Wednesday 14 April 2010 7:39:03 pm Dan Nelson wrote:
In the last episode (Apr 14), Mike Diehl said:
On Wednesday 14 April 2010 5:49:43 pm Jesper Wisborg Krogh wrote:
Lines is a reserved keyword (e.g. like in LINES TERMINATED BY), so it
must be quoted:
test use test;
Database
Hi all.
Now this one is strange.
I just created a new table called lines. I can use Open Office to read the
records in it just fine.
However, when I type this command at the cli, I get an error:
select * from lines;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
On Thu, 15 Apr 2010 09:31:04 Mike Diehl wrote:
I just created a new table called lines. I can use Open Office to read
the records in it just fine.
However, when I type this command at the cli, I get an error:
select * from lines;
ERROR 1064 (42000): You have an error in your SQL syntax;
On Wednesday 14 April 2010 5:49:43 pm Jesper Wisborg Krogh wrote:
Lines is a reserved keyword (e.g. like in LINES TERMINATED BY), so it
must be quoted:
test use test;
Database changed
test CREATE TABLE `lines` (id int unsigned NOT NULL PRIMARY KEY)
ENGINE=InnoDB; Query OK, 0 rows affected
In the last episode (Apr 14), Mike Diehl said:
On Wednesday 14 April 2010 5:49:43 pm Jesper Wisborg Krogh wrote:
Lines is a reserved keyword (e.g. like in LINES TERMINATED BY), so it
must be quoted:
test use test;
Database changed
test CREATE TABLE `lines` (id int unsigned NOT NULL
in
another table.
Tip: Remember when using Load Data, it will be faster if the table is
empty and optimized (no holes) than with a table that has data in it.
That's because the non-unique indexes are built after all of the data has
been loaded. The alternative is to disable the non-unique
Hi Experts,
load data local infile and insert into tablename are the two methods of
inserting data into a mysql table.
Out of the above two method. Is there any faster method of inserting data
into mysql tables.
Thanks,
Krishna Ch. Prajapati
is the fastest method, unless the data is already stored in
another table.
Tip: Remember when using Load Data, it will be faster if the table is empty
and optimized (no holes) than with a table that has data in it. That's
because the non-unique indexes are built after all of the data has been
loaded
tables.
No. Load Data is the fastest method, unless the data is already stored in
another table.
Tip: Remember when using Load Data, it will be faster if the table is empty
and optimized (no holes) than with a table that has data in it. That's
because the non-unique indexes are built after all
Hi Experts,
I have a crm table where 12 millions records inserted/day. We are running
report queries on this table and using partitioning features for faster
results. we have to maintain 45 days data means 540million records. As per
my calculation 540 records will use 1.8 TB of disk space. Total
Krishna Chandra Prajapati wrote:
Hi Experts,
I have a crm table where 12 millions records inserted/day. We are running
report queries on this table and using partitioning features for faster
results. we have to maintain 45 days data means 540million records. As per
my calculation 540 records
Prajapati [mailto:prajapat...@gmail.com]
Sent: Thursday, November 19, 2009 12:13 AM
To: MySQL
Subject: DELETE DATA FROM TABLE
Hi Experts,
I have a crm table where 12 millions records inserted/day. We are running
report queries on this table and using partitioning features for faster
results. we
this, you should probably
seek a bit more information about from this list or other sources.
Regards,
Gavin Towey
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Thursday, November 19, 2009 12:13 AM
To: MySQL
Subject: DELETE DATA FROM TABLE
19, 2009 1:15 AM
To: Gavin Towey
Cc: MySQL
Subject: Re: DELETE DATA FROM TABLE
Hi Gavin,
I am using innodb with file-per-table. I agree with you dropping a partition
will reclaim disk space.
alter table table name drop partition partition name
But, my concern is alter table table name drop
I loaded data into table by using LOAD DATA LOCAL INFILE '../../...TXT' INTO
TABLE tblname (NAME, STREET, MESSAGE); I found that the first letter in
message disappeared. the message is text. Could anyone tell me why and how to
avoid such problem?
Thank you
zzy
--
MySQL General
In order to avoid errors. Always use fields terminated by, enclose by and
lines terminated by tag with load data local infile.
Just, give try.
On Wed, Sep 24, 2008 at 11:19 AM, Zhongyi Zhang [EMAIL PROTECTED] wrote:
I loaded data into table by using LOAD DATA LOCAL INFILE '../../...TXT
On 2007-02-19 Nhadie Ramos wrote:
Hi Christian,
Thanks for the reply. I got the table repaired and deleted some data on it.
What combination can i use to overcome the 4GB limit?
Read http://www.suse.de/~aj/linux_lfs.html and google a bit. Basically any
recent Kernel 2.4 or 2.6 should do.
Hi All,
Hope you can help me with this problem:
I had an error that my database is already full, when i do a select there is
always no result even select * from tablename.
but when i look at it on /var/lib/mysql i can see the size of the file is
still huge,
-rw-rw 1 mysql mysql 9174
Hello
On 2007-02-18 Nhadie wrote:
I had an error that my database is already full, when i do a select there
is always no result even select * from tablename.
but when i look at it on /var/lib/mysql i can see the size of the file is
still huge,
-rw-rw 1 mysql mysql 9174 Feb 18
Hi Christian,
Thanks for the reply. I got the table repaired and deleted some data on it.
What combination can i use to overcome the 4GB limit?
TIA
Regards,
Nhadie
Christian Hammers wrote:
Hello
On 2007-02-18 Nhadie wrote:
I had an error that my database is already full, when i do a
the group.
I have some web-based forms that match table structure. Most of the
important fields have validation, and I ensure good data into the table. But
I have a few columns in the table such as middleInitial where I do not
validate the data. And in the database is shows a null when I do
data into the table. But I have a few
columns in the table such as middleInitial where I do not validate the data.
And in the database is shows a null when I do a select * from.
Is a null acceptable in the database, or is there something I should do on
columns that the user may not put in data
structure. Most of the
important fields have validation, and I ensure good data into the
table. But I have a few columns in the table such as middleInitial
where I do not validate the data. And in the database is shows a
null when I do a select * from.
Is a null acceptable in the database
data into the table. But
I have a few columns in the table such as middleInitial where I do not
validate the data. And in the database is shows a null when I do a select *
from.
Is a null acceptable in the database, or is there something I should do on
columns that the user may not put in data
I imported data into a table mytable into a databse mydb with existing
data.
mysqlimport -L mydb data.txt
that operation failed.
I interrupt it.
It seems that I imported data with the same indexes (duplicate entries)
I tried: delete from mytable;
that seems to fail too
What happens when
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
into table
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General
PM
To: mysql@lists.mysql.com
Subject: Import Excel data into table
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Steve Grosz [EMAIL PROTECTED] writes:
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
If your data is a .csv file [a.csv] similar to:
1,Steve,Grosz
2,Brad,Eacker
Consistent with the output from Excel. You could use
LOAD DATA
I forgot one element
LOAD DATA LOCAL INFILE 'a.csv' INTO TABLE Users
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
(id,firstName,lastName);
Brad ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I am importing data into a large table, 100 million rows, and I want to use
Alter table disable keys prior to executing a Load Data...,. But after
loading the data, if I execute a Alter Table ... enable keys will MySQL
create a second table, load the data into the second table
To: mysql@lists.mysql.com
Subject: Will Alter Table ... enable keys reload data to table?
I am importing data into a large table, 100 million rows, and
I want to use Alter table disable keys prior to executing a
Load Data...,. But after loading the data, if I execute a
Alter Table
table and reload
the data into it, like all Alter Table statements do?
Mike
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 5:24 PM
To: mysql@lists.mysql.com
Subject: Will Alter Table ... enable keys reload data to table?
I am importing data
Could this be a 'register_globals' issue? (Check your php.ini file.)
Are you sure that the queries you're sending are correct? Is
mysql_query() returning any errors?
Some more information, please!
Seth
On Fri, 1 Oct 2004 23:35:09 -0500, tom miller [EMAIL PROTECTED] wrote:
i'am not sure if
i'am not sure if this is related to suse 9.1 or what i'am beginning
with mysql and php
i'am running:
mysql 4.0.21-standard
suse9.1
kernel version 2.6.5-7.10b-default
php version 4.3.4 - default install
apache 2.0.49 - prefork
i created an address book using php and when i go thru and fill in
Michaell Taylor [EMAIL PROTECTED] wrote:
Lost connection to MySQL server during query
details:
myssql 4.0.20
linux: fedora core 2
file system : ext3
There should be a clue of what's happening with MySQL at the end of .err file
in the datadir. Take a look into it.
--
For technical
I have about 1,000 flat files that I have loading into a mysql table. The
load is done through a shell script that iterates over each file, loading
sequentially.That is, I inititate a load data local ... statement on
each of the 1,000 files.
The total size of the completed data base is
I (a total newbie on sql) try to populate my tables by load data local
-syntax from a text file (saved in ANSI-coding) with swedish characters
(vocals å ä ö), but select * from table reveals that swedish vocals are
replaced by other signs.
If I load manually by insert into table values-syntax all
Louie Miranda [EMAIL PROTECTED] wrote:
I have one table named Category under that all values contains Books
How can i make all Books into Stocks?
Use UPDATE statement like this:
UPDATE Category SET column='Stocks' WHERE column='Books';
--
For technical support contracts, goto
I have one table named Category under that all values contains Books
How can i make all Books into Stocks?
Im not familiar with the command
-- -
Louie Miranda
http://www.axishift.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Indexing in MySQL.
If while indexing a table I retrieve data from same table the indexing
process seems to get stuck. Mytop keeps saying something about
repairing keycache for days when the indexing shouldn't take more than
a couple of hours.
Can someone please explain
Scott,
Monday, December 02, 2002, 5:46:18 AM, you wrote:
SB I'm in the process of rebuilding a table in MyISAM format. I can see the
SB plaintext data in the .MYD file just fine. But after running myisamchk
SB -i table, which reports fine and repairs the index to the correct 388
SB rows... I go
]]
Sent: Monday, December 02, 2002 7:18 AM
To: [EMAIL PROTECTED]
Subject: re: Null data after table rebuild
Scott,
Monday, December 02, 2002, 5:46:18 AM, you wrote:
SB I'm in the process of rebuilding a table in MyISAM format. I can see
the
SB plaintext data in the .MYD file just fine. But after
Good evening,
I'm in the process of rebuilding a table in MyISAM format. I can see the
plaintext data in the .MYD file just fine. But after running myisamchk
-i table, which reports fine and repairs the index to the correct 388
rows... I go under the command line client and run a standard select
I have two tables containing a BLOB cloumn as;
-- supposed to be able to handle up to about 16MB
CRETAE TABLE gallery1 (
idINTEGER,
titleVARCHAR(255),
mediumimageMEDIUMBLOB
);
-- supposed to be able to handle up to about 4GB
CRETAE TABLE gallery2 (
idINTEGER,
On 26 Nov 2002, at 8:52, Pae Choi wrote:
Q: How come the size of table does not decrease
after deletion?
MySQL will reuse that space when you insert new records. To recover
the space, you need to optimize the table:
http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html
P.S.: MySQL, SQL,
First of all, thanks for your reply as well as a pointer to the Doc.
I tried the OPTIMIZE command as follows:
mysql optimize table gallery;
mysql optimize table gallery2;
Both does not contain any entry since I deleted the BLOB data.
But the size of tables, gallery.db and gallery2.db does not
Pae,
Tuesday, November 26, 2002, 6:52:20 PM, you wrote:
PC I have two tables containing a BLOB cloumn as;
PC -- supposed to be able to handle up to about 16MB
PC CRETAE TABLE gallery1 (
PC idINTEGER,
PC titleVARCHAR(255),
PC mediumimageMEDIUMBLOB
PC );
PC -- supposed to
no database manager that i know of automatically
packs the database after every record deletion.
it would be too costly.
that is one of the reasons that most of us do not
store blobs in databases, but store them
externally.
I have two tables containing a BLOB cloumn as;
-- supposed to
At 10:36 -0800 11/26/02, Pae Choi wrote:
First of all, thanks for your reply as well as a pointer to the Doc.
I tried the OPTIMIZE command as follows:
mysql optimize table gallery;
mysql optimize table gallery2;
Both does not contain any entry since I deleted the BLOB data.
But the size of
Paul,
It really did the trick. Thanks.
Regards,
Pae
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Pae Choi [EMAIL PROTECTED]; Keith C. Ivey [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 10:59 AM
Subject: Re: [MySQL v3.23.53a] BLOB Data and Table
to the correct IDs.
David
-Original Message-
From: John Chang [mailto:johnec;umich.edu]
Sent: Thursday, October 17, 2002 9:09 AM
To: [EMAIL PROTECTED]
Subject: input data which table first
SQL, Does it matter which table I enter data into first? Or do I need
to
first
put in the data
SQL, Does it matter which table I enter data into first? Or do I need to
first
put in the data into Studios, Genres, Actors, Stars first before adding
to Titles and TitleGenres since they use the IDs of the other table? Or
should I convert it to type innodb and make the IDs foreign keys
Mertens,
Wednesday, August 28, 2002, 6:52:12 PM, you wrote:
MB On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
Put into my.cnf file :
[mysql]
local-infile=1
or start mysql client with --local-infile=1 option.
MB I tried the first option and it works when use the following command to
MB
It shoul d be running as user mysql .
Mertens Bram wrote:
On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote:
As it says in the documentation, If the LOCAL keyword is specified,
the file is read from the client host. If LOCAL is not specified, the
file must be located on the server. That
Hi,
I was following the example in the manual (the menagerie database) but I
can not load a file into the table, i get the following error:
mysql LOAD DATA LOCAL INFILE ~/testmysql/pet.txt INTO TABLE pet;
ERROR 1148: The used command is not allowed with this MySQL version
I searched the
Mertens,
Wednesday, August 28, 2002, 10:54:12 AM, you wrote:
MB I was following the example in the manual (the menagerie database) but I
MB can not load a file into the table, i get the following error:
MB mysql LOAD DATA LOCAL INFILE ~/testmysql/pet.txt INTO TABLE pet;
MB ERROR 1148: The used
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
Put into my.cnf file :
[mysql]
local-infile=1
or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following command to
load the data-file:
mysql LOAD DATA LOCAL INFILE
I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Mertens Bram wrote:
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
Put into my.cnf file :
[mysql]
local-infile=1
or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following
On Wed, 2002-08-28 at 20:02, Gerald Clark wrote:
I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Sorry, I don't understand: why would mysql have access to a file when I
run LOAD DATA LOCAL... and not when I run it without the LOCAL?
If I run it with LOCAL the data is added to the
On 28 Aug 2002, at 20:07, Mertens Bram wrote:
Sorry, I don't understand: why would mysql have access to a file when I
run LOAD DATA LOCAL... and not when I run it without the LOCAL?
As it says in the documentation, If the LOCAL keyword is specified,
the file is read from the client host. If
On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote:
As it says in the documentation, If the LOCAL keyword is specified,
the file is read from the client host. If LOCAL is not specified, the
file must be located on the server. That means that with LOCAL the
MySQL *client* must be able to
If I have mysql on server A and an identical version on server B, what is the easiest
way to move data in Table C from server A to server B?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
* Kemp Randy-W18971
If I have mysql on server A and an identical version on server B,
what is the easiest way to move data in Table C from server A to server B?
Asuming your databases are stored in /usr/local/mysql/var/ and the relevant
database is named database:
From Server A:
scp /usr
Hello all. This is a snippet from my JavaBean that I'm using to insert data
into MySql database.
The bean is working perfectly alright but I can't insert data into the user
table. Please help and do tell what I'm doing wrong here.
This is the code:
public String saveToDB() {
try {
67 matches
Mail list logo