Dear all
I had a query here, could someone pls tell me what is in there?
load data infile 'c:/rate/hkd_rate.csv' into table hkd_deposit
(hkd_chiperiod) fields terminated by ','
This error comes out:
you have an error in your SQL syntax near 'fields terminated by '," at line
1
Aim:
What i wan to
Before you voice out asking any question, you'd better go to
http://www.mysql.com and take a good look and the documentation first.
maxim wrote:
>
> Hi
>
> ... A problem in the following.
> I do(make) the project for university.
> A subject of the project: the Internet shop for small and ave
Hi
... A problem in the following.
I do(make) the project for university.
A subject of the project: the Internet shop for small and average business.
At me 1 computer Cel 350 128/33.2 Win2000/php/Apache/MySQL Max (InnoDB).
The project creation of model of shop is stipulated. The database sho
>Description:
It appears that MySQL can have trouble with a searchterm
in a boolean-mode fulltext index search which is both prefixed
with + and suffixed with *, when that searchterm is paired
with another required term. The empty set is returned when there are rows
which should match.
>H
Hi
... A problem in the following.
I do(make) the project for university.
A subject of the project: the Internet shop for small and average business.
At me 1 computer Cel 350 128/33.2 Win2000/php/Apache/MySQL Max (InnoDB).
The project creation of model of shop is stipulated. The database sho
>Description:
According to the documentation at
http://www.mysql.com/doc/F/u/Fulltext_Search.html, placing double-quotes
around a phrase within the AGAINST clause of a full-text boolean mode
search should match only rows which contain this phrase exactly as
typed. Instead, it appears tha
Hi,
I don't understand, I modified ulong ft_min_word_len=3; in
myisam/ft_static.c, and then recompiled MySQL using
BUILD/compile-pentium --without-innodb script, but show variables still
displays after restarting mysql :
| ft_min_word_len | 4
|
| ft_max_word_len |
>Description:
When performing an UPDATE on a field which is fulltext indexed and
currently contains the NULL value, the MySQL server restarts and the update
fails.
>How-To-Repeat:
SQL code to reproduce problem:
create table test (id int, data text, fulltext(data));
insert into test
On Thursday, 16. May 2002 21:44, Benjamin Pflugmann wrote:
> Hi.
>
> What you observe is the fact that "-1" will be converted to the format
> of the index, else the index could not be used.
>
> Converting -1 to an unsigned number give the biggest possible number
> for the type in question (here BI
I am getting this message when I try to establish a connect to the DB. Any
suggestions on where I can find an answer?
Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2) in /var/www/html/mysql/php/connect.php on line 2
Todd
--
Todd Cary
Ariste Software
2200 D Stre
Original Message
Subject: Bug Report
Date: Thu, 16 May 2002 21:28:21 -0400
From: hugh <[EMAIL PROTECTED]>
Organization: The Dualies
To: [EMAIL PROTECTED]
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comment
Hi,
What characters should i parse when using an INSERT statement that has
string values? So far, i had troubles with single quotes and minus signs.
What should i do with them? Is there any others?
Thank u very much,
Edilson.
Edilson Vasconcelos de Melo Junior
[EMAIL PRO
Dear MySQL wizards,
Perhaps this is more of a Perl question than a mySQL question but I am trying
to access a mySQL database.
Here is the line of code.
if ($q->param('field') eq "") {&printform()} else {&results()}
This gives the reply:
Use of unitialized value in string eq at select.cgi
You might try running queries seperately and check performance to see
if it Perl or mySQL
mike
"Norris, Joseph" wrote:
>
> I am running mysql and apache on windows 2000. Everything is running
> smoothly and then all of the sudden my perl scripts that have been running
> just find are
* Joao A. Marques
> Let´s supose that we have a table with this features :
> - about 7 records;
> - only a primary index;
> - about 30 fields;
> - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
> typically uses about 3 or 4 fields in the WHERE clause.
None of them beeing the primary
Hi,
Let´s supose that we have a table with this features :
- about 7 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
Creating indexes, one for each field used on SELECTS, wil
I'm not new to MySQL but have only recently familiarized myself with InnoDB.
One question I have so far been able to find an answer on is the datafiles.
Let's assume I have 5 GB worth of information, this information changes
regularly. Performance wisewould I be better off using a single 5GB
Perhaps memory utilization issues? Does the box start thrashing?
Norris, Joseph wrote:
> I am running mysql and apache on windows 2000. Everything is running
> smoothly and then all of the sudden my perl scripts that have been running
> just find are loading
> very very slowly. I am not sure i
I am running mysql and apache on windows 2000. Everything is running
smoothly and then all of the sudden my perl scripts that have been running
just find are loading
very very slowly. I am not sure if it is mysql, perl, apache or what. These
are the same scripts that have been running just fine
Hello,
I like to limit the size of a database (or if possible all databases of a
mysql user) to some value. It should work like the disk quota for disk
space.
Thanks for any hints,
Alexander Newald
-
Before posting, please c
Hi,
try :
show tables status;
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Taylor Lewick" <[EMAIL PROTECTED]>
To: <[EMAIL PR
Hi,
Look at http://www.mysql.com/doc/L/O/LOAD_DATA.html
and you can try this...
load data infile 'yourfile' into table your_table fields terminated by
'\your_separator_char_for_fields' lines terminated by
'\your_separator_char_for_row';
Regards,
Gelu
__
Everytime you have something to ask, first point your browser to :
http://www.mysql.com/doc/
Type in the keywords (in this case LOAD DATA)
The first url in the resultset will be :
http://www.mysql.com/doc/L/O/LOAD_DATA.html
which is what you are looking for.
Gurhan
-Original Message-
SHOW CREATE TABLE tablename;
or
SHOW TABLE STATUS LIKE 'tablename';
gives you what you want...
See:
http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html
http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html
Gurhan
-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thu
MySQL do it for you:)
Quoted from the online documentation is:
"
MySQL automatically converts numbers to strings as necessary, and
vice-versa:
mysql> SELECT 1+"1";
-> 2
mysql> SELECT CONCAT(2,' test');
-> '2 test'
If you want to convert a number to a string explicitly, pass it a
I read in the Mysql manual where you can change the default column seperator, but it
didnt specify how to do this.
So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go
to find out about mysql command syntax...?
Thanks,.
Taylor Lewick
Unix System Administrator
>From my sql How can I see what the types of tables I have are.. i.e. how do I verify
>if a table is an ISAM, HEAP, InnoDB...
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
*
Sergei Golubchik wrote:
> rebuild your indexes (the proper way to do it is to issue
> REPAIR table_name USE_FRM
Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick?
TIA,
Vadim.
/* sql, mysql to satisfy the spam police */
i think u dont need to it will automatically deal with it.
- Original Message -
From: "Marcel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 16, 2002 3:26 PM
Subject: STRING TO NUMBER
> Hi,
> In Oracle i use TO_NUMBER to convert a String to a Number what Function Do
i
Hi.
What you observe is the fact that "-1" will be converted to the format
of the index, else the index could not be used.
Converting -1 to an unsigned number give the biggest possible number
for the type in question (here BIGINT UNSIGNED). None of your numbers
is bigger than this, so you get an
restart the MySQL server
happened to me this week when I was copying files (and changing the schema) while the
server was running
HTH
Dave
-Original Message-
From: Frederic Dhorne [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2002 15:32
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: ERRO
Isn't the following:
SELECT * FROM t1, t2 where tl.ID=t2.foreignKey;
logically equivalent to:
SELECT * FROM t1 LEFT JOIN t2 ON t1.ID=t2.foreignKey WHERE t2.ID IS NOT
NULL;
Because I had a query in the first format that took about two minutes to
run on MySQL, and then I changed it into the se
Peace to All,
In Bible said:
If a man doing something wrong for the first time or he don't know , give
the second chance and show him the right way...and if don't want to follow
it , let him
...or something like that.
If you use ODBC you have many ways but the short one is to have a variabl
Hi,
In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i
have to use in Mysql ??
thank´s
Marcel.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Hi,
Same bug with MySQL-4.0.2 latest source.
Regards,
Jocelyn Fournier
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Alexander Keremidarski" <[EMAIL PROTECTED]>
Cc: "Terra" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, May 16,
Hello.
On Thu, May 16, 2002 at 12:10:10PM -0400, [EMAIL PROTECTED] wrote:
> At 11:25 AM 5/16/2002, Alexander Keremidarski wrote:
[...]
> >It is normal to have a difference there. It is not beacuse of how
> >concat() and() concat_ws() work, but how GROUP BY works.
>
> Is this 'unpredictable behav
Hi All,
Using MySQL server version 3.23.49-nt I get strange results when running the
following very simple test. I am wondering if this is a bug, feature or
perhaps a standart SQL behaviour??
CREATE TABLE test(id BIGINT UNSIGNED);
CREATE INDEX test_idx on test(id);
INSERT INTO test VALUES (0)
Can you login to mysql from a perl script by passing it an encrypted password..?
Taylor...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
Hi.
shell> mysqldump --help | grep 'quote\|Ver'
mysqldump Ver 8.14 Distrib 3.23.38, for pc-linux-gnu (i686)
-Q, --quote-names Quote table and column names with `
don't know why it isn't the default, but it seems you can force them
this way.
Regards,
Benjamin.
On Thu, May 16, 2
Hello.
On Thu, May 16, 2002 at 06:25:42PM +0300, [EMAIL PROTECTED] wrote:
[...]
> >mysql> select *,concat_ws('.',oct1,oct2,oct3,oct4)
> >ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group
> >by oct1,oct2,oct3,oct4 having c>1;
>
>>+--+--+--+--+--+-
Please stop reposting your question.
You should be able to get this information from Delphi. Set up a time object
before you execute the query.
On Thursday 16 May 2002 10:19 am, Alexander Burbello wrote:
> I made a program with delphi and I would like to get the message when is
> execute any q
Unsure exactly what you want but I use message box's in my apps to say if
there is an error or whatever.
This, as far as I know, has to be done in the program not in the SQL.
> Alexander,
> Thursday, May 16, 2002, 5:40:41 PM, you wrote:
>
> AB> I made a program with delphi and I would like to ge
T.D.,
Thursday, May 16, 2002, 6:54:45 PM, you wrote:
TDH> I am working with a mySQL database in which some column names contain
TDH> hyphens. These have to be enclosed in backquotes (`table-name1) within
TDH> SQL statements.
TDH> Problem: when generating its own SQL statements, mysqldump does n
Hi!
Good questions!
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, May 16, 2002 6:41 PM
Subject: MySQL/InnoDB questions from a MyISAM background
> We have just migrated a huge installation to InnoDB from MyISAM.
> W
Hi.
IMHO you need to do some more digging yourself and present more
precise question. At least, if you get no other answers, which I
rather doubt.
The problem is that the answers depend heavily on information you did
not provide (e.g. what are the requirements for the system? "high
availibility"
Hi.
Well, what's the problem with using isamchk in detail?
Shut down the mysql daemon, run "isamchk" on all tables to find out
which are corrupted and run "isamchk -r" on those. Then restart
mysqld. Do not forget to make backup copies of the tables in question
beforehand, in case anything unexpe
Hello.
On Thu, May 16, 2002 at 01:39:59AM +0200, [EMAIL PROTECTED] wrote:
[...]
> > It sounds as if you want
> >
> > ALTER TABLE your_table ADD INDEX( message_id )
[...]
> Well, the FAQ is where I went first, of course. And then I came up with
> this,
>
> "ALTER ignore table $table MODIFY messag
Sampson, Peter wrote:
> Gabriel.
>
> This works fine and the two tables talk to each other.
>
> BUT,
> My website can have 5 - 10 news stories per month. So in the tblNews I
> could have
>
[Snip multiple rows]
> I need to use DISTINCT in the SQL lingo as I "bind" the recordset's
> "nMonth"
Hi Aaron (if that's your name)
using LIKE with a '%' as the first character means MySQL cannot use the
FileName index (since % means anything, the index is no use) - if you can, take
out the first '%'
Also, you mention indexing GroupID, but talk about ProductID - is this a typo?
If this doesn
I made a program with delphi and I would like to get the message when is
execute any query.
eg: select ...
10 rows in set (0.04 sec) " .
This message is important for me. How can I get it.
Alexander
A busca mais veloz e precisa da internet. Aces
Hi all,
I would like to know how often (delay in sec.) the slave checks the
master for new records in the log, and if one can control that .
Thanks in advance
Vlady
(mysql)
-
Before posting, please check:
http://www.mysq
Hello Alexander,
At 11:25 AM 5/16/2002, Alexander Keremidarski wrote:
>Terra wrote:
>>Greetings,
>
>
>
>>mysql> select *,concat_ws('.',oct1,oct2,oct3,oct4)
>ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by
>oct1,oct2,oct3,oct4 having c>1;
>>+--+--+--+
Taylor,
Thursday, May 16, 2002, 4:22:37 PM, you wrote:
TL> Regarding mysql...
TL> 1) Are primary keys and foreign keys by default indexes for a table?
Yeah. Primary key is index by default. Foreign key constraints you can create only
on indexed column.
TL> 2) Do I have to use a special data oth
Andre,
Wednesday, May 15, 2002, 6:05:16 PM, you wrote:
AS> Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a
AS> half year. Our way to rotate the binlog files was to stop all software
AS> inserting data into the Prod. DB and then reset the master and the
AS> replication serve
Norris,
Thursday, May 16, 2002, 5:57:51 PM, you wrote:
Neoen> Here is the situation. I have to connect to Mysql running on another
Neoen> windows 2000 box. I have never done this before. Do I set this up in the
Neoen> tables as another
Neoen> host and use the -h parm in command shell and the ho
Alexander,
Thursday, May 16, 2002, 5:40:41 PM, you wrote:
AB> I made a program with delphi and I would like to get the message when is
AB> execute any query.
AB> eg: select ...
AB> " 10 rows in set (0.04 sec) " .
AB> This message is important for me. How can I get it.
In general you can't get
I am working with a mySQL database in which some column names contain
hyphens. These have to be enclosed in backquotes (`table-name1) within
SQL statements.
Problem: when generating its own SQL statements, mysqldump does not
enclose these names in backquotes -- so when I try to restore a databas
I want to ignore a database from bin-logging. I know that in
my.cnf, I can set binlog-ignore-db=database_name but for various
reasons, that's not available to me. How would I pass that option
in on the command line via safe_mysqld? Passing it in as an option
or a set-variable option causes MySQ
I'm finally getting around to working with InnoDB for real :-)
Anyway, is there any reason to still use MyISAM on any tables.
Concurrency is my biggest problem (Locked tables, etc.). My theory is
that the tables that wouldn't benefit from converting to InnoDB are so
small (5-50 rows?) that I m
I have partitioned my data such that each client has its own database
(clientdb1, clientdb2, ... clientdbN). All the databases have the same
structure (same tables, columns, etc.). This design works great except for
one caveat - when I make a change to the database structure I have to make
the sam
Terra wrote:
> Greetings,
>
> mysql> select *,concat_ws('.',oct1,oct2,oct3,oct4)
>ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by
>oct1,oct2,oct3,oct4 having c>1;
>
>+--+--+--+--+--+-+---+--++---+
> | ID
http://rpmfind.net
Thank You
<><><><><><><><><><><><><><><><>
Daniel Negrón
Lotus Notes Administrator / Developer
KB Electronics, Inc.
954.346.4900x122
http://www.kbelectronics.com
<><><><><><><><><><><><><><><><>
|+>
|| Curt Söderberg|
|
Hi all,
I would like to know how often (delay in sec.) the slave checks the master for new
records in the log, and if one can control that .
Thanks in advance
Vlady
(mysql)
-
Before posting, please check:
http://www
Hi!
Going through my email backlog...
Just a short update on this.
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> On Monday 29 April 2002 04:39 am, David Harper wrote:
>> >Description:
>> I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49
>> with mast
Hi,
I don't know what caused it, nor whether it's reproducable, but on an AIX system,
I just found out that both of the 4.0.1 masters (typical master=slave_of_master loop
using same source tree configuration) have created 100.000+ files of the replication
log.
I can only think they are replicat
We have just migrated a huge installation to InnoDB from MyISAM.
While I can feel the power and potential and appreciate this
sophistication of what I have at my disposal, I am having some
performance issues that are most likely due to my ignorance.
Answers to the following questions should help
group,
Here is the situation. I have to connect to Mysql running on another
windows 2000 box. I have never done this before. Do I set this up in the
tables as another
host and use the -h parm in command shell and the host parm in my perl
scripts? or is there another way to do it?
Any help woul
I made a program with delphi and I would like to get the message when is
execute any query.
eg: select ...
10 rows in set (0.04 sec) " .
This message is important for me. How can I get it.
Alexander
A busca mais veloz e precisa da internet. Acess
I made a program with delphi and I would like to get the message when is
execute any query.
eg: select ...
" 10 rows in set (0.04 sec) " .
This message is important for me. How can I get it.
Alexander
A busca mais veloz e precisa da internet. Acesse
I have now installed "mysql-DBI-perl-bin".
But I still get a message about "failed dependencies: MySQL-DBI-perl-bin is
needed by MySQL-bench-3.23.49a-1".
Is this because of the spelling of mysql / MySQL?
Or is it something else?
/Curt
torsdagen den 16 maj 2002 14.23 skrev Curt Söderberg:
> Hi,
Hello,
I am using mysql 3.23.38 on winnt.
I have a table already filled with default value, that way we do only
updates during our processing.
One column is specified as not null in the table definition and it's also an
index.
everything was working fine, Until we decided to use "Optimize Table
Bill,
Wednesday, May 15, 2002, 11:42:00 PM, you wrote:
BF> Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM
BF> tables on which I am unable to do updates or inserts. I get error
BF> message #1036 'Table is read only.' I am able to sign on to the database
BF> through the root,
Eigner,
Thursday, May 16, 2002, 2:05:01 PM, you wrote:
EE> I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL
EE> Version 3.23.49a ?
EE> I havn'tfound it in the documentation so i hope you could help me
What OS do you use? Linux?
If you use MySQL from RPM just
rpm -U
Norris,
Wednesday, May 15, 2002, 6:54:46 PM, you wrote:
Neoen> I have been using (very happily) mysql on unix boxes. I am in a new job and
Neoen> there is not a unix box in sight!!! ouch!
Neoen> This is a windows 2000 shop. Here is the situation and I am looking for any
Neoen> and all sugge
Tom,
Thursday, May 16, 2002, 4:30:50 AM, you wrote:
TB> I am trying to turn off the query log in mysql on redhat linux. It generates
TB> huge log files
TB> (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance.
TB> safe_mysqld was run with --log, and it seems like I want to
Jaan,
Thursday, May 16, 2002, 5:19:20 PM, you wrote:
JJ> Just installed Red Hat Linux on a machine. I included the MySQL packages
JJ> but cant get it up working.
JJ> When starting from shell it looks like this:
JJ> $ mysql
JJ> ERROR 2002: Can't connect to local MySQL server through socket
JJ> '
Rance,
Thursday, May 16, 2002, 4:13:04 PM, you wrote:
RH> On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql
RH> 3.23.??, I think) I have a testing and programming box, only one user is
RH> connecting to the database at a time.
RH> Now, the mysqld startup sequence au
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote:
>> After even more tracking stuff down, I managed to isolate it to a
>> change made in MySQL 4.0.1. ?The query in question was doing:
>>
>> ? INSERT INTO ... SELECT ...
This is the explain select sql query on this table containing 500 records
now:
| table | type | possible_keys| key | key_len | ref
| rows | Extra |
+---++--+--+-+--
-+--+--
Check your indexes.
Daniel Lim wrote:
>Hi there,
>I have MySql version: 3.23.36 running on RedHat 7.1, it has been
>working fine for sometimes until a day ago when the INSERT into for new
>record appeared to return OK status but upon verifying the record isn't
>there?
>
>This is an example;
>
>From my understanding primary keys and foreign keys are indexed. Someone
correct me if I'mwrong here. And you shouldn't have to do anything else to field
besides
make it a float to usenegative numbers.
-Nick
>
Regarding mysql...
> 1) Are primary keys and foreign
keys by default indexes for a t
Make sure mysql owns the tables and their directorys, and has write
privileges to them.
I talking about UNIX permissions here, not mysql permissions.
Bill Flanagan wrote:
>Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM
>tables on which I am unable to do updates or insert
Hi there,
I have a user table with lots of different column types. Now I do experiance
problems filtering out special date. The performance is really bad.
So maybe I did just pick the wrong column types?!
This is what I picked so far:
| Type | Null | Key | Default | Extra
| med
[snip]
SELECT DISTINCT
u.user_id,
u.user_name,
max(
if(u.sex=2,25,0) +
if(u.age=4,25,0) +
if(u.country='gm',25,0)+
if(l.language_id='de',25,0)
)
AS ranking,
c.country_code,
c.country,
ct.city,
l.language_id,
Regarding mysql...
1) Are primary keys and foreign keys by default indexes for a table?
2) Do I have to use a special data other than float to allow for negative numbers,
i.e. I want to be able to enter -1.76 and be able to later do math against that
number...
Thanks,
Taylor
Taylor Lewick
U
Dear MySQL list monitors...
Please do something about the following address that has apparently joined
the list.
every time I send a message to the list, I get a bouned message saying that
the message is undeliverable.
Thanks
>From: "Mailer-Daemon" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED
On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql
3.23.??, I think) I have a testing and programming box, only one user is
connecting to the database at a time.
Now, the mysqld startup sequence automatically starts 5 occurances of the
mysqld server.
Id like to cons
Hi there,
I have a huge querry which takes for ever on a table containing only 2000
records.
Maybe there is a way to reorganize this querry since it contains a join and
lots of other stuff I am not really familar with.
Let me first show you the sql query:
SELECT DISTINCT
u.user_id,
Hi,
I have installed MySQL from rpm's downloaded from mysql.com.
All seems ok except when I try to do "rpm -i MySQL-bench-3.23.49a-1.i386.rpm"
I get an error message from rpm saying the I need "MySQL-DBI-perl-bin".
Where can I find this "MySQL-DBI-perl-bin"?
Thanks in advance!
/Curt
--
Gabriel.
This works fine and the two tables talk to each other.
BUT,
My website can have 5 - 10 news stories per month. So in the tblNews I
could have
nMonth t1 t2
2 I am a line This is one,
too.
2
Hi everybody.
Just installed Red Hat Linux on a machine. I included the MySQL packages
but cant get it up working.
When starting from shell it looks like this:
$ mysql
ERROR 2002: Can't connect to local MySQL server through socket
'var/lib/mysql/mysql.sock' (2)
What have I done wrong?
best r
Hi!
> "Andrey" == Andrey Kotrekhov <[EMAIL PROTECTED]> writes:
Andrey> -LДобрый день.-A
Andrey> Are mysql know about this!!!
>>
>> Sorry but if your OS doesn't support gethostbyname_r(), then
>> mysql_real_connect() is not thread safe (I have just updated our
>> documentation about this)
On Tue, 14 May 2002, j.random.programmer wrote:
> Can someone (who knows this sort of thing) give a
> layman's introduction to the interplay between
> various gcc versions and various mysql versions
> (3.49, 3.50, 4.01 etc) ? I have some linux boxes
> and don't really want to have to install/us
What platform (Win32, Linux, BSD, etc.) are you using?
If you have Win32 machine in the mix (doesn't need to be a server), suggest
you use the Export tool in MySQL-Front (http://www.anse.de/mysqlfront/).
We've replicated databases from Win32 to Linux and Linux to Linux with it
many times.
Gerald
Hi!
> "Michael" == Michael Chang <[EMAIL PROTECTED]> writes:
>> For example, have you called mysql_thread_init() before calling
>> mysql_real_connect() in all your threads ?
Michael> However, to my understanding, mysql_thread_init() is not needed if
Michael> only one database connection is
Hi all.
This may (or may not) be a newbie question. But I've called it a newbie
question since I am a newbie to MySQL (and SQL for that matter). Here is
what I want to do:
I want to join three tables into one, where one specific colomn may have
more than one entry for each row.
The spesifics ar
Hello
I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL
Version 3.23.49a ?
I havn'tfound it in the documentation so i hope you could help me
Greetings Ed
-
Before posting, please check:
http://www.mys
On Thu, 16 May 2002 17:05:25 +0800
"Jack" <[EMAIL PROTECTED]> wrote:
> Dear all
> I had a mysql Database in one of my Server, now i want to transfer this
> whole Database to another Server, what should i do?
>
> 1. How i can export this Database to a file
If your DB server (source) is not runni
Greetings,
While working on a routine to clean out some duplicate entries from our IP management
table, I stumbled upon the following errant behavior...
Logging to file 'concatbug.txt'
mysql> \s
--
Connection id: 73465
Current database: OBFmtable
Current user:
Hi, all
Links to the information are necessary. Master/slave the architecture.
Implementation of the system of a high degree of availability on a basis master/slave.
Implementation of a control master/slave.
Examples of the code of implementation of a monitoring system.
Who realized thi
1 - 100 of 112 matches
Mail list logo
