Re: Help please: SELECT in binlog?

On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote: > You can have both, AFAIK. The general query log keeps all queries, > including SELECTs. Binlog only has data-modifying queries. Thanks very much for your answer. Maybe the fact that binlogs apparently are quite different from normal text lo

Help please: SELECT in binlog?

We recently switched to mysql5 and while we were at it we also changed our logs from text to bin as suggested by the migration script we had (probably created by debian people). Now I unfortunately had to reconstruct what had happened during a faulty run of our application and I could not get any

Install on RH9

ease help! Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] --

tracing ips

from users but I need a method to get more information about who they are. If anyone has any suggestions, let me know! thanks! mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)

Desc question

his? -mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.c

desc question

his? -mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.c

Re: displaying a letter based on a query value

19' group by number"); while($captain2=mysql_fetch_array($captainquery)){ printf ("C indicates captain: %s",$captain2["cstatus"]); } and I'm certain the number '19' is set to be a captain. Thanks! -Alex "Big Al"

Re: displaying a letter based on a query value

s right cuz its returning a value. How do I make it show if the captain value is 1 that it returns a "C"? Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8

displaying a letter based on a query value

on my page? mysql Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unl

date conversion problem

re displayed on my displayed on the page. Is this possible? mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599

RE: sudden increase in size when doing CREATE TABLE ... SELECT ...

Hi there ! A sample create table SQL query is as follows : "create table eml.adjacency select * from emlbase.adjacency where eml.adjacency.importdate = '2002-10-10';" The database names (e.g. "eml") ,tablenames (e.g. "adjacency") and date are changed by a perl script for the different tables

sudden increase in size when doing CREATE TABLE ... SELECT ...

Hi All ! Recently we have begun developing a web-based configuration sheet generator. The basis for these configuration sheets is data stored on several Sun servers. The Sun servers are responsible for collecting all config data from all equipment connected to the network. We have developed scr

RE: Howto "copy" a database

Hi, see the "2.5.4 Upgrading to another architecture" part of the mysql reference manual or "4.8.5 mysqldump, Dumping Table Structure and Data". Regards, HB - Before posting, please check: http://www.mysql.com/manual.php

problem with mysqldump

Hello i got a problem with mysqldump, i'm forced to dump it to to place the database on a new laptop mysql -u root -p hardwaredb < hardwaredbbackup.sql Enter password: ERROR 1065 at line 25: Query was empty and the corresponding line: ) TYPE=MyISAM; 25: /*!4 ALTER TABLE mobile_dev DISA

help with a simple query..

structured liek this: SELECT * from hwu_articles WHERE id = '$id' and * is not null, but I don't think you can use two *'s in the same query, how can I do this? Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Ur

A lil help with a simple query...

structured liek this: SELECT * from hwu_articles WHERE id = '$id' and * is not null, but I don't think you can use two *'s in the same query, how can I do this? Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Ur

Re: can't connect

ound fourth confirm running: mysqladmin status or as second above jan behrens -- [EMAIL PROTECTED] -- a different set of mind - Before posting, please check: http://www.mysql.com/manual.php (the ma

Re: select by total goals

Hey, I'm trying to display this information on a page, but I'm having trouble. How do I output this into php? mysql, query Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be br

select by total goals

amount? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Se

select by total goals

amount? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Se

select

amount? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Se

row totals

mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Se

mysql and java

quot;],$a["name"]); } ?> I need to somehow have the "='if (window.event || document.layers) show(\"%s\",event)' onMouseOut='hide(\"%s\")'" syntax pull its data from a mysql table or another page, how can I do this? Thanks! --

Re: create tmp table of column list of a table for future use

I believe it has to be like this: create table column_list (MYTABLE_NAME DESC); Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-48

help sorting by a column name

$a["name"]); } ?> I want it so it displays them like this: Processors - Reviews listed here Motherboards Reviews listed here the categories are stored under the column name "category", for reference. Thanks! -Alex "Big Al" Be

need some help...

parse error on the page for the $retval. = line Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited

output to a file

icurl"],$a["picurl"],$a["title"]) ; } ?> Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599

Re: problem with '

Thanks Peter, you gave me a lot work with I'm going to experiement with it all. Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 6

Re: problem with '

27;,'$url','$author','$email','$category','$num','$i nfo')"); Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Pho

Re: problem with '

Is it possible to have my script do this automatically if it detects a ' in the data being inserted? would you know the command to do this, I would assume it would be PHP based. -mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROT

problem with '

MS-6153. Is it possible to use a different type of column so these characters are allowed? it is a for a review so I need it be all grammatically correct with the apostrophes. How do I get around this error? sql Thanks! -Alex "Big Al" Behrens

Re: primary key

Sorry I meant without deleting the table or affecting any present data. is this possible? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fa

primary key

Hey Guys, Is it possible to remove a primary key from a mysql table that has already been created without whipping out the table? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)

column names

Hey Guys, What is the command to display the names of all the columns in a table? -mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fa

Re: limiting a select

Thanks guys I got it to work. Also, thanksPaul for the PHP reference as well, I'm going to tool around with both as a learning experience. Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (

limiting a select

lumn? my query is this: $r = mysql_query("SELECT * FROM hwureviews LIMIT (MAX(num)-7),7"); Does this work or am I way off? Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Pho

Re: hits

Ok thanks guys. Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: htt

Re: hits

Yeah, but thats not what I'm asking, how can I get this info from the table? Does mysql have a built-in feature that stoes the hit information and if so, how do I pull this info from the table? Thanks! -Alex "Big Al" Behrens E-mail: [

hits

or, E-mail, Number, Category, Description I want to be able to track the amount of hits per category and I the same categories for displaying all reviews in the table. Does mysql integrate a function like this? Thanks! -Alex "Big Al" Behrens

Re: SELECT frmo two tables

mysql_fetch_array($numberquery)){ printf ("Total groundballs for $position: %s",$number["grounders"]); } Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-877

Re: SELECT frmo two tables

ySQL result resource" Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: ht

SELECT frmo two tables

quot;SELECT SUM(groundballs) AS grouders FROM stats WHERE (position = '$position') FROM rahs"); is it possible to do a WHERE command with a FROM command? Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [E

Re: Help with selects

Even though I don't know how to fix my problem, I know yours is possible because its just a different form type not any different in the code I'm using. I hope this helps. Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] U

Help with selects

-------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Netw

Re: adding up row values....

Thanks for hte help with both the SUM and ABG mysql fuction, can you take a look at my last e-mail too and see if you can help me implement this code into my site? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-ma

Re: adding up row values....

hanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Mes

adding up row values....

002-03-01 | +-++--+-+-+---+- -+---++ I want to add all of the values for the groundballs, shots, and faceoffs, how do I make it add up row values? Thanks! -Alex "Big Al" Beh

Re: need help debugging! (more!)

this error: Warning: printf(): too few arguments how do I fix this? I checked the number of "%s" and the number of $num arguments and they shuld match. what am I doing wrong? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Ur

Re: need help debugging!

what do you mean by checking each query manually? how do I do this? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 IC

Re: need help debugging!

how do I fix it so mysql doesn't returns a 0? is my syntax wrong somewhere? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 6

need help debugging!

arch)) { what is wrong with my code? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-

Re: using a datetime def in a column...

I forgot that mysql reverses the month and day so I was trying to input yesterdays date (02-28-2002) so it gave me hte default zero value since 28 isn't a valid month number! oops thanks guys. Thanks! -Alex "Big Al" Behrens E-mail: [

using a datetime def in a column...

what is the proper way to insert data into a row like this so it will show up with the date that I want it to show up as? what is the proper input for MYSQL to use this type of column? Thanks! -------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgen

Re: dumb (re)newbie question...

Awesome thanks, I thought it was under the INSERT command at first, but I guess its the ALTER command, thanks bro! I'll check out the online manual some more! Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [

dumb (re)newbie question...

her a whole new row (or maybe column) or the table. like if you have 7 values for the table, I want to be able to add an 8th value. Please advise... Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (

Re: problem with security and user access

Ian Barwick wrote: > > > Have you flushed the privileges after changing the tables? > > FLUSH PRIVILEGES > > -- > Ian Barwick - Developer - [EMAIL PROTECTED] > akademie.de asp GmbH - http://www.akademie.de > > "To query tables in a MySQL database is more fun than eating spam" yes i did countless

problem with security and user access

after editing the tables below , i'm still not able to access the Bisimis Database below with the user behrens, just getting the errormessage below. I've tried it with any combination of user/db/host but can't see the supposed logic error i've made,i'm stuck,anyone

Re: Nusphere is spamming me (Interesting Stuff)

Andy Woolley wrote: > > > For a long time now Nusphere has been treading on far too many peoples toes > (who do they think they are) not only are they annoying MySQL users with > their exasperating antics they are also trying to steal MySQL from the very > people that actually wrote the software.

how to delete user from the usertable

How do i delete a user utterly from the usertable Haven't find it right now in the doc(thanks Ian B.) janB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

how to login to dbases under mysql

first a thank to Ian Barwick,his tip saved my day. But now the next newbie Question! I want to insert users into the usertable of the mysql Tables how do i login? haven't found an answer sofar. Does anyone knows where such questions were already answered, so that i have not to put my nescience

strange behaviour

Hello, started a new compiled MysqlDataBase on my local Machine everything okay sofar. added a ./bin/mysqladmin -u root password '' (password omitted) no problem I tried it several times to log in to create a database but only getting this: >behrens@ws8:/home/behrens/behren