Guys,
I think I remember this from way back.
You could ask for a lock, and get an OK if it is safe.
Something like, if there is pending transactions, on your target tables,
you would get a NO.
But then again. I could be wrong, and Shawn is the authority on this.
On 2018-08-18 23:59, shawn
You need to GROUP BY those fields NOT in the aggregate function. Like:
SELECT f.id,f.name,sum(p.price)
FROM fruit f
left join purchase p on f.id = p.fruit
where p.price is not null
group by f.id,f.name;
1, 'Apples', 2
2, 'Grapes', 6.5
4, 'Kiwis', 4
On 2015-10-23 04:15, Don Wieland wrote:
Hi
When I read the OP I was thinking: This is one for Reindl. And here we
go.
When dealing with data of this specific kind, you most definitely
would want a date reference. A very small computer will be able to
handle
mane years of all kinds of weird sports statistics.
You need to define the
Maybe not the most optimal, but (probably) the most simple:
SELECT * FROM fruit
where id not in (select fruit from purchase
where customer=1);
1, 'Apples'
3, 'Oranges'
On 2015-09-30 00:01, Richard Reina wrote:
If I have three simple tables:
mysql> select * from customer;
+++
| ID
are talking about
http://www.catb.org/esr/faqs/smart-questions.html#beprecise
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http
item has several values, there are several records with the same
item_number and a different data_value.
What is the command to select all the records where an item_number has
the data 1 but not the data 2?
Thanks in advance,
Olivier
--
Mogens Melander
+66 8701 33224
--
This message
.
If one item has several values, there are several records with the same
item_number and a different data_value.
What is the command to select all the records where an item_number has
the data 1 but not the data 2?
Thanks in advance,
Olivier
--
Mogens Melander
+66 8701 33224
.
That is, this list, right? What does it lack (besides readers)?
mail-clients using a readable quoting, your's do not :-)
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
by MailScanner, and is
believed to be clean.
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Sales Engineer
SkySQL | t: +46 708-608-121 | Skype: drdatabase
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous
been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives
list of id where the type equals 2 and
5
Any ideas ?
Neil
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner
for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http
the working
assumption that he is using a MySql version released in this century,
I don't know how this would have informed my analysis or response.
- michael dykman
On Thu, Nov 22, 2012 at 4:00 PM, Mogens Melander mog...@fumlersoft.dk
wrote:
On Thu, November 22, 2012 15:45, Neil Tompkins wrote
On Mon, November 19, 2012 17:02, Shawn Green wrote:
On 11/19/2012 9:02 AM, Mogens Melander wrote:
On Mon, November 19, 2012 13:49, Jan Steinman wrote:
From: Mogens Melander mog...@fumlersoft.dk
So, I got a little further with my problem. I found an article
on:
http://stackoverflow.com
On Mon, November 19, 2012 13:49, Jan Steinman wrote:
From: Mogens Melander mog...@fumlersoft.dk
So, I got a little further with my problem. I found an article
on:
http://stackoverflow.com/questions/3122424/dynamic-mysql-query-view-for-crosstab
Describing how to do the dynamic generation
On Wed, November 14, 2012 09:23, Mogens Melander wrote:
Guru's
I've been tasked with creating a report with information about
which images are related to each active article. The images
are descriptive icons visualizing different properties.
Articles can be active 'on' or not '', and only
Did you change the target column to varchar before import ?
On Wed, November 14, 2012 10:23, sagar bs wrote:
tried to import data as text, but its showing Operation failed with
exitcode 1
On Wed, Nov 14, 2012 at 1:12 PM, Mogens Melander
mog...@fumlersoft.dkwrote:
Or you could import
, but the
layout is best done in a application language, such as PHP.
-Original Message-
From: Mogens Melander [mailto:mog...@fumlersoft.dk]
Sent: Wednesday, November 14, 2012 12:23 AM
To: mysql@lists.mysql.com
Subject: Dynamic crosstab got me lost.
Guru's
I've been tasked with creating
://lists.mysql.com/mysql
--
Regards
SAGAR B S
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed
://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content
6:40 AM: Sorry, didn't mean to be rude. It's in there.
On Thu, November 15, 2012 00:23, Mogens Melander wrote:
Dude, which part of RTFM did yoy miss?
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
On Wed, November 14, 2012 13:57, sagar bs wrote:
Hi,
There are four
in your CSV file into the format you need. So many
ways to do that, e.g.: bring in into excel and change the column's
format, use sed, use python, use vi,
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed
On Mon, October 29, 2012 18:11, walter harms wrote:
Am 29.10.2012 14:55, schrieb Reindl Harald:
Am 29.10.2012 14:54, schrieb walter harms:
Am 29.10.2012 13:17, schrieb Reindl Harald:
Am 29.10.2012 12:48, schrieb walter harms:
hi list,
does someone know under what circumstances
';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed 1 Warnings: 0
mysql select status from tasks;
++
| status |
++
| W |
++
1 row in set (0.00 sec)
whoops
bill
Maybe a SHOW CREATE TABLE `tasks`\g could shed some light.
--
Mogens Melander
+66
archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Baron Schwartz
Win free MySQL conference tickets! http://goo.gl/mvZ4W
--
Later
Mogens Melander
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed
MySQL console/query-browser:
1
, 2
, 'Long description' Correct data
, 'Jane'
, 'Doe'
, 'Solvej 1'
, ''
, '1234'
, 'Sommerby'
, '11 22 33 44'
, ''
, ''
, ''
, -7500.00
--
Later
Mogens Melander
--
This message has been scanned for viruses and
dangerous content by MailScanner
.
- Rick
Original Message
Date: Tuesday, September 22, 2009 10:02:06 PM +0200
From: Mogens Melander mog...@fumlersoft.dk
To: mysql@lists.mysql.com
Subject: Wierd PHP/MySQL result
Hi guys
I'm getting rather confused on this thing.
Results returned from mysql
, Mogens Melander wrote:
Well, no typos.
The relevant piece of code:
if (! $cust = mysql_fetch_assoc($res))
{
echo {success: false, errors: { reason: 'Fetch Customer failed: .
htmlspecialchars(mysql_error(),ENT_QUOTES) .
br . htmlspecialchars($sql,ENT_QUOTES
General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=mog...@fumlersoft.dk
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
at 7:14 AM, Mogens Melander [EMAIL PROTECTED] wrote:
Hi list
I have this statement that really need optimizing. The result is
about 5500 rows, and it runs for about 3-5 minutes. If i do the
same in a PHP script (outer loop, inner loop) it run in 20 sec.
The idea is that data in tdata might
:
On Dienstag, 9. Dezember 2008, Mogens Melander wrote:
| I can't figure out why the UNION solution is missing 4 rows. I'll include
| the 3 complete statements, so maybe someone smarter than me can figure out
| why there's a difference in the result.
Without having studied your query, my guess
CHARSET=latin1;
--
Later
Mogens Melander
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
/QUOTE
These are all functions you use in your sql statement, so yes. They can be
used in MS Access.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General
(the odds against are huge!)
Well, i got the impression that OP wanted to retrieve the cleartext
string, but i could be wrong.
On Saturday 18 August 2007 16:19, Mogens Melander wrote:
MD5() is not an encryption function. The MySQL manual states:
--
Later
Mogens Melander
+45 40 85 71 38
+66 870
for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list
On Mon, July 23, 2007 10:19, Carlo Sogono wrote:
Is there a way for mysql to login as an administrator and su to a
normal user?
What I'd like to achieve is a way to log in to our clients' accounts (we
are a web-hosting company) without having to use their passwords. Having
to su keeps
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66
]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General
content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http
probably too late for me to make sense, so i leave it here for now.
On Tue, July 24, 2007 04:54, Carlo Sogono wrote:
Mogens Melander wrote:
On Mon, July 23, 2007 10:19, Carlo Sogono wrote:
Is there a way for mysql to login as an administrator and su to a
normal user?
What I'd like to achieve
On Tue, July 17, 2007 13:31, Baron Schwartz wrote:
Mogens Melander wrote:
On Tue, July 17, 2007 04:29, Baron Schwartz wrote:
B. Keith Murphy wrote:
The problem is that I am realizing that this dump/import is going to
take
hours and in some cases days. I am looking for any way to speed
5.0.38 (sorry, I forget what it was and can't find it now). When the
slave
checks the master version, it throws an error and stops saying I refuse
because
of this bug.
Baron
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses
:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content
models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens
on three tables above?
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
'
86, 'field_51'
The exercise is: replace 'X' with map.id in main.map.field
main.code and map.id are primary keys, all other are varchar.
Hmm, did that make any sense?
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content
://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner
content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http
, age, null as height
from table1
union
select id, name, null as age, height
from table2
I believe that was the right answer to the question.
( there might be other answers ;^)
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous
product at that particular time?
One method could be to store product(id, description, price) and
orderitem(id,orderid,productid,quantity,price)
This way your orders will reflect the item-price at the time the
order was created.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
, and any individual guesses
are based on assumptions which cannot be proven (like known rates of bug
inflow and fixing).
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean
-- before that, they say it's no longer supported. I
couldn't find a way to get it, anyway.
Mogens Melander wrote:
If i'm not mistaken, the mysql site, also has older versions.
On Sun, June 3, 2007 18:31, Baron Schwartz wrote:
Hi,
Subasta.pl - Darmowe Aukcje Internetowe wrote:
Hello
://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
MySQL General Mailing List
For list archives
/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been
]
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
some speed, fiddeling with buffer sizes.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
MySQL General Mailing List
For list archives
), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
file, but is
there anyway around that other than setting the password as blank?
How about creating a mysql account with only read / connect from
localhost permissions on?
Making a no-password account, or storing password in file, can't
be that far apart, security wise :)
--
Later
Mogens
' AND
members_id= '8' ORDER BY lastname
The PHP variant could look like (prev id):
SELECT id FROM contacts
WHERE category = '5'
AND subcategory = '1'
AND members_id= '8'
AND lastname $_POST['lastname']
ORDER BY lastname
LIMIT 1;
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
MySQL General Mailing
scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com
the bankaccount database, but only from the
local host.
The second account can access the expenses database, but only from the
host whitehouse.gov.
The third account can access the customer database, but only from the host
server.domain.
Mogens Melander wrote:
GRANT CREATE,INSERT,DELETE,UPDATE,SELECT
?
Thanks again,
CPK
Keep your Environment clean and green.
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been
to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=1
--
This message has been scanned for viruses and dangerous content by
OpenProtect(http://www.openprotect.com), and is believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870
-2.
Steve
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 1:35 PM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: RE: secure port 3306
On Mon, May 7, 2007 17:40, Steven Buehler wrote:
The thing is...I need to securely do
field search box, someone enters:
Sony 20 TV
How do I search for that, not knowing which fields are which?
For example, they could have also entered:
20 Sony TV
How about:
select soundex('Sony 20 TV' ),soundex('20 Sony TV');
'S531', 'S531'
--
Later
Mogens Melander
+45 40 85
.
What is missing, what's the trick. Help me Y'all.
You could try something like:
mysql -u xxx -pyyy -e 'select * from dbname;'
mysql -u xxx -pyyy -e 'select * from dbname.tblname;'
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses
On Wed, May 2, 2007 08:55, Mogens Melander wrote:
On Tue, May 1, 2007 22:15, Brown, Charles wrote:
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me
]
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http
at the mysql prompt.
What error message do you get ?
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
MySQL General Mailing List
For list archives
been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com
this?Thanks.
That would be
select date(updatetime) ut, count(*) dd
from items group by ut;
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean
]
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http
General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens
/%' then 1 else 0 end) image
FROM tablea
GROUP BY domain;
domain all html image
-
'google.com', 6, 3, 3
'teddybears.com', 2, 1, 1
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses
are identical.
update table1 t1, table2 t2 set t1.value=t2.value where t1.id=t2.id;
But I cannot find any UPDATE query that can do this in a single operation.
Anyone that can give me a suggestion?
I'm using MySQL 4.1.8
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message
the changes you need to make be done with stream
editing (simple changes like changing a word or two are very easy with
stream
editor)?
Also, replace from your mysql-installation could be used,if
you only need to replace a-string with b-string :)
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133
Something like this should do the trick:
~#replace mthosp newname org-file.sql new-file.sql
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Thu, April 19, 2007 16:53, molemenacer wrote:
I am trying to change all the names of the database from mthosp to another
name
Arg, come on, really.
where t.created = date(now()));
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Mon, April 16, 2007 15:18, Jay Blanchard wrote:
[snip]
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
[/snip
Argh, that was not the one i wanted to send :)
This is the one:
select s.* from store s
where s.id not in
(select t.storeid from trans t
where t.created date(now()) - interval 1 day);
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Tue, April 17, 2007 09:20
It looks to me that local-infile is a command-line parameter
to mysql client
mysql --local-infile -u user dbname
I've not been able to find this option elsewhere.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Mon, April 16, 2007 12:14, Mark van Herpen wrote:
Hi,
I want
a
REPLACE statement makes no sense. It becomes equivalent to INSERT, because
there is no index to be used to determine whether a new row duplicates
another.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Fri, April 13, 2007 08:14, Douglas Pearson wrote:
Apologies if this is a dumb
* from abc;
++-+-+
| a | b | c |
++-+-+
| A1 | B1 | C1 |
| A2 | B2 | C2 |
| A3 | B3 | C3 |
++-+-+
3 rows in set (0.00 sec)
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Fri, April 13, 2007 09:39, Thufir wrote:
Mogens Melander mogens
How about this:
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Sat, April 14, 2007 00:22, Jay Blanchard wrote:
Good day gurus and gurettes!
I have a table
).
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Fri, April 13, 2007 22:18, Denise Wilson wrote:
Hi. I'm brand new at this so I'm looking for a little help.
I need to have two difference levels of access to a mysql database that I
am
developing for our librarians to use
Hmmm, your LINES TERMINATED BY '/r/n';
should be:
LINES TERMINATED BY '\r\n';
if the abc.txt file was generated on windows. If it
was made on *nix/linux, it should be:
LINES TERMINATED BY '\n';
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Thu, April 12, 2007 09:58, Thufir
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Wed, April 11, 2007 21:11, Richard wrote:
Hello, I've got a problem with mysql 5 on my debian server.
I've got a forum on this server and untill the database reached about 60
Mo I could dump the database with either phpmyadmin
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...)]
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Thu, April 12, 2007 02:37, Thufir wrote:
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED
it is used.
mysql SELECT IFNULL(1,0);
- 1
mysql SELECT IFNULL(NULL,10);
- 10
mysql SELECT IFNULL(1/0,10);
- 10
mysql SELECT IFNULL(1/0,'yes');
- 'yes'
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Sat, April 7, 2007 20:19, John Kopanas wrote:
I
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Fri, April 6, 2007 10:16, Christophe Gregoir wrote:
I have to admit, Google doesn't provide much information.
Let's take a closer look and see if we can't figure out ourselves what
that value means.
Here is the output of `mysqladmin status` on my
and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean
1 - 100 of 102 matches
Mail list logo
