career advice - Excel Expert and MySQL SQL specialist

Hi I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work 5% of my job with SQL but I am searching for a full time SQL job. http://shop.oreilly.com/product/0790145363466.do Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a junior SQL pro job? What do

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

mysql/sql server migration

I'm involved with a project that is migrating data from sql server to mysql. The project will take up to a year to complete. During that period of time, we will need to synchronize data from sql server to mysql as we migrate windows based functionality to linux based servers. What is the rec

Re: good books or URL for mysql sql tunning

On Wed, Aug 13, 2008 at 7:30 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Can u please guide me to any good books or URL for mysql sql tunning.. http://www.highperfmysql.com/ - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: good books or URL for mysql sql tunning

this book are definitely key for large scaling applications. On Wed, Aug 13, 2008 at 7:30 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > Can u please guide me to any good books or URL for mysql sql tunning.. > > regards > anandkl > -- MySQL General Mailing

good books or URL for mysql sql tunning

Hi All, Can u please guide me to any good books or URL for mysql sql tunning.. regards anandkl

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

mysql sql query size limit

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

MySQL SQL statistics

Hello everyone: I want to get some SQL statistics including executions, CPU time for each SQL Statement. How can I get it from MySQL? regards, Gu Lei

Re: Differences Between ORACLE SQL PLus and MYSQL SQL

On Fri, 16 Sep 2005 10:32:23 -0400 [EMAIL PROTECTED] wrote: > You asked basically two questions: > > a) what are the differences between ORACLE SQL plus and MYSQL? > depends on how they are with MySQL already. One well-known point on how > MySQL and Oracle differ is in how to define a JOIN in

Re: Differences Between ORACLE SQL PLus and MYSQL SQL

Phong Nguyen <[EMAIL PROTECTED]> wrote on 09/15/2005 10:56:57 AM: > All, > > Could you please tell us what are the differences > between ORACLE SQL plus and MYSQL SQL? We developed > application using ColdFusion with Oracle. Now I like > to point my application to mysql

Re: Differences Between ORACLE SQL PLus and MYSQL SQL

Hi, > Could you please tell us what are the differences > between ORACLE SQL plus and MYSQL SQL? We developed "oracle sql plus" is a client side application to execute SQL statements. "oracle sql" is Oracles version of standard SQL (which is not standard) and "

Differences Between ORACLE SQL PLus and MYSQL SQL

All, Could you please tell us what are the differences between ORACLE SQL plus and MYSQL SQL? We developed application using ColdFusion with Oracle. Now I like to point my application to mysql database. How do I fix my application to work with Mysql? Thankyou

Differences Between ORACLE SQL PLus and MYSQL SQL

All, Could you please tell us what are the differences between ORACLE SQL plus and MYSQL SQL? Thank you :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: possible mysql/sql error...

ue Sanchez Vela [mailto:[EMAIL PROTECTED] Sent: Monday, August 01, 2005 7:21 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: possible mysql/sql error... Bruce, the shell is catching "system" and tries to execute whatever follows it, MySQL ignores it 100%. try using &#

RE: possible mysql/sql error...

> ignored...!!! > > hope this clarifies what i stated earlier... > > -bruce > > > > -Original Message- > From: bruce [mailto:[EMAIL PROTECTED] > Sent: Sunday, July 31, 2005 1:15 PM > To: mysql@lists.mysql.com > Subject: possible mysql/sql error

RE: possible mysql/sql error...

bruce [mailto:[EMAIL PROTECTED] Sent: Sunday, July 31, 2005 1:15 PM To: mysql@lists.mysql.com Subject: possible mysql/sql error... update... it appears that the 'system' word has to be at the beginning of a line in the comment for the error to occur! i'm willing to bet this is a

possible mysql/sql error...

update... it appears that the 'system' word has to be at the beginning of a line in the comment for the error to occur! i'm willing to bet this is a bug that hasn't been filed what are the odds that someone would run across it!! hi... i created the following simple test of sql for mys

possible mysql/sql error...

hi... i created the following simple test of sql for mysql. i included some comments that use the word 'system' in the comments. the comments are wrapped in the '/* ... */' delimiters.. i get an error stating 'sh: foo command not found.' i traced the error/msg to the fact that the word 'system' 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

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

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-01 12:10:00'; -- M

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

ob... You are correct. Good luck, --John > thanks > > -bruce > > > -Original 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 s

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

mysql sql files...

hi.. i can run sql files that have sql statements by : shell:>mysql -u -p http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

mysql sql question

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 to how i'd go about inserting a

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

d web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: Rafi Sheikh [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 12:21 PM To: '[EMAIL PROTECTED]' Subject: MySQL SQL Case Stetement Hi list. Can someone give me a working exampl

MySQL SQL Case Stetement

Hi list. Can someone give me a working example of a SQL CASE statement(in SELECT)? I have examples for stored procedures, but none for use within the DML side of SQL. I am trying to in my SELECT (used in PHP) create a variable/col for example: status='high' where value in a other col is withini

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

com> cc: Fax to: 06/16/200

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

MySQL -- SQL syntax error.....

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 error saying, --snip-- You have an error in your SQL syntax.

Re: MySql SQL Help

fferent modes supported by the week() function and make sure you pick the one that matches the rules in your environment. Rhino - Original Message - From: "Ramesh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 01, 2004 11:12 PM Subject: MySql SQL H

MySql SQL Help

Hi, Need a SQL/Design help. I have a table as follows: ORDER_HISTORY -- ORDER_ID | ORDER_NAME | ORDER_AMOUNT | ORDER_DATE -- 10 | Order 1| 20.00| 10-Jan-2003 11 | Order 2| 200.00 | 15-Jan-20

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

mySQL SQL Conversion

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 errors i believe it is the AS Avg(survey_responses.Response)

MYSQL (SQL ERROR)

Hi, I'm using Win2k,Apache,PHP(V4) and mysql . When I'm running php page ,noticing error " Notice: Undefined variable". Let me know how to fix pl? thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

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

> Sent: Wednesday, October 01, 2003 12:04 AM Subject: 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 > > I f

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 I found something really interesting: In Oracle, I have to create the Foreign Key in order to join 2 tables. It's quite different wh

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[2]: MySQL sql query help

Hi Bruce, Thanks for your reply. I just got the time to take a look at it, and it makes sense. However, for the first test: SELECT distinct t.name FROM Teacher t INNER JOIN (TeacherClass tc2 INNER JOIN Class c2 ON tc2.classid = c2.id AND c2.name = 'English') ON t.teacherid = tc2.teac

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

MySQL sql query help

Hi all, I've been trying to wrap my head round this problem for a few days now, and have plenty of pieces of scrap paper with lines and arrows and numbers to prove it. Anyway, here's the scenario: I have a table of teachers, and a table of classes. Any teacher can have taught any class, and any

MySQL sql query help

Hi all, I've been trying to wrap my head round this problem for a few days now, and have plenty of pieces of scrap paper with lines and arrows and numbers to prove it. Anyway, here's the scenario: I have a table of teachers, and a table of classes. Any teacher can have taught any class, and any

MySQL sql query help

Apologies if you now get this three times now, but I haven't received any copies through the mailing list yet, and the first 2 were sent 3 and 4 hours ago. I know email can go walkies for a few hours, but I've not been experiencing any other mail problems, either personally or in receiving MySQL m

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?

EMAIL PROTECTED] Subject: mysql - sql - auto-update cmd? 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 doing an "automated" update of a fi

mysql - sql - auto-update cmd?

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 doing an "automated" update of a field. example. team is a table. wins, losses, pct are fields

Re: newbie mysql-SQL question

* Laszlo G. Szijarto > I'm trying to run two tables with identical table structures into a single > continuous resultset. To simpify, I have one table with columns > ID int and > NAME varchar(32) and another table2 with columsn ID int and NAME > varchar(32), and each table has 100 items. How wou

newbie mysql-SQL question

Thank you in advance for your help. I'm trying to run two tables with identical table structures into a single continuous resultset. To simpify, I have one table with columns ID int and NAME varchar(32) and another table2 with columsn ID int and NAME varchar(32), and each table has 100 items. H

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

MySQL SQL question

Hello, I hope this isn't too far afield of the list discussions but here goes. I'm trying to fashion a query against a MySQL database. There are three tables that are relevant. They are: listing (ID, OfficeID, CatID, SubID, Visible, Deleted) category (ID, Name) subcategory (ID

MySQL SQL question

Hello, I hope this isn't too far afield of the list discussions but here goes. I'm trying to fashion a query against a MySQL database. There are three tables that are relevant. They are: listing (ID, OfficeID, CatID, SubID, Visible, Deleted) category (ID, Name) subcategory (ID

MySQL,sql my unscribe info appears in mail

database,sql,query,table > 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: > > database,sql,query,table > > If you just reply to this message, and include

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.

Mysql & SQL

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

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

Mysql SQL behaviour with a plus sign

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. How can I make it insensitive to a +- Thanks in advance. Piyush.

Re: 2-way replication in MySQL (sql)

On Fri, May 11, 2001 at 11:50:27AM -0600, Joseph Chow wrote: > Hi, everyone, > > This is my another question. I have one master server and one slave > server now. In case that the master is down for any reason, I want > the slave still accessible by clients. Is that possible in my SQL? Yes.

2-way replication in MySQL (sql)

Hi, everyone, This is my another question. I have one master server and one slave server now. In case that the master is down for any reason, I want the slave still accessible by clients. Is that possible in my SQL? by two way replications? This problem seems quiet complicated to me. Please

a mysql SQL question

a mysql SQL question - I am programming a TV guide script and I am getting stuck 1) Admin must be able to add tv listings to a database using a form at http://1001cgi.hypermart.net/project1/admin2.html Please IGNORE all the form fields above "Start date - (mm/dd