Re: fulltext index -- word "needs" not found

Hi Joyce, "needs" is a stopword, that's why it's not indexed or found. You can use your own ft_stopword_file to define the list without "needs." The default, built-in stopword list is defined in, I think, the myisam/ft_static.c file of the source distribution, for reference. Hope that helps.

Re: SUM same field twice in one SELECT?

With the query: SELECT SUM(IF(cur = 'EUR',amount,0)) as "Amount, euro", SUM(IF(cur = 'FIM',amount / 5.94573,0)) as "Amount, fim -> euro", SUM(IF(cur = 'SEK',amount / 9.294,0)),0)) as "Amount, sek -> euro" FROM table1; I get the total amount spent -- converted into one currency, euro -- for the re

load strips first character

Hello, I am loading data from a text file where filed3 is a path to a document in a format "\\path\to\some\directory" but after loading into MySQL it appears as "\path\to\some\directory" with the first backslash stripped away. Why is this happening and how can I avoid it? LOAD DATA INFILE '/local

RE: SUM same field twice in one SELECT?

Use if statements: Your query would then look like this: SELECT SUM(IF(cur = 'SEK',amount,0)), SUM(IF(cur = 'EUR',amount,0)) FROM table1 WHERE ... The if statement has three properties, the first is the condition, the second what to do if true, the third, is what to do if false. Hope this helps,

SUM same field twice in one SELECT?

Hi, I've just started to dabble with MySQL, creating a database as much for actual use, as for learning experience. Thus, if my question is a really basic one, for which there is a manual page, please just refer me to it. :) So, I have this table, let's call it table1, in which I amongst other

fulltext index -- word "needs" not found

>Description: We have three different unrelated tables, each with one field that has a fulltext index. In each table, in the field with the fulltext index, there are records with the word "needs" in them, and in each case no records are found when doing this type of query (using a fulltext

Re: inserting values from another table

At 11:25 +1000 4/28/04, Nik Belajcic wrote: Hello, I just subscribed to the list (after a few years of absence) and have a rather basic question - I have two tables table1 and table2: table1 - primarykey1, foreignkey, somevalue table2 - primarykey2, somevalue Both tables are populated with record

inserting values from another table

Hello, I just subscribed to the list (after a few years of absence) and have a rather basic question - I have two tables table1 and table2: table1 - primarykey1, foreignkey, somevalue table2 - primarykey2, somevalue Both tables are populated with records, but foreignkey in table1 has no value.

Re: storing

[EMAIL PROTECTED] wrote: hi, thanks for the info. I'm not very sure about mysql. but this is what ive got. ive got three tables with data in it.need to save the tables and run it on another machine or rather view the tables and records in another machine. 1. if i use mysqldump query, it will

Re: storing

hi, thanks for the info. I'm not very sure about mysql. but this is what ive got. ive got three tables with data in it.need to save the tables and run it on another machine or rather view the tables and records in another machine. 1. if i use mysqldump query, it will prepare a backup right?

Re: How to load fixed-format data?

Roy Smith wrote: I've got a bunch of files which contain packed fixed-field-width records. The records are pretty long; depending on the file, as long as 1000 characters and 10's of fields. Fields are a mix of numeric and alphanumeric types. What's the best way to load these into mysql? Mys

Re: User Conference Presentations

I'm trying to get the presentations too. I found one of them. the session was in the Orlando room and it was called Crack-Proofing MySQL. I found the presentation on the authors site at http://www.appsecinc.com/presentations/Hackproofing_MySQL.pdf. I thought the session was pretty good and luckily

How to load fixed-format data?

I've got a bunch of files which contain packed fixed-field-width records. The records are pretty long; depending on the file, as long as 1000 characters and 10's of fields. Fields are a mix of numeric and alphanumeric types. What's the best way to load these into mysql? Mysqlimport looks lik

Re: What is your mysql debugging strategy?

On Tue, 27 Apr 2004 22:26:16 +0100, wrote: >I only use mysql with php so all I need is > >php code: >$result = mysql_query($sql) or die(mysql_error()); > >This always tells me what I did wrong in the query. You could easily put >together a very short script into which you just drop you query. TH

core dumped every time when my code is finishing

This is my code. Very simple one. Every time when I run my code, after it finishes all the work, I use gdb to trace it to "return 0;", after return 0;, it crashes. I have the same problem to run the example codes. My machine is a linux box with gcc 3.2.2. I don't know what was wrong. Thanks a lot.

RE: storing

mysqldump when ensure consistency. If you are using InnoDB or DBD you run the risk of data not being committed. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 4/27/04 4:06 PM Subject: storing hi, i have mysql on my local machine.and i have created tables in my

Re: storing

On Tue, 27 Apr 2004 17:06:59 -0400 (EDT), wrote: >hi, > i have mysql on my local machine.and i have created tables in my database. >if i need to copy these tables onto a cd and transfer them , which folder to i >copy? is it the data directory under mysql??? > >i am not sure abt this. > >Thank

Re: What is your mysql debugging strategy?

I only use mysql with php so all I need is php code: $result = mysql_query($sql) or die(mysql_error()); This always tells me what I did wrong in the query. You could easily put together a very short script into which you just drop you query. THis would output the problem to the page. Dead simple

storing

hi, i have mysql on my local machine.and i have created tables in my database. if i need to copy these tables onto a cd and transfer them , which folder to i copy? is it the data directory under mysql??? i am not sure abt this. Thanks, liz -- MySQL General Mailing List For list archives: h

Re: Still getting problems creating a new super user on version 4 under WinXP

Jeff, I'm in the process of working with some grants, so I tried the following and it worked fine. grant all privileges on *.* to sec5 identified by 'sec' with grant option; SHOW GRANTS FOR sec5 produced the following: mysql> show grants for sec5; +--

Re: What is your mysql debugging strategy?

On Tuesday 27 April 2004 04:26 am, zzapper said something like: > Even though I solved the following problem myself, I'd like to know > what debugging strategy people use to solve problems when they get the > dreaded "Error in Mysql look in the manual" Fire up MySQL CC and paste the SQL in there,

Still getting problems creating a new super user on version 4 under WinXP

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; Excuted in a MySQL console returns the following SQL error "ERROR 1064:you have an error in your SQL syntax. check the manual that corresponds to you MYSQL server version for the right syntax to use

RE: Going Crazy in KY

Chris: The easiest way to do this is to start the MySQL client in the directory of the file. To do this start your dos prompt, cd to the directory and then start MySQL. Type your source command and all should be could. If you're feeling frisky, then type source path\file.name and it should run.

RE: Going Crazy in KY

Are you in the same directory as the file you are trying to execute? What if any error messsages are you getting? -Original Message- From: Chris Stevenson To: [EMAIL PROTECTED] Sent: 4/27/04 3:12 PM Subject: Going Crazy in KY I'm trying to run a saved command in windows format. At mysql>

Going Crazy in KY

I'm trying to run a saved command in windows format. At mysql> I'm typing source create_event.sql Create.event.sql is my saved command and is my c:\mysql\bin\sampdb directory. 1. What is the correct entry to get the table EVENT created in X database using a stored command? Pl

RE: sql_no_cache

In an update to the last, I think I have the issue in hand: I am using TOAD 1.0 and it seems to be doing some sort of caching itself or going directly to the query cache. I issued the identical query and it would return the result immediately. Checking Mytop (did I mention that JZ rules?) the q

RE: sql_no_cache

One possibility is that the OS has the portion of disk that the row is stored in cached in memory via its normal disk caching after the first execution. Another possibility is that the key for the table is in mysql's key_buffer after the first execution. If you are using innodb then it might be c

Re: Mysql for Family History (genealogy)

>Hi, > >Anyone designed a MySql database for family history? > >Any ideas,recommendations, problems ? You can try asking the GRAMPS team (http://www.gnu.org/directory/gramps.html). I seem to remember that they are playing around with using a database (right now, only in CVS). Don't know if it's

sql_no_cache

I am trying to turn of the query caching for select queries I am testing as I would like to rerun the as if they were the first hit. The query-cache-type = 1. I am suspicious b/c I run a query and it takes 12 seconds. I then run the same query with no changes and it takes .17 seconds. Anoth

Mysql for Family History (genealogy)

Hi, Anyone designed a MySql database for family history? Any ideas,recommendations, problems ? zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing Li

Re: MySQL Memory Structure

Here is an example of where I get frustrated. Maybe I'm just not finding it in the docs. When I execute the "show innodb status\G" I get: -- BUFFER POOL AND MEMORY -- Total memory allocated 17490512; in additional pool allocated 924288 Buffer pool size 5

Re: detecting basic errors

[EMAIL PROTECTED] wrote: Hi all, I am a MySQL and in fact SQL newbie. I am trying to write java code that will help me determine a couple of error conditions. I want to be able to find out if, after I have done an insert, if the values that I entered are valid. Interestingly, when I entered cl

Re: Standard of Column Names

Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, "Ronan Lucio" <[EMAIL PROTECTED]> writes: Hello, I´m doing the planing for an application that will use MySQL as database. So, I´d like to know your opinions about the standard for the column names. Supposing that I should create a table nam

Re: enum or tinyint?

Harald Fuchs wrote: Even better, in this case you can use BOOL as the column type. Although that's just a synonym of TINYINT, it makes the intended usage clearer. I suppose, except that mysql (4.0.17, anyway) doesn't remember that you used BOOL. mysql> CREATE TABLE bt (flag BOOL); Query OK, 0 r

Re: Doubt about TINYINT type

At 13:29 -0400 4/27/04, Keith C. Ivey wrote: On 27 Apr 2004 at 13:59, Ronan Lucio wrote: OK, I understood it, but I didn´t understand why is there an option TINYINT(n) See http://dev.mysql.com/doc/mysql/en/Numeric_types.html | Another extension is supported by MySQL for optionally | specify

Re: using COUNT in a WHERE

Sagi Bashari wrote: Michael Stassen wrote: No, you can't use an alias in the WHERE clause. Even if you could, you'd have a problem here. The WHERE clause is used to decide which rows to look at in advance of any calculations. You're asking mysql to count the rows which match the WHERE cla

Re: Doubt about TINYINT type

On 27 Apr 2004 at 13:59, Ronan Lucio wrote: > OK, I understood it, but I didn´t understand why is there an option > TINYINT(n) See http://dev.mysql.com/doc/mysql/en/Numeric_types.html | Another extension is supported by MySQL for optionally | specifying the display width of an integer value

Re: Trying to do a STRAIGHT JOIN to force an INDEX

David Perron wrote: I have a query similar to the one below. Im trying to force a STRAIGHT JOING to Table5 which has an index on Id & Date. For some reason, the optimizer isnt picking the INDEX to execute the query (and subsequently doing a full scan on a 250 million+ row table) so Im trying to fo

Re: Standard of Column Names

Harald, > I don't see the necessity of the latter naming scheme since > > SELECT cod, name, description FROM car > > can also be written as > > SELECT car.cod, car.name, car.description FROM car Do you know how it would be about portability? Thanks, Ronan -- MySQL General Mailing List Fo

Re: Doubt about TINYINT type

Paul, > I don't know what "minor than" means Sorry by my english. I´d like to say "less than" (or something like this). > , but TINYINT is a single-byte > type. The range for TINYINT is -128 to 127, and the range for > TINYTINT UNSIGNED in 0 to 255. OK, I understood it, but I didn´t understand

MySQL Memory Structure

I'm trying to get a handle on the entire memory structure used by MySQL. I'd like to be able to see the total memory used by the entire MySQL instance, and then a breakdown of what is going on within that aggregate allocation. For example, I'd like to see how much memory is devoted to the quer

Trying to do a STRAIGHT JOIN to force an INDEX

I have a query similar to the one below. Im trying to force a STRAIGHT JOING to Table5 which has an index on Id & Date. For some reason, the optimizer isnt picking the INDEX to execute the query (and subsequently doing a full scan on a 250 million+ row table) so Im trying to force the STRAIGHT JO

Re: Doubt about TINYINT type

At 11:53 -0300 4/27/04, Ronan Lucio wrote: Hi, If I create a column with the type TINYINT(2) UNSIGNED. Will the content can have the value minor than 510 (like a number 499), or will the content can have two values minor than 255 (like 11)? I don't know what "minor than" means, but TINYINT is a s

detecting basic errors

Hi all, I am a MySQL and in fact SQL newbie. I am trying to write java code that will help me determine a couple of error conditions. I want to be able to find out if, after I have done an insert, if the values that I entered are valid. Interestingly, when I entered clearly invalid non numeri

Re: Standard of Column Names

Ruslan, > IMHO: > 1) Table name as prefix is unnecessary for me. It's norwegian notation > which I hate. > 2) Also I recomend look into ANSI SQL standard for reserved keywords. > I've got experience of porting DB from MySQL(allow some keywords) to > another DB, it's pain. Thank you your answer. D

Doubt about TINYINT type

Hi, If I create a column with the type TINYINT(2) UNSIGNED. Will the content can have the value minor than 510 (like a number 499), or will the content can have two values minor than 255 (like 11)? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Standard of Column Names

Ronan Lucio wrote: Hello, I´m doing the planing for an application that will use MySQL as database. So, I´d like to know your opinions about the standard for the column names. Supposing that I should create a table named car. Is it better to have either the column names (cod, name, description) or

Standard of Column Names

Hello, I´m doing the planing for an application that will use MySQL as database. So, I´d like to know your opinions about the standard for the column names. Supposing that I should create a table named car. Is it better to have either the column names (cod, name, description) or (car_cod, car_na

Re: Query help

Thank you very much Shawn and Mike for your quick responses. Left join was exactly what I was looking for and it worked quite nicely. Once again, thanks for your help. Richard [EMAIL PROTECTED] wrote: Richard, This is the case for using a LEFT JOIN. You want everything from the "left" table

RE: select command with a search?

Thank you, That did the trick. > -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 12:17 AM > To: [EMAIL PROTECTED] > Subject: Re: select command with a search? > > "Christopher Lyon" <[EMAIL PROTECTED]> wrote: > > I want to be able to searc

Re: using COUNT in a WHERE

Sagi Bashari <[EMAIL PROTECTED]> wrote: > Michael Stassen wrote: > >> No, you can't use an alias in the WHERE clause. Even if you could, >> you'd have a problem here. The WHERE clause is used to decide which >> rows to look at in advance of any calculations. You're asking mysql >> to count t

InnoDB Table Locking Issue

Hi, I am having a difficult time with a query. My environment is MySQL v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel). Basically, I am running a query of the form: INSERT INTO temp_tbl SELECT c1,c2... FROM t1,t2,t3,t4 WHERE ... It is a very complex query, which looks at millions

Re: Dumping data per request

"Teguh Kurniawan " <[EMAIL PROTECTED]> wrote: > Hi... > It's possible to dumping data by request. I mean it can limiting data dumping with > some condition. What about using --where option of mysqldump? http://dev.mysql.com/doc/mysql/en/mysqldump.html -- For technical support contracts, goto

RE: Dumping data per request

If you use mysql dump you can use the --where= switch. Or you can use select into outfile syntax from within the mysql monitor. -Original Message- From: Teguh Kurniawan To: [EMAIL PROTECTED] Sent: 4/27/04 7:45 AM Subject: Dumping data per request Hi... It's possible to dumping data by re

Dumping data per request

Hi... It's possible to dumping data by request. I mean it can limiting data dumping with some condition. Thank's Teguh Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

Re: Innodb running out of disk space for relatively low number of rows!

Thanks for the response. Closed long running transactions, Did the test again and got in to same situation. Innodb and table status at that time were: = 700101 0:16:20 INNODB MONITOR OUTPUT = Per second averages calculated fr

What is your mysql debugging strategy?

Hi, mysql 4.018 script ColdFusion MX I've got the rather miserable job of porting a MsAccess ODBC SQL application to Mysql. Most seems to work OK, but some of the queries fail ; Mysql seems to be "stricter ". Even though I solved the following problem myself, I'd like to know what debugging str

Re: Innodb running out of disk space for relatively low number of rows!

Sp.Raja wrote: = 700101 20:31:59 INNODB MONITOR OUTPUT = Per second averages calculated from the last 39 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 139, signal count 139 Mutex spin waits 0, r

Re: select command with a search?

> I want to be able to search for specific text in a field and return the > results for those rows. What is the best way to go about it? Do I use > the regex stuff or match? You can use - ...WHERE column LIKE '%specific text%' - "use the regex stuff" (which is mostly slower than LIKE) - MATCH afte

Re: SET column type??

> i am sort of confused about the SET column type... is there any place that i > can go that will give a better example of it and how to use/create it than > the manual does?? If you read the user comments on the manual page (http://dev.mysql.com/doc/mysql/en/SET.html) you'll see loads of examples.

Re: select command with a search?

"Christopher Lyon" <[EMAIL PROTECTED]> wrote: > I want to be able to search for specific text in a field and return the > results for those rows. What is the best way to go about it? Do I use > the regex stuff or match? > It depends. You can use LIKE, REGEXP, full-text search for those purpose:

Re: What is SAP R/3 Ver 4.6c installation procedure on PC?

The only source for this info is http://service.sap.com. Login with your S- user and download the pdf file. BIVOL - Original Message - From: Rahul Mandle To: mysql Sent: Tuesday, April 27, 2004 8:45 AM Subject: What is SAP R/3 Ver 4.6c installation procedure on PC? Sir,