Re: Query SUM help

to SUM the top 11 players from each team. Any suggestions ? > > Cheers > Neil > > > On Thu, Sep 9, 2010 at 9:17 AM, Ananda Kumar wrote: > >> did u try to use LIMIT after ORDER BY >> >> >> On Thu, Sep 9, 2010 at 1:27 PM, Tompkins Neil < >> nei

Re: Query SUM help

1:27 PM, Tompkins Neil < > neil.tompk...@googlemail.com> wrote: > >> Any help would be really appreciated ? >> >> >> >> -- Forwarded message -- >> From: Tompkins Neil >> Date: Wed, Sep 8, 2010 at 5:30 PM >> Subject

Re: Query SUM help

did u try to use LIMIT after ORDER BY On Thu, Sep 9, 2010 at 1:27 PM, Tompkins Neil wrote: > Any help would be really appreciated ? > > > > -- Forwarded message -- > From: Tompkins Neil > Date: Wed, Sep 8, 2010 at 5:30 PM > Subject: Query SUM help &

Fwd: Query SUM help

Any help would be really appreciated ? -- Forwarded message -- From: Tompkins Neil Date: Wed, Sep 8, 2010 at 5:30 PM Subject: Query SUM help To: "[MySQL]" Hi I've the following query : SELECT total_team_rating, my_teams_id FROM (SELECT players.teams_id AS m

Query SUM help

Hi I've the following query : SELECT total_team_rating, my_teams_id FROM (SELECT players.teams_id AS my_teams_id, SUM(players_master.rating) AS total_team_rating FROM players INNER JOIN players_master ON players.players_id = players_master.players_id WHERE players.worlds_id = 1 AND players.red_ca

Re: Query help

;>> fixtures_results_id >>>> home_teams_id >>>> away_teams_id >>>> home_goals >>>> away_goals >>>> home_users_id >>>> away_users_id >>>> >>>> From this I want to extract the following type of information if

Re: Query help

m this I want to extract the following type of information if >>> the home_users_id or away_users_id = 1 : >>> >>> total number of games games >>> number of games won >>> number of games drawn >>> number of games lost >>> number of goals scored >>> number of goals conceded >>> biggest win >>> biggest loss >>> most goals in a game >>> >>> I'd appreciate any help with regards the query and whether or not it is >>> possible to do ? >>> >>> Cheers >>> Neil >>> >> >> >

Re: Query help

want to extract the following type of information if >> the home_users_id or away_users_id = 1 : >> >> total number of games games >> number of games won >> number of games drawn >> number of games lost >> number of goals scored >> number of g

Re: Query help

; number of goals conceded > biggest win > biggest loss > most goals in a game > > I'd appreciate any help with regards the query and whether or not it is > possible to do ? > > Cheers > Neil >

Query help

umber of games won number of games drawn number of games lost number of goals scored number of goals conceded biggest win biggest loss most goals in a game I'd appreciate any help with regards the query and whether or not it is possible to do ? Cheers Neil

Re: Database design help

il: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: Tuesday, August 31, 2010 3:48 PM To: mysql@lists.mysql.com Subject: Database design help Hi I've a soccer application consisting of managers, teams

Re: Database design help

60.674.8796 / FAX: 860.674.8341 > E-mail: je...@gii.co.jp > Web site: www.the-infoshop.com > > >-Original Message- > >From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] > >Sent: Tuesday, August 31, 2010 3:48 PM > >To: mysql@lists.mysql.com > >Subjec

RE: Database design help

t;From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] >Sent: Tuesday, August 31, 2010 3:48 PM >To: mysql@lists.mysql.com >Subject: Database design help > >Hi > >I've a soccer application consisting of managers, teams players and >fixtures/results. Basically each man

RE: Database design help

ssage- From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: 01 September 2010 12:52 To: [MySQL] Subject: Fwd: Database design help Looking for some help / comments if possible ? Cheers Neil -- Forwarded message -- From: Neil Tompkins Date: Tue, Aug 31, 2010 at 8:48 PM Su

Re: Database design help

think this few lines can trigger the best idea in you. Claudio 2010/9/1 Tompkins Neil > Looking for some help / comments if possible ? > > Cheers > Neil > > -- Forwarded message -- > From: Neil Tompkins > Date: Tue, Aug 31, 2010 at 8:48 PM > Subject

Fwd: Database design help

Looking for some help / comments if possible ? Cheers Neil -- Forwarded message -- From: Neil Tompkins Date: Tue, Aug 31, 2010 at 8:48 PM Subject: Database design help To: mysql@lists.mysql.com Hi I've a soccer application consisting of managers, teams players and fix

Database design help

Hi I've a soccer application consisting of managers, teams players and fixtures/results. Basically each manager will get points for each game which will depend on the result. What would be the best table design bearing in mind that a manager can move to a different club. My thought was

RE: replication help

@lists.mysql.com Subject: replication help hello, i had a master-master replication now one of the masters seems to be about two days ahead of the slave how do i make the first server in sync with the second and force any data added to the second master to be pushed back into the first server. thanks

replication help

hello, i had a master-master replication now one of the masters seems to be about two days ahead of the slave how do i make the first server in sync with the second and force any data added to the second master to be pushed back into the first server. thanks -- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝ

Re: query help

-- From: "Steven Buehler" Sent: Friday, August 20, 2010 3:30 PM To: Subject: query help I am hoping that I can do this with one query, I have a table, "Domains" with 3 columns accountID, domainID, mailname what I am trying to do is find

query help

quot;accountID,mailname". If it doesn't exist, I want it to insert another row with the same accountID and mailname, but with the second (54321) domainid. Any help would be appreciated. Thanks Steve

Re: Seems like an easy query, but isn't to me. Help?

On 8/19/2010 8:45 PM, George Larson wrote: I hope I've come to right place, and I'm asking in the right way -- please accept my apologies if not. We have some dates missing and I need to populate those fields with dates from the record just before them. I've gotten this far: SELECT UUid, MIN(D

Re: Seems like an easy query, but isn't to me. Help?

On 20/08/2010 2:45 a, George Larson wrote: I hope I've come to right place, and I'm asking in the right way -- please accept my apologies if not. We have some dates missing and I need to populate those fields with dates from the record just before them. I've gotten this far: SELECT UUid, MIN(D

Seems like an easy query, but isn't to me. Help?

I hope I've come to right place, and I'm asking in the right way -- please accept my apologies if not. We have some dates missing and I need to populate those fields with dates from the record just before them. I've gotten this far: SELECT UUid, MIN(DDenteredDate) minDate FROM UUtable JOIN DDdet

Re: help with replication

thanks On Wed, Aug 18, 2010 at 10:42 PM, wrote: > Quoting Norman Khine : > > >>> >>> What is shown from "show master status" and "show slave status" after you >>> have made a change on the master DB? >> >> this is the output: >> >> http://pastie.org/1100610 >> >> it does not seem to have any cha

Re: help with replication

Quoting Norman Khine : What is shown from "show master status" and "show slave status" after you have made a change on the master DB? this is the output: http://pastie.org/1100610 it does not seem to have any changes and "show slave status" is just empty. have i missed to add something to

Re: help with replication

hi On Wed, Aug 18, 2010 at 8:00 PM, wrote: > Quoting Norman Khine : > >> hello, >> i have an issue with the replication here is my procedure: >> >> http://pastie.org/1100368 >> >> in the log it shows replication works, but when i update a record this >> is not updated on the server. > > What is

Re: help with replication

Quoting Norman Khine : hello, i have an issue with the replication here is my procedure: http://pastie.org/1100368 in the log it shows replication works, but when i update a record this is not updated on the server. What is shown from "show master status" and "show slave status" after you

help with replication

hello, i have an issue with the replication here is my procedure: http://pastie.org/1100368 in the log it shows replication works, but when i update a record this is not updated on the server. any help much appreciated. -- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ &#x

Help with flush logs

Hi, This is probably very simple for someone who has encountered the problem before but I'm struggling to find how I can contain the MySQL error log from being flushed at "FLUSH LOGS" command. This command is executed as part of the database backup every night and simply moves the old error log

might need some help recovering tables from trashed DB

i asked about this once upon a time, and might need a little more help here. a friend's mysql hosting provider lost an entire DB, but has managed to recover and hand over the "ibdata1" file (or at least some portion of it). when my friend popped into mysql, what he's se

Re: Need Help Writing Simple Query

t 1) as name_2 > from test1; > > - test1 table: > col1v_idh_id > America 1 2 > > - test2 table: > id name > 2 SAM > 1 UNCLE > > - Original Message - > From: "Mark Phillips" > To: "Mysql List" >

Re: Need Help Writing Simple Query

On 07/25/2010 09:29 PM, Mark Phillips wrote: I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two tables. Table 1 has many columns, two of which are hID and vID. Table 2 has two columns, ID and name. The hID and vID in table 1 correspond to the I

Re: Need Help Writing Simple Query

SAM 1 UNCLE - Original Message - From: "Mark Phillips" To: "Mysql List" Sent: Monday, July 26, 2010 8:29:00 AM Subject: Need Help Writing Simple Query I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two

Need Help Writing Simple Query

I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two tables. Table 1 has many columns, two of which are hID and vID. Table 2 has two columns, ID and name. The hID and vID in table 1 correspond to the IDs in table 2. I want to make a query so I get

Re: Help me

On 21/07/2010 16:33, Karthik Pr wrote: I have created a table as follows but i was not able to use full text search on a specific data. create table racebike (id int auto_increment not null primary key, name varchar(10), user text,fulltext(name,user)); [snip] The query is mysql> select * fro

Help me

I have created a table as follows but i was not able to use full text search on a specific data. create table racebike (id int auto_increment not null primary key, name varchar(10), user text,fulltext(name,user)); The table is as follows, ++-+-+ | id | name|

Re: Query Help

Table 1 Product_id | Product_Name 1| Product A 2| Product B 3| Product C Table 2 Category_id | Category_Name 1 | Admin 2 | Marketing 3 | Support 4 | IT Table 3 Product_id

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

I believe you're describing a crosstab query. This should help you put it together: http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html ---Michael On Friday, July 09, 2010 07:37:41 pm Phillip Baker wrote: > Hello All, > > > For the life of me I cannot remem

Query Help

Hello All, 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

RE: query help

Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > From: rich...@rushlogistics.com > To: joerg.bru...@sun.com; mysql@lists.mysql.com > Subject: Re: query help >

Re: query help

Thank you very much for all the insightful replies. I think I can get it to work with a join. Joerg Bruehe wrote: > > Hi! > > > Jay Blanchard wrote: > > [snip] > > I have a table similar to this: > > > > - > > |transactions | > > |ID |DATE |

Re: query help

Hi! Jay Blanchard wrote: > [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 gi

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: query help

don't have a match is your answer. Regards, Gavin Towey -Original Message- From: Richard Reina [mailto:rich...@rushlogistics.com] Sent: Tuesday, June 15, 2010 11:30 AM To: mysql@lists.mysql.com Subject: query help I have a table similar to this: - |tr

query help

have a transaction? Thanks for the help. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Help needed on query on multiple tables

I am glad that I was able to help someone finally :) There may be other ways to do this, but that was what first came to mind. I would maybe run an explain on that query to ensure that it is using indexes. Steven Staples > -Original Message- > From: Michael Stroh [mai

Re: Help needed on query on multiple tables

aybe something like this could give you a > starting point? > > Steven Staples > > >> -Original Message- >> From: Michael Stroh [mailto:st...@astroh.org] >> Sent: June 3, 2010 11:24 AM >> To: MySql >> Subject: Help needed on query on multiple

RE: Help needed on query on multiple tables

nt: June 3, 2010 11:24 AM > To: MySql > Subject: Help needed on query on multiple tables > > Hi everyone. I'm trying to create a certain MySQL query but I'm not sure > how to do it. Here is a stripped down version of the result I'm aiming for. > I'm pretty new

Help needed on query on multiple tables

Hi everyone. I'm trying to create a certain MySQL query but I'm not sure how to do it. Here is a stripped down version of the result I'm aiming for. I'm pretty new to queries that act on multiple tables, so apologize if this is a very stupid question. I have one table (data) that has two column

Re: Anyone can help resolve this problem?

But when I clear MySQL root password, > everything goes well. I don't know that why. For security, Idon't want keep > the empty password for production service. Anyone can help me to resolve it? > Im just guessing but, did you flush the privileges ? maybe the change have no ta

答复: Re: Anyone can help resolve this problem?

Touch Diamond2 - 原始邮件 - 发件人: Rob Wultsch 发送时间: 2010年5月31日 星期一 11:09 收件人: Lancer ; mysql@lists.mysql.com 主题: Re: Anyone can help resolve this problem? This seems like a wordpress problem, not mysql. On 5/30/10, Lancer wrote: > Hi there. Sorry for my poor english. > Iinstalle

Re: Anyone can help resolve this problem?

lishing adatabase connection'. But when I clear MySQL root password, > everything goes well. I don't know that why. For security, Idon't want keep > the empty password for production service. Anyone can help me to resolve > it? > Btw, phpbb using mysql (not mysqli, it no

Anyone can help resolve this problem?

l. I don't know that why. For security, Idon't want keep the empty password for production service. Anyone can help me to resolve it? Btw, phpbb using mysql (not mysqli, it normal working) extension, phpbb will return error message like 'Access Denied for r...@localhost (using pas

Re: Query Help!

Not tested, but I think it can help you or at least give you an ideia on how to do it. select EndDateTime + INTERVAL 1 SECOND as startLazy, (select StartDateTime - INTERVAL 1 SECOND from table t2 where t2.StartDateTime > t1.EndDateTime limit 1) as endLazy from table t1 where (sel

Re: Query Help!

6:49:21 > 12010-02-26 16:49:27 2010-02-26 16:49:55 > > *I can see the system was free between 16:45:57 and 16:47:01 on 26th > February 2010 and this is what I would need the query to return only > working > with a lot more data. Any ideas? > > Thank you in adva

Query Help!

system was free between 16:45:57 and 16:47:01 on 26th February 2010 and this is what I would need the query to return only working with a lot more data. Any ideas? Thank you in advance for any help, suggestions. This is currently on a MySQL 5.1 system. Regards -- John Daisley Certified M

Re: Need help with query optimization

It may only be returning 51 rows but its having to read significantly more. Get rid of the derived table join if possible. Something like SELECT TAP.ID , M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State, TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType,

Re: Need help with query optimization

Can you please show us the indexes on both the tables. regards anandkl On Tue, Mar 16, 2010 at 11:47 PM, Jesse wrote: > I have the following query: > > SELECT TAP.ID , M.UID, TAP.FirstName, TAP.MI, > TAP.LastName, TAP.State, > TAP.SchoolName, TAP.StateApproved, TAP.DiplomatAppro

Need help with query optimization

I have the following query: SELECT TAP.ID, M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State, TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType, S.Region, S.District,Pts.TotPoints FROM TorchAwardParticipants TAP JOIN Members M On M.ID=TAP.CurrentMemberID JOIN Chapters

Re: Help with the World.sql sample database

On Feb 11, 2010, at 11:47 AM, kebede teferi wrote: > Could any one lead me to a true link where I can download the world.sql > sample database? Thanks. Go to: http://dev.mysql.com/doc/ Click on the "Other Docs" tab to get to: http://dev.mysql.com/doc/index-other.html You'll see an entry fo

Re: Help with the World.sql sample database

On 2/11/2010 11:47 AM, kebede teferi wrote: Could any one lead me to a true link where I can download the world.sql sample database? Thanks. http://dev.mysql.com/doc/index-other.html Carlos Proal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Help with the World.sql sample database

Could any one lead me to a true link where I can download the world.sql sample database? Thanks.

RE: help me out for this scenario

>-Original Message- >From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com] >Sent: Thursday, February 11, 2010 12:52 AM >To: mysql@lists.mysql.com >Subject: help me out for this scenario > >I have a table like as follws > > > >Emp_id, first_login , se

help me out for this scenario

Whats the query if first loin and second login were from two different tables.

help me out for this scenario

8 >From this I need a table like Month, First_total(count(emp_id)), second_total(count(emp_id)) In first and second login the employee id will be consider only one time.. Please help me for this. thanks in advance

RE: query help

SELECT ID, check_no, amount FROM payables UNION SELECT ID, check_no, amount FROM paychecks; Regards, Gavin Towey -Original Message- From: Richard Reina [mailto:rich...@rushlogistics.com] Sent: Tuesday, February 09, 2010 9:23 AM To: mysql@lists.mysql.com Subject: query help I am trying

query help

|498.00 | 34 |3502|767.00 | 36 |3504}754.00 | Any help would be greatly appreciated. Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Help optimizing settings?

In general you need to adjust your server settings to actually use the new RAM. This depends on various things, storage engines used, what else runs on the box, etc. In addition you should look at your schema, see if you have the right indices for what you want to do. E.g. All columns that you u

RE: Help optimizing settings?

Which MySQL server do you use? What is your storage engine? -Original Message- From: Ken D'Ambrosio [mailto:k...@jots.org] Sent: Friday, February 05, 2010 5:26 PM To: mysql@lists.mysql.com Subject: Help optimizing settings? I've got a fairly large -- 100+ GB -- MySQL dat

Re: Help optimizing settings?

Using "load index" might help, but you'll have to make sure you allocate plenty of space to your keycache. If the queries are identical, the query cache might also be a good candidate, but that seems unlikely. The memory will also be used by your OS to cache often-used parts of

Help optimizing settings?

I've got a fairly large -- 100+ GB -- MySQL database. It isn't accessed often -- it's acting more as an archive right now than anything else. That being said, when it does get accessed, the indeces seem to take forever to load. Being as I just bumped the RAM from 2 GB to 6 GB, what, generically,

Re: help me out for this problem...

See this link. Might me help for you http://answers.yahoo.com/question/index?qid=20070309043307AATLe9k On 5 February 2010 17:46, misiaQ wrote: > Instead of: > -> else 2003 > >-> where id between 1 and 6; > Try >-> else 2003 >-> end >

RE: help me out for this problem...

-> end -> where id between 1 and 6; Good luck! Regards, m -Original Message- From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com] Sent: Friday, February 05, 2010 12:04 PM To: mysql@lists.mysql.com Subject: help me out for this problem... Here I have to update

help me out for this problem...

Here I have to update year column with reference to the row id mysql> update table1 -> set year=case when id=1 then 2000 -> when id=2 then 2001 -> when id=3 then 2000 -> when id=4 then 2001 -> when id=5 then 2000 -> when id=6 then 2001 -> else 2003

Re: help me regarding how to use cursor and handler

those.. > if any body familiar with those.. please help me.. > > thnaks in advance > by > Muralikrishna > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel

help me regarding how to use cursor and handler

hi.. i like to know really what is a cursor and a handler and those functionality and purpose... i have tried much over net... but i didnt find proper material and examples for those.. if any body familiar with those.. please help me.. thnaks in advance by Muralikrishna

Re: help about the charset

On Wed, Feb 3, 2010 at 6:33 PM, Thiyaghu CK wrote: > Hi Moli, > > I hope this is because there is spelling mistake. It should be > '--with-extra-charsets=all', but you have given > '--with-extral-charsets=all'. That's why only the utf8 has been installed > and not the other charsets. > Thanks a

Re: help about the charset

Hi Moli, I hope this is because there is spelling mistake. It should be * '--with-extra-charsets=all'*, but you have given '--with-*extral*-charsets=all'. That's why only the utf8 has been installed and not the other charsets. Regards, Thiyaghu CK www.mafiree.com On Wed, Feb 3, 2010 at 2:26 PM,

help about the charset

Hello, I have a strange problem on the charset on mysql. I'm using mysql-5.0.45, compiled from the source, and enabled: '--with-charset=utf8' '--with-extral-charsets=all' when compiling it. My default charset in my.cnf is utf8: character-set-server=utf8 OK I logined into mysql and run: mysql>

RE: hi help to take backup-mysql-windows-xp

IPAQ mobile device -Original Message- From: muralikrishna g Sent: 02 February 2010 06:45 To: mysql@lists.mysql.com Subject: hi help to take backup-mysql-windows-xp hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by

RE: hi help to take backup-mysql-windows-xp

nal Message- From: sureshkumar...@gmail.com [mailto:sureshkumar...@gmail.com] Sent: Tuesday, February 02, 2010 12:22 PM To: muralikrishna g Cc: mysql@lists.mysql.com Subject: Re: hi help to take backup-mysql-windows-xp Hi Murali, You have to execute it outside mysql prompt i.e command pro

Re: hi help to take backup-mysql-windows-xp

Hi Murali, You have to execute it outside mysql prompt i.e command prompt. Thanks Suresh Kuna MySQL DBA Sent from BlackBerry® on Airtel -Original Message- From: muralikrishna g Date: Tue, 2 Feb 2010 12:17:24 To: Suresh Kuna Cc: Subject: Re: hi help to take backup-mysql-windows-xp hi

Re: hi help to take backup-mysql-windows-xp

hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name > backup.sql; but i am getting error.. i am using windows xp system.. please help me mysql> mysqldump -u root -p d

Re: hi help to take backup-mysql-windows-xp

-u name -p password database_name > backup.sql; > > but i am getting error.. i am using windows xp system.. please help me > -- Thanks Suresh Kuna MySQL DBA

hi help to take backup-mysql-windows-xp

hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name > backup.sql; but i am getting error.. i am using windows xp system.. please help me

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

Give the ful path of file name with in '' and try it out Thanks Suresh Kuna MySQL DBA --Original Message-- From: Colin Streicher To: mysql@lists.mysql.com Cc: kebede teferi ReplyTo: co...@obviouslymalicious.com Subject: Re: I NEED HELP ON 'SOURCE(\.) MYSQL Sent: Feb 2, 201

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

what everyone else said... also, is there a longer version of the error? or is it literally error 2 or error 22? Colin On February 1, 2010 06:38:08 pm kebede teferi wrote: > Hi, I'm very new to this and I need help. > > What I want to do is to execute a source command stateme

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

Error 2 is "No such file or directory" So, probably the file is not in the right path or you need to explicitly provide the path to the file. Carlos On 2/1/2010 5:38 PM, kebede teferi wrote: Hi, I'm very new to this and I need help. What I want to do is to execute a

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

On 02/01/2010 06:38 PM, kebede teferi wrote: Hi, I'm very new to this and I need help. What I want to do is to execute a source command statement from cmd to create tables and populate them on a data base that I created in Mysql. Here is what I did at CMD: *I changed the directory f

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

How did you type the source command? Did you remember not to quote the file name? E.g. mysql> SOURCE schema.sql is the correct way. Jesper On Tue, 2 Feb 2010 10:38:08 kebede teferi wrote: > Hi, I'm very new to this and I need help. > > What I want to do is to execute

I NEED HELP ON 'SOURCE(\.) MYSQL

Hi, I'm very new to this and I need help. What I want to do is to execute a source command statement from cmd to create tables and populate them on a data base that I created in Mysql.  Here is what I did at CMD: *I changed the directory from c:\> to mysql *At mysql prompt i used -u

Help with a crash

Running 5.1.34 on XP Box has been working for form some time, however last night it asserted out. I've attached the log output, below. I've taken the query, that is listed, and run it without any trouble -- its only issue being that it could use some rewriting. I'd greatly appr

Re: Quick help with Insert

; a.lieferant = b.lieferant > where > b.lieferant is null > > > > > -Ursprüngliche Nachricht- > Von: Carlos Proal [mailto:carlos.pr...@gmail.com] > Bereitgestellt: Dienstag, 19. Jänner 2010 20:15 > Bereitgestellt in: gmane.comp.db.mysql.general > Un

Re: Quick help with Insert

...@gmail.com] Bereitgestellt: Dienstag, 19. Jänner 2010 20:15 Bereitgestellt in: gmane.comp.db.mysql.general Unterhaltung: Quick help with Insert Betreff: Re: Quick help with Insert Hi !! You need a left join and then an insert. Please read: http://dev.mysql.com/doc/refman/5.1/en/join.html or google

Re: Quick help with Insert

an answer? THX -Ursprüngliche Nachricht- Von: Intell! Soft [mailto:intellis...@fachoptiker.net] Bereitgestellt: Donnerstag, 14. Jänner 2010 17:40 Bereitgestellt in: gmane.comp.db.mysql.general Unterhaltung: Quick help with Insert Betreff: Quick help with Insert Hey I would need quick h

Re: Quick help with Insert

Hey Not really quick ;> - But nobody knows an answer? THX -Ursprüngliche Nachricht- Von: Intell! Soft [mailto:intellis...@fachoptiker.net] Bereitgestellt: Donnerstag, 14. Jänner 2010 17:40 Bereitgestellt in: gmane.comp.db.mysql.general Unterhaltung: Quick help with Insert Betr

Re: myslqd_safe & is not starting. pls help

ce started... thanks again.. Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Thu, Jan 14, 2010 at 4:13 PM, Joerg Bruehe wrote: > Hi Faizal, all! > > > F.A.I.Z.A.L wrote: > > hi > > > > anyone can help. its urgent. iam trying to start mysql serve

Re: myslqd_safe & is not starting. pls help

Hi Faizal, all! F.A.I.Z.A.L wrote: > hi > > anyone can help. its urgent. iam trying to start mysql server but it is not > starting. Just read the output: > > bash-2.03# ./mysqld_safe & > [2] 3422 > bash-2.03# Starting mysqld daemon with databases from /usr/local

<    1   2   3   4   5   6   7   8   9   10   >