Don't use varchar unless you absolutely have to, that should help.
Jerry
- Original Message -
From: "Ulterior" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 3:13 PM
Subject: Insert query
> Hi,
>
> I have a database tabl
What I was going to say ::
I was always told to stay clear of the varchar for performance, and that was
on the mysql training course and the dev's.
So I'd take that its relevant....
Jerry
- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
To
varchar doesn't cause a problem, its a case of not using it speeds things
up.
As with all things, horses for courses, if you don't need to use it, don't.
Jerry
- Original Message -
From: "Andrew Braithwaite" <[EMAIL PROTECTED]>
To: "'Ulterior
I'd advise char due to the over head and space usage of varchar. if its
something like your example i.e.16 chars, make it 30 to be sure.
Jerry
ps. + pps. = http://www.mysql.com/doc/en/Column_types.html
- Original Message -
From: "Dan" <[EMAIL PROTECTED]>
To: <
i.e.16 chars, make it 30 to be sure
"it" = CHAR
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: "Dan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 3:10 PM
Subject: Re: Using varchar or something el
And the manual says : .
http://www.mysql.com/doc/en/Table_size.html
Jerry
- Original Message -
From: "Mark Vollmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 9:39 AM
Subject: Maximum table size
> Hello
>
> As i under
am looking for. :( As the
tables are already defined in the text file and the
appropiate database name to enter them into.
Is there a way to load these into the database
directly instead of doing each table seperately from
the mysql prompt? (not web admin)
Thanks in advance.
Kind Regards,
Jer
Thanks, worked nicely.
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 14:52
+1000 6/8/03, JeRRy wrote:
> >Hi,
> >
> >I have a text file with all my database information
> to
> >create databases to setting up tables. I have
> looked
> >throught th
Okay thanks.
One last thing.
>From the mysql prompt how can I generate a database
backup? (So I can see the database setup in notepad
so I can backup and transfer easily online.)
Jerry
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 14:52
+1000 6/8/03, JeRRy wrote:
> >H
x27;s easier to update instead
of changing things.
So if I wanted to create another user other than root
how can I do this?
Thanks!
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 14:52
+1000 6/8/03, JeRRy wrote:
> >Hi,
> >
> >I have a text file with all my database info
html correctly but not php. Is
there something I need to add to apache to get php to
work with it? If so where can I download it from and
any instructions on installing it please.
Thanks for your time.
Jerry
http://mobile.yahoo.com.au - Yahoo! Mobile
- Check & compose your email via SMS on your T
High priority message ?
Then you should read the manual.
http://www.mysql.com/doc/en/Upgrade.html
- Original Message -
From: "MOSSANO" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 18, 2003 9:43 AM
Subject: upgrading
> I want to upgrade from 3.23 to 4.0 version. C
MySQL & OS version and hardware ?
Jerry
- Original Message -
From: "Steve Quezadas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 6:36 PM
Subject: MySQL gets slower over time
HIdey Ho.
I have a fairly large mysql database (a few mi
#x27;2003-07-08' ORDER BY count DESC LIMIT
150,-1;
Solaris 2.8 , mysql 4.0.13.
Any ideas anyone ?
Thanks
Jerry
- Original Message -
From: "Steve Edberg" <[EMAIL PROTECTED]>
To: "M Wells" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wed
If you are using the result set as part of an application, you could select,
then count the rows or use a function such as in PHP : mysql_num_rows()
Jerry
- Original Message -
From: "Mojtaba Faridzad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
http://www.mysql.com/doc/en/Table_size.html
More lightly to be file system than dB I think depending on the version.
Jerry
Apps-R&D
Cable and Wireless
- Original Message -
From: "Martin Hudec" <[EMAIL PROTEC
table for a year that will encompass them
all (i.e. 9.1 billion rows).
Has anyone had 365 tables in a merge table ? or more ?
Thanks
Jerry
-
Jeremy Hutchings
Apps R&D
Cable and Wire
If your going to HAVE to use windows 2000, you'll have to odbc and create
the form with vb.
I've always used web front ends and had the PDF generated on the fly, to
have to use 2000 is going to mess things up no end.
Jerry
- Original Message -
From: "Octavian Rasnita&quo
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 08, 2003 9:33 AM
Subject: Merge table limit
> Hello all.
>
> Does any one know, or can anyone point me in the direction of the limits
of
> a number o
Pass it to a script or handeler program that does the dB work then passes
back what you need to the radius ?
Jerry
-
Jeremy Hutchings
Apps R&D
Cable and Wireless
-
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
comma after the 3rd line.
CREATE TABLE info (name varchar(50),message varchar(255));
^ comma here.
Jerry
Apps-R&D
Cable and Wireless
- Original Message -
Most of mine weren't getting through either and it seem to of gone mad on
delivery too .
Jerry
Apps-R&D
Cable and Wireless
- Original Message -
From: "Simon Windsor" <[EMAIL PROTECTED]>
To: <[EMAI
Where is the text coming from ?
With languages like php, there are loads of functions to escape things and
make sure that the text is ok
Jerry
- Original Message -
From: "ahimsa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 08, 2003 9:21
Cheers.
The only limit I've hit so far on 365 tables, was the max number of open
files, so I've ramped that up and its working fine at the moment.
Jerry
-
Jeremy Hutchings
Apps R&D
Cable and Wireless
-
- Original Message -
From:
Write a script that generates all the GRANT SQL ?
Then pipe it into mysql.
I'd write a function that would go and get all the table name and a list of
the relevant users then generate the sql from there.
Jerry
-
Jeremy Hutchings
Apps R&D
Cable and
ess of
the order the resultset appears.
>
> > -Original Message-
> > From: Jerry [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 13, 2003 1:48 PM
> > To: Luc Foisy
> > Subject: Re: Row numbers
> >
> >
> > Have to have one in the row and s
Auto-inc column would be the obvious answer, but that's and intrusive
answer.
Jerry
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: "Luc Foisy" <[EMAIL PROTECTED]>
Cc: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursda
Yes, there are, many :)
Jerry
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 3:57 PM
Subject: New Database,
> Okay,
> I have installed, mySQL, ( all is well
Hi,
Any one gone over 1000 million rows ? or any where near ?
Pref. in ver 4+ with a MyISAM table.
Cheers
-
Jerry @
MetalCat.Net
-
SQL
-
Before posting, please check
t, opposed to MySQL limits.
Which is nice. :)
Cheers
-----
Jerry @
MetalCat.Net
-
SQL
- Original Message -
From: "MySQL List" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 200
Are you referencing the result set correctly in php ?
How are you dealing with what MySQL returns ?
Looks like the info is there, you just not getting it out of the result
set.
-
Jerry @
MetalCat.Net
-
- Original Message -
From: "Guru
Is it just me or is everyone on the list getting junk/spam from naver.com ?
-
Jerry @
MetalCat.Net
-
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the
What type of table is it ?
Would that effect it ?
Jerry
- Original Message -
From: "Magnus Själander" <[EMAIL PROTECTED]>
To: "'Peter Grigor'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 9:17 AM
Subject: RE:
That's what I'm hoping
jerry
- Original Message -
From: "Peter Grigor" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 1:39 PM
Subject: Re: INSERTs getting slower with growing tab
Another coffee ?
I'd buy Starbucks .....
Jerry
- Original Message -
From: "Peter Grigor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "david" <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 10:58 PM
Subject: Re: CREATE INDEX is
I meant buy the whole chain, its going to take a few cups
Jerry
- Original Message -
From: "Peter Grigor" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 11:11 PM
Subject: Re: CREATE
I know this is a MySQL list but
Personally being a php coder, I'd do it in php.
http://www.mysql.com/doc/en/Date_and_time_functions.html
-
Jerry @
MetalCat.Net
-
- Original Message -
From: "Melih Onvural" <[EMAIL PROTE
On Solaris I always use :
/etc/rc3.d/S99mysqld stop
/etc/rc3.d/S99mysqld start
Jerry
- Original Message -
From: "Sunil Gavaskar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
Sent: Monday, February 17, 20
l_num_rows($result);
if($num_rows)
{
return TRUE;
}
else
{
return FALSE;
}
}
Jerry
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 4:10 PM
Subject: Checking existence of a table.
>
> What query would I use to check
I'd create a table with
id, username, ,badgenumber, url.
then have i.e.
1, Jerry, 007, /dir/images/jerry.jpg
2, Bob, 008, /dir/images/bob.jpg
or something like that.
The scripting to get that out and generate the html would be very easy.
There are a few examples here that would cover
Using the hostname or IP adders of the machine it is on.
(B
(BJerry
(B
(B- Original Message -
(BFrom: "kk" <[EMAIL PROTECTED]>
(BTo: "list mysql" <[EMAIL PROTECTED]>
(BSent: Wednesday, February 19, 2003 9:24 AM
(BSubject: Connecting to remote server
(B
(B
(B> Hello folks
(B> I
http://www.mysql.com/doc/en/ALTER_TABLE.html
- Original Message -
From: "Prabu Subroto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 19, 2003 11:58 AM
Subject: MySQL
>
> --- [EMAIL PROTECTED] wrote:
> > Your message cannot be posted because it appears to
> > be e
ecking for less than 0 and finding out what the max is.
Most lightly going to be something in here :
http://www.devshed.com/Server_Side/PHP
Is it a case of one rows worth of information from the dB per page/request ?
--
Jerry @
MetalCat
dot Net
--
- Original Message -
Fr
So what is the actual question ?
If you don't have the software, surely you should get it and read the manual
if that is the best way you learn !
Jerry
- Original Message -
From: "Marijka Walker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday
as it is a language (well a
specification for one) opposed to MySQL.
Surely the nature of dB's and what/how they are used is understood from
previous knowledge of working with the others
Jerry
- Original Message -
From: "KH Chiu" <[EMAIL PROTECTED]>
To: "J
Yes,
http://www.mysql.com/doc/en/Installing_many_servers.html
- Original Message -
From: "shirly cohen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:42 AM
Subject: question about mysql installation
>
> Hi all,
> Can i install mysql twice on the same
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
'myuser'@'localhost' IDENTIFIED BY 'password'
mysql -u myuser -ppassword
Does that do it ?
Jerry
- Original Message -
From: "Andy De Petter" <[EMAIL PROTECTED]>
To: &
FILE
privilege on the server host. "
"you must have the FILE privilege on the server host. "
http://www.mysql.com/doc/en/LOAD_DATA.html
Did adding FILE to the permissions do it ?
Jerry
- Original Message -
From: "Andy De Petter" <[EMAIL PROTECTED]>
To: &qu
That's going to be a bit out of date !!
I'd suggest a combination of Paul DuBois's latest offering in blue and the
www.mysql.com search engine.
Keeps me out of trouble, well mostly !
Jerry
- Original Message -
From: "Andy De Petter" <[EMAIL PROTECTED]>
show tables; ?
or do you mean specific to vb ?
Jerry
- Original Message -
From: "Jeff Pearson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 10:31 PM
Subject: List of Tables
> I am writing a vb.net application to do some db
can you post line 4 of the script ?
Jerry
- Original Message -
From: "Sunfire" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:11 PM
Subject: @ character appended at end of username problem
> hi..
>
> i have an mysql use
C:\WINNT\system32\drivers\etc
There should be one there by default
Jerry
- Original Message -
From: "Sunfire" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:32 PM
Subject: Re: Access Denied Help Needed
> if i remember righ
or my application I had to be sure that the input was 100.00 % ok.
Jerry
- Original Message -
From: "James Kelly" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 2:02 PM
Subject: Checkpoint FW1 logs into mysql
> Hello all
> I&#
Depends on what you are experienced with on win platform I would of thought.
Something like vB or Delphi is very quick and easy to use.
Jerry
- Original Message -
From: "Simon Windsor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 1
As I said, all depends on what you are used to , as to which is going to be
the least painful path.
Jerry
- Original Message -
From: "KH Chiu" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>; "Simon Windsor"
<[EMAIL PROTECTED]>
Cc: <
s no where near
an issue, I run a app against mysql that has arrays around 250-300K at the
moment and its fine.
Jerry
- Original Message -
From: "gregory lefebvre" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 3:07 PM
Subject: Large table
http://www.amazon.co.uk/exec/obidos/ASIN/0735712123/qid=1046214226/sr=1-7/re
f=sr_1_3_7/202-4962738-0968635
- Original Message -
From: "Jasdeep Singh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 25, 2003 11:01 PM
Subject: Question
> Dear Sir:
>
> Could you recomme
Has a quick overview of installation :
http://www.php.net/manual/en/ref.mysql.php
A whole load more tutorials :
http://www.domaincarecenter.com/php_programming_tutorials.htm
Jerry
- Original Message -
From: "agc" <[EMAIL PROTECTED]>
To: "KH Chiu" <[EMAI
Have you done anything to the files by hand ?
I used to get this when I moved tables about and effected the permissions or
case of the extensions.
Jerry
- Original Message -
From: "Daniel Geske" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Feb
What versions of MySQL are on each machine ?
Jerry
- Original Message -
From: "Floyd Wellershaus" <[EMAIL PROTECTED]>
To: "Mysqllist (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 1:55 PM
Subject: mysql replication across platforms
>
As with most things, depends on what you want to do, what are the
requirements ?
Jerry
- Original Message -
From: "InfoSysNCA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 5:23 PM
Subject: MySQL or PostgreSQL
> Hi! I've just
ing.
Load data infile doesn't "link" the file, it imports the contents into the
dB.
Jerry
- Original Message -
From: "Barry Hayden" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 04, 2003 11:28 AM
Subject: Loading pictures dynamicall
I'm fairly sure it won't do master-master at the moment.
I'd like to be wrong though.
http://www.mysql.com/doc/en/Replication_FAQ.html
----
Jerry
Systems Dev
Cable & Wireless
- Original Message -
From: "Gaston Escobar
Yea, I've done what it says there but had to implement the locking myself,
then just use two subsets of the dB and master slaved them to each other on
the respective parts that weren't being used.
----
Jerry
Systems Dev
Cable & Wireless
- Or
Well no because " real two-way replication" would happen at the dB level, or
through some distributed transactional layer.
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Jerry" <[EMAIL PROTECTED]>
If you confused I wouldn't bother replying.
I was answering another question from a while ago.
J
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursda
Store it in another table and have a start up script that creates a heap
once the server is started ?
Jerry
- Original Message -
From: "Steve Quezadas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 7:41 PM
Subject: heap tables keep on di
mysql -u user -ppassword my_dB < some_file.sql
With the "Just do it" flag ?
Cheers
Jerry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This ?
http://www.mysql.com/doc/en/Installing_many_servers.html
Jerry
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 8:55 AM
Subject: 2 different Mysql DB on the same server
Hi to all,
I need to have on the same PC
http://www.php.net/manual/en/function.substr-replace.php
- Original Message -
From: "delz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 8:57 AM
Subject: Stripping off commas
> Hi All,
>
> I'm using Mysql as my database and php as my script to connect to the
Hi,
vBulletin has a customer support forum, if you post there the support team
will deal with it or pass it to one of the developers.
Jerry
- Original Message -
From: "Mihai RUSU" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 8:13
By waiting or reading :
http://www.mysql.com/doc/en/ANSI_diff_Triggers.html
Jerry
- Original Message -
From: "Themis Kafetzopoulos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 28, 2003 3:37 PM
Subject: Storing procedures
> How can I
Which server is going to perform the application logic (the one on the LAN
I'd hope) ?
Can you just replicate to the local one from the internet ?
I've done a lot of things like that in PHP , depends on the data sizes and
error checking etc etc.
Jerry
- Original Message -
Does anyone know of a good color coded SQL editor for MySQL that
runs on Windows?
TIA,
Jerry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Does anyone know of a good color coded SQL editor for MySQL that
works in Windows?
TIA,
Jerry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi,
I am trying to setup a PHP form to send to mySQL
database. I know how to connect to mySQL but need
help getting the information in the form to update
into the mySQL database.
I have the following table called contacts, I'd like
the form to have the following fields.
firstName
lastName
emai
Hi,
I would like to create a members area on my site,
using mySQL for the database to hold usernames and
passwords to login to the area.
I need to know the following if anyone can help
please.
- What code would I need to make a login page form
that has username and password? (lets say the table
t;
ALSO, if I have more than one page for the members how
do I protect these? So if they have not got a valid
login they get asked for it or referred back to the
login / main page? Or is there a way to have all my
pages in the one PHP file? (I think thi
there any if-like
>function that checks ALL records for the ID=ocenjevalec, not just the first
>(or the grouped by, seems to take 'ocenjevalec' as from the first data). If
>this is not possible, how can I achieve that? Should
recordset from the members or oldmembers table.
There must be another way directly from the SQL query.
I looked everything on Internet about this problem and couldn't find any
solution. Could you just point me to any directi
). In SQL I can not do
>the AND and compare both MEMBER_ID's because it would never return anything.
>If I use or I do get data, but not one, but multiplied number od times (every
>new member is then resulted or every old member, depending on in which table
>SQL finds the data).
>
when my database
grows, all of the new messages will be from new members, not old, so the
condition to open recordset in for...next loop would not be executed.
Is my thinking valid?
Yours
Jerry
-
Before posting, please check:
but I need to to this in mySQL).
Yours
Jerry
-
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 P
n("date")
Session("date") holds 20011126121222
Is 14 number digit to much to use < or what is wrong?
Thank you for your help.
Yours
Jerry
-
Before posting, please check:
http://www.mysql.com/manual
;although I own a copy of it I have hardly used it in a year or
>>more)).
>>On a side note to Jerry, I checked my uptime this morning, and
>>my Amiga1200 has now been running for 59 days without a single
>>reboot. I have yet to see windows do that. :-D
>>And... o
code is generated or is it better to connect for every piece of
information that is needed?
What should I also be looking for in optimizing my pages? I don't have near
100 users simultaniously accessing database!
Yours
a 20, OR 37
I know this is childs play for some of you out there. Any help/ideas would
be greatly appreciated.
Jerry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi-
Anyone know what web.mysql.com is doing? It's from a netstat on a RH 7.2
running mysql 3.23.47
myhost.mydomain:4570 web.mysql.com:auth TIME_WAIT
Thanks-
-
Before posting, please check:
http://www.mysql.com/
What do I put in a date field's default value if I want
the MySQL database to insert the current date in the
field when
a new record is inserted?
TIA,
Jerry
-
Before posting, please check:
http://www.mysql.com/manua
m?
I am using Win98 2nd edition. I downloaded and installed
My ODBC. For some reason, I am not able to see the MySQL
ODBC driver. What do I need to do so that it is available
to me?
I am really lost with this.
Jerry
-
B
David Lloyd wrote:
How do you mean not able to "see it"? Under the control panel there
should be an "ODBC Data Source Administrator"...
(mysql, query)
DSL
The driver is not listed in the driver. I cannot select
it from the list of drivers as it
Is there any way to find a column name (or, better yet, a partial column
name) in all tables within a data base?
I inherited a complex and totally undocumented data base, and need to find
out (for example) which tables have a column name like xxx_exported.
Regards,
Jerry Schwartz
Global
irst table is named ORDER,
and I thought there was something wrong with my plan.
Thanks.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: George Law [mailto:[EMAIL PROTECTED]
Sent: Tu
I haven't ventured into MySQL 5.x, I have enough trouble working with this
house of cards I was handed. I'll try to remember this for the future,
though.
Thanks to all.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.
thing?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Actually, by default a full text search ignores words that are three
characters or less, not less than three characters.
I found this out by searching on "red".
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 86
More than likely, the OS file system is caching the files that make up the
tables.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ratheesh K J [mailto:[EMAIL PROTECTED]
Sent
en-source spell checkers
(http://www.thefreecountry.com/sourcecode/spellcheckers.shtml, et al). I
don't know what language you are using, so I can't go further than that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674
You might come close by using a combination of tee, select, and notee
commands. You didn't say if this was for debugging, which would tolerate a
lot of ugly, or not.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674
Yeah, my customer wasn't too pleased when his product search could only find
certain colors. ;<)
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Chris [mailto:[EMAIL P
1 - 100 of 859 matches
Mail list logo
