That makes sense.
Thank you Tore.
Kyle
-Original Message-
From: Tore Bostrup [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 February 2003 01:12
To: Kyle Lange; [EMAIL PROTECTED]
Subject: Re: INSERT ... SELECT - A slightly different question
The typical syntax for this would be:
INSERT I
Hi,
Have u thought of sending an sql query like "show tables" and then looking
at what it returns?
Eric
On Thu, 20 Feb 2003, Jeff Pearson wrote:
> I am writing a vb.net application to do some db management on MySQL. Ive
> got it pretty far but am at a point where I am stuck. I know with php
> th
Thanks for your reply,
Diana Soares wrote:
> > Selecting manufacturers from just one color with join works like a charm.
> > (IIRC, untested code:)
> >
> > SELECT DISTINCT ca.Manufacturer, co.Name FROM car_color_links as l
> > JOIN colors as co ON (co.ID = l.color_ID)
You may have to wait until version 4.1 if I am not mistaken.
- Original Message -
From: "geeta varu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 4:09 PM
Subject: subselect
> does mysql version 3.23 support subqueries ...if no
> does latest version 4.0 sup
does mysql version 3.23 support subqueries ...if no
does latest version 4.0 support...
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
Hi!
We host a very big ip database (around 2 million of records) with ip
ranges converted to int numbers, in a schema like:
from_ip, to_ip, country, uniq_id
And we need to make tons of querys looking for a particular ip on the
database to get its country and we're asking some questions that may b
What you are looking for is a report generator. SQL queries will return
result sets in a "table" layout (since the fonts etc. messes up attempt at
tabulat layout, I'm presenting the data as comma separated):
(SeriesTitle, LinkTitle)
1, 1
1, 2
1, 3
2, 1
2, 2
3, 3
If the Series column in the Links
This is really not a bug. It is only a feature. Besides trimming of trailing
spaces, MySQL also perform case-insensitive match. ie. SELECT 'abc' = 'ABC';
will return true.
In order to turn off this feature, you should add the keyword 'binary'.
Examples:
SELECT binary 'abc' = 'ABC'; will retur
mysql:ÄúºÃ!
»¶Óµ½ÏÄÊÏÀñÆ·Íøhttp://www.xiagift.comÃâ·Ñ·¢²¼¸÷ÖÖÉÌÆ·¹©Çó¼°È˲ÅÕÐƸÐÅÏ¢!
ÐÂÉÌÆ·,ÐÂÆæÀñÆ·,È˲ÅÕÐƸ,ÐÅÏ¢·¢²¼Ó¦Óо¡ÓÐ!
ÐĶ¯²»ÈçÐж¯,¸Ï¿ìµã»÷http://www.xiagift.com
--
¾¹ý2¸öÔµÄÕýʽÔËÐУ¬¡°ÏÄÊÏÀñÆ
select count(distinct targetrange) from job;
The index would help, but with a 255 char field, you'd suffer with disk
space.
HTH
Mervyn Chapman
- Original Message -
From: "Daevid Vincent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 12:03 AM
Subject: How do
Hi David,
Use:
SELECT COUNT(DISTINCT targetrange) FROM job;
Cheers!
On Thu, Feb 20, 2003 at 09:03:29PM -0800, Daevid Vincent wrote:
> Given this table, I want to count the number of distinct targetranges.
>
> CREATE TABLE job (
> job_id int(10) unsigned NOT NULL auto_increment,
> cust
Given this table, I want to count the number of distinct targetranges.
CREATE TABLE job (
job_id int(10) unsigned NOT NULL auto_increment,
customer_id int(10) unsigned NOT NULL default '0',
scanner_id int(10) unsigned NOT NULL default '0',
status_id int(10) unsigned NOT NULL default '0',
hi,
can u just mail me the link that i asked for...
thanks
regards
sunil gavaskar
Sunil Gavaskar wrote:
Hello,
I need to know the link for Mysql Bug Database.
I tried a lot in google...but not yet got it.
somebody send me the link plz...
Thanks a lot in advance
regards
sunil gavaskar
--
Hello:
I'm fairly new to MySQL and think there is an easy query to get what I need
done, but not sure how to do it. I thank everyone for their help in
advance.
I have two tables.
Table1: Series
SeriesID
SeriesTitle
Table2: Links
LinkID
Series
LinkTitle
I need a query that I can group the link
Hi MySQL folks,
I'm very excited to try MySQLGUI. Unfortunately for some reason I can't
connect to the database. I'm running MySQLGUI 1.7.5-1, the linux static
version, on RedHat 8.0. It opens fine, but when I enter the password I
just get this error:
Can't connect to local MySQL server
In the last episode (Feb 21), Zhestkov Victor said:
> I have a table with varchar column and when I execute SELECT query like that:
> SELECT * FROM sometable WHERE somecolumn='abc '; it returns records which
> contain records with bo 'abc ' value, and which are only 'abc'.
> Thry this SELECT 'a
mine is getting a 0 at solaris2.7
mysql> select 'a'='\';
+--+
| 'a'='\' |
+--+
|0 |
+--+
1 row in set (0.04 sec)
mysql> status
--
mysql Ver 12.16 Distrib 4.0.9-gamma, for sun-solaris2.7 (sparc)
Connection id: 159
Current database:
Current us
I have a table with varchar column and when I execute SELECT query like that:
SELECT * FROM sometable WHERE somecolumn='abc '; it returns records which
contain records with bo 'abc ' value, and which are only 'abc'.
Thry this SELECT 'abc' = 'abc '; it returns true. I think it rather strange.
A new, free, Internet security mailing list archive is now online and
searchable on the Security Clipper website at:
http://www.securityclipper.com
Over 50 security- and privacy-related email mailing lists,
including MySQL-bugs, are available and all are freely searchable.
--
At 22:45 +0200 2/20/03, Dubery wrote:
Hi all,
I have a table that includes an auto_increment field.
This is used to build up an audit trail of the passage of a file through my
server. As a file is received from a remote system I create the first entry
for that file in the audit trail table. I bu
> When running script under Windows NT as "mysql -h host -u user
> --password=password MySQL and send the script I have stored in "scriptfile.sql". However
if I
> try the same thing under Windows98 it does not work. It connects to
the
> server then gives a MySQL prompt instead of sending the scr
> I have a table that includes an auto_increment field.
>
> This is used to build up an audit trail of the passage of a file
through
> my
> server. As a file is received from a remote system I create the first
> entry
> for that file in the audit trail table. I build up an sql INSERT
command
> (I'
Is there a way i can subscribe to this list as a digest user's mode,
Similar to mailman's digest feature. I was trying to get to the mailman
user's preference page but cannot find it on mysql.com. Can anyone help me
MySQL uses ezmlm. You need to unsubscribe from this list and subscribe
to the d
All you need to do is set up a MySQL user that allow the Windows box to
access the MySQL database.
Regards,
KH
> Hello,
>
> I hope it is okay to ask this here. I have a MySQL server running on
> Slackware 8, and I would like to access it from a Windows box using Excel
> (for now). I'm downloa
The typical syntax for this would be:
INSERT INTO phone (personID, phoneNr, email, type)
SELECT personID, '1-xxx-xxx-', \N, 'OFF'
FROM persons WHERE lastName=''
HTH,
Tore.
- Original Message -
From: "Kyle Lange" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, Febru
Hi all,
I'm trying to load a 1:M table with rows. I've been thru the manual
and discussion list and each comes close but not quite. I'm trying to
load a full table with 4 cols, but one of them needs to be a key to
another table SELECTed enroute. 'LAST_INSERT_ID()' doesn't help because
the main ta
hi list,
Is there a way i can subscribe to this list as a digest user's mode,
Similar to mailman's digest feature. I was trying to get to the mailman
user's preference page but cannot find it on mysql.com. Can anyone help me
out here.
thanks,
MT
-
Hello,
I hope it is okay to ask this here. I have a MySQL server running on
Slackware 8, and I would like to access it from a Windows box using Excel
(for now). I'm downloading the ODBC driver for windows, but is there
anything I need to do on the MySQL server side? I'm a bit confused about
that.
C:\WINNT\system32\drivers\etc
There should be one there by default
Jerry
- Original Message -
From: "Sunfire" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:32 PM
Subject: Re: Access Denied Help Needed
> if i remember right you should make a hosts file
if i remember right you should make a hosts file in c:\windows\ dir and
thats where it sits.. at least thats where i have mine and it works fine...
in the file do this:
127.0.0.1 localhost
#or whatever your domain name and ip address is but its
#the same format and always include localhost
-
can you post line 4 of the script ?
Jerry
- Original Message -
From: "Sunfire" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:11 PM
Subject: @ character appended at end of username problem
> hi..
>
> i have an mysql username that is in the form of an em
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Feb 03 01:41:06 Taipei Daylight Time
[EMAIL PROTECTED] wrote:
It seems someone has forged a from header and it appears to be from the
vbfx.com domain (my domain). I hope that you see it is not originating from me
or my server.
I am writing an application that will store
information in a MySQL database. I would like to
encrypt the data being stored in the database using
the AES_ENCRYPT/DECRYPT functions. My question is,
how can I securely contain the password in memory
within the application?
For example, the applicati
hi..
i have an mysql username that is in the form of an email address and when i
use it in my php scripts for some reason i get an error:
warning: connection to host failed access denied for '[EMAIL PROTECTED]@' in
filename.php on line 4
anybody know what the extra @ is for at the end of the user
show tables; ?
or do you mean specific to vb ?
Jerry
- Original Message -
From: "Jeff Pearson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 10:31 PM
Subject: List of Tables
> I am writing a vb.net application to do some db management on MySQL. Ive
> got
MySQL-List,
I have just installed MySQL on a Windows 2K machine. I followed the
directions to make it secure and now I'm getting the "Access Denied"
error. I found in the manual that I should create a hosts file to fix
this. Where do I put it? From what I see, in the C:\mysql\bin folder,
I sho
SHOW TABLES;
Then treat the output as a normal result set.
see the manual for more about SHOW syntax
http://www.mysql.com/doc/en/SHOW.html
-Original Message-
From: Jeff Pearson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 2:31 PM
To: [EMAIL PROTECTED]
Subject: List of Tabl
Jeff Pearson wrote:
I am writing a vb.net application to do some db management on MySQL. Ive
got it pretty far but am at a point where I am stuck. I know with php
there is a list tables function. Does anyone know of a way to list the
tables of a given database outside of php?
Any help would be G
I am writing a vb.net application to do some db management on MySQL. Ive
got it pretty far but am at a point where I am stuck. I know with php
there is a list tables function. Does anyone know of a way to list the
tables of a given database outside of php?
Any help would be GREATLY appreciated.
hi,
this is the problem.
# /usr/bin/rsync -vvaz --delete rsync://sunsite.dk/mysql/
/var/www/html/mysql/
opening tcp connection to sunsite.dk port 873
rsync: failed to connect to sunsite.dk: Connection refused
rsync error: error in socket IO (code 10) at clientserver.c(89)
where should I mirror
Hi All,
Once again we have run into a situation where our production
database is throwing an error regarding the use of table locks for
"no apparent reason".
We are running MySql on windows with InnoDb. We have a section
of code which is working fine most of the time but occasionally will
MySQL, SQL, Query ...
Does anyone know of a transaction history utility for MySQL? What
I am looking for is something that logs a before/after entry anytime
a change occurs in a MySQL table. I want to be able to say
definitively "these changes occurred at these times".
There are, of course, two
On Thursday 20 February 2003 22:32, Jeff Kilbride wrote:
> Hi Guilhem,
>
> Ok, good. At least this is a confirmed bug and not something on my end. :)
Yes, you are not crazy and that's good news.
> Hopefully, this will be considered a "critical" problem and fixed in 3.23,
> since it makes all the
Hi Guilhem,
Ok, good. At least this is a confirmed bug and not something on my end. :)
Hopefully, this will be considered a "critical" problem and fixed in 3.23,
since it makes all the replicate_* config commands useless. Was this
introduced recently? Can I downgrade to an older 3.23.x to get ri
Quoting Lenz Grimmer <[EMAIL PROTECTED]>:
Lenz:
# cc -V
Compaq C V6.4-014 on Compaq Tru64 UNIX V5.1A (Rev. 1885)
Compiler Driver V6.4-215 (sys) cc Driver
# cxx -V
ksh: cxx: not found
=
I couldn't find standard source so I used the gamma source. I'm g
I have a host table where I save the platform model. The platform model
can be saved in various ways. For example,
Sun Enterprise 250 (2 x UltraSPARC 164MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 400MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 450MHz)
Sun 250
etc. I can get the count by:
select pl
Hi
Thanks for your bug report.
In latest 3.23 and 4.0, the slave ignores any LOAD DATA INFILE
as long as one of these options is set on the slave :
replicate_do_table
replicate_wild_do_table
replicate_ignore_table
replicate_wild_ignore_table
regardless of the values of these options, which is a
I found the following error with mysql server version 3.23.52.
mysql> select snb,id_servicio from Abonados_Servicios where
snb="1144293549";
9 rows in set (0.01 sec)
mysql> select snb,id_servicio from Abonados_Servicios where snb=1144293549;
9 rows in set (45.61 sec)
mysql> describe Abonados_Serv
Hi all,
I have a table that includes an auto_increment field.
This is used to build up an audit trail of the passage of a file through my
server. As a file is received from a remote system I create the first entry
for that file in the audit trail table. I build up an sql INSERT command
(I'm
updat
Since this is off topic anyway I thought I would throw this in. Instead
of Web-X use
http://www.astaskywire.com/
This would reduce the costs and allow the trainer to host the trainings
and customize the look and feel.
FWIW
Mike
> It would be great to attend more advanced training on Struts. Bu
Heikki / Egor,
I am not using the LOCAL keyword, but I am using selective replication with
the replicate-do-table directive. Could this be causing problems? Here are
the relevant options from my.cnf on the slave:
# The MySQL server
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-lo
Although several years later I just wanted to add my 2 pence worth.
I had similar problems to Chad.
It would appear that mysql_options does not work.
The scenario is.
I have a host to which I am trying to connect but that host is down.
(If the host is up but mysqld is not running then mysql_real_
Hi,
On Thu, 2003-02-20 at 13:20, Mac wrote:
> Hi,
>
> I am using MySQL v3.23 and have a many-to-many relationship (cars <->
> colors) that I have broken up into three tables as follows
>
> cars:
> ID Manufacturer
> 1 Volvo
> 2 BMW
> 3 Toyota
It would be great to attend more advanced training on Struts. But maybe
it is hard for you to get to the city of the presentation. What if you
could from home attend 4 different published authors?
What if additionally there were labs by Best Training as voted by JDJ?
What if you could view the p
Hi,
I think that it's your GROUP BY clause that isn't correct.
Try replacing "GROUP BY sys.name" with "GROUP BY error_t.sys_id"
(ie, group using the same table where you applied the max() function)
I didn't tryed, hope it solves.
On Thu, 2003-02-20 at 15:02, Chris Czeyka wrote:
> Hey all,
>
>
When running script under Windows NT as "mysql -h host -u user
--password=password http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscrib
(7¤ù¸Ë)¡Aµ´¹ï¶WÈ!(Á`ª÷ÃB: 1000¤¸)
Windows XP PRO SP-1 ¤¤¤å"±M·~"¥úºÐ¥¿¦¡ª©
Windows XP Service Pack 1¥]§t¤F±qWindows XP¥h¦~10¤ë30¤é¤W¥«¥H¨Óªº©Ò¦³×¥¿¡A
³o¨Ç×¥¿µ{¦¡¥]§t¤F¦b¦w¥þ©Êªº´£°ª¡A©Ê¯àªº¥[±j¤Î¿ù»~ªº×¥¿¡A
·íµM§ó¥[¤J¤F¥þ·sªºµwÅé³W®æ¤ä´©¡A¤×¨ä¬O USB 2.0ªº¤ä´©¡A
¦Ó¥þ·sªºWINDOWS XP°£¤F§ó·s¤F¨t²Î
Seems to be only a problem when I send the statement to mysql over php. If
I enter the statement with the command line tool everything is fine.
So this is not a mysql problem.
At 15:58 20.02.2003 +0100, Stefan Hinz wrote:
Christian,
> SELECT 'ä' = '\\';
> gives 1 as result!
Not on my server, a
* Dieter Stelzner
[...]
> I have opened a conection to a MySQL-Server database. How I can get a list
> of all available tables inside the database via ODBC with an SQL
> statement?
Send a "SHOW TABLES" command. Full syntax:
SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]
http://www.mysql.com/doc/e
yes ther is a mailing list for php/mysql.. they deal with php and any other
sql servers out there as well as lots and lots of other stuff out there...
it is [EMAIL PROTECTED] but before you send mail to that address
subscribe to it by going to www.php.net and finding the right mailing list
you need
* Inandjo Taurel
> i'd like to have the syntax to import in a mysql table from a tab
> delimited text file, and also the same thing from an excel file.
See the LOAD DATA statement and the mysqlimport utility:
http://www.mysql.com/doc/en/LOAD_DATA.html >
http://www.mysql.com/doc/en/mysqlimport.htm
Thanks for the comments Steve
I am using MySLQ 3.23.53 on XP. I can try the current version and see
what happens.
As an example, I can make a backup with mysqldump, flush the logs, return
to my app and add an item to the database that contains an attachment that
might be an mp3 or bmp stored
* Jianping Zhu
> I need to insert recond to mysql use servlets,
>
> insert into mytable values('key', 'f1');
>
> i need to chech if key is already in mytable.
why?
> what is a good efficient way to do that?
The most obvious answer, do a lookup to check if the record exist:
SELECT * FROM mytable
> I need to insert recond to mysql use servlets,
>
> insert into mytable values('key', 'f1');
>
> i need to chech if key is already in mytable.
>
> what is a good efficient way to do that?
Insert the value and see if a "DUPLICATE KEY" error is returned. Act
accordingly.
---John Holmes...
--
Hi Taurel,
You can use a perl script to do that work for you.A sample is given below
#!/usr/local/bin/perl
use DBI;
#These are the configuration variables
$host ="host on which mysql is running";
$uname = "database user";
$pword = "user password pass";
$dbase = "database name";
#Connect to the
- Original Message -
From: "Chris Czeyka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 10:02 AM
Subject: How to grab the latest record in one query?
[snip]
> Either I'm stupid or it's impossible. Let's see which case is true. :)
I'm sure it's neither. :)
> Is there an equivalent lsit as this that also deals with PHP.
>
> A PHP and MySQL list I am sure MySQL is used in conjunction with other
languages
> but I am only interested in developing PHP and MySQL solutions, unless
someone
> convinces me otherwise.
>
> Also think you for whom ever it was tha
Hello,
I need to know the link for Mysql Bug Database.
I tried a lot in google...but not yet got it.
somebody send me the link plz...
Thanks a lot in advance
regards
sunil gavaskar
-
Before posting, please check:
http://w
On Thursday 20 Feb 2003 3:07 pm, Andrew wrote:
> Is there an equivalent lsit as this that also deals with PHP.
www.php.net have a look through their mailing lists. the General one is good
for tech questions.
> As a matter of interest can I have a show of hands for all those using PHP
> with MySQ
Hello,
1. Bug:
A resultset of i.e. "select * from table" has now the behaviour of a
dynamical cursor, but a ODBC question for cursor type returns "static
cursor".
2. Question:
I have opened a conection to a MySQL-Server database. How I can get a list
of all available tables inside the database via
I need to insert recond to mysql use servlets,
insert into mytable values('key', 'f1');
i need to chech if key is already in mytable.
what is a good efficient way to do that?
Thanks
-
Before posting, please check:
http://
I am using phpMyAdmin. But it is written in php.
Regards,
KH
> Hi all!
>
> I started using MySQL about two months ago (and I already love it!)
> and I'm new to this list...
>
> I would like to know if there's some web interface for MySQL
> management that has been released as open source. Pr
hi,
i'd like to have the syntax to import in a mysql table from a tab delimited
text file, and also the same thing from an excel file.
Thanx
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=fe
> I started using MySQL about two months ago (and I already love it!) and
I'm new to this list...
>
> I would like to know if there's some web interface for MySQL management
that has been released as open source. Preferably this should be in ASP 3.0
or ASP .NET languages, but I'll appreciate to kno
Is there an equivalent lsit as this that also deals with PHP.
A PHP and MySQL list I am sure MySQL is used in conjunction with other languages
but I am only interested in developing PHP and MySQL solutions, unless someone
convinces me otherwise.
Also think you for whom ever it was that pointed ou
Hey all,
My Question:
1. I got a table which tracks errors on systems:
mysql> select id, sys_id, beginn, end, status from error_t;
+++-+-+-+
| id | sys_id | begin | end | state |
+++--
Christian,
> SELECT 'ä' = '\\';
> gives 1 as result!
Not on my server, and with my character set (latin1_de):
mysql> STATUS
--
mysql Ver 12.18 Distrib 4.0.10-gamma, for Win95/Win98 (i32)
Connection id: 6
Current database: menagerie
Current user: superuser@l
I got this forwarded to me.
Yes the library from 4.0 and above is now GPL. And in 3.23 it was LGPL.
As for the inability to link with OpenSSL we as the copyright holder
can allow this. And we do so.
The same license incomparability problem also appears for the Apache
and Eclipse people that we a
Hi all!
I started using MySQL about two months ago (and I already love it!) and I'm new to
this list...
I would like to know if there's some web interface for MySQL management that has been
released as open source. Preferably this should be in ASP 3.0 or ASP .NET languages,
but I'll appreciate
Stefan,
Stefan Hinz wrote:
Richard,
set-variable = max_allowed_packet=16M
Yikes!!! I knew that running "default configuration" gave you SOME
values, but I didn't know they were so small. I've placed the
my-medium.cnf as "my.cnf" in /etc on the Sparc 20, and also in C:\ on
th
MYSQL Ver 8.23 Distrib 3.23.54,
sun-solaris2.8 [binary install]
Sun E4500
Hi we have some seriously bad benchmarks for MYSQL performance on a new
cluster - The problem seems to be IO, but the box is doing nothing:
The first set of results are the benches the second results are from my new
mysql
> why does Mysql consider an 'ä' as equal to '\' ???
> The query
> SELECT 'ä' = '\\';
> gives 1 as result!
I get zero on 3.23.52-max-nt
mysql> select 'ä' = '\\';
++
| 'ä' = '\\' |
++
| 0 |
++
1 row in set (0.00 sec)
---John Holmes...
---
Hi again
I looked in the site and in some place they write:
"you should create an option file for each server. In your startup script
that is executed at boot time you should specify for both servers
safe_mysqld --defaults-file=path-to-option-file "
What is the startup script? is it somthing tha
Hi,
why does Mysql consider an 'ä' as equal to '\' ???
The query
SELECT 'ä' = '\\';
gives 1 as result!
Is this a bug ?
Greetings,
Christian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
I have installed MySQL version Release: mysql-3.23.38 (as found in the
mysqlbug.txt). When I use mysqlimport, I get the following error code
ERROR 1148 : the used command is not allowed with this MySQL version.
I get the same message whenever I use "LOAD DATA".
WHich version should I install ?
I don't have a mailing list, and I don't appreciate your email.
You subscribed to the mysql mailing list, or you would not be getting it.
The instructions to unsubscribe are at the bottom of every message.
Kip McGee wrote:
will you please take me off of your mailing list if you dont im gonna
se
Egor,
>> But now if i try to use it from the mysql-Command-line tool i get
>> an errror 1148, This command is not allowed with this mysql version.
>> On my server the variable local_infile is set to on.
>> I change to my.cnf-File on my client to
>> [mysql]
>> local-infile=1
>> or I try to start my
Jeff,
MySQL does not have system tables from where you could query metadata with
ordinary SELECT queries. You have to use
SHOW CREATE TABLE tablename.
If you do not see your foreign key definitions in SHOW CREATE TABLE, then
you probably are using MyISAM tables, which do not support foreign keys
Thanks to you both, Karam and KH. These suggestions are most helpful.
However, my ultimate goal is to find some sort of "query", via a catalog
table, that can get arbitrary meta data from within the database. This
information will be used in subsequent queries.
Thanks, to you or anyone in the m
Jeff, Egor,
Guilhem Bichot just found a bug in replication of LOAD DATA LOCAL INFILE in
4.0.
The problem is the LOCAL keyword. Of a large import file, only 8 kB or 16 kB
will actually be replicated in the slave. Do you use the LOCAL keyword?
I do not know if the bug affects 3.23.
Are you using
Hello,
I have two questions:
1) How to write my query with SQL_CACHE and UNION ? UNION work with
SQL_CACHE ?
A)
SELECT SQL_CACHE
UNION
SELECT SQL_CACHE
or B)
SELECT SQL_CACHE
UNION
SELECT
2) How to write my
Hi,
I am using MySQL v3.23 and have a many-to-many relationship (cars <->
colors) that I have broken up into three tables as follows
cars:
ID Manufacturer
1 Volvo
2 BMW
3 Toyota
colors:
ID
Hi,
yes I did this .
here were some lines from my server-cfg file:
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=1M
set-variable= table_cache=64
set-variable= sort_buffer=512K
set-variable= net_buffer_length=8K
set-
On Thursday 20 February 2003 14:40, Andy De Petter wrote:
> When I try to perform a LOAD DATA INTO, I get a "Permission Denied"
> problem, although I (should) have the correct privileges, for a specific
> user:
>
>
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
> 'myuse
That's going to be a bit out of date !!
I'd suggest a combination of Paul DuBois's latest offering in blue and the
www.mysql.com search engine.
Keeps me out of trouble, well mostly !
Jerry
- Original Message -
From: "Andy De Petter" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>
Cc
I've just tried, and it seems to work This means, there is an error
in the O'Reilly book (July 1999, 1st Edition) then. ;)
Thanks a lot,
-Andy
On Thu, 20 Feb 2003, Jerry wrote:
> The search engine on www.mysql.com is always worth a look first ...
>
> "For security reasons, when read
Hi,
md5 is a function name, maybe that's why you need to quote the field
name. Check the MySQL manual about that.
On Thu, 2003-02-20 at 10:51, [EMAIL PROTECTED] wrote:
> >Description:
> syntax checker reject length restriction when index char column
> with ending by number.
>
> >How-To-R
The search engine on www.mysql.com is always worth a look first ...
"For security reasons, when reading text files located on the server, the
files must either reside in the database directory or be readable by all.
Also, to use LOAD DATA INFILE on server files, you must have the FILE
privileg
The file resides in /var/tmp (I am using the full path):
LOAD DATA INFILE '/var/tmp/whatever' INTO TABLE ...
-a
On Thu, 20 Feb 2003, Ahmed S K Anis wrote:
> If the File resides in the same machine as the Database, it should
> work.
> If the file resides where the your client program resides, t
I can perfectly connect to the myqsl server, with this specific user .. he
can select/insert/update/whatever, but he gets permission denied errors,
when trying to do a load data infile ;-/
The user has:
GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY
PASSWORD 'password'
GRANT SELECT,
1 - 100 of 126 matches
Mail list logo
