query seems perfect, what error is this giving?
Nitin
- Original Message -
From: "Jim Bartram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 10:07 AM
Subject: Adapting a Select statement to MySQL
> I've got the following select statement that is defeating
yes, syntax is bit diff.
INSERT into table1(column list) select a, b, c, d from table2 where
);
Enjoy
Nitin
- Original Message -
From: "Lay Hoon Tan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 11:36 AM
Subject: Inserting values via a SELECT statement
Is there any way that SQL can accomplish the insertion of values through a
"select" statement,
eg, INSERT into table1 VALUES (
select a, b, c, d
from table2
where );
Regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
> Hi there, i was wondering how i could setup a query to get related
> articles for an article. How would it be possible to join these
> articles up. For instance i select an article, i has two related
> articles to it, i select one of the articles and it also has a related
> article back to the pr
Hi there, i was wondering how i could setup a query to get related articles
for an article. How would it be possible to join these articles up. For
instance i select an article, i has two related articles to it, i select
one of the articles and it also has a related article back to the previous
art
Hello
I have 4.1.0-alpha-max-nt. When i issue a command -
show full fields from tblname;
I get information about the fields in the table. There
are two columns i.e. EXTRA and COMMENTS which is
always blank. I cant seem to figure out what
information they provide. The SHOW FULL FIELDS... in
my My
I've got the following select statement that is defeating me!
select title_id, ytd_sales from titles
where ytd_sales between 4095 and 12000;
The WHERE clause is not working... How should this be done in MySQL?
Thanks for any help,
-Jim
--
MySQL General Mailing List
For list archives: http://l
Remember that utf8 is not the same as the Unicode codepoints. If you want
to enter utf8 like that you need to convert it from ucs2 first. Try this:
SELECT convert(_ucs2 0x00d4 using utf8);
and to insert:
INSERT INTO your_table values (convert(_ucs2 0x00d4 using utf8));
You can compare the ch
Hi:
Does anyone have a simple PHP program that will enable
SQL queries to be executed and displayed with MySQL?
thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General Mailing List
For
This feature set appears to be very quietly in place in libmysqlclient.
I'd rather not reinvent the wheel when there's a perfectly good effort
underway elsewhere... so I'll just bring this up here and see what kind
of response I get. BTW, hi list! :)
For those of you who don't pore over the s
Hi,
I am trying to insert unicode characters in to a table
from mysql client, but I am unable to.
My configuration is
MySQL4.1.0-alpha on SunOS8. Installed MySQL from
source with support for all character sets.
Created table with create table mm(xyz varchar(10)
character set utf8), and started my
Hello, mysql,
Research on the mysql status,we found the mysql take slow query.But we don't
know when it happened.
Does any command to trace the slow query(such as what sql statement,when it
occur)?
or any tools to monitor when it happened?
In my loading test,when
Check out SQLYog, could can connect and copy databases...pretty much
like MSSQL Enterprise manager. They have a trial version on their site:
http://www.webyog.com/sqlyog
On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote:
> Hi there,
> I have taken the plunge and dropped windows in favour of linux
Hello, Victoria Reznichenko,
The p_showing table,the following is the create table sql statement.
| p_showing | CREATE TABLE `p_showing` (
`showing_timestamp` timestamp(14) NOT NULL,
`showing_channel_name` varchar(50) NOT NULL default '',
`showing_asset_name` varchar(50) NOT NULL default '
Hi there,
I have taken the plunge and dropped windows in favour of linux. My
question is what is the best way to get the data from my windows mysql
databases into linux? Can I just copy some files from one partition to
another or what?
Thanks,
Matt
--
MySQL General Mailing List
For list archi
Hello,
I already use phpmyadmin to dump the mysql data into sql files,
but I would like to back up the original database files as well.
I found the actual database files on my server in var/lib/mysql
and want to download copies, but I do not know wether I should
use binary or ascii format.
Wha
Am I wrong to assume mysqlimport is supposed to emulate the LOAD DATA INFILE
syntax? I cannot find the command line option to turn on the CONCURRENT
flag.
Steve Cersosimo
"When all is said and done, more is said than done"
*
"The information transmitted is intended only for the person or e
On Mon, Nov 03, 2003 at 03:29:23PM -0500, Mauro Marcellino wrote:
> Thanks much...
>
> Does this work with InnoDB tables as well as MyISAM?
Yes. The binlogs work for all table types.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawod
hi everyone.
i'd like to know if mysql always uses all the key_buffer size it has been
given in my.cnf
especially, on my server with :
set-variable= thread_stack=128K
set-variable= key_buffer=200M
set-variable= max_allowed_packet=1M
set-variable= table_cache=128
set-variable=
I have a MyISAM table, into which I am trying to bulk-load several
gigabytes of data.
The first attempt got stuck after the table.MYD file had reached
precisely 4 GB. There wasn't any error message, but I observed that
neither the data nor the index file was increasing in size, even though
the CPU
Thanks much...
Does this work with InnoDB tables as well as MyISAM?
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Mauro Marcellino" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, November 01, 2003 2:47 AM
Subject: Re: Offline Replication with MySQL
>
The table is currently only about 345MB, so it is not a file size limit.
In response to the other post, the only deletes in this table happen every
week or so when I'm cleaning the table out, so the corruption is not
happening with a delete.
-Original Message-
From: gerald_clark [mailto:[
Could it be getting larger than 2G on a filesystem with a 2G/file limit?
Jon Wagoner wrote:
I have a table that tends to get corrupted and needs to be repaired every
few days. It is used for logging various messages in my web app. The
structure is:
CREATE TABLE log (
log_id int(11) unsigned NO
I think I have tracked the problem down to deletes. In an environment
with many deletes I've noticed that the rate of table corruption across
my cluster of db server increases for the boxes with many deletes.
I've been able to get around this issue by periodically checking tables
on off hours and
You need to GRANT the appropriate privs-for the slave in question to
replicate from the master on the master. Look up Grant on mysql.com
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From
I have a table that tends to get corrupted and needs to be repaired every
few days. It is used for logging various messages in my web app. The
structure is:
CREATE TABLE log (
log_id int(11) unsigned NOT NULL auto_increment,
log_type tinyint(1) unsigned NOT NULL default '0',
when datetime
On Mon, Nov 03, 2003 at 01:35:26PM -0600, William Baker wrote:
> It's hard to tell. The CPU is under a reasonable load (uptime shows 1.0
> - 2.0), no swapping, and the hard drive is churning away continually.
The "load average" is relatively meaningless. What's the actualy CPU
utilization as sh
On Mon, Nov 03, 2003 at 01:37:26PM -0600, William Baker wrote:
> Now why didn't I think of a single alter tablethat should certainly
> improve things. I'll give it a try.
Oh, yeah. That will probably help A LOT.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<
If you insert records directly into the tables in mysql, then they only
have the rights you specifically specify. GRANT is smart enough to
handle a lot of the dirty-work for you. In particular, I like the:
GRANT SELECT on *.* to readonly@'%' identified by 'readonly';
This will create the user
Now why didn't I think of a single alter tablethat should certainly
improve things. I'll give it a try.
bbaker
William Baker wrote:
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScsi3 controller
It's hard to tell. The CPU is under a reasonable load (uptime shows 1.0
- 2.0), no swapping, and the hard drive is churning away continually.
One thing that makes me think I am doing something wrong is that if I
build the indexes on a 60MB file, it still takes a considerable amount
of time (6-
I have two tables, one with adverts (two columns, 'keywords' & 'advert') and
the other with articles (one column, 'text')
How do I get them to match up selecting only one word from 'keywords' and
one from 'text'
i.e. Each 'keyword' record may have four or five words, say 'dog cat pet
bird'
+
ORDER BY and LIMIT.
Jeremy March wrote:
I have an alphabetic list of records in a table and I want to display
the 25 previous and 25 next records before and after a selected
record. This would be easy if "before" and "after" meant sorted by id
number, but I need it sorted alphabetically. Doe
I have an alphabetic list of records in a table and I want to display the 25
previous and 25 next records before and after a selected record. This would
be easy if "before" and "after" meant sorted by id number, but I need it
sorted alphabetically. Does anyone know a good way to do this?
Than
On Mon, Nov 03, 2003 at 11:18:55AM -0600, William Baker wrote:
> I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
> RAM. The database is on a dedicated SCSI drive with an Adaptec
> UltraScsi3 controller which shows 40MHz bus connecting the 10K-RPM
> disks. (Fairly new, fairl
Hey everybody --
I'm trying to get a handle on permissions in MySQL. I've read the manual several
times, and I still lack the 'big picture'.
It seems to me there are three levels of security:
1. Database permissions
2. Table permissions
3. column permissions.
What I don't understand is how al
William Baker wrote:
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScsi3 controller which shows 40MHz bus connecting the 10K-RPM
disks. (Fairly new, fairly capable, low-end server grade.)
I have a 2GB
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScsi3 controller which shows 40MHz bus connecting the 10K-RPM
disks. (Fairly new, fairly capable, low-end server grade.)
I have a 2GB datafile with 10 indexe
It doesn't look like it is *that* easy. It looks like the server starts
when using mysqld-max, I just have to get the mysql database tables
built and see how it goes from there (being lazy and using the rpms I
don't get those tables as it uses the mysqld server... similar issues
with mysql_ins
Dand, sorry, I forgot to cut and paste the error in there. :\
It was something to the point of 'exceeded max_allowed_packet', though.
I can't find any sort of file in my system called 'my.cnf'. Is there
another name or place this would be on a linux box? I have a Cobalt RAQ4 if
you or anyone
Hi all!
I need to perform what I've called an "additive UPDATE".
The logic is the next:
(1) There's a historic table (HISTORY) with two fields:
mysql> create table history (ID char(7) primary key, VAL int(12));
(2) There's a new table everyday (TODAY) with exactly the
same structure as HISTORY (ID
Hiya,
tried LD_ASSUME_KERNEL=2.2.5?
See here:
http://sources.redhat.com/ml/libc-hacker/2003-06/msg00032.html
May work, then again your machine may blow up! So use at your own risk as I
am guessing!
Greg
> -Original Message-
> From: Owen Scott Medd [mailto:[EMAIL PROTECTED]
> Sent: 03
I should sleep before posting, I suppose.
I suppose this is the issue with the NPTL threads library? If so, has
anyone dealt with that issue with MySQL? I remember hearing that
perhaps using a dynamically linked mysqld would work around the problem.
Owen
Owen Scott Medd wrote:
I have Red Ha
oops, sorry, i missed the right forum ;)
[EMAIL PROTECTED] a écrit :
Hi to all,
I'd like to use the file:/// protocol with mozilla mail. But how ?
When i create an html document, i can insert links with file:///
protocol. Exemple:
wanna read MyDoc ?
And it works fine. When i click on th
Hi to all,
I'd like to use the file:/// protocol with mozilla mail. But how ?
When i create an html document, i can insert links with file:///
protocol. Exemple:
wanna read MyDoc ?
And it works fine. When i click on the link, acrobat reader opens.
However, when i write a mail with this l
[EMAIL PROTECTED] wrote:
Since moving to mysql 4.0.15 from 3.23.5x, I am getting a crash
once a week on an hourly run set of queries that are disk intensive.
# ./resolve_stack_dump -n /tmp/mysqld.stack -s mysqld.sym
0x8070640 handle_segfault + 420
0x8288108 pthread_sighandler + 184
0x80aca70 __9
Victoria Reznichenko wrote:
[EMAIL PROTECTED] wrote:
mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
I checked the error log but not
"MaFai" <[EMAIL PROTECTED]> wrote:
> Hello, mysql,
>
> The replication running smoothly between the master and slave,except that the heap
> table can not be synchronized.
>
> While the master insert the record into the heap table,the slave would do the same
> job.
> While the master delete the
THanks everyone for all your help!
Steve
- Original Message -
From: "Pete Harlan" <[EMAIL PROTECTED]>
To: "David T-G" <[EMAIL PROTECTED]>
Cc: "mysql users" <[EMAIL PROTECTED]>; "Steve Vernon"
<[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 4:16 PM
Subject: Re: Hardware Raid and 2 Gig L
* joffrey leevy
> Got a problem/question. I am trying to load a tab
> delimited textfile into my table and it keeps saying
> file not found. I am confident I am doing everything
> correct (the pathname, text extension, syntax, etc.)
> But it keeps saying file not found (error 1105 and
> errcode:2
[EMAIL PROTECTED] wrote:
> How can I trouble shoot this, please (it happens selecting any table
> from all of my DBs):
>
> Error
>
> SQL-query:
>
> SHOW KEYS FROM `answers`
>
> MySQL said:
>
> #1017 - Can't find file: './survey/answers.frm' (errno: 13)
$ perror 13
Error code 13: Permissi
Heinrich Stoellinger <[EMAIL PROTECTED]> wrote:
> Does MySQL support the "EXISTS" / "NOT EXISTS" clause in table query
> statements?
It's supported since version 4.1
> What I want to do is to find tuples which do NOT have
> corresponding tuples in another table. For example - tell me who in my
On Mon, Nov 03, 2003 at 12:47:03AM +1100, Chris Nolan wrote:
> Hi all,
>
> Looking through various database feature lists, a fairly common
> thing seems to be Distributed Transactions (as in two databases,
> each have an uncommited transaction that needs to be commited and
> either all of both com
> -Original Message-
> From: Fernando Melo [mailto:[EMAIL PROTECTED]
> Inside my program (PHP) I want to provide a field where the user
> can select
> a database. Since I don't want clients accessing into other clients'
> databases, I need to do user-level access control within MySQL wh
Hi everyone,
Inside my program (PHP) I want to provide a field where the user can select
a database. Since I don't want clients accessing into other clients'
databases, I need to do user-level access control within MySQL whereby a
user will only have read/write access to his/her database based on
55 matches
Mail list logo
