Hi!
When running a query like:
LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS
TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'
(list_id,email,f1,f2,f3)
mysql seems to forget to invalidate the query cache, because added rows are
not displayed in following
SELECT stat
Dear Ladies and Gentlemen,
in order to backup databases or better the whole server file-based , I'd
like
to know , if there is a way to get a read-Lock for all tables in a database
or even better for all tables in all databases.
Something like:
LOCK TABLES .% READ;
which I tried cause I'm foool
no mysql.sock file on machine. I'll remove mysql package and reinstall it
and see if things go better then.On Tue, 4 Feb 2003, Brian Johnson wrote:
> Date: Tue, 4 Feb 2003 14:33:54 -0600
> From: Brian Johnson <[EMAIL PROTECTED]>
> To: 'Tomasz Krasiel' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subj
Hi
Thanks for the information, my Microsoft SQL DBA is looking the DTS VB Script
stuff.
I will post the information if it works
Cheers
--
Jonathan Bedford
Quoting Victor Pendleton <[EMAIL PROTECTED]>:
> In the DTS engine you can write a VB script to handle the quotations during
> the trans
Hi People,
I have been trying to get InnoDb to run on my windows XP machine. I have
MySQL 3.23.55 installed and i am running the mysqld-max-nt server. I
have added the following lines to my my.ini file: (note the # because i
didnt get it to work, i dissabled it)
[mysqld]
.
#innodb_data
Yes,
You can use the FIELD() function:
SELECT * FROM table WHERE recordID IN ($string)
ORDER BY FIELD(recordID,$string)
On Tue, 2003-02-04 at 13:15, Wilbert Enserink wrote:
> Hi All,
>
> I have a string containing recordID's in a specific order (e.g.
> $string=17,2,33,5,99)
> How can I select
Hi Derek,
No it doesn't take alot of techy knowledge, time or trouble to run MySQL
on windows...Just download it and install and it will be ready to
run.Infact installation on a Windows sytem should be easier than on *nix.
Regards,
Eric
===
Kamara Eric Rukidi Mpuuga
C
On Tue, 4 Feb 2003, Mike Blezien wrote:
> Hello all,
>
> I want to change some of our database host settings to allow for other host
> connection other then the default 'localhost' setting. what is the proper way to
> assign a different host to connect to, like an IP address or something like
> "
On Tue, 4 Feb 2003, Jianping Zhu wrote:
>
> I have mysql in a redhat machine. I need to use mysql do user
> authentication to a website.
> I have a table like following.
>
> +--+--+
> | username | passwd |
> +--+--+
> | jianping | jian1830 |
> | chichi | jian18
* Wilbert Enserink
> I have a string containing recordID's in a specific order (e.g.
> $string=17,2,33,5,99)
> How can I select those records from a table in the right order (as
> determined in $string)?
>
> SELECT * FROM table WHERE recordID IN ($string)
>
> results in the right records but not
> I'm thinking of setting up a bulletin board for a system with Windows
2000
> OS.
> Most of the good, affordable BB software uses MySQL databases.
> Is it possible/practical to run MySQL on Windows OS? Does it take a lot
of
> techy knowledge, time & trouble?
Yes, you can run it on Windows. No,
hi there i was wondering if mysql 4 will become production quality soon ? i
would like to convince work to start using it, so i can start using the
transactions, sub selects and query cache
-
Before posting, please check:
http
Hi,
Use the PASSWORD() function to encrypt the password.
There are other encryptation functions in MySQL like MD5(), SHA1(),
ENCRYPT(). Have a look at functions you can use in SELECT statement at
the manual.
http://www.mysql.com/doc/en/Miscellaneous_functions.html
On Tue, 2003-02-04 at 19:58, Jian
Hi,
Simply do the following:
INSERT INTO yourtable (username, password)
VALUES ('chichi', PASSWORD('jian1830'));
The encrypted password will look like this... 2748c558120ee3c9. This is
MySQL's own internal encrypting function.
Remember to set the password to a, CHAR(16) binary not null, field.
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
- Original Message -
From: "Jianping Zhu" <[EMAIL PROTECTED]>
Sent: Tuesday, February 04, 2003 1:58 PM
> I want the passwd field not to be plain text but encrypted. how can i do
> that?
Use the password function:
mysql> create table users (
-> name varchar(12),
-> pass varchar(1
try to use the password() function.
update user set password=password('your_psw') where
user='your_user'
bye
--- Jianping Zhu <[EMAIL PROTECTED]> ha scritto: >
> I have mysql in a redhat machine. I need to use
> mysql do user
> authentication to a website.
> I have a table like following.
>
Hello everybody,
Is it possible to set up this kind of replication and what parameters I have
to set in the my.cnf file ?
Table A own by server A and replicated to server B and C
Table B own by server B and replicated to server A
Table C own by server C and replicated to server A
The mysql level
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.10, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 4 Feb 2003, Manuel Kiessling wrote:
> to allow tables bigger than 2GB, I want to compile MySQL in a way that
> it can utilize the LFS support on my Linux box (SuSE 8.1, ext3 FS,
> should support files up to 2048GB).
>
> Anyone has an advice?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 3 Feb 2003 [EMAIL PROTECTED] wrote:
> Quoting [EMAIL PROTECTED]:
> Also, I used this command:
>
> CC="cc -pthread" CXX="cxx -pthread -O" \
> ./configure --with-named-thread-libs="-lpthread -lmach -lexc -lc"
This is the configure line I u
Hi.
On Tue 2003-02-04 at 12:25:08 -0500, [EMAIL PROTECTED] wrote:
> Ok I'm stumped on what I think should be a somewhat simple query. What I
> have so far is a list of names that is in a list of projects AND in a the
> main contact list by doing the following query:
> SELECT p.name, p.company FROM
I don't know such product running with MySQL. There is something called
Bill storage server which runs with PostgreSQL, perhaps someone knows a way
to put MySQL behind it instead of PostgreSQL.
B.
At 17:26 04-02-2003 +, Ben Clewett wrote:
MySQL,
My first post, please go easy if this is t
Hi all
where do i mention with-raid option in my.cnf file(under which
program)?
i could not find it out in the manual.
thanks in advance
prasanth
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
Hi all,
Does anyone know a program for Windows that can create reports for MySQL
databases?
If you know more, please tell me more, because I need to check which of them
are accessible for the blind.
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
-
Nicholas,
Tuesday, February 4, 2003, 12:25:08 PM:
> Ok I'm stumped on what I think should be a somewhat simple query. What I
> have so far is a list of names that is in a list of projects AND in a the
> main contact list by doing the following query:
> SELECT p.name, p.company FROM contacts c, pro
refer to 1.7.4.1 Subselects in the manual for the
answer. here's a brief example:
The queries:
SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM
table2);
SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM
table2 WHERE table1.id=table2.id);
Can be rewritten as:
SELECT table1.* FROM tab
> MySQL,
>
> My first post, please go easy if this is the wrong pleace!
>
> I'm trying to find an IMAP server which used MySQL so that my Mozilla
> Email client can file it's email a little faster.
>
> Has anybody heard of such a device?
I just finished configuring courier-imap to use a MySQL tab
I notice some of my colleagues have used SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
(for the filter this time: sql,query,q
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
---
hi all
i am working on a very huge MyISAM table in mysql which is updated
every second. this table keeps on increasing.
so i want to store it on different disks(as one would not be
sufficient).
is there any method so that i can store the table on a different disk
once the present disk is full and
>Description:
I have a delete statement and an insert statment. I'm replacing a line but I
want
to make sure, that its deleted. The insertion is successful as per sql batch
output.
But when I dump the data from the table, there is no record for the date !
Seems like
Hi.
On Tue 2003-02-04 at 17:04:39 -, [EMAIL PROTECTED] wrote:
>
> I noticed that when you return a zerofill field from a select statement into
> a server-side language, say PHP or Perl, it will store the number with the
> zeros included, great no problem.
>
> However, if I insert into that t
I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this
Animal sex can be represented in a variety of ways
My mother tongue is not English but doesn't it sound rude ? :-)
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> s
>From the 4.0.8 changelog:
o We now send big queries/result rows in bigger hunks,
which should give a small speed improvement.
Is this configurable ? I'd like to measure various hunk
sizes for my "sql" "query".
/GG
-
Bef
I have a MySQL table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-++
| id | int(10) unsigned | | PRI | NULL
Hi.
On Mon 2003-02-03 at 10:19:59 +0100, [EMAIL PROTECTED] wrote:
[...]
> >That can be made to work with several versions. In other words, it
> >would not check a version number saved in the database, but determine
> >the version by the database structure itself.
> >
> >That would give #2 with the
You are absolutely right! In the /usr/bin/safe_mysqld, there're two lines
where "/var/lib/mysql..." is residing. To me this looks kind of rediculous
(sorry for my stupid comment), why they have those configuration
info hard-coded in the script? Since we already have my.cnf so the
conf info was sup
>Description:
Multiple IS NULL tests in a WHERE clause appear to be broken
when testing NOT NULL date fields. Queries work fine against
varchar and int, probably(?) others.
>How-To-Repeat:
create temporary table test (a date not null, b date not null);
inser
Hi!
InnoDB is a MySQL table type which provides transactions, foreign key
constraints, and a non-free hot backup tool. InnoDB is included in all
versions of MySQL-4.0. You can download MySQL-4.0 from http://www.mysql.com.
As the MySQL-4.0 branch approaches declaration of stability, this InnoDB
re
the whole program halts by itself, this is how my software work
* form loads, then i open a connection, then i close connection but not
terminating it to be use later
* the user click the 'add' button, all related textbox will be enabled.
* the user type in all the details, while typing the th
What type of 'hang' are you reporting? Have you checked the processlist to
see if the connection is processing a request? Are you returning a large
result set that needs to be displayed?
-Original Message-
From: pazenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 7:43 AM
To
Hello,
On Tuesday 04 February 2003 14:46, Grover Cussi N. wrote:
> > restore to the original size ?, I see that the tendence of the innodb
> > tables is to grow, and grow, and never will reduce the size, it is
> > posible to control this?
I had the same problem, it went on until I had 44G of Inno
Crescent,
if you look at the yourhostname.err file in the MySQL datadir, does it
contain anything?
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
sql query
...
Shomal,
- Original Message -
From: "Shomal Bafna" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, February 04, 2003 7:46 PM
Subject: Innodb: Limited creation of tables
> The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2
> Linux with Duron pr
Hello all,
I want to change some of our database host settings to allow for other host
connection other then the default 'localhost' setting. what is the proper way to
assign a different host to connect to, like an IP address or something like
"mysql.somedomain.com",..etc..
thx's
mysql databa
Locate the mysql.sock file and create a symbolic link to the
/var/lib/mysql/mysql.sock file. :)
- Brian J.
-Original Message-
From: Tomasz Krasiel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: ERROR 2002
I installed MySQL 3.23.54 on
- Original Message -
From: "Alex Shi" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>; "mysql group"
<[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 10:39 PM
Subject: Re: datadir and socket
> But still I have question regarding my.cnf: I searched the whole
On Tue, Feb 04, 2003 at 01:27:13PM +0200, Okan CIMEN wrote:
> Hi all,
>
> First of all , the version of mysql is 3.23.52. I am using When I do a
> truncate table on a MyIsam table, the show table command shows thatt there
> are no records but the table size is about 100 MBs.
>
> Afterwards, I run
Hello all,
I want to change some of our database host settings to allow for other host
connection other then the default 'localhost' setting. what is the proper way to
assign a different host to connect to, like an IP address or something like
"mysql.somedomain.com",..etc..
thx's
--
MikeBlezi
On Tue, Feb 04, 2003 at 12:32:27PM +0900, kk wrote:
> > I have previously used a company in India and I am not averse to
> > trying this again.
> You are not supposed to turn your face against all indian companies and just
> pass your personal comments in a userlist like this.
> Your experien
At 14:36 04/02/2003 +0200, Ciprian Trofin wrote:
Hi,
I tested against the last release 3.23.55/4.0.10 and
below the results:
c:\mysql\bin>mysql -uroot -p test
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.55-max-deb
I have mysql in a redhat machine. I need to use mysql do user
authentication to a website.
I have a table like following.
+--+--+
| username | passwd |
+--+--+
| jianping | jian1830 |
| chichi | jian1830 |
+--+--+
I want the passwd field not to
Hello,
sorry for this question, after googling for nearly 2 hours, I really
thought I found out everything I could on my own.
Just found this one:
http://www.mysql.com/doc/en/Full_table.html
and my questions are answered. Thanks and sorry again.
--
Manuel Kiessling
-
Hi,
I am trying out mysql-4.1.
I got the source code;
configured it using --with-sharset=big5;
successfully build it and got it installed.
However, the following error occurrs,
while mysqld is starting up.
/usr/local/libexec/mysqld start
/usr/local/libexec/mysqld: File
'/usr/local/share/mysq
In the last episode (Feb 04), Shomal Bafna said:
> The box is running a MySQL 3.23-47 Max rpm based version on a
> Mandrake 8.2 Linux with Duron processor and 256MB Ram. Thera are 10
> InnoDb type tables created and several MyISAM types too (approx 30
> more.). On adding the 11 table of InnoDb type
56 matches
Mail list logo
