Le reponse de Harald est entirement correct. En plus il existe un
liste en français:
Liens utils :
Poster un message: [EMAIL PROTECTED]
S'abonner: [EMAIL PROTECTED]
Se désabonner : [EMAIL PROTECTED]
Ecrire au proprio : [EMAIL PROTECTED]
URL sur Yahoo :
Hi,
I have mysql running on a redhat-9. (rpm files)
I tried to change the datadir from /etc/my.conf without succes.
What do I have to do to change the directory of my databases from
/var/lib/mysql (default) to /mnt/data/mysql ?
is the fact that /mnt/data a vfat partition a problem (if it is, I
Please don't hijack other threads. It's not that hard to start your own.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: phieu huynh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 29 May, 2003 21:00
Subject: can't unzip the mysql V4.1.0
Hi,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victoria Reznichenko wrote:
George Pitcher [EMAIL PROTECTED] wrote:
I think I've tried that.
This is how I start MySQL
mysqld --enable-local-infile
No joy I'm afraid. I've got round a minor problem in moving a MSAccess db
using SQLyog but that
Try something like SELECT formatted_date FROM mytable WHERE
formatted_date BETWEEN '04-08-2003' and '07-08-2003';
Or something along those lines, I would get more specific but I do not
have specific information to go from.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From:
Hi Edward,
I expected this question to come up once more, so I think that this would
have happened anyway, so let's just forget it shall we ? ;-)
Probably it's only you and me reading it ;-)
Best regards
Nils Valentin
Tokyo/Japan
On Fri, 30 May 2003 09:07:17 -0400, Becoming Digital
[EMAIL
Hi Jean;
enter into /etc/my.cnf or ~/.my.cnf
datadir=/mnt/data/mysql
login to mysql and do
SHOW VARIABLES LIKE '%data%'
That should do it.
Best regards
Nils Valentin
Tokyo/Japan
On Fri, 30 May 2003 15:06:35 +0200, Jean Christophe [EMAIL PROTECTED]
wrote:
Hi,
I have mysql running on a
Michael Satterwhite [EMAIL PROTECTED] wrote:
Is there a tool for displaying / printing the tables and table definitions for
a given database? I know about info / show, I'm looking for something that
can take a database name and produce the entire definition report.
Whar about mysqldump?
Davy Obdam [EMAIL PROTECTED] wrote:
I am trying to run this query:
UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id
= 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name
But i keep getting the same error message
You have an error in your SQL syntax near
It appears that if I try to insert an illegal value into an INT field, the
value is set to 0 instead of NULL, even though the field has NULL as a
default.
Is this documented behavior, and if so, what's the rationale?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Edward,
Thanks, this worked with the field, however it only works in the shell. I am
trying to make it work in a PHP page.
Here is my code, am I doing something wrong?
?php
$substring = SELECT SUBSTRING_INDEX(field, 'p', 5) FROM table WHERE
start_date = CURRENT_DATE ORDER BY start_date DESC;;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stephen Fromm wrote:
It appears that if I try to insert an illegal value into an INT field, the
value is set to 0 instead of NULL, even though the field has NULL as a
default.
Is this documented behavior, and if so, what's the rationale?
Yes.
Hi folk!
I would like to know how to create a new file mysql.sock, because it was
deleted of /tmp and i perceive that it don't was in the binary file
tar.gz.
Thanks for reply!
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I am getting this mysqld got signal 11 error and Server process is shutdown. I
am trying to setup replication on two solaris 2.8 sparc boxes. MySql version is 4.0.12.
Anyone else had this experience?. Any help is appreciated.
Thanks
Sakthi.
Hi,
I have to search a big database.
Now there are many categories i.e computerlanguage = C++, Perl,Php,Visual
Basic, C, Javascript.
In my table
C++ =1
Perl = 2
PhP = 3
VB = 4
C = 5
Java = 6
and i have a select statment like this
SELECT * FROM lang WHERE language = 1 OR language = 2 OR language
Hello
If you are on windows then you can try SQLyog at
http://www.webyog.com/sqlyog which has GUI interface
to do just for what you are looking.
Karam
--- Michael Satterwhite [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there a tool for displaying / printing
Hello
I have two MySQL 4.1 servers installed. One at home
and at my work. Both run WinXP.
I used mysqldump to export my database at work and
tried to import it at my home server, I am getting the
following error in one of the - create table
defintaion
Error Code : 1064
You have an error in your
Nils:
thank you so much for the response. Below are results related to '%time%' from the db
giving 2013 error:
mysql SHOW VARIABLES LIKE '%time%';
+--+---+
| Variable_name| Value |
+--+---+
| connect_timeout | 30|
How about
SELECT * FROM book WHERE book_prg IN (1, 4, 6) ;
Dies that make any difference?
|-+
| | Anthony Ward |
| | [EMAIL PROTECTED]|
| | r |
| ||
Hello
I have a MySQL 4.0.3 server with SSL option. I know
that the SSL option is runnish coz when I do show
variables...i am getting the value for ssl to be true
:)
I am writing a C app to connect to the MySQL server to
do some jobs.
I am using the mysql_real_connect() function to
connect. The
You are going to have to use the backtrace utility (Stackdump analyzer)
see http://www.mysql.com/doc/en/Using_stack_trace.html
Hth,
Martin
- Original Message -
From: Sakthivel Muthusamy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 10:19 AM
Subject: Replication: Master
O. I've got a headache trying to understand joins. I'm definitely NOT a
database guru.
Why in the world doesn't this work?
SELECT dacspriv_name
FROM dacspriv
WHERE dacspriv_id not in (SELECT dacspriv_id
FROM dacs_access JOIN users
ON dacs_access.user_id=users.user_id
WHERE
O. I've got a headache trying to understand joins. I'm definitely
NOT a database guru.
Why in the world doesn't this work?
SELECT dacspriv_name
FROM dacspriv
WHERE dacspriv_id not in (SELECT dacspriv_id
FROM dacs_access JOIN users
ON dacs_access.user_id=users.user_id
WHERE
I did find out :-)
I had to edit the mysqld in /etc/rc.d/init.d
It's can be done on a linux partition without problem.
;-)
Jean Christophe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Short answer is mysql does not do sub-selects (i.e., a select inside of a
select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions, 4.x+,
supported sub-selects.
Ryan
__
Do you Yahoo!?
Yahoo! Calendar - Free
mtoth [EMAIL PROTECTED] wrote:
This is on a production server and I would rather not stop and restart it.
Also I don't think HUPing mysqld will make it read my.cnf again.
In version 3.23.51 there are very few options and variables that you can reset via SET
command. In your case you need
ian ward [EMAIL PROTECTED] wrote:
I have created a database using Windows XP Professional OS and granted all
priviliges to a user called rwuser with a specified password. I am
attempting to access the data in a table through MySQL ODBC 3.51 Driver on
Windows XP Professional. I have
Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world do I
accomplish the following:
I have these tables:
dacspriv - with dacspriv_id,dacspriv_name,short_name
users - with user_id,username
dacs_access - with
Andre Ribeiro Barros [EMAIL PROTECTED] wrote:
I would like to know how to create a new file mysql.sock, because it was
deleted of /tmp and i perceive that it don't was in the binary file
tar.gz.
File mysql.sock is created when MySQL server is started. So, just start MySQL server
:)
--
Short answer is mysql does not do sub-selects (i.e., a select inside
of a select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions,
4.x+, supported sub-selects.
Ryan
__
Do you Yahoo!?
Yahoo! Calendar -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 30 May 2003 11:40:11 +1000, phieu huynh wrote:
The problem is my netscape browser, somehow the file had been corrupted.
I just re-download the file by using another computer and I can unpack
the file.
Yes, navigator can be twitchy about
Hi
We are running Mysql 4.0.12 on a FreeBSD 4.5 machine. We are
trying to get Request Tracker 3.0 (http://www.bestpractical.com/rt)
working. Each time we start up the mysqld process, it steadily consumes
processor time until it reaches ~90%. This bogs down the computer and
makes the
This may be a PHP rather than MySQL issue
I'm using 4.0.13 on Windows XP and Apache 1.3.
My phpinfo() shows (among others) QUERY_STRING and REQUEST_URI in the
Apache environment and _SERVER[QUERY_STRING] with _SERVER[REQUEST_URI]
under the PHP variables.
On my ISP, who is running
Maximum precision for DECIMAL column in MySQLMatt,
in 4.1 this restriction has been removed:
[EMAIL PROTECTED]:~/mysql-4.1/client mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.1-alpha-debug-log
Type 'help;' or '\h' for
It looks like the maximum precision for a DECIMAL column is 17 in MySQL.
Is this documented anywhere? I get the following results:
mysql CREATE TABLE `scale_test6` (`a_dec` decimal(30,23) default NULL)
TYPE=MyISAM;
mysql INSERT INTO scale_test6 (a_dec) VALUES
Hi... silly question maybe.
I want to execute the following query:
mysql_query(SELECT MIN(order), MAX(order) FROM downloads WHERE class='1');
...but it doesn't work and gives me a SYNTAX ERROR. If I use my 'id' column
(the primary key) instead of the 'order' column, it works fine:
mike wOZniewski wrote:
Hi... silly question maybe.
I want to execute the following query:
mysql_query(SELECT MIN(order), MAX(order) FROM downloads WHERE class='1');
order is a reserved word.
try:
MIN(`order`), MAX(`order`)
Note use back ticks ` NOT '
...but it doesn't work and gives me a
1) Are your users connected temporarely (disconnecing after a certain time) or
do you stay connected until the server crashes ;-)
Both temporary connections and persistent connections. The number of
connections fluctuates based on the number of simultaneous clients.
2) Check your
Hi.
Lately, I've been banging against the glibc 2GB malloc limit - what a
headache. :/
I believe this is not a mysql-specific problem, so a might be a bit off
topic here. Does anyone know of a way to work around this limit? Does
Redhat Advanced Server also have this problem? Or Suse Enterprise?
No, this was perfect. I had totally misread (I figured out after I
bothered everyone!) --it was I had always been taught and as you say.
I hope you have seen my most recent question to the list? About
manually entering the data? The short and sweet answer there be that
someone ALWAYS has to
Hi all,
I have been having a problem with MySQL lately on my machine - I
apologize for the long post. Specs are:
RedHat Linux 7.3
MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as well)
Apache 1.3.27
PHP 4.3.1
(most (99%) of the MySQL connections are made through PHP scripts
On Friday, May 30, 2003, at 05:13 AM, Becoming Digital wrote:
My question is: must I manually enter the value from the people_id
(primary key of people table) into the machine_id field of the
machines table? My only question here (unless you see others ;) is
must I manually enter these
---Original Message-
--From: Steven [mailto:[EMAIL PROTECTED]
--RedHat Linux 7.3
--MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as
well)
--Apache 1.3.27
--PHP 4.3.1
--
--(most (99%) of the MySQL connections are made through PHP scripts
--running as an apache module)
--
Foreign keys have been available in InnoDB tables since 3.23.43b.
A here's couple of pages to check out:
From the InnoDB Manual pages:
4.3 Foreign key constraints
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
From the MySQL Manual:
1.8.4.5 Foreign Keys
4.8-STABLE and linuxthreads-2.2.3_10 and gcc3.2
It's easy for me to reproduce this bug on my system, but I don't know if I could
come up with a simple test case for someone to play with.
Do you compile with the BUILT_OPTIMIZED flag?
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Wed, May
OK, first of all thanks for the pointers, however, the query I now have
doesn't seem to work. If I run the query up until pricelevel IN (1, 2, 3,
4, 5) it returns a large result set (the clauses are fairly inclusive),
however, when I add in the rest of the query no results are returned. Any
The gist; the below query doesn't finish, can't figure out why.
-- Query --
SELECT
images.iid,
images.locnetid,
images.path,
images.CD,
lightbox_location_image_LINK.iid
FROM
images
CROSS JOIN
image_cat_location_link
LEFT OUTER JOIN
Hi Nils,
So if I su to root and try to start mysql, I get the following... does that
mean I'm secure? I am still finding the very confusing, but doing my best
to look it up on dejanews and in books etc so as to not stress this group
too much.
[root admin]# mysql
ERROR 1045: Access denied for
You have no ON condition for image_cat_location_link.
Chris Cameron wrote:
The gist; the below query doesn't finish, can't figure out why.
-- Query --
SELECT
images.iid,
images.locnetid,
images.path,
images.CD,
lightbox_location_image_LINK.iid
FROM
It just means you didn't enter the password for root.
2Hosts.com wrote:
Hi Nils,
So if I su to root and try to start mysql, I get the following... does that
mean I'm secure? I am still finding the very confusing, but doing my best
to look it up on dejanews and in books etc so as to not stress
Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world
do I accomplish the following:
I have these tables:
dacspriv - with dacspriv_id,dacspriv_name,short_name
users - with user_id,username
dacs_access - with
Well, it's not blowing up on me and returning a jillion records. Trouble is,
it's also not returning any records at all.
Thanks for the suggestion, though. I'll keep plugging away at it.
susan
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30,
Grettings! I'm new to the list, and I hope this isn't off-topic. I've got
a MyISAM table that is about 3.3 GB in size. The index is around 4.7GB. I
started a REPAIR TABLE nnn QUICK last Sunday in a mysql session, and its
still running. The index keeps getting updated, but I can't tell if it
Thanks, Jeff. You saved me a lot of typing. ;)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Jeff Shapiro [EMAIL PROTECTED]
To: Ted Rogers [EMAIL PROTECTED]
Cc: Becoming Digital [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, 30 May, 2003 14:30
Try this.
?
$substring = SELECT SUBSTRING_INDEX(field, 'p', 5) FROM table WHERE
start_date = CURRENT_DATE ORDER BY start_date DESC;;
$response = mysql_query( $substring, $dbh );
while ( $data = mysql_fetch_array( $response ) ) {
print $data['field_name'].\n;
}
?
I'm not sure if it
Hi all,
I'm in the process of designing a database and I'm a bit of an
optimization freak ... I'd like to make sure that the actual structure
of the database is optimal.
With that said, my question is about TEXT fields. In the actual CREATE
TABLE statement, would it make the table
Hi,
I would like to use one query to compare aggregate values from columns
in two separate tables. I am running mysql 3.23.55 (max). Here is a
simplified table structure:
job
- job_id
- name
quote
- quote_id
- job_id
- quote_amount
actual
- actual_id
- job_id
- actual_amount
I'm
This select statement will give you the job name and difference between the
actual amounts and quote amounts fo all jobs that have both quotes and
actuals:
SELECT job.name,sum(actual.actual_amount)-sum(quote.quote_amount)
FROM quote, job, actual
WHERE (job.job_id=actual.job_id) and
Hi All
After stumbling at a few points during make of the MySQL 4.0.13 on HP-UX 11.00, I've
come to a point where I will need some help. I'm trying to do make install and I get
the following error:
gmake[2]: Entering directory
We have a hosting provider with a Linux box and an MySql database.
We have a local Mysql database.
In both machines I use phpMyAdmin.
When I export from Windows to Linux then all the data in Linux is messed up with
respect to special characters, we work in spanish and all accents are lost and
In a nutshell, I have a query that runs in 28 seconds until I perform a
REPAIR TABLE against one of the tables in the query then execution time
jumps to 51 seconds. The only way to get the query time back down is to
TRUNCATE and repopulate the table. I've been operating under the assumption
that
I have a query where I use a LIKE on a DATETIME field and it used to work
i.e.: WHERE article_datetime LIKE '2003-05%'
but when we upgraded to 4.1 it stopped working (it didn't return any
results). In itself I find that increased restrictiveness to accomplish
no purpose. And then I found out
You might try some partial queries before the big one to see if there are
reasonable results -
select count(*) , list.prodcode
from application as app, application_list as list
where app.id=list.appl_id
AND app.name IN (7, 23, 16, 9, 18, 24, 25, 5, 13, 11, 10, 6,
20, 14, 19,
22,
Ahem, please ignore this post - I should have been doing:
AND app.id IN (7, 23, etc.)
DOH!
Thanks to everyone for their help though...
Mikey
-Original Message-
From: Mikey [mailto:[EMAIL PROTECTED]
Sent: 31 May 2003 12:53
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Why
Hi,
I have a database table:
CREATE TABLE FTPFILE (
ID int(11) NOT NULL auto_increment,
FTPSITEID int(11) DEFAULT '0' NOT NULL,
FILENAME varchar(254) DEFAULT 'Not defined' NOT NULL,
FILEPATH varchar(254) DEFAULT 'Not defined' NOT NULL,
FILEEXTN varchar(3) DEFAULT '---' NOT NULL,
Don't use varchar unless you absolutely have to, that should help.
Jerry
- Original Message -
From: Ulterior [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 3:13 PM
Subject: Insert query
Hi,
I have a database table:
CREATE TABLE FTPFILE (
ID int(11) NOT
So what would be an alternative to varchar? text? but then how mysql will
index such table?
text is a blob record.
Ulterior
- Original Message -
From: Jerry [EMAIL PROTECTED]
To: Ulterior [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 1:19 PM
Subject: Re: Insert query
sow what would you suggest, Jerry?
( I need a very FAST search on this table's filename field)
Ulterior
Don't use varchar unless you absolutely have to, that should help.
Jerry
- Original Message -
From: Ulterior [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, May 31,
68 matches
Mail list logo