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 proxy
--
Sebastian
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 idyllic
. 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/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
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.mysql.com/mysql
To unsubscribe
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 - Music Without
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
--
MySQL General Mailing List
, but 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
?
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]
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));
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
| Using where |
++-+---+--+--+--+-+--+--+-+
1 row in set (0.05 sec)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
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]
) |
+---+
| 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 rows possible returned
http://dev.mysql.com/doc/refman/5.1/en/using-explain.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list
= 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]
into the
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
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]
??
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 List
For list archives: http
`) 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
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]
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
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 temporary
this?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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,
wouldn't
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]
will be 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
, there would be lot of
fragmention, so i used the
analyze table table_name; 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
--
MySQL
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]
at 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
--
Sebastian
(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]
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 ()
--
Sebastian Mendel
--
MySQL General Mailing
', '$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]
in my personal E-mail address also.
$username instead of '$username'
same for '$password'
but what has this to do with MySQL???
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
but what has
.
and what indexes do you have currently exactly?
id - is the primary and has an index type btree
wite_what - is a unique and has an index type of btree
so this looks all ok, i am not sure if the query time includes the time if
the query needs to wait for locked tables ...
--
Sebastian
--
MySQL
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 DaysInQ2
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]
is the 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 unsubscribe:http
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.*
FROM items
INNER JOIN taggings
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 unsubscribe:http
/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]
://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 ... ;-)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
`name`='ostrich' in WHERE, cause grp,id are already UNIQUE
your key is grp,id (bird,2)
but your query will fail, because there is already grp,id (mammal,2) and
therre can not be two identical UNIQUE (PRIMARY) keys
--
Sebastian
--
MySQL General Mailing List
For list archives: http
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(30) NOT NULL,
PRIMARY KEY
. 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 archives: http
on 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]
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 statement, or are the parameters escaped
somewhere else?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
'
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]
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 list archives: http
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 ...)
--
Sebastian
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.
how do i do
, 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: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
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]
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
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
--
Sebastian
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 Mailing List
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]
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]
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]
Changying Li schrieb:
Sebastian Mendel [EMAIL PROTECTED] writes:
Changying Li schrieb:
Hi. there is a table photo and two queries:
mysql show index from photo;
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
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
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:
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
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;
--
Sebastian
--
MySQL General Mailing
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]
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: http
?
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
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://lists.mysql.com/mysql
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]
` )
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://lists.mysql.com
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]
is that there is 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 unsubscribe
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
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
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]
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]
is that there is 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 unsubscribe
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/mysql
To unsubscribe:http://lists.mysql.com
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]
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
--
Sebastian
--
MySQL General Mailing List
For list archives: http
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
on in the 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]
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
--
MySQL General
) 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
|
+--+-++
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]
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]
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: boxplot(pF.port_dst,LOW) ?
--
Sebastian
--
MySQL General Mailing List
For list archives: http
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]
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]
() or as operator: |
--
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
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]
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/mysqli_connect
--
Sebastian Mendel
--
MySQL General Mailing List
For list
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 ...
--
Sebastian
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
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 merit to
it?!
I would be surprised
1 - 100 of 244 matches
Mail list logo
