Hi,
I have a requirement of storing and retrieving data in 2 languages - namely English
and Arabic.
>From what I have been able to understand, that would require me to have 2 MySQL
>servers running simultaneously.
Can somebody please tel me : 1)if there are any other better ways 2) if this i
Hi,
Sorry, it didn´t help.
create table tPruefBesch (fTimestamp timestamp(14), fPruefbeschNr int
auto_increment not null, fPlanNr int, primary key (fPruefbeschNr));
mysql> explain tPruefBesch;
+--+--+---+---++--+
|
> When I execute mysqld -u root -p
> I am presented with the default variables.
The manual says to use safe_mysqld to properly start mysqld. Also,
--user=root is clearer for that option. And, what are you doing with -p
in starting the daemon? This is not an option, it is an
error.
http://www.
> Any way to hint a particular index for a query?
>From the manual (http://www.mysql.com/doc/J/O/JOIN.html)
"As of MySQL Version 3.23.12, you can give hints about which index MySQL
should use when retrieving information from a table. This is useful if
EXPLAIN shows that MySQL is using the wrong
You can do what you asked for by making a temporary table, as follows.
create temporary table T (this varchar(..), that varchar(..));
insert into T select tbl1.this, "no record" from tbl1 left join tbl2 on
tbl1.id = tbl2.id where tbl2.id is null;
insert into T select tbl1.this, tbl2.that from tbl
On Tue, Mar 05, 2002 at 09:15:59PM -0800, Amit Lonkar wrote:
> hi
> Does Mysql support Transat SQL???
Nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 26 days, processed 912,69
Hi,
I run SuSe 7.2 and have upgraded to the current suse versions of
mysql.
Server version 3.23.41-Max-log
Protocol version10
Connection linux.lisse.na via TCP/IP
TCP port3306
I have added mysqld and mysqld-max to the /etc/hosts.allow and can
access
hi
Does Mysql support Transat SQL???
Amit
__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
-
Before posting, please check:
http:/
On Tue, Mar 05, 2002 at 05:30:31PM -0800, Steven Roussey wrote:
> Jeremy,
>
> Mytop is simply awesome. Thanks!
Thanks, glad ya like it.
> I recently updated to 0.9. I have a request: how about the qps mode show
> total qps as well as breaking them out (selects, inserts, updates,
> deletes, and
Hi,
I'm a newie to SQL, and to Linux, so please forgive my blaring blunders...
I know I have an x86 Linux machine, running Redhat 7.2, and I know that I
like RPMs better than binary installations
When I get to the Stable Version/Linux/RPMs download area, the following
options are availabl
Hi
What I want to do is import data from some other
database to Mysql. For this the requirement is that,
each record before being added to Mysql database,
should pass through a loop say 5 times. This I want to
do using only SQL. I do not want ot use Java or any
other language. Any idea as to how
At 19:10 05/03/2002 +0100, Othmar Stehlik wrote:
Hi!
>Hi
>
>I installed MySql on Win2k and everything worked fine, than I also installed
>Oracel, mysql refused to work, than I deinstalled Oracle and did a new mysql
>setup.
>But when I try to start mysql, with mysql\bin>mysql
mysql.exe is the clie
> > PMFJI, but has anyone done any testing to see if persistent
> > connections with MySQL and PHP is actually faster in practice?
>
> Without testing, I suspect that it is faster but that the gains are
> very small. If this was Oracle, it'd be a whole different story. The
> connection
Hi,
Select Sum(ifnull(column1,0)+ifnull(column2,0)+
...+ifnull(columnn,0)) From tbl group by ..
Anvar.
At 11:34 PM 05/03/2002 +0100, you wrote:
>Dear,
>
>I am stuck on something,
>I would like to summarize multiple columns to a total value in a query and
>then display the output with php in a
Hi Richard,
On Wed, 2002-03-06 at 13:02, Richard S. Huntrods wrote:
> Interestingly enough, pulling records without a sort was rather
> random (rather, influence by the last sort) - but once I placed a primary
> key on the table, the order of unsorted records is always constant, even
> after a so
Jeremy,
Mytop is simply awesome. Thanks!
I recently updated to 0.9. I have a request: how about the qps mode show
total qps as well as breaking them out (selects, inserts, updates,
deletes, and other) as is possible with the Com_ status variable in
the later versions of MySQL (no documentat
I wrote:
> Didn't see anything on this specific question in a quick search of the
> database. If I just missed it, I apologize.
Okay, okay, RTWM.
> What I have in mind is being able to read the Japanese error messages on
an
> MSWindows box.
>
> So I wanted to make a mysql\share\japanese_sjis di
DLN,
Thanks. Interestingly enough, pulling records without a sort was rather
random (rather, influence by the last sort) - but once I placed a primary
key on the table, the order of unsorted records is always constant, even
after a sort (based on numerous tests yesterday and today with the table
Hi,
Below is the content of my my.cnf file.
I would like to get the optimum performance from MySQL and would
like to modify some of the values.
Specifically, my W2K Machine has 192MB of ram, what should I
have in order for MySQL to take advanatge of that 192MB memory
and what effect does it ha
Hi.
This is a known bug and IIRC fixed by 3.23.49a. Try that and report
back, if you still have problems.
Regards,
Benjamin.
On Tue, Mar 05, 2002 at 01:22:34PM -0800, [EMAIL PROTECTED] wrote:
> I have a several Redhat machines with MySQL 3.23.* installed on it.
> When I upgrade any of
Steven Roussey wrote:
>>Any way to hint a particular index for a query?
>>
>
> From the manual (http://www.mysql.com/doc/J/O/JOIN.html)
Thanks. I missed that. Unfortunately, as I was afraid, this is a very
MySQL-specific way of doing it. But then, hints always are DB-specific, so
that's not
Hi,
On Tue, 2002-03-05 at 23:55, Petre Agenbag wrote:
> I have recently had some problems with web forms not updating the
> website ( use PHP and the insert page should first enter the form data
> into a table and then update the status field in a second table
> correlating to the entry just m
Hi,
On Wed, 2002-03-06 at 11:12, Shankar Unni wrote:
> (Using mysql 3.23.38 - commercial version)
>
> I have a table that has two indexes: one on just "creationTime"
> (iv_alert_creation_ix), and one on "(state, creationTime)" (iv_alert_state_ix).
>
> When I issue this query:
>
> explain sele
(Using mysql 3.23.38 - commercial version)
I have a table that has two indexes: one on just "creationTime"
(iv_alert_creation_ix), and one on "(state, creationTime)" (iv_alert_state_ix).
When I issue this query:
explain select uuid from iv_alert
where state = 1
and creationTime >= '20020201
I do have a mysql user, and have used the commands to assigne rights for the
mysql user per the instructions. I have no hostname.err, only linux.err
which displays the exact same errors I typed out.
Mark
- Original Message -
From: "James Montebello" <[EMAIL PROTECTED]>
To: "Intrex" <[E
On Tue, 5 Mar 2002, Intrex wrote:
> Ok.
>
> SuSE 7.3
> Digital HiNote VP745
> mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu
>
> Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47
> for SuSE
>
> I have installed the .tar.gz and followed those instructions
> I ha
Ok.
SuSE 7.3
Digital HiNote VP745
mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu
Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47
for SuSE
I have installed the .tar.gz and followed those instructions
I have installed the RPM's using the -i, and also installed t
I was the one having issues getting Lost Connection and whatnot for no
reason.
I have recompiled under glibc2.2.5 with 2.95 and 3.04.
I just tried 4.0.2 from the source tree.
Sometimes from the command line of doing mysql -uroot -p I get this:
ERROR:
And that's it.
I run it again, and it go
"Dr. Michael Wittmann" <[EMAIL PROTECTED]> writes:
> one solution could be to install a more recent compiler version and try
> to recompile again. be aware that actual rpm's will be created by rpm
> version 4, whereas redhat 6.2 has rpm version 3 installed which possibly
> cannot handle version-4
Hi again
I'm Working with PB 8.01 , mysql odbc 3.51 driver, Mysql 4.01 alpha-max-nt ,
OS Platform:w2k service pack2, using INNODB table type
I design a Datawindow using 2 retrieval arguments, in my preview seem to
works fine...but when I run my application it doesn't retrieve any data...
If
Try this like, http://www.entropy.ch/software/macosx/ , they're great
instructions and binaries.
Michael
On Tuesday, March 5, 2002, at 06:38 PM, Ray Hughes wrote:
> I have been going out of 'my' mind. I am trying to install mysql on
> a Macintosh OS X server. Can anyone give me instructio
Josiah,
> What is the command prompt to create a user in mysql?
GRANT privileges ... TO user_name IDENTIFIED BY 'password'
Manual: 4.3.1 GRANT and REVOKE Syntax
Regards,
=dn
-
Before posting, please check:
http://www.mysq
Thi Cao wrote:
>
> Hello everyone,
>
> This is my first attempt at MySQL database replication. Can't seem to get
> it to work yet. The problem reported in the error log of the slave server
> is as follows:
>
> Error reading packet from server: Access denied for user 'repl@slave_host'
> (Usin
Leif,
> I'm not sure what you mean by "tbl2's population is a sub-set of that
> in tbl1". tbl1 contains user id nums and hours each user spent
working on a
> project. tbl2 contains user id nums and the first and last names that
> correspond to each user id. There are user id nums in tbl1 that
Mark,
This probably won't get you the response you wanted. How about letting
us know where you have gotten to and where things seem to be breaking. A
generalized request for "what do I do" often recieves little or no help.
Some basic system information would also be much appreciated; what d
I have been going out of 'my' mind. I am trying to install mysql on a
Macintosh OS X server. Can anyone give me instructions on how to do
this? I have been to numerous sites with no luck. We run OS 10.1.2
server, I have mySQL 3.23.49 running (from entropy). During the install I
had to ch
No need to get all snarky. People are confused because there's a whole
section in the manual that covers the installation, step-by-step, with no
cryptic mumbo jumbo. This is at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Linux-RPM
and basically tells you to down
Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100
TIMES is NO help. I have read this file, I have used the appropriate
.tar.gz, I have reinstalled, I have used the most current RPM's
How about contributing something USEFUL, like a REAL answer, that anyone can
follow. No
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using password: YES) (read_errno 0,ser
What is the command prompt to create a user in mysql?
Thank you,
Josiah Wallingford
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi,
Download the binary distribution that suits your system and read the
"INSTALL-BINARY" file.
Also, make sure the online documentation at
http://www.mysql.com/documentation/index.html
Regards,
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
Dear Alainq,
> I am stuck on something,
> I would like to summarize multiple columns to a total value in a query
and
> then display the output with php in a table.
> the summarize works for 1 column but not for two or more.
> any suggestions >?
So is what you are doing something like?
(would it
Why does
SELECT SUM(column1 + column2 + column3) AS combined FROM table
not work for you? The php echo is no different from any other data... your column name
is "combined"
if you fetch_array or fetch_assoc.
Please post more information if this does not accomplish what you require.
Cheers,
#
Dear,
I am stuck on something,
I would like to summarize multiple columns to a total value in a query and
then display the output with php in a table.
the summarize works for 1 column but not for two or more.
any suggestions >?
Thanks alot
---
>Description:
A slave replication only one of many databases from a master
will fail with a "error 'Can't read dir of './otherdb/' (Errcode: 2)
on query 'DROP DATABASE otherdb' if the slave was not replicating
that database.
>How-To-Repeat:
Create a master
Sure seems that way to me. Same SQL engine no matter what table type you
use.
InnoDB didn't scare me. Pretty friendly to use. :>)
--Walt
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 2:09 PM
To: [EMAIL PROTECTED]
Cc: Tobias Lind - Tel
Couldn't you return the data you need by using an outer join? The rows in
tbl1 that aren't in tbl2 would have null values in the name fields. You
could order by the name fields.
Or, you could migrate the data to Oracle and use DECODE to put "No record"
in the name fields that are null. :>)
--W
I have a several Redhat machines with MySQL 3.23.* installed on it.
When I upgrade any of them to MySQL 3.23.49 the timezone stops being
recognized. I have verified that MySQL 3.23.46 and 3.23.47 work properly
by downgrading some of our servers. 3.23.49 always uses UTC according to
'mysqladmin v
On Tue, Mar 05, 2002 at 09:58:13PM +0100, Steve Rapaport wrote:
> I sure would, thanks Monty and Tobias. In particular some sample
> update/insert/delete db code for MyISAM vs. InnoDB, (especially in
> the case where you're not adding transactions, just trying to take
> advantage of row-locking.
DN-
I'm not sure what you mean by "tbl2's population is a sub-set of that
in tbl1". tbl1 contains user id nums and hours each user spent working on a
project. tbl2 contains user id nums and the first and last names that
correspond to each user id. There are user id nums in tbl1 that do not
exi
Happens randomly among all my scripts.
Mysql is being started with:
/usr/sbin/mysqld --basedir=/ --datadir=/usr/local/lib/mysql --user=mysql
--pid-file=/usr/local/lib/mysql/mysqld.pid --skip-locking -O
max_connect_errors=1 -O back_log=30 -O max_connections=580 -O
table_cache=512 -O
Machine ha
I sure would, thanks Monty and Tobias.
In particular some sample update/insert/delete db code for MyISAM
vs. InnoDB, (especially in the case where you're not adding
transactions, just trying to take advantage of row-locking.)
Assuming something changes, of course.
The other thing is a page on rep
At 15:34 -0500 3/5/02, Chuck Roberts wrote:
>I was wondering if Mysql has aliases, that is, a short command
>representing a long MySql command. Say I want to do a "show
>status", so I map an alias to "ss" and do "ss" when I want to do
>a show status.
No.
-
hi!
> the source rpm for mysql 3.23.49 contains build
> instructions for gnu compilers 2.95 or newer.
> redhat 6.2 comes with a compiler that cannot
> handle the "permissive" flag (i think its ecgs-2.91).
A-HA!!! Thanks a lot!
> therefore the build fails.
>
> one solution could be to install
Hello.
I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel 2.4.17,
and glibc 2.1.
Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and
headed the warnings and downgraded to 2.95.
Randomly I get the Lost Connection using PHP 4.1.2... Any idea why?
Thanks
Adam
I was wondering if Mysql has aliases, that is, a short command
representing a long MySql command. Say I want to do a "show
status", so I map an alias to "ss" and do "ss" when I want to do
a show status.
-
Before posting, please
Um, if there aren't any records in tbl1.id that match tbl2.id, it will return zero
records. I am not
away of the ability to output strings as custom errors, but you will get an Empty Set
result. You
can use that result in whatever front-end language you are using to output anything
you like.
D
Hello.
I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel
2.4.17, and glibc 2.1.
Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and
headed the warnings and downgraded to 2.95.
Randomly I get the Lost Connection using PHP 4.1.2... Any idea why?
Thanks
Adam
On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote:
> On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote:
> > When the machine is pounding away on updates (over 300/sec), it can
> > take a long time to get a response to SHOW SLAVE STATUS. ?I get one,
> > but it can take between 5 an
Hi.
On Tue, Mar 05, 2002 at 12:10:47PM -0700, [EMAIL PROTECTED] wrote:
[...]
> > Of course, MySQL has some kind of internal order depending on many
> > factors, but you may not rely on it. And neither you may rely on the
> > fact that a PRIMARY KEY influences the internal order. You have to use
>
Leif,
> I want to select and join data from two tables if the same id exists
in both
> tables. If the id only exists in one table I want MySQL to return a
string
> like "sorry, no records found". How can I do this?
>
> I'm guessing it's something like:
>
> mysql> SELECT tbl1.this, tbl2.that FRO
You can use "logical lock" - set a STATUS int <>0 (probably the ID of user)
to indicate someone started to edit it interactively to block other user to
edit the same record.
Before you write it back to disk, read it again in a buffer to keep all data
possible changed by batch updates.
Or separate
Richard,
> > I guess your "problem" comes from the fact that SQL has no concept
of
> > internal order. If you do not specify an ORDER BY clause, the order
or
> > records returned is undefined, i.e. random.
>
> That's what I was figuring. I asked because I wanted it confirmed.
Thank
> you.
>
> >
>Description:
mysqld just stops responding. 'mysqladmin ping' hangs without any message
>How-To-Repeat:
Cannot reproduce manually, happens during normal operation
>Fix:
Asking You :)
>Submitter-Id:
>Originator:ilm.ee
>Organization:
>MySQL support: [none | licenc
oops, good point. thanks.
On Mon, 4 Mar 2002, Roger Baklund wrote:
> * Nathan Cowles
> > $query2 = "SELECT SEC_TO_TIME(TIME_TO_SEC('$lastout') -
> > TIME_TO_SEC('$firstin'))";
> > $result2 = mysql_db_query($database, $query, $connection) or die
> > ("Error in query: $query. " . mysql_error());
Benjamin,
Benjamin Pflugmann wrote:
> Hi.
>
> I guess your "problem" comes from the fact that SQL has no concept of
> internal order. If you do not specify an ORDER BY clause, the order or
> records returned is undefined, i.e. random.
That's what I was figuring. I asked because I wanted it con
I want to select and join data from two tables if the same id exists in both
tables. If the id only exists in one table I want MySQL to return a string
like "sorry, no records found". How can I do this?
I'm guessing it's something like:
mysql> SELECT tbl1.this, tbl2.that FROM tbl1, tbl2 WHERE
Hi.
I guess your "problem" comes from the fact that SQL has no concept of
internal order. If you do not specify an ORDER BY clause, the order or
records returned is undefined, i.e. random.
Of course, MySQL has some kind of internal order depending on many
factors, but you may not rely on it. And
...and so I'm tempted for the third time to bring up my issue which has to
date resulted in no response: BLOB columns causing various, seemingly random
"out of memory" errors on FreeBSD. Is this problem too low-level for the
list? I see plenty of responses to questions about simple queries, even
It won't let you since Windows ODBC only lets you create ONE DSN per
DATABASE
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:11 PM
To: MySql
Subject: connecting to all databases using one odbc connection..PLEASE
HELP
I asked yesterday
On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote:
> I asked yesterday but got no responses...anyone have any ideas how I can
> use one odbc connection but have access to all databases on the MSSQL
> server???
I have not tried this but have you considered using the use command? Or even
per
Sam, I am constantly coding with PHP and MySQL. As far as:
>Would you agree that sorting small row sets on the client with say PHP
>is more efficient than asking a busy MySQL server with many clients to
>o ORDER BY so that FILESORT or TEMPORARY can be avoided ?
I have learned to let MySQL do any
I just installed mysql 3.23.49a on RedHat 7.2 and when I rety to start it it
shows errors like @hostname@ command not found" when I start it using
symlink and it won't start at all if I start it from
/etc/init.d/mysql.server start, error about /tmp/mysql.sock.
On the same machine 3.23.47 was worki
One more thing... What are you using to pull the data? PHP? Perl?
Etc?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent ca
Do you have another table with all the birthdates in it?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Query help please!
I need help writing query that would give me parent categories of catI
I asked yesterday but got no responses...anyone have any ideas how I can use
one odbc connection but have access to all databases on the MSSQL server???
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manua
Hi
I installed MySql on Win2k and everything worked fine, than I also installed
Oracel, mysql refused to work, than I deinstalled Oracle and did a new mysql
setup.
But when I try to start mysql, with mysql\bin>mysql
an error occurs, and mysql can´t connect to localhost.
Where is the problem?
Tha
I need help writing query that would give me parent categories of catID from
categories table.
For example, if catID=030 then it should give me:
Birthday | Special Birthday | Special Birthday
If catID=028
Birthday | General Birthday | NULL
>desc categories
+---+--+--
At 9:52 -0800 3/5/02, Sam Iam wrote:
> >> Is there some way that I can avoid doing an ORDER BY and get my
> >> rows back ordered by album_id, rank they way I inserted them ?
>
> >No. That is the nature of relational databases.
>
>Is this because the index cache in ram may not be loaded in orde
Ok,
I'm an idiot. I haddatadir = c:/_data/mysql/
when I should have had datadir = c:/_data/mysql/data/
I had some help though (I can't place all the blame on myself, ego
issues ya know).
I find this paragraph utterly confusing in MySQL Ref. Manual version
4.0.2-alpha See "Node Windows pre
>> Is there some way that I can avoid doing an ORDER BY and get my
>> rows back ordered by album_id, rank they way I inserted them ?
>No. That is the nature of relational databases.
Is this because the index cache in ram may not be loaded in order ?
> You might want to consider adding an A
Well after reviewing the DELETE section of the manual, I see nothing to suggest that
it supports
multiple-table deletes...
# Nathan
- Original Message -
From: "Daren Cotter" <[EMAIL PROTECTED]>
To: "Nathan" <[EMAIL PROTECTED]>; "Daren Cotter" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05,
Sam,
Tuesday, March 05, 2002, 6:16:17 PM, you wrote:
SL> I have a table like so :
SL> CREATE TABLE album_rank(
SL> album_id INT NOT NULL,
SL> rank INT NOT NULL,
SL> KEY(album_id)
SL> )
SL> I want to query on the album_id & get the results ordered by rank but I
SL> want
Intrex,
Tuesday, March 05, 2002, 6:09:01 PM, you wrote:
I> Funny I still have the same exact problem Egor does. I start mysql with
I> safe_mysqld, same only server just ends. I do safe_mysqld & nothing, I use
I> mysqld -r root -p
I> Nothing I do, that is listed helps. I still have no mysql.s
At 8:16 -0800 3/5/02, Sam Lam wrote:
>I have a table like so :
>
>CREATE TABLE album_rank(
> album_id INT NOT NULL,
> rank INT NOT NULL,
> KEY(album_id)
>)
>
>I want to query on the album_id & get the results ordered by rank
>but I want to avoid doing an ORDER BY in the query be
From: Daren Cotter <[EMAIL PROTECTED]>
> ...what happens when I want to delete a poll?
Do it machanically. That is, do a query in advance to find the data that needs to be
deleted, then go through and delete it. The logic for joining a delete can be written,
but MySQL doesn't support it. (Hey
Thanks to everyone who responded to my query. Your responses have given
me a bit to think about.
Dang Nguyen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Thanks much for the try, but I get an error:
mysql> DELETE
-> poll_questions, poll_answers, poll_votes
-> FROM
-> poll_questions, poll_answers, poll_votes
-> WHERE
-> (poll_questions.poll_id = poll_answers.poll_id)
-> AND (poll_answers.answer_id = poll_votes.answer
On Tuesday 05 March 2002 10:05, Thomas Spahni wrote:
There are some good reasons for wanting to store data directly in the
database, sometimes.
For instance I built an application recently that used blobs. The reason is
simplicity and security. In a web application it is nice to just dump the
Hi Darren,
On Tue, 5 Mar 2002 09:42:50 -0800
"Daren Cotter" <[EMAIL PROTECTED]> wrote:
> mysql> desc poll_questions;
> ++-+--+-++-
> ---+
> | Field | Type| Null | Key | Default| Extra
> |
> +
On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote:
> When the machine is pounding away on updates (over 300/sec), it can
> take a long time to get a response to SHOW SLAVE STATUS. ?I get one,
> but it can take between 5 and 30 seconds:
My first inclination was to blame FreeBSD threads, but
I have a table like so :
CREATE TABLE album_rank(
album_id INT NOT NULL,
rank INT NOT NULL,
KEY(album_id)
)
I want to query on the album_id & get the results ordered by rank but I
want to avoid doing an ORDER BY in the query because of the filesort
that it usually trigg
Thomas Birchmire writes:
> I tried putting --local-infile in my server script and local-infile in the
> /etc/my.cnf file. I also placed a number or logging cammands in the startup
> script hoping to catch lower level messages. There appears to be little
> effect on anything.
> Regards, Tom Birch
Funny I still have the same exact problem Egor does. I start mysql with
safe_mysqld, same only server just ends. I do safe_mysqld & nothing, I use
mysqld -r root -p
Nothing I do, that is listed helps. I still have no mysql.sock, and the
server never starts.
Mark
- Original Message
Hi,
I tried it too, got the same result. I looked into the setup.iss file
that setup -r created, and found these lines that looked different from
the others:
[SetupType-0]
Result=301
szDir=
The SdAskDestPath dialogs has:
[SdAskDestPath-0]
szDir=C:\mysql
Result=1
So I thought I'd give it a try
Howdy -
I am using the C API and am returning a result set from a table with a BLOB
type item in it.
When I populate the BLOB fields initially (with all the same data) the
length is returned properly when I issue SELECT * FROM and decode
the result set column metadata.
Meaning, that if I put ,
I just discovered that @lists.mysql.com accepts no attachments...
Please disregard the comments below regarding the code being attached, and
instead please find it at this URL:
http://www.10east.com/~hightowe/mysqld_udf_zlib.cc
--
Lester Hightower <[EMAIL PROTECTED]>
-- For
razvan,
Tuesday, March 05, 2002, 7:46:31 AM, you wrote:
r> Hi, please help me with this one!
r> I now the date_format function, it converts the standard format sql
r> (-mm-dd)
r> to any format, but my problem is that i want to convert from another format
r> (eg. dd/mm/) to the sta
Somsak,
Tuesday, March 05, 2002, 2:03:57 PM, you wrote:
SR> Dear sir,
SR> I use MySQL-3.23.35 before that running on FreeBSD-4.2.
SR> Now I use MySQL-4.0.1 running on FreeBSD-4.5.
SR> I want to convert Database ...
SR> from
SR> MySQL-3.23.35 that store at "/usr/local/mysq
dlyles,
Tuesday, March 05, 2002, 4:54:30 AM, you wrote:
d> This is the message I am getting. I am currently running MySQL (or trying
d> to) on a Cobalt Raq3.
Is your MySQL server running?
d> I recently uninstalled and reinstalled, but am unable
d> to remove this message. I can't start mysql o
1 - 100 of 144 matches
Mail list logo
