search through entries

HI can someone help me with general search syntax. I want to search a table with a search string obtained from a form input ( PHP/Mysql app) The problem is: Lets say there is an entry in the table: John Doe When I search for that, with something like: select * from table where name like

sample c code wanted

hi my query is that i am looking for sample c code on how to load/extract binary data into/from a blob field. can u help me? tks tom _ The new MSN 8: advanced junk mail protection and 2 months FREE*

Moving the location of mysql.sock and mysql_setpermission

OS: Linux 2.4 Mysql: 3.23.52 /etc/my.cnf -- [mysqld] #datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock datadir=/usr6/mysql socket=/usr6/mysql/mysql.sock port=3306 [mysql.server] user=mysql #basedir=/var/lib basedir=/usr6

CREATE TABLE and CHECK clausole

Dear subscribers, MySQL seems to support the CHECK() clausole in the implementation of CREATE TABLE statement, but MySQL (Ver 11.15 Distrib 3.23.39, for pc-linux-gnu) returns a syntax error on such a command. For example: mysql CREATE TABLE example (var INTEGER, CHECK(var BETWEEN 0 AND 1));

Re: CREATE TABLE and CHECK clausole

Maybe it's just to late for me to think clearly but there are NO INTEGERS between 0 and 1, try FLOAT or DECIMAL. Best/h On 12/3/02 1:08 AM, Achille M. Luongo [EMAIL PROTECTED] wrote: Dear subscribers, MySQL seems to support the CHECK() clausole in the implementation of CREATE TABLE

Re: C API problems with InnoDB

Hello Mark, thanks for your answer. In fact the mysql shell where I update the row is using AUTOCOMMIT=1. Even after I issue a COMMIT manually the changes are not seen by the application. What I dont understand is that the program doing a SELECT has to issue an COMMIT to have all data available.

Re: Mysql Replication

AFAIK, you can't do it transparently from the MySQL client library. (like in Oracle) You have to accomplish the task in your application, ie: try to connect/select from the master database, if command fails then try the slave1, then slave2, then slave3... and so on. Hint: create you own

Re: C API problems with InnoDB

Hi Stefan, Does the second shell actually perform those changes? In this case, I assume it's got something to do with the isolation level / consistent read in InnoDB tables. shell1 sees all its changes immediately, shell2 (the application) has just a snapshot of the data at the time it

Re: Users and their priveleges in a mySQL Database

* Andi S. Giri Can mysql have different tables for different users ? Yes. Say user 'TEST1' creates a table called 'XYZ' and also user 'TEST2' creates the same table name 'XYZ' Is it allowed ? Yes, if you give each user his own database. If it is, can this two tables can be accesed by a

Re: Advice please

Hi George, I am about to start the planning process in moving my FileMaker/Lasso/PHP site over to MySQL/PHP. Before I get too far down the road, should I be using InnoDB or MyISAM tables? The service is initially going to be hosted on WinNT but may move over to Linux later. =main response,

ERROR 2014 - command out of sync, why?

Database error: cannot use database pollo MySQL Error: 2014 (Commands out of sync; You can't run this command now) Session halted. Why? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MYSQL and large fields

We have switched over from Microsoft Access to MySQL because we were unable to store large files. 2-3 pages of written text. But M. Access kept messing with the data. MySQL has Blob types that can store large amounts of Data. So, can MySQL store 2-3 pages of text or would this be a limitation. I

Re: search through entries

* Petre Agenbag can someone help me with general search syntax. I can try. :) I want to search a table with a search string obtained from a form input ( PHP/Mysql app) The problem is: Lets say there is an entry in the table: John Doe When I search for that, with something like: select

Syntax error in INSERT

Hi, I have the following statement causing an error near , sNewCallBackSQL = INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES ( ExLearnerID , sCallDate , sCallTime ) The executed statement is: INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113 , , )I

Problem with a table

Hi I'm new with mysql, and I have a problem in a dabase, the file sysmte got full and one table is corrupt, the messages are: mysql desc medicionproc; ERROR 1016: Can't open file: 'medicionproc.MYD'. (errno: 144) I tryed to repair it mysql repair table medicionproc;

JDBC driver: Buggy for DatabaseMetaData.getImported/Exported keys ?

Hi: I am using Connector/J 3.0.2 against MySQL 3.23.52-max. My default table type is set to InnoDB (since I always use innodb). The following methods are acting strangely: - DatabaseMetaData.getImportedKeys() - DatabaseMetaData.getExportedKeys() Often these methods return partial information

RE: MYSQL and large fields

A LONGBLOB can store 4294967295 bytes A LONGTEXT can srote 4294967295 bytes Simon Green -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 11:20 To: [EMAIL PROTECTED] Subject: MYSQL and large fields We have switched over from Microsoft Access to

Re: help with picking the right index(s)

Hi Justin, I'm after a little help/advice with indexing... I have a table for measuring hits on each page within a site: year month page hits basically, my php script looks for a row matching this year (2002), this month (12) and this page (something.php). if it finds it, increment by 1,

Select and count duplicates

I have a column containing headlines. In this column there are some duplicates, like this: --- monsters headline1 monsters halloween monsters halloween ... -- How can I get a result like this instead? HEADLINE | HITS --- monsters | 3 halloween | 2

truncate table ...

Dear All, I am getting a severe problem with truncate comand( InnoDB Tables - Mysql 3.23.52-MAX on Linux 7.3) . The scenario is: I have a table with more than 100 Million records. I gave a truncate table command to delete all the data from this table. Once I gave

Re: MYSQL and large fields

* Simon Green A LONGBLOB can store 4294967295 bytes A LONGTEXT can srote 4294967295 bytes In theory, yes. But not for real. MySQL 3.23.x has a limitation on the max_allowed_packet parameter, the max setting is 16M. This will prevent any single field from containing more than 16M. This

Re: Table setup question

Beauford, OK, I get it now. I thought there would need to be duplication in the AlbumSonglist DB. =indeed, the process of 'normalisation' (as mentioned earlier) helps to ascertain when and where 'duplication' is allowed/beneficial/should not happen. Just one other question though. What is the

sleeping threads problem

Hello , i use MySql 3.23.49-log with Php 4.2.1on RH 7.2 . The problem is that i got many many (16-30) sleeping threads almost all the time . The code is pretty clean , and i suspect that those threads are sleaping beacuse of some strange ascii characters (like CR) . Is any intelegent way to find

RE: Select and count duplicates

select headline, count(*) from headlines_table group by headline; Eva Parackova [EMAIL PROTECTED] -Original Message- From: Michelle de Beer [mailto:[EMAIL PROTECTED]] Sent: 3. decembra 2002 13:27 To: mysql list Subject: Select and count duplicates I have a column containing headlines.

RE: Select and count duplicates

Run this query as rs1: select distinct scary_words from monsters_table; String word; String query; Int count; while rs1.next() { word = rs1.getString(); // Run this query as rs2 query = 'select count(*) from monster_table where scary_words=' + word + '';

Fw: Re: Select and count duplicates

- Original Message - From: [EMAIL PROTECTED] To: DL Neil [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 1:05 PM Subject: Re: Re: Select and count duplicates Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter

RE: Select and count duplicates

SELECT headline, count(*) AS HITS from your_table GROUP BY headline -Original Message- From: Michelle de Beer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 8:27 AM To: mysql list Subject: Select and count duplicates I have a column containing headlines. In this

Trying2insert Date2table

Hi, I am trying to insert the following value to a Date/Time field in SQLServer7 table. Here is the Line values Im tring to execute sNewCallBackSQLINSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113 , 01/01/2002 , 0:00) Here is the statement: sNewCallBackSQL = INSERT INTO

re: Security issues with LOAD DATA

Chris, Tuesday, December 03, 2002, 6:58:39 AM, you wrote: CW I developed a PHP application where users can update a mySQL table using CW LOAD DATA. Recently I installed this application on another web server where CW the File Permissions have been set such that this method of uploading data CW is

re: Users and their priveleges in a mySQL Database

Andi, Tuesday, December 03, 2002, 8:52:33 AM, you wrote: ASG Can mysql have different tables for different users ? Say user 'TEST1' ASG creates a table called 'XYZ' and also user 'TEST2' creates the same table ASG name 'XYZ' ASG Is it allowed ? Yes. Table names must be unique within a database.

re: Problem with a table

Edgard, Tuesday, December 03, 2002, 1:45:15 PM, you wrote: ED I'm new with mysql, and I have a problem in a dabase, the file sysmte got ED full and one table is corrupt, the messages are: ED mysql desc medicionproc; ED ERROR 1016: Can't open file: 'medicionproc.MYD'. (errno: 144) ED I tryed to

re: change the data directory

Julia, Tuesday, December 03, 2002, 2:24:49 AM, you wrote: JS I have just installed the mysql binary on solaris 8. JS I would like have the data go to a different directory than /local/mysql/data. JS How do I get it to do that? JS I tried starting it with the --datadir set, but that didn't work.

re: Blob accepts LongBlob without error

Ryan, Tuesday, December 03, 2002, 2:04:03 AM, you wrote: RCGT I have successfully inserted and retrieved binary image files within RCGT MySQL. No big deal. RCGT However, for quite some time I was perplexed because only about half my RCGT image was going through. RCGT It seems that MySQL

re: CREATE TABLE and CHECK clausole

Achille, Tuesday, December 03, 2002, 11:08:19 AM, you wrote: AML MySQL seems to support the CHECK() clausole in the implementation of CREATE AML TABLE statement, but MySQL (Ver 11.15 Distrib 3.23.39, for pc-linux-gnu) AML returns a syntax error on such a command. For example: AML mysql CREATE

re: Select and count duplicates

Michelle, Tuesday, December 03, 2002, 2:27:00 PM, you wrote: MdB I have a column containing headlines. In this column MdB there are some duplicates, like this: MdB --- MdB monsters MdB headline1 MdB monsters MdB halloween MdB monsters MdB halloween MdB ... MdB -- MdB How can I

MySQL: Select Not In Table

Just wondering if anyone knows of a work around for selecting rows in Table1 that have an ID column value which is not found in the ID column of Table2. I have seen a workaround for selecting similar rows IN both tables, but I want NOT IN. This would be a work around to the sql subselect query in

Re: C API problems with InnoDB

Heri, H. Steuer schrieb: Hi Stefan, Does the second shell actually perform those changes? In this case, I assume it's got something to do with the isolation level / consistent read in InnoDB tables. shell1 sees all its changes immediately, shell2 (the application) has just a

REPLACE fails to find newlines

Using Red Hat 8.0, mysql-3.23.52-3, and phpMyAdmin-2.3.3. I'm importing a bunch of old posts from one bboard system (Ezboards) into a new one (Burning Board), and the process left a bunch of HTML br on the end of each line that is now unwanted. (I'm getting double-spacing.) I figured this SQL

Virtual Mem. problem w/ mysql-3.23.53-win.zip

When the service is running ( mysqld-nt or mysqld-opt ), my Windows 2000 virtual memory gets eaten up and I get messages that I have run out and need to reboot. Once I shutdown the service, I go back to normal. I use mySQLWinAdmin to do all the starting and stopping of the service. Any ideas

Re: ERROR 2014 - command out of sync, why?

At 12:16 +0100 12/3/02, Claus Reestrup wrote: Database error: cannot use database pollo MySQL Error: 2014 (Commands out of sync; You can't run this command now) Session halted. Why? What's the context? Are you, for example, seeing this error from within a PHP script?

RE: Select and count duplicates

Run this query as rs1: select distinct scary_words from monsters_table; String word; String query; Int count; while rs1.next() { word = rs1.getString(); // Run this sql query as rs2 query = 'select count(*) from monster_table where scary_words=' + word + '';

Re: WHERE IN SYNTAX

My mistake. I failed to mention that there are two tables, bar and baz. And, I found the answer to my question. Thanks everybody. On 12/2/02 5:52 PM, Adolfo Bello [EMAIL PROTECTED] wrote: Isn't this sort of impossible? You are asking for something like a set which contains as an element the

bug / feature : privilege inconsistency

Hi, The new CREATE TEMPORARY privilege is a very good idea. Unfortunately, when an user creates a temporary table, he can't write to it if he doesn't also have the INSERT privilege. It would be much more useful if an user were always allowed to write to its own private temporary tables,

Re: Select and count duplicates

* Michelle de Beer I have a column containing headlines. In this column there are some duplicates, like this: --- monsters headline1 monsters halloween monsters halloween ... -- How can I get a result like this instead? HEADLINE | HITS ---

Re: CREATE TABLE and CHECK clausole

On 12/3/02 4:32 AM, Achille M. Luongo [EMAIL PROTECTED] wrote: Dear Sir, I have tried with FLOAT or DECIMAL data types, but MySQL always returns the same error. After your suggestion, I double checked the MySQL data types definition list and the INTEGER (alias INT) data type is supported.

RE: dividing

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 8:35 AM To: Fifield, Mike Subject: Re: dividing 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

Re: Syntax error in INSERT

Hi, I suppose you have to use a NULL value: INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113,NULL,NULL)I [EMAIL PROTECTED] wrote: Hi, I have the following statement causing an error near , sNewCallBackSQL = INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES

join count and 0

I am wanting to see if there is a way to do a join but have count(id) show up as 0 when there is no records in the 2nd table. With out having to 2 selects. for example. orderid = has persons name and contact info select oi.id,oi.name, count(o.id) from orderid oi, orders o where o.order_id =

Perl DBI or C++ API Help!

I need to be able to connect to mysql through a perl or C++ script without knowing the name of the database to connect to. I can't seem to find a way to do this. Is it possible to either: look up database names so I can pick one before connecting or connect without a database name so I can show

Re: JDBC driver: Buggy for DatabaseMetaData.getImported/Exportedkeys ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 j.random.programmer wrote: Hi: I am using Connector/J 3.0.2 against MySQL 3.23.52-max. My default table type is set to InnoDB (since I always use innodb). The following methods are acting strangely: - DatabaseMetaData.getImportedKeys() -

SQL Select Idea

Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but

Select, mysql_fetch_array, PHP question

Hi, I'm trying to do a search on database through a web interface using PHP and having one small problem. Example: If I search for items that cost $5.00 and there are three of them, the query works and displays the information, but if there is only one item the query works but doesn't display the

Re: Table setup question

DL, Yep, I see what your saying. In my application it may work fine, but in larger applications where things may change, it would be easier to do it with the 3 tables. Thanks - Original Message - From: DL Neil [EMAIL PROTECTED] To: Beauford.2003 [EMAIL PROTECTED]; [EMAIL PROTECTED]

DateTime Calculations

Suppose I have a datetime in the following format: Column One Column Two 1999-09-17 16:30:18 1999-09-18 13:30:18 I want to calculate the minutes like (Column Two - Column One) = Total Minutes I've scoured the mysql site and haven't found something that addresses this. Any

order by clause with latin5 character set on binary fields

Hello, I use mySQL 3.23.49 with latin5 character set. At some of my tables I use binary fields. At normal fields order by clause returns true sorting but at binary fields I get wrong results. Is there any way to correct this problem or have to I use normal fields instead of binary and use

Re: LEGAL information about MySQL.

On Mon, Dec 02, 2002 at 08:52:53PM +0100, Mark wrote: Is this true? If so, that is a relief. But does the licence also not talk about using MySQL? Is connecting to MySQL not the same as using it? First off, the GPL is very clear that it is not a mandatory license. Your options are to either

TimeDate in SQLServer7

Hi I am inserting a Time like 06:00 from my code to a Date/Time field in SQLServer7...the value I am sending in my program is perfectly finebut...when It gets in the database... it gets screwed up to be like 01/01/1900 06:00:00 What I need really is only the time rather than Date/Time.

Re: MySQL: Select Not In Table

Dear Henning, SELECT Table1.ID FROM Table1 WHERE Table1.ID NOT IN (SELECT Table2.ID FROM Table2); SELECT Table1.ID FROM Table1 LEFT JOIN Table2 USING (ID) WHERE Table2.ID IS NULL Hope it helps, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de

Re: MySQL: Select Not In Table

SELECT Table1.ID FROM Table1 LEFT JOIN Table2 ON Table1.ID = TRable2.ID where Table2.ID IS NULL; Henning Sittler wrote: Just wondering if anyone knows of a work around for selecting rows in Table1 that have an ID column value which is not found in the ID column of Table2. I have seen a

Re: Security issues with LOAD DATA

This also does not enable me to upload a data file. My resulting SQL statement reads: LOAD DATA LOCAL '/tmp/phpgPhl51' INTO TABLE test FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' I have also tried: LOAD DATA LOCAL INFILE '/tmp/phpgPhl51' INTO TABLE test

RE: MySQL: Select Not In Table

Thanks to all those who have responded! This is the sql query I am looking for. It's good to have such a user mail list. SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID) WHERE Table2.ID IS NULL when you do a left join, if there is no cooresponding row in the second table, then a

Index timestamp column

Its possible to use index on this query ?? select .. from .. where timestamp_col2002110100 and timestamp_col2001110100 I have index on timestamp column, but EXPLAIN says that not using any of possible keys. I also try using BETWEEN function instead of two compares, but same result.

Re: sleeping threads problem

In the last episode (Dec 03), cristian ditoiu said: Hello , i use MySql 3.23.49-log with Php 4.2.1on RH 7.2 . The problem is that i got many many (16-30) sleeping threads almost all the time . The code is pretty clean , and i suspect that those threads are sleaping beacuse of some strange

Re: REPLACE fails to find newlines

Since '\n' is ignored in HTML, that is not your problem. The answer is probably in your PHP setup or code. Kenneth Porter wrote: Using Red Hat 8.0, mysql-3.23.52-3, and phpMyAdmin-2.3.3. I'm importing a bunch of old posts from one bboard system (Ezboards) into a new one (Burning Board), and

MySQL: Select HELP!

Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but

RE: Select and count duplicates

select distinct(headlines), count(headlines) from table group by headlines -Original Message- From: David Shapiro [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 8:40 AM To: 'Michelle de Beer'; mysql list Subject: RE: Select and count duplicates Run this query as rs1:

Newbie Question

Hello there. I recently got a wild hair to set up an amateur web site that will allow a group of friends to log and comment on bottles of wine. Having never done web development before, I set out to first research what relational database I would use that would satisfy my need for maintaining

Re: Virtual Mem. problem w/ mysql-3.23.53-win.zip

At 08:28 03/12/2002 -0600, Patrick Quinnett wrote: Yes, When the service is running ( mysqld-nt or mysqld-opt ), my Windows 2000 virtual memory gets eaten up and I get messages that I have run out and need to reboot. Once I shutdown the service, I go back to normal. I use mySQLWinAdmin to do

RE: CREATE TABLE and CHECK clausole

I've attempted to get the CHECK clause to work as well, and have had no luck. I don't think it's actually supported by MySQL yet. -JF -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 7:42 AM To: Achille M. Luongo; MySQL

RE: Virtual Mem. problem w/ mysql-3.23.53-win.zip

Thanks for the quick response. Excellent support We will be using myCC next until we see the next release of mySQL. -Original Message- From: miguel solórzano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 12:26 PM To: Patrick Quinnett; '[EMAIL PROTECTED]' Subject: Re:

synopsis of the problem (one line)

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Charlie Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

Re: Selective Replication question

Ok, so nevermind... MySQL actually supports the selective replication I want with the replicate-do-table=db_name.table_name syntax, which I thought was only available after 4.x. Thanks for all the great responses that helped me figure this out. :-) =john John Stanforth wrote: Hi folks,

4.0.5 mysqld-max segs on TCP connect under RH 8.0

Description: Test mysql 4.0.5 beta installed from binary RPMs: MySQL-4.0.5-0, MySQL-shared-4.0.5-0, MySQL-devel-4.0.5-0, MySQL-client-4.0.5-0, MySQL-Max-4.0.5-0 mysqld-max starts normally (including binding TCP socket) and handles connections via Unix socket normally, but segs

RE: Perl DBI or C++ API Help!

For Perl... Take a look at the data_sources DBI class method http://search.cpan.org/author/TIMB/DBI-1.32/DBI.pm#DBI_Class_Methods or the ListDBs MetaData Method for DBD::mysql http://search.cpan.org/author/JWIED/DBD-mysql-2.1020/lib/DBD/mysql.pod#Priva te_MetaData_Methods Duncan

RE: join count and 0

I am wanting to see if there is a way to do a join but have count(id) show up as 0 when there is no records in the 2nd table. With out having to 2 selects. for example. orderid = has persons name and contact info select oi.id,oi.name, count(o.id) from orderid oi, orders o where

RE: SQL Select Idea

I believe that SELECT * FROM processo_arquivos ORDER BY date DESC LIMIT 10; Should do it. Mike Hillyer -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: SQL Select Idea Importance:

RE: SQL Select Idea

Something on the order of... SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,10 Seems like that ought to do it.. Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

RE: Select, mysql_fetch_array, PHP question

$item is probably undefined, unless you are assigning it a value somewhere else in your script. mysql_fetch_array is putting the result set in an associative array called $line, so $line['item'] would hold the result from your query. -Original Message- From: Beauford.2003 [mailto:[EMAIL

Problem doing Select * from table

I am using mysql 3.23.41 The tables are set to MyISAM. Table A i having problem with has 1.4 million records. When i perform a mysqldump it hangs on this table but dumps other tables. Also when i do a select * from table it hangs. But if i do select count(*) from table a get a result. The

Re: DateTime Calculations

From: Peter Abilla [EMAIL PROTECTED] (Column Two - Column One) = Total Minutes This is quite a hack, and there's probably a better way. But it works: SELECT ROUND( (unix_timestamp(column_one) - unix_timestamp(column_two)) /60 ) as my_minutes; I've scoured the mysql site and haven't

Re: DateTime Calculations

Peter, I would do something like this: (UNIX_TIMESTAMP(Column Two) - UNIX_TIMESTAMP(Column One))/3600 to give you the hoursnot sure about the minutes, but this should get you going! HTH, Cory '$valid_user' ; On Tue, 2002-12-03 at 10:45, Peter Abilla wrote: Suppose I

Re: Blob accepts LongBlob without error

From: Ryan @ Common Ground . To [EMAIL PROTECTED] It seems that MySQL accepts insertion of a string into a BLOB field that is longer than the maximum length of the BLOB data-type and it will still accept it. Perhaps MySQL should output an error or at least a warning to know the string is too

Re: help with picking the right index(s)

On Tue, 03 Dec 2002 12:47:28 +1100, Justin French wrote: my php script looks for a row matching this year (2002), this month (12) and this page (something.php) It would seem like one index on year/month/page would be appropriate then. It could be used for both lookups and for reporting

Re: Select, mysql_fetch_array, PHP question

On Tue, 3 Dec 2002 08:38:59 -0500, Beauford.2003 wrote: while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo $item; } Try echo $line['item']; - Steve Yates - Any sufficiently advanced magic looks like technology. ~ Taglines by Taglinator - www.srtware.com ~

Re: DateTime Calculations

On Tue, 03 Dec 2002 10:45:57 -0600, Peter Abilla wrote: (Column Two - Column One) = Total Minutes Assuming this doesn't work :) perhaps select UNIX_TIMESTAMP(col2) - UNIX_TIMESTAMP(col1) as TimeDiff This should give you an answer in seconds. [sql] - Steve Yates - File not found.

Re: Advice please

From: George Pitcher [EMAIL PROTECTED] I am about to start the planning process in moving my FileMaker/Lasso/PHP site over to MySQL/PHP. Before I get too far down the road, should I be using InnoDB or MyISAM tables? InnoDB does not support FULLTEXT indeces. Since FileMaker searches are always

re: change the data directory

Julia, Tuesday, December 03, 2002, 2:24:49 AM, you wrote: JS I have just installed the mysql binary on solaris 8. JS I would like have the data go to a different directory than /local/mysql/data. JS How do I get it to do that? JS I tried starting it with the --datadir set, but that

RE: join count and 0

select oi.id,oi.name, count(o.id) from orderid oi LEFT OUTER JOIN orders o ON o.order_id = oi.id group by oi.id,oi.name ; -Original Message- From: Charles Verge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 11:53 AM To: [EMAIL PROTECTED] Subject: join count and 0

Re: TimeDate in SQLServer7

Sam, heads up! MySQL list members don't want this = spam! =dn - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 4:54 PM Subject: TimeDate in SQLServer7 Hi I am inserting a Time like 06:00 from my code to a Date/Time

RES: SQL Select Idea

Hi Jim and others that tried to help me! Thanks for any kind os answer. Well, the SQL command that you suggested don't work for me. Below, I will show What I want and what I get if I use the select command you suggested: 1) What I have: Table: processo_arquivos _

RE: MySQL: Select Not In Table

SELECT Table1.ID FROM Table1 LEFT OUTER JOIN Table2 ON Table1.ID=Table2.ID WHERE Table2.ID IS NULL; -Original Message- From: Henning Sittler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 10:16 AM To: 'mysql users' Subject: MySQL: Select Not In Table Just

Re: DateTime Calculations

On 12/3/02 10:45 AM, Peter Abilla ([EMAIL PROTECTED]) wrote: Suppose I have a datetime in the following format: Column One Column Two 1999-09-17 16:30:18 1999-09-18 13:30:18 I want to calculate the minutes like (Column Two - Column One) = Total Minutes I've scoured

RE: Trying2insert Date2table

Missing quotes. It should read: sNewCallBackSQLINSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113 , '01/01/2002' , '0:00') -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:41 AM To: [EMAIL PROTECTED]; [EMAIL

replication problem

Hi I am using replication with MyISAM tables with MySQL. I want to check once in a while that the master and slave are synchronized through software. Is there an elegant way of doing it except for using SHOW MASTER STATUS with the file name and pointer? Thanks Gil Shai Savantis Systems  

Re: DateTime Calculations

Try this: select sec_to_time(unix_timestamp(column_two) - unix_timestamp(column_one)) Should give you the elapsed time in hh:mm:ss format. --jeff - Original Message - From: Peter Abilla [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 8:45 AM Subject: DateTime

mysql.sock error

at first when trying to run mysql it did this: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 3124 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql 021121 02:27:42 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql then, i stopped

Problems changing password following installation

I downloaded MySQL 3.23 for my Linux server and installed it using rpm -Uvh *.rpm. The installation went OK and at the end, I was given a Don't set the root password reminder. Specifically, it tells you to set the password using two commands: /usr/bin/mysqladmin -u root password 'new-password'

relational is relational is relational, but ...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi again, all -- I apologize in advance for asking kindergarten-level questions on the list, but my head is getting really bruised from this one. I'm trying to understand what makes a relational (not necessarily transactional) database and how, in

Re: TimeDate in SQLServer7

That is not the proper format for a date/time field. It should be CCYYMMDDHHMMSS as a number or 'CCYY/MM/DD HH:MM:SS' as a string. You may not use any other format for an insert/update. [EMAIL PROTECTED] wrote: Hi I am inserting a Time like 06:00 from my code to a Date/Time field in

Re: truncate table ...

Sekhar, - Original Message - From: Sekhar.Thota [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, December 03, 2002 3:14 PM Subject: truncate table ... Dear All, I am getting a severe problem with truncate comand( InnoDB Tables - Mysql 3.23.52-MAX on Linux 7.3)

  1   2   >