bad code on
the part of my users? And if the latter, what can I do to prevent their
bad code making my slaving fail?
--
Duncan Hutty
System Administrator, ECE
Carnegie Mellon University
Please use informative subject lines
--
MySQL General Mailing List
For list archives: http://lists.mysql
.
Kurt Duncan
> -Original Message-
> From: Duncan, Kurt (MCUSA) [mailto:k...@medconnectusa.com]
> Sent: Thursday, April 09, 2009 12:28 PM
> To: mysql@lists.mysql.com
> Subject: S L O W query over internet
>
> We are running a remote service and have an application t
arched the internet and
found several postings that this is normal but I can't believe anyone would
wait this long... does anyone have any ideas or can you point me in the right
direction?
Kurt Duncan
and running the same query and same database on a
2000 server 1 gig less memory runs the query in about 15 seconds with no
issues. Is this an issue with MySQL or the 2008 server?
Kurt Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
speed on the VPN has tested fine. Does anyone have any ideas?
Kurt Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Thursday 19 April 2007 15:53:54 molemenacer wrote:
> I am trying to change all the names of the database from mthosp to another
> name, is this possible?
Assuming you mean tables, not database (as mysqldump doesn't store the
database name in the dump file [or at least never has for me]):
sed
On Thursday 19 April 2007 11:43:34 molemenacer wrote:
> Hi all,
>
> I have backed up a database using mysqldump and have a .sql script that is
> over 2GB in size. I am trying to open this file to view it and make some
> changes. I have not been able to find a program that can open this file.
>
>
On Monday 02 April 2007 09:11:18 sam rumaizan wrote:
> I have to two different fields Last_Updated and Story. I want whenever
> Story Field got updated (modified) the time and date of the modification
> get recorded (insert) in Last_Updated Field
The answer you seek lies within the manual.
http:/
On Thursday 29 March 2007 11:38:21 Stephen Liu wrote:
> > http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html
>
> I tried learning resetting the password according to above URL. I
> can't find "set" command on this box. I don't know which package
> provides it so finally I surrende
On Tuesday 06 March 2007 01:51:38 xian liu wrote:
> Hi all,
>
> when I insert many records into a myisam type table, at the same time,
> unplugged the power cable, the os crash, I found several *.MYI file was
> corrupted, but can use "repair" or "myisamchk" to repair those table.
>
> Is there any w
On Thursday 01 March 2007 13:43:38 [EMAIL PROTECTED] wrote:
> >Otherwise you're looking at perhaps select limit 0,1000, 1000,1000,
> > 2000,1000
> >
> >etc ..
>
> Can you clean up this command? I can't find documentation on the select
> limit part of a mysqldump command.
It's nothing to do with my
On Thursday 01 March 2007 09:56:41 [EMAIL PROTECTED] wrote:
> Hi;
> I have an unusual problem. My current production server's OS is corrupt and
> I'm building a new one. However, due to the corruption, I can't move files
> out of it. I have a "back door" through Zope, but I can only move files of
>
On Thursday 15 February 2007 11:12:11 Juan Eduardo Moreno wrote:
> Linux :
>
> $ rpm -qa |grep -i mysql
>
> Regards,
> Juan
>
> On 2/14/07, Zsolt Csillag <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I would like to create a setup program for my demo version that uses
> > MySql database.
> >
> > I
On Sunday 04 February 2007 17:24:29 Jim MacDiarmid wrote:
> I've been trying to figure this out using the CURDATE() function, but I
> keep getting a syntax error. Below is the code I'm using:
>
> SELECT
> `vb_links`.`DateAdded`
> FROM
> `vb_links`
> WHERE DATEDIFF( CURDATE() , `vb_links`.`DateAdded
On Thursday 25 January 2007 11:08, Neil Tompkins wrote:
> The databases are on the same server, however the login details for each
> database are different.
>
A query executes with the credentials of the authentication used to set up the
connection. If you want to query two tables simultaneously
Chris White wrote:
Duncan Hutty wrote:
I attempted to build 5.1.14-beta with ssl support and it failed
(output below).
It builds quite happily on this system without the ssl support
parameter to configure. Since it appears to fail in an area (timezone
system) that to me seems rather
.
x86-suse9.3, openssl-0.9.8d, gcc-3.4.6 (or gcc-4.1.1) using:
CFLAGS="-O3" CXX=gcc \
CXXFLAGS="-O3 -felide-constructors \
-fno-exceptions -fno-rtti" \
./configure --with-ndbcluster \
--with-ssl=/usr/local/openssl \
--enable-assembler && make
Any suggestions?
--
Dunca
On Friday 29 December 2006 14:02, Servers24 Network wrote:
> Hi,
>
> Well this question may seem funny, but I really need to know!
> The problem is with counting a user's contribution in my site. Suppose that
> each user that send an email will be stored in DB. Now I want to count
> number of times
On Monday 18 December 2006 13:10, Karl Larsen wrote:
> Is there a paper I can d/l that covers intalling MYSQL on Red Hat
> Linux?
http://dev.mysql.com/doc/refman/5.1/en/linux-rpm.html
perhaps?
--
Scanned by iCritical.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
On Saturday 25 November 2006 17:54, John Kopanas wrote:
> The following query takes over 6 seconds:
> SELECT * FROM purchased_services WHERE (purchased_services.company_id =
> 535263)
What does EXPLAIN say about that query?
Have you done an optimize recently?
--
Scanned by iCritical.
--
MySQL
On Thursday 14 September 2006 11:46, Martijn Tonies wrote:
> > > for commercial email under bill S.1 6 1 8 Title lll, Section 301,
>
> lol .. I believe it's not really that ... It CAN be considered SPAM, but
> it's just "allowed spam" ... :-D
1618 never passed.
http://www.techlawjournal.com/cong
On Thursday 31 August 2006 12:21, Renald Buter wrote:
> The problem is that a simple 1-table query shows different answers
> depending on whether you select 1 or 2 columns.
Relational databases are founded on mathematical set theory. Unless you
specify an ORDER BY stanza in your query, the data
On Friday 11 August 2006 08:25, [EMAIL PROTECTED] wrote:
> Can the output of the DESCRIBE be stored somewhere ( in file)?
mysql mydb 'describe table' > table.describe.txt ?
> Or is there any way to get the structure of whole table?
show create table?
--
Scanned by iCritical.
--
MySQL General
On Wednesday 02 August 2006 09:28, Asif Lodhi wrote:
> Hi,
>
> Though I understand very well that it has been discussed lots of time
> before but I don't have time to browse through the previous archives
> and dig out the stuff I need. So, guys, I would be thankful if you
> could give me your valu
On Wednesday 26 July 2006 22:16, Karl Larsen wrote:
> I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5
> of any other and find with Core 4 I can yum only mysql version 4.
>
> I imagine Core 5 might be able to yum mysql version 5 but not
> certain of that. Is there a way
On Monday 24 July 2006 16:16, Brian E Boothe wrote:
> HI all i have a question, I have A server MySQL database in our
> office location that stores Contact information / inventory etc... and
> also we have a Internet Site
> NOw what id like to perform is Whenver Someone changes something in the
On Monday 24 July 2006 09:06, Duncan Hill wrote:
> On Monday 24 July 2006 09:05, Ratheesh K J wrote:
> > Hello All,
> >
> > I run a select query to see its speed. It took around 5 seconds. Now i
> > run the same query simultaneously twice usng two instances of the
On Monday 24 July 2006 09:05, Ratheesh K J wrote:
> Hello All,
>
> I run a select query to see its speed. It took around 5 seconds. Now i run
> the same query simultaneously twice usng two instances of the client tool.
> It took 10 seconds for both the queris to complete. Its not 5 secs + 5
> secs.
On Tuesday 18 July 2006 16:08, Dominik Klein wrote:
> > My question is : do I have to follow the upgrade procedure from 4.0 to
> > 4.1 or can I juste installed the new binaries? We are not ready yet for
> > the version 5.
>
> As always when upgrading: Make sure you have a backup :)
This becomes a
On Monday 17 July 2006 13:26, Karl Larsen wrote:
> I'm using mysql on Linux and all is going well but I can't find the
> proper way to write a CREATE VIEW. I'm using 4.1 and is this function
> still in mysql?
If the MySQL manual for 4.1 does not list views as a feature of that version,
odds a
On Wednesday 12 July 2006 20:58, Chris White wrote:
> performance?". From what I know of MySQL, not really, because MySQL does a
> good amount of work in memory. The only time I'd see disk access being a
> factor is if you had a large mass of swap/virtual memory.
I have to play with 300 gig of
On Tuesday 04 July 2006 21:33, Karl Larsen wrote:
> I have not yet found how I can put a $ in front of all the money
> columns :-)
Either use concat() or do it in your program that retrieves the data from
MySQL. Currency symbols are not something the database should have to store
for you.
-
On Tuesday 04 July 2006 16:21, Nolan Rumble wrote:
> SELECT COUNT(*) FROM temp GROUP BY recipient;
>
> and it will list all the email addresses and how much email they
> sent/received.
>
> I suppose I can create another table which handles the variable length
> recipients but I would like to avoid
On Saturday 24 June 2006 12:50, Asif Lodhi wrote:
> Hi,
>
> Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
> Is that correct? Or 5.0.5 came first and then came 5.0.22?
After. 5 < 22.
Major.Minor.Release
--
Scanned by iCritical.
--
MySQL General Mailing List
For list a
and your patch. I can't find what I think is where you
> want to put one line of code. The other lines do not exist. Or I don't
> know what I.m doing :-)
chkconfig mysqld on
--
Duncan Hill - Developer
Critical Software
+44 (0)870 770 8190
--
Scanned by iCritical.
--
MySQL Gener
Good day list,
I've encountered a behaviour with 'WITH ROLLUP' that I don't understand.
SELECT a.report_date,
SUM(b.daytotal*last1) last1,
( 100*SUM(b.daytotal*last1) /
(select sum(daytotal) FROM aggregate_logs
WHERE aggr_source like 's%' and aggr_date=CURDATE()
)
) tper
FROM m
google.co.uk/search?q=mysql+slow+query&ie=UTF-8&oe=UTF-8
Combined with show processlist / mysqltop, you can see if you have locking
contention.
--
Duncan Hill - Developer
Critical Software
+44 (0)870 770 8190
Scanned by mailCritical.
--
MySQL General Mailing List
For list archives: ht
On Tuesday 20 June 2006 08:23, Ciprian Vizitiu wrote:
> > On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> > > Hi Chris,
> > >
> > > I've noticed that a Ctrl-C will also leave the query
> >
> > running (5.0.22 -
> >
> > > Linux) and I've had to use the kill from mysqladmin or
On Monday 12 June 2006 14:16, Gabriel Mahiques wrote:
> but I have a problem with this solution, because I have the words in the
> middle of the phrase.
> For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to
> replace IT with Movie Kill Bill Vol 1 in "dvd" format.
> In Another case I
On Wednesday 07 June 2006 16:04, Kaushal Shriyan wrote:
> mysql> use mysql;
> Can't read dir of './mysql/' (Errcode: 13)
> Database changed
> mysql> show tables;
> ERROR 12: Can't read dir of './mysql/' (Errcode: 13)
> mysql>
>
> Kaushal
$ perror 13
OS error code 13: Permission denied
Your fil
On Tuesday 06 June 2006 15:38, [EMAIL PROTECTED] wrote:
> Quoting Barry <[EMAIL PROTECTED]>:
> > Well my msql doesn't give me any errors using that query.
> > neither a warning.
>
> Ditto.
>
> usemysql> use test;
> Database changed
> mysql> CREATE TABLE a ( t TIMESTAMP );
> Query OK, 0 rows affecte
On Thursday 01 June 2006 03:05, Mathieu Bruneau wrote:
> Harish TM a écrit :
> > hi...
> > I need to store something like a couple of million rows is a MySql
> > table. Is that ok or do I have to split them up. I intend to index each
> > of the columns that I will need to access so as to spee
On Thursday 01 June 2006 17:02, Ed Curtis wrote:
> I have a column in a table I need to replace a value of certain records
> in. The current value is /realtors/Value/. I need to change them to
> /realtors/This_Value/. Is there an easy way to do this. There are way too
http://dev.mysql.com/doc/refm
On Thursday 01 June 2006 15:52, Miles Thompson wrote:
> Is there a tool, preferably open source, that can read database schema
> scripts (for lack of a better term) or connect to the database, and
> generate a diagram? This for a MySQL 5.x database.
I use dbVisualizer, but it isn't a free tool.
On Thursday 25 May 2006 12:02, balaraju mandala wrote:
> Hello All,
>
> I need some explanations about these files.
>
> 1. ibdata1
> 2. ib_logfile0
> 3. localhost-bin.index
> 4. localhost-relay-bin.01
> 5. master.info
> 6. relay-log.info
http://dev.mysql.com/doc/refman/5.0/en/innodb-configurat
thing.
Your hack works, but you'd be better off reading up on SQL injection (you can
do more than select all records - how's a dropped table strike you?), and
looking at the availability of quoting capabilities in your language of
choice.
--
Duncan Hill - Developer
Critical Software
+44 (0)870 770 8190
Scanned by mailCritical.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Friday 07 April 2006 10:30, Mark Sargent wrote:
> alexj wrote:
> > try mysqldump --no-data -u
>
> Hi All,
>
> thanx, but get the following,
>
> mysql> mysqldump --no-data osc -u admin;
> ERROR 1064: You have an error in your SQL syntax near 'mysqldump
> --no-data osc -u admin' at line 1
mysql
On Friday 24 February 2006 12:33, Erich Beyrent wrote:
> My question is whether or not it is good design to have each user have
> his or her own set of tables. Would it not make sense to have all user
> posts in a single table, referenced by a BlogID? This table could
> easily grow to be a few m
On Friday 30 December 2005 14:05, jean-marc Jegou wrote:
> Re: install mysql-5.0.17 on linux AMD 64 processor
> http://lists.mysql.com/mysql/193352
>
> dir Duncan Hill ,
>
> thank you to answer to my question !
>
> my processeur is AMD 64 2800+ ( 64 Bits processeurs!)
On Friday 30 December 2005 10:35, jean-marc Jegou wrote:
> i try to install mysql-standard-5.0.17_linux-x86_64-glibc23, but it did
> not work !
>
> System: Linux localhost.localdomain 2.6.9-10.2.aur.2 #1 Thu Feb 10
> 04:34:27 EST 2005 i686 athlon i386 GNU/Linux
> Architecture: i686
x86_
On Friday 16 December 2005 00:34, Stephen Cook wrote:
> I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
>
> And my filters remove anything that isn't from one of the mailing lists
> I subscribe to.
Did the spam actually come through the list, or did it just fake the From to
m
On Thursday 15 December 2005 15:01, Darrell Troth wrote:
> I am designing an intranet for a law firm. Everything works fine. My
> problem is that they need to include the documents that are relative to
> specific cases in their database. These documents are on a different
> computer and I cannot fi
On Tuesday 13 December 2005 02:25, Peter Lauri wrote:
> Best group member,
>
>
>
> How can I prevent people from hijacking a query? I read this in an article
> about a few months ago, but now I can not find that article again. This
> question is maybe not so exact, and I do not know how risky it is
I am looking to do a query on a self join table that returns the parent
records.
Obviously there are ways to do this, but just wondered if there are any
functions in MySQL that make this easier, or specific functions
available to stored procedures. I have read the manual and couldn't find
any
Title: DIY MTB
Is there any built in or other
support for recursive queries . I suspect not, but wonder what is
considered the best approach.
With stored procedures being supported in 5.0 is that the way to handle
these.
Thanks
--
Duncan Miller
[EMAIL PROTECTED]
www.diymtb.com.au
On Wednesday 07 December 2005 15:29, Shaun wrote:
> SELECT Firstname FROM Users;
>
> Matthew
> Matthew
>
> I need to do this with pure SQL - no server side scripting...
http://dev.mysql.com/doc/refman/4.1/en/string-functions.html
CONCAT() perhaps.
Scanned by mailCritical.
--
MySQL General
on lesser hardware (ok, so the SAN
> > isn't lesser). The manual also contains a lot of information on how to
> > tune
> > MySQL for large memory environments - the default configuration is for <
> > 256
> > MB I think.#
>
> Thank you Duncan and Sco
On Tuesday 22 Nov 2005 09:24, Marko Knezevic wrote:
> is running on dedicated server which consists of two Xeons @ 3 Ghz, 2 GB
> RAM and two 150 GB disks @ 1 rpm running under RAID 1 controller. OS is
> CentOS 4.2
A very recent article that crossed my eyes indicates that in certain cases, HT
On Tuesday 08 Nov 2005 08:42, Timothy Wu wrote:
> another partition. So I manually removed the files. However, not much disk
> space was freed from the operations. I suspect what I removed were hard
> symlinks, but I wasn't quite sure. Why wasn't my disk space freed? How
> would I be able to free
n the later releases.
Sorry for any confusion I caused!
Rhino
- Original Message -
*From:* Duncan Miller <mailto:[EMAIL PROTECTED]>
*To:* Rhino <mailto:[EMAIL PROTECTED]>
*Cc:* mysql@lists.mysql.com <mailto:mysql@lists.mysql.com>
*Sent:* Monday, Novemb
ino wrote:
See comments interspersed below.
Rhino
- Original Message -
From: "Duncan Miller" <[EMAIL PROTECTED]>
To:
Sent: Sunday, November 06, 2005 8:36 PM
Subject: Evaluating text as an expression
I am trying to set up a table where the returned value is a res
Select evaluate(queryText) from queryTable where queryId = x
This is probably a bit more redundant now that 5 has stored procedures
etc but still...
any ideas
Thanks
Duncan
> On Wednesday 21 September 2005 11:23, Martijn Tonies typed:
> > Hi there,
> >
> > Did I just see in the documentation that the "comment" clause
> > is being misused to supply a connection string for the federated
> > engine?
> >
> > If so, I sure hope it will be changed before the final 5.0 relea
On Wednesday 21 September 2005 11:23, Martijn Tonies typed:
> Hi there,
>
> Did I just see in the documentation that the "comment" clause
> is being misused to supply a connection string for the federated
> engine?
>
> If so, I sure hope it will be changed before the final 5.0 release.
>
> "comment
On Saturday 10 September 2005 12:17, Gleb Paharenko wrote:
> Hello.
>
> Looks like it is a bug. See:
> http://bugs.mysql.com/bug.php?id=7883
>
> Duncan Hill <[EMAIL PROTECTED]> wrote:
> > I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as
&
I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as we're
starting to encounter quite a few tables that are larger than 4 GB. However,
the create table statements used by the software application using the DB
don't seem to be creating tables with pointers > 4 bytes.
Recent
On Tuesday 12 July 2005 14:25, Salama hussein typed:
> I can't connect to Mysql from a remote computer yet I can log in fine
> locally. When I telnet from a remote computer to port 3306, I get a
> response. The response wasn't meaningful but it was a response.
Exact error message?
--
MySQL Gener
I am having trouble with this small bit of sql I am using for a
homepage.
I need to select information on the next two events from two
separate tables; tblevents (which holds event related info), and
tbleventdate (which holds info related to each date, including times and
informatio
I am having trouble with this small bit of sql I am using for a
homepage.
I need to select information on the next two events from two
separate tables; tblevents (which holds event related info), and
tbleventdate (which holds info related to each date, including times and
informatio
On Monday 23 May 2005 20:01, Dayakar wrote:
> Please give me solutions at the earliest as mirgration from oracle to mysql
> is started and i need to meet the solution as soon as possible.
4.1 does not support views. As documented in the online documentation:
"Views (including updatable views) are
On Thursday 19 May 2005 14:36, Bing Du typed:
> > The problem is exactly as the problem says, you're trying to install
> > something
> > that isn't an RPM package. Try:
> >
> > file MySQL-server-5.0.4-0.i386.rpm
> >
> > It'll tell you what the file you've downloaded actually is. Either it's a
> > c
On Friday 13 May 2005 18:21, Gordon wrote:
> If you can add a table structure why not create a SELECTED table with
> REPORT ID and PERSON ID as the 2 field PRIMARY KEY.
>
> Then you could INSERT IGNORE into this table [with no BEGN/COMMIT] and the
> IGNORE would throw away those already selected.
On Friday 13 May 2005 16:19, Eric Bergen typed:
> I agree. It sounds like you could use plain repeatable read isolation
> transactions. If someone else is modifying those rows you get an older
> version from when your transaction was started. No need for skipping
> anything.
In the case of what I
On Friday 13 May 2005 11:34, Ramesh G typed:
> I am using InnoDB only.
> But, it's not skipping locked rows.
Ditto that here.
CREATE TABLE `a` (
`b` int(11) NOT NULL auto_increment,
PRIMARY KEY (`b`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
select * from a;
+---+
| b |
+---+
| 1 |
| 2 |
| 3 |
And no performance diff. Note that you're benchmarks only show a 20M
addition overhead. We're about 60x too slow for these drives so I'm
not
sure what could be going on here :-/
I know of a site that encountered a similar performance issue:
The OS was reading in a lot more data from the disk th
On Wednesday 20 April 2005 16:55, [EMAIL PROTECTED] typed:
> For the small number of records, this query takes a remarkable amount of
> time, so clearly this solution does not scale.
A query that uses keys should not take a long time to run - unless your key
data is not maintained as a key in the
I'm currently evaluating ways to increase our online storage capacity for our
DB engine. The current winner is a massive external SAN/disk array.
However, I'm wondering how MySQL will handle failover when it comes to InnoDB
tablespaces.
The current plan, based on the disk array, is to have ea
On Monday 07 February 2005 07:57, Sue Cram might have typed:
> I'm writing a report listing animals from our shelter and whether they have
> been adopted. I am selecting the animal name field and a field called
> 'adopted' from a table called 'animal'. The values in 'adopted' are
> either: 1 (m
On Friday 04 February 2005 16:03, Winn Johnston might have typed:
> My users have expressed a distinct dislike for point
> and click methods. They would rather use the keyboard
> in the same way a ticket agent does when she is
> looking for a flight :)
You can do this one of two ways.
Give them
On Wednesday 02 February 2005 14:11, Michael Satterwhite might have typed:
> mysqldump backs all of the tables up in alphabetic order, including the
> table create statements. The problem is that if foreign keys exist on
> the tables, the reload will not work unless the backup file is hand
> edited
On Thursday 20 January 2005 13:47, Shahzad, Saleem might have typed:
> Hi,
>
> I am using egroupware and in the calendar on a specific day and event I
> click on the link but MySQL gives me the following error
>
>
>
> Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 =
> 'cale
On Thursday 13 January 2005 12:42, Mads Kristensen might have typed:
> If it is indeed only possible to store 2^16-1 bytes I would like to know
> why this has been implemented in that way (yes, I am always this curious
> ;-)
http://dev.mysql.com/doc/mysql/en/String_type_overview.html
--
MySQL G
On Wednesday 15 December 2004 15:38, Dave Juntgen might have typed:
> Hi!
>
> Could someone please explain to me why the second query below is faster
> then the first query? The only difference between the two is that
> ext_doc_id's value is quoted. Index and column information follow and the
> t
I'm having to run some purges of data to clean up disk space until the new
storage array arrives. I've got the data archived, and the rows deleted from
the table. The only method I know to reclaim the space in the table is to
use myisamchk -r. Is there any other faster method for reclaiming t
Never mind, it was a query optimization issue. Upon the third
interogation of the other admin, he remembered one small setting that he
changed, which just so happened to increase the number of queries
exponentially.
Thanks,
Jonathan Duncan
On Mon, 6 Dec 2004, Jonathan Duncan wrote:
Background
admin said he only edited an e-mail address on someone's account.
Help?
Thank you very much for your time,
Jonathan Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rovements after 5.8.1, especially since
Unicode support is used a lot less than ascii historically. Also, make
sure you have DBI 1.46 and DBD::mysql the newest. -- Darren Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Very good feedback on multiple books. Thank you. So many good choices.
If only I had time to read them all...
Jonathan
>>>Ugo Bellavance <[EMAIL PROTECTED]> 11/23/04 7:46 am >>>
Kieran Kelleher wrote:
>This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks
>after MySQL i
Sasha,
Plugs from authors are interesting, but plugs from readers are what
really sell a book. I will check it out though. Thank you for the
response.
Jonathan
>>>Sasha Pachev <[EMAIL PROTECTED]> 11/19/04 5:36 pm >>>
Jonathan Duncan wrote:
>I have the MySQL
On Monday 22 November 2004 13:10, Dayakar might have typed:
> Hello list,
> I am getting the following error when i am loading data (Tab seperated
> data) into a table which has reference to a primary key table. There is
> data in the primary key table, but still this error is being thrown.
>
> ERR
reviews online for the following two books:
-MySQL, Second Edition by Paul DuBois
-Mastering MySQL 4 by Ian Gilfillan
Any preferences between these two? Any better suggestions for learning
MySQL front and back from a DBA perspective to an end user perspective?
Thanks,
Jonathan Duncan
--
MySQL
On Friday 05 November 2004 15:56, [EMAIL PROTECTED] might have typed:
> Yes, but I want to be able to insert into the column dates in the format
> d-mmm-yy
MySQL has a date format function that you can use to translate the format.
The format in the table is always -mm-dd. Use translation fu
table
Users. Thus, this of course seems to match on just about everything
since there is no actualy record in the Users table to match on.
Is there some way to match on a lack of information?
Thanks,
Jonathan Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Monday 23 August 2004 11:08, Manisha Sathe might have typed:
> Hi,
>
> Here i am again. I can select particular record by using
>
> LIMIT 9,1
>
> But e.g. if i want to delete this record then how shall i do ? I tried to
> use
>
> Delete from Limit 9, 1
Said record is probably keyed in some m
On Friday 20 August 2004 15:58, Boyd E. Hemphill might have typed:
> The quick answer is to save your data as a comma delimited file with no
> headers. (I suggest actually using bang | since your data may contain
> commas.)
A properly comma delimited file will not have problems with commas in the
On Friday 20 August 2004 07:08, [EMAIL PROTECTED] might have typed:
> Is replication of database in MySQL is possible. Actually i want to
> replicate the changes to the database to different servers located at
> different locations.
A tiny bit of legwork would have answered it for you.
http://dev
On Monday 16 August 2004 11:05, Duncan Hill might have typed:
> Had to rebuild my laptop this weekend. Made sure to make a backup copy
> of /var/lib/mysql/*. Loaded on the mysql binary tar (as gentoo doesn't
> have 4.1.3 in portage yet), and copied my data back across.
>
> Ho
Had to rebuild my laptop this weekend. Made sure to make a backup copy
of /var/lib/mysql/*. Loaded on the mysql binary tar (as gentoo doesn't have
4.1.3 in portage yet), and copied my data back across.
However, even with the innodb files in place, the mysql engine is saying
things like:
Didn'
On Tuesday 27 July 2004 16:00, Alexander Newald might have typed:
> Hello,
>
> currently I recive mails from [EMAIL PROTECTED] that say that I have to
> validate my email at Spamcease. Looking at the mail header mail seems to
> come from tgpnexus.com?
>
> Anybody else getting this type of emails?
On Tuesday 27 July 2004 05:31, Daniel Kasak wrote:
> As you probably know, not all software is perfectly supported on x86-64
> under Linux at the moment. This includes glibc, gcc, binutils, etc.
> There are always patches coming in. If you run Gentoo, you have
> *incredibly* painless updates to ALL
1 - 100 of 252 matches
Mail list logo
