Re: Need help querying a database of polynomials

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

Re: Subquery Problem With mysql-4.0 (Works with mysql-5.0)

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

Re: The number of left join in one SQL statement.

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

Re: Sql optimization

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

Re: a tricky join

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

Re: Version Numbers - Precedence

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

Re: Getting unique values

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

varchar(5) and select question

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

Re: varchar(5) and select question

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

replication stopped

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

Re: How to look for balanced parenthesis?

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

Re: transaction

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

mysql_upgrade returning an error

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

mysqlcc / mysql query browser

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

replication breaks

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

Re: mysql_upgrade script problems on MySQL 5.0.24

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

error when sending message

I try to send a message to this list with another account, but the message came back with an error : Your message was not delivered to: mysql@lists.mysql.com for the following reason: Diagnostic was Unable to transfer, -1 Information MTA 'lists.mysql.com' gives error message Mail from HELO

Re: 4.0 > 4.1 migration and timestamps

Hi, I'll tell you what did my provider (http://www.claranet.fr ) to upgrade from 3.23 to 4.1. They setup a new server with new hardware and a clean new 4.1.11 on it. Then I have available the old 3.23 and the new 4.1. They let me the choice on which server, the DB are created. So the customer has

Re: A more general REPLACE(STR,FROM_STR,TO_STR) function

That I'd love to have a regex_replace available in MySQL !! 2005/6/29, Thomas Spahni <[EMAIL PROTECTED]>: > Hi all, > > sometimes life would be easier with a more general 'REPLACE' function > available. That's when I find mysqlf dumping a database, editing with sed > and reloading. > > My featur

convert varchar to char

Hi, I try to convert a varchar to a char, but it doesn't seems to work. show create table sessions; CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL default '', `user_id` int(6) NOT NULL default '0', `ip` varchar(8) NOT NULL default '0', `lastseen` timestamp NOT NULL default CURRENT_

Re: convert varchar to char

(`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 and now I've got fixed-length rows ! Thanks 2005/8/13, Roger Baklund <[EMAIL PROTECTED]>: > Pooly wrote: > > Hi, > > > > I try to convert a varchar to a char, but it doesn't seems to work. > > Fro

Re: convert varchar to char

Yeah, for example the last statement ALTER, ..., ... is the only way sometimes to make things working. anyway, it's worth knowing it. 2005/8/13, Chris Elsworth <[EMAIL PROTECTED]>: > On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote: > > Damnit ! > > Thanks

Re: Design problem About application related with cached rows

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

Re: Design problem About application related with cached rows

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

Limit in subquery

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;

Re: fehler

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

Re: Is there an easy way to copy a table between two mysql servers?

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

Re: BLOB in mysql ----- performance issue.

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]

Re: BLOB in mysql ----- performance issue.

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

Re: Running select on multiple databases serially.

> > > > -- > 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]

MinGW and MySQL

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

Re: Migration from MySQL 4.0 to 4.1

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:

Re: Migration from MySQL 4.0 to 4.1

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]

Re: LATEST N RECORDS from a table without date field

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

Birthday strategy

(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

Re: Birthday strategy

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 >

Re: Birthday strategy

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

Re: MinGW and MySQL

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

Re: UK Bank Holidays

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] >

Re: create "serial number" by select

value > -- > res1 > res2 > res3 > > > SELECT (??), value FROM table1 ... > > 1res1 > 2res2 > 3 ... > . > . > > I can't build "serial number" in table1! > > Thans! > > Best Regards! > Zoli > > >

question with rows count

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

Re: question with rows count

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; > > +--

Re: MySQL Control Center works with v4.0.23 -- how about V5?

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]

Re: MySQL Subquery bug or am I doing something wrong?

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

Re: LIMIT alternative

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]

Re: Please I need inputs on "Lost connection to MySQL server during query"

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] &

Re: Performance of DB with many tables

> > -- > 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]

Re: Unclear on UPDATE versus INSERT, and a simple query that is not working

. 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]

Re: [newbie] moving mysql db to new server

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] >

Re: innodb and myisam and db optimising

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

Re: innodb and myisam and db optimising

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]> >

Re: EXISTS subquery optimization

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]

Re: Select ALL rows with WHERE statement

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

Re: Select ALL rows with WHERE statement

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

Re: mysql_free_result() WITHOUT mysql_fetch_row()

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

Re: mysql_free_result() & 2 different connections

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&#

Re: mysql_free_result() WITHOUT mysql_fetch_row()

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/ --

Re: mysql_free_result() WITHOUT mysql_fetch_row()

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]

Re: mysql_free_result() & 2 different connections

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]

Re: Failure to install on Solaris.

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]

Re: mysql_free_result() & 2 different connections

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]

Re: connect from oracle to MYSQL.

#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]

Re: "Lost connection to MySQL server during query" when calling stored procedure

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

Re: mysql_free_result() & 2 different connections

> > 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

Re: connect from oracle to MYSQL.

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

Re: Must mysql_free_result be called after mysql_store_result in case of NULL?

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]

Re: insert subquery

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

Re: Multithread handling of Connect/Close

> ...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

Re: add a column if not exists

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]

Re: varchar vs char speed improvement

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]

Re: ORDER BY for ints

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]

Re: To multi thread or NOT to multi thread?

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]

Re: MyISAM to InnoDB

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]

Re: MySQL Query Browser

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

Re: Mysql Regular expression

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]

Re: restore db from mysqldump I get different databases size

> 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

Re: alter table

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]

Re: Easy or not so easy GROUP BY

-+ > | 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

Deadlock found when trying to get lock; try restarting transaction

if ( ret ) { printf("%s : delete failed : %s\n", argv[1], mysql_error(mysql)); return 1; } } printf("%s : commit\n", argv[1]);

Re: Input on Materialized Views

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

Re: PHP/MySQL vs ASP/MSSQL?

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]

Re: LEFT JOIN problem

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

Re: vpn connectivity

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.

Re: Does MySQL Support '=' Sign?

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

Re: differenced backup from sql dumps

; 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]

Re: Mysql 4.1 full table (nearly) - best practice to alter?

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

Re: INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8

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

Re: autoincrement for year

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

Re: mysql 5 - disk bound - fixed

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:/

Re: "left join" record in one joined table and not in another

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

Re: Histogram from tables.

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

Re: Stepping into libmySQL.dll with VC6

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]

Re: CHAR vs TEXT and fast Row Updates

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

Re: Estimated Drive Space Requirements

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]

Re: How NOT to log SHOW INNODB STATUS in the query log.

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]

Re: Last access time of a table

> 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.

Re: unix_timestamp + milliseconds support?

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]

Re: Perl & MySQL

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]

Re: Change on LEFT JOIN ON syntax in 5.x?

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

Re: Rollback is not take effect on MySQL 5.0.18

> > 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

  1   2   >