I knew it was an option somewhere... Perfect!
Thanks
JamesDR wrote:
> JamesDR wrote:
>> Scott Baker wrote:
>>> If I create the following table, and then try and insert the following
>>> data both inserts work. It looks like the second one works (it shouldn't
>
If I create the following table, and then try and insert the following
data both inserts work. It looks like the second one works (it shouldn't
because Last is NULL) because it assumes Last = ''. Is there a way I can
make it NOT assume that? If Last is not specified it should reject that
command. I
rs of the older mysqlcc.
I've also tried the Aqua Data Studio which seems decent but it
requires java is a little slower.
http://www.aquafold.com/
Anyone out there have a GREAT mysql client tool they can recommend?
--
Scott Baker - RHCE
Canby Telcom System Administrator
503.266.8253
--
M
Disregard this question, it was a problem with a script I wrote, not
a problem with mysqlhotcopy. My bad!
Scott
Scott Baker wrote:
> I recently upgraded from MySql 4.0.x to 5.0.x and now my nightly
> backups are giving me this error (from mysqlhotcopy).
>
> Cannot open di
information_schema" thing.
That's definitely NOT in my /database directory. How do I get it to
NOT error out on that?
--
Scott Baker - RHCE
Canby Telcom System Administrator
503.266.8253
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
*
> FROM UserInfo u
> INNER JOIN DslInfo d USING (UserID)
> LEFT JOIN DslExtra e ON d.DslID = e.DslID
> LEFT JOIN ExtraAddr a ON a.UserID = u.UserID;
>
> PB
>
> -
>
> Scott Baker wrote:
>> I have four tables that I join to get one record set about a
>>
I have four tables that I join to get one record set about a
customer. They are: UserInfo, ExtraAddr, DslInfo, and DslExtra.
Specifically the main tables are joined with:
SELECT * FROM UserInfo u, DslInfo d WHERE u.UserID = d.UserID;
I've been adding more data to other tables and LEFT JOINING to
LYZE TABLE on your tables?
>
>
> Scott Baker wrote:
>> I have a query that's taking about 0.3 seconds to run and it should
>> be faster I think. I've read all about query optimization and
>> forcing indexes and I'm not entirely sure what I'm having this
>&
wrote:
> Hello.
>
> Please, provide the output of EXPLAIN for your queries. The performance
> should improved if you make e.CustID and c.CustID the same type (one of
> them is unsigned). Have you run ANALYZE TABLE on your tables?
>
>
> Scott Baker wrote:
>> I have a que
I have a query that's taking about 0.3 seconds to run and it should
be faster I think. I've read all about query optimization and
forcing indexes and I'm not entirely sure what I'm having this
problem. Google finds all kinds of basic information like using
indexes, and not doing math on the query f
Is there a way to tell mysqld to stop running a query if it hasn't
completed in over 60 seconds? Or how about stop running if the
result is greater 100,000 rows or something? I have a bone head user
who keeps querying two tables and NOT joining them, and then
dragging the DB server down while i
:
I made a change to my.cnf and want it to restart mysqld_safe so it will
re-read my.cnf. How do I do this?
Thanks,
Chip
--
Scott Baker
Canby Telephone - Network Administrator - RHCE
Ph: 503.266.8253
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
e north does not appear in the last result
because north was only visited by bob in 2005 and kim in 2004,
records which are not included in the limited result.
Any help appreciated.
I would like to be compatible with 3.23.xx.
-Bob
--
Scott Baker
Canby Telephone - Network Administrator - RHCE
Ph: 5
I searched the archives but couldn't fine much on the QueryBrowser. I
think it's still pretty new. Is anyone else experience frequent crashes
using this software?
After about 6 queries or so (mild use) it crashes randomly.
./mysql-query-browser: line 9: 19346 Segmentation fault
$MYPATH/mysql-qu
com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
-text indexes.
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
PGP KeyID: 0xC2153655
-
Before posting, please check:
did a search through the mysqsl (3.23.38) source code after I compiled
>it, and I don't find that library anywhere? What am I doing wrong?
---------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
&q
server
>settings and what not.
>
>-----
>Larry Hotchkiss
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"You may be disappointed if you fail, but you are doomed if you don't try."
-
PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Short wor
.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
27;t.
>
>I will now make another pass at a couple of pages that seemed to be
>the focus of the errors that users received, to see if I can improve
>the error handling (and maybe mail myself a message!). For now, I'm
>calling the bug worked-around.
>
>GB
>
>On Wedne
s.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]> Trouble
> > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>-
---
>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 <
(the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker
anual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
ual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-----
Scott Baker - Webster I
atly help us to
>make decision and to use MySQL.
>
>Thanks.
>
>Regards,
>
>John Ding
---------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"It has been said that the
ad, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
&
omething2')
>
>now if $something1 contains any french characters likeé
>
>mysql says there is an error in sql statement
>
>I am using a BLOB datatype
>
>How to escape french characters using perl or using mysql
>
>
>chris
--------
MySQL will run just fine on all Win32 platforms. Including Millenium.
At 05:41 PM 4/11/2001 +0200, Sylvain Besson wrote:
>Hi
>Is mysql running on Windows Millenium ?
>Thank you in advance
>
>Sylvain Besson
------
>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 <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsub
ECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"It has be
ould make my day if someone knew the answer.
---------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"It has been said that the primary function of schools is to impart enough
facts to make children stop asking questions. Some, with whom the schools
do
w.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 <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
w.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 <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
quest this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Technic
ogram to
> do that? Any help would be most appreciated.
>
>Mat
---------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"It has been said that the primary function of schools is to
Make them a char(32). They will also be 32 chars long, have the DB expect
that.
At 10:48 AM 3/21/2001 -0600, roger westin wrote:
>Whats the best way, any realy good space saving way to store a MD5 value?
>
>/roger
--
t;localhost","root","") or die ("Server Currently Unavailable");
Put the @ in front to suppress error messages.
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PR
fy that the 2nd one is indeed),
>but still they are begining to show signs of their age. Mysql develops
>very fast and they are both '99 books (IIRC). Does anyone know of any
>plans for 2nd editions?
-
Scott Baker - Webster Internet - Netwo
e reverse and says 'Hey, I've
>seen you before, you're 13ave.com'
>
>
>You can turn this behavior off with --skip-host-caching (or whatever it is
>mysql --help). BUT, you want to think what load this will give your
>nameservers. Consider redoing your DSN per
b.web-ster.com info, so I don't know where mysql is
getting that info. Anyone have any problems with this?
Scott
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Children today are tyrants. They contradict t
looking for it on my Linux box. I have both php3 and 4 on the system
>and mysql seems to be working fine. However, I could not find phpMyAdmin.
>So how
>do I get it and how do I put in on this box??
-----
Scott Baker - Webster Internet - Network Technici
and I can't find anything
>showing commands on how to connect to other databases. Can someone point me
>in the right direction?
>
>Thanks.
>
>John Halladay
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTE
The problem
>is, when I link to the table it shows the data in my data formatted fields
>all messed up. The data in the mysql table is fine, it is something the
>odbc driver or access is doing. I read on the Egroup that Scott Baker was
>having a simular problem in September, but I d
er wrote:
> >
> > Its not recommended to just `cp' your data directory for use
> > later. You should always dump the database with mysqldump.
>
>Eh?
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTE
lt;[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Children today are tyrants. They contradict their pare
I am not part of the mailing list yet.
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Children today are tyrants. They contradict their parents, gobble their
food
while, when I try to bang my head against a
>Red Hat MySQL install again.
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Children today are tyrants. They contradict their parents,
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
> > M
OAT, AUTO_INCREMENT,
>etc...I looked through the manual and archives to no avail.
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Always bear in mind that your own resolution to success is more important
than an
ou can find the
> developer to pay him.
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Always bear in mind that your own resolution to success is more important
than any other one thing."
t;[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Technician
503
Primary key by definition is a unique index.
At 02:33 PM 1/15/2001 -0800, Rekha Das wrote:
>I need to know whether the primary key field already has a index on it or we
>need to create one.
-
Scott Baker - Webster Internet - Network Technician
503.26
db = Nothing
> DoCmd.Close
> Exit Sub
> End If
> End If
>
>
>
>cleanup:
> frminq![event_id] = Me![event_id]
> frminq![event_id Box].Visible = True
> frminq![event_id
(the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Te
archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Techni
erl5 is needed. The perl version installed is Perl 5.005. Is
>this not enough?
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Always bear in mind that your own resolution to success is more important
than any other
or the the list of tables, there were not tables.
>
>Is this expected?
-----
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Always bear in mind that your own resolution to success is more important
than any other
sit there?
>
>Any help would be great!
>
>Thanks!
>Dave Young
>Applications Engineer
><http://www.gluepoint.com>www.gluepoint.com
>"We make billing easy."
-
Scott Baker -
w.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 <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
ad, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"A
hich does not work. But that's the idea.
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"Always bear in mind that your own resolution to success is more impor
drives,
>gig of RAM. What's the best set up for a PHP/mySQL web server for approx
>60,000 page views and 1300 visitors per day?
>
>Thanks in advance,
>Mike
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTEC
t;* Create Textbox
>* For DataSource choose: Adodc1
>* For DataField choose: fldSITEName (fldSITEName is text format field
> in MySQL).
>* Run program (F5)
> Maybe this will help you to understand what did I do.
>
>
>Regards,
>Vladimir
-
67 matches
Mail list logo
