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.com/mysql
To unsubscribe
.
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 that queries a
mysql database
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
and
the 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 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.
Does
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 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.
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 surrendered.
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 way to
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
a
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 mysqldump -
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 need to detect if the
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?
--
Duncan Hutty
System Administrator, ECE
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 that
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:
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.
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
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 valuable
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 I
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. Both
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 client
tool. It took 10 seconds for both
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 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 pain
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 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 are
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 that
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 General Mailing List
For list archives: http
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
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
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
mysql client
=mysql+slow+queryie=UTF-8oe=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: http://lists.mysql.com/mysql
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 have:
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 file system
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 affected (0.27 sec)
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.
I
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
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 speed up
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-configuration.html
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 database-name -u user-name
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
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
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 !
machine, os, target, libraries (multiple lines)
System: Linux localhost.localdomain 2.6.9-10.2.aur.2 #1 Thu Feb 10
04:34:27 EST 2005 i686
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!) and linux is
seeing an Athlon 32
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 find
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
make
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 to
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
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
On Wednesday 07 December 2005 15:29, Shaun wrote:
SELECT Firstname FROM Users;
Matthew
a href=index.php?action=view_userfirstname=MatthewMatthew/a
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.
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
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 Scott, we are using MySQL v.4.1.12. Table type is
MyISAM and following lines are inside my.cnf file:
$ locate
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
- 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, November 07, 2005 1:22 AM
*Subject:* Re: Evaluating text as an expression
Thanks.
I see
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
comments interspersed below.
Rhino
- Original Message -
From: Duncan Miller [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 result of
evaluating
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 is next to
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
we're starting to encounter quite a few
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 General
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
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
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
corrupted rpm,
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 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 |
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'm
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
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
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
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 to
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 =
'calendar'
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
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
table
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
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]
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
, 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
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.
ERROR
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 first edition book by Paul. Still
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
the 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 table name Limit 9, 1
Said record is probably keyed in some
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.
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
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:
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.
However, even
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?
Yes,
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 249 matches
Mail list logo