Re: Merging multiple SQL requests

On 2015-02-15 23:55, Learner Study wrote: > Hello experts, > > Is it possible for MySQL server to automatically merge responses for > different queries into a single response? Are there any kernel > parameters that may dictate that? "UNION is used to combine the result from multiple SELECT statem

Re: space gone after MyISAM REPAIR TABLE

On 2013-06-27 01:27, nixofortune wrote: Now importing with Keys in place. It takes longer, much longer but at least the server is working and customers do not complaint. Schema design is awful, agree. I try to understand the process so will redesign it soon, but any suggestions are welcome. I'

Re: space gone after MyISAM REPAIR TABLE

On 2013-06-26 18:31, nixofortune wrote: > What would be the best way to convert BIG MyISAM table into InnoDB? We do not > have SLAVE. I would do it on another computer. Then copy the table to the server and then add the data that has been added from the original table. And/or i would experiment w

Intel Hyperthreading benefits on MySQL 5.5.10+

Should i disable HyperThreading on an Intel Xeon 8-core CPU or leave it on? On older versions of MySQL i read that it should be disabled but with the never versions MySQL is said to handle multiple cores/CPUs better but i cant find anything on HT to be beneficial or not. MySQL 5.5.10+, 24GB DD

Re: What MySQL-flavor to choose.

On 2011-02-14 15:43, Singer X.J. Wang wrote: So I'm assuming OLTP type transaction, then I'm going to recommend MySQL 5.5. Why is that flavor to be chosen over MariaDB with XtraDB or Percona with XtraDB? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

Re: What MySQL-flavor to choose.

On 2011-02-14 15:31, Singer X.J. Wang wrote: What is your load type? Heavy read but enough write not to benefit much from query cache. It is a webshop app (custom). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?u

What MySQL-flavor to choose.

We are about to migrate from MySQL 4.1 to a 5.5 version. We heavily use InnoDB, have an dual quad Nahelem Xeon, 24GB DDR3, 4*SSD in RAID-10 on an Adaptec RAID with 512MB Cache and running under x64 Linux on a modern kernel. We replicate to several other slaves. I only have experience on vanill

RE: SQL book recommendation?

[snip] I'm finding the MySQL online manuals hard going in figuring out how to construct SQL queries. Can anyone perhaps recommend a good book that can shed light on the subject? [/snip] http://www.peachpit.com/store/product.aspx?isbn=0321375734 MySQL, Second Edition: Visual QuickStart Guide, 2n

RE: harmonic mean in SQL

[snip] The mathematical way to add two "partial" harmonic means to generate new harmonic mean is: Let X1 , X2 be two harmonic means on different rollup rows, generated using n1 and n2 # of facts respectively. The combined harmonic mean would be: (n1 + n2)/( n1/x1 + n2/x2) If you have experienc

RE: Even or Odds numbers

[snip] is there a function, using MySQL 5.0v, that can detect if a numerical value is either an Even or Odd number [/snip] You can use modulus http://www.roseindia.net/sql/mysql-example/mysql-modulus.shtml -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

RE: Why is MySQL always linked to PHP?

[snip] Jay, PHP is a WEB based Server Side scripting Language. Do not compare it with C. C is a middle -level System programming language. Please stop comparing. [/snip] The statements about C were not mine, it was just the way that the thread was snipped together. Believe me when I say that I

RE: How to get last record for each product

[snip] I have a list of product orders in a table with the following structure : OrderID ProductID OrderDate OrderCost What query would I need to get the last order for each productID ? [/snip] MAX(OrderDate) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

RE: Why is MySQL always linked to PHP?

[snip] I merely wished to dispel the common, newb impression that PHP is the only realistic choice. [/snip] I don't think that is the impression but I think that the low barrier to entry and extensive support community make PHP a widely acceptable choice. I have seen many a newb turned off by the

RE: Why is MySQL always linked to Php?

[snip] PHP applications are, for the most part, not that ambitious and mysql is simply the most accessible database with the best developed API. [/snip] I know that you said "for the most part" and you are absolutely correct. I just want to point out that there are many corporations relying on PHP

RE: Creating a Data Dictionary

[snip] Perhaps I have a conflict of terms here, but my googling "mysql data dictionary" turned up material that didn't seem to correspond with my problem. In python I can create dictionaries: my_dict = {'1': 'one', '2': 'two'} Now, I would like to create the equivalent of an enum in which I could u

RE: Query Help

[snip] For the life of me I cannot remember how to make a query like this and what it is called. I know it is fairly basic though. Table 1 Product_id Product_Name Table 2 Category_id, Category_name Table 3 Product_id, Category_id Each product can have one or more categories. So I want a result

RE: query help

[snip] I have a table similar to this: - |transactions | |ID |DATE |EMPLOYEE| |234 |2010-01-05| 345| |328 |2010-04-05| 344| |239 |2010-01-10| 344| Is there a way to query such a table to give the days of the year that employee 344 did not

RE: substring query

[snip] Here is what I came up with. select substring(substring_index(myfile,'.',-2),1,4) AS MyColumn from mydatabase group by MyColumn; That appears to yield what I need. I just need to filter out the results that do not have an extension. [/snip] You can exclude results that do not have a per

RE: substring query

[snip] It may be a little more complicated then I made it out to be. I am just trying to pull out the file extension but there were some conditions I did not list. [/snip] Thank you for that update, would have been good to have from the start. SELECT SUBSTRING_INDEX('my.doc','.',-1) -- MySQL G

RE: substring query

[snip] I am looking for some guidance on creating a substring query. I have a column that stores a path to a file. I would like to extract that file extension and that is it and display it on my results. However, the paths are different lengths and some extensions are 3 letter and some are 4, eq

Re: Out of range value for column 'datestamp' at row 1

On 2010-05-09 13:29, Prabhat Kumar wrote: INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time, username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','* NOW()');* Last_SQL_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to

RE: Pivot Query in

[snip] Date, ProjectCode Building, Number of Copies I want to get a Connsolidate Report of Project Code R&D STP 1007304--04---04 (Group by Project Code)(Sumtotal Building wise). I have tried to execute the following code : select pcode, building, sum(ncopies) from request gro

Re: better way to backup 50 Gig db?

Gavin Towey wrote: What Shawn said is important. Better options: 1. Use InnoDB, and then you can make a consistent backup with `mysqldump --single-transaction > backup.sql` and keep your db server actively responding to requests at the same time. 2. Use something like LVM to create filesytem

RE: compare column value to anything in a list of values

[snip] IN('value1','value2') should work for exact matches, also works for integer values. [/snip] IN will not open and read his CSV file... [snip] Is there a simple function or method to compare a value in a column to one or more items in a comma separated list? [/snip] In order to do this you

Re: Exporting the result of a Query into excel

ishaq gbola wrote: Thanks a lot for that, but where does this file get saved in and how can i copy it to my local host if the database is on a remote server If you don't specify the absolute location it can be find in "DATADIR/DatabaseName/". And after you located the file you have a multit

Re: Exporting the result of a Query into excel

ishaq gbola wrote: Hi all, I would like to know if there is a tool or command in mySQL that allows one to export the result of query into excel formart select * from table into outfile "thefile.txt"; That can be imported into excel using CSV and using "TAB" as separator. http://code.anjanes

Re: Importing large databases faster

Madison Kelly wrote: Hi all, I've got a fairly large set of databases I'm backing up each Friday. The dump takes about 12.5h to finish, generating a ~172 GB file. When I try to load it though, *after* manually dumping the old databases, it takes 1.5~2 days to load the same databases. I am gue

Re: How to not lock anything?

D. Dante Lorenso wrote: All, I am using MySQL currently, but am starting to think that maybe I don't really need to use an RDBMS. The data I am storing ends up getting indexed with Sphinx because I have full-text indexes for about 40 million records. I have an "items" table that is heavily

Re: Fwd: ODBC MySQL Password as plain text

Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Sec

Re: DELETE DATA FROM TABLE

Krishna Chandra Prajapati wrote: Hi Experts, I have a crm table where 12 millions records inserted/day. We are running report queries on this table and using partitioning features for faster results. we have to maintain 45 days data means 540million records. As per my calculation 540 records wil

Re: Alphabetical search to and from

Or : alter table users add first_f_name char(1) not null; create index first_f_name_idx on users (first_f_name); update users set first_f_name = left(first_name,1); And not the query will use index. select username from users where first_f_name between "A" and "B"; -- MySQL General Mailing List

Re: Alphabetical search to and from

Dave M G wrote: MySQL, This should be a fairly simple question. I have a table with a bunch of people's names. I want to find people who's name begins within a certain range of characters. All names between F and P, for example. What SELECT statement would I use to do that? Thank you for any

Re: 50M records each year, help me choosing the stretegy

sudhir543-nima...@yahoo.com wrote: I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. 50M records is not th

RE: Why doesn't mySQL stop a query when the browser tab is closedL

[snip] I just noticed a horrible thing. [/snip] Keep in mind that the query event is server side and is not tied to the browser (client side) once it has begun because of the statelessness of the connection. You would have to have some sort of onClose() event from the browser that would trigger a

RE: Virtualizing MySQL

[snip] Virtualization includes overhead. It is fine as long as your application can tolerate that, but if your performance demands grow there will be a point where a DB server in a virtual machine will cause trouble but the same HW as a "real" machine would still suffice. [/snip] We run MySQL in v

Complex conditional statement during select

SELECT this, that, theOther, SUM(IF(SUBSTRING(myDate,1,10) >= '20080101' AND SUBSTRING(myDate,1,10) <= '20080131'), 1, 0) AS `January` FROM theTable GROUP BY theOther Throws this error... ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL ser

Re: List of Publicly Accessible MySQL Databases?

Hi! Check out db4free.net. :) Cheers, Jay Andrew J. Leer wrote: > Is there a listing of public MySQL Databases anywhere? > > Just if someone would be new to databases (not me...other people at my > office) and they would want to get a look at an existing working > database

DESCRIBE temporary table

I am not finding a quick reference to this, but I wanted to DESCIBE a TEMPORARY TABLE so that I can make sure the index was properly applied. Can this not be done? TIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL P

RE: TreeView

[snip] how can i create a tree View From a mysql table? [/snip] First you get some leaves. oops, waitnevermind :) I STFW and found http://forums.devarticles.com/mysql-development-50/treeview-of-mysql-tab le-2963.html -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Innodb vs myisam

Please actually read my reply before asking the same question. As I stated, InnoDB outputs *estimated* row counts in EXPLAIN, whereas MyISAM outputs *accurate* row counts. -jay Krishna Chandra Prajapati wrote: Hi, On myisam storage system mysql> explain select ui.user_id, ucp.user

Re: Innodb vs myisam

The MyISAM isn't scanning more rows. It's that the InnoDB "rows" output in EXPLAIN is an estimate and the MyISAM one is accurate... -jay Krishna Chandra Prajapati wrote: Hi All, I have same table configuration, every thing same except the storage engine. Explain res

RE: Im being dumb!

[snip] -Original Message- From: roger.maynard [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 7:33 AM To: mysql@lists.mysql.com Subject: Im being dumb! I got 4 tables: Table A | ID | Description1 | Table B | ID | Description2 | Table C | ID | Descript

RE: Problems with timestamp and leap seconds?

[snip] > The column type needs to be DATETIME. Thank you for pointing me at TIMESTAMP versus DATETIME. I'll read thoroughly when I can. Can you give a little more detail as to why DATETIME is necessary? [/snip] It was much too qu

RE: Problems with timestamp and leap seconds?

[snip] I had a bit of BFOTO and tried simple inserts. mysql> create table t (f timestamp); Query OK, 0 rows affected (0.00 sec) mysql> insert into t values ('2008-03-04 16:17:00'); Query OK, 1 row affected (0.00 sec) mysql> select * from t; +-+

Re: Large Database Performance - Reference Sites?

You will likely need to be a lot more specific about what you are asking for here, David. What is a "large select"? What constitutes a "large update"? What number of joined tables composes a "multi join" in your specific case? What is "text functionality&

Re: performance of heterogeneous joins

Nope, no difference, AFAIK. Alex K wrote: Any ideas pertaining this newbie question? Thank you so much, Hi Guys, Is there a performance hit when joining across multiple databases as opposed to joining multiples tables in one database? Suppose the same tables are available across all database

RE: executing query from the command line -- need help

[snip] Hello Jay. Thanks for your reply but where is your solution to my problem. I'm lost here. Help me -- please Thx -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 11:29 AM To: Brown, Charles; mysql@lists.mysql.com Subjec

RE: executing query from the command line -- need help

[snip] SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER; UPDATE TEST_SERVER SET SYS_ID = &value passed from above SYS_LOCATION = &value passed from above SYS_IPADDRESS = &value passed from above; [/snip] And here http://dev.mysql.com/doc/refman/5.1/en/user-variables.html -- M

RE: executing query from the command line -- need help

[snip] I'm new to mysql. I would like to issue a query from the command line and pass the result to an update done on the command line within the same script. See below. My question is how can I run a select from the command line and pass the values to an update SELECT SYS_ID, SYS_LOCATION, SYS_IP

RE: Sun and mysql

[snip] I am still amazed by the fact that youtube "is worth" 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? [/snip] Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet.

Re: Prepared SQL statements - Faster performance?

Are you using the PREPARE STATEMENT server-side syntax or an emulated prepared statement like in PDO? -jay mos wrote: I would like to speed up my Select queries since I'm executing approx 5,000 of them, same syntax but the search values for 2 columns will change with each query. Will

Re: Another cry for help..

his helps, Jay Anders Norrbring wrote: Brent Baisley skrev: You might be able to use variables to store the result of the query. Although I've never tried assigning the result of a query to a variable, only field values. SELECT (count(*)+)/(SELECT COUNT(*) FROM score AS s2 WHERE s2.ti

Re: Forbidden subquery

No problem. I hope by now you figured out I made a typo... :) The WHERE in the DELETE should be prod_price_chg_flag='O', not ="X" :) -jay Jerry Schwartz wrote: Hi Jerry! The very last sentence on: http://dev.mysql.com/doc/refman/5.0/en/delete.html is "Currently,

Re: Forbidden subquery

ete SELECT prod_price.prod_id FROM prod_price WHERE prod_price.prod_price_chg_flag = "X"; DELETE prod_price FROM prod_price JOIN to_delete ON prod_price.prod_id=to_delete.prod_id WHERE prod_price.prod_price_chg_flag = 'X'; DROP TABLE to_delete; Cheers, Jay Jerry Schwartz wrote:

Re: Update but insert if not exist

INSERT ... ON DUPLICATE KEY UPDATE: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html Cheers, Jay J Trahair wrote: This is a question I want to know the answer to, as well! Is there any way of avoiding looking up a specific record in a table to see if it exists, before

Re: Spfile in Mysql......

Sujatha S wrote: Mysql should bring this as there new feature in there next release! Unlikely. Dynamic changes are, well, dynamic. Permanent stuff goes in the my.cnf. -jay Regards, Sujatha On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani < [EMAIL PROTECTED]> wrote: Hello,

RE: Giant database vs unlimited databases

[snip] The justification for the latter is that MySQL is not powerful enough (compare to Oracle or DB2) to handle large amount of data and concurrent users. [/snip] Not true and it has been proven time and again by the likes of Yahoo and others that size. We routinely use MySQL for large data stor

Re: Slow Subquery

indexes on p (project_id), pt (project_id, tag_id), t (name) Cheers, Jay So your query would look something like this: SELECT projects.* FROM projects JOIN (SELECT projects_tags.project_id FROM tags, projects_tags WHERE tags.name='foo' AND projects_tags.project_id=projects.id) AS p

RE: ORDER BY but disregard stop words

[snip] Is there any way to use ORDER BY in such a way as to have it ignore words such as "the", "a", "an", and the like? [/snip] I haven't tested this but you might be able to do it with a little REGEX and a HAVING clause; SELECT REGEX(words) AS undesirable FROM table HAVING stuff <> undesirable

The value of NULL in Uniqued Columns

This is more of a philosophical issue than anything, but it has jumped up to bite us so I thought I'd make others aware; Since NULL has no value they can be entered multiply times into unique columns. Some will say that NULL is a value and therefore should be unique in this case (only one NULL a

Re: Need help with a "natural sort order" for version numbers and release code names

Daevid Vincent wrote: I'm trying to get some 'release/version numbers' to sort properly. mysql> SELECT ReleaseID, Name FROM releases ORDER BY Name DESC; +---+-+ | ReleaseID | Name| +---+-+ |18 | Unspecifie

RE: Query not returning Data

[snip] SELECT * FROM Sight_Hearing_Help WHERE 'type_help' = "Eye Exam & Glasses" AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007" LIMIT 0 , 60; [/snip] Try WHERE type_help LIKE '%Eye Exam & Glasses%' and look at your dates in the database themselves even if they are varchars, they ar

Re: 2008 conference fee?

I *think* that's right... :) Cheers, and post back here if you've got any further ?s. Jay Pipes Program Chair, MySQL Conference and Expo 2008 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: funky characters in columns

[snip] Try: replace(replace(dealerLong, '\n', ''), '\r', '') [/snip] Didn't work, perhaps because they are hidden. I ended up taking the long road; update table set foo = replace(HEX(foo), '0D', ''); update table set foo = UNHEX(foo); HEX allowed me to see the carriage return (0D) and then use

funky characters in columns

I did some googleing and some other searching, now I am looking for a cure all. I have a column into which it appears that a carriage return has been inserted and it is mucking about with some queries; mysql> select dealerLong from profile where id = '130'; ++ | dealerLong | +-

RE: csv to mysql

[snip] : i,m looking for a solution for my PDA that Doesn't have a DB Solution installed on it : so im having to write to CSV Files for my Forms , i'm needing a way that when i sink my PDA with my wireless network it Moves the Entire CSV File into a MySQL database :any Suggestions :? [/sni

Re: Does this MySQL client exist?

Christoph Boget wrote: I did a search and couldn't find anything like what I'm looking for and though I doubt something like this does exist, I figured I'd ask anyway. Is there a client (not phpMyAdmin) that can connect to a server (that is running MySQL) using SSH and connect to the database th

Re: [mysql] duplicating lines

Hi Craig, would you mind posting the SHOW CREATE TABLE for the tables in question? I'm having trouble determining what is the primary key for your service ticket table... Thanks, -Jay Weston, Craig (OFT) wrote: Hello again, I am having a duplication of results probl

RE: Simple questio SQL

[snip] I have a Table and want to know the most visited products. Products - Id - Name - Visited [/snip] SELECT Id, Name, count(Visited) AS Total_Visits FROM product GROUP BY(Id) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: finding count of spaces in a string

plish this task. Not having much luck finding a solution in the manual. SELECT CHAR_LENGTH(field_name) - CHAR_LENGTH(REPLACE(field_name, ' ', '')) as num_spaces FROM my_table; Cheers, Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: thread_concurrency in linux

, AFAIK: http://www.mysql.org/doc/refman/5.0/en/innodb-parameters.html#option_mysqld_innodb_thread_concurrency I know the general rule is number of CPU's*2 but will this actually have any effect with Linux's threading model? Nope, at least AFAIK. -jay -- MySQL General Mailing Lis

Re: servers full potential / FT searches locking tables

statement and a write lock when the client issues an INSERT statement. Implicit locks are acquired only for the duration of a single statement. - Original Message - From: "Jay Pipes" <[EMAIL PROTECTED]> To: "Justin" <[EMAIL PROTECTED]> Cc: mysql@lists.mys

Re: servers full potential / FT searches locking tables

SELECTs don't lock the table. Are you having frequent UPDATEs while selecting? That would be the reason for locks. -jay Justin wrote: Ok.. Straight to the point.. Here is what I currently have. MySQL Ver 14.12 Distrib 5.0.27 RHEL vs 5 584GB Raid 5 storage 8GB of RAM and Dual

Re: Index usage - MyISAM vs InnoDB

xecuting this particular query a *lot*, the best thing for you to do would be to put the index on (calldate, usercost) so that you have a covering index available to complete the query. Cheers! Jay Tnx in advance for help Regards Edoardo Serra WeBRainstorm S.r.l. -- MySQL General Mai

Re: user permissions to all DB

solidzh wrote: 2007/8/21, Jay Pipes <[EMAIL PROTECTED]>: Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this?

Re: user permissions to all DB

Terry, I absolutely agree with Rolando on this. Rolando, Although I agree with you, I was only trying to answer Terry's question :) Cheers, Jay Rolando Edwards wrote: You must be very careful when granting permissions on every database this way. Here is why: By giving a user permis

Re: user permissions to all DB

Yep. Terry wrote: Just to verify, will that include all new databases? On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote: Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permi

Re: user permissions to all DB

@'hostname' IDENTIFIED BY 'password'; Cheers, Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Insert Select query problem

ase (Source, Item, Qty) SELECT 1, totals.Item, r.Qty FROM request r JOIN ( SELECT Item, SUM(Qty) AS TotQty FROM inventory GROUP BY Item ) AS totals ON r.Required = totals.Item WHERE r.Qty <= totals.TotQty UNION ALL SELECT 0, totals.Item, (r.Qty - totals.TotQty) FROM request r JOIN (

Re: 2007 MySQL Community Survey - Got Ten Minutes to Spare?

d. I'll remember your input for the next one and hopefully do a better job. Cheers, Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 2007 MySQL Community Survey - Got Ten Minutes to Spare?

Thanks for the input! Hopefully, I've fixed the problem. Please retry. It should have saved your previous answers. Thanks much! Jay J.R. Bullington wrote: I received the same as David. The question was: What OS do you currently use? Please check all that apply: (p

2007 MySQL Community Survey - Got Ten Minutes to Spare?

you would like to go into the drawing for the books, just include your email address in the very last question...otherwise, just leave it blank. Link to the 2007 Community survey: http://www.surveymonkey.com/s.aspx?sm=ONCdTFPxjyq55NAUBUJ_2fvQ_3d_3d Thanks much! Jay Pipes Community Relatio

MySQL Camp II - August 23-24 - Brooklyn, New York

and community projects. Limited Registration Registration for MySQL Camp II is restricted to only 200 participants, and space is filling up quickly. To register, email Jay Pipes ([EMAIL PROTECTED]) the following information: - Your Name - Your Company or Affiliation (if

RE: selecting everyting from 2 non-identical tables.

[snip] I have two non-identical tables. They are pretty similar except a few fields. I want to select everything from both for example table1 id name age table2 id name height I want id name height age even if it returns null values. select * from table1, table2 seems to give repeat rows

RE: Sorting by a list of possible results in a column....

[snip] I have a query that selects a list of results, ordering them by the status field. However, I want to further sort that by the type of status, that is: Undefined Ready for Review Top Priority Priority Completed Etc... Every sort that I try, of course, sorts alphabetically. Is there a way

RE: stored procedure not working in legacy ASP

[snip] The stored procedure is in MySQL, but when called using ASP it fails to return more than the first record. Anyone? [/snip] You need a while loop. Does the SP work from the command line properly? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: secure port 3306

[snip] I have a client that needs to be able to remotely connect to port 3306 securely. I have tried to suggest an SSH Tunnel, but they do not want their clients to have SSH access. Another problem is that even if we do tunnel, it needs to go thru one server that is connected to the Internet and

RE: [X-POST] Fastest way to dump this huge table

[snip] I have a huge MySQL table, 2.1 million records, 200MB. Once a week I need to dump it in CSV format and zip the file. This is not on my server, and it's in production, so I don't want to risk testing different methods and possibly hanging up their server for a period of time, so I want

Re: Optimize code?

Hi Jerry, comments inline Jerry Schwartz wrote: I need (ultimately) to update some prices in a prod_price table. First, I need to locate a product and its associated prices using a field prod.prod_price_prod_id which is not unique, and is often null, but it is indexed. (Subsequent operations

Re: Help please: SELECT in binlog?

has data-modifying queries. Cheers, jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem on millions of records in one table?

red a production version. Cheers, Jay -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 18, 2007 10:04 PM To: Brent Baisley Cc: He, Ming Xin PSE NKG; mysql@lists.mysql.com Subject: Re: Problem on millions of records in one table? Brent Baisley wrote

Re: Problem on millions of records in one table?

remove "old" data easily from the default table set. Hi! Have you tried out the new partitioning features of MySQL 5.1 to do this? Would be cool if you had some performance numbers comparing the older MERGE table method with the newer partitioning... Cheers! Jay - Original Me

RE: how to tell if something hasn't happened yet - SOLVED

[snip] [snip] select s.* from store s where s.id not in (select t.storeid from trans t where t.created=date(now())); [/snip] This is close, but it does not exclude previous days. I only want to see those that have not logged in today. [/snip] select store.storeid, store.stname from store

RE: how to tell if something hasn't happened yet

[snip] select s.* from store s where s.id not in (select t.storeid from trans t where t.created=date(now())); [/snip] This is close, but it does not exclude previous days. I only want to see those that have not logged in today. -- MySQL General Mailing List For list archives: http://lists.

how to tell if something hasn't happened yet

Good day gurus and gurettes! I have a table; | transactionid | int(11) | NO | PRI | | auto_increment | | username | varchar(32) | NO | | || | storeid | varchar(6) | NO | | || | action| int(4) | NO

Re: Why is the Falcon license listed as 'PROPRIETARY' in 5.2.3?

now fixed in the codebase, as evidenced here: http://lists.mysql.com/commits/24222 Cheers! Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Inserting a file in MySQL

[snip] How do i insert a file in a blob field from the command line ? [/snip] >From http://dev.mysql.com/doc/refman/5.0/en/string-functions.html mysql> UPDATE t SET blob_col=LOAD_FILE('/tmp/picture') WHERE id=1; -- MySQL General Mailing List For list archives: http://list

Re: Do NULL values slow down the database?

y accessed columns have much less likelihood from taking up space in memory, especially in memory-starved applications. Cheers, Jay On 3/29/07, Reinhart Viane <[EMAIL PROTECTED]> wrote: Hello list, I have a table events in a database that has a field named duration. This fiel

Re: improving performance of server

Could you post the actual code you are using for the INSERT? Also, what storage engine are you using? Jay andrew collier wrote: hello, i am having some trouble getting mysql to perform decently on my machine. it is a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit

Re: Increasing the Query Cache Size has performance ?

Not sure what is going on, but the version of MySQL you are using is ancient. The current version of MySQL is 5.0.37. Even MySQL 4.1 (which has been end-of-lifed) has a latest version of 4.1.22. If it is a bug you are seeing, it likely has been fixed in a later version. Cheers, Jay

  1   2   3   4   5   6   7   8   >