Re: Access denied/password change

dev.mysql.com/doc/mysql/en/access-denied.html http://dev.mysql.com/doc/mysql/en/resetting-permissions.html Seena Blace <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 8bit, charset: iso-8859-1, 17 lines --] > > Hi, > > I have been noticing follow

Access denied

Hi, I have been noticing following error when trying to connect mysql. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) or ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) What could be reason? Is there any way I can connect to databa

Re: QUERY (TOP)

E rank <= 10 gives the top ten ordering customers per year, as expected. So I am unclear why the algorithm does not work for your spam table. PB - Seena Blace wrote: Peter here u go.just a few.You may see sample report. 2005-05-05 | 1108529 |

CONCAT

hi, how to concat 2 columns to display in report? select column1concat column2 form table1; Concatenation Operator pl? thanks - Discover Yahoo! Stay in touch with email, IM, photo sharing & more. Check it out!

Re: QUERY (TOP)

th the results and explain to me what's wrong so I can fix it. Thank you for your patience, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace wrote on 05/16/2005 04:41:19 PM: > Shawn, > query > SELECT * > FROM spam_stats > WHERE rank <= 10;

Re: QUERY (TOP)

. thanks [EMAIL PROTECTED] wrote: Seena Blace wrote on 05/16/2005 11:13:48 AM: > shawn > I think 2nd query will return only 10 rows. > I want out like followings > date domain spam > 05/05/05 hotmail.com 120 > 05/05/05 yahoo.com 110 > 05/05/05 abc.com 99 > 05/05/05 d

repair table/close table ?????

Hi, Here is what I see. mysql> check table report_1; +---+---+--++ | Table | Op| Msg_type | Msg_text | +---+---+--+---

Re: select count(*) table

just give a it try select count(columnname) from table; Eric Bergen <[EMAIL PROTECTED]> wrote:select count(*) table; gives me a syntax error in 4.0 and 4.1 so I'm not sure how that worked. Something similar would be select count(*) t; which uses the shortcut alias syntax. It's the same as doing

Re: QUERY (TOP)

..like that upto 10 Each day there are multiple entry from diffrent domains or same domain. I want each day whatever top 10 spam sender domain. thanks [EMAIL PROTECTED] wrote: Seena Blace wrote on 05/16/2005 10:08:15 AM: > Any suggestion pl? > > Seena Blace

output in text file /migration

Hi, I want to migrate 1 table from MYSQL to oracle ? how to do that ? How to get output of table into text file? thanks . - Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone.

Re: QUERY (TOP)

Any suggestion pl? Seena Blace <[EMAIL PROTECTED]> wrote:hi, here is table description report1 +-+--+--+-+-++ | Field | Type | Null | Key | Default |

QUERY (TOP)

hi, here is table description report1 +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-

TOP N record

Hi, how to get top N records from table ? columns of table id date1 process wip worm I need output date1 process wip worm 5/5/05 5/6/05 5/7/05 thanks - Do you Yahoo!? Yahoo! Mail - Find

Re: Report(query)

ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using date_format(nameofcolumn,'%Y-%m-%d')? Harald Fuchs <[EMAIL PROTECTED]> wrote: In article <[EMAIL

RE: table optimisation

How to check whae are tables are having how many indexes on which columns ? Thomas Sundberg <[EMAIL PROTECTED]> wrote: > -Original Message- > From: Seena Blace [mailto:[EMAIL PROTECTED] > Sent: den 11 maj 2005 23:58 > To: mysql@lists.mysql.com > Subject: table opti

Report(query)

Hi, I want report like this Table description is like as follows Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(

table optimisation

Hi, I have been noticing table performanace issue when # of rows grows more.How to tune that table? thanks -Seena - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard.

MIGRATION OF DATABASE FROM ONE BOX TO ANOTHER BOX

Hi, How to migrate mysql database from one box to another box ? thanks -Seena - Do you Yahoo!? vote.yahoo.com - Register online to vote today!

AUTO_INCREMENT

Hi, Is there any way AUTO_INCREMENT column cann't me Primary key ? One table has one column auto_increment which I want to convert into non primary key but I also want to maintain the column.How to do that? thanks - Do you Yahoo!? vote.yahoo.c

MYSQL CONNECT ISSUE

I have been getting following error. [polaris] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) How to fix that? What is default port for mysqlserver? thx -seena - Do you Yahoo!? New and Improved Yahoo! Mail - 100MB f

Table dump into binary

into valid Oracle statements. Other than that, I think that you would need to periodically poll the MySQL server for changes and duplicate them into your Oracle server. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace wrote on 09/01/2004 12:30:12 PM: > Hi, >

Re: Database connectivity

Hi, I wanted to setup connectivity between mysql database and oracle database.I have one database in mysql from which all tables data I want to insert real time data into oracle database.How to connect mysql database with oracle database? thanks -

Database connectivity

Hi, I wanted to copy setup some procedure which pickup data from mysql and load into oracle database.How to do this? I would also like to know how to establish a connection between mysql and oracle database? thanks - Do you Yahoo!? Win 1 of 4,00

Connectivity

Hi, I have one mysql database and one oracle database.I want to fetch data from mysql db to oracle db in realtime.How to do this? I also wanted to tarnsfer 14 tables from one mysql database to Oracle how to do this? thanks - Do you Yahoo!? New and

Re: MYSQLOUTPUT

<[EMAIL PROTECTED]> wrote: Are you just wanting to remove the header information? If so, then try mysql --skip-column-names On Thu, 01 Apr 2004, Seena Blace wrote: > > Hi, > > I'm getting output like > > select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.versio

MYSQLOUTPUT

Hi, I'm getting output like select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from host a,ipdet_temp1 b,makemodel c,software d,hsdet e -> where a.hostid=b.hostname2 and a.makemodel=c.makemodelid and a.hostid=e.host_id and e.software_id=d.softwareid and a.hostid='dstm-db01

Re: ORDER BY WITH NO PRINT

Seena Blace <[EMAIL PROTECTED]> wrote:Hello, I want to show outpur like this? Group hostname details aa abababa aa abababababab aa anannanananna bb llololololool bb ssjjsjsjsjjsjsj Select group,hostname,details from table1 order by group; I wa

ORDER BY WITH NO PRINT

Hello, I want to show outpur like this? Group hostname details aa abababa aa abababababab aa anannanananna bbllololololool bbssjj

How to prompt variable

Hi, i want to update couple of columns like update tablename set = where columname=; I want to run query on mysql prompt each time and enter value1 and value2 for diffrent columnname ? Value1 and value2 will be diffrent. in oracle we use & to prompt value. thx Do you Yahoo!? Yahoo! Finance Tax C

PHP and Mysql

Hi, Does any one help me in formating the output result in PHP with mysql? The code is here. Host Details $today"; $i=0; while ($i < $num) { $hostid=mysql_result($result,$i,"hostid"); $hostname=mysql_result($result,$i,"hostname"); $cabinetnumber=mysql_result($result,$i,"cabinetnumber"); echo "$h

Migration from windows to linux red hat

Hi, I have 10 tables which I want to migrate from windows mysql(V4.0.17) to red hat mysql(V3.23.54).How to do that pl? Some tables are having real data also. thx -seena - Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online

COMPOSITE PRIMARY KEY?

Hi, I want to create a table with composite Primary key.How to do that? create table ipdet (IPaddress varchar (14) not null , hostid varchar (20) not null primary key (ipaddress,hostid), IP_DESC text , MAC text, interface text); thx-seena - Do y

HOW TO RUN SQL

utch community for helping newcomers on the hackerscene mrtg.grunn.org Dutch mirror of MRTG -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: maandag 9 februari 2004 22:14 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] HOW TO RUN SQL and

HOW TO RUN SQL and default value ?

Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the extention of that query? I want to create on column which contains only default value TRUE or False.how to do tha

Re: PHP AND MYSQL

s from post like: $softwareid = $_POST["softwareid"]; $manufacturer = $_POST["manufacture"]; etc, etc... Plus...are you able to connect to the db server? Use: mysql_connectd("$host", "$username", "$password"); -- Jason On Mon, 2004-02-02 at 16:07,

PHP AND MYSQL

Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please help me. When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable: like this.Can some one please send some tips pl? Html code: Software id: Manufacturer: Name: Version: Let m

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-discussions] SQL CONNECTIVITY

comers on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:12 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] SQL CONNECTIVITY Hi all, I have been noticing following error message with PHP.

RE: [Mysql-discussions] SQL CONNECTIVITY

[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:12 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] SQL CONNECTIVITY Hi all, I have been noticing following error message with PHP. Fatal error: Call to undefined function: mysql_connect() Let me know how to fix that.I have ins

SQL CONNECTIVITY

Hi all, I have been noticing following error message with PHP. Fatal error: Call to undefined function: mysql_connect() Let me know how to fix that.I have installed linux9,apache 2.0, php. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building t

Re: MYSQL Database

Which version of PHP would be good for Red hat 7.3? can someone send URL from where I can download the php pl? Jochem van Dieten <[EMAIL PROTECTED]> wrote:Douglas Sims wrote: > > You should check out: http://onlamp.com/ L.A.M.P. > (Linux/Apache/MySQL/Perl(or PHP) Or Linux/Apache/Middleware/Pos

SELECT

Hi, How to see all tables in connected database? thx -seena - Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

MYSQL Database

Hi, I'm new to this group.I would like to know which frontend tools be good tuned with Mysql database like php,perl etc? I want to develop one application on linux on mysql database which eventually would be webbased.Please suggest what combination would be good. thx -Seena --

MYSQL Database

Hi, I'm new to this group.I would like to know which frontend tools be good tuned with Mysql database like php,perl etc? I want to develop one application on linux on mysql database which eventually would be webbased.Please suggest what combination would be good. thx -Seena ---