,
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
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
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
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.
>>>> >
>>
ame":"Doe"
,"addr1":"Solvej 1"
,"addr2":""
,"zipcode":"1234"
,"city":"Sommerby"
,"phone":"11 22 33 44"
,"mobile":""
,"email":""
,"web":&qu
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
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
, 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
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
-+
> 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
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
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,
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
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
>>
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
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
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:
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
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 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
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
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.
>
> 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 ?
>>>
>>
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
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
it. Little help please:
>>>>
>>>> DELIMITER //
>>>> CREATE PROCEDURE `reset_sortid` (IN category INT(11))
>>>> BEGIN
>>>> DECLARE a INT;
>>>> SET a = 0;
>>>> UPDATE
>>>>
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
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
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
_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
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
om/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 2
anyone help me with that please ?
>
> --
> 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
Payment > 0 and
>> cust.disposition > 0 order by SOURCE, DISPOSITION
>>
>> The MYSQL has the following version
>>
>> mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)
>>
>> Thanks for your help
>> Murthy
>>
>>
>> -
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
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
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
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:
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
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
, 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
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
).
--
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
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
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
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
#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
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
; 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
'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
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
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
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
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
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
-
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
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
/[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
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
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
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
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
>> >
>> >
>>
>>
>> --
>> - 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
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
-> 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
(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.
>
>
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
= '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[
; 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
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:
://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
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
'...'
> 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
> --
> 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
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
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
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
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:
>&
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
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
+
> | COUNT(*) |
> +--+
> |0 |
> +--+
> SELECT COUNT(*) FROM t WHERE d = '2007-06-15';
> +--+
> | COUNT(*) |
> +--+
> |1 |
> +--+
>
>
>
>
> --
> MySQL General Mailing List
> For list
.. 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]
>
>
> --
>
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
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
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
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://
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.
--
; 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]
>
>
-
>
>
>
>
> --
> 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
&
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
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
;
>
>
> --
> 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 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
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
=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
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
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:
>>
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
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:
>>
-
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
1 - 100 of 103 matches
Mail list logo