it, but as I
recently wrote an article that has an explanation of connection strings and
a sample one, I will instead just make a shameless plug: check out
www.dynamergy.com/mike/articles/blobaccessvb.html and you should find what
you need.
Mike Hillyer
Dynamergy Software
-Original Message
Hi All;
Is there any way to get a real time queries per second in MySQL as opposed
to the average given when I request the server status?
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hello,
I cannot add an index to one of my tables. I get the following message:
mysql alter table devlog add index (dt_status);
ERROR 1030: Got error 127 from table handler
I've run 'myisamchk -o table' on the table in question.
What should I try next?
Version: Server version
Isn't that what 'myisamchk -o' does?
On Tue, 17 Sep 2002, Victor Pendleton wrote:
Mike,
Erro 127 means that the table is marked as crashed. You should run a
check and repair if necessary.
Error code 127: Unknown error
127 = Record-file is crashed
I hope this helps
Description:
When doing a 'gmake install' with DESTDIR= set, 'libs' directory
is not installed properly
How-To-Repeat:
(build MySQL)
gmake DESTDIR=`pwd`/.install
Notice that a directory '.install..' gets created in the current
directory.
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: 4.0.3 datadir mangle bug
Description:
mysqld is mangling the datadir. Fed in /mysql and it produces
. ysql
How-To-Repeat:
Upgrade from 3.23.52 to 4.0.3
Fix:
Unknown at this time. Tried to feed parameters to
Paul DuBois wrote:
At 13:02 -0500 9/11/02, Mike Gohlke wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: 4.0.3 datadir mangle bug
Description:
mysqld is mangling the datadir. Fed in /mysql and it
produces . ysql
It's only changing the command line parameters
'test' in 'field list'.
Anyone know what I can do to fix it?
Thx..
Mike
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
.
Any clues, suggestions would be greatly appreciated.
TIA,
mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
) are
performed.
Mike
-Original Message-
From: Chugh Shalini [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 02, 2002 6:41 AM
To: [EMAIL PROTECTED]
Subject: sysdate or curdate as default date in mysql
Dear All!
Can we define sysdate or curdate as default date for a column of
datatype
. If
you choose that course, feel free to e-mail me and I will see if I can help
you work it out.
Mike Hillyer
Dynamergy Software
-Original Message-
From: Tom Emerson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31, 2002 7:47 PM
To: mySQL (E-mail) (E-mail)
Subject: possibly off topic: any
.
Mike
[sql,query]
-
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-mail
Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
I would like to use the getGeneratedKeys() method.
Thanks.
Mike
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
Do a locate mysql.sock it's there. Do a search on the newsgroup at
http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b
On mysql.sock
M;)
On Sat, 2002-08-24 at 21:34, Roger Young wrote:
I'm trying to install the binary mysql-3.23.52 under Linux (Slackware
8.2 distribution, kernel 2.4.18).
I
I have a table with around 150 entries in it. I am querying the table with
the fallowing command.
SELECT * FROM guestbook LIMIT 140,9
This is working fine I am getting the last 9 entries but I would like it to
return them in reverse order. Is there a way to do this? I tried this
SELECT * FROM
. I found it was for my
application.
Good Luck,
Mike Hillyer
-Original Message-
From: Bruno Batarelo [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 8:05 AM
To: [EMAIL PROTECTED]
Subject: BLOB and ADO
Greetings
There is a persistant problem while trying to insert a string from
Well, I am not sure about MS, but in Oracle you have to use the rownum
pseudocolumn and a pseudocolumn, an example:
SELECT * FROM (SELECT * FROM mytable ORDER BY somedatefield) WHERE rownum
20 AND rownum 30;
or something like that. It may be similar for MSsql, I am not sure.
Mike
P.S. my
this: can that user delete users he has
created (or at least disable them), and can users change their own
passwords? This is all being done for a VB front end, so I need to be able
to do these things using SQL statements. Any help would be appreciated.
Thanks,
Mike Hillyer
I believe this is one of those few cases where the database will silently
optimize your datatypes, it will be transparent from the client point of
view, but will make the database more efficient. Nothing to worry about.
Mike Hillyer
Dynamergy Software
-Original Message-
From: Pushkar
their own
passwords? This is all being done for a VB front end, so I need to be able
to do these things using SQL statements. Any help would be appreciated.
Thanks,
Mike Hillyer
-
Before posting, please check:
http://www.mysql.com
You need an index, it should drastically cut the query time. See:
http://www.mysql.com/doc/en/CREATE_INDEX.html#IDX1466
Mike Hillyer
Dynamergy Software
-Original Message-
From: Steinar Kolnes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 4:50 PM
To: Mysql List
Subject: Need
this file into mySQL (or maybe SQL Server
which we can then import to mySQL)
MTIA
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
but this is failing :( so was just putting a feeler out to see if anyone
else had done this... So far I can recreate the table structure but cant
extract the actual data from the file.
TIA
Mike
-Original Message-
From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 14:17
Except I don't have any access whatsoever to the Oracle server... All I
have is a flat dmp file on a CD which has all the data embedded into
this file...
I have found a tool that will extract the table structure from this
file... But will not extract the data
Mike
-Original Message
An easier (and more secure) way, surely, is to use one-way encryption... and
if a user forgets his/her password, replace it with a random alphanumeric
string and mail that to them instead with instructions to change it to one
of their own choosing as soon as possible.
Mike
- Original
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Mike Hall [EMAIL PROTECTED]
Cc: Michael Collins [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, August 11, 2002 7:05 PM
Subject: Re: [OT] assigning new passwords (was: Need reversible encryption
as string)
On Sun
What are you trying to do here?
MySQL is giving this error because the table 'test' does not exist in the
'test' database. Are you mistaking database for tables? I think perhaps you
need to take a look more carefully at the manual about creating tables.
Mike
- Original Message -
From
Jeremy Zawodny wrote:
On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote:
The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3)
(again, I acknowledge this is an old article) says flat out that MySQL tends to die
under high load. Also, when I say high
?
--Mike
- Original Message -
From: Kerry Ancheta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, August 02, 2002 9:37 PM
Subject: RE: MySql on Linux Clustering..?
You could set up a clustering configuration using our
Do you mean like 'mysqldump'? You can use mysqldump to dump tables +/-
data and then upload it to a database later--or 'import' it, e.g.,
mysqldump -u user_name database
all the tables from that database.
mysqldump takes a variety of arguments. see 'man mysqldump' for more
info.
-mj
copy with the
structure?
Mike
-
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
Desmond Lee wrote:
Hi there
Does mysql have a currency type, or is it best to just use a varchar or a
float?
Thanks
Desmond
I normally use the DECIMAL(6,2) data type, works very for currency values.
--
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain
Diana Soares wrote:
Hi, just sending a reply in case that someone else has the same problem.
I solved the problem by decreasing the key-buffer from 320M to 288M.
We tried that among many other things. It turns out that their is some
kind of problem related to temporary tables. MySQL AB is
Diana Soares wrote:
On Fri, 2002-07-26 at 18:43, Mike Wexler wrote:
Diana Soares wrote:
Hi, just sending a reply in case that someone else has the same problem.
I solved the problem by decreasing the key-buffer from 320M to 288M.
We tried that among many other things
I had this problem.
For some reason MySQL has decided to look at your tmp directory (which
contains vi.recover) instead of your data directory. Compiling
with -DHAVE_BROKEN_REALPATH fixed it for me, on FreeBSD 4.6, linuxthreads
and dual CPU.
--Mike
- Original Message -
From: Dicky
was growing by ~ 1K per 5
min.
Now it is up for about 16 hours:
virt: 281928K
RAM: 143920K
See, something wrong happens, it's back 50% in RAM. It's a memory leak,
isn't it?
Thanks, any input is much appreciated
--
==
Mike Blazer
[EMAIL PROTECTED
Oops, sorry, few mistakes here
Mike Blazer wrote:
Hello guys,
I'm runing mysql 4.0.0 under apache and mod_perl on solaris 2.28 - we
are in a kinda testing/adjusting period. So, yesterday I've wrote an
utility on top of
`ps -o vsz,rss -e` to monitor the memory usage by my processes
I have a system that has been in production for more than a year and
fairly reliable.
I have a Penguin Systems Relion 120 running Redhat Linux 2.2.14 and
MySQL 3.23.48
A few weeks ago it started crashing occasionally. About a week ago it
started crashing a lot. Some times it gets a core dump
I got one when I went on an Official MySQL training course. There again it
doesn't fit me so my wife is wears it.
Cheers,
Mike
Wouter van Vliet [EMAIL PROTECTED] 19/07/2002 09:47:00
Yeah .. I want it too :) .. please tell us !
--
Alle door mij verzonden email is careware. Dit houdt
Although this is the wrong forum for this question, you certainly can. PHP
has functions available to execute programs or command lines.
http://www.php.net/manual/en/ref.exec.php
Mike
-Original Message-
From: Harpreet Kaur [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 3:38
, MAX(isession) as isession, MAX(ssession) as ssession from
o_sessions GROUP BY iuser;
+--+--+
| iuser | isession | ssession
+--+--+
|41 |2 | wanted
|42 |4 | wanted
|43 |6 | wanted
+--+--+
Mike
mysql
Have you tried something like this,
SELECT iSession FROM O_Sessions GROUP BY iUser ORDER BY iSessions DESC;
Mike
- Original Message -
From: Robo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 3:39 PM
Subject: ??? Simple sql-question: SELECT iSession FROM
Either that, or buy a commercial MySQL License
- Original Message -
From: Oliver Six [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Monday, July 08, 2002 12:03 PM
Subject: Re:Re: Licensing--web site is schizophrenic
Hi,
does this mean that whenever I write a
Take a dump
- Original Message -
From: Todd Cary [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 08, 2002 1:38 PM
Subject: Moving a DB from one Server to another
Is there a quick and simple way to move a MySQL DB from one server to
another
MySQL server? Can I just copy
added some since then using the same software
and there's no issues.
MySQL version 3.23.49-max-nt
Thanks in advance,
Mike Tiffee
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
of /var/tmp (in my case vi.recover). When I
shutdown and restarted the system, it reverted to normal behaviour.
Anyone have any idea what is going on?
--Mike
-
Before posting, please check:
http://www.mysql.com/manual.php
computer_id - primary key
computer_name
etc.
HardDriveTable
drive_id - primary key
computer_id - foreign key
drive-capacity
etc.
If it is better to use the application code, I can do that, but I want to do
things the right way, not necessarily the easiest.
Mike
is not NULL
That works fine for oracle, but not mysql. I would perfer not to litter the
code with a bunch of
if (length($some_variable) == 0)
{ $quoted_some_variable = NULL; }
else
{ $quoted_some_variable = $dbh-quote($some_variable); }
sql, query
Mike(mickalo)Blezien
I know version 4.0.1 does.
I use Delphi 6 to write my UDF's for it.
mike
-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 9:20 PM
To: [EMAIL PROTECTED]
Subject: UDF on win2k??
hi,
i checked the manual, but i want a confirmation here
that the above returns nothing because of the multiple
pic.pic_id's in the query. But I don't know what to do get it
working(Redesign? or Is there something I could change in the query?)
Thanks in advance for any help,
Mike
sql,mysql
---
Outgoing mail is certified Virus Free.
Checked by AVG anti
Thanks for the help. Got that to work no problem.
Mike
- Original Message -
From: Harrison C. Fisk [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]
Cc: mysql list [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 5:48 PM
Subject: Re: Need Help with JOIN
Mike,
With the way you have
For the code you posted
mysql_connect(localhost, kryste, ***);
$result = mysql(mydatabase, select * from Bidder);
$num = mysql_numrows($result);
$i = 0;
Try $num = mysql_num_rows($result);
Mike
- Original Message -
From
I have a database containing stock data which I want to keep up to date.
The relevant fields are the symbol, date, high, low, and last prices.
When a new price comes in for an existing date, I want to update the high if the price
is higher, the low if the price is lower, and I always want to
I've been trying to solve this problem for a couple of days now.
I've only started with DB's a month ago so I am no expert in SQL.
So, I present this problem to you guys in hopes of getting a solution.
Thanks in advance,
Mike
=
Question:
=
Using the query below I get the result
,mysql
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
been tested and works fine is:
for (end= *option ; (end= strcend(end,'_')) *end ; ) //* detect null */
Have a great day!!!
Mike Bluett Denis Laplante
Network Engineering
The Univeristy of British Columbia
-
Before posting
);
$sth-execute ();
$count = 0;
while (my @val = $sth-fetchrow_array ())
{
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
' but not '13a'
How can I do this?
I want to end up with a result of only customer 2 in this case.
Thanks
mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
better what happens.
I'm not sure what you mean; do you mean running more basic commands? I did
a generic SELECT * from each table, and they come out just fine.
Thanks for answering! :)
-Mike
-
Before posting, please check
Please start here http://www.mysql.com/doc/index.html This is your new best
friend.
//Please don't kill me. I want to learn about databases. I hear MySQL is a
//good start. I have RedHat Linux and I've download and (I believe)
installed
//mysql.
Please read
then Optimize these tables, and mySQL speed is Awsome...
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 4:33 PM
To: Michael Grover; [EMAIL PROTECTED]
Subject: Re: Best book on MySQL
Hi Mike,
What did you think of Firebird vs. MySQL? I
happen at table creation time, but I've searched for a
long time and haven't found anything. A more general question might be how is meta
data entered or stored for tables and columns in MySql?
Can somebody point me in the right direction?
Many Thanks,
Mike
tmp_table_size set
In ini file.
mike
-
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
Paul,
Thanks for responding. The ability to document columns, tables, databases, etc. seems
pretty important to me. Why is this not an issue to others? Am I approaching this
issue the wrong way? Your thoughts would be appreciated.
Mike
-Original Message-
From: Paul DuBois
used your JDBC driver for a couple of years now, it's wonderful. Thanks to
both of you for all of your hard work.
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 2:07 PM
To: mike markovich; Paul DuBois; [EMAIL PROTECTED]
Subject: Re: Column
the cloak of some weird codenaming convention, and RedHat saying
unofficially, gcc-2.96 is fine, stuff it's compiling is broken.
Surely there has to be a better explanation, given the vast array
of knowledge and experience at work on MySQL, GCC, and RedHat.
Best Regards
Mike Robinson
Vadim P. writes:
Mike, what kind of problem? What exactly goes wrong with PHP4?
Thanks,
Vadim
Mike Robinson wrote:
I am able to reproduce this problem very easily, including on
Redhat-7.2. Basically, any app using the libmysqlclient.so
compiled with gcc-2.96 connecting to a server
.nn, it appears this might
get worse, or stay bad for quite a while, before it gets
any better.
Best Regards
Mike Robinson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Here is download for Very Simple UDF example for MySQL 4 and
Delphi 6. This is by ni means perfect...
mike
http://www.tctelco.net./~mmgrover/udf.zip
-
Before posting, please check:
http://www.mysql.com
Greetings.
I am new to MySQL and am starting to use Apache::Session::MySQL.
I created a table as the instructions mention.
CREATE TABLE sessions
(
id CHAR(32) NOT NULL PRIMARY KEY,
a_session TEXT
)
;
I have also tried a_session as BLOB.
I can set and retrieve values from the
in mysql to tell it to
go to my user directory or home directory.
Thanks
--Mike
__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
-
Before
Questions:
- Do I use root account to install the software?
Yes to compile the source or do an RPM as seen below.
See http://www.mysql.com/doc/L/i/Linux-RPM.html
- What account do I use to create Innodb?
Same - I am guessing here but I do all installs as root then give the needed
permissions to
Corrupt index, hmm? I'll check that in a moment - thanks.
Probably a sensible idea to limit the query too - I think I'll order by date
desc too just to make sure that recent mail gets sent.
Cheers
--Mike
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Mike Hall
J. Flechnter,
Here are some paths from an rpm install that I did with RedHat.
/usr/share/mysql/
/etc/my.cnf
/var/lib/mysql/
Mike
J. Flechtner wrote:
Greetings,
I am new to mysql. I have performed a fresh Red Hat install (7.2)
with all packages available. In an attempt to become more
Dra. Silvia Andreasi,
SELECT * FROM table WHERE begin_date_column =2000-01-25 and
2001-01-30= end_date_column;
begin_date_column and end_date_column have to be date type columns.
Mike
sql,mysql
Dra. Silvia Andreasi wrote:
Hi,
How can I get the columns between a given time interval
I think you better show us the script. This might help to figure out the
problem.
Okay, here it is:
-- Start
#!/usr/local/bin/php -q
?php
// Include library files
include 'config.php';
include 'feedlib.php';
// Init log
$log = new ParserLog;
// Define location of mailer lock file
$lock =
Should be able to find the right rpm's from your Linux distribution's
website. Just a guess here but www.redhat.com.
Mike
sqp,mysql
Balteo wrote:
Hello,
I am trying to install mysql from RPMs. My installation guide requires:
-Mysql server
-Mysql shared
-Mysql client
However those
have
any ideas?
--Mike
-
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
wasn't changed at all during this time - so the results of all
three queries should have been identical.
--Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
You should pass the data to be imported into Flash through urlencode().
Flash needs the data to be urlencoded in order for it to be able to read it,
particularly if the inputted data contains HTML, text with spaces, symbols,
etc.
Mike
-Original Message-
From: Phil Clandillon [mailto
, field3 FROM news ORDER BY date
DESC
Again, my apologies.
Mike
-Original Message-
From: Phil Clandillon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 11:22 AM
To: [EMAIL PROTECTED]
Subject: newbie PHP/mySQL query
Hi everyone,
I'm using a very simple PHP script with mySQL
, ideas or info.
Mike Grabski
-
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
Does MySQL 4 support udf's under Windows?
Mike..
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
Jeremy Zawodny wrote:
On Tue, Apr 23, 2002 at 08:26:23PM -0500, JW wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
Some time ago I set up a rather large mySQL server with InnoDB and
had a hard time customising my.cnf.
At the time there was some discussion of createing a tool that
command line?
If anyone can help me, give me some ideas if my install went wrong, or
if i need to update gcc, or get a different compiler (i dont know any
for linux yet! ) id appreciate it very much!
~Mike
-ERRORS--
[stigmasix@localhost practice]$ g++ mysql.cpp
In file included from
LEFT JOIN table2 ON table1.id=table2.id
- LEFT JOIN table3 ON table2.id=table3.id;
mysql SELECT * FROM table1 USE INDEX (key1,key2)
- WHERE key1=1 AND key2=2 AND key3=3;
mysql SELECT * FROM table1 IGNORE INDEX (key3)
- WHERE key1=1 AND key2=2 AND key3=3;
Mike
T.Thiessens wrote:
Well
this.
Anyone have any ideas?
Thanks,
-Mike
-
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
am trying to run a SQL query that will return an array of rows from the
images table. But I want the gallery_id number to be replaced with the
actual gallery name from the galleries table.
Mike Fifield
Charles Schwab Co, Inc.
WARNING: All e-mail sent to or from this address will be received
this.
Anyone have any ideas?
Thanks,
-Mike
-
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
.
Since I didn't mention this earlier, I should also mention that I am on a
linux box (Cobalt RAQ4).
Thanks,
-Mike
-Original Message-
From: Petre Agenbag [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:48 PM
To: Mike At Spy
Subject: Re: Weird MySQL thing
Yes, I'd also
use ORDER BY ASC or DESC
$Query = SELECT * from $TableName ORDER BY DESC;
Mike
- Original Message -
From: Jule Slootbeek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, April 17, 2002 6:38 PM
Subject: print on top
Hey guys and gals,
I'm writing
Sorry, I forget the column name for the ORDER BY
$Query = SELECT * from $TableName ORDER BY column_name DESC;
Mike
- Original Message -
From: Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Jule Slootbeek [EMAIL PROTECTED]
Sent: Wednesday, April 17, 2002 6:45 PM
Subject: Re: print on top
Those are nice guidelines and will do my best to keep in them But, no joke,
I got an E-mail from [EMAIL PROTECTED]
that the subject start's out massey,darling! Now I know I'm cute but:)
Cheers
M;)
-Original Message-
From: Robert Alexander [mailto:[EMAIL PROTECTED]]
Sent: Monday, April
',
'%D %y %a %d %m %b %j');
- '4th 97 Sat 04 10 Oct 277'
mysql select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'
Mike
SELECT DATE_FORMAT(date column,'%W %M %Y') as date FROM table;
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
Thanks but I want to be able
Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
function to supply a date for a WHERE clause in a sql statement.
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:53
also, note that char is changed to varchar in some cases, such as when there
is a text field in the table.
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 10:40 AM
To: 'Luke van Blerk'; [EMAIL PROTECTED]
Subject: RE: Char vs Varchar field
http://www.php.net/links.php
Mike
- Original Message -
From: Luigi Stefano Sona [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 12:12 PM
Subject: a little help for a beginner
Hello,
where can I find a simple php to generate a default html table from a
MySql
be greatly
appreciated.
Thanks in advance,
Mike
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
-
Before
From my limited experience. I believe your gonna have to split that one
field of alpha and numeric into two fields one for the alpha info and one
for the numeric info. Then you can sort the information the way you want.
Mike
- Original Message -
From: Luc Foisy [EMAIL PROTECTED
901 - 1000 of 1406 matches
Mail list logo