Mysql listed in spamcop?

This may have been mentioned.. I have not been recieving message for 12+ hours now.. And it appears: Jan 13 01:23:49 cyclone tcplog: smtp connection attempt from 213.136.52.31 Jan 13 01:23:50 cyclone sendmail[10674]: ruleset=check_relay, arg1=lists2.mysql.com, arg2=213.136.52.31, relay=lists2.mys

Re: VARCHAR 255 versus TINYTEXT

At 10:40 +1100 1/13/04, Justin French wrote: Hi, Can someone please calrify when I would use VARCHAR 255, and when I would use TINYTEXT (which also has a length of 255)? TINYTEXT won't have trailing spaces chopped. e -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.m

Re: VARCHAR 255 versus TINYTEXT

On Tue, 13 Jan 2004 12:40, Justin French wrote; > Can someone please calrify when I would use VARCHAR 255, and when > I would use TINYTEXT (which also has a length of 255)? I think the difference between a VARCHAR and a TEXT column is that the TEXT is saved as a reference to its own row-like

Access Denied, How To Fix This

Hello, I'm trying to access phpadmin and another website that I built on my mysql server and I get the following access denied error: Warning: mysql_pconnect(): Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in C:\Apache\Apache2\html\C2R\catalog\includes\functions\database.php

RE: What Does This Mean

Chris L. White said: > You know what is even more screwed up now. I did this command and when > it prompted me for the password I just hit enter and wallah look what I > got. But I am sure there is other stuff messed up now: > SET YOUR ROOT PASSWORD it its blank it will behave as you describe. So

Unicode Collation utf8_general_ci

I have a table that stores strings in utf8, using the default collation utf8_genera_ci. During comparison using LIKE, MySQL 4.1.1 seems to be able to handle case insensitivity of latin characters correctly but not other characters such as Greek. For example, I have a varchar column (mycol) with

VARCHAR 255 versus TINYTEXT

Hi, Can someone please calrify when I would use VARCHAR 255, and when I would use TINYTEXT (which also has a length of 255)? Thanks, Justin French -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Loading the .myd into memory

Hi Trevor, MySQL itself doesn't cache any of the data (.MYD) file. The operating system uses any free RAM to cache that file data. This is why I don't think it's that important to have such a huge key_buffer, because some of that memory would probably be better used for caching the data file. In

re: JOIN types

MyQuoting [EMAIL PROTECTED]: > I'm suprised by your result too. Did you have an index on the join column? > If > not that might explain it. One place you might turn to learn more about how > > mysql optimizes joins is internals.texi. This file describes a lot of the > internal workings of m

Re: JOIN types

Hi Keith, I would assume it's because LEFT JOIN forced a change in the join order (in EXPLAIN). Does using STRAIGHT JOIN give the same result? So your query was this? SELECT a.field FROM table1 a LEFT JOIN table2 b USING (field2) ORDER BY b.field3 DESC If table1 is read first (which it should

Loading the .myd into memory

Mysqlians, Greetings. Besides the query cache is their a buffer which holds the data portion of MyISAM tables. All the buffers seem to hold key information or query processing information. Thanks, Trevor

re: JOIN types

I'm suprised by your result too. Did you have an index on the join column? If not that might explain it. One place you might turn to learn more about how mysql optimizes joins is internals.texi. This file describes a lot of the internal workings of mysql and is found in the bk doctree and is

JOIN types

Hey all, I've read the pages in the MySQL manual that explain the types of JOINs many times, but still think I'm missing something. I usually was always using INNER JOIN in all my join queries, and in a few cases LEFT JOIN (in cases I wanted the rows in one table that were not in the other one

Re: Rounding to nearest one sixteenth of an inch. (Solved)

On Monday 12 Jan 2004 22:23, you wrote: (B> Richard Davies wrote: (B> > Does anyone have any ideas on how to round a number in the form (B> > float(3,4) to the nearest sixteenth of an inch. (B> (B> Multiply by 16, round, divide by 16. (B (BObvious really, (Bupdate table1 set field1 = (round

Re: Rounding to nearest one sixteenth of an inch.

In the last episode (Jan 12), Richard Davies said: > Does anyone have any ideas on how to round a number in the form > float(3,4) to the nearest sixteenth of an inch. > > eg ending in > .0625, > .125 > .1875 > .25 > .3125 ROUND(myfield*16)/16 should work. -- Dan Nelson [EMAIL

RE: What Does This Mean

You know what is even more screwed up now. I did this command and when it prompted me for the password I just hit enter and wallah look what I got. But I am sure there is other stuff messed up now: C:\MySQL\bin>mysql -u root -p Enter password: ** ERROR 1045 (28000): Access denied fo

Rounding to nearest one sixteenth of an inch.

Does anyone have any ideas on how to round a number in the form float(3,4) to the nearest sixteenth of an inch. eg ending in .0625, .125 .1875 .25 .3125 etc I haven't found anything in the manual about this, maybe normal people don't want to do this. -- Regards Richard -- MySQL General

Re: metric conversions SOLVED

On Monday 12 Jan 2004 13:20, Richard Davies wrote: (B (BThank you to everyone who offered advice on this problem I knew it was easy (Bbut couldn't see how to do it. (B (BThanks again. (B (B> I receive measurements for a product sometimes in inches, sometimes in (B> centimeters. (B> (B> T

Re: Mysql Socket Error

Birju Shah wrote: Hello Friends, We are using free bsd, mysql 4.0.15. We are using this system since more than a year now. We have a autoresponder script which has mysql database. Since a month or so we are noticing that mysql gives the mysql.sock error and the only option which remains is to reb

Re: What does this Mean

Chris L. White said: > C:\MySQL\bin>mysql show > > ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using > password: > > YES) > > > > C:\MySQL\bin>mysql show -u root > > ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using > password: > > YES) Your musql setup requi

Mysql Socket Error

Hello Friends, We are using free bsd, mysql 4.0.15. We are using this system since more than a year now. We have a autoresponder script which has mysql database. Since a month or so we are noticing that mysql gives the mysql.sock error and the only option which remains is to reboot the entire s

Re: mysql.sock

Mike Mapsnac wrote: I got such error message ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/ mysql/mysql.sock' (111) Thanks Right. This means that you're using the mysql command-line tool, and it's trying to talk to MySQL through the /var/lib/mysql/mysql.sock file, but

Re: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

Thanks for responding randy. so I checked my my.ini file and the address is set to 127.0.0.1. I checked the database error file and it was empty. I posted the my.ini file down below. Any other suggestions ? When I try to startmysql through the MSDOS prompt it says C:\Program Files\EasyPHP1-7\

Re: Automatic conversion from `char` TO `varchar`

you seem to have mixed single and double quotes. this might be your problem - Original Message - From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 10, 2004 7:06 AM Subject: Automatic conversion from `char` TO `varchar` > Hi, >

Re: What does this Mean

C:\MySQL\bin>mysql show ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using password: YES) C:\MySQL\bin>mysql show -u root ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\bin>mysql show -u root -p Enter password: *

Re: What Does This Mean

Did you set a password for the root account? MySQL comes with a root user that (initially) has no password and all privileges. Most setup instructions have you assign a password to the root account pretty early on. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: Space Column

* [EMAIL PROTECTED] > I am beginning in mysql, and I do not obtain to create a table > with a space column. > some friend could help me? > > mysql> CREATE TABLE g1 (p1 GEOMETRY); > Error 1064 : The error message got lost in the mail. Beware that spatial support is introduced in mysql version 4.1,

Re: Can't create Database

It looks like you didn't specify a user. Try this: mysql -u root -p It will prompt you for the password that you set up for the root account. After you enter it you will get a mysql> prompt. Now type: create database newdatabase; This will create a new database called newdatabase. You can l

Re: Strange ORDER BY question(SOLUTION)

* Mike Johnson > From: Lewis, Jason [mailto:[EMAIL PROTECTED] > > > Didn't know if anyone else might need this but I was given > > the solution. > > > > SELECT * FROM tablename > > ORDER BY MemberLevel='Platinum' DESC, > > MemberLevel='Gold' DESC, > > MemberLevel='Silver' DESC, > > MemberLe

Re: Space Column

Just enclose the column name in backticks (upper left key on your keyboard just below ESC). Be warned that if you do this you will ALWAYS have to refer to this column using the backticks. It would be MUCH better to remove the space from the name. You might consider using an underscore instead.

Re: Bug in Boolean mode fulltext searching.

Hi! On Jan 07, [EMAIL PROTECTED] wrote: > >Description: > Boolean mode fulltext searching returns zero hits for valid queries. > >How-To-Repeat: > Create a database with a Text column. Add a fulltext index on it. > Try to search for multiple words with AND or phrase syntax. >

Addition to Last Post on Connecting to MYSQL

Also It keeps telling me that the host is not allowed to connect to the MySQL server, funny thing is the host that is trying to connect is the actual machine that MYSQL is on? Chris L. White Network Administrator Jr. Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]

Re: How to move data between tables in a database?

On Mon, Jan 12, 2004 at 12:54:55PM -0500, Syed Ali wrote: > Hello, > > I would like to move data between tables in mysql within the same > database, I am not sure what the best way to go about it is. > I do not need to move all the data in the tables, just the output of > some select statements.

What Does This Mean

It says I am not allowed to connect to the mySQL server. I am trying root and admin and it won't let me in. Have I done something wrong and what do I check? Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]

Re: Automatic conversion from `char` TO `varchar`

Hi Michael, > >>>Indeed. Nevertheless, I'm right at this one :-) > >> > >>I defer to your expertise on SQL standards. Regardless of the standard, > >>however, mysql does not pad CHARs with spaces. Thus, CHARs and VARCHARs > >>are identical from the client's point of view, so silently changing >

Table Joins

Hi, I have 2 identical tables and wish to join them. I am a complete novice and thought it was simple! Here is the code that I am using with asp.net select Date, Payroll, First, Last, Rank, Number, Division, Reason, ImpDate from all_by_Payroll, payinc where "+ DropDownList1.SelectedItem.Value +

Re: How to move data between tables in a database?

"Syed Ali" <

Installation-related question -- inter host communication

Hi. I have MySql 3.23.49 on machine A. I have apache on machine B, and wish to ultimately run queries on databases on machine A using perl/DBI as CGI from Apache. Machine B was wiped and rebuilt from the RH9 up, but has no Mysql on it at all. My goal is to share the load a bit. Do I need to pu

How to move data between tables in a database?

Hello, I would like to move data between tables in mysql within the same database, I am not sure what the best way to go about it is. I do not need to move all the data in the tables, just the output of some select statements. I am using Perl DBI and MySql 4.0.15-standard on RedHat 8.0. I guess I

RE: Strange ORDER BY question(SOLUTION)

From: Lewis, Jason [mailto:[EMAIL PROTECTED] > Didn't know if anyone else might need this but I was given > the solution. > > SELECT * FROM tablename > ORDER BY MemberLevel='Platinum' DESC, > MemberLevel='Gold' DESC, > MemberLevel='Silver' DESC, > MemberLevel='Paying' DESC, > MemberLevel='N

Foreign key contraints, on delete cascade not working?

I created the following .sql file to demonstrate a problem I'm having. According to the manual: If ON DELETE CASCADE is specified, and a row in the parent table is deleted, then InnoDB automatically deletes also all those rows in the child table whose foreign key values are equal to the refere

RE: Strange ORDER BY question(SOLUTION)

Didn't know if anyone else might need this but I was given the solution. SELECT * FROM tablename ORDER BY MemberLevel='Platinum' DESC, MemberLevel='Gold' DESC, MemberLevel='Silver' DESC, MemberLevel='Paying' DESC, MemberLevel='Non-Paying' DESC; Thanks again Mike! Jason -- MySQL General

Re: Resetting Auto_Increment

You got to be kidding! I am sure there's a better solution. Hassan - Original Message - From: "Tobias Asplund" <[EMAIL PROTECTED]> To: "Hassan Shaikh" <[EMAIL PROTECTED]> Cc: < Sent: Monday, January 12, 2004 9:43 PM Subject: Re: Resetting Auto_Increment > On Mon, 12 Jan 2004, Hassan Sh

Re: Strange ORDER BY question

On Mon, 12 Jan 2004, Lewis, Jason wrote: > Okay I have a field in my db called MemberLevel in this field you can be one of 5 > levels. > > Platinum > Gold > Silver > Paying > Non-Paying > > > now my question is, how would I ORDER BY MemberLevel and get it to come out in the > above order? I have

wildcards the field

Hi, I'd like to use a mysql database as a lookup to authorize people to edit a webpage. The idea is that people would go to a main login page for authentication and then when they visit a page they are authorized to edit, they see an "edit this page" link. What I'm envisioning is a really bas

Re: Automatic conversion from `char` TO `varchar`

Martijn Tonies wrote: Hi Michael, The manual says The following problems are known and will be fixed in due time: [...] All string columns, except BLOB and TEXT columns, automatically have all trailing spaces removed when retrieved. For CHAR types t

Space Column

I am beginning in mysql, and I do not obtain to create a table with a space column. some friend could help me? mysql> CREATE TABLE g1 (p1 GEOMETRY); Error 1064 : -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

RE: Strange ORDER BY question

From: Lewis, Jason [mailto:[EMAIL PROTECTED] > Okay I have a field in my db called MemberLevel in this field > you can be one of 5 levels. > > Platinum > Gold > Silver > Paying > Non-Paying > > > now my question is, how would I ORDER BY MemberLevel and get > it to come out in the above

Recreating InnoDB tables from .frm

I'm cleaning up a user-error where the innodb data files were deleted without a useful backup. I need to reconstruct the tables and still have the frm files. Is this possible? A significant amount of time was put into these tables' structures and I hate to lose that effort... Yes the users are

Can't create Database

Ok got MySQL running and I have MyODBC installed as well. In any event. I have the test database and I can see it. I need to create a new database and it is not letting me do that. It tells me access denied for user ' ' @' localhost. I used the syntax mysqladmin create database . Have I done s

Strange ORDER BY question

Okay I have a field in my db called MemberLevel in this field you can be one of 5 levels. Platinum Gold Silver Paying Non-Paying now my question is, how would I ORDER BY MemberLevel and get it to come out in the above order? I have been racking my brains for a week on this one and any he

RE: my.ini file for two instances of MySql - need help

Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in the manual. Sorry for the bother, all. From: Tobias Asplund <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: "'Rich Brant'" <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySq

Re: my.ini file for two instances of MySql - need help

> # If you specify no service name, the server uses the default service name of MySQL > and the server reads options from the [mysqld] group in the standard option files. > # If you specify a service name after the --install option, the server ignores the > [mysqld] option group and instead read

RE: my.ini file for two instances of MySql - need help

> Hello, > > What do I need to add to the my.ini file? Can anyone post a typical setup > of this as an example? I install with mysqld-nt-max --install servicename servicename in those cases are MysQL40, MySQL41 and MySQL50 Those are the relevant rows: [mysqld] [mysql40] basedir = C:/mysql/4.0

Problem creating sp

I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the mysql's page example to test but makes an error: mysql> delimeter | -> create function hello (s char(20)) returns char(50) -> return concat('Hello, ',s,'!'); ERROR 1064 (42000): You have an error in your SQL syntax.

Re: backup my database

On Mon, 12 Jan 2004, Alaios wrote: > Hi there. Do u know how can i backup my database? > (create && insert) http://www.mysql.com/doc/en/Backup.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.ini file for two instances of MySql - need help

Thanks, Chris, but how do I refer to the sencond instance of MySQL, the version 4? That's what's not clear to me. I did read the section in the manual, but it doesn't explain how to refer to seperate instances. THanks! From: "Chris L. White" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> T

Re: field reference question

On Mon, 12 Jan 2004, Ed Lazor wrote: > Is there an abstract way to refer to field names in a result set? > select ID, Name, Price from Products order by field(1) > where "field(1) would be the abstract way of referring to the specific field to sort > on. ORDER BY # Where # is the number of the c

Mysql 4.1.1a

Hello mysql, Table-level privileges do not work at all... (on Windows) -- Best regards, Viktor mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

backup my database

Hi there. Do u know how can i backup my database? (create && insert) __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

field reference question

Is there an abstract way to refer to field names in a result set? For example: select ID, Name, Price from Products order by field(1) where "field(1) would be the abstract way of referring to the specific field to sort on. It's for a function that allows me to display tables and sort by colum

RE: my.ini file for two instances of MySql - need help

Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that

Re: my.ini file for two instances of MySql - need help

At 16:48 + 1/12/04, Rich Brant wrote: Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both run

my.ini file for two instances of MySql - need help

Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.in

Re: Resetting Auto_Increment

On Mon, 12 Jan 2004, Hassan Shaikh wrote: > Hi, > The following does not work for InnoDB tables. The manual says "The next > AUTO_INCREMENT value you want to set for your table (MyISAM). " > ALTER TABLE AUTO_INCREMENT = ; > > Any suggestions for InnoDB? Insert a row with a custom value, then de

Resetting Auto_Increment

Hi, The following does not work for InnoDB tables. The manual says "The next AUTO_INCREMENT value you want to set for your table (MyISAM). " ALTER TABLE AUTO_INCREMENT = ; Any suggestions for InnoDB? Thanks. Hassan

Re: Optimization help

On Jan 12, 2004, at 08:09 AM, Douglas Sims wrote: I think... you don't have an index on the "Incident" field itself, just on (Date, Incident, Type, Task) which means that it concatenates those fields and orders the result - thus this may be virtually useless if you're looking for a specific inc

Problem with MySQL and Solaris 9 sparc

> > Hi, my name is Carlos Flores, and i have solaris 9 on ultra 10 > > workstation, but > > i can not up this daemon, with /opt/sfw/mysql/bin/mysqld_safe & i try > > to up this > > daemon, but always begin but in second line tell me: mysql ended, and > > i try with > > mysql_install and anyone opti

COMP_ERR is missing in windows binary distribution zip file of 4.1.1a

Hello mysql, subj. It's inconvenient, because one should get source distribution and compile this tool. -- Best regards, Viktor mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: Question about Mysql C API v 3.22 and 3.23

At 8:51 -0600 1/12/04, Joe Johnson wrote: Hello, I am attempting a change in my use of mysql C API to use 3.23.54 instead of 3.21 and I am finding that the mysql_real_connect function is failing to run (it crashes the program). My mysqld version is also 3.22.27. Anyone know whether this is a bug i

Re: inser woes

:( Thank you - my only defense - it was 04:00, I think I looked at it too long and got hung up on the line 2. Doug On Mon, 12 Jan 2004, Johan Hook wrote: > Hi Doug, > I think you need to quote "imgsml=C2BUWS1028.jpg," like > imgsml='C2BUWS1028.jpg', > > take care, > /Johan > > [EMAIL PROT

Re: Optimization help

I think... you don't have an index on the "Incident" field itself, just on (Date, Incident, Type, Task) which means that it concatenates those fields and orders the result - thus this may be virtually useless if you're looking for a specific incident within a large date range. Since your query

Question about Mysql C API v 3.22 and 3.23

Hello, I am attempting a change in my use of mysql C API to use 3.23.54 instead of 3.21 and I am finding that the mysql_real_connect function is failing to run (it crashes the program). My mysqld version is also 3.22.27. Anyone know whether this is a bug in that version of the C API? Thank You,

Optimization help

Hi all - I have a speed problem that I don't understand. I've been pretty active with DB's for a few years, but I'm no expert, so let me know if I'm missing the obvious. I have Paul DuBois' MySQL book (New Riders edition) and Descartes and Bunce's Programming DBI book on my desk, so feel free

Re: Passwords query

these are definitely MySQL connection identities. Each with specific (different) privileges. You can connect to the database directly with these. - Original Message - From: "Matthew Stuart" <[EMAIL PROTECTED]> To: "MySQL email support" <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 6:

Re: metric conversions

You could do something like (don't copy and paste, this is just for you to have an ideia - i didn't understand your calculations with 0.063 and others...): SELECT IF (metric="cm", expression_in_centimeters, expression_in_inches) , ...other_fields FROM ... where "metric" is the name of the tab

Re: hierarchical records, I need some help!! ;(

Victor, First: don't ask the same thing twice. > I have one table called noms like this: > > > | id | int(11) | | PRI | [NULL] | auto_increment | > | reference| varchar(255) | > | component| varchar(255) | > > the relation between reference and component is hierarch

Re: metric conversions

* Richard Davies > I recieve measurements for a product sometimes in inches, sometimes in > centimeters. > > These are stored in table1 > int not null primary key, measurement1 int, measurement2 int, type > varchar(255) > > I need to extract data from this table and store it in another > table with

User quotas, how?

Hiya all! I'm curious about if there's a simple way to manage user quotas in a MySQL database? F.x. user one can have 10MB data in the database and user two can have a maximum of 5MB? Anders Norrbring -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: metric conversions

Hi, > I recieve measurements for a product sometimes in inches, sometimes in > centimeters. > > These are stored in table1 > int not null primary key, measurement1 int, measurement2 int, type > varchar(255) > > I need to extract data from this table and store it in another table with all > measure

hierarchical records, I need some help!! ;(

Hi I have one table called noms like this: | id | int(11) | | PRI | [NULL] | auto_increment | | reference| varchar(255) | | component| varchar(255) | the relation between reference and component is hierarchical like reference - > component reference

metric conversions

I recieve measurements for a product sometimes in inches, sometimes in centimeters. These are stored in table1 int not null primary key, measurement1 int, measurement2 int, type varchar(255) I need to extract data from this table and store it in another table with all measurements converted to

Re: Passwords query

These look like the security permissions for 3 MySQL user entries. The first one is the administrator account which can do pretty much anything. The second looks like an account used by a program. The third looks like it can be given to individual users as it can only looks at records, not chan

Re: Storing currency values

* Asbjørn Konstad > I’ve spent some day(s) probing the web to find a solution to this problem: > > A table-column for storing currency –> float(10,2). > > As my users are punches the currency value like this “255,55”, > with a comma as decimal point, MySQL stores this value as zero (0.00). > > I qu

Re: Storing currency values

Just convert the format of the input in your program before saving the value. In VB/ASP us can do: replace(255,55,",",".") -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Passwords query

I have been given these passwords for a MySQL db on a remote server. I have to dump the records to this volume on the remote and I am not sure what these passwords mean to me. SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER username_master password SELECT,INSERT,UPDATE,DELETE username_runtime pass

Re: I'm using 4, host using 3!!!

* Matthew Stuart > I am using version 4 of MySQL and the people who I am told to use to > host the site are running 3 on the server I will be using. This is probably not so unusual. 3.23.x hopefully, and x should be as big as possible...: 3.23.47 was the last version released in 2001, 3.23.54 was

Speeding up queries by avoiding ORDER BY clauses

Hi, I am trying to speed up the full text searching on my MySQL database. I currently have one table that has approximately 90,000 rows added to it each 24 hour period in batches of up to 200 rows constantly. These rows are will be kept for approximately 60 days, however I am currently working

I'm using 4, host using 3!!!

I am using version 4 of MySQL and the people who I am told to use to host the site are running 3 on the server I will be using. I am not using any real complex table structures eg: autoincrement, date, timestamp, medium int, small int, indexes. I have to do a dump of data to install on remote s

Re: Storing currency values

Hi Asbjørn, try to use "replace" function: http://www.mysql.com/doc/en/String_functions.html update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ; Best regards, Mikhail. - Original Message - From: "Asbjørn Konstad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: M

mysqld crash on FreeBSD-Alpha (64 Bit)

>Description: mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha >How-To-Repeat: Any acces over IP (not domain socket) crashes mysqld: #/usr/local/bin/mysqladmin: connect to server at 'install' failed error: 'Lost connection to MySQL server during query' syslog: install mysqld[78066]: warnin

Re: query efficiency

Hi Dan, Just run the UPDATE with all the column you want to update. :-) MySQL won't update the ones that haven't changed (which may have been said). Don't waste time trying to determine whether you should include a column in the UPDATE or not. The only time it could be an issue is if you're se

Re: Automatic conversion from `char` TO `varchar`

Hi, - Original Message - From: "Michael Stassen" Sent: Sunday, January 11, 2004 5:10 PM Subject: Re: Automatic conversion from `char` TO `varchar` > > Martijn Tonies wrote: > > > Hi, > > > >>The manual says > >> > >> > >>>The following problem

Re: What full-text improvements are next?

While on the subject of wishes for FullText enhancements, there is one I would like to add to the wish list: the ability to make certain punctuation characters into "letters" for the purpose of FullText searches. The main reason is to put video timecodes, which are in the form 12:34:56:01 int

Re: Which one is better: CHAR or VARCHAR?

Hi Hassan, In a case like that where you know the data will always be a certain length, CHAR is definitely better. VARCHAR will actually waste space (1 byte) when the data is always a certain length. And yes, if using the CHAR allows your table to have fixed-length rows, there will be a speed im

Re: Which one is better: CHAR or VARCHAR?

If the data is 10-char in length always, CHAR is better performance-wise. - Original Message - From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 11, 2004 6:34 PM Subject: Which one is better: CHAR or VARCHAR? Hi, I've a column of type VARCHAR(10) w

Re: 4.1.1 FTS 2-level?

Hi, - Original Message - From: "Sergei Golubchik" To: "Steven Roussey" Sent: Wednesday, December 10, 2003 7:44 AM Subject: Re: 4.1.1 FTS 2-level? > Hi! > > On Dec 09, Steven Roussey wrote: > > Does Mysql 4.1.1 have the two level index system integrated into it for full > > text searches?

What full-text improvements are next?

Hi, Sorry, I guess this is yet another question for Sergei! :-) Since the full-text search TODO in the manual is a little vague (and hasn't been updated much) and it was kind of a "surprise" when multi-byte character-set support was added to 4.1 a couple months ago, I'm wondering what "surprises"

Re: New grant tables

i dont think that, cauz 'Password' field in 'user' table was always 16 char long and still is. In fact, check for the no. of privs in 'user' table. if it is 21 or 14, as in 3.23.x it was 14 and in 4.0.17 is 21. Hope that helps Nitin - Original Message - From: "Director General: NEFACOMP"

Storing currency values

Hello. I’ve spent some day(s) probing the web to find a solution to this problem: A table-column for storing currency –> float(10,2). As my users are punches the currency value like this “255,55”, with a comma as decimal point, MySQL stores this value as zero (0.00). I quess the reason fo

  1   2   >