Is 9640 a word by itself? A full-text search wouldn't find abc9640,
you'd need to use LIKE for that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Don O'Neil [mailto:[EMAIL
How about the UUID() function. As I recall, the differences between a UUID
and Microsoft's GUID are trivial.
INSERT INTO Inv_Id SET id = UUID();
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original
I don't now your application at all. That being said, if you are running a
single-threaded application I don't see how MySQL could have more than one
thread running on one CPU.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
!br/\n);
This might be in the including script, if any, since the error message shows
a suggestively-named file name.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: List [mailto
into your spreadsheet (adjusting the row numbers
accordingly) or directly into your text file, and redirect the input file
for mysql on the command line.
Once you get the hang of it, this is all simpler than it sounds.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave
text
values with an extra pair of single quotes:
... SET col1 = ', 'Sheet1'!A1, ', ...)
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Roberto William Aranda-W Roman
Can't you just keep track of which page you are on, and multiply by 20
(except for the last page)? I must be missing something.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From
I'm still confused, are you saying that you want to know what page a team
would be on if you did a listing?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: news [mailto:[EMAIL
it
until it was shut down.
UNIX don't care...
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 18, 2006 2:16 PM
I wonder if this is a permissions problem.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: mdpeters [mailto:[EMAIL PROTECTED]
Sent: Monday, October 16, 2006 9:19 PM
To: Dan
I would think that with so few possible values for all but the ip field,
indexing the other fields would accomplish nothing. In fact, I'd be
surprised if the optimizer didn't realize that and do a sequential read
anyways.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave
I didn't think of that (combinations). You are probably right. Due to my
background, I tend not to think a lot about multi-column indices.
I would think that you want field with the most possible values first, then
the next, etc. Is that what you were thinking?
Regards,
Jerry Schwartz
Global
That's what Dan (and I) meant.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 17, 2006 1:28 PM
To: mysql
You might want to check for an empty string () rather than null. From what
I can tell, HTML forms don't give you NULL values if you leave fields empty,
they return . Unless your programs internally convert empty strings to
NULL, you won't find NULL in your table.
Regards,
Jerry Schwartz
Global
.
I can't speak for OpenOffice.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ferindo Middleton [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 14, 2006 9:40 PM
To: mysql
This may be too obvious, but what is in that text field?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ted Johnson [mailto:[EMAIL PROTECTED]
Sent: Monday, October 16, 2006 3
Based on my experience, that wouldn't quite work. You'd need to preface each
word with a plus sign:
+olive +oil*
and it would return records regardless of the order in which the two words
appear, nor how far apart they are. That might be desirable, or it might
not.
Regards,
Jerry Schwartz
gave me the inverse of what I wanted. This shouldn't be impossible to do,
Access has a find duplicates wizard; but come to think of it, that lists
both records and I never tried to limit it to just the older.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT
.
Thanks for your help.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 12, 2006 2:14 PM
To: Jerry Schwartz
in the topic_index table and quickly
pull all of the corresponding records for the different languages from
topic_detail. You can also easily find all topics that have entries in a
particular language, or that do not have entries in a particular language,
etc.
Regards,
Jerry Schwartz
Global
It probably uses a single lock to handle a JOIN, and two locks to handle a
sub-SELECT. I doubt that it helps, but if I'm right it will change what you
see when you poking around.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
I'm a newbie, for sure, but can't you use OR to accomplish this?
SELECT * FROM release_hack WHERE BID IN (5749, 7355, 6454)
OR oBID IN (5749, 7355, 6454);
Could it be as simple as I am?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
, and
not about retrievals, then don't index anything. A SELECT will have to
serially access the table, while a write will have to shuffle the indices.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original
The default engine is configurable: default-storage-engine=INNODB in my.ini.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent
We have multiple Western languages in our UTF-8 data base, without a
problem. Right now I'm working on adding Chinese data, but my major problem
is reading back what's in there to find out if it went in correctly :(
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave
client.
Now I'm chasing that hare.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Michael Monaghan [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 9:58 AM
To: Jerry
then export to a tab-separated file.
Ugly, but as I said my data comes in all kinds of nasty formats, such as web
pages.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: [EMAIL
Your first query returns a scalar (single value), right? You can put its
value into a variable, and use that in the second query. It's not exactly
what you wanted, but it will work without external programming.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave
Have you dumped out your variables to make sure none of them is a
zero-length string? That would surely cause your problem.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ed
of
all writes to the data bases. The reads were distributed simply by having
the clients open different copies of the data base.
Ugly, but it works.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original
I don't think you can do this with mysqlimport. It wouldn't be hard to do
with Perl or PHP, though, and that could be automated any way you want with
a shell script.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
records in tableb.
Unless I'm mistaken
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
André Hänsel skrev:
Hello list,
I have two tables:
Table A
a_id name
1a
2b
3c
Table B
b_id a_id flag name
1
Have you tried using parentheses around your last line?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: molemenacer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006
This may be the blind leading the one-eyed, but wouldn't
SELECT FieldID FROM TableA, TableB WHERE TableA.FieldID = TableB.FieldID AND
TableA.Enabled != TableB.Enabled;
Work?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
I'm not sure I understand where the other field data (that you say you have
to enter manually) is coming from, but what I often do when confronted with
data that needs to be massaged before entry is put it in an Excel
spreadsheet and use a formula to build the MySQL statements.
Regards,
Jerry
FULLTEXT can only be used with ISAM tables.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Lakshmi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 3:29 AM
To: mysql
I am receiving some messages an extra time, also. It seems that something is
wrong with the list server.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Nico Sabbi [mailto:[EMAIL
Overnight (Monday night US time) I was receiving some duplicate messages
(not ones addressed to me specifically). Has this been fixed?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
that would work for characters that have no Latin equivalent.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Charlie Schaubmair [mailto:[EMAIL PROTECTED]
Sent: Monday, September 11
of the silent conversions - varchar(256) would be
converted to text, but not varchar(255). What's going on?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
You are absolutely right. The entire data base is UTF-8.
That explains why the examples I found were not in English.
Thanks.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From
for any reasonable amount, but now you're
back to the rounding issue caused by the fact that .01 is not exactly
representable as a binary fraction.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original
their loops with x + 1
rather than = x. That gets past the problem, but if you are adding
together many values the final answer may be wrong.
Look at 23.1 of the manual.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
I don't see the form.
Unless one of your included files sets the values of your variables, this
code will insert a row of empty strings every time it executes.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Automatically? Don't know. I did it by hand using Dia, a free alternative to
MS Visio. It was tedious.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: news [mailto:[EMAIL
of the farm-land areas cover a lot of territory with
very few zip codes.
I don't know how the mapping software does it, really. They must have big
tables of some sort.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
The only reason that I can think of is to balance the load among systems.
This might be because you want to split the load between the data base
server and the application, or because you want to run the application on
more than one server.
Regards,
Jerry Schwartz
Global Information Incorporated
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.8341
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 PROTECTED
= mysql_fetch_row($result); /* DELETE THIS ROW */
while ($row=mysql_fetch_row($result)){
By the way, I think I read that using WHERE is more efficient than HAVE.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
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: 860.674.8341
One
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
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.8796 / FAX: 860.674.8341
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
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: Tuesday, August 22
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.8796 / FAX
?
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]
I have 290 records in the database with backslashes. I want to remove the
backslashes. Why the query below doesn't remove backslashes?
update name set first_name = REPLACE(first_name,'','') where first_name
like '%%';
I have sudo access to Linux box. How to start mysql 4.0.14.
TH
How to reset mysql password to mysql?
mysql -u root
ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Jerry Swanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 November 2005 12:11 PM
To: mysql@lists.mysql.com
Subject: Reset root password to mysql
Both Linux computers.
On 11/21/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
You have not specified what operating system you're using. MySQL manual
has some notes for Windows:
http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html
Jerry Swanson wrote:
How to create
How to create ssh tunnel for Mysql?
TH
How to write the query?
table1: order (order can have more than 1 item)
table2: item (has order_id).
table3: item_status (has item_status_id and item_id)
table4: status (has item_status_id). Status can be 'complete', 'pending'.
I need to get all orders that have ONLY completed items.
Examples:
if
and c.item_status_id = d.item_status_id
where d.status = 'completed'
It isn´t tunned but I think that it works for that you want
-Mensaje original-
De: Jerry Swanson [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 10 de Noviembre de 2005 06:23 a.m.
Para: mysql@lists.mysql.com
If you have auto_incremnt id in the table you can do the following:
delete from table a where id start_id and id = end_id
Or you can delete by timestamp.
delete from table a where date between 'start_date' and 'end_date'.
On 11/6/05, Brian Dunning [EMAIL PROTECTED] wrote:
I'd like to delete
What is the difference between these two fields?
Both fields hold number 5, but for some query marked_id field gives result.
marked_id | int(11) | | | 0 |
id | int(11) | YES | | NULL |
Where you can see difference between these fields?
TH
Why when I do select from database and try to compare float field with float
number, I have no results
amount --- type float
select * from price where amount = 3.45 // doesn't work
select * from price where amount = '3.45' //doesn't work
select * from price where amoun like '3.45' //work
My
I have field in database type float. When I insert number like 12345.27 ,
number is inserted 12345.3
Why it happened?
, but it appears more likely the documentation is wrong.
~jerry
On Fri, 5 Aug 2005, Gleb Paharenko wrote:
Hello.
I think these lines from sql/mysqld.cc from 4.1.13 distribution shows
that --log-long-format doesn't affect the behavior of MySQL:
{log-long-format, '0',
Log some extra information
-queries-not-using-indexes option is available for the purpose of
logging queries that do not use indexes to the slow query log.
I'm using 4.1.13, however, I don't see username or host information for
binary logs, just slow query logs. Am I missing something?
Jerry Bonner
Systems Engineer
CP
I have query that pulls data between to dates. How to group the data by month?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to make this work?
field like '%DATA_FORMAT(now(), '%m%d%y') %'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I want to install MySQL 4 on Fedora Core 2.
Questions:
#1. Do I need to uninstall MySQL 3 from the server first?
#2. Where I can get source for MySQL 4?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Column type is username varchar(100).
When I do select from database:
select * from user where username='John'; //returns one row
select * from user where username='john'; //returns one row
The records in the database has username 'John'.
Why it isn't case sensitive? 'John and
Does Mysql 4 supports views?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
decimal(6,2)
On 5/18/05, Philippe Poelvoorde [EMAIL PROTECTED] wrote:
Jerry Swanson wrote:
I need to change format from varchar(10) to decimal.
When I alter the table the data is trimmed.
What I'm doing wrrong?
TH
ALTER TABLE your_table MODIFY your_column double NOT NULL
I need to change format from varchar(10) to decimal.
When I alter the table the data is trimmed.
What I'm doing wrrong?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to select 5 records(including username, first_name, last_name,
contact) for each user in the database?
table user(
id,
username,
first_name,
last_name
)
contact(
id
id_user //id from user table
name
)
--
MySQL General Mailing List
For
I need 5 records per user.
On 5/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
try this,
select username, first_name,last_name, name as contact
from user,contact
where user.id=contact.user_id
order by username;
Mathias
Selon Jerry Swanson [EMAIL PROTECTED]:
How to select
query runs for 5 min... kill query id.
On 12 May 2005 00:29:56 +0200, Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Eric Jensen [EMAIL PROTECTED] writes:
So you want 5 contacts for every user? Try this:
SELECT COUNT(c.id) AS count, u.username, u.first_name,
I have field varchar(20) that stores phone numbers. Phone number can
be in different format. So I need only digits from the field. How I
can do such replacement?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
How to update randomly field date of datetime? I need to update
randomly on 300 records
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I want to get everything from user than if record exist in admin so
user has admin(administrator) in table user with user.id =
admin.admin_id, so I need to get 'admin' first_name and last_name
If there is no record in table admin with adin.user_id = user.id ,
than I need at least all records from
I want to upgrade mysql 3 to mysql 4.
Operating System is Fedore Core 2. Is there any package dependency?
How to remove mysql3 and install mysql 4?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:01:05 +, Jerry Swanson [EMAIL PROTECTED] wrote:
I have two dates (start_date, end_date). Datediff() function returns
difference in days.
I need the difference but not including Satuday and Sunday.
Any ideas?
C:\Program Files\MySQL\MySQL Server 4.1\binmysql -utest -ptest test
I have two dates (start_date, end_date). Datediff() function returns
difference in days.
I need the difference but not including Satuday and Sunday.
Any ideas?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
How to select datetime using UNIX_TIMESTAMP excluding Saturday and Sunday?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does binary logs are avaialbe in Mysql 4 or only in Mysql 5?
Thanks
On Thu, 10 Feb 2005 10:28:56 +1100, Daniel Kasak
[EMAIL PROTECTED] wrote:
Jerry Swanson wrote:
Is it possible to do daily incremental backups on mysql?
Thanks
Yes.
mysqldump will give you a starting point
Is it possible to do daily incremental backups on mysql?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm interesting to know what is the best way to select last inserted record.
This can do it ORDER BY id desc limit 5 .. but ..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does mysql stores queries? If so where?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is what I was looking for. Why the query is call cross-tab?
TH
On Thu, 13 Jan 2005 02:09:45 +, Ian Sales [EMAIL PROTECTED] wrote:
Jerry Swanson wrote:
| Field| Type
| Null | Key | Default | Extra
What query suppose to be faster? Jan or Dave?
Jan Solution:
SELECT
date,
SUM(IF(CONCAT(status,id) LIKE 'received%',1,0)) as received,
SUM(IF(CONCAT(status,id) LIKE 'send%',1,0)) as send,
SUM(IF(CONCAT(status,id) LIKE 'cancelled%',1,0)) as cancelled
FROM
account
GROUP BY date;
On Wed, 12 Jan
Database Administrator
Unimin Corporation - Spruce Pine
Jerry Swanson [EMAIL PROTECTED] wrote on 01/13/2005 07:56:18 AM:
What query suppose to be faster? Jan or Dave?
Jan Solution:
SELECT
date,
SUM(IF(CONCAT(status,id) LIKE 'received%',1,0)) as received,
SUM(IF(CONCAT(status,id
Can subquery return more than one column in Mysql 4.1.7?
SELECT (select user.last_name, user.first_name from actor where
user.id=6) as last_name, first_name
(select count(*) from account where account.status = 'progress') as
progress_count,
ERROR 1241 (21000): Operand should contain 1
| Field| Type
| Null | Key | Default | Extra |
+--+--+--+-+-++
| id | int(10)
I upgraded mysql mysql-3.23.58-1 to mysql4.1
In mysql-3.23 ( I have this field)
password | varbinary(45) | YES | | NULL
|
I inserted data into this field as password('pass').
I have php script that checks if login valid. mysql-3.23 and
mysql-4.1 have identical
I need to make query that adds numbers. The fields are varchar format
so I have some value 12121 and some values 121212,121212.
I think I need string replace function that replace comma. What
function can do this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
This is my query
select id, status from sale where user_id = 1 GROUP BY id;
I need to know how many rows or how many entries this query returns. I
tried to use count and sum. But the result is wrong.
I want to be able to make select and know how many rows this query
returns. Now, I use
601 - 700 of 846 matches
Mail list logo
