ture being
considered or discussed? Where might I find it online?
Thank you to the MySQL team and to Oracle for filling in InnoDB;s
missing features!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
On Thu, Mar 28, 2013 at 11:15 PM, Peter Brawley
wrote:
> Can someone run the server with --skip-grant-tables to retrieve this code?
>
Possibly, I'll ask. However, it is highly unlikely that such a thing
was done to create the routine.
--
Dotan Cohen
http://gibberish.co.il
htt
On Wed, Mar 27, 2013 at 5:46 PM, wrote:
>>>>> 2013/03/27 08:01 +0200, Dotan Cohen >>>>
> Actually, it is the user that I am logged in as that created the
> function. That is why I find it hard to believe that one needs root /
> admin access to see its defini
On Sun, Mar 24, 2013 at 11:08 PM, Peter Brawley
wrote:
> Log in as admin@localhost.
>
Thanks. I don't have the admin or root privileges on this database. Is
that the only way to see the code behind the function?
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
My
turns,body FROM mysql.proc;
ERROR 1142 (42000): SELECT command denied to user
''@'localhost' for table 'proc'
mysql>
What else should I try to get the code? This is on MySQL 5.1.61
running on CentOS. Thanks.
--
Dotan Cohen
http://gibberish.co.il
http://
I did not realise that a Windows installer might
install applications of a different architecture than itself.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
quot;MIN":
>
> select * from table1 where messageID NOT IN (
> select MIN(messageID) from table1
> group by userID
> )
>
>
Thanks. I actually used ORDER BY and LIMIT, I should have used MIN.
This is how one learns!
Thank you!
--
Dotan Cohen
http://gibberish.co.il
ht
our usage examples including code covering real-world scenarios.
Thanks!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ds in a memory table with an
> index and it solved it. It also was a cleanup script, and not something I
> need to run everyday.
>
Yes, this is also a cleanup script for a bunch of vBulletin private
messages that should not have been sent. Have you seen the vBulletin
database? Over 200 table
leanly. It will involve a sort and a limit
on the inner select. Thanks!
> I'm assuming where you show row 7 you meant row 8?
>
Yes, that is what I meant. As someone wiser than myself once said: to
err is human, but to really mess things up we need a computer!
--
Dotan Cohen
http:
aim to have the expertise or
experience to tell Oracle how to run their show, I only voice my
concern as a consumer of the product and one with an interest in
keeping the product and technology viable. I have nothing but
appreciation to Oracle for continuing to develop Java, MySQL and for
having the
ll-MySQL solution is possible.
Thanks!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, an outer join should return all matched and
unmatched rows (essentially all rows) from both tables. So it is not
clear to me what is the difference between a right outer join and a
left outer join, and how they differ from a regular outer join. But
don't answer that, I'll google it and pos
esponds to your MySQL server version for the right
syntax to use near 'outer join colours c on (b.colour = c.ID)' at line
1
mysql>
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
al references natural outer joins and requires curly brackets
and I'm frankly not making sense of it. Left, right, and inner joins
work as I expect them too, and fishing for examples in google doesn't
find anything unusual. How exactly am I erring?
Thanks!
--
Dotan Cohen
http://gi
fruits.fruit, beers.beer FROM fruits INNER JOIN
beers ON fruits.userid = beers.userid WHERE beers.userid = 1");
In general, which is preferable? I don't have access to the production
machine to benchmark at the moment, but which is best practice?
Thanks!
--
Dotan Cohen
http://gibb
the database connection is include()ed from a file outside
the webroot. This way if Apache is ever compromised or for whatever
reason stops parsing the PHP, the resulting code returned to the
browser won't have the daabase info (especially the password).
--
Dotan Cohen
http://gibberish.co.
pes
> // prepare the data aray with escaping/intval()/doubleval()
> // and generate finally the insert
> //
> // as return value use 0 on errors or the insert-id
> }
>
>
You are right, using a class has many benefits. I might do that on a
future project. Thanks.
--
Dotan Co
;)";
> Now on the other hand, if you have several elements in the array $M to be
> inserted, and have a function like this to escape them all at once:
> for each ($M as &$val) $val= mysql_real_escape_string($val);
> then your method starts to make more sense.
I could foreach
t goes into the array, so I know that all the data
in the array have been escaped. I can then use the array members in
the query.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
about why to wrap the
variables in PHP MySQL queries with curly brackets. I don't even
remember where I picked up the habit. Does anybody here know?
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Thanks, Reindi. I actually do something like this (simplified, in real
code I use an array and a small custom function):
$mysqlName=mysql_real_escape_string($name);
Then, in the query I can see that all my variables start with $mysql*
so I know that they have been sanitized.
--
Dotan Cohen
http://gibberish.co
error, but might cause some logic errors in the
> database. The choice is yours.
>
Thanks, that is a good point. I would actually prefer errors to arise
on insert then a potentially inconsistent database or bad data. I
should definitely learn to use stored procedures, I know.
That said, I
27;ve only recently
started putting ticks around table and column names. I'll stick to
your convention of no quotes around numerics and single quotes around
everything else.
Have a terrific week!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
On Sat, Sep 10, 2011 at 01:48, Carsten Pedersen wrote:
> `userTable.userid` => `userTable`.`userid`
>
Thank you Carsten. That was indeed the problem! Have a peaceful weekend.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archi
nt(someField) |
+---+
| 5076 |
+---+
1 row in set (0.00 sec)
mysql>
What could be the issue here? Thanks!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
his is on a CentOS 4 or 5 server, with MySQL 5.0.77, accessed from
the CLI. Thanks!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Fri, May 13, 2011 at 10:21, Joerg Bruehe wrote:
> Hi everybody!
>
>
> Dotan Cohen wrote:
>> Is there a simple browser-based MySQL backup solution for
>> non-technical users. [[...]]
>> The main features needed are:
>> 1) Automatic scheduled off-site backups
the
> commercial version.
> Backups are stored on the host that runs the server, and of course it serves
> multiple MySQL machines.
>
> Webinterface is annoyingly slow, though :-)
>
Thanks, I passed the suggestion on. Might be what he is looking for.
--
Dotan Cohen
h
other MySQL users' input on the
topic.
Thank you!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
el, no recursion and 1 query (more or less) and I
> have all the results I needed. It was seconds in comparison.
>
Thanks, I enjoy reading these real-life scenarios. This was a terrific example.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
for
Smarties" by Joe Celko, which also deals with a similar model. It is
revealing and an interesting way of looking at the issue of organising
data.
In addition to those two links, this one also seems relevant:
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
--
Dotan Cohe
ories of category X requires searching
> first for all children, then all grandchildren, and so on, resulting in a
> recursive query.
> Using the nested sets model requires a single non-recursive query to get the
> same data.
>
I do agree that the non-recursive method at r
the length of the sig far outweighs the length of
your typically concise and to-the-point post. Constructive advice:
trim the sig!
Thanks!
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> Adding categories to the hierarchical model is definitely faster
> so it comes down to your insert-to-select ratio. Moving a subtree is also
> much easier with the hierarchical model.
Which do you call the hierarchical model? That term is not used in the
linked article.
--
Dot
at for tomorrow) I'll see it differently. Thanks.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ng that a customer exists, that
implies compensation, and therefore fair bait.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ed
> within the equation.
>
> However, I digress, momentarily.
>
> But Einstein gave freely, for humanity, not for gain, other than
> personal freedom.
>
> An equation that benefited all, and yet gain is a personal product.
>
> Also, if you can answer it, is gravit
if you have multiple tag hierarchies.
>
Is that strategy widely deployed, then? It seems so unruly having to
change on average half the database records for every new leaf.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http:
; CREATE TABLE items_tags (
> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
> itemID int,
> tagID INT
> );
>
> Will not require a major overhaul if you later turn categories into a tree.
>
Terrific, Peter, this looks like the right direction. I appreciate the input.
--
Dot
e that is to
> work like libraries do: 10 is "fiction", 10.05 is "crime novels", 10.05.07 is
> "British authors", and so forth. Your `tags` table then looks like
>
Thanks. I prefer the "parent tag" field, though, I feel that it is
more flexible.
--
On Thu, Jan 20, 2011 at 18:20, Dotan Cohen wrote:
> On Thu, Jan 20, 2011 at 17:00, Richard Quadling wrote:
>> I'd have my items table, my tags table and a join table for the two.
>> My join table is really simple. UniqueID, ItemID, TagID.
>>
>
> Yes, that is the
27;d recommend using a nested set approach for the tags
> (http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
> gives a good explanation on the issues and methodology of nested
> sets).
>
That is terrific, at least the first half. The second half, with the
Venn diag
ld, so if I plan on having this table anyway would
method 3 above be preferable?
Note: this message is cross-posted to the MySQL and the PHP lists as I
am really not sure where is the best place to do the logic. My
apologies to those who receive the message twice.
Thanks!
--
Dotan Cohen
http://g
Thanks in advance.
Dotan Cohen
http://lyricslist.com/lyrics/lyrics/44/402/pink_floyd/atom_heart_mother.html
http://what-is-what.com/what_is/sql_injection.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r.
Another option: host the MySQL server on your own hardware, and
configure the php script to connect to that. Then you can control
everything coming in/going out.
What are you trying to protect? And what's the sense in protecting it
such, if in any case the php script has access to it?
D
On 15/01/07, Gabriel PREDA <[EMAIL PROTECTED]> wrote:
Read here: http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html
have fun !
-- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer
Thanks. Been quite a while since I've deserved a good RTFM! :)
t will suffice... I know it does for me !
Thanks, Gabriel. What exactly is the "NAMES" in "SET NAMES utf8;"? Why
can't I find any reference to it?
Dotan Cohen
http://technology-sleuth.com/technical_answer/how_can_i_be_safe_online.html
http://what-is-what.com/what_is/bios
er_set_database=utf8");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_server=utf8");
Dotan Cohen
http://what-is-what.com/what_is/computer.html
http://lyricslist.com/lyrics/artist_albums/255/hill_faith.html
--
MySQL General Mailing List
For li
of changed rows in whatever language
you are programming, then update from that? Or a text file, another
DB, whatever...
Dotan Cohen
http://what-is-what.com/what_is/digg.html
http://dramatherapy.info
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
On 06/12/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
Use SELECT in with count(*)
SELECT count(*) from YOUR_TABLE
Mikhail Berman
Thanks, Mikhail. Will do.
Dotan Cohen
http://what-is-what.com/what_is/xss.html
http://english-lyrics.com/
--
MySQL General Mailing List
For list ar
What's a quick query to determine how many records a given table
contains? I don't think that a SELECT query is appropriate, as I don't
intend on doing anything with the data selected. Note that I'm
interfacing with MySQL via php, if that matters. Thanks.
Dotan Cohen
htt
Thanks in advance.
Dotan Cohen
http://what-is-what.com/what_is/bluetooth.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 06/11/06, Christian Hammers <[EMAIL PROTECTED]> wrote:
On 2006-11-06 Dotan Cohen wrote:
> I have a list of subjects, such as "Linux", "Open Source", and "the
> World Wide Web". The subjects are stored in MySQL and being retrieved
> via php.
t code:
$query = "SELECT subject FROM table ORDER BY subject asc";
$result = mysql_query($query);
Thanks in advance.
Dotan Cohen
http://what-is-what.com/what_is/world_wide_web.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 4/16/06, Nicolas Verhaeghe <[EMAIL PROTECTED]> wrote:
> I am slowly considering leaving GoDaddy, who has a very good bandwidth and
> ok tech support (I have seen better but much much worse) and acceptable
> prices, but unfortunately does not support MySQL 5 and PHP 5 either.
>
> I wonder if I co
ox so that I can connect? 'Cause I've
nothing but Kubuntu and Fedora at home.
Dotan Cohen
http://technology-sleuth.com/
On 12/31/05, Mechtilde Stehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Dotan Cohen schrieb:
> > I keep a lot of personal information in a MySQL database. I have a few
> > querys premade for the wife to use, but we have gotten to the point
> > where we need a solut
On 12/18/05, Daniel Kasak <[EMAIL PROTECTED]> wrote:
> Dotan Cohen wrote:
>
> >I keep a lot of personal information in a MySQL database. I have a few
> >querys premade for the wife to use, but we have gotten to the point
> >where we need a solution for her to be able
On 12/16/05, Greg Maruszeczka <[EMAIL PROTECTED]> wrote:
> Dotan Cohen wrote:
> > I keep a lot of personal information in a MySQL database. I have a few
> > querys premade for the wife to use, but we have gotten to the point
> > where we need a solution for her to be
Access installation the other day and it
seemed to be just what we need- a GUI for non-programmers to use a
database. Is there any such beast for MySQL? Anthing that will run on
Fedora Core 4 would be great. Or even a web-based solution would be
fine- I do have apache on localhost.
Thank you.
Dotan
On 10/24/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
> On Mon, 2005-10-24 at 06:09 +0200, Dotan Cohen wrote:
> > How do I use a not operator in the WHERE clause? The obvious != and
> > NOT didn't work for me. Something along the lines of:
> > $query = "
ear ASC";
Thanks in advance.
Dotan Cohen
http://technology-sleuth.com/question/what_is_a_cellphone.html
On 10/21/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
> On Fri, 2005-10-21 at 06:34 +0200, Dotan Cohen wrote:
> > Why would this work:
> > SELECT question, short, longa, technical FROM -snip- WHERE
> > filename='$filename'
> >
> > But th
Why would this work:
SELECT question, short, longa, technical FROM -snip- WHERE filename='$filename'
But this not:
SELECT question, short, left(longa,40), technical FROM -snip- WHERE
filename='$filename'
The line that looks like this:
$long =mysql_result($result, 0, "longa");
Is throwing this er
advance.
Dotan Cohen
http://www.technology-sleuth.com/mobile/cellphones.php
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 9/27/05, Nigel Wood <[EMAIL PROTECTED]> wrote:
> Dotan Cohen wrote:
>
> >Hi all, I have a field in a mysql database v4.0.18 that contains a
> >linux timestamp. I have been googleing for a solution that would
> >return to me all the entries where the timestamp fa
ulling all the fields and checking the timestamp with php. But I
believe that there must be a better way. Thanks.
Dotan Cohen
http://lyricslist.com/lyrics/artist_albums/109/carlisle_belinda.php
Carlisle, Belinda Song Lyrics
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
g for mysql, newbie, create user, tutorial and installation
but have come up with nothing. Please, how do I create the first (and
subsequent) user? Thanks!
Dotan Cohen
http://lyricslist.com/lyrics/artist_albums/373/newton-john_olivia.php
Newton-John, Olivia Song Lyrics
--
MySQL General Mailing Lis
69 matches
Mail list logo
