his can lead to a lot
of complexity, so many people usually cheat and have a few "does not apply"
fields for some records.
Now, what I've been doing is using NULL for "does not apply" as it seems to be
more true to the data model than using some sort of fake da
>
> I agree with most everything you said, as far as the use of a RDBMS, and
> especially: quoting you,
>
> "theoretically you break up your data into tables so that there is never a
> non-applicable field for any given row."
>
> Here is where I disagree with you, and please DON'T take this as an
more than 3.
I want a query that will provide one record per event with all times included.
feel free to answer RTFM or STFW as long as you provide the manual section or
key words. ;)
Thanks,
Ray
chart form follows:
id | event_id | start | end
---
1 |
On June 2, 2009 10:44:48 am Peter Brawley wrote:
> Ray,
>
> >I want a query that will provide one record per event with all times
> > included. feel free to answer RTFM or STFW as long as you provide the
> > manual section or key words. ;)
>
> Can be done with
On June 2, 2009 03:14:36 pm Ray wrote:
> On June 2, 2009 10:44:48 am Peter Brawley wrote:
> > Ray,
> >
> > >I want a query that will provide one record per event with all times
> > > included. feel free to answer RTFM or STFW as long as you provide the
On June 2, 2009 04:13:31 pm Nathan Sullivan wrote:
> Ray,
>
> You can use the results of a query in a join with something like:
>
> select tmp.id, t1.id
> from (some_query_selecting_id) as tmp
> join t1 on t1.id=tmp.id
>
>
> Hope that helps.
>
>
> Regard
On July 13, 2009 12:03:49 pm Carlos Williams wrote:
> If I am looking for a application that will connect to MySQL and allow
> me to make database / table / user / permission modifications via a
> graphical tool, is there something specific out there you guys
> recommend? I have been doing everythi
Hello All,
I am trying to insert a unique random number* with each row when inserting
into a table. I can do it in the application layer (php) but just wondering if
there is an easier way in the database layer.
Thanks
Ray
* for example, when registering a person for a contest, I want to give
gt;
> www.the-infoshop.com
>
> >-Original Message-
> >From: Ray [mailto:r...@stilltech.net]
> >Sent: Friday, October 16, 2009 11:43 AM
> >To: mysql@lists.mysql.com
> >Subject: insert random number into table
> >
> >Hello All,
> >I a
On October 16, 2009 12:29:42 pm Jerry Schwartz wrote:
> >-Original Message-
> >From: Ray [mailto:r...@stilltech.net]
> >Sent: Friday, October 16, 2009 1:10 PM
> >To: mysql@lists.mysql.com
> >Subject: Re: insert random number into table
> >
> >On O
Hello,
I am trying to debug another application and I need to enable logging of all
queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL
installed from ports.
any Instructions, or pointers to documentation would be appreciated.
Thanks,
Ray
--
MySQL General Mailing List
For
I seem to have problems receiving from this list.
I hadn't seen this answer come through until I was searching google again
today. :)
I just can't get my head around the mysql config system. If you can provide me
with instructions, It would be greatly appreciated.
Ray
>There
from the manual it appears that "char(0) null default null" can be
used as a boolean, will the values of either null or "". haven't
tried it myself, but its documented.
http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Column_types
[NATIONAL] CHAR(M) [BINARY | ASCII |
currently i have a table with an ip coloumn in text 123.45.67.89
though it shouldn't be a big deal to convert it to binary, but was wondering
if there is an easy way to sort by closeness to a given ip address?
ie records that come out sorted as
same class sub-c
same class c
same class c
same cla
ill use 64bit
> integer arithmetic).
>
> You just need to ORDER BY this value.
>
>
>
>
>
> Regards
>
>
> Matthew
>
>
> -Original Message-
> From: Ray [mailto:[EMAIL PROTECTED]
> Sent: 19 June 2003 15:33
> To: [EMAIL PROTECTED]
>
^ ipAddress2
>
> (order does not matter) where they are both integers (mysql will use 64bit
> integer arithmetic).
>
> You just need to ORDER BY this value.
>
>
>
>
>
> Regards
>
>
> Matthew
>
>
> -Original Message-
> From: Ray [mail
select 8 ^ 5;
ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1
i'm guessing that this means mysql 3.23 doesn't have the xor.
On Thursday 19 June 2003 11:52, Nicholas Elliott wrote:
> Remember that this is a binary XOR, not a logical XOR. Mysql does have a
> binary XOR operat
probably one of the many replys you'll get on this, but
ORDER BY month(start_date)
assuming the column that has the date is start_date
On Thursday 10 July 2003 14:51, Mike At Spy wrote:
> I am trying to create an order by in a select statement that takes a
> standard 'date' column in a table an
have a table
CREATE TABLE `pics2003` (
`ID` int(11) NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`ShortDesc` text,
`LongDesc` text,
`Image` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
and after a while someone wanted something that would always be
actually it will act like insert in eather case. if its there,
delete it first, if not just insert.
http://www.mysql.com/doc/en/REPLACE.html
as far as using shell to do the insert/update, you could look at
command line php, that way you get the logic and you don't have to
learn a new language
On Monday 08 March 2004 14:14, Neil Gunton wrote:
> [EMAIL PROTECTED] wrote:
> > If your infact (sounds like) storing the pictures meta-data
> > (name, size, owner, etc) and the data (blob of some kind) .. I
> > would definately break up the design into 2 tables. That way
> > when dealing with the
> When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of
> data and some of my data is not shown.
the garbled display is probably due to the results being wider then the
screen/terminal, and since the mysql client doesn't implement a horizontal
scrollbar like a gui/web mysql
its not LIMIT from, to, its LIMIT start, count
SELECT * FROM table ORDER BY somefield LIMIT 30,30
On Tuesday 26 November 2002 11:56, you wrote:
> I must not be awake yet. Why is this query sending me back 60 records?
> Shouldn't it only send back records 30 through 60 (i.e. 30 records)?
>
> SELE
another trick that might work is just to deny access to everyone to the
database. if no one has access to it, then its as good as gone.
i don't know if MySQL would allow just
grant blah on *.* to user;
revoke all on disabled_db.* from user;
and alot of it depends on how the security is setup a
is there a way to remotely grab the databases (ie mysqldump) and have it
place everything in a different file for every database? or has anyone
written a script to do something like this?
dbserver having databases mysql, db1, db2
and creating backup files
mysql.sql
db1.sql
db2.sql
and at differ
installed mysql onto debian using a deb file. it is running locally fine,
but it isn't openning a TCP port for remote connections to it.
>a few lines from /etc/mysql/my.cnf
[mysqld]
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
-- this is a resend, its been over an hour, and the 1st hasn't shown up on
the list yet. i'm assuming my mail server dropped it --
installed mysql onto debian using a deb file. it is running locally fine,
but it isn't openning a TCP port for remote connections to it.
>a few lines from /etc/mysq
after digging around more, i found Debian's MySQL has 'skip-networking' in
the /etc/mysql/my.cnf further down
On Monday 27 January 2003 17:08, you wrote:
> installed mysql onto debian using a deb file. it is running locally fine,
> but it isn't openning a TCP port for remote connections to it.
>
i have a select that seem to be taking too long for what it is, and after
looking over the documents i can't seem to find a better way.
probably some things that would help:
-on a datetime field, is there a way to look at everything from a month that
still uses the index.
-is there a way to caus
is there a way to use the date part of a datetime field that still uses the
index on the datetime field? i've tried a few different things and it keeps
saying in the explain it says that its a possible_key, but NULL for the key
--
mysql, sql, query, sql, sql, sql
--
is they a way to have mysqldump ignore a list of tables, but get everything
else?
something like:
mysqldump -ume -psecret -hserver --all-databases
--exclude-tables=server.acctlog
mysql 3.23.49-8.2 debian
--
mysql, sql, query, sql, sql, sql
--
> You are inserting 6 values into 7 fields, so it fails.
looks like a 6 field table to me
create table if not exists MSFT (date DATE not null, close
DECIMAL(10,2), high DECIMAL(10,2), low DECIMAL(10,2), volume MEDIUMINT,
yest DECIMAL(10,2), PRIMARY KEY date (date));
1) date
2) close
3) high
4) l
try 's arround the dates
$query = "SELECT * FROM designs, appliquetable, puffyfoamtable WHERE
designs.puffyfoam = puffyfoamtable.puffyfoam AND
designs.applique = appliquetable.applique AND
>(designs.designadddate <= '$today' AND
> designs.designa
this is more a php question then mysql, but if you put a @ before the
commands that are giving you warnings, it should cause it to not show them
@mysql_connect(...)
and you might also be looking for the php function
error_reporting( [ int level ] )
On Tuesday 04 March 2003 13:55, you wrote:
>
On Wednesday 26 March 2003 08:25, you wrote:
> > A programmer just asked me about a possible race condition,
> > and I didn't know what to answer:
> >
> > If I insert a line using autoincrement, then ask for last_insert_id()
> > am I guaranteed to get the same ID I just inserted?
>
> Yes
>
> > It s
the other thing is make sure you don't have a space after -p and before your
password
mysql -h localhost -u root -p mysql < did.query > did.out
says ask for the password and start in the database mysql
mysql -h localhost -u root -pmysql < did.query > did.out
says the password is mysql and don't s
tatement
>Submitter-Id:
>Originator: Ray Norrish, [EMAIL PROTECTED]
>Organization: Portjile Pty Ltd
>MySQL support: None
>Synopsis: Connect fails using DBI when a options file is specified (Core Dump)
>Severity: serious
>Priority: medium
>Category: mysql
>Class:
is there a show grants self or a whoami type command?
i'm trying to setup security, but i'm not show who i'm login in as?
root@% or [EMAIL PROTECTED]/255.255.255.0
i am logging in just fine, but i don't really want to delete root@% until i
know i'm getting the right login.
\s just shows me
Curr
SQL4X Manager by InterServices has worked for me, it doesn't have much for
meta edit guis though (alter tables and grant/revoke users)
On Tuesday 04 June 2002 8:05, you wrote:
> Is anyone successfully accessing MySQL from Mac OS X
> via a GUI front-end?
>
> Any advice?
>
> Thanks,
>
> Andrew
>
>
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document pos
in the DSN settings, each datasource has a different username and password.
and looking over the DSNs, none of them should be using the username
ODBC@localhost.
On Thursday 06 June 2002 9:18, you wrote:
> Ray,
> Thursday, June 06, 2002, 4:39:11 PM, you wrote:
>
> R> Error
how much access does odbc@localhost need?
i don't have any dsn that use the user, i don't have any php scripts that use
it as a log in into the database; however if i disable the user, ALL of the
pages that use a mysql odbc datasource break with the error that
odbc@localhost can't log in. (all
i'd like to setup a system that would allow for sensitive information to be
encoded (like cc numbers), however having different keys for encoding &
decoding the data.
found these in the manual, but they use the same pass_str.
ENCODE(str,pass_str)
Encrypt str using pass_str as the password. To
in the manual:
|6.2.6.2 Storage requirements for date and time types
|
|Column type Storage required
|DATE 3 bytes
|DATETIME 8 bytes
|TIMESTAMP 4 bytes
|TIME 3 bytes
|YEAR 1 byte
so, does datetime do more then date + time?
datetime = 8 bytes, date + time = 6 bytes
its really a point
default port is 3306, or look in the my.cnf
and if that doesn't work, since your using outlook, i'm guessing your on
windows, you can goto a command line and type
>netstat -a
and see what ports are being used, and try those.
On Friday 14 June 2002 3:44, Laura Findley wrote:
> Does anyone know
is there a place to download a copy of the manual that uses the same format
as on MySQL's website(http://www.mysql.com/doc/T/a/Table_size.html)? vs the
one that comes out of the manual-split.tar.gz, which is just split into 8
large html files
--
mysql, sql, query
phpMyAdmin if you have a webserver with php you can use.
or you can use MyODBC and us MS Access to make a front end for data entry.
-- Forwarded Message --
Subject: Data Entry for a Newbie
Date: 25 Jul 2002 11:12:35 -0400
From: William Bradley <[EMAIL PROTECTED]>
To: Mysql <[
is there a way to have mysql skip columns from the data file when loading the
data?
i am getting a text delimited data file from an outside source that is
updated daily. however the data is defined as having 10 blank fields in it,
and in the first 9000 records 7 more fields are just not used,
your probably looking for curtime()
CURTIME()
CURRENT_TIME
Returns the current time as a value in 'HH:MM:SS' or HHMMSS
format, depending on whether the function is used in a string
or numeric context:
mysql> select CURTIME();
-> '23:50:26'
mysql> select
I wanted to respond with what I found:
APPARMOR blocks mysql from writing to any other directory than the data
dir and /tmp.
I had to edit the /etc/apparmor.d/usr.sbin.mysqld file and add the
following:
/backups/mysql** rwk,
to the bottom.
Hope this helps someone.
Ray
--
MySQL General
Hi Voytek
You could try some variation of:
INSERT INTO inserttable (user, maildir)
SELECT REPLACE(user, '@', 'spam@') as user, CONCAT(maildir,'.spam/')
as maildir
FROM selecttable
[WHERE ..]
the where bit is optional of course!
let me know how you go - hope
Have you tried using the
> use db
> source /path/to/dumpfile.sql
command via the mysql command line client?
At 08:28 AM 5/20/2007, Vitaliy Okulov wrote:
Çäðàâñòâóéòå, mysql.
How i can speedup restore of mysql DB from file created by mysqldump?
MySQL is quite fast at reloading data, but if
e to be done with
similar speed without having to use a temp table... Is there any way to
optimize the performance of the join query without having to go with the
two-query option?
--
Thanks,
Mathew
......
Mathew J. Ray
Sr. Interactive Developer
IQ Television Group
M data
INNER JOIN names ON data.name_id=names.id
INNER JOIN values ON data.value_id=values.id
WHERE data.campaign_id = 22
AND names.name = 'content'
AND values.value = 'index'
PB
-
Mathew Ray wrote:
Newbie on the list here having a bit of confusion at the moment
Has anyone used or built a db monitoring tool for MySQL?
I have come across various system-level heartbeat tools, but I am
specifically looking for a solution that will work on Win2K Server and
RedHat boxes, as we have several servers that each run different
instances of mysql.
No replication o
though...
~mathew
Michael Dykman wrote:
On Wed, 2005-02-16 at 10:35, Mathew Ray wrote:
Has anyone used or built a db monitoring tool for MySQL?
I have come across various system-level heartbeat tools, but I am
specifically looking for a solution that will work on Win2K Server and
RedHat boxes
is zabbix (http://www.zabbix.com), its very
easy to setup and personally I think its excellent. It may be overkill if
you just want to check a db is up though
-Original Message-
From: Mathew Ray [mailto:[EMAIL PROTECTED]
Sent: Thursday, 17 February 2005 2:35 AM
To: mysql
I am guessing the long duration is caused by having to do complete table
scans. How big is your dataset?
What about creating another index in resource_goals that includes
GoalNumber and ResourceID? Perhaps even Subject, Grade, and
NumericGrade As I learned just a couple days ago, making sur
Been searching for a while and can't seem to come up with any good
answers to this - I have a normalized structure of about 5 tables that I
need to denormalize into one big representation of the entire structure.
Anyone know of a good tool or resource to 'flatten' my tables easily?
I've got a
is increasing quite drastically as I pile on more
variable comparisons... I am guessing because I am increasing that
number of comparisons that must be done...
Thanks,
Mathew
[EMAIL PROTECTED] wrote:
Mathew Ray <[EMAIL PROTECTED]> wrote on 03/24/2005 10:42:51 AM:
Been searching for a while a
My SQL Team,
When launching WinMySQLadmin 1.4 on multi-displayed systems, the admin
application launches center between both displays, not display 1, as it
should.
Thanks,
Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
gure out what else to do.
Any suggestions? (take it easy on me, I'm fairly new to Unix)
Thanks!
Marty Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:
"ERROR 2002 (HY000): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)"
I then tried installing the automatic startup routine, restarted the
computer and running mysql and I get the same message.
Any suggestions?
Thanks!
Marty Ray
--
MySQL Gene
uter:/usr/local/mysql martyray$
---
Hope I didn't screw up too bad... 8)
Thanks for your help.
Marty Ray
On Feb 12, 2004, at 4:35 PM, Brent Baisley wrote:
I assume when you tried to start MySQL from the command line you used
saf
n key constraint system tables created
040212 15:54:39 InnoDB: Started; log sequence number 0 0
040212 15:54:39 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
040212 15:54:39 mysqld ended
Hmmm...
Marty Ray
On Feb 12, 2004, at 4:56 PM, Michael Stasse
line 274: 397 Broken pipe cat
$fill_help_tables
Installation of grant tables failed!
I'm sure all this is boring and routine for all of you, but unix is
still mostly Greek to me, although I am learning!
Thanks Again,
Marty Ray
On Feb 12, 2004, at 5:37 PM, J.R. Bullington wrote:
appreciate that!
Regards and thanks to all,
Marty Ray
On Feb 12, 2004, at 4:43 PM, j.e.b. wrote:
Marty Ray
This should help you out - http://www.entropy.ch/software/macosx/mysql/
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manu
Brace yourself for another beginner question...
When I try to use the SHOW command (logged in as root) , I get an error:
mysql> show databases;
ERROR:
No query specified
Any suggestions?
Thanks!
Marty Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
ton
and picking different types such as "compiled" and "archive", but I
still get errors. Anybody have any suggestions?"
Thanks.
Marty Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've noticed that some messages from the list have a reply-to of just [EMAIL
PROTECTED] and others have both the MySQL list and the address of the sender. When I
hit reply-all on this message three addresses are in the To field. Nils, Jim, and the
list. Delete the redundant ones...
--
Ra
t I'd give the list a try to see if could get some input
on this.
We are currently running version 4.0.7 in production.
Thanks,
Ray Elenteny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hmmm. Do F1 or F3 produce the last command given?
--
Ray Thompson
> >
> >I remember in WIN NT 4 if we type cmd at the run prompt, then
> >command prompt use to come up
> >and we can repeat the commands i.e. doskey feature is available.
> >
--
MySQL General Mailin
( Apache 2 is the web
> > server the file
> > is in the htdocs folder. ) But when I try to run any
> command I get no
> > results.
> >
--
Ray Thompson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
O'Reilly's "Managing & Using MySQL" is a good intro.
--
Ray Thompson
> >
> > As a true novice starting out, can someone tell me which of the two
> > would be best suited for a true newbie
> >
--
MySQL General Mailing List
For list archi
| GGG | HHH| III |
+-+---++---+
3 rows in set (0.00 sec)
So, why is mysql_info not giving me any information about the data loss
that is going on here? Is that not information that might be of
interest?
Is there some other call I have to make that will "prepare&
p the information to itself?
- ray
On Saturday, August 2, 2003, at 5:24AM, Adam Fortuno wrote:
Actually, MySQL doesn't normally give overrun cut-off information
(best I know). Use MySQL 4.0.x on 10.2.6, and MySQL has always
performed that way.
Regards,
A$
On Friday, August 1, 2003, at 05:37 PM,
number, usable
as a UUID, would be better.
- ray
On May 12, 2004, at 3:07 PM, Jeremy Zawodny wrote:
On Wed, May 12, 2004 at 02:50:55PM -0700, Larry Lowry wrote:
Well I'm trying to move to MySQL from the MS SQL Server
world. Most data elements are easy except for the uniqueidentifier.
In the
opencms up, but i need to get mysql up in a
usable state. i do not care about security at this point.
does anyone have any clues about how to fix this? or should i reinstall and
not supply a root password?
any pointers would be appreciated.
thanks
---
ray tayek http://tayek.com/ actively seeki
At 06:04 PM 9/21/03 -0700, Ray Tayek wrote:
hi, trying out opnecms. so i installed mysql on slak 8.0. added a root
password (something like ... root password opencms) like the doc says, so
i can do a: use mysql and create databases and tables if am root on the
slak box. but only if i am root
e the mysql.h and other .h files are in this directory. i am not
familiar with red had rpm, but he or someone may not have put the right
include files in the right place or may have left some old ones hanging
around .
hth
---
ray tayek http://tayek.com/ actively seeking mentoring or telecommuting
PROTECTED]:/usr/src/mysql-connector-java-3.0.8-stable$
Script done on Fri Sep 26 20:46:01 2003
---
ray tayek http://tayek.com/ actively seeking mentoring or telecommuting work
vice chair orange county java users group http://www.ocjug.org/
hate spam? http://samspade.org/ssw/
--
MySQL General Mailing
At 07:31 PM 9/27/03 -0500, Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ray Tayek wrote:
> hi, just donwloaded mysql and connector/j. the driver seems to work fine
> for simple stuff. but i can not get all of the tests to run ...
I actually get all of the tests to r
ot;Update_time" data is NULL.
Any reason?
thanx - ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
My environment:
MySQL 4.0.18
perl 5.6
FreeBSD 5.1
Thanks for any help,
Ray Spence
__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
--
MySQL General Mailing List
Hi,
I've been trying to determine the difference between MySQL 4.0.5 and
4.0.5a. I can't seem to find any documentation relating to the change.
Can someone point me to the documentation or tell me what has changed?
T
.0.5 and 4.0.5a.
>
> Regards,
> Jocelyn
>
>
> - Original Message -
> From: "Ray Elenteny" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, November 27, 2002 2:47 PM
> Subject: Difference between 4.0.5 and 4.0.5a
>
>
&
to defend the current approach?
thanx - ray
-
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 PROTEC
can backup and
re-create the table, but that seems unnecessary, if the documentation
on myisamchk is correct....
thanx - ray
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
include the release which you are announcing? For example, since
http://www.mysql.com/downloads/ does not point to the 4.0.7 version,
which page does?
thanx - ray
On Friday, December 27, 2002, at 12:10 PM, Lenz Grimmer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.7,
appen, as -n does for make.
--lines-commented-out-by=... : pretty obvious
--terminate-on= : deleted, skipped, or warning, for example, if
you want to stop if there is even one warning.
Any other ideas? I am thinking of trying to extend it myself and am
open to suggestions.
thanx
Hey there, I'm kinda new to using mysql to its full potential and I was
wondering something. I want to store resume information, but I just want
the user to cut and paste the resume in the "Resume" field and then store
all that in one column in the table. Which table type should I use for
this? Lo
considerations would kick in for anything
> beyond TEXT (max 65535).
>
> So I'd probably go with the LONGTEXT, too.
>
> HTH,
> Tore.
>
> - Original Message -
> From: "Tom Ray" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: W
I'm looking for a webbased interface that will allow me to managae mysql
databases. However, phpmyadmin has been ruled out due to the fact it
requires the username and password to be stored in the config file and
that it doesn't have any security to protect the average joe from
stumbling across it.
m the column field.
Is there any way this can be accomplished with MySQL 4.0.12?
Thanks,
Ray
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
I have a small question about the DATE function. This is what I want to do:
- User enters information into form and submits it to database
- When info is added to database the current date is stored ala 2003-03-26
- Now I want to take that date 2003-03-26 and tack on either 15 or 30 days
on to it
t I do
need to begin learning.--Ray
-
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]>
T
elect
statement and later use a select statement to get some data, and later
drop the temporary table. I would like to do this without giving create
and especially drop access to the regular non-temporary tables in the
database.
Thanks,
Ray Rodr
here. Are there
better ways to enter that much info into the database, or are we flat doing
it wrong?
Any help is greatly appreciated.also any more info that is needed will
be supplied up request.
Ray
Here is the top of the file
use Mysql;
use DBI;
use CGI::Carp "fatalsToBrowser";
.e. should match 1, but not 2 or 3) ... what's the query
syntax?
How about if I want to find all Objects which have no children (i.e.
should match 4, 5 and 6, but not 1, 2 or 3).
TIA,
--
Ray Zimmerman / e-mail: [EMAIL PROTECTED] / 428-B Phillips Hall
Sr Research / phone: (607) 255-9
I figured it out ...
At 3:22 PM +0100 5/20/02, ds wrote:
>On Mon, 2002-05-20 at 13:34, Ray Zimmerman wrote:
>...
> > For example, given the following data ...
>>
>> CREATE TABLE Object (
>> id int(11) NOT NULL auto_increment,
>> PRIMARY KEY
1 - 100 of 146 matches
Mail list logo
