Date: Sun, 10 Feb 2002 16:06:55 -0800
To: [EMAIL PROTECTED]
From: tj marlin [EMAIL PROTECTED]
Subject: Re: Quick SQL design help
the SET data type comes to mind. there is a limitation of 64 for the set
size.
ciao
At 05:23 AM 2/10/02 +, you wrote:
Hello MySQL users
I was wondering if one
Date: Sun, 10 Feb 2002 16:06:55 -0800
To: [EMAIL PROTECTED]
From: tj marlin [EMAIL PROTECTED]
Subject: Re: Quick SQL design help
the SET data type comes to mind. there is a limitation of 64 for the set
size.
ciao
At 05:23 AM 2/10/02 +, you wrote:
Hello MySQL users
I was wondering if one
if you don't want the user to input trash, don't give him the opportunity.
on your form, put three two character input fields. label the fields month,
day and year, or what ever is the most common order that your user will
input a date. put '-' or whatever, between the fields - just to make
.1 can not be represented exactly on a binary machine. there must be an
approximation stored in the fractional bits of the floating point
representation. there are more fractional bits in a double than in a float.
so the approximation is better. see the user manual for exact sizes.
At 12:51
with the sircam virus going around, i'm not into opening attachments.
my guess is that you are running into the cr/lf problem.
windows terminates lines with a cr/lf. unix uses only a lf. so when you
read the windows file, the cr terminates a record and then the lf
terminates the interspersed
There are secure telnet packages. one for windows is SecureCRT. see
www.vandyke.com
for tips and pointers: basic telnet gives you a link to your server thru
your own pc. it is as if you were directly connected to your server.
At 01:24 PM 7/28/01 -0600, you wrote:
On Saturday 28 July 2001
yes, but then you wouldn't learn. if you don't want to buy Dubois' book,
try appendix J of the mySql reference manual, available for free from the
mysql site.
At 06:06 PM 7/26/01 +0100, you wrote:
In message [EMAIL PROTECTED], tj marlin
[EMAIL PROTECTED] writes
I think it is time for you
This virus is becoming wide spread. It appears to use a machine's address
book and mail itself to the members of the address book. i've received mail
with the virus from a number of people, in addition to receiving it from
this list.
At 05:04 PM 7/27/01 -0400, you wrote:
On Fri, 27 Jul 2001,
Mark:
the key to this puzzle is the separator, the ';'
for your first question, you need to find the ';' followed by a 6. not just
any ';', but the first ';'
the pattern would be ^[0-9]*;6
which says
^ find beginning of line
[0-9]* followed by zero or more instances
the method signature for getConnection is:
public static synchronized Connection getConnection(String url,
String user, String password) throws SQLException
try PURE JSP Java Server Pages by James Goodwill from Sams. a nice book.
has some coding errors.
At 04:02 PM 7/18/01 -0600, you
but before you issue this command and possibly trash your database, use
select * from a_table where status='flag_value';
to look at the records which will be deleted. you may find some surprises.
At 08:19 AM 7/16/01 -0400, you wrote:
Why not:
delete from a_table where
MySQL, Paul DuBois, New Riders publishing, 2000, $40
At 10:25 PM 7/7/01 -0800, you wrote:
The Mysql/Msql book I have from O'Reilly is definitely showing its age. I
know there are books in the MySQL FAQ, butI am looking for recommendations.
Any books that stand out as better than others?
I'm
i know it is large. the user must do his own calculations to determine if
he can substitute eliminate for postpone.
this is his call; not mine nor yours.
At 09:57 AM 7/8/01 +0307, you wrote:
tj marlin wrote:
you can postpone this problem for a very long time by using an unsigned
bigint (0
they can't access them! are you sure about that?
indeed, if a user is logged on to the web host, he is acting in the
environment imposed by the operating system on the user session. in this
case, the other databases - given that the correct permissions are
established - can not be accessed.
actually you are already using mysql.
what you need to do is specify a database to use.
to see the available databases, type
show databases;
then type
use db name
note, no ;
if none of the existing databases are appropriate you must create a
database. but this is another
my only comment on this is that although you appear to have two different
problems - you don't!
pick a single solution to both cases; then when your solution needs
modification, you only have one set of code to change.
this obviously is computer science; only tenuously related to mysql.
At
there is a way:
delete the column
add the column
then the auto increment will start from 1 up to the number of records.
be careful! if there are records in other tables which refer the records
in this table - the one being modified - those records WILL NOT BE UPDATED.
and now your database
indexing the entire large text column really drags performance down, and
consumes big hunks of disk space. mysql has a good regexp facility. rtfm
At 10:52 PM 7/6/01 -0700, you wrote:
Hi Everyone,
I'm writing a script using perl for a search function. I have a large
text column that I want to
Mysql by Paul Dubois, New Riders publisher, is strongly recommended.
Get the perldoc on dbi and dbd. terse, but up to date.
other reading are:
cgi programming 101 by jacqueline hamilton. basic information. well
presented. with examples that work. very broad, very shallow.
of course the camel
19 matches
Mail list logo