Please , help !

Hi, I'm developing a web site with PHP and I want to show some information only if I'm able to connect to a mysql database . If I can´t connect , simply I don´t show some parts of the web page. Sounds easy and it works fine in local , but when I install it in the web server ,if it can´t conne

help me

hi Just to clarify my requirements again: i need to add 2 buttons like ADD COMMENT & EDIT COMMENT at the bottom of every page of my site (which uses PN). So that users can enter and edit (their own) comments for each page on the site. for eg look here: "http://www.mysql.com/doc/D/A/DATETIME

Is there a timeout or similar en MySql?

Hi, I'm developing a web site with PHP and I want to show some information only if I'm able to connect to a mysql database . If I can´t connect , simply I don´t show some parts of the web page. Sounds easy and it works fine in local , but when I install it in the web server , if it can´t c

Re: How to change DATETIME format ??

mysql / query -- I have a DATETIME column type with format -MM-DD and I'd like to have format DD-MM- what do I have to do ? _ MSN Photos est le moyen

FW: Simple SQL

-Original Message- From: Sampson, Peter Sent: 16 May 2002 09:35 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: FW: Simple SQL Roger et al. Thanks for your response in reference to MySQL Query I'm interested to find out more on how to do the following. You say that an "appl

Re: problem with libmysqlclient_r.so

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >> I am not agree. I take _another program_ which work fine during ~2 year >> with previouse mysql version (mysql-3.23.44 for example). >> And I send dump from this program. >> >> Why I interested libmysqlclient_r? >> I have

Re: How to change DATETIME format ??

Hi, I think you can't. You can create char field type on table (i.e. char(10)) and when you wish to do some date comparison you can use the next mySQL functions:LEFT,MID,RIGHT,TRIM. I.E: mydate->field in a_table:char(10); date on this field: '10.01.2001','30.02.2000',...etc. select * from a_table

Re: problem with libmysqlclient_r.so

Hi! > >> Under FreeBSD gethostbyname is not thread-safe > >> And there is no thread-safe gethostbyname_r > >> (function exist but not thread-safe) > >> > >> Are mysql know about this!!! > > Just a note about this problem: > > We will add a wrapper for gethostbyname() in 3.23.51 and the 4.0.2 > th

Re: Bug in fulltext search in latest mysql-4.0.2 source

Hi! On May 15, Jocelyn Fournier wrote: > A small question : > > I have : > > CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) > > in the field 'nom' . > How could I match BCI-11N for exemple ? (BCI* return nothing :( ) > > Thanks, > Jocelyn Actually, it's a question for [EMAIL PRO

How to Load a Database to other Server

Dear all I had a mysql Database in one of my Server, now i want to transfer this whole Database to another Server, what should i do? 1. How i can export this Database to a file 2. How i can Load this File into my another Server which create a database exactly same as the old Server? Thx a lot! J

Re: How to change DATETIME format ??

mysql,select,query,sql >mysql / query >-- > >I have a DATETIME column type with format -MM-DD and I'd like to have >format DD-MM- > >what do I have to do ? Does it matter in what format it is in the database? you can s

RE: How to Load a Database to other Server

not sure about the Linux guys, but if you're using Windows just copy the directory for your database (in the mysql\data directory) to the new server. Restart MySQL Server on new machine Cheers Dave -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 10:05 To: [

Systems of a high degree of availability

Hi, all Links to the information are necessary. Master/slave the architecture. Implementation of the system of a high degree of availability on a basis master/slave. Implementation of a control master/slave. Examples of the code of implementation of a monitoring system. Who realized thi

[BUG] CONCAT_WS + GROUP BY display problem

Greetings, While working on a routine to clean out some duplicate entries from our IP management table, I stumbled upon the following errant behavior... Logging to file 'concatbug.txt' mysql> \s -- Connection id: 73465 Current database: OBFmtable Current user:

Re: How to Load a Database to other Server

On Thu, 16 May 2002 17:05:25 +0800 "Jack" <[EMAIL PROTECTED]> wrote: > Dear all > I had a mysql Database in one of my Server, now i want to transfer this > whole Database to another Server, what should i do? > > 1. How i can export this Database to a file If your DB server (source) is not runni

Upgrade

Hello I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL Version 3.23.49a ? I havn'tfound it in the documentation so i hope you could help me Greetings Ed - Before posting, please check: http://www.mys

Newbie JOIN question

Hi all. This may (or may not) be a newbie question. But I've called it a newbie question since I am a newbie to MySQL (and SQL for that matter). Here is what I want to do: I want to join three tables into one, where one specific colomn may have more than one entry for each row. The spesifics ar

Re: problem with libmysqlclient_r.so

Hi! > "Michael" == Michael Chang <[EMAIL PROTECTED]> writes: >> For example, have you called mysql_thread_init() before calling >> mysql_real_connect() in all your threads ? Michael> However, to my understanding, mysql_thread_init() is not needed if Michael> only one database connection is

Re: How to Load a Database to other Server

What platform (Win32, Linux, BSD, etc.) are you using? If you have Win32 machine in the mix (doesn't need to be a server), suggest you use the Export tool in MySQL-Front (http://www.anse.de/mysqlfront/). We've replicated databases from Win32 to Linux and Linux to Linux with it many times. Gerald

Re: gcc for newer mysql versions - what's needed exactly ?

On Tue, 14 May 2002, j.random.programmer wrote: > Can someone (who knows this sort of thing) give a > layman's introduction to the interplay between > various gcc versions and various mysql versions > (3.49, 3.50, 4.01 etc) ? I have some linux boxes > and don't really want to have to install/us

Re: problem with libmysqlclient_r.so

Hi! > "Andrey" == Andrey Kotrekhov <[EMAIL PROTECTED]> writes: Andrey> -LДобрый день.-A Andrey> Are mysql know about this!!! >> >> Sorry but if your OS doesn't support gethostbyname_r(), then >> mysql_real_connect() is not thread safe (I have just updated our >> documentation about this)

Can't connect to ....

Hi everybody. Just installed Red Hat Linux on a machine. I included the MySQL packages but cant get it up working. When starting from shell it looks like this: $ mysql ERROR 2002: Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2) What have I done wrong? best r

RE: Fw: Simple SQL

Gabriel. This works fine and the two tables talk to each other. BUT, My website can have 5 - 10 news stories per month. So in the tblNews I could have nMonth t1 t2 2 I am a line This is one, too. 2

problem inst ...bench... rpm

Hi, I have installed MySQL from rpm's downloaded from mysql.com. All seems ok except when I try to do "rpm -i MySQL-bench-3.23.49a-1.i386.rpm" I get an error message from rpm saying the I need "MySQL-DBI-perl-bin". Where can I find this "MySQL-DBI-perl-bin"? Thanks in advance! /Curt --

Speeding up a huge sql query

Hi there, I have a huge querry which takes for ever on a table containing only 2000 records. Maybe there is a way to reorganize this querry since it contains a join and lots of other stuff I am not really familar with. Let me first show you the sql query: SELECT DISTINCT u.user_id,

automatic server start paramaters

On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql 3.23.??, I think) I have a testing and programming box, only one user is connecting to the database at a time. Now, the mysqld startup sequence automatically starts 5 occurances of the mysqld server. Id like to cons

Fwd: NDN: automatic server start paramaters

Dear MySQL list monitors... Please do something about the following address that has apparently joined the list. every time I send a message to the list, I get a bouned message saying that the message is undeliverable. Thanks >From: "Mailer-Daemon" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED

mysql index question

Regarding mysql... 1) Are primary keys and foreign keys by default indexes for a table? 2) Do I have to use a special data other than float to allow for negative numbers, i.e. I want to be able to enter -1.76 and be able to later do math against that number... Thanks, Taylor Taylor Lewick U

RE: Speeding up a huge sql query

[snip] SELECT DISTINCT u.user_id, u.user_name, max( if(u.sex=2,25,0) + if(u.age=4,25,0) + if(u.country='gm',25,0)+ if(l.language_id='de',25,0) ) AS ranking, c.country_code, c.country, ct.city, l.language_id,

Are this the right column type choices?

Hi there, I have a user table with lots of different column types. Now I do experiance problems filtering out special date. The performance is really bad. So maybe I did just pick the wrong column types?! This is what I picked so far: | Type | Null | Key | Default | Extra | med

Re: Newbie asks error 1036 table read only?

Make sure mysql owns the tables and their directorys, and has write privileges to them. I talking about UNIX permissions here, not mysql permissions. Bill Flanagan wrote: >Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM >tables on which I am unable to do updates or insert

Re: mysql index question

>From my understanding primary keys and foreign keys are indexed. Someone correct me if I'mwrong here. And you shouldn't have to do anything else to field besides make it a float to usenegative numbers. -Nick > Regarding mysql... > 1) Are primary keys and foreign keys by default indexes for a t

Re: INSERT INTO not working

Check your indexes. Daniel Lim wrote: >Hi there, >I have MySql version: 3.23.36 running on RedHat 7.1, it has been >working fine for sometimes until a day ago when the INSERT into for new >record appeared to return OK status but upon verifying the record isn't >there? > >This is an example; >

Re: Speeding up a huge sql query

This is the explain select sql query on this table containing 500 records now: | table | type | possible_keys| key | key_len | ref | rows | Extra | +---++--+--+-+-- -+--+--

Re: Solved (Re: 4.0.2 Replication still buggy...)

Hi! > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: >> After even more tracking stuff down, I managed to isolate it to a >> change made in MySQL 4.0.1. ?The query in question was doing: >> >> ? INSERT INTO ... SELECT ...

Re: automatic server start paramaters

Rance, Thursday, May 16, 2002, 4:13:04 PM, you wrote: RH> On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql RH> 3.23.??, I think) I have a testing and programming box, only one user is RH> connecting to the database at a time. RH> Now, the mysqld startup sequence au

Re: Can't connect to ....

Jaan, Thursday, May 16, 2002, 5:19:20 PM, you wrote: JJ> Just installed Red Hat Linux on a machine. I included the MySQL packages JJ> but cant get it up working. JJ> When starting from shell it looks like this: JJ> $ mysql JJ> ERROR 2002: Can't connect to local MySQL server through socket JJ> '

Re: how to turn off query logging for mysql on redhat linux

Tom, Thursday, May 16, 2002, 4:30:50 AM, you wrote: TB> I am trying to turn off the query log in mysql on redhat linux. It generates TB> huge log files TB> (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance. TB> safe_mysqld was run with --log, and it seems like I want to

Re: Very new to windows version - question about host and server

Norris, Wednesday, May 15, 2002, 6:54:46 PM, you wrote: Neoen> I have been using (very happily) mysql on unix boxes. I am in a new job and Neoen> there is not a unix box in sight!!! ouch! Neoen> This is a windows 2000 shop. Here is the situation and I am looking for any Neoen> and all sugge

Re: Upgrade

Eigner, Thursday, May 16, 2002, 2:05:01 PM, you wrote: EE> I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL EE> Version 3.23.49a ? EE> I havn'tfound it in the documentation so i hope you could help me What OS do you use? Linux? If you use MySQL from RPM just rpm -U

Re: Newbie asks error 1036 table read only?

Bill, Wednesday, May 15, 2002, 11:42:00 PM, you wrote: BF> Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM BF> tables on which I am unable to do updates or inserts. I get error BF> message #1036 'Table is read only.' I am able to sign on to the database BF> through the root,

ERROR 1030: Got error 127 from table handler / Optimize Table

Hello, I am using mysql 3.23.38 on winnt. I have a table already filled with default value, that way we do only updates during our processing. One column is specified as not null in the table definition and it's also an index. everything was working fine, Until we decided to use "Optimize Table

Re: problem inst ...bench... rpm

I have now installed "mysql-DBI-perl-bin". But I still get a message about "failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.49a-1". Is this because of the spelling of mysql / MySQL? Or is it something else? /Curt torsdagen den 16 maj 2002 14.23 skrev Curt Söderberg: > Hi,

Message

I made a program with delphi and I would like to get the message when is execute any query. eg: select ... " 10 rows in set (0.04 sec) " . This message is important for me. How can I get it. Alexander A busca mais veloz e precisa da internet. Acesse

Message

I made a program with delphi and I would like to get the message when is execute any query. eg: select ... 10 rows in set (0.04 sec) " . This message is important for me. How can I get it. Alexander A busca mais veloz e precisa da internet. Acess

question about perl connection to mysql on another machine

group, Here is the situation. I have to connect to Mysql running on another windows 2000 box. I have never done this before. Do I set this up in the tables as another host and use the -h parm in command shell and the host parm in my perl scripts? or is there another way to do it? Any help woul

MySQL/InnoDB questions from a MyISAM background

We have just migrated a huge installation to InnoDB from MyISAM. While I can feel the power and potential and appreciate this sophistication of what I have at my disposal, I am having some performance issues that are most likely due to my ignorance. Answers to the following questions should help

Replication creating large number of files

Hi, I don't know what caused it, nor whether it's reproducable, but on an AIX system, I just found out that both of the 4.0.1 masters (typical master=slave_of_master loop using same source tree configuration) have created 100.000+ files of the replication log. I can only think they are replicat

Re: Slave crashes with SEGV on master shutdown

Hi! Going through my email backlog... Just a short update on this. > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Monday 29 April 2002 04:39 am, David Harper wrote: >> >Description: >> I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49 >> with mast

replication

Hi all, I would like to know how often (delay in sec.) the slave checks the master for new records in the log, and if one can control that . Thanks in advance Vlady (mysql) - Before posting, please check: http://www

Re: problem inst ...bench... rpm

http://rpmfind.net Thank You <><><><><><><><><><><><><><><><> Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com <><><><><><><><><><><><><><><><> |+> || Curt Söderberg| |

Re: [BUG] CONCAT_WS + GROUP BY display problem

Terra wrote: > Greetings, > > mysql> select *,concat_ws('.',oct1,oct2,oct3,oct4) >ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by >oct1,oct2,oct3,oct4 having c>1; > >+--+--+--+--+--+-+---+--++---+ > | ID

Synchronize only database structures

I have partitioned my data such that each client has its own database (clientdb1, clientdb2, ... clientdbN). All the databases have the same structure (same tables, columns, etc.). This design works great except for one caveat - when I make a change to the database structure I have to make the sam

MyISAM and innodb

I'm finally getting around to working with InnoDB for real :-) Anyway, is there any reason to still use MyISAM on any tables. Concurrency is my biggest problem (Locked tables, etc.). My theory is that the tables that wouldn't benefit from converting to InnoDB are so small (5-50 rows?) that I m

backquotes(`) and mysqldump

I am working with a mySQL database in which some column names contain hyphens. These have to be enclosed in backquotes (`table-name1) within SQL statements. Problem: when generating its own SQL statements, mysqldump does not enclose these names in backquotes -- so when I try to restore a databas

Re: Message

Alexander, Thursday, May 16, 2002, 5:40:41 PM, you wrote: AB> I made a program with delphi and I would like to get the message when is AB> execute any query. AB> eg: select ... AB> " 10 rows in set (0.04 sec) " . AB> This message is important for me. How can I get it. In general you can't get

Disable replication from command line

I want to ignore a database from bin-logging. I know that in my.cnf, I can set binlog-ignore-db=database_name but for various reasons, that's not available to me. How would I pass that option in on the command line via safe_mysqld? Passing it in as an option or a set-variable option causes MySQ

Re: question about perl connection to mysql on another machine

Norris, Thursday, May 16, 2002, 5:57:51 PM, you wrote: Neoen> Here is the situation. I have to connect to Mysql running on another Neoen> windows 2000 box. I have never done this before. Do I set this up in the Neoen> tables as another Neoen> host and use the -h parm in command shell and the ho

Re: Reset Master command ignores max_binlog_size variable

Andre, Wednesday, May 15, 2002, 6:05:16 PM, you wrote: AS> Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a AS> half year. Our way to rotate the binlog files was to stop all software AS> inserting data into the Prod. DB and then reset the master and the AS> replication serve

Re: mysql index question

Taylor, Thursday, May 16, 2002, 4:22:37 PM, you wrote: TL> Regarding mysql... TL> 1) Are primary keys and foreign keys by default indexes for a table? Yeah. Primary key is index by default. Foreign key constraints you can create only on indexed column. TL> 2) Do I have to use a special data oth

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hello Alexander, At 11:25 AM 5/16/2002, Alexander Keremidarski wrote: >Terra wrote: >>Greetings, > > > >>mysql> select *,concat_ws('.',oct1,oct2,oct3,oct4) >ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by >oct1,oct2,oct3,oct4 having c>1; >>+--+--+--+

repication

Hi all, I would like to know how often (delay in sec.) the slave checks the master for new records in the log, and if one can control that . Thanks in advance Vlady (mysql) - Before posting, please check: http://www.mysq

Message

I made a program with delphi and I would like to get the message when is execute any query. eg: select ... 10 rows in set (0.04 sec) " . This message is important for me. How can I get it. Alexander A busca mais veloz e precisa da internet. Aces

Re: Email from WDVL

Hi Aaron (if that's your name) using LIKE with a '%' as the first character means MySQL cannot use the FileName index (since % means anything, the index is no use) - if you can, take out the first '%' Also, you mention indexing GroupID, but talk about ProductID - is this a typo? If this doesn

Re: Fw: Simple SQL

Sampson, Peter wrote: > Gabriel. > > This works fine and the two tables talk to each other. > > BUT, > My website can have 5 - 10 news stories per month. So in the tblNews I > could have > [Snip multiple rows] > I need to use DISTINCT in the SQL lingo as I "bind" the recordset's > "nMonth"

Re: Alter table

Hello. On Thu, May 16, 2002 at 01:39:59AM +0200, [EMAIL PROTECTED] wrote: [...] > > It sounds as if you want > > > > ALTER TABLE your_table ADD INDEX( message_id ) [...] > Well, the FAQ is where I went first, of course. And then I came up with > this, > > "ALTER ignore table $table MODIFY messag

Re: ISAMCHK utility - MySQL server - 3.21.33b

Hi. Well, what's the problem with using isamchk in detail? Shut down the mysql daemon, run "isamchk" on all tables to find out which are corrupted and run "isamchk -r" on those. Then restart mysqld. Do not forget to make backup copies of the tables in question beforehand, in case anything unexpe

Re: Systems of a high degree of availability

Hi. IMHO you need to do some more digging yourself and present more precise question. At least, if you get no other answers, which I rather doubt. The problem is that the answers depend heavily on information you did not provide (e.g. what are the requirements for the system? "high availibility"

Re: MySQL/InnoDB questions from a MyISAM background

Hi! Good questions! - Original Message - From: "Michael Bacarella" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, May 16, 2002 6:41 PM Subject: MySQL/InnoDB questions from a MyISAM background > We have just migrated a huge installation to InnoDB from MyISAM. > W

Re: backquotes(`) and mysqldump

T.D., Thursday, May 16, 2002, 6:54:45 PM, you wrote: TDH> I am working with a mySQL database in which some column names contain TDH> hyphens. These have to be enclosed in backquotes (`table-name1) within TDH> SQL statements. TDH> Problem: when generating its own SQL statements, mysqldump does n

Re: Message

Unsure exactly what you want but I use message box's in my apps to say if there is an error or whatever. This, as far as I know, has to be done in the program not in the SQL. > Alexander, > Thursday, May 16, 2002, 5:40:41 PM, you wrote: > > AB> I made a program with delphi and I would like to ge

Re: Message

Please stop reposting your question. You should be able to get this information from Delphi. Set up a time object before you execute the query. On Thursday 16 May 2002 10:19 am, Alexander Burbello wrote: > I made a program with delphi and I would like to get the message when is > execute any q

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hello. On Thu, May 16, 2002 at 06:25:42PM +0300, [EMAIL PROTECTED] wrote: [...] > >mysql> select *,concat_ws('.',oct1,oct2,oct3,oct4) > >ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group > >by oct1,oct2,oct3,oct4 having c>1; > >>+--+--+--+--+--+-

Re: backquotes(`) and mysqldump

Hi. shell> mysqldump --help | grep 'quote\|Ver' mysqldump Ver 8.14 Distrib 3.23.38, for pc-linux-gnu (i686) -Q, --quote-names Quote table and column names with ` don't know why it isn't the default, but it seems you can force them this way. Regards, Benjamin. On Thu, May 16, 2

Re: mysql login question

Can you login to mysql from a perl script by passing it an encrypted password..? Taylor... Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply."

Comparing UNSIGNED and INDEXED columns with negative numbers

Hi All, Using MySQL server version 3.23.49-nt I get strange results when running the following very simple test. I am wondering if this is a bug, feature or perhaps a standart SQL behaviour?? CREATE TABLE test(id BIGINT UNSIGNED); CREATE INDEX test_idx on test(id); INSERT INTO test VALUES (0)

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hello. On Thu, May 16, 2002 at 12:10:10PM -0400, [EMAIL PROTECTED] wrote: > At 11:25 AM 5/16/2002, Alexander Keremidarski wrote: [...] > >It is normal to have a difference there. It is not beacuse of how > >concat() and() concat_ws() work, but how GROUP BY works. > > Is this 'unpredictable behav

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hi, Same bug with MySQL-4.0.2 latest source. Regards, Jocelyn Fournier - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Alexander Keremidarski" <[EMAIL PROTECTED]> Cc: "Terra" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 16,

STRING TO NUMBER

Hi, In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i have to use in Mysql ?? thank´s Marcel. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: Message

Peace to All, In Bible said: If a man doing something wrong for the first time or he don't know , give the second chance and show him the right way...and if don't want to follow it , let him ...or something like that. If you use ODBC you have many ways but the short one is to have a variabl

isn't this join equivalent to this LEFT JOIN?

Isn't the following: SELECT * FROM t1, t2 where tl.ID=t2.foreignKey; logically equivalent to: SELECT * FROM t1 LEFT JOIN t2 ON t1.ID=t2.foreignKey WHERE t2.ID IS NOT NULL; Because I had a query in the first format that took about two minutes to run on MySQL, and then I changed it into the se

RE: ERROR 1030: Got error 127 from table handler / Optimize Table

restart the MySQL server happened to me this week when I was copying files (and changing the schema) while the server was running HTH Dave -Original Message- From: Frederic Dhorne [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:32 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: ERRO

Re: Comparing UNSIGNED and INDEXED columns with negative numbers

Hi. What you observe is the fact that "-1" will be converted to the format of the index, else the index could not be used. Converting -1 to an unsigned number give the biggest possible number for the type in question (here BIGINT UNSIGNED). None of your numbers is bigger than this, so you get an

Re: STRING TO NUMBER

i think u dont need to it will automatically deal with it. - Original Message - From: "Marcel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 3:26 PM Subject: STRING TO NUMBER > Hi, > In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i

Re: Bug in fulltext search in latest mysql-4.0.2 source

Sergei Golubchik wrote: > rebuild your indexes (the proper way to do it is to issue > REPAIR table_name USE_FRM Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? TIA, Vadim. /* sql, mysql to satisfy the spam police */

table type airline?

>From my sql How can I see what the types of tables I have are.. i.e. how do I verify >if a table is an ISAM, HEAP, InnoDB... Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." *

Mysql Load Data question

I read in the Mysql manual where you can change the default column seperator, but it didnt specify how to do this. So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go to find out about mysql command syntax...? Thanks,. Taylor Lewick Unix System Administrator

RE: STRING TO NUMBER

MySQL do it for you:) Quoted from the online documentation is: " MySQL automatically converts numbers to strings as necessary, and vice-versa: mysql> SELECT 1+"1"; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' If you want to convert a number to a string explicitly, pass it a

RE: table type airline?

SHOW CREATE TABLE tablename; or SHOW TABLE STATUS LIKE 'tablename'; gives you what you want... See: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Thu

RE: Mysql Load Data question

Everytime you have something to ask, first point your browser to : http://www.mysql.com/doc/ Type in the keywords (in this case LOAD DATA) The first url in the resultset will be : http://www.mysql.com/doc/L/O/LOAD_DATA.html which is what you are looking for. Gurhan -Original Message-

Re: Mysql Load Data question

Hi, Look at http://www.mysql.com/doc/L/O/LOAD_DATA.html and you can try this... load data infile 'yourfile' into table your_table fields terminated by '\your_separator_char_for_fields' lines terminated by '\your_separator_char_for_row'; Regards, Gelu __

Re: table type airline?

Hi, try : show tables status; _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Taylor Lewick" <[EMAIL PROTECTED]> To: <[EMAIL PR

How to limit database size?

Hello, I like to limit the size of a database (or if possible all databases of a mysql user) to some value. It should work like the disk quota for disk space. Thanks for any hints, Alexander Newald - Before posting, please c

What is going on? Performance question

I am running mysql and apache on windows 2000. Everything is running smoothly and then all of the sudden my perl scripts that have been running just find are loading very very slowly. I am not sure if it is mysql, perl, apache or what. These are the same scripts that have been running just fine

Re: What is going on? Performance question

Perhaps memory utilization issues? Does the box start thrashing? Norris, Joseph wrote: > I am running mysql and apache on windows 2000. Everything is running > smoothly and then all of the sudden my perl scripts that have been running > just find are loading > very very slowly. I am not sure i

MySQL/InnoDB question

I'm not new to MySQL but have only recently familiarized myself with InnoDB. One question I have so far been able to find an answer on is the datafiles. Let's assume I have 5 GB worth of information, this information changes regularly. Performance wisewould I be better off using a single 5GB

Index X No Index

Hi, Let´s supose that we have a table with this features : - about 7 records; - only a primary index; - about 30 fields; - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS typically uses about 3 or 4 fields in the WHERE clause. Creating indexes, one for each field used on SELECTS, wil

RE: Index X No Index

* Joao A. Marques > Let´s supose that we have a table with this features : > - about 7 records; > - only a primary index; > - about 30 fields; > - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS > typically uses about 3 or 4 fields in the WHERE clause. None of them beeing the primary

Re: What is going on? Performance question

You might try running queries seperately and check performance to see if it Perl or mySQL mike "Norris, Joseph" wrote: > > I am running mysql and apache on windows 2000. Everything is running > smoothly and then all of the sudden my perl scripts that have been running > just find are

Script fails during MySQL access attempt.

Dear MySQL wizards, Perhaps this is more of a Perl question than a mySQL question but I am trying to access a mySQL database. Here is the line of code. if ($q->param('field') eq "") {&printform()} else {&results()} This gives the reply: Use of unitialized value in string eq at select.cgi

  1   2   >