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 l.g
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 ga
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 goa
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
that allows me to check for repetitive
>> queries?
>
> likely nobody knows what you 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 co
_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 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/mysql
one item_number and one
> data_value.
>
> 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
tion
>>
>> Those things are what would make it a proper mailing list integration,
>> instead of just another notification tool.
>> <<<<<<<<
>> That is, this list, right? What does it lack (besides readers)?
>
> mail-clients using a readable
acebook.com/pointmade.band
>
>
>
>
>
> --
> 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
it. Little help please:
>>>>
>>>> DELIMITER //
>>>> CREATE PROCEDURE `reset_sortid` (IN category INT(11))
>>>> BEGIN
>>>> DECLARE a INT;
>>>> SET a = 0;
>>>> UPDATE
>>>>
en in query optimization automatically.
> For Example:
> SELECT * FROM Status WHERE 1=1 AND DWProcessed = 0;
>
> 1=1 is detected as a tautology and removed.
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/m
o share it. Excepting only 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
> wrote:
>&g
> 1001,5
>>> 1002,2
>>> 1001,2
>>> 1003,2
>>> 1005,2
>>> 1006,1
>>>
>>> From this I what to get a distinct list of id where the type equals 2
>>> and
>>> 5
>>>
>>> Any ideas ?
>>>
>>
03,2
> 1005,2
> 1006,1
>
> From this I what to get a distinct 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.
>
p me out to solve the issue in 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 by MailScanner, and
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"
>>>>
>>>> So, I got a little furthe
On Mon, November 19, 2012 13:49, Jan Steinman wrote:
>> From: "Mogens Melander"
>>
>> 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
>&g
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.
>
> Art
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:
t; is not NULL, but empty string. Consider those NULL.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
> --
> This message has been scanned for viruses and
> dangerous conte
ach pattern, but it
>> cannot match variation in the separators.
>>
>> It is required that NULLs in the file take the form '\N' or 'NULL',
>> depending on escape-option.
>>
>>
>> --
>> MySQL General Mailing List
>> For list arch
sultset for the information, 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
>>
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
> wrote:
>
>> Or you could
file are same in the table in
>> database
>> of mysql.
>> Please help me out.
>
> Convert the data 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,
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 some
-+
> 1 row in set (0.00 sec)
>
> mysql> update tasks set status= 'H';
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed 1 Warnings: 0
>
> mysql> select status from tasks;
> ++
> | status |
> ++
> | W |
&g
nload.
>>
>> Thank you,
>> Hiromichi
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql
>>
>
>
>
> --
> Baron Schwartz
> Win free M
, September 22, 2009 22:56, Mark Goodge wrote:
> 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: &q
2009 22:35, 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_QUO
the returned value to the variable, or in the name of
> the variable you're printing.
>
> - Rick
>
>
>
> ---- Original Message
>> Date: Tuesday, September 22, 2009 10:02:06 PM +0200
>> From: Mogens Melander
>> To: mysql@lists.m
ame":"Doe"
,"addr1":"Solvej 1"
,"addr2":""
,"zipcode":"1234"
,"city":"Sommerby"
,"phone":"11 22 33 44"
,"mobile":""
,"email":""
,"web":&qu
t;>> > -article_type
>>>> >
>>>> > So i want the user to be able to login and add articles.
>>>> >
>>>> > I then want to be able to view all the articles the user has
>>>> > submitted.
>>>> >
>>
undt wrote:
> 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
7;
)
left join unit u
on u.code=m.code and u.country='dk'
where m.activedk = 'on' and m.olomultidk = 'on'
order by m.code;
==
On Mon, December 8, 2008 22:48, Brent Baisley wrote:
> On Mon, Dec 8, 2
,
PRIMARY KEY (`code`,`country`),
KEY `code` (`code`),
KEY `country` (`country`)
) ENGINE=InnoDB DEFAULT 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 Mailin
inal passwords match (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:
>>
-
uld suffice for short strings.
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
uot; priveleges
to "B"'s databases, to do stuff on them.
It's 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:
>>
t; Thanks for trying so hard, Carlos!
>> Lillian
>>
>
>
> --
> 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
&g
=1ONXIC
>
> --
> 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 t
m, 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 870 133 224
--
This message ha
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 keep
;
>
>
> --
> 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 b
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
>>>> ta
data,
> and
> then load the data separately.
>
> Beware: replication from 4.1.x to 5.0.40 will fail. The MySQL changelog
> didn't
> list it as an incompatible change, but there is some bug that got fixed
> around
> 5.0.38 (sorry, I forget what it was and can't find i
-
>
>
>
>
> --
> 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
&
; For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
s 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.
--
gt; can u give a select example with JOIN 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://
x27;', '', '' ,,,
555, 'X','X', '' ,,,
table map(id, field)
1, 'field_1'
5, 'field_2'
9, 'field_3'
....
86, 'field_51'
The exercise is: replace 'X' with map.id in main.
main.code and map.id
e>=X and date<=Y
> date>X and date<=Y
>
> and so... didn't find a function to specify ranges of dates and the LESS
> THAN/EQUAL operator does not include the last day, so my reports with "<="
> are done by adding one day but don't like to use it this way si
gt;
> 2007/6/19, Olexandr Melnyk <[EMAIL PROTECTED]>:
>>
>> select id, name, 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
.. but not sure.
>
> Can anyone recommend a good way to store this data?
>
> Thanks!
>
> -Matt
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> --
>
+
> | COUNT(*) |
> +--+
> |0 |
> +--+
> SELECT COUNT(*) FROM t WHERE d = '2007-06-15';
> +--+
> | COUNT(*) |
> +--+
> |1 |
> +--+
>
>
>
>
> --
> MySQL General Mailing List
> For list
he cost of that
> particular 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
te", formerly called "gamma").
>
> When in turn this one has not shown any severe problems, 5.1 will be
> called production level (aka "GA").
>
> For these status changes there are no dates, and any individual guesses
> are based on assumptions which cannot
to 4.1.x -- 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:
>&
130
> Photo Craft Imaging . 3550 Arapahoe Ave. #6
> http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists
ue uddin Ahmed Farooqui
>> > (C++/C# Developer, IT Consultant)
>> > A revolution is about to begin.
>> > A world is about to change.
>> > And you and me are "the initiator".
>> >
>>
>
> --
> This message has be
ew user specific to localhost :D
>
> Thanks for your comments
>
> --
> 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
> --
> 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 OpenProtect(http://www.openprotect.com), and i
'...'
> GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'myuser'@'%'
>
> but this time am able to connect. What can be wrong? or do I need to add
> both '%' and 'localhost' hosts?
> **
>
> --
> MySQL General Mailing
mysqldump?
>>>
>
> Ok, but for innodb?
>
Well, you might be able to gain 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.openprotec
://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
too :)
Well, doing encryption in user-interface (PHP mcrypt) using a password
not stored in app. or db would hide information pretty good.
--
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:
; 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
Moge
= '5' AND subcategory = '1' 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[&#
TECTED]
>
>
> --
> 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
dangero
(3306, 3307 etc) is it possible and how?
> 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.
>
>
-> TO 'custom'@'server.domain'
-> IDENTIFIED BY 'obscure';
The three accounts can be used as follows:
The first account can access the bankaccount database, but only from the
local host.
The second account can access the expenses database, b
m.
>
>
> --
> 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 OpenProtect(http://www.openprotect.com
>> >
>> >
>>
>>
>> --
>> - michael dykman
>> - [EMAIL PROTECTED]
>>
>> - All models are wrong. Some models are useful.
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsub
and
> Server-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
his 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:http://lists.mysql.com/[EMAI
up.
>
> Here's the challenge, given a text 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
ou have to do it at a higher level. What
> aprroach would people suggest?
> Perhaps another table with two fields - field_name and field_regex?
And, what would you have mysql do if a user failed to enter fx. valid date ?
Maybe you'd be better off, handling input validation in the us
/[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 scanned for
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
input
> "show tables" gave me an output.
>
> 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
l
> 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
-
ect. The SQL queries I gave are correct, because they work
>> when I give them 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.open
te" type.Then I can't get
> the correct result.
>
> How can I do 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
ist 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
Gerald L. Clark
>> Supplier Systems Corporation
>>
>>
>
> --
> 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 a
'text/html'
'teddybears.com', 'image/png'
'teddybears.com', 'text/html'
SELECT domain, count(*) `all`,
sum(case when mime = 'text/html' then 1 else 0 end) html,
sum(case when mime like 'image/%' then 1 else 0 end) image
FROM
; table1.value with the table2.value where the id 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
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 databa
#x27;m not sure that such a beast exists, other than stream editors
> such as sed or perl. Can 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 c
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
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.c
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,
&g
).
--
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
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 hav
, 3 rows affected (0.02 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
mysql> select * 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
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 i
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
ED BY 'char']
]
[LINES
[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:
ter
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
x27;test','test1'),'no','yes');
-> 'no'
IFNULL(expr1,expr2)
If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2.
IFNULL() returns a numeric or string value, depending on the context in
which it is used.
mysql> SELECT 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 th
1 - 100 of 103 matches
Mail list logo
