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
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
&g
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 'pag
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, environ
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 d
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 you
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: http://lists.mysql.com/mys
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 fre
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: http://lists.mysql.com/my
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
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 part
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 n
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 gene
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_i
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
f
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 p2.ter
he records' data.
Yeah, but sometimes beoing able to do such things on the mysql
command line would be very helpful ! (Instead of having 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/
; 4294967295
> It's still a 4bytes integer.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_format_specification_fields_.2d_.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]
ser |
> +--+
>
>
> I set innodb_table_locks=0 in my.cnf , but ROLLBACK is still not effect.
>
>
> Could you teach me more ?
>
>
> Thanks and best regards,
>
>
> - Original Message -
> From: "Pooly"
>
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> ^^
>
> 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 : htt
olumn 'u.uid' in 'on clause'
> mysql>
>
> It seems like the table alias u is not recognized 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 s
L installation, it's DBD::MySQL which is
not installed properly. I would suggest to reinstall it, since 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]
eed to manipulate those
millisecond, a tinyint 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/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]
he 5,000 rows - and then ensuring that
> the UPDATE 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
oad the source,
load the projet, chose 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]
te table, with all working days for instance), do
a left join on it with year and quarter.
SELECT year(dates.date), quarter(dates.date), count(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) > '20
d Join Syntax in the ref. manual. Is it related 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 Lis
newtbl SELECT blah... is what you're after :
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:/
t :
http://dev.mysql.com/doc/refman/5.0/en/example-auto-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: h
2.8
you mean Debian 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:htt
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
W
; get dump from every signle 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 Ro
ao
>
>
> --
> 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.
languages, and match the translated object
> (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
of ASP/MySQL could be a right option for you if you already
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]
ormal table. Triggers
> would update 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 l
if ( ret ) {
printf("%s : delete failed : %s\n",
argv[1], mysql_error(mysql));
return 1;
}
}
printf("%s : commit\n", argv[1]);
-+
> | 10-1a |
> +---+
> | 10-2|
> +---+
>
>
> - Thanks in advance
>
So, Max group by month/item ?
http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html
and for concat :
http://dev.mysql.com/doc/mysql/en/string-functions.html
Since
id, chg_by, chg_date)
btw, you could do :
alter table MEMBERS add CHG_BY varchar(3) not null default "sbk", 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]
> Orginal size 3.1 MB the new size 2.7 MB.
> any idea?
They may not be ordered 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 Li
and QT have regular expression )
>
> Thanks
> 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]
ow I do it. I don't
> know why they have two different types of tabs (one for multi-statements and
> one for single statements) but they do.
>
> File -> New Script Tab
>
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> --
> My
t)
>
And GIS as well, IIRC:
http://dev.mysql.com/doc/mysql/en/spatial-extensions-in-mysql.html
(just to be picky)
--
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]
d thread-creation, for no advantage... So that's the result
expected.
(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]
ql_result($players,$i,'id');
> echo "$label"
> }
Try with mysql_fetch_array
>
> And that generates an order like it was doing a string comparison.
> I'm 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 List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
ah, Information_schema would be better, but 5.0 is in gamma)
--
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]
> ...handle thread...
>
> mysql_close(...)
> ...
> }
> mysql_server_end();
> exit(0);
>
> Thnx,
>
> Lefteris
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysq
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
sult);
>
> Thnx,
>
> Lefteris
>
> --
> 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]
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 documenta
>
> P.S.
> I already posted it to bugs.mysql.com but still do not get response
>
again, I doubt it's a bug 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
ion?
>
> Fairly obviously, how do I fix it!? ;)
>
> > Most probably, a server crash...
>
> Can you be a little bit more specific please? The MySQL server is
> working absolutely fine for everything else and also continues to
> respond to connections and queries perfec
#pkgadd -d MyODBC-3.51.10-sun-solaris2.8-sparc.pkg
#more README
?
> I am using solaris2.8 for oracle database and mysql 4.1 on linux fedaro.
> regards
> 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]
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://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installed the development package for the pthread library ?
I guess you're missing libpthread.a which is needed 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]
still crashes even 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]
E 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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
will do absolutely the same thing
that you want, and spare you the mysql_store_result with a whole
dataset.
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/
--
my1.query
One My2.store == One My2.free.
you're 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&#
ling it...
http://dev.mysql.com/doc/mysql/en/mysql-free-result.html
it does not says : you have to retrieve all rows before freing it. So
you should be able to free the result. Otherwise it's a bug or
undocumented behaviour.
But why don't you use the Count(*) solution ?? that
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
g like:
>
> SELECT * FROM `tbl_table1` WHERE field1 = * or ALL or % #Select all the
> fields.
>
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
o do an additional seek
to read the actual row. This strategy can be used when the query uses
only columns that are part of a single index.
So you should save an extra seek 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]
ow how to reach mysql logs? Can you 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]>
>
need transaction.
Check for slows 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
estination.
restart server
If it's InnoDB, I have no idea...
>
> 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]
>
.
So :
UPDATE forums_members,members
SET forums_members.active=members.active
WHERE
forums_members.member_id = members.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]
>
> --
> 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]
Client and Server are connected through a LAN.
>
> Based on ping an average of .1 ms reply..
>
> tia,
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
&
ttp://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]
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_c
It looked like
> it
> > was supposed to be able to do that from the screen shots.
> >
> > Thanks,
> > Siegfried
> >
> I think what you are looking for is MySQL Query Browser
>
> http://www.mysql.com/products/tools/
>
> Shawn Green
> Database Administrator
> Unimin Corporation - 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]
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;
> > +--
state` tinyint(1) NOT NULL 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
We
value
> --
> res1
> res2
> res3
>
>
> SELECT (??), value FROM table1 ...
>
> 1res1
> 2res2
> 3 ...
> .
> .
>
> I can't build "serial number" in table1!
>
> Thans!
>
> Best Regards!
> Zoli
>
>
>
arate table
> and keep it updated with Bank Holiday dates?
>
> Thanks for your help.
>
>
> Shaun
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
GW.
>
> What is the MinGW ? Database 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
month, 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).
>
> F
or leap years.
thanks for your 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
>
(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
ated to SQL:
>
> SELECT slno, name
> FROM tbl
> ORDER BY slno DESC
> LIMIT
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Pooly
Webzine
ards,
> > Rafal
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql?
> > [EMAIL PROTECTED]
> >
> >
>
>
> --
> 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]
b file. After migration we wan't use file 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:
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
>
>
>
> --
> 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]
sorry for asking such out of
> list questions.
>
>
> 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 databas
he last 2 operations which
willmakethe whole operation faster.
--
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]
http://www.pc.nu
>
> --
> 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://l
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 No
Hi,
I use ther version 4.1.11, and when I run this query :
SELECT c.id,c.subject,c.res_type,c.news_id,c.com_thread,c.timestamp +
0 as timestamp FROM comments c WHERE c.id IN (SELECT d.id FROM
comments d WHERE d.res_type=1 GROUP BY d.news_id ORDER BY d.id DESC
LIMIT 5 ) ORDER BY c.timestamp DESC;
now I more effective way to do this?
>
> thank you in advance, Kostas
>
> Pooly wrote:
> > 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 al
1 - 100 of 109 matches
Mail list logo
