Urgent question

Hi! I am new to this list and to the magical world of mysql so please accept some, maybe, stupid questions from an amateur. I am trying to install the Bundle::DBD::mysql module on my machine (Mandrake Linux). I get an error message stating that it can't find mysql.h and errmsg.h and they are no

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

Hi! I just tried Windows ME + MySQL Server - 4.0.9/4.0.11 + ConnectorJ - 3.0.4/3.0.6/3.1.0 with an InnoDB table test (id bigint not null auto_increment, name varchar(255)) also tried test (id int not null auto_increment, name varchar(255)) and did an SQLQuery thru JDBC insert

Update works in Netscape, doesn't in Explorer

Working in Lasso Profession 6, OS X and My SQL 4.? I'm at the testing stage of a small survey website (http://www.myword.co.uk/iied/iied_introVw.lasso). When a visitor first comes to the site, a record is created and identified by a sessionID. The visitor can move from page to page, and the answe

Re: Update works in Netscape, doesn't in Explorer

on 02/28/2003 1:37 AM, Roddie Grant at [EMAIL PROTECTED] wrote: > Working in Lasso Profession 6, OS X and My SQL 4.? > > I'm at the testing stage of a small survey website > (http://www.myword.co.uk/iied/iied_introVw.lasso). > > When a visitor first comes to the site, a record is created and ide

replication on single server

Hey guys, Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supposed to be replicated to all other databases on the same machine, so it is kinda like the master database. So how do I tell MySQL which databas

mysql download problems

Dear Sir or Madame, I have had _extreme_ problems with your web site. My first attempt was with the browser lynx, an elegant, text browser. It died on my, claiming to have problems uncompressing some tempory file. I then tried netscape. Your web page was OK, but the download page was all mixe

MySql eats CPU

Estimated gurus. My PC has RH 6.2, 510 Mb RAM, 812 MB swap, Kernel 2.2.23 and Mysql 3.23.55-log. Normaly my CPU is about 2 % , but sometimes increases until 65 %. And memory free swings from 45 Mb to 2 Mb. Web pages creates many temporary tables. Environment variables are. back_log 50 | based

A table allways crashes

>Description: We have to tables: t_daten(autoincrement on dat_id) and t_daten_detail. For each record in t_daten are on or more records in t_daten. The records are filled in from a java program via jdbc. An another program selects the data. At the the data will be deleted with: delete from t

RE: Why Is my dbase slow

have you indexed table on uniqueref field? if the table is not indexed on uniqueref than your query will require a full table scan. (my goodness, that's a HUGE table!) regds, -Original Message- From: John Berman [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 03:34 To: [EMAIL PR

re: trouble setting key_buffer_size on a debian slave

Hi, I'm using the same MySQL version on debian and have no problem setting the key_buffer size. I take it you are setting "key_buffer" and not "key_buffer_size" in the my.cnf file ? eg. set-variable= key_buffer=32M I don't know why it has a different name in the 'show variables' list. Are

Re: MySQL 4.0.11 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 26 Feb 2003, Benjamin Pflugmann wrote: > On Wed 2003-02-26 at 18:36:07 +0100, [EMAIL PROTECTED] wrote: > [...] > > As Mark has already stated, this is a typo - it should have read "GAMMA" > > instead. Sorry for the confusion. > > Would yo

UDF and mysql binary distr

Hi, For the busy ones, here's my question (then i explain): is it possible to add an UDF to a binary distr (.rpm for RH-8, downloaded from mysql.com) ? I'm having problems in creating an UDF (i create but when a use it mysqld restarts automatically). I've already created UDF functions in the past

bk bitkeeper to get the source for MySQL 4.1

Hello, Can anyone tell me where I can get an up-to-date copy of bz from? They're not responding to my colleague's or my own applications at their site bitmover.com. Failing that, can anyone point me in the direction of a compiled MySQL 4.1? Cheers, Andrew mysql,query --

left outer join

Could someone please tell me what I'm doing wrong here? I have the following two tables a)document_fields ++---+---+++ | id | name | data_type | is_generic | has_lookup | ++---+---+++ | 1 | Category |

speeding up mysql client

Hi everyone, I'm calling the mysql client from a bash shell script in a loop. It's doing one INSERT query each time. I'm aware that there is some overhead in this procedure, because the client has to connect to the server each time. Question: what are the recommended options to make this as fast

Re: HELP mysql_server_init embedded in a DLL?

Hi, - Original Message - From: "Derick Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 10:33 PM Subject: Re: HELP mysql_server_init embedded in a DLL? > I am posting this again, in hope that I will get a response. > > I tried doing

Re: left outer join

Hi, You have one thing wrong in your query... You're using LEFT JOIN but then you use a condition over DFL in the where clause. That's why it doesn't give you the results expected from a LEFT JOIN. You should have a look in the manual to see how to use left joins. The query should by: SELECT D

Re: SELECT DISTINCT question

Tore, Thanks very much for this. Question: Is it better to use INNER JOIN than a WHERE clause (for readability)? They do the same thing, don't they? I will try this out as soon as a finish another piece of my site. I'm under a big deadline crunch. I'll be interested to see if others know of othe

RE: left outer join

I am not sure whether you have checked for case sensitive issues but it could be that? document_fields.id,document_fields_link.id are you getting any errors? Andrew >SELECT DF.id, DFL.id >FROM document_fields AS DF LEFT JOIN document_fields_link AS DFL on DF.id = >DFL.document_field_id >WHERE

Starting with Innodb

Dear friends, I am not getting INNODB support as per describd in mysql manual. my c:\ has only 230MB free can this be a problem? when i make changes in my.cnf as per the manual, 'mysql' stops responding. pls provide detailed guideline. thanking you. nitin.

RE: Using MySQL to store email

I believe this is close to what I am needing. Thank you for your time and detail. My thank you to everyone else for their comments. Thanks, Jeff On Thu, 2003-02-27 at 12:13, Vikash K Agarwal wrote: > We have used procmail and PHP combination to achieve this for our > department mail management

mysql@lists.mysql.com

A select query I am running is working fine, except when the results are returned I wouldn't mind the query select options to display the full list again. Instead I believe there is a way I can query the table to display the value selected from the previous page. Anyone know what I am talkingabou

Re: Starting with Innodb

Hello Nitin, You can check the error messages in your database directory, it is usually named your.hostname.err it will give hints on why the mysql server won't start. also make sure that the 230mb free on your drive c: doesn't yet include the windows swap file, and your innodb space is less than

RE: left outer join

Thanks, I just learn't a lot about SQL --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTE

RE: left outer join

Thanks, I just learn't a lot about SQL --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED

Deleting records while parsing query results (in Perl DBI)?

Hi, If I run a mysql query then work through the results of that query one at a time, deleting the record sometimes eg: while (my $href = $sth->fetchrow_hashref()) { if ($href->{'ExpiryDate'} eq '2003-02-22 00:00:00') { # Do something # then... $db->do("DELETE FROM MyTable WHERE ID

Re: speeding up mysql client

Thomas, Well I guess the best way is to make an insert statement that goes like, INSERT INTO table values (3,'S',1,6,'2002-07-15','The Palm Computing Device',1),(2,'S',6,6,'2002-07-18','Programming for the Palm',1),(4,'S',5,6,'2002-07-1 6','Medical Applications for the Palm Device',1); The above

Database Security Related Matter....

Dear Sir/Madam, How can I Lock my database in MySQL with password. As we are having only password for User but what I have to do if I want to lock whole database. Waiting for your favorable reply. Thanks & Regards, Shripal. -

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: > Hi! I just tried > Windows ME + MySQL Server - 4.0.9/4.0.11 + > ConnectorJ - 3.0.4/3.0.6/3.1.0 > > with an InnoDB table > test (id bigint not null auto_increment, name varchar(255)) > also tried > test (id int not null

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

You don't select last_insert_id() from table. This will return the last_insert_id() for each row of the table. You just select last_insert_id(). Tea Yu wrote: >Hi! I just tried >Windows ME + MySQL Server - 4.0.9/4.0.11 + >ConnectorJ - 3.0.4/3.0.6/3.1.0 > >with an InnoDB table >test (

INTO DUMPFILE, BLOB problem

Hi All, Please help me, how can I download, store or read a content of an BLOB field to the local filesystem via the internet. I have tried it, but it wasn't right: SELECT Picture INTO DUMPFILE "C:\TempFile" FROM article where `ColumnID`=1 and `ArticleID`=4; It stores the file to where the sql s

Re: replication on single server

Databases are neither slave nor master, servers are. A master may have many slaves, but a slave may have only one master. Brandl, Thomas wrote: Hey guys, Simply said, imagine this scenario: A MySQL server with about 10 databases: A and 1 to 9. Database A contains a 'special' table that is supp

Re: problem connecting to mysqld

Of course because your MySQL engine is off. Start up your MySQL. Why not with Linux. Linux is far better than the Stupid Windows Plat form. Windows is only for a computer idiot. (but I am not meaning that you are idiot. I mean the windows). --- Ahmed Shams <[EMAIL PROTECTED]> wrote: > > I am ha

RE: The Security of MySQL

Respondendo, quinta-feira, 27 de fevereiro de 2003, 13:32:39, Mensagem Original: AN> Are you using Windows? If so, this root/mysql user talk will be AN> meaningless. You can still make the directory secure and only touchable AN> by the user that mysql is running as. Is this what you need? nope

MySQL and email

I have a big problem to solve on my site, and I'm not sure how to approach it. I'm selling software that's distributed as trialware (will be--haven't launched yet). Users will be able to unlock the time-limited versions with a license. I want to send the license to the user after her payment has be

Re: SELECT DISTINCT question

For readability, using the INNER JOIN clause makes it immediately clear what/how you are joining the tables, but it isn't too hard to read that from a WHERE clause either. Of course, for other types of join, definitely use the JOIN statement. It is *possible* that the optimizer may treat an INNER

JDBC Driver Bug, does not appear to support auto commit off-selections not detected in while loop if new insertions

My code works fine with autcommit on..however it does not support autocommit off. This is quite a big bug, or I have missed something out. Please let me know as I it would be of great interest to me if I was mistaken or correct and you will consider fixing it. If I switch off auto commit and sele

RE: rollback a table?

Yes, Back up your data every night. Then you will only have to perform a single simple restore instead of rebuilding from four months ago. I know that this sounds like a smart ass reply but I am serious. Disk space is cheap. CD's are cheap. Other media like DVDs are getting cheaper every day. U

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

Hi there! > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Tea Yu wrote: > > Hi! I just tried > > Windows ME + MySQL Server - 4.0.9/4.0.11 + > > ConnectorJ - 3.0.4/3.0.6/3.1.0 > > > > with an InnoDB table > > test (id bigint not null auto_increment, name varchar(255)) > > also t

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

Yea thanks for correct this, so I'm getting the right resultSet in console... but still having problem thru ConnectorJ, "select last_insert_id()" returns a String to me, rs.getString(1) throws no exception. Tea > You don't select last_insert_id() from table. > This will return the last_in

mysql: change column to row

mysql, Can I change the table one column to one row like this? Table1: key, count A 123 B 456 C 789 to Table2: A B C 123 456 789 Thanks, - Before posting, please check: http://www.mysql.

Re: JDBC Driver Bug, does not appear to support auto commit off-selectionsnot detected in while loop if new insertions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Emma Wansbrough wrote: My code works fine with autcommit on..however it does not support autocommit off. This is quite a big bug, or I have missed something out. Please let me know as I it would be of great interest to me if I was mistaken or correct an

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: Hi there! -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: Hi! I just tried Windows ME + MySQL Server - 4.0.9/4.0.11 + ConnectorJ - 3.0.4/3.0.6/3.1.0 with an InnoDB table test (id bigint not null auto_increment, na

query or php with a join

PHP Guys & Dolls I have a sight display issue that I just need to resolve :) After a select I end up with a record = 9 but I want to display the record as the name not the value. The value was inserted as a value so I need to make a join to the original table in the query, but alas I have tried a

Show number of records 1, 2, 3...

Hi I want to make a Simple Select using MySQL that show me number of rows, or make a count and show something like this: record#ClientCodeClientName 1 1020John 2 1032 Mary 3

Re: SELECT DISTINCT question

Sheryl, I'm trying to determine which author has the highest royalty percent FOR EACH PROGRAM, not overall. I'm displaying a list of programs and authors, and when there is more than one author, I want to show the principal author (i.e., the one earning the highest royalty percent). Ok, so your des

RE: Very basic If statement problem

This is so simple and basic, I must be missing something I have php code for displaying my embroidery designs on the web page. It's going through the mySql database and the query to pull up all the designs for a chosen category works fine. I have two fields in my database called "applique"

Re: query or php with a join

Since you haven't told us your table designs, I have to guess, but something like: SELECT I.ItemSKU, I.ItemName, I.ItemDescription, I.PostCode, I.Category, I.CityID, I.CTelephone, I.ItemID, I.Cfax, I.Cemail, I.Caddress

Problem with Win XP / Powerbuilder

I have encountered a problem regarding MySQL / ODBC ! I have an application written in PB6.5 and running in Windows XP Home Edition. There is an error generated while updating to MySQL table: "Row Changed Between Retrieve and Update". I tried to move the application to Windows 98 and it worked pr

Re: mysql: change column to row

The technique to do this is called a cross-tab(ulation) query or a pivot table. A simple (and pretty static) cross-tab query can be created by the use of CASE WHEN. But if you want a more generic solution that works for all values, it gets a bit more complex. Spend some time investigating Google

re: query optimisation

On Friday 28 February 2003 05:22, Dan Rossi wrote: > hi there i was wondering if there was a must get mysql book or paper > covering query optimisation ? Some info you can find in the manual: http://www.mysql.com/doc/en/MySQL_Optimisation.html And look also at Paul DuBois book "MySQL".

re: Starting with Innodb

On Friday 28 February 2003 15:19, Nitin Nanivadekar wrote: > Dear friends, > I am not getting INNODB support as per describd in > mysql manual. > my c:\ has only 230MB free can this be a problem? > when i make changes in my.cnf as per the manual, > 'mysql' stops responding. > pls provide detailed

re: Database Security Related Matter....

On Friday 28 February 2003 15:57, Shripal Shah wrote: > How can I Lock my database in MySQL with password. As we are having only > password for User but what I have to do if I want to lock whole > database. There is no password per database in MySQL. But if the user doesn't have permissions on t

re: Show number of records 1, 2, 3...

On Friday 28 February 2003 18:07, Juan Carlos wrote: > I want to make a Simple Select using MySQL that show me number of rows, or > make a count > and show something like this: > > >record#ClientCodeClientName > 1 1020John >

RE: The MySQL and InnoDB FK's

Hi, > > Hi, > > > >I would like to know if is there a way to delete constraints > >without dropping and recreating a table. If there isn't, I would > >like to know when do you plan to implement this important feature. I would also like to see this feature. I have been implementing a

Re: speeding up mysql client

On Fri, 28 Feb 2003, Sherwin T. Ang wrote: > Well I guess the best way is to make an insert statement that goes like, > > INSERT INTO table values (3,'S',1,6,'2002-07-15','The Palm Computing > Device',1),(2,'S',6,6,'2002-07-18','Programming for the > Palm',1),(4,'S',5,6,'2002-07-1 > 6','Medical Ap

Re: SELECT DISTINCT question

Frank, Sorry that I seem to be explaining this so poorly. I'll try to clarify what I'm trying to do and what my questions are. Someone on this list did give me code that I think will work. I haven't had a chance to try it yet. My question about how DISTINCT works is this: does it operate on the *

Very basic If statement still not working ????

Boy, this is getting real frustrating ... doesn't this seem to be child's play? I'm not trying to do anything fancy ... I tried the && and parentheses suggested below and it still didn't work. I even tried to put quotes around the zeros and ones thinking maybe the program wasn't recognizing that

MySQL or PostgreSQL

Hi! I've just started working in Linux, but I'd like to know which database is better to use, MySQL or PostgreSQL. Which one would be better in the long run? -- Regards, Neil - Before posting, please check: http://www.mysq

Re: MySQL or PostgreSQL

As with most things, depends on what you want to do, what are the requirements ? Jerry - Original Message - From: "InfoSysNCA" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 5:23 PM Subject: MySQL or PostgreSQL > Hi! I've just started working in Linux, but I

RE: MySQL or PostgreSQL

Since you're posting on a MySQL list, you could probably expect some biased responses. Could you post more about what you need to use a database for, i.e., what are your needs, wants, what kind of data are you handling, connection rates, serving platform, code base, etc. Here are a few URLs I was

Antwort: Re: Bug im Connector

You have written the following: It seems that the new MySql Connector/J has a "bug". If one calls close() twice on the same statement a NullpointerException is thrown. Best regards Horst Scheruga - Before posting, please ch

RE: MySQL or PostgreSQL

> Since you're posting on a MySQL list, you could probably expect some > biased responses. Could you post more about what you need to use a > database for, i.e., what are your needs, wants, what kind of data are > you handling, connection rates, serving platform, code base, etc. > > Here are a few

performance issue of innodb

Dear sir, I'm using mysql Ver 12.16 Distrib 4.0.5-beta, for Win95/Win98 (i32). I have an innodb table which contains more than 40 columns, after it load 5 rows, the query: select count(*) from t; takes 11 seconds. while the same table with ISAM type, the query only takes 0.02 second. I

RE: Very basic If statement still not working ????

Why don't you verify what the values are in the variables. If the Variables are not getting set then you would always see the "oops" in your statement. Try... echo $applique; echo $puffyfoam; Hope this helps Roger -Original Message- From: Stitchin' [mailto:[EMAIL PROTECTED] Sent: Friday,

Re: Antwort: Re: Bug im Connector

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: You have written the following: It seems that the new MySql Connector/J has a "bug". If one calls close() twice on the same statement a NullpointerException is thrown. Best regards Horst Scheruga Hmmm, the following testcase p

Re: performance issue of innodb

From: "Frank LIU" <[EMAIL PROTECTED]> > I also did some other test: > I ceated two tables both only have two columns, and both load 5 rows. > Talbe A has two int type columns, > Table B has an int type as primary key, and a mediumblob column. I insert a > 4k data into blob column of each row.

Support in apache for MySQL

Hello I use Apache/1.3.27 Server I use to use a mysql-connection, but now the apache support is gone. Trying to connect to my MySQL-database gives following result: Fatal error: Call to undefined function: mysql_pconnect() in... How do I get the MySQL-support back? Henning (newbie) ___

RE: Support in apache for MySQL

What language are you using? As far as I know Apache doesn't connect to databases, you have to use a programming language to do that. I'm guessing you are using PHP and you have possibly upgraded it without compiling in mysql support. -Original Message- From: Henning Olsen [mailto:[EMAIL

RPM Start/Stop Script not releasing terminal

>Description: after starting mysql via init script, one can not log off a SSH session >How-To-OBRepeat: log into box via SSH as root /sbin/service mysql start attempt to log off.. and the session hangs until you use another session to stop mysql. >

Re: MySQL or PostgreSQL

Neil, > Hi! I've just started working in Linux, but I'd like to know which > database is better to use, MySQL or PostgreSQL. Which one would be > better in the long run? I guess about anyone on this list will scream "Postgre is better", but let me make an exception. Some people consider Postgr

RE: Support in apache for MySQL

OK It's a PHP-problem then.. You are right - I use PHP 4. I thought it was a Apache-problem. But when I try the phpinfo.php, I get this (among much more) dbx dbx support enabled dbx version 1.0.0 supported databases MySQLODBCPostgreSQLMicrosoft SQL Server dba DBA support enabled Supported ha

Re: speeding up simple SELECT statements with the C api?

Hello. On Thu 2003-02-27 at 14:52:56 -0800, [EMAIL PROTECTED] wrote: [...] > Anyways, I'm running into a little bit of a performance issue as the old > database report writer had direct access to the database through a c library > (no sql interface). On some reports there can be as many as 100,00

Show record index, limit

Hello Everybody I using MySQL and I want to show the record id for the SELECT I know you can do SELECT clientCode, clientName limit 20, 3 2030John 2040Charles 2050Mery The limit show from record 21 (record id = 20) because the first start in 0 I want to show that record i

Very basic If statement still not working VERIFIED VARIABLES

Here's what I've got in my form: echo "{$row['designname']} {$row['designfile']} {$row['designcomments']} {$row['applique']} Applique {$row['puffyfoam']} Puffy Foam $mes

Re: HELP mysql_server_init embedded in a DLL?

Attempts at creating an embedded mySQL DLL for VB: I can successfully use the mysql_init() function from libmysql.lib to create a DLL for VB. However, when I use this function (in a DLL or lib)linked against the libmysqld.lib or mysqlserver.lib it crashes the VB application but not the C applic

Re: ./configure goes into infinite loop on mit-pthreads

MySQL Part of configure reads: (cd mit-pthreads; sh ./configure) I invoked configure as so: sh -v ./configure 2> /tmp/foo This leaves the following at the end of /tmp/foo while its running: ./configure: mit-pthreads: No such file or directory ./configure: mit-pthreads: No such file or directo

database query.

Hi, I have a table as shown with approx 500 lines: --- Tndr| Detail| 34 | one | 47 | two | 34

Re: SELECT DISTINCT question

Paul, > DISTINCT removes duplicates: rows that are the same in *all* columns. Would this be all columns in the table, or all columns retrieved by the SELECT statement? TIA. - Sheryl sql,query,queries,smallint - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Shery

Strange Temporary Table Problem.

Hello everyone, I am running MySQL version 3.23.52 on Mandrake 9.0 and access it from a web application running on IIS on Win 4.0 Service pack 6a with MyODBC version 2.50.39. The problem I am having is when I create a temporary table and then query the temporary table I get a Table doesn’t exist

RE: Very basic If statement still not working VERIFIED VARIABLES

In your If statement (if this is still true) you are using... > if(($applique == 1) && ($puffyfoam == 0)) etc. But in your list you are using > {$row['applique']} Applique > {$row['puffyfoam']} Puffy Foam Since I am seeing bits and pieces

count rows

Here's a nice MySQL simple returning records query question! I want to return a staement saying 'number of records shave been found' for your selection. so presumably this is a simple row count based on the the returning recordset? Andrew ---

Re: Re: SELECT DISTINCT question

> From: "Sheryl Canter" <[EMAIL PROTECTED]> > > > > DISTINCT removes duplicates: rows that are the same in *all* columns. > > > > Would this be all columns in the table, or all columns retrieved by the > > SELECT statement? in the SELECT statement :) SELECT queries do not alter your rows, you

Create table with IF condition not working properly

I have a client word database and I am attempting to create a database with the results from a select that splits the description field based on the spaces. When just executing the select command, the output is correct. When using the create command with the select command, apparently the IF stat

bug - sec_to_time has a low upper limit on the range

From: [EMAIL PROTECTED] Subject: bug - sec_to_time has a low upper limit on the range Description: sec_to_time will not return times greater than 24, my hunch is that sec_to_time() is wrapping at 24:00 for some reason or that's some kind of bound, and it's not sticking to the TIME type which has

Re: count rows

> Here's a nice MySQL simple returning records query question! > > I want to return a staement saying 'number of records shave been found' for your > selection. > > so presumably this is a simple row count based on the the returning recordset? > > Andrew Either with PHP or C you can use mysql_num_

RE: database query.

hi, I appreciate the time you spared for my problem. Thanks, that helped :) Regards Anil -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:47 PM To: Anil Garg Subject: Re: database query. There really isn't enough information for me to a

Re: SELECT DISTINCT question

Your guess is correct, DISTINCT works on the result set - i.e. if the result set contains two result rows that contain exactly the same values, it will eliminate the duplicate from the result set. SELECT DISTINCT is equivalent with using a GROUP BY without an aggregate function. SELECT DISTINCT x

Re: SELECT DISTINCT question

So depending on which columns you were looking at, two rows might seem like duplicates or not? If your SELECT statement only requested certain fields, your result set might have duplicates that wouldn't be duplicates if you were looking at other columns as well? Is this correct? So if I had this i

Re: count rows

>> Here's a nice MySQL simple returning records query question! >> >> I want to return a staement saying 'number of records shave been >> found' > for your >> selection. >> >> so presumably this is a simple row count based on the the returning > recordset? >> >> Andrew > > Either with PHP or C you

Re: Update works in Netscape, doesn't in Explorer

I'm using link based sessions, but I don't think that can be the culprit. The SQL statement includes WHERE sessID="whateveritis". Explorer appears to identify the correct record because it clears the NULLs; it just doesn't write the new data. Roddie on 28/2/03 9:45 am, Scott Haneda at [EMAIL PR

Re: [PHP] Is it an apache or a php-problem?

Partly right I'm using RedHat 7.3 and it has an automated update funktion. Both Apache, MySQL and PHP are updated by the scripts, and during that proces the connection between PHP and MySQL disappeared. But how to diagnose where the configureationproblem is??? Henning Michael Mulligan <[EMAIL P

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Hi, I just installed 3.23.55 and I started getting this message when I run mysql from the shell. /tmp/mysql.sock exists and the permissions are right and mysqld is running, also the weird thing is that php is connecting just fine. any ideas? thanks, - Mark -

Re: Show record index, limit

Juan Carlos wrote: Hello Everybody I using MySQL and I want to show the record id for the SELECT I know you can do SELECT clientCode, clientName limit 20, 3 2030John 2040Charles 2050Mery The limit show from record 21 (record id = 20) because the first start in 0 I want to show

can't find /tmp/mysql.sock

Please help. I downloaded the binary distribution for mysql-3.23.55-pc-linux-i686 to run on redhat linux 8.0 I've done the following commands: shell>> cd /usr/local shell>> gunzip < /downloads/mysql-3.23.55-pc-linux-i686.tar.gz | tar xvf - shell>> groupadd mysql shell>> useradd -g mysql mysql she

mysql encripted password from perl

I have perl code like my $username = $query->param("username"); my $password1 = $query->param("password1"); my $sql= "INSERT INTO apidbusers "; $sql .= "VALUES(?, ?)"; $sth->execute($username, $password1); In this way, password1 will be in mysql table as plain text. how ca

Re: can't find /tmp/mysql.sock

> when I do this this is what I get: > starting mysql with databases from /var/lib/mysql > 030228 16:00:55 mysqld ended This may be your culprit right here... not sure where the mysql_install_db defaults its installs to, but I'm guessing its not /var/lib/mysql. And you installed everything into /

mysqld: Can't lock file (errno: 45)

I just rebuilt mysql 3.23.55 on FreeBSD 5.0, and I am trying to start mysqld with my databases, and all of a sudden I'm getting this error. I was wondering if anyone has seen this and might know where I should start looking? -- Mark P. Hennessy [EMAIL

Re: Show record index, limit

Do you know how to make a counter, something like this SELECTj++ClientCode ClientName so the ouput seria 11030John 23202 Mary 34033Xavier etc Thnak - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "J

Re: mysql encripted password from perl

sth->execute($username, password($password1)) does not work. On Fri, 28 Feb 2003, Jianping Zhu wrote: > > I have perl code like >my $username = $query->param("username"); >my $password1 = $query->param("password1"); >my $sql= "INSERT INTO apidbusers "; > $sql .= "VALUES(?, ?)";

  1   2   >