Re: mysql/sql server migration

- Original Message - > From: "Adam Lanier" > > What is the recommended course of action to keep data synchronized > between the two platforms? Not an easy one, I think :-) For simple one-shot copies the MySQL Connector for ODBC should do fine. I'm not sure if you can set up a continuou

Re: mysql sql query size limit

The closest thing to an absolute limit on query size is the value of the configuration variable max_allowed_packet which defaults to 1 meg. - michael On 4/10/07, Anil D <[EMAIL PROTECTED]> wrote: Hi List, What is the practical limit on size of the sql query in mysql 4.1.x Anil --

Re: MySQL SQL statistics

On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote: Thanks a lot for your reply. I need know SQLs that consume most resources(CPU time, disk IO etc.) of database server. If its an application, you can use EXPLAIN to find out how MySQL is processing the most used queries, and use this knowledge to optim

Re: MySQL SQL statistics

Oracle for MySQL. Regards, Gu Lei - Original Message - From: "Daniel da Veiga" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 08, 2006 12:43 AM Subject: Re: MySQL SQL statistics > On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote: >> Hello everyone: >> >>

Re: MySQL SQL statistics

On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote: Hello everyone: I want to get some SQL statistics including executions, CPU time for each SQL Statement. The number of each type of query can be found using the "show status like 'Com%';", I don't believe there's a way to know how much CPU time MySQL i

Re: MySQL (SQL) Newbie.. Need help with a Query

hi, that's the same. If you use between, mysql do the rest for you : mysql> explain SELECT * FROM passengers WHERE -> reservation_date_time >= '2005-01-01 12:10:00' -> AND reservation_date_time <= '2005-05-01 12:10:00'; ++-++---+---++

Re: MySQL (SQL) Newbie.. Need help with a Query

resubmitted Selon [EMAIL PROTECTED]: > hi, > that's the same. If you use between, mysql do the rest for you : > > mysql> explain SELECT * FROM passengers WHERE > -> reservation_date_time >= '2005-01-01 12:10:00' > -> AND reservation_date_time <= '2005-05-01 12:10:00'; > ++-

Re: MySQL (SQL) Newbie.. Need help with a Query

Sebastian wrote: Cory Robin wrote: I'm trying to return all records between two dates.. The fields are datetime fields... Which is better? The following or using BETWEEN? (A little lost here) SELECT * FROM passengers WHERE reservation_date_time >= '2005-01-01 12:10:00' AND reservation_date

Re: MySQL (SQL) Newbie.. Need help with a Query

Cory Robin wrote: I'm trying to return all records between two dates.. The fields are datetime fields... Which is better? The following or using BETWEEN? (A little lost here) SELECT * FROM passengers WHERE reservation_date_time >= '2005-01-01 12:10:00' AND reservation_date_time <= '2005-05-0

Re: mysql sql question

| | cc: | | Fax to: | |

Re: mysql sql question

Bruce, >i have two hypothetical tables >create table owner ( >-> name char(20) , >-> ownerid int(10) auto_increment primary key); >create table dog ( >-> name char(20) , >-> ownerid int(10), >-> dogid int(10) auto_increment primary key); >i'm curious as to how i'd go about in

Re: mysql sql files...

At 17:21 -0700 7/4/04, bruce wrote: hi.. i can run sql files that have sql statements by : shell:>mysql -u -p is there a way to run foo.sql if i'm already inside the mysql env... neither a search of google/mysql indicates that you can... You don't have to use Google. Just read the section on the

Re: mysql sql question

ql question > > > Hi, > > The insert says 'insert data in to two columns, name > and collegeid'. > > The select says "get two columns, 'tom' and id" - > 'tom' is a fixed value, the same for each row, and > id is taken from the test table.

RE: mysql sql files...

to clairfy it looks as though the "source" function/command allows you to use the script from inside the mysql env... disreagrd -bruce -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 5:22 PM To: [EMAIL PROTECTED] Subject: mysql sql files...

RE: mysql sql question

al Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:49 PM To: [EMAIL PROTECTED] Cc: MySQL (E-mail) Subject: RE: mysql sql question Hi, The insert says 'insert data in to two columns, name and collegeid'. The select says "get two columns, 'to

RE: mysql sql question

of the insert be derived from.. -bruce -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:41 PM To: [EMAIL PROTECTED]; Emmett Bishop; [EMAIL PROTECTED] Subject: RE: mysql sql question Hi, You've already specified some values, so you c

RE: mysql sql question

mysql> insert into dept (name,collegeid) -> select name, id from test where name="sammy"; -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 10:50 a.m. To: Quentin Bennett Subject: RE: mysql sql question i can't see how this would wor

RE: mysql sql question

to:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 10:41 a.m. To: 'Emmett Bishop'; [EMAIL PROTECTED] Subject: RE: mysql sql question i created the following as a simple test... mysql> describe test; +---+--+--+-+-+

RE: mysql sql question

7;t it be possible to extend the basic approach to multiple tables, using FROM tbl1, tbl2, tbl3.. - -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:26 PM To: 'Emmett Bishop'; [EMAIL PROTECTED] Subject: RE: mysql s

RE: mysql sql question

me = $ownername; -bruce -Original Message- From: Emmett Bishop [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: Re: mysql sql question Bruce, what you want it the insert into ... select statement. It's like this: insert into dog (name,

RE: mysql sql question

riginal Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 12:59 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mysql sql question At 12:54 -0700 7/4/04, bruce wrote: >hi... > >i have two hypothetical tables >create table ow

Re: mysql sql question

At 12:54 -0700 7/4/04, bruce wrote: hi... i have two hypothetical tables create table owner ( -> name char(20) , -> ownerid int(10) auto_increment primary key); create table dog ( -> name char(20) , -> ownerid int(10), -> dogid int(10) auto_increment primary key); i'm curious as

Re: MySQL SQL Case Stetement

The CASE function is documented in the manual . SELECT CASE WHEN other_col < 100 THEN 'low' WHEN other_col BETWEEN 100 AND 1000 THEN 'medium' WHEN other_col > 1000 THEN 'high' END AS col FROM your_table; Michael Ra

RE: MySQL SQL Case Stetement

I have used the CASE statement for ordering many times. It's very useful... SELECT myDATA, CASE WHEN data2 = SomeValue THEN 0 ELSE WHEN data2 = SomeOtherValue THEN 1 ELSE 2 END AS mySort from MyTable Where myConstraints. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web techno

Re: MySQL -- SQL syntax error.....

Try this: UPDATE BUSINESS_CATEGORY SET BUSINESS_CATEGORY.BUS_CAT = 'JUNKKK' ,BUSINESS_CATEGORY.BUS_DESC = 'JUNK123KK' WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788'

RE: MySQL -- SQL syntax error.....

From: Scott Fletcher [mailto:[EMAIL PROTECTED] > When I use this SQL statement, ... > > --snip-- > UPDATE BUSINESS_CATEGORY SET > (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = > ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788' > --snip-- > > I get the SQL syntax e

Re: MySql SQL Help

I can't suggest a complete solution but I think the answer is going to start with the week() function. See http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1403. You're lucky; figuring out which week a date belongs to was something I had to do in DB2 a few years back. The user was on an

Re: mySQL SQL Conversion

"Logan McKinley" <[EMAIL PROTECTED]> wrote: > I am using MySQL (4.0.17) and am getting errors with the following SQL > statement originally writen for MS products. > > SELECT > survey_questions.Question_ID, > First(survey_questions.Question_Text) AS FirstOfQuestion_Text, <== this line > returns e

Re: MySQL <-- SQL --> Oracle

> Folks, this is funny. > > I've been using Oracle for several months, and started teaching myself MySQL > since last weekend. I'm currently using the MySQL version 3.23.49 You might want to go get the latest if you can (4.0.14). > I found something really interesting: In Oracle, I have to crea

Re: MySQL <-- SQL --> Oracle

I found something really interesting: In Oracle, I have to create the Foreign Key in order to join 2 tables. It's quite different when I deal with MySQL. I can join two tables without creating the Foreign Key. - Is this Normal? Before learning MySQL, I thought both MySQL and Orcle use Structura

Re: MySQL <-- SQL --> Oracle

typo :( correct: in Oracle, one have to use single quotes to enclose those values which are going to be inserted. but in MySQL, doubl quotes do the job well. - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To: "Mysql List" <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 200

Re: MySQL sql query help

Ben Balbo wrote: Seems MySQL doesn't much like having nested joins in joins... Oops! Sorry about that. (Curse me for a MySQL novice! ) However, your principles led me to my result. As the search page will pass the class ids in anyway, I don't need to read these from the table. I.E. I pass the

Re: MySQL sql query help

Ben Balbo wrote: Teacher (id, name, ...) TeacherClass (teacherid, classid, timestamp) Class (id, name, ...) Now, what I'd really like to do it find all teachers who, for example, taught Engligh and Math, but not Biology, Here's a general, recursive, untested solution for you to play with. We st

RE: mysql - sql - auto-update cmd?

Seifuddin, Lamar T.* (LSEIFUDD); [EMAIL PROTECTED] Subject: RE: mysql - sql - auto-update cmd? Lamar, Why store that information? You'll be constantly updating your table. I do something similar keeping softball stats for my team. I just keep the raw data and do all calculations, i.e. batti

Re: mysql - sql - auto-update cmd?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Seifuddin, Lamar T.* (LSEIFUDD) wrote: | Hello All, | | I am using mysql on Linux - RedHat 7.1. | The basic stuff is simple, cool, too. | | I am a newbie, so forgive me if this is too simple a question. | | Is there a mechanism available somewhere in

RE: mysql - sql - auto-update cmd?

Lamar, Why store that information? You'll be constantly updating your table. I do something similar keeping softball stats for my team. I just keep the raw data and do all calculations, i.e. batting average, slg pct, winning pct, obp pct, etc. in the queries that generate the web pages or repor

Re: Re: MySQL - SQL

On Sat, 06 Apr 2002 [EMAIL PROTECTED] wrote : >Your message cannot be posted because it appears to be either >spam or >simply off topic to our filter. To bypass the filter you must >include >one of the following words in your message: > >sql,query > >If you just reply to this message, and incl

Re: Mysql & SQL

On Friday 07 September 2001 06:11 am, you wrote: > Giovanni Borri writes: > > hi all, > > > > i have a question. i would like to know if mysql has a sql'x' standard. > > my problem is that i would like to use UNION or MINUS or... but it seems > > not to work, another problem is that i would li

Re: Mysql & SQL

Giovanni Borri writes: > hi all, > > i have a question. i would like to know if mysql has a sql'x' standard. my > problem is that i would like to use UNION or MINUS or... but it seems not to > work, another problem is that i would like to make some nested query. > > by > thanks in advance.

Re: Mysql SQL behaviour with a plus sign

In the last episode (Jun 07), [EMAIL PROTECTED] said: > It looks like mySQL is funny about a + next to a - in a string. > > > If I do select count(*) from Table where Column like '%+---%' > I get 0 records. > If I do select count(*) from Table where Column like '%---%' > I get 70652 records. >