RE: can you "see" an index

On 29-Jun-01 Tom Beidler wrote: > Newbie question. > > I recently altered a table by adding an index. I then DESCRIBEd it and it > didn't show an index. Is this correct and if so, how do I know it's there? > mysql> show keys from da_table Regards, -- Don Read

Re: Re: Query Slowness

On 29-Jun-01 [EMAIL PROTECTED] wrote: eat this & die a horrible death: database,sql,query,table. ... damn robot POS (ghrrr). > > > On 29-Jun-01 Kris Amy wrote: >> yes i search on phone number. it's indexed(7) and the format of the phone >> data is (XX) XXX

can you "see" an index

Newbie question. I recently altered a table by adding an index. I then DESCRIBEd it and it didn't show an index. Is this correct and if so, how do I know it's there? Thank you, Tom >>.>>.>>>.>.>. Tom Beidler Orbit Tech Services 805.682.8972 (phone) 805.682.5833 (fax) [EMAIL

Re: MySQL JDBC

Thank you, but I should have mentioned that I tried this before already. So this is not the solution. What is really strange is that MySQL is only mentioning the host IP in the first error message. I used different versions of JDK and mm.mysql driver. Any other ideas about that problem ? Thomas M

Re: Re:innobase bug w/ 3.23.29???

> Heikki> Hi! > Heikki> I checked that in the COUNT(*) below InnoDB does > Heikki> not fetch the whole row if it does the query through > Heikki> a secondary index. It may sometimes have to > Heikki> fetch it to determine if the row should be visible > Heikki> in the current consistent read, the t

RE: logs on nt4--Max Size

My Logs get pretty hefty with my PHP MySQL site, is there a Max log size or something that will start another log file by date or when a certain size is reached it's cleared. Had to ask Cheers -Original Message- From: Gerald Jensen [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001

Re: Query Slowness

On Fri, 29 Jun 2001 13:19, Kris Amy wrote: > i have a database and a table:- > > mysql> describe phone; > +---+--+--+-+-+---+ > > | Field | Type | Null | Key | Default | Extra | > > +---+--+--+-+-+---+ > > | name | blob |

mysterious loss of disk space

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've searched through the archives, and while some things were slightly similar, I couldn't find anything that matched well. I'm using the Linux Debian packages for MySQL 3.23.39. The problem I'm having is this: While the program i'm developing is r

Re: Query Slowness

yes i search on phone number. it's indexed(7) and the format of the phone data is (XX) . is there anyway this could be optimized. I will eventually remove the spaces and the first 4 characters from the input data and reload it in Kris Amy -Original Message- From: Don Read <[EMA

RE: Query Slowness

On 29-Jun-01 Kris Amy wrote: > i have a database and a table:- > > mysql> describe phone; > +---+--+--+-+-+---+ >| Field | Type | Null | Key | Default | Extra | > +---+--+--+-+-+---+ >| name | blob | | | |

creative work. SSZGO Multimedia design company

[EMAIL PROTECTED] WWW.SSZGO.COM SSZGO International is back, introducing its new website WWW.SSZGO.COM v4 IT IS RANDOM...IT IS MODULAR... a new level in flash actionscripting... ARE YOU IN NEED OF CREATIVE WEBWORK? DONT MISS THE OPPORTUNITY : GREAT CUSTOM DESIGNS AT GREAT PRICES, HU

Query Slowness

i have a database and a table:- mysql> describe phone; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | name | blob | | | | | | add1 | blob | | |

Re: Connecting to MySQL w/VB

just curious, how do you connect to mysql through ASP? i have tried connecting with "MyODBC", i installed myodbc and then i create the connection string in asp like this set conn=server.createobject("adodb.connection") conn.open "driver={mysql};server=192.168.0.1;user=user;pass=pass;database=db1

Re: Connecting to MySQL w/VB

- Original Message - From: "Jason Brunk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 8:18 PM Subject: Re: Connecting to MySQL w/VB > i know i am definitly knew at this, but his permissions could be set more or > less for read only. Yes, it's possible that t

Re: Connecting to MySQL w/VB

i know i am definitly knew at this, but his permissions could be set more or less for read only. i am just spitting junk out, i am new, but i don't like sitting idle in a group. i have been watching this thread closely, because i do developement on a large scale in ASP and VB. so just ignore me

Re: cursor definition

At 7:08 PM + 6/28/01, Yamuna Vallipuram wrote: >Hi... > >I am new to MySQL and trying to write some database queries. > >(Basically, I am developing a WEB application using Pearl script. >The data is stored in MySQL database. Pearl scripts access the >database via Pearl DBI) > >I could not f

Problem in initializing mySQL on Windows Plateform

Hello I had installing mySQL as well myODBC, but when I run mysqld it has given an error C:\>mysqld error: Found option without preceding group in config file: c:\my.cnf at line: 1 Program aborted Next time I had write a file my.cnf as innodb_data_file_path = ibdata1:400M;ibdata2:40

Re: Connecting to MySQL w/VB

- Original Message - From: "Robert Skinner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 7:44 PM Subject: Connecting to MySQL w/VB > I am trying to connect to MySQL using a connection string using VB6. The > read part is great but I don't seem to be able to

Re: message traffic

All of the suggested methods for filtering mail from MySQL list is great...for those using an actual mailer program. For people sitting on web based email services, they don't have that capability (except for maybe sorting based on subject, receive date, or something like that), and having s

Increasing Packet Size

How can I increase the packet size used in mySQL i.e. increase the value of 'max_allowed_packet' to a larger number from a script. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Connecting to MySQL w/VB

I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [EMAIL PROTECTED] - Before posting, please ch

Re: Very difficult Query! Help plz!!

>hi all together! > >i'm turning to your mailinglist as last chance to find s.o. helping >me with my problem. > >the situation is as follows: > >i got a table on a mysql-database, queriing it by php4. the table >consists of all planets of the planetarion.com-system. these >information consists

bug on Sum() Function with Null Value

Dear Sir: The Version of Mysql is mysql-3.23.38. The OS is Win NT SP 5. I have a problem with below SQL Statement "Select Sum(Cost) as TotalCost from Item" All the entries for Cost Field has the Value Null. The result of this Query is TotalCost = 0. But is not it suppose to be Null

Re: MS IIS web logfiles

I have a Perl script that I use to parse and insert all my Unix logfiles into a MySQL server. I can post the script if you would like to have / view / steal of whatever. -Paul - Original Message - From: "Dennis Salguero" <[EMAIL PROTECTED]> To: "Charles Henderson" <[EMAIL PROTECTED]>; <[

Re: message traffic

I'm filtering on "List-ID" header contains "mysql.mysql.com" Works great. j- k- On Thursday 28 June 2001 17:05, Sherzod Ruzmetov wrote: > I do aggree with dave's point. Could we do that, please > > On Thu, 28 Jun 2001, Dave Halliday wrote: > > Quick question - just signed up for this li

Re: message traffic

On Fri, 29 Jun 2001 01:14, Dave Halliday wrote: > Quick question - just signed up for this list and I was wondering if it > would be possible to put a " [MySQL] " tag in the subject line? > > There doesn't seem to be a standard identifier in the messages and > although I am filtering the entire

Re: message traffic

I do aggree with dave's point. Could we do that, please On Thu, 28 Jun 2001, Dave Halliday wrote: > Quick question - just signed up for this list and I was wondering if it > would be possible to put a " [MySQL] " tag in the subject line? > > There doesn't seem to be a standard identifier in

Re: Very difficult Query! Help plz!!

Hello. On Thu, Jun 28, 2001 at 10:48:23PM +0200, [EMAIL PROTECTED] wrote: [...] > the user inserts some wished dates (the lowest score, the searched > planet may have, the highest, the highest number of roids and the > lowest..) and the number-interval in wich the _galaxy-score_ may be > included

Re: MS IIS web logfiles

- Original Message - From: "Charles Henderson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 4:33 PM Subject: MS IIS web logfiles > How can I get mySQL to create a table for a IIS web logfile (*.log) ? The > file is very long (maybe 1 million records +) and t

Re: Help - Create Views

Hello. Views are not supported (yet). I tried to search for VIEWS in the online manual and it came up with the following section as first link: http://www.mysql.com/doc/M/i/Missing_Views.html Bye, Benjamin. On Fri, Jun 29, 2001 at 02:44:44AM +1000, [EMAIL PROTECTED] wrote: > Hello, >

MS IIS web logfiles

Hi, 8 -) I'm a newbe to mySQL. So, please excuse me if I ask a question whose answer appears obvious to you. How can I get mySQL to create a table for a IIS web logfile (*.log) ? The file is very long (maybe 1 million records +) and there are 16 space separated data fields (17 if you include

Re: tar.gz.asc ????

On Thu, 28 Jun 2001, wkd wrote: > > Does any body know how to open a x.tar.gz.asc file? > I know what a tar file and gz but i can't find anything on how to > open a tar.gz.asc file. .tar.gz.asc is an ascii file containing the signature of the .tar.gz in question - either generated by md5

Update based on subselect

I have seen the smart way to insert data into tables based on a select statement posted recently on this list. Is this also possible for an update query? I want to do something like: UPDATE TABLE foo SET foo.field1 = SELECT bar.field1 FROM bar WHERE foo.field2 = bar.field2; Thanks in advance h

Re: libmysql.dll - documentation pls..

NOTE: I replied off-list First note: I like the e-mail address. Really great. Secondly: The best VB/DLL documentation you could find MIGHT be a project that has done what you want. If you download the source classes for the MyVbQl VB API it will tell y

Re: logs on nt4

Pete: Check the config file (C:\MY.CNF or C:\WINNT\MY.INI) ... you should see a line like: log=d:/mysql/mysql.log If the line if commented out (# log=d:/mysql/mysql.log), then logging is off. Remove the #, shutdown and restart the mysqld server. Gerald Jensen - Original Message --

tar.gz.asc ????

Does any body know how to open a x.tar.gz.asc file? I know what a tar file and gz but i can't find anything on how to open a tar.gz.asc file.

libmysql.dll - documentation pls..

All, I want to use the libmysql.dll in Visual Basic, I have seen a few dll's floating around that do the wrapping for you but I want to do this myself. Can someone point me in the direction of an example or some documentation.

logs on nt4

Hi, Where would I find the logs files from Mysql on a NT4 server? I have Nusphere Mysql installed with Apache/PHP and Mysql I monotor the Apache Error and Access logs, but should'nt there be logs generated by Mysql? I don't want to run out of disc space cause I neglected to clear them out. Than

mysql_connect() blocking problem

Hi All, My unix client process got blocked at the reconnect attempt when the Linux box running MySQL server went down. I don't know how to set timeout value on the mysql_connect() call. Anyone know a good way to stop the function from blocking forever without killing the process ? I am using mys

SELECT using > and limit not optimized.

>Description: I am trying to get the next record given a key (numeric or string), What is the best way to do this. I am currently using: SELECT * from wk004.slsf01 where ___RecNo > 3000 limit 1; table typepossible_keys key key_len ref rowsExtra s

Very difficult Query! Help plz!!

hi all together! i'm turning to your mailinglist as last chance to find s.o. helping me with my problem. the situation is as follows: i got a table on a mysql-database, queriing it by php4. the table consists of all planets of the planetarion.com-system. these information consists of each 3 c

Re: Date format problem

On Thu, 28 Jun 2001 21:49:57 +0200, "Sebastiaan J.A. Kamp" <[EMAIL PROTECTED]> wrote: if your using perl, heres a real simple way to format your date: my $date = "28/06/2001"; my($mn,$day,$yr) = split '/',$date; my $db_date = join('-',$yr,$mn,$day); # Your output should now be $db_date = 2001-0

RE: Newbie problem with winmysqladmin

How did you get MySQL up and running on your PC? I am trying to get MySQL running on my PC and I cannot find out how to even start it. Is there an installation manual in the files? Is there a manual on how to use MySQL in the files? Bomber Steel -Original Message- From: Michael Tam [mai

Re: Newbie problem with winmysqladmin

At 12:28 28/06/2001 -0700, Michael Tam wrote: Hi, WinMySQLAdmin only shows for you the db and table info, when is able to do a connection using an user name and his password which are edited at first start and when the my.ini file exist. So, if you are not using my.ini file, then the tool doesn't

Re: Newbie problem with winmysqladmin

Michael Tam writes: > Hi All, > > I am new to MySQL and have a problem using winmysqladmin. MySQL is working >fine, which I can access the database from my Java apps. However, when I tried to >use winmysqladmin to obtain my db and table info, winmysqladmin never connects with >MySQL and

Replication updating two slave databases

>Description: Using replication and redirection. Master database named 'ftc'. Slave database named 'ftcprod'. Using replicate-rewrite-db to direct the updates to the slave ftcprod. my.cnf is: [cgi]# more /etc/my.cnf [mysqld] server-id=111757 replicate-do-db=ftc repli

Re: HELP: C API: mysql_query INSERT not working...

James Gosnell writes: > > I'm not getting any errors at all and the program runs just fine, except > that it's not inserting! :) selects work and everything else. Am I > missing a function or structure? Thanks... > > James Gosnell > [EMAIL PROTECTED]#include > #include > #include > You shou

RE: Date format problem

What programming language are you using? Hi guys, does anyone help me with this simple thing ?? I have a date format problem, I need a spanish format please read the following lines: Receive from input "28/06/2001" Want to change it to "2001-06-28" to write the Database Use to do it "DATE_FORM

Re: Trouble with mysql

Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello Michael, Peter> Thursday, June 28, 2001, 1:52:09 PM, you wrote: Peter> I started to often get the followings in a log file: Peter> 010628 13:49:28 Aborted connection 627619 to db: 'counter' user: 'titan' host: `pan.

RE: setting up MySql database

http://www.mysql.com/manual.php (the manual) Your New Friend -Original Message- FROM: [EMAIL PROTECTED] TO: [EMAIL PROTECTED] DATE: Thu 6/28/01 13:21 SUBJECT: setting up MySql database Hello everyone, I am a beginner, can you please put me through setting up MySql database downloaded fr

Newbie problem with winmysqladmin

Hi All, I am new to MySQL and have a problem using winmysqladmin. MySQL is working fine, which I can access the database from my Java apps. However, when I tried to use winmysqladmin to obtain my db and table info, winmysqladmin never connects with MySQL and I can't obtain the info.

Re: Re:innobase bug w/ 3.23.29???

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Hi! Heikki> I checked that in the COUNT(*) below InnoDB does Heikki> not fetch the whole row if it does the query through Heikki> a secondary index. It may sometimes have to Heikki> fetch it to determine if the row should be

Re: Date format problem

On Thu, 28 Jun 2001 15:30:14 -0300, Alejandro Ralla <[EMAIL PROTECTED]> wrote: You would need to reformat the input date first, within your middleware, like Perl or PHP. Then you would be able to enter it into your db. >>Hi guys, does anyone help me with this simple thing ?? >> >>I have a date

cursor definition

Hi... I am new to MySQL and trying to write some database queries. (Basically, I am developing a WEB application using Pearl script. The data is stored in MySQL database. Pearl scripts access the database via Pearl DBI) I could not find any info about cursor definitions in MySQL documentation

Re: Inserting values into table

Jon Haworth wrote: > Hi list, > > Sorry if this appears twice, our mail server is playing up at the moment. > > We've got an sql file that was created using mysqldump on an NT box. The > info in this file needs to be imported into MySQL on a Linux box. When I run > >/usr/local/mysql/bin/

Frequent server side crash on FreeBSD

I am running mysql version 3.22.32 on freebsd version 4.2 I am running a high traffic BBS on an Apache web server (PERL) that connects to the database server through DBI. MySQL is crashing every two minutes or so. - My file descriptors and max files are set high, per process and for the system

setting up MySql database

Hello everyone, I am a beginner, can you please put me through setting up MySql database downloaded from the site http://www.mysql.com . I could have downloaded the wrong thing. Thanks. Dots. - Before posting, please check:

Re: message traffic

I will give this a shot - thanks!!! Dave > > > > There doesn't seem to be a standard identifier in the messages and > > although I am filtering the entire header looking for instances of " > > mysql " my reader ( Pegasus ) doesn't always catch it. > [snipped to conserve bandwidth] > > Ty

Re: MYSQL errmsg.sys

At 18:18 28/06/2001 +0200, PABLOSKY® wrote: Hi, Thanks for the bug report. Sorry for the inconvenience with the partial translation of the errmsg.sys file. I will the translation and send you the new errmsg.sys as fast as possible. Regards, Miguel >Dear friends, > > I'd like to know how to

Date format problem

Hi guys, does anyone help me with this simple thing ?? I have a date format problem, I need a spanish format please read the following lines: Receive from input "28/06/2001" Want to change it to "2001-06-28" to write the Database Use to do it "DATE_FORMAT (inputdate, %Y-%m-%d)" It doesn't work

RE: message traffic

Why are you complaining, Don Read? I think the guy is making a worthy suggestion, and since you are so "flawless", good job getting the lsit name wrong. --On Thursday, June 28, 2001 12:53 -0500 Don Read <[EMAIL PROTECTED]> wrote: > > On 28-Jun-01 Dave Halliday wrote: >> Quick question - just

Applet problem

Hi, We have been running MySQL for a while accessing it with the MM driver and in applications everything works well. I'm a newbie in trying to build an applet, and when I try to access the driver to make a connection, I get a "notinited" error in the browser. In the Apache error_log is a mess

RE: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete a

On 28-Jun-01 Jawad Khan wrote: > Hope you can find the problem in the following SQL command: > > delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms) > limit 1 ; > That is a sub-select, currently unsupported in MySQL. try : delete from alarms order by raiseTime limit 1;

Re: More questions about Fulltext searching.

--- Stoyan <[EMAIL PROTECTED]> wrote: > hi, > > why don't you try to use this: > > SELECT * FROM BOOK WHERE author LIKE '%charles%dickens%'; That query takes 6.4 seconds. My query (MATCH author AGAINST ('charles') and match author against('dickens')) takes 1.3 seconds. Fulltext searching is MU

Re: Integrity checks

When you delete a row from a table that may be referenced in another table... you must delete all references to it from the other tables. This is done in the same way in which you deleted the first row... ryan > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > As long as MySQL doesn't manage

RE: Unique select

On 28-Jun-01 Matt \"TrollBoy\" Wiseman wrote: > I'm attempting to do a select via PHP where I want to get a list of unique > records for example if my table is as follows > +-+--+ >| bluefish| blah| > +-+--+ >| bluefish| blah| > +-

Re: Re:innobase bug w/ 3.23.29???

> ryc> > Heikki> Well, mystery solved :). Except that why MySQL uses hours to > Heikki> sieve away the extraneous rows in the first query. > >> > >> To be able to answer the question why: > >> > >> SELECT COUNT(*) FROM table1 WHERE col1=0 and col2=0 > >> > >> Is slow, I would need to get an EXPLA

RE: message traffic

On 28-Jun-01 Dave Halliday wrote: > Quick question - just signed up for this list and I was wondering if it > would be possible to put a " [MySQL] " tag in the subject line? > You just signed up & want everybody to accomodate your broken mailer. > There doesn't seem to be a standard identif

RE: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as shown (a correction)

server version 3.23.35 > -Original Message- > From: Khan, Jawad [COLE:6S34:EXCH] > Sent: Thursday, June 28, 2001 1:13 PM > To: '[EMAIL PROTECTED]' > Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete > as shown > > Hope you can find the problem in the f

RE: Must use '#' in fieldnames

Here's a messy hack that would let you use your column names like 'a35#70' to select and insert. Set up a table like this: col1a35#70 col2a35#71 col3a35#72 ... Then make a routine in your middleware that select * from this table and returns the results in a named array or hash array

Re: message traffic

On 28 Jun 2001, at 8:44, Dave Halliday wrote: > Quick question - just signed up for this list and I was wondering if it > would be possible to put a " [MySQL] " tag in the subject line? Please - no, those take up to much room and remove from the Subject area. I *hate* those tags, they're use

Unique select

I'm attempting to do a select via PHP where I want to get a list of unique records for example if my table is as follows +-+--+ | bluefish| blah| +-+--+ | bluefish| blah| +-+--+ | redfish | blah| +-+

I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete as sho wn

Hope you can find the problem in the following SQL command: delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms) limit 1 ; raiseTime is of type BIGINT.

MYSQL errmsg.sys

Dear friends, I'd like to know how to compile my own 'errmsg.txt' to 'errmsg.sys'. I know that there is an utility called 'comp_err' but i dind'nt find it in the Windows distribution of MYSQL. The matter is that the error message file for spanish language in the last distribution isn

Help - Create Views

Hello, I am just learning Mysql and was reading a general SQL book. The book talks about creating views for joins (CREATE VIEW ...)that you regularly use. I can not find out if Mysql supports this and if it does, how do I perform this. Thank you in advance, Bob -

Data disappearing problem

Hi, I'm having a very annoying and elusive problem. You probably won't be able to help me, but any guess or pointer would be appreciated nonetheless. The main table in the db contains some 50 fields, mostly of type varchar and tinyint. This table is updated through php. Now the problem is: so

RE: restoring one table from a mysqldump --all

On 28-Jun-01 Dave Brown wrote: > Is there an easy way to restore just one table from a mysqldump of all the > tables? > If the (empty) table already exists: grep " INTO table VALUES " backup.dmp | mysql dbname If it doesn't then use awk to create it: awk '/^CREATE TABLE table/,/^);/' backup.dm

Inserting values into table

Hi list, Sorry if this appears twice, our mail server is playing up at the moment. We've got an sql file that was created using mysqldump on an NT box. The info in this file needs to be imported into MySQL on a Linux box. When I run /usr/local/mysql/bin/mysql < /home/jon/dump.sql I get "Err

cannot open shared libraries

I get this error on my mysql client (filter): error in loading shared libraries libmysqlclient.so.10: cannot open shared object file: No such file or directory Vien Huynhle Clearsail Communications

RE: Must use '#' in fieldnames

if you just need to call your field a35#70 for retrieval purposes why don't you call it something else and alias it in your select statements. select col1 as 'a35#70' from test; if this doesn't help perhaps explain why you absolutely need your field named a35#70. it will make it easier to find

message traffic

Quick question - just signed up for this list and I was wondering if it would be possible to put a " [MySQL] " tag in the subject line? There doesn't seem to be a standard identifier in the messages and although I am filtering the entire header looking for instances of " mysql " my reader (

restoring one table from a mysqldump --all

Is there an easy way to restore just one table from a mysqldump of all the tables? Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) T

Re: thoughts on raw file systems

WW> Can you use a raw partition with MySQL much like you can with Oracle or WW> Sybase? Probably tables with InnoDB type can work on raw devices. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)

Re: Creating Table with a Default Datetime field

At 11:57 AM +0200 6/28/01, Kaneda K wrote: >At 10:38 27/06/2001 -0700, you wrote: >>Sorry, for quoting the manual but this might be just another example where >>it could have the answer right away: >>Hannes >> >>http://www.mysql.com/doc/D/A/DATETIME.html > >On my own mysql version : > Date TIMEST

Request for posting of Solaris package of MySQL 3.23 distributions

I would greatly appreciate your posting of a Solaris package of the MySQL 3.23 distributions in order to simplify installations on a Solaris platform. Please cc me directly in your response if this would be possible. many thanks for your help, Bryan Bryan J. Byerly [EMAIL PROTECTED] --

Re: Must use '#' in fieldnames

Because our company works with a standard - tabledefinition in many enviroments like db2, mssql ... So I got no choice but to use those crazy fieldnames. And because the fieldnames work fine on the other db-systems we use, I hoped there is a trick that lets even MySQL work with these names. Mit

Re: Imagenes en mysql

Carlos - si - las imagenes se pueden almanecer en mysql - el typo de campo es 'blob'. Nicole [EMAIL PROTECTED] wrote: > > Hola, > para un desarrollo en java con acceso a una base de > datos en MySQL, necesitaria saber si alguien ha > implementado imagenes con MySQL? . ¿Se pueden almacenar > im

Re: Must use '#' in fieldnames

> create table test ( > a35#70 char (70)); Looks like the reason is # is the remark sign like // in php Why don't you call the columns any name? Then you write INSERT INTO table (col1, col2) VALUES ('a35#70', 'id') or whatever. -- Herzlich Werner Stuerenburg

RE: thoughts on raw file systems

why not... it improves speed and removes the overhead and limitations of the FS. -Original Message- From: David Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 9:20 AM To: Wyly Wade Subject: RE: thoughts on raw file systems I certainly hope not :) -Original Message-

Re: Innodb and timestamps

Hi! Thank you for the bug report. 3 lines of code had been omitted from mysql/sql/ha_innobase.cc and that causes the timestamp not to be updated in a row update. If you compile yourself you can use the patch below. Add the lines marked with '+' to function ha_innobase::update_row. Best regards,

HELP: C API: mysql_query INSERT not working...

I'm not getting any errors at all and the program runs just fine, except that it's not inserting! :) selects work and everything else. Am I missing a function or structure? Thanks... James Gosnell [EMAIL PROTECTED] #include #include #include int main (void) { MYSQL *connection, mysql;

Re: Got timeout reading communication packets

Hi! > How do you know that row is truncated ?? > Filesizes for one. With just this single query the database is ca. 65K, the update log with just this query in it is ~600k. > If you have binary data in the blob field, when you retreive a result > set, you will get it back in the binary, une

Must use '#' in fieldnames

Hello everybody, I have to create a table on a MySQL-Server with fieldnames like a35#70. if I ty it that way create table test ( a35#70 char (70)); on the mysql - prompt, the creation fails. Even brackets like in MsSQL or '`' doesn't help. Can anybody tell me what to do? thank Dirk

Imagenes en mysql

Hola, para un desarrollo en java con acceso a una base de datos en MySQL, necesitaria saber si alguien ha implementado imagenes con MySQL? . ¿Se pueden almacenar imagenes en esta base de datos, cómo debe ser el tipo de campo? Gracias, Carlos Miglioli Gobierno de Mendoza ARG. [EMAIL PROTECTED

Re: Problem in Using two web servers

This is really quite basic. Server B must be running with PHP and mysql support. It connects to mysqld on server A, which must have granted the proper privileges to server B Maneet Puri wrote: > Dear Sir, > > I am trying to connect to the MYSQL server running on web server say A, thru my >scr

Re: select query for duplicate records

That makes sense, sound like I'm redoing in PHP what the UNIQUE column already does. So all I need to do is modify my PHP trap using mysql_affected_rows() = 0, retun a error messagu to the used indicating a rcord already exists. Will try it, THX! Pete Paul DuBois wrote: > > At 5:46 PM -0500 6/27

Re: Re:innobase bug w/ 3.23.29???

Hi! I checked that in the COUNT(*) below InnoDB does not fetch the whole row if it does the query through a secondary index. It may sometimes have to fetch it to determine if the row should be visible in the current consistent read, the trx id is stored in the whole row in the primary key index.

Re: host.ISM

Make sure mysql owns all the directories and files in its database directory. If you have never seen host.ISM on your .22 server, then you never looked. It sounds like you also ran mysql_install_db and overwrote your privilege tables. That is why they are now .MYD and .MYI. You also probably

Re[4]: Duplicate entry

> Doing a SELECT and then an INSERT without LOCK TABLE doesn't seem very > robust to me. I agree. (Blush) > Why don't you simply try to INSERT and if it fails due > to a duplicate sid generate another session ID? Good idea. (Again: blush) Thanks. -- Herzlich Werner Stuerenburg __

Re: Error during compilation.

You also need to link in libz, so make it "-lmysqlclient -lz" mysql novice wrote: > Hi all, > > I don't know how many times this question has come up > in discussion, but I am new to the group, so please > forgive. More over, I am very new to SQL itself. > > I have a small program, that connec

  1   2   >