2008/7/1 Dan Nelson [EMAIL PROTECTED]:
In the last episode (Jun 30), Pooly said:
2008/6/30 Dan Nelson [EMAIL PROTECTED]:
In the last episode (Jun 29), Pooly said:
Hi,
I'm trying to convert my tables to UTF8 but I'm getting the
following error: ERROR 1062 (23000): Duplicate entry
Hi,
2008/6/30 Dan Nelson [EMAIL PROTECTED]:
In the last episode (Jun 29), Pooly said:
Hi,
I'm trying to convert my tables to UTF8 but I'm getting the following error:
ERROR 1062 (23000): Duplicate entry 'Zorglüb' for key 1
Not too sure why I'm getting this error since the current (latin1
Hi,
I'm trying to convert my tables to UTF8 but I'm getting the following error:
ERROR 1062 (23000): Duplicate entry 'Zorglüb' for key 1
Not too sure why I'm getting this error since the current (latin1) data are:
mysql select * from topics_lookup where label like 'Zor%';
Hi,
I'm reloading a backup and I'm getting loads of warnings like :
+-+--++
| Level | Code | Message|
+-+--++
| Warning | 1265 | Data truncated for column
Hi,
could it be this bug :
http://bugs.mysql.com/bug.php?id=21011
2006/8/31, Whisler, David [EMAIL PROTECTED]:
I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the
Solaris package utility (which means I de-installed 5.0.22 then
installed 5.0.24 in the same location,
Hi,
I recently upgrade our master to MySQL 5.0.24. But, I changed on
option to log_bin=server-log-bin, as a result the binary log has
changed from server-bin.000228 to server-log-bin.01...
So now, the slave throw me an could not find first log file in binary
log index.
I suppose I have to do
Hi,
MysqlCC not being in developement anymore and not working properly
with a server 5.0, we are trying to use MySQL Query browser, but there
are few things which are less than efficient compared to mysqlCC.
- you can't execute several queries ! The query tab executes them one
by one, and if
Hi,
I upgraded one slave server from 4.0.23 to 5.0.24, and when I run
mysql_upgrade I got the following error :
ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
what can I do ?
--
http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives:
Hi,
2006/7/22, João Cândido de Souza Neto [EMAIL PROTECTED]:
Ok Dan.
Thanks a lot for your answer.
An other doubt about transaction is in the foreign key case. If in a
transaction i insert a certain register and get the last insert id and after
i try to insert another register using this id
2006/7/10, Joerg Bruehe [EMAIL PROTECTED]:
Hi Mike, all!
mos wrote:
I have a complicated SQL statement with around a dozen
if(this,val1,val2) embedded in it and there are even nested If
clauses. I'm getting syntax errors because I'm not balancing the ( )
properly. Is there any free
Hi,
recently, our slave stopped for a duplicate key error (which is a bug to me :
http://bugs.mysql.com/bug.php?id=9929
)
How do you usually check automatically that slaves are up and running ?
--
http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives:
Hi,
2006/6/29, Joerg Bruehe [EMAIL PROTECTED]:
Hi Pooly, all,
Pooly wrote:
Hi,
I stumbled on one issue yesterday which took me some time to figure out.
the table is :
create table tt ( PCname varchar(5) not null default '');
insert into tt values ('Centaure');
So, by mistake I
Hi,
2006/6/28, Chris Sansom [EMAIL PROTECTED]:
I'm sure this is an elementary problem, but I can't get my head round it.
I have two tables: pix and sections, the relevant bits of which are:
pix (2,421 rows):
picid varchar(7) not null
sectionid smallint(5) unsigned not
Hi,
I stumbled on one issue yesterday which took me some time to figure out.
the table is :
create table tt ( PCname varchar(5) not null default '');
insert into tt values ('Centaure');
So, by mistake I inserted names which were too long for the field, but
then I tried to do queries on this
2006/6/24, Asif Lodhi [EMAIL PROTECTED]:
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
mathematically speaking, there no such number like 5.0.5 anyway...
5.05 perhaps...
MySQL are numbered according to a X.Y.Z release number.
X : is the major version, where major
Hi,
2006/6/21, Helen M Hudson [EMAIL PROTECTED]:
Yes, I can see how this would work for just the one order and hardcoding the
100... but I cannot assume only to sum distinct values and my table has
other order_refs in it with the same multiple rows of over multiple days, so
I need a more
2006/6/20, [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hi All,
I am using INNODB.I have a delete quetry something like this :
delete from modnaptrrecord_zone where modnaptrrecord_zone.modnaptrrecord_id in
(593536 ,593537 ,593538 ,593539 ,593540 ) and
modnaptrrecord_zone.modnaptrrecord_id
Hi,
2006/6/16, Takanobu Kawabe [EMAIL PROTECTED]:
[snip]
I tried this statement without error.
But Ihave some questions.
1.How many left join keywords can I use in one SQL statement if
there
are 5000 datas in one table?
as this blog point out, its 31 or 61 depending
2006/6/5, MySQL Nexeia [EMAIL PROTECTED]:
I face one problem with mysql4.0
I've two tables, one called company and the other called favorites. The
relation between those two tables is CO_ID on the company table and
MASTER_CO_ID on the favorites table. When I run the following query it works
2006/5/31, Peter Brawley [EMAIL PROTECTED]:
Lew,
If I have another polynomial, say the sum of terms 1,3,4, and 5, how
can I quickly search this
database to see if it's already been stored?
SELECT DISTINCT polynomial_id
FROM polynomial p1
INNER JOIN polynomial p2 ON p1.term_id=1 AND
a script for
such simple things which would be like having a jack hammer for a
nail.. )
--
Pooly
Webzine Rock : http://www.w-fenec.org/
.printf_and_wprintf_functions.asp
try :
sprintf(s,%I64d\n,ull.id);
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
^^
RollBack is NOT take effect. But on WindowsXP, it is GOOD.
What is wrong ?
Did you check if the table are innoDB ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
=0 in my.cnf , but ROLLBACK is still not effect.
Could you teach me more ?
Thanks and best regards,
- Original Message -
From: Pooly [EMAIL PROTECTED]
To: MySQL General mysql@lists.mysql.com
Sent: Monday, March 13, 2006 5:13 PM
Subject: Re: Rollback is not take effect on MySQL
for some reason. Does
anyone have any hints about this?
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html
precedence of comma has been change to conform to standards. So you'll
have to use arenthesis or rewrite your query.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General
you
have a broken dependency. (If you use debian : apt-get install
libdbd-mysql-perl )
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
could be acceptable as well (you only store
millisecond with a precision of 1/8 second).
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Otherwise, you could try to use the binlog. The filesystem sure would be
easy though...
for mysql 5.0
show table status
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/5.0/en/storage-requirements.html
Without any more details, we can't help you precisely.
Pretend there's no indexes for now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock
operation always writes 2K of text to the field? - e.g. will
this avoid MySQL having to 'free up' the space for the field, then
re-allocate 2K again for it.
space is not reclaimed after deletion until you run an : optimize table.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General
the debug version, and off you go. Quiet useful
to debug buggy query strings :-D
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(pics.date) FROM dates
left join pics on year(dates.date)=year(pics.date) and
quarter(dates.date)=quarter(pics.date)
WHERE year(pics.date) '2000' AND year(pics.date) ' 2005'
GROUP BY year(dates.date), quarter(dates.date)
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing
to the new order of
precedence for the JOIN operator?
comma operator has lower precedence than join now :
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
:
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
FTFM :
You can create one table from another by adding a SELECT statement at
the end of the CREATE TABLE statement:
CREATE TABLE new_tbl SELECT * FROM orig_tbl;
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing
-increment.html
So, if the year is generated by your application or with YEAR(), you
could do what you want. (For MyISam and BDB tabel types)
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
with a linux kernel 2.6.8 ? then you're running sarge.
Did you install the dev packages ?
apt-get install termcap-dev
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
0. stop the web server or avoid hitting the db !
1). Backup everything! :)
the mysqldump should suffice.
2). do the alter
The alter does already a create table with new data and then exchance
table. You need 2x the storage space though.
3. do the opposite of 0.
--
Pooly
Webzine Rock
day?
Any ideas?:)
diff ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2005/11/11, The Nice Spider [EMAIL PROTECTED]:
Does MySQL support:
SELECT ID_TAG= ID
FROM TABLE
rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty.
Did you try the AS keyword ?
Select ID As ID_TAG from TABLE
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(if it is exists) for a specific object_id. If it does not exists for that
specific language_id, I want to have NULL.
Have a try with :
Select language_id,language_title,object_id,object_title
FROM languages
LEFT JOIN objects ON objects.object_language_id=languages.language_id
--
Pooly
Webzine Rock : http
know ASP. I'm not sure if it's possible though (using ODBC ?).
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it.
Regards,
Better, mark this view (or particular rows if it's not too expensive)
as dirty and recompute it only on access, you may spare few
cycles...
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
) {
printf(%s : commit failed : %s\n, argv[1],
mysql_error(mysql));
return 1;
}
printf(%s : Commit ok\n, argv[1]);
}
return 0;
}
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
MySQL version, I can't give you a precise answer.
HIMH
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, add
CHG_DATE date not null default CURRENT_DATE on update current_date
(not tested)
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binay
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in the same way, and may have empty spaces.
If you optimized all tables in both database, you would then get the same size.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/Linux on DELL D600 1.4Ghz 1.5GB RAM
98% Microsoft(tm) Free!!
Neuromancer 10:38:25 up 2 days, 15:24, 6 users, load average: 0.71,
0.56, 0.35
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
just iterating over the rows in the result in order, so not sure
what would be applying another sort.
or it's likely that mysql_result retrieve an array of rows
(well-ordered), but fetch it by using a string for the index.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing
.
(So, yes forthe troll, it's an OS issue, threads creation are somewhat
slow on FreeBSD :)
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2005/9/23, Gordon Bruce [EMAIL PROTECTED]:
What am I missing
INSERT INTO table1 (column names.)
SELECT VALUES..
FROM table2
WHERE primary id = insert value
You will have to put in your real table name and column names.
nice and easy :-)
--
Pooly
Webzine Rock : http://www.w
List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
what about :
http://dev.mysql.com/doc/mysql/en/dsn-on-unix.html
2005/9/22, Ananda Kumar [EMAIL PROTECTED]:
Hi Pooly,
I know your busy, but please help me, i need to submit this by today for the
testing team.
If you dont mind can you please guide to any url or documentation where i
can find
anandkl
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
getting that error.
I think he means, that you should try the official binaries, and this
still happens, file a bug report because 5.0 is still in Beta stage.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
in the api, I use various 4.0.x, 4.1.x daily
and several OS and I've never had a crash in it (except from my own
mistakes, non-null terminated query strings, threads messing up,
freeing twice a result, non-allocating of result). the API is pretty
robust :-)
--
Pooly
Webzine Rock : http://www.w-fenec.org
with just one set of results, no
matter how I use it, it always crashes :-(
what is the code you're using ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
even for a dynamic
linking, the linker can't do it's job here.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it or not, and if so, why the documentation tells
that it is a *must* call the free function after the whole set of rows is
retrieved...
That would leave a nice memory leak indeed...
eventually, recompile and set a break-point before calling mysql_free,
and look at all variables.
--
Pooly
Webzine Rock : http
TABLE mytable ADD UNIQUE(id,list)
which make a unique index on two field. inserting a duplicate value
would give you back an error and let the table untouched.
Maybe you have a suggestion to do the same in another way.
Thanks
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General
2005/9/18, Jasper Bryant-Greene [EMAIL PROTECTED]:
Alvaro Cobo wrote:
Thanks Pooly and Peter:
The problem is that in the same php page I would like to choose either the
calculation from an especific year or the calculation from the whole table
using URL.
The same page can easily
the Count(*) solution ?? that's exactly what you
need IMHO.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
doing it more thant once, it can't work.
from the fine manual :
http://dev.mysql.com/doc/mysql/en/mysql-store-result.html
You must call mysql_free_result() once you are done with the result set.
but in you're code you're still using the result set !
--
Pooly
Webzine Rock : http://www.w
.
count(*) as nothing to do with knowing is there is data in the table or not...
If I'm still wrong, could you provide a sample query ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
from the disk I guess.
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
You need to select all rows, but you have only control on the
condition on flied1, I am right ?
If you can input %, it should do the trick.
select * from table WHERE field1 like '%';
Why can't you do just
select * from table ??
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL
queries. If you don't have access to the slow query
logs, the best is to log query time on a per page basis (or per
script/template which is better, depending your website).
check the field type, no nee to have an integer to store a state value
which is 0 or 1 for instance.
--
Pooly
Webzine Rock
explain me how can
I examine detailed mysql logs?
2. Can you basicly define transaction and its advantages and disadvantages?
Thank you
- Original Message -
From: Pooly [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, September 16, 2005 5:13 PM
Subject: Re: innodb
I'm sure other on the list will explain in details, but I'll do short.
I understood that forum_members is the new table, members the old one.
So :
UPDATE forums_members,members
SET forums_members.active=members.active
WHERE
forums_members.member_id = members.id
--
Pooly
Webzine Rock : http
...
thanks for your help :-)
julien
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http
/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
mysql SELECT criterio, idSite
- FROM dominios_propios_completos
- WHERE criterio NOT IN (
- SELECT criterio_pub
- FROM sites_criterios
- );
Empty set (0.05 sec)
Do you have NULL values in sites_criterios.criterio_pub ?
--
Pooly
Webzine Rock : http
!
Vladimir
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock
reply..
tia,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Spruce Pine
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
default '1',
PRIMARY KEY (`id`),
KEY `forum_id3` (`state`,`group_id`)
);
I don't understand why the number rows analyzed returned by EXPLAIN
does not match the count(*) of the query. I can understand when it's
higher, but lower ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL
2005/8/28, Michael Stassen [EMAIL PROTECTED]:
Pooly wrote:
Hi,
I ran those two queries :
mysql select count(id) from forums_data WHERE forums_data.group_id=1
AND forums_data.state=1;
+---+
| count(id) |
+---+
| 2385 |
+---+
1 row in set (0.11
, and if he give the year I'll compute his age).
Thanks!
2005/8/25, Jigal van Hemert [EMAIL PROTECTED]:
Pooly wrote:
Hi,
I would like to display a list of members who have their birthday a
given day (today for instance).
For such an application I've used a single integer column to store
server?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http
for your help.
Shaun
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http
table1 ...
1res1
2res2
3 ...
.
.
I can't build serial number in table1!
Thans!
Best Regards!
Zoli
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(birthday)=DAY(NOW())
but it would perform a entire table scan with that.
What would be your best strategy for that sort of query ?
And how would you deal with 29th of february ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
help.
Pooly wrote:
Hi,
I would like to display a list of members who have their birthday a
given day (today for instance).
My idea is to store their birth date in a column, and then query the
table against the column. But the query would be like :
select id from members where MONTH
Hello,
I'm using QT4.0 which works with MinGW. Now I want to use the MySQL
API, but it seems to be only working with MS VC++. Should I recompile
my own ? Is there any official MinGw libmysqlclient.dll ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list
per table.
What is the best and fastest way to make migration?
Best Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org
PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Thanx in advance ,
Kane.
Pooly [EMAIL PROTECTED] wrote:
2005/8/20, Kane Wilson :
hi Friends,
I have a WAP portal which is running based on mysql database. That's meant
that contents has been stored in the data base.
wallpapers , themes, ringtones, games ...etc data type as BLOB
if someone can give me some pointers (any
urls/links would be nice) as to how to write a client library with threading.
Thanks a lot.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
data stay on disk.
For example if you need to send a ringtone which is in your DB, the
browsersend the request, Apache receive it, load PHP/Perl, which then
connect to the DB...
If the file is on disk, you remove the last 2 operations which
willmakethe whole operation faster.
--
Pooly
Webzine Rock
Hallo,
Ich werde in english sprechen, so :
You get this error usually, when your connection with the DB juste
broke, or it's not working, try to test the return value of
mysql_connect, and see what is going on.
Or you can have this error when the server is too busy.
Tschüss !
2005/8/18, Scott
Hi,
Try in in two fold.
1. Get all the ID you have in your remote DB
2. check those localy with the ones you have in cache
3. Get all the info you need after you remove the ID you already have.
2005/8/14, Kostas Karadamoglou [EMAIL PROTECTED]:
Hello,
I try to create an application for my
in a resultset locally(remote database) and then in a for
loop I must check all the IDs that I dont need with the ID of the
current row within the loop.
I think this is a little bit time consuming!!
Do you know I more effective way to do this?
thank you in advance, Kostas
Pooly wrote:
Hi
1 - 100 of 109 matches
Mail list logo