On Wed, Jan 17, 2001 at 02:15:26PM +0800, Victor Alamo wrote:
> Hi guys,
>
> I am looking some tutorial step by step using replication. I had a
> look the documentation about replication but I am not so clear where
> to find some of files and some other points.
I've suffered thru the replication
Hi guys,
I am looking some tutorial step by step using replication. I had a look the
documentation about replication but I am not so clear where to find some of files and
some other points.
Do you know any url or real sample for replication for MySQL?
Thank you
Canario
Sinisa,
On Mon, 15 Jan 2001, Sinisa Milivojevic wrote:
> Hi!
>
>
> I will answer questions one by one.
>
>
> 1) thread safe client library only has mutexes around thread sensitive
> code. They have nothing to do with timeouts. Timeouts can be resolved
> with corresponding startup variables
On Tue, Jan 16, 2001 at 08:30:01AM -0500, Jeff Lewis wrote:
> I have always used flat file text files for my database purposes but
> this has always led to problems when the number of users gets to be
> too many.
Tell me about it. I converted a system like that to MySQL a while
back. It's s
On Tue, Jan 16, 2001 at 01:43:26AM -0800, Derek Sivers wrote:
> Has anyone done testing to show the difference between:
>
> #1 - having MySQL on the same server as Apache/PHP
>
> vs.
>
> #2 - having MySQL on its own dedicated computer, TCP/IP connected to the
> main Apache box
>
> NOTE: We u
"Jeremy D. Zawodny" wrote:
>
> On Tue, Jan 16, 2001 at 01:52:17PM -0500, Patrick Lannigan wrote:
>
> > Java Developers Journal is holding a vote for a number of Java
> > technologies. One of them is "Best Enterprise Database" and you can
> > vote for MySQL.
> >
> > The process takes some time, a
On Tue, Jan 16, 2001 at 03:41:14PM +0800, Ganen Ganeswaran wrote:
> I'm a relative newbie in mySQL. I have 10 mySQL databases. At the
> moment I'm only using 1 of the databases. I was wondering if it's
> possible (and how) to setup some sort of replication/load balancing
> between all 10 dbs. Bas
hi,
can someone with a stable redhat 7.0 mysql (3.23.29) installation run a
'tree -palug' on /var/lib/mysql so i can see the perms and user.group.
i had to make several chowns and chmods in order to start mysql and just
want to check against a known stable configuration.
thanks
--
ashten remwa
Hi,
The problem you ran into is because you didn't start mysqld the right way!
There are 3 options on how to start mysqld!
a) cd mysql-distribution-directory
./bin/safe_mysqld &
b) Make a symlink from the mysql distribution to /usr/local/mysql so that
you can start safe_mysqld from anywher
Yes you can!
You must download MyODBC, set it up and configure a DSN for your mysql
database.
Then you must Link the tables by doing the following:
File -> Get External Data -> Link Tables -> ODBC Databases (combo box), and
then select your DSN.
Regards
Jorge
MySQL Development Team
__ __
Cindy writes:
>
> OK. I went to the documentation at www.mysql.com and typed in
> DATE_FORMAT in the search box, hopefully find a list of the %M's, etc
> rules that may be used (I'd like December to become Dec, etc). No
> dice. Randomly looking through sections that came up under "DATE"
> sear
Even if you could, there is no need to set up 2 different charsets. Just use
English. When entering Japanese, just ensure you have an OS/program/web
browser that can display Japanese correctly. Sorting should be fine. Also,
have a for JIS in the manual, if you haven't already done so.
- Ori
On Tue, Jan 16, 2001 at 08:00:09PM -0600, Scott Gerhardt wrote:
> Thanks for your responses Jeremy, I'm just trying to clarify any
> misunderstandings I may have.
>
> So, as far as the example goes, the relationships between shirts and
> people is maintained by using the LAST_INSERT_ID (in one c
question:
Can i link to a mysql database using ms access 97 or ms access 2000 using an
odbc driver.
i recall doing it before, but can't seem to get it work again. i would
appreciate any help
you could give me on this subject. thanks
charlie scott
-
MySQL was working fine but now it seems to be giving me an error:
user:/usr/local/apache/bin# mysql -uusername -pmypassword
Can't read dir of '.' (Errcode: 2)
or
user:/usr/local/apache/bin# mysqladmin -uusername -pmypassword create catalog
Sorry, my mistake. Yes, you're right, the to: & cc:
- Original Message -
From: "Jason Brooke" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; "John en Daphne Kuiper"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 9:50
Subject: Re: putting an mark i
Thanks Paul,
And it doesn't really matter if the ID's are cronological that's what
timestamps are for.
___
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
___
>
> On Tue, Jan 16, 2001 at 07:22:48PM -
Thanks for clearing that up Benjamin!
It all makes sense now :-D
- Scott
>
> On Tue, Jan 16, 2001 at 07:22:48PM -0600, [EMAIL PROTECTED] wrote:
> > So referential integrity is maintained but AUTO_INCREMENT
> values may not be
> > chronological?
> >
> > Connection A's LAST_INSERT_ID()
Hi.
On Tue, Jan 16, 2001 at 07:22:48PM -0600, [EMAIL PROTECTED] wrote:
> So referential integrity is maintained but AUTO_INCREMENT values may not be
> chronological?
>
> Connection A's LAST_INSERT_ID() may be 3 at 15:20
> AND
> Connection B's LAST_INSERT_ID() may be 4 at 15:18
Hm, yes, but only
On Tue, Jan 16, 2001 at 07:22:48PM -0600, Scott Gerhardt wrote:
> So referential integrity is maintained but AUTO_INCREMENT values may not be
> chronological?
>
> Connection A's LAST_INSERT_ID() may be 3 at 15:20
> AND
> Connection B's LAST_INSERT_ID() may be 4 at 15:18
The AUTO_INCREMENT values
Thanks for your responses Jeremy,
I'm just trying to clarify any misunderstandings I may have.
So, as far as the example goes, the relationships between shirts and people
is maintained by using the LAST_INSERT_ID (in one connection) but
referential integrity is not maintained in terms of foriegn
The from field is the original sender, not the list. Try to: and cc:
jason
> What's wrong with creating a filter? Most e-mail programs of today allow
> for filters!!
>
> Just create a filter based on the from field where it equals
> [EMAIL PROTECTED]
On Tue, Jan 16, 2001 at 07:22:48PM -0600, Scott Gerhardt wrote:
> So referential integrity is maintained but AUTO_INCREMENT values may
> not be chronological?
Nope. Referential integrity is not maintained.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (
I'm confused on what your talking about. Are you having difficulties with
msql or mysql. If msql, you're asking the wrong list but if it is mysql,
I'm not sure what your problem is.
- Original Message -
From: "Ulrich Schneider" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
Jon, no offence meant but, I think there is a misunderstanding somewhere.
This guy is an admin and probably isn't on this list so he probably doesn't
get these e-mails.
Dave, if you didn't get the info at the bottom of e-mails, try removing him
manually at: http://lists.mysql.com/php/unsubscribe.
Rolf Hopkins wrote:
>
> Check out skip-grants in the manual
>
> - Original Message -
> From: "Bigheart Luis" <[EMAIL PROTECTED]>
> To: "G r e g L a w r i e" <[EMAIL PROTECTED]>
> Cc: "Robert" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, January 17, 2001 6:44
> Subject: Que
What's wrong with creating a filter? Most e-mail programs of today allow
for filters!!
Just create a filter based on the from field where it equals
[EMAIL PROTECTED]
- Original Message -
From: "John en Daphne Kuiper" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January
Hi.
Sorry, but I cannot see how this relates to MySQL. Please ask in the
appropriate forum. Here, it is off-topic. Try http://www.php4.org
Bye,
Benjamin.
On Tue, Jan 16, 2001 at 11:53:00AM -0300, [EMAIL PROTECTED] wrote:
> Using PHP+Apache+Linux, how can I find out from the browser whe
Check out skip-grants in the manual
- Original Message -
From: "Bigheart Luis" <[EMAIL PROTECTED]>
To: "G r e g L a w r i e" <[EMAIL PROTECTED]>
Cc: "Robert" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 6:44
Subject: Question on password
> I have a simpel q
So referential integrity is maintained but AUTO_INCREMENT values may not be
chronological?
Connection A's LAST_INSERT_ID() may be 3 at 15:20
AND
Connection B's LAST_INSERT_ID() may be 4 at 15:18
- Scott
> In the last episode (Jan 16), Scott Gerhardt said:
> > I was reading the informat
On Sun, Jan 14, 2001 at 09:36:00AM +, Martin Thoma wrote:
> Hi there,
>
> sorry, I'm a newbee and I didn't found what to do in the manual.
>
> I heard in the maillinglist something about big tables. I want to
> make a database with about 2-3 GB. What do I have to do / set / pay
> attention
On Tue, Jan 16, 2001 at 07:07:25PM -0600, Scott Gerhardt wrote:
> I was reading the information on foreign keys in the manual
> http://www.mysql.com/doc/e/x/example-Foreign_keys.html and noticed
> that there is no mention of locking the tables.
>
> It seems to me that using the example verbatim
In the last episode (Jan 16), Scott Gerhardt said:
> I was reading the information on foreign keys in the manual
> http://www.mysql.com/doc/e/x/example-Foreign_keys.html
> and noticed that there is no mention of locking the tables.
>
> It seems to me that using the example verbatim could lead to
On Tue, Jan 16, 2001 at 01:52:17PM -0500, Patrick Lannigan wrote:
> Java Developers Journal is holding a vote for a number of Java
> technologies. One of them is "Best Enterprise Database" and you can
> vote for MySQL.
>
> The process takes some time, as you have to vote for each category
> one
In the last episode (Jan 17), John Stumbles said:
> SELECT * from MAC_connections
> or even
> SELECT count(*) from MAC_connections
>
> hangs! (it's been sitting there for the last 10 minutes and hasn't
> produced anything!)
The server always caches the value of count(*), so the only reason
Hello you all!!!
I've got a tricky issue that I want to discuss with you. Currently I'm
developing a Quiz Game and I'm using MySQL to host data. In a Quiz Game that
is going to have prizes the ranking of a user is very important and I want
to find a good way of creating one.
To make it simple let
I was reading the information on foreign keys in the manual
http://www.mysql.com/doc/e/x/example-Foreign_keys.html
and noticed that there is no mention of locking the tables.
It seems to me that using the example verbatim could lead to loss of
referencial integrity if INSERTS did not occur in seq
Hi,
I just realized that mysql does not have nested queries, and
I need to do something like this:
update table1 set A="blah" where B=(select B from table1, table2 where
table1.B=table2.B)
Is it possible?
Thanks,
Jeff Pavel [EMAIL PROTECTED]
---
Thanks That worked
-
Before posting, please check:
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-m
On Tue, Jan 16, 2001 at 04:43:23PM -0600, Gary Roediger wrote:
> What future version of MySQL will have nested SELECTs in the WHERE
> clause?
You looked in the manual, right?
http://www.mysql.com/doc/T/O/TODO_future.html
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Y
Put your limit at the end
On 17 Jan 2001 11:26:04 +1100, MacBane wrote:
> The variables are set using php and are all set correctly.
> how do I do the where and order by statement
>
> SELECT * FROM $table_name LIMIT $indst,$inded where sec_id = $sec order by PG_date
>DESC
>
>
The variables are set using php and are all set correctly.
how do I do the where and order by statement
SELECT * FROM $table_name LIMIT $indst,$inded where sec_id = $sec order by PG_date
DESC
I'm using mysql-3.23.29-gamma on Solaris 2.6 sparc. I have a
multithreaded mysql client that is linked to libmysqlclient_r.
On startup, it dumps core after mysql_init() is called. More
specifically, the fault is during the getservbyname() call in
mysql_once_init(), which is part of libmysql.c.
There were some very recent fixed to FreeBSD-stable
surrounding C++ and threads, that directly mysql,
I'd strongly recommend updating freebsd.
On Mon, 15 Jan 2001, Nicolai Gylling wrote:
> Hi
>
> I'm currently running a FreeBSD4.2-Stable server with
> Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.2
what does a 'show processlist' reveal?
On 17 Jan 2001 00:08:23 +, John Stumbles wrote:
> On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote:
>
> > On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote:
> >
> > > I can't readily reproduce the first-time big difference
> > > scenario.
>
>
On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote:
> On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote:
>
> > I can't readily reproduce the first-time big difference
> > scenario.
OK, I can now: I have a table -
MAC_connections:Data records:6689
+--+--
Hello All,
I have been using mysql-3.23.29a-gamma-dec-osf4.0f-alphaev6
running on a machine running Digital UNIX V4.0F. Since upgrading the
database from 3.22 to 3.23, auto-increment fields have been acting
strangely.
A brief description of the table looks like:
++-
Try the manual contents, linked from the documentation page
http://www.mysql.com/documentation/mysql/bychapter
> OK. I went to the documentation at www.mysql.com and typed in
> DATE_FORMAT in the search box, hopefully find a list of the %M's, etc
> rules that may be used (I'd like December to
Yep, you're right. Fixed.
Thanks,
Zeev
At 23:24 16/1/2001, Steven Roussey wrote:
> > OK. Look at a quick report. I've just installed php4-200101152345. It runs
> > with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4
> > (remote connection).
> >
> > What I can see is: the o
Hi!
I would like to be able to use BOTH Japanese characters and English in
mySQL. I am wondering if this is possible. I know that one can use the
Japanese charset, and of course one can set the English charset, but I
require BOTH Japanese and English. . . Is there any way to do this?
Thanks
OK. I went to the documentation at www.mysql.com and typed in
DATE_FORMAT in the search box, hopefully find a list of the %M's, etc
rules that may be used (I'd like December to become Dec, etc). No
dice. Randomly looking through sections that came up under "DATE"
search didn't yield any other
The tables are being created dynamically, I don't know the column names or
field types. I am currently using a subroutine to return the field types by
issuing a DESCRIBE on the tablebut I was wondering if there was a SQL
trick to select stuff using field type criteria in the where clause.
-
Hi Joseph,
>Hardware platform :
> Dell PowerEdge 2450 bipro PIII/733,
> 2Gb RAM,
> integrated hardware RAID crontroller (PERC3)
> with 2x18Gb disks configured
> in RAID1 (mirroring) mode.
>
>Operating system:
> Linux RedHat 6.2 (kernel 2.2.14 SMP)
>[...]
> I tried to use --safe-mode but I had to
You can get around subqueries by using JOIN's. mySQL may not have all the
bells and whistles that some
other db applications may have, but more often than not, there is a way to
get around it.
Paul DuBois covers this in his mySQL book very well.
-Original Message-
From: Mark Marshall [
I'm using mysql 3.23 on red hat 6.1
I want to select * from tablea and tableb where columna in tablea is the same as
columnb in tableb, but columna1 in tablea DOESN'T appear in columnb in tableb.
I tried select a.* from tablea as a,tableb as b where a.cid <> b.uid limit 30;
it gave me the
Just read the section in the documentation about user rights. You have to
give that user, at that IP address access to the box.
At 02:09 PM 1/16/2001 -0800, Bigheart Luis wrote:
>"Karl J. Stubsjoen" wrote:
> >
> > Hello,
> >
> > We have loaded MySQL on an Apache Linux machine, I have recently t
I have a simpel questions, I forgot the password
to mysql server. How do i change it ?
THank you
Luis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
You have to select a certain row, there is no way to say all rows that are
NOT an int.
At 04:33 PM 1/16/2001 -0500, Brian Kaney wrote:
>Is there a way to SELECT FROM table WHERE field_type IS (NOT) 'something'.
>
>For example, 'something' could be TIMESTAMP, INT, FLOAT, AUTO_INCREMENT,
>etc...I
What future version of MySQL will have nested SELECTs in
the WHERE clause?
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote:
> Hello. I am trying to get the results from a query to be ORDERED by
> ASCENDING instead of the default DESCENDING. Is this possible, and
> if so how?
I mis-wrote in my reply (which hasn't come thru the list yet). You can
use "ASC" but now
Cindy writes:
>SELECT *.DATE_FORMAT(datefield, "%M %d, %Y") FROM table;
Agh. *,DATE of course. Comma, not dot.
--Cindy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote:
> Hello. I am trying to get the results from a query to be ORDERED by
> ASCENDING instead of the default DESCENDING. Is this possible, and
> if so how?
As the manual explains:
SELECT . ORDER BY foo ASC
or
SELECT . ORDER B
"Karl J. Stubsjoen" wrote:
>
> Hello,
>
> We have loaded MySQL on an Apache Linux machine, I have recently tried to
> connect and am getting the following error:
>
> C:\mysql\bin>mysql -hdaffy -uroot -p
> Enter password:
> ERROR 1130: Host 'workstation01.fenzer' is not allowed to conne
On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote:
> Along the lines of:
>
> > I think its because the Operating System is caching the data the
> > query are run on
>
> What I didn't emphasise in my original email was that the
> differences I was getting were of the order of S
Hi!
> "David" == David Mechner <[EMAIL PROTECTED]> writes:
David> Hi,
David> My license number is 7697. I don't know what the expiration date is. I'm
running 3.23.28-gamma msqld-opt under w2k.
David> I'm trying to use a HEAP table to speed up data access, but every select I do
which refe
What's your subquery and we can help you convert it to a join.
On 16 Jan 2001 15:59:48 -0500, Mark Marshall wrote:
> Hi all,
>
> Is there any kind of schedule that says when the next MySQL version will be
>available? I'd like to utilize MySQL here, but I can't really start to seriously
>work
> From: "Yury V. Bukhman" <[EMAIL PROTECTED]>
> Organization: Danforth Plant Science Center
> Date: Tue, 16 Jan 2001 16:49:09 -0800
> To: Anthony Cooke <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Char comparisons vs. Integer.
>
>
> Do you mean, putting primary entry identifiers o
Is there a way to SELECT FROM table WHERE field_type IS (NOT) 'something'.
For example, 'something' could be TIMESTAMP, INT, FLOAT, AUTO_INCREMENT,
etc...I looked through the manual and archives to no avail.
Regards,
Brian Kaney
-
Hmmm, you seem to have things a little backwards as ASCENDING should be the
default order.
However, as per the manual, the following will do it
SELECT * FROM tbl_name ORDER BY col_name ASC
To sort in the opposite order
SELECT * FROM tbl_name ORDER BY col_name DESC
Regards,
Greg
>
select col1,col2 from table1 order by col1 ASC;
Please see the manual:
http://www.mysql.com/doc/S/E/SELECT.html
On Tue, 16 Jan 2001, Robert wrote:
> Hello. I am trying to get the results from a query to be ORDERED by
> ASCENDING instead of the default DESCENDING. Is this possible, and if so
>
> OK. Look at a quick report. I've just installed php4-200101152345. It runs
> with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4
> (remote connection).
>
> What I can see is: the offending messages didn't vanish at all (both hosts
> are involved):
> So, I think it's not fixe
"j.urban" writes:
>select field1,field2,DATE_FORMAT(datefield,"%M %d, %Y"),field4,fieldn from
>table;
He didn't want to have to explicitly list all 40 other fields, though.
Can't he do something like
SELECT *.DATE_FORMAT(datefield, "%M %d, %Y") FROM table;
? That gives him one extra field,
Hello,
We have loaded MySQL on an Apache Linux machine, I have recently tried to
connect and am getting the following error:
C:\mysql\bin>mysql -hdaffy -uroot -p
Enter password:
ERROR 1130: Host 'workstation01.fenzer' is not allowed to connect to this
MySQL
server
Any ideas what we ne
select *,DATE_FORMAT(datecolumn,'%M %D %Y');
On Tue, 16 Jan 2001, Mike Podlesny wrote:
>
> > Thanks for your help but that unfortunately doesn't answer the question,
> > unless I am looking at it wrong. I want the sql statement to read
> something
> > to the affect:
> >
> > SELECT * FROM Table
OK. Look at a quick report. I've just installed php4-200101152345. It runs
with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4
(remote connection).
What I can see is: the offending messages didn't vanish at all (both hosts
are involved):
010116 20:52:30 Aborted connection 3
GATOR-root wrote:
>
> >Description:
> We had an NFS incident and used CHMOD and CHOWN to repair it.
> Shortly there after, we noticed that our MySql under WebRT did not work.
> We presume that we corrupted the ownership and permissions of files and
> programs within MySQL.
>
> >How-To-Re
I find myself having to deal with lookup tables to preserve
space and speed up queries. Something like:
create table test (
somedate DATE,
long_column_id INT UNSIGNED,
);
create table longcol_lookup (
long_column_id_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
long_column CHAR(128)
)
Hi all,
Is there any kind of schedule that says when the next MySQL version will be available?
I'd like to utilize MySQL here, but I can't really start to seriously work on it
until sub-queries are possible.
Thanks!
Mark
-
I created the binaries. A versions need the LD_LIBRARY_PATH. This is
what I use.
PATH=$PATH:$HOME/bin:.:/bin:/usr/bin:/usr/bin/X11:/usr/local/bin:/usr/ccs/bin:/usr/local/ubin:/usr/zenez/bin:/etc:
export PATH
LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/local/mysql/lib/mysql:/
On Tue, 16 Jan 2001, Pavel Kveton wrote:
> On Sunday 14 January 2001 16:25 Martin Borg wrote:
> > I am trying to install Mysql 3.23.7 on a Red Hat 6.0 Server system. When
> > I try to install the binary rpm-distribution i get an error saying that
> > bin/usr/perl5 is needed. The perl version ins
Mike Podlesny wrote:
>
> I want to select all the fields in from the mySQL database except I want my
> date field to be returned in the format of:
>
> January 16, 2001
>
> How can this be done without having to do the select in this manner:
>
> SELECT field1,field2,MONTHNAME(datefield),DA
Why not use ENUM?
create table test
bool ENUM('t', 'f') default 't' not null,
val1 char(15),
val2 int
...
...
It will "map" T to a 0 and F to 1. It's nearly identical to what
you're doing, but it may seem more intuitive to some.
Cheers,
Chris Oson
-Original Messa
Hello. I am trying to get the results from a query to be ORDERED by
ASCENDING instead of the default DESCENDING. Is this possible, and if so
how?
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the
select field1,field2,DATE_FORMAT(datefield,"%M %d, %Y"),field4,fieldn from
table;
See the MySQL Manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
On Tue, 16 Jan 2001, Mike Podlesny wrote:
> I want to select all the fields in from the mySQL database except I want my
> date field
Matt Wagner writes:
> Hi all,
>
> Just testing ezmlm's attachment filter to make sure our changes catch
> this 'Emanual.exe' from "funky gao".
>
> Attachment should be here:
Okay, looks like we are all GO Houston.
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt W
Anthony Cooke wrote:
> If table a is person_entry and table b is person_account and you will be
> searching according to an exact comparison then why use a CHAR field for the
> ID instead of a numerical equivalent?
>
> Why not normalize so that each record in "entries" would have one Unique
> aut
- Original Message -
From: "Mike Podlesny" <[EMAIL PROTECTED]>
To: "Scott Gerhardt" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 3:20 PM
Subject: Re: SQL HELP
> Thanks for your help but that unfortunately doesn't answer the question,
> unless I am looking at it wrong. I want the
Check in the manual about the DATE_FORMAT function
HTH
Quentin
-Original Message-
From: Mike Podlesny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 17 January 2001 07:55
To: mySQL Mailing List
Subject: SQL HELP
I want to select all the fields in from the mySQL database except I want my
d
Various folks responded to my question:
> [EMAIL PROTECTED] wrote:
>
> > I've noticed that when developing queries involving complex joins on
> > tables I sometimes seem to get appallingly long times the first time I run
> > a query, but the second and subsequent time I run it - even subs
On Tue, Jan 16, 2001 at 01:55:01PM -0500, Mike Podlesny wrote:
> I want to select all the fields in from the mySQL database except I want my
> date field to be returned in the format of:
>
> January 16, 2001
>
> How can this be done without having to do the select in this manner:
>
> SELECT fie
On Tue, Jan 16, 2001 at 05:05:13PM +, John Stumbles wrote:
> [Apologies if this message hits the list twice: I sent it several
> hours ago but didn't see it on the list or get a bounce message (or get
> any response!) so I don't know what's happened to it.]
>
> I've noticed that
Hello to all,
I'm just a member to this list and was shocked how many email already has arrived.
Now I'm happy about it but all the mail will be put in the inbox. I can't make a
filter on it, so that al my mysqlmail will be placed directly into my mysqlfolder.
Is there something to do about it?
>Description:
We had an NFS incident and used CHMOD and CHOWN to repair it.
Shortly there after, we noticed that our MySql under WebRT did not work.
We presume that we corrupted the ownership and permissions of files and
programs within MySQL.
>How-To-Repeat:
use command CHOWN and
Asaf Maruf wrote:
>
> Dear all on list
>
> How can i specify two columns together as primary key for a table.
>
> Using create table test
> (increment int , id int not null primary key, date not null primary key, name
>char(20) );
>
> doesn't work.
>
> Is it possible that one column is tex
I want to select all the fields in from the mySQL database except I want my
date field to be returned in the format of:
January 16, 2001
How can this be done without having to do the select in this manner:
SELECT field1,field2,MONTHNAME(datefield),DAYOFMONTH(datefield),
YEAR(datefield)
PHP handles persistent connections by leaving them open
for some other identical connection request. The next request
will check for a free connection.
see
http://www.php.net/manual/en/features.persistent-connections.php
In other words, you don't need to worry about when they are closed
php wil
Robert Marchand writes:
> Hi,
>
> I have download the latest binary distribution for SGI Irix:
> mysql-3.23.30-gamma-sgi-irix6.5-mips and it lock when I try the test
> suite:
Hi!
Could you send this message along with the a report filled out with
`mysqlbug' to [EMAIL PROTECTED]?
Regards
Hi all,
Just testing ezmlm's attachment filter to make sure our changes catch
this 'Emanual.exe' from "funky gao".
Attachment should be here:
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http:
It has been dead, but JUST today it was announced that it will come back:
http://www.hughes.com.au/news/pr-2001-01-15.html
At 09:45 AM 1/16/2001 -0800, William R. Mussatto wrote:
>*** I believe that development work on this is stopped.
> there also is a slight fee for using it if you can fin
I wish MySQL had a boolean datatype for this exact reason. Unfortunately
it doesn't, so for all the times I've needed on I've just used a "Tinyint"
and set 0 to false, and -1 (or 1) to true.
At 05:41 PM 1/16/2001 +, SED wrote:
>Hi, I'm new to MySQL and I want to create a column which only
1 - 100 of 222 matches
Mail list logo
