Re: Is It Possible To Change the Value of A Particular Field Manually?

you can optionally use MySQL Front to view and edit data in GUI mode get it free of cost athttp://www.mysqlfront.de/ Enjoy Nitin - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Caroline Jen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 1

Problems with MySQL 4.0.16

Hello, I am using MySQL 4.0.16 on Debian GNU/Linux at the moment. In this database there are over 4,5 Mio. entries! The Database crashs with follow errors: 031217 19:21:06 mysqld started /opt/lampp/sbin/mysqld: ready for connections. Version: '4.0.16-log' socket: '/opt/lampp/var/mysql/mysql.so

Re: Is It Possible To Change the Value of A Particular Field Manually?

Caroline Jen wrote: Hi, I am not a database person. I have a database called "members". One of the fields in this database is "user_name". There are a number of records in this database. Under the field user_name, I would like to make some changes manually; for example, I want to change John D

mysql_connect() problem

Hi, I am trying to setup network having 1) Linux main server running IPTABLES firewall, squid, dns server. 2) LAN connected to main server. 2) DMZ having apache, mysql and php, mail server connected to main server. User will use php script from remote host to connect to mysql as follows: MYSQL_

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

Martijn, I've asked this question a year ago on the Borland forums but didn't get any replies. Do you know of any websites (non-programming related) that are using Interbase/Firebird for their primary webserver database? I don't mean programmer hangouts like www.mers.com or www.tamaracka.com e

Binary install instructions wrong?

Hey all, I don't like the default locations that mysql tries to install into.. I like putting stuff in user accounts, with a version directory. Easier to maintain, yada yada. Anyways, as per the instructions you have to change a path in ./bin/mysqlaccess I did this but when I run the script

Re: MySQL GUI tool

I have been using it for a long time is works fine ! :) - syed sanya Amanullah <[EMAIL PROTECTED]> wrote: Hi, I'm Using the Same, the Tool is very much useful to me to export data from one server to another online, and for much more activities. Excellent... -Aman. Mike Blezien wrote

mysql_connect() problem

Hi, I am trying to setup network having 1) Linux main server running IPTABLES firewall, squid, dns server. 2) LAN connected to main server. 2) DMZ having apache, mysql and php, mail server connected to main server. User will use php script from remote host to connect to mysql as follows: MYSQL_CON

Is It Possible To Change the Value of A Particular Field Manually?

Hi, I am not a database person. I have a database called "members". One of the fields in this database is "user_name". There are a number of records in this database. Under the field user_name, I would like to make some changes manually; for example, I want to change John Doe to john_do

Re: MySQL GUI tool

Hi, I'm Using the Same, the Tool is very much useful to me to export data from one server to another online, and for much more activities. Excellent... -Aman. Mike Blezien wrote: Hello, Was wondering if any one on the list has or is using PremiumSoft Navicat's MySQL Administration Tool for wi

Re: high water mark

Hi Jamie, Yes, when tables are made "smaller" in MySQL, the file size isn't actually reduced. I guess it shouldn't usually make a speed difference unless your SELECTs are doing a table scan. Reads that use an index shouldn't really be affected, I don't think. If you want to reclaim the deleted sp

Re: MySQL 4.0.17 has been released

Hi! Well, I checked the code and looks like in 4.0.17 lower_case_table_names is NOT forced to 1 on case-insensitive file system, despite the changelog entry (that we will fix, by the way). Obviously a programming mistake, but for now only warning that lower_case_table_names is forced to 1 is issue

Re: MySQL 4.0.17 has been released

OK, ehm, considering Heikki's post, why does MySQL take care of case-sensitive table names at all? I'm not that familiar with the whole thing about it, but aren't database names also case-insensitive? I know that column names are. So why isn't this option removed and table names are generally treat

Re: [ MySQL: Problems with Innodb ]

Osvaneo, you probably forgot to move also ib_logfiles. > InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 7 1021600303 > InnoDB: Doing recovery: scanned up to log sequence number 7 1021600256 It cannot scan the current ib_logfiles at all! Best regards, Heikki Tuur

Re: Innodb multiple tablespaces benchmark

Carlos, - Original Message - From: ""Carlos Proal"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, December 12, 2003 4:09 AM Subject: Innodb multiple tablespaces benchmark > > > Hi all, specially to Heikki. > > Its really amazing that multiple tablespaces are avai

Re: "Planned" transactions?

Chris, - Original Message - From: "Chris Nolan" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, December 13, 2003 7:54 AM Subject: "Planned" transactions? > Hi again all, > > Given that a transaction looks like this: > > BEGIN; > SELECT useless_field FROM useless

Re: Questions about MySQL implementation

Chris, - Original Message - From: "Chris Nolan" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, December 13, 2003 7:24 AM Subject: Questions about MySQL implementation > Hi all! > > I've got a few questions that I was hoping some of the fine readers of > this lis

Re: foreign keys.

hehehe, Yeah figures that it was something stupid I did!!! Thanks for that. Mof. On Thu, 18 Dec 2003 09:30 am, Heikki Tuuri wrote: > Mofeed, > > - Original Message - > From: "Mofeed Shahin" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday

Re: InnoDB lock in share mode problems

Andrew, SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY] [DISTINCT | DISTINCTROW | ALL] select_expression,... [INTO {OUTFILE | DUMPFILE} 'file_name' export_options] [FROM

Re: Basic error

Hello friendly helper types, Forget it people. I'm an idiot. Just forgot to change the table name. Of course then it at least had more clue as to what it was doing that myself. I'm going away now, but you can be sure I'll be back with more silly questions later. Bye. :^) > What is the pr

RE: Basic error

From: Trevor Rhodes [mailto:[EMAIL PROTECTED] > Hello friendly helper types, > > What is the problem here. I can't find any errors. I know > it's there but as a > newbie I'm as blind as a bat at the moment. Thanks for your help. > > Warning: mysql_num_rows(): supplied argument is not a valid

Re: Basic error

Hi Trevor You haven't the query which connection to use: $result = mysql_query( "select * from domains", $link ); HTH Steve Davies Trevor Rhodes wrote: Hello friendly helper types, What is the problem here. I can't find any errors. I know it's there but as a newbie I'm as blind as a bat at t

Re: foreign keys.

Mofeed, - Original Message - From: "Mofeed Shahin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 12:47 AM Subject: Re: foreign keys. > On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote: > > Mofeed, > > > > - Original

Re: foreign keys.

On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote: > Mofeed, > > - Original Message - > From: "Mofeed Shahin" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, December 18, 2003 12:20 AM > Subject: Re: foreign keys. > > > Hmmm, Thanks for tha

RE: Basic error

try adding an error report after the query $result = mysql_query( "select * from domains" ) or die (mysql_error()); the rest looks OK Peter -Original Message- From: Trevor Rhodes [mailto:[EMAIL PROTECTED] Sent: 17 December 2003 22:26 To: [EMAIL PROTECTED] Subject: Basic error Hello f

MySQL GUI tool

Hello, Was wondering if any one on the list has or is using PremiumSoft Navicat's MySQL Administration Tool for windows, and if so, any thoughts on it... good, excellent, poor...etc. Appreciate the feedback ;) TIA -- MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Pub

Re: Detecting locks (using connector/j)

Jonck, sorry, there is currently no way to detect InnoDB locks, except by setting globally innodb_lock_wait_timeout=1 in the [mysqld] section of my.cnf. Then your failing lock requests return with the error 'lock wait timeout'. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Forei

Basic error

Hello friendly helper types, What is the problem here. I can't find any errors. I know it's there but as a newbie I'm as blind as a bat at the moment. Thanks for your help. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource Warning: mysql_fetch_row(): supplied a

Re: MySQL 4.0.17 has been released

Hi, I saw the change as soon as it was posted last week or whenever and didn't think anything of it. But the point Yves brings up seems very important! Although, I'm not sure what to do then with "bug #1812." Too bad MySQL's code can't make database/table names case-sensitive like on *nix. e.g.

Re: foreign keys.

Mofeed, - Original Message - From: "Mofeed Shahin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 12:20 AM Subject: Re: foreign keys. > Hmmm, Thanks for that. > But I'm not quite sure what it means. > > Mof. > >

Re: MySQL 4.0.17 has been released

Hi! I would like to remind people that if you want to move an InnoDB database between Unix and Windows, you have to consider the following: http://www.innodb.com/ibman.php#Moving " On Windows InnoDB stores the database names and table names internally always in lower case. To move databases in a

Re: foreign keys.

Hmmm, Thanks for that. But I'm not quite sure what it means. Mof. LATEST FOREIGN KEY ERROR 031218 8:48:23 Error in foreign key constraint of table moftest/foo, FOREIGN KEY (First_Name, Last_Name) REFERENCES Blah (First_Name, Last_Name)) TYPE=INN

How boolean full-text search finds matches?

Hi, Just have a couple more full-text search inquiries here. :-) I'm not exactly clear on how matching rows are found when searching for 2 or more required words: '+word1 +word2'. I understand that it can't currently know which word occurs less, so that it can be searched first -- this optimizat

How boolean full-text search finds matches?

Hi, Just have a couple more full-text search inquiries here. :-) I'm not exactly clear on how matching rows are found when searching for 2 or more required words: '+word1 +word2'. I understand that it can't currently know which word occurs less, so that it can be searched first -- this optimizat

Re: foreign keys.

On Wed, 17 Dec 2003 07:55 pm, Victoria Reznichenko wrote: > Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > mysql> CREATE TABLE foo ( > >-> ID INT PRIMARY KEY, > >-> note VARCHAR(50), > >-> First_Name VARCHAR(50), > >-> Last_Name VARCHAR(50), > >

RE: Issues with count(), aliases, and LEFT JOINS

> -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 17, 2003 8:12 AM > To: [EMAIL PROTECTED] > Subject: RE: Issues with count(), aliases, and LEFT JOINS > > Try changing it to this: > > ... > -> COUNT(DISTINCT switch_connect1.switch_id) AS lef

Re: MySQL 4.0.17 has been released

I agree, 100%. We live in a mixed environment of UNIX and Windows and as such, we've assumed case insensitivity in our apps. I know that this is bad practice, but forcing this flag on us is and even worse practice. This should always, always be an option. I wont be able to upgrade until this is fi

Re: foreign keys.

Mofeed, if you are using a relatively recent version of 4.0, or 4.1.1, please look with SHOW INNODB STATUS\G what is the latest FOREIGN KEY error. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot ba

Re: Change the size of an InnoDB table field

Felix, I assume this is a MySQLCC bug. Can you perform the ALTER TABLE from using the mysql interactive SQL client program? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB whi

Re: Can I really have no_wait row-locks in MySQL+InnoDB?

Dmitry, we have to consider implementing NOWAIT and SKIP LOCKED clauses to SQL statements. The latter would be useful in implementing transactional queues. But there are lots of items in the TODO list. Do not expect these soon. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Fo

Re: How to include count(*) in selection criteria

Hi, RE: > In other words, you cannot use values that are determined from > the selected rows to determine which rows to select. :-) Sounds very logical. In fact I was not surprised that my query did not work, I just had no idea about the workaround. Thanks again! Gaspar -- MySQL General Maili

Re: MySQL 4.0.17 has been released

On Wednesday, December 17, 2003 1:58 PM CET, Lenz Grimmer wrote: > Functionality added or changed: > >* `lower_case_table_names' is now forced to 1 if the database > directory is located on a case-insensitive file system. (Bug > #1812) Uh, _very_ bad. I know that my Windows filesystem is

Re: Increase space for /var/db

At 9:03 -0800 12/17/03, Naveen Babu wrote: Hello, I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated to /var/db. Our database is increasing so fast that now i need to expand the memory for /var/db. I guess one way to do is to install a new hard drive and then mount it to /va

Increase space for /var/db

Hello, I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated to /var/db. Our database is increasing so fast that now i need to expand the memory for /var/db. I guess one way to do is to install a new hard drive and then mount it to /var/db. But i would like to know if there i

Re: case sensitivity of table names

At 13:00 -0500 12/17/03, Mayuran Yogarajah wrote: Paul DuBois wrote: At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote: I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT *

Connector/J 3.0.9 Unexpected end of input

I upgraded to Connector/J 3.09 from 2.0.14. After some hours, the driver looses it's connection and will not reconnect (despite setting reconnect=true). The error starts as follows below. I rollback to 2.0.14 and everything is stable again. This is using mysql 4.0.16-standard. Is connector/j 3.0x p

How to include count(*) in selection criteria

use having N > 10 The having clause takes the results of the query AFTER all of the rows have been read and aggregated by the group by clause and further reduces the set of rows that gets returned. - original message - Date: Wed, 17 Dec 2003 12:52:08 -0500 (EST) From: Gaspar Bakos <[EMAI

Re: How to include count(*) in selection criteria

At 12:52 -0500 12/17/03, Gaspar Bakos wrote: Dear all, I am trying the following mysql statement (probably it will be obvious that I am a newcomer): select IMdirectory, IMljd, count(*) as N from Images where IMstid = 5, N > 10 group by IMdirectory order by IMljd; ERROR 1054: Unknown column 'N' in

Re: case sensitivity of table names

Paul DuBois wrote: At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote: I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT * FROM mytest. How can I make it so that the table n

How to include count(*) in selection criteria

Dear all, I am trying the following mysql statement (probably it will be obvious that I am a newcomer): select IMdirectory, IMljd, count(*) as N from Images where IMstid = 5, N > 10 group by IMdirectory order by IMljd; ERROR 1054: Unknown column 'N' in 'where clause' My question is: how could I

errno 138

Hi all, We're trying to upgrade from 4.0.2 max to 4.0.16 Everything starts fine, but when querying the DB, something as simple as "SELECT count(*) FROM myTable" will return errno 138, but this works fine before the upgrade. Its probably something minor, but we're at a loss. Im not sure what oth

Re: case sensitivity of table names

At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote: I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT * FROM mytest. How can I make it so that the table name is still MyTest b

case sensitivity of table names

I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT * FROM mytest. How can I make it so that the table name is still MyTest but selects work with mytest ? -- MySQL General M

Reverse DNS question

At 10:55 AM 12/17/2003, you wrote: MySQL checks the IP address of the user connecting to it's server. It then does a Reverse DNS lookup on that IP address, to get the name associated with it (there is only one name associated with any IP, the rest are just aliases) Suppose we wanted to associate

Re: Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

Yes, Matthew, the response to my original query here has been almost overwhelming, far surpassing what I had expected. Yes, you certainly "all deserve a pat on the back". Thanks to everyone who took the time to respond. This has proven to be a useful short cut to ascertaining some of strength

RE: Spatial Extension in MySQL 4.1.1-alpha

Hi Steve and Paul, Thanks - the comma did get me! Paul, no the mistake isn't in the manual - I managed it all on my own. For anyone following, the correct sequence was: mysql> CREATE TABLE geom ( g GEOMETRY ); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO geom VALUES ( GeomFromText(

RE: Variable names, colum names

From: Paul Fine [mailto:[EMAIL PROTECTED] > Greetings! > > Is it common practice to name script variables/form data in > say PHP to match the appropriate colums in the db tables? > > I can see how this makes sense, however in the little work I > have done I preferred to do the opposite as it s

mysql query not dead after 'kill'

I have run into this a few times now, and am wondering there is a solution: I have two queries: (1) select query on a MERGE table (2) 'alter table' on the same MERGE table. As expected, the select query will lock the 'alter table' query. The alter table query is intended to swap one of the tabl

Re: Problem creating new user.

As advised by other member of this mailing list, Let me check whether it is reverse DNS problem. Reverse DNS is giving "202-63-167-192.exatt.com" instead www.networkshastrihall.com". Regarding password, this is test database not in production . I am going to change all settings later on. From n

RE: Variable names, colum names

Well, I keep my internal script variables identical to the relevant MySQL variable , with the exception of putting the type identifier in front of the script variable (s for string, i for int, etc...) I do the exact opposite of form data in trying not to have a form variable with the same name as

Variable names, colum names

Greetings! Is it common practice to name script variables/form data in say PHP to match the appropriate colums in the db tables? I can see how this makes sense, however in the little work I have done I preferred to do the opposite as it seems to be helpful to keep a distinction. Thanks! -- My

RE: Issues with count(), aliases, and LEFT JOINS

Try changing it to this: ... -> COUNT(DISTINCT switch_connect1.switch_id) AS left_port_count, -> COUNT(DISTINCT switch_connect2.switch2_id) AS right_port_count, ... I would suggest, if that suggestion fails, that you experiment with just switch_connect.switch_port and switch_connect.swi

Re: MySQL with SSL enabled

On Wed, 2003-12-17 at 09:39, rmck wrote: > Hello, > > I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL > enabled. > > Does this feature come enabled with the binary download? Or do I need to download > the source and compile > it? > > Any good links ot setting up

Re: MySQL with SSL enabled

On Wed, 2003-12-17 at 09:39, rmck wrote: > Hello, > > I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL > enabled. > > Does this feature come enabled with the binary download? Or do I need to download > the source and compile > it? > > Any good links ot setting up

RE: Problem creating new user.

MySQL checks the IP address of the user connecting to it's server. It then does a Reverse DNS lookup on that IP address, to get the name associated with it (there is only one name associated with any IP, the rest are just aliases) The host you are connecting from does not resolve to www.networksha

Re: MySQL with SSL enabled

rmck wrote: Hello, I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL enabled. Does this feature come enabled with the binary download? Or do I need to download the source and compile it? Any good links ot setting up MySQL with SSL enabled? Good luck. Let me kn

Re: Problem creating new user.

If that error is verbatim from the console, then DNS may be working, but it is not who MySQL is acknowledging you as, is there a firewall in between you and the MySQL server? looks like you'd need a grant for 202-63-167-192.exatt.com. and i know its not working, but you really shouldn't post pass

RE: Null-safe equal help, please

-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:44 PM To: Knepley, Jim; [EMAIL PROTECTED] Subject: Re: Null-safe equal help, please At 15:22 -0700 12/16/03, Knepley, Jim wrote: >>I've got a WHERE clause: >>WHERE possibly_null_value IS N

RE: Null-safe equal help, please

Please reply to the list so that others can follow this discussion. Thanks. At 8:26 -0700 12/17/03, Knepley, Jim wrote: -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:44 PM To: Knepley, Jim; [EMAIL PROTECTED] Subject: Re: Null-safe equal

Re: Problem creating new user.

Hi, I tried to create user with GRANt as follows : mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO ads123@'

MySQL/InnoDB-4.0.17 is released

Hi! InnoDB is a MySQL table type which is included in all GPL versions of MySQL-4.0 that you can download from http://www.mysql.com, and is included in the commercial MySQL license MySQL Pro, which you can buy from https://order.mysql.com/?sub=pg&pg_no=1. You can buy technical support for InnoDB

Re: Problem creating new user.

ads mysql wrote: I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # Your DNS is broken. It gives error. I sthere anything giving permis

MySQL with SSL enabled

Hello, I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL enabled. Does this feature come enabled with the binary download? Or do I need to download the source and compile it? Any good links ot setting up MySQL with SSL enabled? Thanks Rob -- MySQL General Mail

Re: Problem creating new user.

I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # It gives error. I sthere anything giving permission to connect to mysql for particular H

Grant access to named table in many DBs

Situation: Multiple DBs with the same named table in each DB. Needed: Grant insert to a named login to the named table in all DBs. Not wanted: A grant for each db.named_table combo :) Am I right in concluding that my not wanted solution is the only solution to this case? Ie, I'll have to grant

Re: Problem creating new user.

On Wednesday 17 December 2003 12:45, ads mysql wrote: > It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p > bankaccount Enter password: (here I enter password 'ads11') > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > YES) > Domain www.allnet.com is

MySQL 4.0.17 has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.17, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

On Dec 17, 2003, at 7:35 AM, Matthew Stanfield wrote: Wouldn't it be great if all mailing lists and newsgroups were as friendly and helpful as the mysql ones are. I host a couple of lists: ProLinux and ProPython, which are for developers that are new to Linux and Python, and want help getting

Re: Problem creating new user.

Unless i'm misunderstanding(highly possible)...if you are on the command line, you are going to be seen by mysql as localhost and not allnet.com. You'll only be seen as another host if you connect remotely. the webserver running on the localmachine and the mysql client will be seen as localhost.

Problem creating new user.

Hi, I can create new user with following. mysql>INSERT INTO user (Host,User,Password) VALUES('localhost','ads11',PASSWORD('ads11')); mysql>INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','bankaccount','ads11','Y','Y','Y','Y

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

Jerry Apfelbaum wrote: > I have been tasked with evaluating open source databases for a large > upcoming project: e-commerce, B2B, high availability. Jerry -- See what I meant when I said: "very active mailing lists where list subscribers are helpful and quick to respond." I think we all deserv

RE: Issues with count(), aliases, and LEFT JOINS

> -Original Message- > From: Brandon Ewing [mailto:[EMAIL PROTECTED] > Sent: Monday, December 15, 2003 2:28 AM > To: [EMAIL PROTECTED] > Subject: Issues with count(), aliases, and LEFT JOINS > > Greetings, > > This is driving me crazy. > > I'm running MySQL 4.0.15-standard. > > I've g

Re: Invalid ENUM values after upgrading from 4.0 to 4.1

It's known bug, will be fixed in 4.1.2 - Original Message - From: "Juri Shimon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Noor Dawod" <[EMAIL PROTECTED]> Sent: Wednesday, December 17, 2003 12:37 PM Subject: Re: Invalid ENUM values after upgrading from 4.0 to 4.1 > I have the same pr

Re: Invalid ENUM values after upgrading from 4.0 to 4.1

I have the same problem with cp1251 and, seems, it's a bug. I have posted correspoding message two days ago. Without any reply 8((( I migrate 3.23.55 -> 4.1.1 and I don't know about existing such problem in 4.0. Look in your .frm - your field is in correct charset. More of, inserts and updates of

good ways to start a multiuser-environment

hello, i'm working on a java-jsp-page with mysql-connection. now i've created a test-system with myisam-tables where the tables are just read. my plans for next weeks are, to make the owner of the site capable of entering/changing his data by his own - web-based and multi-user-capable. as this

Re: foreign keys.

Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > mysql> CREATE TABLE foo ( >-> ID INT PRIMARY KEY, >-> note VARCHAR(50), >-> First_Name VARCHAR(50), >-> Last_Name VARCHAR(50), >-> FOO_ID INT, >-> INDEX(FOO_ID), >-

Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

Thanks for reply! > >> 1. mysql -u root -e "create database t; show create database t; drop database t" > >> 2. mysql -u root -e "use_mysql; create database t; show create database t; drop database t" > >> 1.| t| CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET cp1251 */ > >> 2.| t

Re: Problem with replication

SQL Hi! Does anybody have any solution? I change time where query run. Each new day where query run first ones in day replication crash. "Slave start" on slave server restore replication. How can it be? I have no any ideas. Both servers have 4.0.16 > SQL > Hi all! > > Nearly very night I have

Re: Unable to insert String constants through my function

shiva shankar wrote: Hi, I USE THIS FUNCTION TO INSERT VALUES TO DIFFERENT VALUES OF MY DATABASE.. void InsertValues(const string &tableName, const string &values) { char ValuesToStore[255]; long datasize; char *EncodedData; char *query; strcpy(ValuesToStore, values.c_str()); Encode

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

Hi, > > > Jerry, > > > Interbase/Firebird looks good on paper. But there are a couple of > > > things to watch out for. > > > > > > 1) Check the Borland Interbase newsgroups for "corruption" to see if it is > > > still an issue. I know from reading their newsgroups a few years back , > >

Re: query over several tables

Philippe Rousselot wrote: Hi I have three linked tables : store, catalogue, and sales store : ID_store, store, date catalogue : ID_product, product sales : ID_sales, ID_store, ID_product, product, quantity I would like a view giving me ALL the products in catalogue with the quantity per store if