;t see any related queries in the general query log. Does the general
log include invalid SQL?
I've also tried to use the driver logging, but on Windows it overwrites
with the last SQL command so I cannot get a good capture as requests are
sent to the DB.
DB is MySQL 5.0.x
you can try MySQL prox
Sorry. My VPS has 144 MB of RAM so mysqld is using about ~ 21 MB when
idle.
Sebastian
--
Emacs' AlsaPlayer - Music Without Jolts
Lightweight, full-featured and mindful of your idyllic happiness.
http://home.gna.org/eap
--
MySQL General Mailing List
For list archives: http://lists
.0.67 on 64 bit intel" is
> way more informitive. Most people have not migrated to 5.1 yet, and
> many people are using versions older than 5.0 .
Fair enough. It's 5.0.51a-21 on 32 bit Intel Xeon.
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
gt; wanna bring the memory usage down?
WordPress blogs.
Why, because my VPS is very low-powered. I have PostgreSQL installed as
well and it uses less than 1.5% of memory when idle.
Sebastian
--
Emacs' AlsaPlayer - Music Without Jolts
Lightweight, full-featured and mindful of your idy
Hi all,
I use Gmane (http://gmane.org) to read/post to mailing lists as news
groups.
Is there any way of switching off delivery of mail from this list whilst
remaining subscribed? I've had a look around and there doesn't appear
to be...
Regards,
Sebastian
--
Emacs' AlsaPlayer
lly'
install a later version.
Is there anything I can do to bring this figure down?
Any advice/tips/pointers much appreciated.
Regards,
Sebastian
--
Emacs' AlsaPlayer - Music Without Jolts
Lightweight, full-featured and mindful of your idyllic happiness.
http://home.gna.org/eap
--
don't forget to run mysql_convert_table_format after upgrade
(beside mysql_fix_privilege_tables)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Now i do not know what to do,Can someone help me?
My english is not well.Do i speak clearly?
take a look into your mysql error log, windows event viewer
most common reason for not starting mysql is missconfigured InnoDB
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http
Hi,
for all you people out there loving phpMyAdmin ;-)
please visit http://hackontest.org and vote for or suggest your favorite
feature you would like to see in phpMyAdmin and that can be implemented
within 24 hours by a team of three
Thank you very much!
--
Sebastian Mendel
--
MySQL
ation?
SELECT `sales_date`, COUNT(*)
FROM `sales_activity`
WHERE `sales_type` = 1
GROUP BY `sales_date`
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
exactly is the problem?
What exactly did you tried? What was the error?
How are the foreign keys defined?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| amc_rch | fulltext | ER_IT_CTX_IDX_0805201045 |
ER_IT_CTX_IDX_0805201045 | 0 | |1 | Using where |
++-+---+--+--+------+-+--+--+-+
1 row in set (0.05 sec)
--
Sebastian Mendel
R() (and UPPER()) are ineffective when applied to binary strings
(BINARY, VARBINARY, BLOB). To perform lettercase conversion, convert the
string to a non-binary string:
mysql> SET @str = BINARY 'New York';
mysql> SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));"
--
Seb
your quotes are wrong, did you tried
mysql -u $DBUSER --password=$DBPASS --batch --execute="update
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t; Select count(id) from log where date between '2008-05-01' and
'2008-05-30';
+---+
| count(id) |
+---+
| 85232 |
+---+
1 row in set (0.97 sec)
"rows" is how many rows MySQL thinks it must examine to execute the query,
not the number of ro
a windows-1256 dump file??
with SET NAMES, you tell MySQL which charset it should use to return content
to you, or which charset has the content you send to the server
http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html
--
Sebastian Mendel
--
MySQL General Mailing Lis
AND T.val = Q.val
HAVING ISNULL(Q.ID)
OR ISNULL(T.ID)
)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
eAccelerator cache but the resource returned by eA does not appear to
be recognised by mysqli_fetch_assoc.
than you need to fetch the result, and store this result like any other
array, but not the resource
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
h_date.pk = copy_low.pk
AND copy_low.date < 100
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jack Bates schrieb:
Given columns a, b, and c, where I GROUP BY a, how do I get the value of
column b in each group which corresponds to the maximum value of column
c?
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
--
Sebastian Mendel
--
MySQL General Mailing
dd the MySQL log?
there you can see what MySQL is doing, with times
you could also prioritize background processes instead of desktop processes
to speedup MySQL start
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
`) FROM `domain_payments` GROUP BY `Domain`)
you can also save this as a VIEW
btw. `Domain` should have an index, and i think `Invid` and `Custid` too
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
is there a way or a function like NOW() except it returns the client time
and not the server time?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Paul DuBois schrieb:
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote:
Hi,
wouldn't it be very helpful if mysql connectors support some sort of
per session persistent connection?
this would save a lot of queries in many apps, for example SET NAMES,
setting variables, creating temp
isn't this the general mysql list? isn't mysqlnd maintained by mysql?
Michael Dykman schrieb:
This is a little off-topic for this list (recent PHP tutorials
nowithstanding)... replying offline
On Wed, May 7, 2008 at 5:36 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
Hi,
this?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
omitted, and writes/reads go
directly to the disk and not the RAM (cache)
you do not need to worry about loosing data caused by a full cache
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
r you use two fields, one with formated ISBN and one indexed with numeric ISBN
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ly deletes happening, there would be lot of
fragmention, so i used the
analyze table ; command to defragment it, it took close to 12
hrs. Is there any better and faster way to analyze or optimize the table to
defragmentation.
having a fixed row length will prevent tale fragmentation
--
Sebastian
--
MyS
o it seems not unusual to me that it takes more time to search this index ...
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
David Perron schrieb:
Hi Sebastian-
Wanted to follow up on this. I figured out the problem. You actually
have to use the LEAST & GREATEST operators when comparing multiple
values, this statement works perfectly.
LEAST(EndDays,Q2EndDays) - GREATEST(Q2StartDays,StartDays) as Days
or the full length of the field (128). I just
ran a query for the length of wite_what and the maximum length so far is
34. So, I will cut the index length down to 64.
and what indexes do you have currently exactly?
id - is the primary and has an index type btree
wite_what - is a unique and
Padiyath Sreekumaran schrieb:
Hello Sebastian,
Thanks for your mail. But I donot see any difference in my $username and yours
except
'(").
what surprise, yes, thats it!
you have to use no quotes at all (or doublequotes) around variables, RTMF is
this case the one from PHP
bu
ite\htdocs\script.php on line 6
Keine Verbindung möglich!
What is Iam missing? Any help is appreciated.
Please send a copy of the answer in my personal E-mail address also.
$username instead of '$username'
same for '$password'
but what has this to do with MySQL???
--
Seba
$oct1.$oct2.$oct3',
'$oct1.$oct2.$oct3.$oct4', '[EMAIL PROTECTED]',
'[EMAIL PROTECTED]', '$from_dom', '$rcpt_dom');
you could also vary with thee index length if wite_what.
and what indexes do you have currently exactly?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ise, you're best bet is to
rewrite the query as UNION clauses with one of your WHERE conditions
in each. I know it sounds crazy, but before MySQL 5 the use of
indexes with OR queries was not very good.
IMHO not in this case, cause it is just a simple "WHERE field IN ()"
--
Seb
TO_DAYS([date_end]), TO_DAYS([Q_end])) - MAX(TO_DAYS([Q_start]),
TO_DAYS([date_start]))
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this problem for the whole day and did not make
much of a progress. If someone has any idea how to resolve this problem,
I'll appreciate a tip greatly.
a similar question was just answered on this list about 15 hours before your
question ...
http://lists.mysql.com/mysql/212457
--
Seba
for the dates that do not have
an event would work.
Example of the events table and the above query in action:
http://www.pastie.org/185419
You can generate the values with the integers table.
http://www.xaprb.com/blog/2005/12/07/the-integers-table/
i knew that you would answer this ... ;-)
-
aces”.
http://dev.mysql.com/doc/refman/5.0/en/innodb-init.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
liaojian_163 schrieb:
> thank you Sebastian!
> I have re-created the table.there are not any problems in the table.
>
> if the table is new,need to rebuild de indexes?
no
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Ingo Weiss schrieb:
Thanks, Sebastian!
I have tried this one before. The problem is that it finds all items the
tags of which include EITHER 'blue' OR 'red', not 'blue' AND 'red':
oh ... "and" ..., i missred
SELECT DISTINCT items.*
right value )
I was wondering why it didn't gave me the same value and after some
time doing a select max gave me the right value "Y"
seems your index was corrupted
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
here classid=41
> and id >0 order by id desc limit 10;
> Empty set (0.00 sec)
did you tried to repair the table and/or rebuild the indexes?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27; and 'red'
- items tagged with 'blue', 'red' and 'green'
SELECT DISTINCT items.*
FROM [your join above]
WHERE tags.name IN ('blue', 'red');
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on class, but
the last comma seems to be wrong
try
'update products set pic1="%s" where id="%s";'
instead of
'update products set pic1="%s" where id="%s", ;'
or even without ';' too
and is this some sort of prepared stat
all versions, and the example is from the MySQL manual
http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cal server. It would even have the same IP address.
additionally, depending on data size it could much more easier to just
install our old HDD into the new server ... whether copy the data to the new
HDD or sue the old ones ...
--
Sebastian Mendel
--
MySQL General Mailing List
For list arch
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi list,
reading manual on mysql regarding auto_increment with multiple-column
index:
CREATE TABLE animals (
grp ENUM('fish','mammal','bird') NOT NULL,
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR
estion is what id would be if i:
UPDATE `animals` SET `grp`='mammal' WHERE `grp`='bird' AND `id`='2' AND
`name`='ostrich' LIMIT 1;
you do not need `name`='ostrich' in WHERE, cause grp,id are already UNIQUE
your key is grp,id (bird,2
e seventh line shows the second non root user I created –
it has just one line and shows localhost as the host. All the rest of the
users I created show the
% character in the host column.
would be much more easier if you would send this output here (with faked
names, passwords and hosts .
means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
--
Sebastian
--
MySQL General Mailing List
For
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal
this must be the host of the MySQL server, the host that is specified when
connecting _TO_ the database.
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
update on newslettercontent and set its timestamp
column to be the publishdate from the newsletter table using the join
rules in that query. Is there a way to do that in a query?
yes, you can, see multi-table update
http://dev.mysql.com/doc/refman/5.0/en/update.html
--
Sebastian
--
MySQL General Mailin
Perrin Harkins schrieb:
On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
use UNION
You can't use UNION to add the results of two queries. It would
return two rows.
of course!
you need to use this UNION as subquery
sorry for being not imprecise
-
case
when table names are in uppercase you have also write this in your queries:
select * from TABLE_NAME
or read:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
structure? Or explain why this is wrong?
use UNION
http://dev.mysql.com/doc/refman/5.0/en/union.html
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ere group_id=0 and album_id!=0
?
beside the fact, MySQL should not need to investigate any row at all for
this query, it should satisfy this query from the index, without looking up
any row
so this is a bad example
--
Sebastian
--
MySQL General Mailing List
For list archives: ht
Changying Li schrieb:
Sebastian Mendel <[EMAIL PROTECTED]> writes:
Changying Li schrieb:
Hi. there is a table photo and two queries:
mysql> show index f
e user_id as an index ? what's the mean of 'rows' ?
valid rows after applying the WHERE to this index
how doese mysql get value of 'rows'?
count returned values from index with valid WEHERE
I really dont wnat to use 'force index' because I'm using DBIx::Class in perl
catalyst framework.
why do you want to FORCE INDEX?
did you tried an index(user_id, group_id)?
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ssed their replies (except from Rub
Wulsch)?
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Neil Tompkins schrieb:
Thanks Sebastian, but I now get the error message
[MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function
i am not familiar with ODBC or MySQL 3.x
but possible just GROUP BY is missing
check the manual for your mysql version for the exact syntax
if
Sebastian Mendel schrieb:
Neil Tompkins schrieb:
Hi
I want to order by the totalled fields varProductCount and
Products.ProductReviewDESC
just put them together, separated with comma, like it is written in the
manual
ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT
Neil Tompkins schrieb:
Hi
I want to order by the totalled fields varProductCount and Products.ProductReviewDESC
just put them together, separated with comma, like it is written in the manual
ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT(ProductsPurchases.ProductID)
--
MySQL
Products ON Products.ProductID =
ProductsPurchases.ProductIDGROUP BY Products.ProductID ORDER BY
varProductCount+Products.ProductReviewDESC
ORDER BY COUNT(ProductsPurchases.ProductID)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
?
where do you want to see this drop-downs?
MySQL is an database server, and i m not aware of any place where it would
display any drop-downs, possible you speak of some sort of GUI, like MySQL
Admin or phpMyAdmin?
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
file created by
mysqldump.
i am not sure if mysqldump does include `mysql` database, but you will see
if you look into it,
you should run mysql_fix_privilege_tables after importing `mysql` database
and FLUSH PRIVILEGES;
--
Sebastian
--
MySQL General Mailing List
For list archives:
Carlos Savoretti schrieb:
Hi all!
Well, question is how could I to retrieve information about
types supported.
IMHO, no
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
super doesn't have rights to select from the hr table. But why not? According to the tables_priv table, super should have right to select.
did you export/import your data, or just copied the data files from your old
to the new MySQL?
did you reload privileges after changes?
FLUSH PRIVILEGES;
available sooner or later?
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a problem unless
the result is large.
yes. of course, size matters, if your whole DB is small enough you will not
even get any performance impacts without any index ... ;-)
but it requires more resources, or?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lis
design is better to do.
search for: nested sets or something similar
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
m` , `id_to` )
this will not prevent filesort, because the results still needs to be sorted
for ORDER BY time, or?
i would try INDEX(`id_from`, `id_to`, `time`)
but i am not sure if this will help, cause of this two IN()
--
Sebastian
--
MySQL General Mailing List
For list archives: http://list
Hi all,
I tried to implement a cursor using the following statement:
create procedure curdemo()
begin
declare cursor1 cursor for select SID from customer;
I have a customer table with a field SID.
BUt I am getting an error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
duplicate supcode in a.
When running this query I often have c values which does not relate to
supcode.
yes, because c is JOINED by `code` and not by `subcode` with a "and
a.code=c.code"
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
_date DESC
LIMIT 1
)
WHERE a.price = 0;
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I created two tables like this:
create table customer(SID int,name varchar(20),primary key(SID));
create table orders(OID int,O_Date date,customer_SID int,primary
key(OID),Foreign key(customer_SID) references customer(SID) on delete
cascade on update cascade);
And inserted values into it.but when
duplicate supcode in a.
When running this query I often have c values which does not relate to
supcode.
yes, because c is JOINED by `code` and not by `subcode` with a "and
a.code=c.code"
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
ld be like a time service would record once the current time, and
than always just send this recorded time ... wired, not?
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My question is, is this worth it? It certainly seems to be faster to me, but
not as much as I expected.
I did try originally subtracting from 0, but that caused the rankings to be
incorrect..
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
making the mistake. Can anyone
advice on the best practice for preserving my database as is when
backing up and restoring?
this 'bug' is unknown to me, did you tried to reproduce on phpMyAdmin demo
servers?
http://pma.cihar.com/
http://wiki.cihar.com/pma/Getting_Help
--
Seba
d
GROUP BY
comments.id
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stop loop.
does MySQL still respond on network connections when the socket is 'gone'?
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reason why this
happens and there are no errors, no core files, nothing - the file just
disappears.
why do you need to kill if the socket is missing?
does $/etc/init.d/mysqld stop|restart not work without a socket?
--
Sebastian
--
MySQL General Mailing List
For list archives: http
those fields from integer to
varchar's as am not doing any arithmetic with those fields. Does anyone see
any issues with this approach ? Will this break any of the existing
functionality when i move from INT to varchar's ?
it will require more space
sorting will change
--
Sebastian
-
) drop index
5) execute same query
takes 0.2 seconds and uses a different method of returning results from the
original query in 1)
6) restart mysql
7) execute query
takes 2 minutes
query cache, os cache, or some other cache
--
Sebastian
--
MySQL General Mailing List
For list archives: http
| 1996-04-29 |
+--+-++
you need to add an additional field like 'priority' and do "ORDER BY
priority DESC, species ASC"
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
E filter.ipv4_src=boxplot.ipv4_src AND
filter.ipv4_dst=boxplot.ipv4_dst AND filter.port_dst>=boxplot.low AND
filter.port_dst<=boxplot.low
what you are trying to do?
and how about formating your query in a human readable way?
did you tried EXPLAIN?
what type of syntax is this: &qu
pproved=0 if you only need the '47'
SELECT COUNT(comment_agent)
from wp_comments
WHERE comment_agent LIKE '%Linux%'
GROUP by comment_approved
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s a new storage engine
http://dev.mysql.com/doc/refman/6.0/en/storage-engine-overview.html
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ave any ideas? I was trying to avoid having to write a program to do
this.
use UTF-8 for text files
use SET NAMEs to correctly MySQL what charset you are using
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2000-05-18
how do i construct my select statement so that i only get distinct year?
so the above data will return something like this:
sDate
2000
1999
1998
1997
did your tried:
SELECT DISTINCT YEAR(`sDate`);
--
Sebastian
--
MySQL General Mailing List
For list archives: http
() or as operator: |
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hope this makes enough sense to be able to answer.
did you tried with lowercase table names (ttable1) too?
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table_A to this, and not otherwise
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Richard Heyes schrieb:
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
??? why, this payment goes to current owners and investors, not to MySQL
itself ...
but anyway, using Suns structures and "power" will help of course ...
--
' uses sockets,
127.0.0.1 uses networking
"host Can be either a host name or an IP address. Passing the NULL value or
the string "localhost" to this parameter, the local host is assumed. When
possible, pipes will be used instead of the TCP/IP protocol."
http://php.net/
but why should disable networking speedup MySQL?)
On Jan 14, 2008 6:54 PM, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
Moon's Father schrieb:
On Jan 14, 2008 7:00 AM, Daevid Vincent <[EMAIL PROTECTED]> wrote:
I saw this on the PHP list and was wondering if there is any meri
OldManRiver schrieb:
I uploaded the mysql console screenshot at:
http://www.sitepoint.com/forums/showthread.php?t=525160
this requires a login ...
why not just post (copy and paste) the console output, with all the commands
and results your where trying to execute?
--
Sebastian
--
MySQL
1 - 100 of 246 matches
Mail list logo
