Re: Why does MySQL create a temp table when adding an index?
At 09:07 PM 12/10/2003, you wrote: Hi There, The data needs to be sorted into the key you specified. Any RDBMS does this type of operation. Some don;t copy the whole table though, just the columns you are indexing Cheers Chris Chris, Ok, I see your point. Some of the other databases I've used will simply read the data from the table and creates the index from that. They don't need to sort the table which creates a large intermediate table and a lot of disk I/O. The delay probably isn't noticeable to most people unless their tables have millions or rows in them. I suppose MySQL sorts the data first so it can build the branches of the index better (similar index values are adjacent). I wish there was some way of speeding it up, because I wouldn't want to do it very often with a 7gb table. There's only so much coffee a guy can drink. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Blocking One Table Blocks Others
Randy Chrismon wrote: Kim G. Pedersen wrote: BUT just a little hint , u sure it not ur _ (underscore) in table name which is a kind of wildcard that give u trouble ?? This raises an interesting question. I wrote earlier about troubles with mismatch field count and missing field errors. I have both tables and fields that have under_scores in the name; although none of the primary key, not null, or foreign keys have under-score names (but the tables do). Now I'm wondering if the missing field or mismatched counts arises from this. Before I go back to re-design all my tables and re-write all my code ;-< can anyone tell me whether this, in fact, might be the problem? I should say that the code I'm using has connector classes so I'm not writing native SQL statements. Rather, I'm defining field list objects, which contain field objects, which have values set, then executing the update method of the connection object, etc. etc. Thanks. Randy Being the impatient sort, I went ahead and stripped all the under scores from both my tables and my code. Didn't help I simply cannot insert the first record because of this missing field error. I have quadruple checked the tables and the code and everything matches up. I strongly suspect that the error description does not match the actual error. Oh well. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [RE-REPOST] Openssl support not activated?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greg G wrote: > > I'm still having trouble figuring this out. Please help! > > I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the > variables with mysqladmin, "has_openssl" is set to "NO". I've got > OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian > hosts. I'm not seeing any errors during the configure or compile phases. > > What could have happened to cause this, and how can I fix it? Did you create certificates and configure mysqld and the client libraries to find them (as it says to in the manual :))? http://www.mysql.com/doc/en/Secure_connections.html -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/19/6tvXNTca6JD8RAmWRAJ9fVokwiOLvkJGSfdkqO3lM2VH2ngCfQ3vE bpDK+g0PmvqtB3755EX7ncM= =1qIY -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Multiple languages in the same column
Hi All, I'd like to use the same column to store content from multiple languages (English, German, French, Japanese). Here is my understanding of the options available. In MySQL 4.0: - UTF-8 is not currently available as a charset - we can connect to the database using "useUnicode=true&characterEncoding=UTF-8" in the connection string. - this enables us to store, search and retrieve Unicode content from the column, as long as we always use JDBC with the above connection string, to interact with the db. - sorting will not work on the column In MySQL 4.1: - UTF-8 is available as a charset - We still neet to connect to the database using the above connection string (doesn't seem to work otherwise) - sorting will work, but only using the general utf8 collation (may not work for Japanese?). More collations will be available soon. - [can we cast/convert to a different charset (sjis) and use its collation for sorting? (performance is not really an issue)] Please let me know if any of these assumptions are incorrect. Thanks, Puny Sen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why does MySQL create a temp table when adding an index?
I don't understand why MySQL will create a copy of the table when I'm adding an index to it. Example: Alter Table Tablex Add Index NewIndex (col1,col2); ProcessList will show "copy to tmp table" for 99% of the process. This will physically copy the data to a temporary table. I have a 7gb table and adding an index takes a long long time. I don't see why the index can't be created without physically copying the data. If the index operation fails, then just delete the index. I don't see why creating an index needs to alter the data file. If it doesn't alter the data file, why copy it? I understand the need to copy the data when the Alter Table is changing the field definitions, but why do it when creating an index? Can someone shed some light on this? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Invalid Compressed Data Error??
Hello, When I try and unzip the linux pc binary download file mysql-standard-4.0.16-pc-linux-i686.tar I get no further than the first four files before getting this error. I tried a couple of mirrors with the same result. ejd
Re: Locking one table blocks others
Kim G. Pedersen wrote: BUT just a little hint , u sure it not ur _ (underscore) in table name which is a kind of wildcard that give u trouble ?? This raises an interesting question. I wrote earlier about troubles with mismatch field count and missing field errors. I have both tables and fields that have under_scores in the name; although none of the primary key, not null, or foreign keys have under-score names (but the tables do). Now I'm wondering if the missing field or mismatched counts arises from this. Before I go back to re-design all my tables and re-write all my code ;-< can anyone tell me whether this, in fact, might be the problem? I should say that the code I'm using has connector classes so I'm not writing native SQL statements. Rather, I'm defining field list objects, which contain field objects, which have values set, then executing the update method of the connection object, etc. etc. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference 2004 Call for Papers
MySQL AB is please to announce that the Call for Papers for the 2004 MySQL User Conference is now officially open. We encourage every MySQL user with something to say - from grey-bearded hackers and peach-fuzzed power users to corporate code wranglers and veteran DBAs - to drop by http://mysql.com/events/uc2004/speakers.html and write up your proposals for great sessions. We are looking for sessions that speak to your peers: practical, pragmatic and clueful presentations that focus on how you solved problems in a demanding or unique technical environment. Session that introduce a particular feature set or provide hands-on training to introduce newer developers to cutting edge functionality are also welcome (as is any cool or unique presentation). You can give sessions that range in length from 5 minute lighting talks up to 90 minute power tutorials. We also have set aside slots for 30 minute technical briefs and standard hour long sessions. Additionally we are looking for solid ideas from the community for Bird-of-a-Feather (BoF) sessions. These sessions give conference attendees a chance to meet and discuss topics of common interest with their peers. Visit http://mysql.com/events/uc2004/speakers.html to suggest ideas for the BoFs that you would like to participate in. The call for papers closes on January 14th. The conference will take place on April 14th to 16th in Orlando, Florida, USA. The call for BoFs and lightning talks closes on February 14th. For additional inspiration, check out last year's schedule: http://mysql.com/events/uc2003/schedule.html If you want to briefly discuss your ideas, fill out the appropriate form at http://mysql.com/events/uc2004/speakers.html and make a note in your comment. I will write you back in a day or so with some extra input. Good Luck! See you in Orlando! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Disk io wait during select,
Greetings.. Is their a way to list a time breakdown of a select? Amount of query waiting on disk-io, in memory, etc... I have tried the debug-info option with mysql client but it lists several memory settings. I have a 1.2 ultra-sparcIII that is twice as slow as a xeon 2.4 machine eventhough the sparc has superior memory and disks. Thanks, Trevor
Re: RAID Strip size
On Thu, Dec 04, 2003 at 10:33:17AM -0500, Brent Baisley wrote: > > Actually, you want to try to match the stripe size to your data size. > The ideal would be to have a stripe size equal to the size of a record > in your database. This way the disk needs only one read or write for > each database record. That depends on the storage engine you're using. For MyISAM, yes, the record size is a good way to do it. But for InnoDB, you'd probably want to use its page size. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 88 days, processed 3,535,395,556 queries (464/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
allowing for Japanese and Korean characters
What has to be done to mysql to allow for the insertion and extraction of Japanese and Korean characters? ( I will not be searching by them only displaying and saving them.) Do I only have to have the set the "characater set" in the table declaration or is there more to it? Also does the newest version of MySQL support UTF-8? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.16 64bit crash report
Hi Heikki, Heikki Tuuri wrote: Don, it is the assertion below which fails. Do you use FOREIGN KEY ON UPDATE CASCADE? Nope. Do you have any idea which query causes the crash? I didn't, but after Googling for similar problems, I found a thread where you had talked about a bug in a column prefix index. (here's the message: http://archives.neohapsis.com/archives/mysql/2003-q4/0697.html ) I was fairly sure I wasn't using any column prefix indexes, but sure enough, there was one. I removed the index, and MySQL has stopped crashing completely. Now, it's entirely possible that whichever user was submitting some query just stopped at the same time I removed that index. But prior to my doing that, MySQL was crashing every few minutes. Probably a dozen times within an hour or two. I'm keeping a close eye on it, and if it happens again, I'll turn the query log on to see if I can catch it. Please run CHECK TABLE on suspicious tables. Can you test on an x86 computer? I would be happy to, but since I don't know which query is doing it, I'm not sure it'd be much use. I can't easily put an x86 box into production to get the same load on it. Have you changed the default character set of the server in my.cnf? Nope. Can you please send me your my.cnf. Here it is. I actually had the innodb buffer set to 4G before, and lowered it to see if we were still hitting some old 32bit limit or something. Of course, there was no change, the crashes still occurred. FWIW, this on Red Hat Enterprise 3 for AMD64. --- [mysqld] datadir = /xserve1/mysql port= 3306 socket = /tmp/mysql.sock pid-file= /xserve1/mysql/zeus.pid skip-external-locking set-variable= key_buffer=256M set-variable= max_allowed_packet=10M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= read_buffer_size=1M set-variable= thread_cache=8 set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=512M set-variable= query_cache_size=512M set-variable= query_cache_type=1 set-variable= max_connections=500 set-variable= long_query_time=1 log-bin server-id=1 innodb_data_home_dir = /xserve1/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /xserve1/mysql/ innodb_log_arch_dir = /xserve1/mysql/ set-variable = innodb_buffer_pool_size=2G set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_log_file_size=512M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50 log-slow-queries log-error open-files-limit=8192 ft_min_word_len=3 max_connect_errors = 10 --- Thanks for your reply! Please let me know if there's anything else I can do. I'm happy to help test and debug. Don 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 which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ .. Builds an update vector from those fields which in a secondary index entry differ from a record that has the equal ordering fields. NOTE: we compare the fields as binary strings! */ upd_t* row_upd_build_sec_rec_difference_binary( /**/ /* out, own: update vector of differing fields */ dict_index_t* index, /* in: index */ dtuple_t* entry, /* in: entry to insert */ rec_t* rec,/* in: secondary index record */ mem_heap_t* heap) /* in: memory heap from which allocated */ { upd_field_t*upd_field; dfield_t* dfield; byte* data; ulint len; upd_t* update; ulint n_diff; ulint i; /* This function is used only for a secondary index */ ut_ad(0 == (index->type & DICT_CLUSTERED)); update = upd_create(dtuple_get_n_fields(entry), heap); n_diff = 0; for (i = 0; i < dtuple_get_n_fields(entry); i++) { data = rec_get_nth_field(rec, i, &len); dfield = dtuple_get_nth_field(entry, i); ut_a(len == dfield_get_len(dfield)); - Original Message - From: "Don MacAskill" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 10, 2003 7:49 PM Subject: MySQL 4.0.16 64bit crash report I'm running 4.0.16 on a dual-Opteron using the 64bit mysql-max binary distribution (tar.gz, not rpm) from mysql.com. I have 8GB of RAM, and it was using about 4.5GB at the time of the crash. 031210 9:24:34 InnoDB: Assertion failure in thread 1171265904 in file row0upd.c line 713 InnoDB: Failing assertion: len == dfield_get_len(dfield) InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report
Mysql 4.1
Hi there, i was wondering when a possible release of 4.1 will happen ? I can see its in Alpha still, but i am trying to instigate across the board server upgrades, so its best to wait until then. Please let me know. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Prepared statements in embedded MySQL
I was wonder if anyone here could comment on when prepared statements might be available in the embedded server, I would find it very helpful. Will they be in the 4.1 release? Are there plans to add support in some future release? Thanks, Richard Tibbetts -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Locking one table blocks others
Hi U lucky man ,,, I can't make my locks work at all :( BUT just a little hint , u sure it not ur _ (underscore) in table name which is a kind of wildcard that give u trouble ?? regards Kim Pedersen > Fella's, > > First of all I'd like to welcome myself to this list. Have been here before, > but now that I need your help again I decided to return. For the following question I've of course read the Manual, googled some .. Even checked the archives. Found no answer that satisfied me. > > For a website I'm writing some kinda stock-market game, really fun. You should check it out when it's done. Of course, while updating stuff on certain tables I want to do some things to prevent lost updates, dirty reads > and stuff like that. Would pretty much spoil the game for my dear users. Therefor I request a lock > > > LOCK TABLES eurostoq_units WRITE; > > That's the only table I really need a lock on. I am inserting in one other, > and updating to again one other but since I know beforehand for sure nobody > else is changing or reading from there I thought I didn't need to lock it. But now, when I do something like: > > > INSERT INTO eurostoq_transactions (walletid, unitid, value, what) > VALUES (9, 22, 400.3, 's'); > > Mysql starts Yelling at me, stating: > > > ERROR 1100: Table 'eurostoq_transactions' was not locked with LOCK > TABLES > > Now, please .. Of course I can request locks on other tables too. In fact I > did, as a workaround. But can anybody explain me why I cannot do anything (just found out I can't even do 'describe ' anymore when there's > one table locked) else with any other table? > > Thanks, > Wouter > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > mvh Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Locks dont lock
Hello I try in my program to make a lock. I try to prevent another session to read and write from the whole table I tried both LOCK TABLES pstockx WRITE and LOCK TABLES pstockx READ but no success. I put in a breakpoint in my program to be sure the lock are held and then I try to make a select from another session. It dont lock me up :( What am I doing wrong ,,is it some settings on server ?? 8128 Query LOCK TABLES pstockx READ 031211 0:22:058133 Connect [EMAIL PROTECTED] on elprint 8133 Query SET SQL_BIG_SELECTS=1 8133 Query select amount from pstockx where productID = 82846 8133 Query EXPLAIN select amount from pstockx where pro ductID = 1 031211 0:23:068128 Query SHOW COLUMNS FROM pstockx 8128 Query SHOW INDEX FROM pstockx 8128 Query select amount from pstockx where productID=8 2846 TIA Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: copy from table to it again
If you want to change the value in qid to 3 when it is 0 You really need an update update answer setqid = 3 where qid = 0 -Original Message- From: ÇÈæ ÇÈÑÇåíã [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 8:14 AM To: [EMAIL PROTECTED] Subject: copy from table to it again i want to ask you a question i have a data in a table `answer` and i want to copy the data which have a specific value in a filed and inserted into it again but i will change the value i try to use this but it's give me an error === INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct` , 3 FROM `answer` as a2 where a2.qid=0 === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication on one slave and two different masters
mysql, query I have a situation come up where we want one slave to act as backup for two different databases located in two different hosts. Can this be done? The master setup is easy. The slave setup is unclear. Can I have two sets of master-host, master-user, and master-password, master-port, master-connect-retry, w/o the mysqld getting confused? My experience is one slave, one master. No FAQ covers multiples master on one slave that I can find. I'm running mysql version 3.23.49 on Solaris. Thanks in advance David --- David E Lopez Org: SPS->WMSG->AT->SOC->CSAM Phone: 480-413-6251 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.16 64bit crash report
Don, it is the assertion below which fails. Do you use FOREIGN KEY ON UPDATE CASCADE? Do you have any idea which query causes the crash? Please run CHECK TABLE on suspicious tables. Can you test on an x86 computer? Have you changed the default character set of the server in my.cnf? Can you please send me your my.cnf. 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 which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ .. Builds an update vector from those fields which in a secondary index entry differ from a record that has the equal ordering fields. NOTE: we compare the fields as binary strings! */ upd_t* row_upd_build_sec_rec_difference_binary( /**/ /* out, own: update vector of differing fields */ dict_index_t* index, /* in: index */ dtuple_t* entry, /* in: entry to insert */ rec_t* rec,/* in: secondary index record */ mem_heap_t* heap) /* in: memory heap from which allocated */ { upd_field_t*upd_field; dfield_t* dfield; byte* data; ulint len; upd_t* update; ulint n_diff; ulint i; /* This function is used only for a secondary index */ ut_ad(0 == (index->type & DICT_CLUSTERED)); update = upd_create(dtuple_get_n_fields(entry), heap); n_diff = 0; for (i = 0; i < dtuple_get_n_fields(entry); i++) { data = rec_get_nth_field(rec, i, &len); dfield = dtuple_get_nth_field(entry, i); ut_a(len == dfield_get_len(dfield)); - Original Message - From: "Don MacAskill" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 10, 2003 7:49 PM Subject: MySQL 4.0.16 64bit crash report > > I'm running 4.0.16 on a dual-Opteron using the 64bit mysql-max binary > distribution (tar.gz, not rpm) from mysql.com. I have 8GB of RAM, and > it was using about 4.5GB at the time of the crash. > > 031210 9:24:34 InnoDB: Assertion failure in thread 1171265904 in file > row0upd.c line 713 > InnoDB: Failing assertion: len == dfield_get_len(dfield) > InnoDB: We intentionally generate a memory trap. > InnoDB: Send a detailed bug report to [EMAIL PROTECTED] > InnoDB: Thread 1183455600 stopped in file ha_innodb.cc line 396 > InnoDB: Thread 1176770928 stopped in file ha_innodb.cc line 396 > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked against is corrupt, improperly built, > or misconfigured. This error can also be caused by malfunctioning hardware. > We will try our best to scrape up some info that will hopefully help > diagnose > the problem, but since we have already crashed, something is definitely > wrong > and this may fail. > > key_buffer_size=268435456 > read_buffer_size=1044480 > max_used_connections=336 > max_connections=500 > threads_connected=143 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections > = 1284140 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > InnoDB: Thread 1174018416 stopped in file ha_innodb.cc line 396 > InnoDB: Thread 1214912880 stopped in file ha_innodb.cc line 396 > > Number of processes running now: 0 > > > Any ideas? > > Thanks, > > Don > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 Beta Release
Puny, - Original Message - From: "Puny Sen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 10, 2003 10:00 PM Subject: MySQL 4.1 Beta Release > --Boundary_(ID_9gZ0fPFbGnkpio2LXXaaOA) > Content-type: text/plain; charset=us-ascii > Content-transfer-encoding: 7BIT > > Hi All, > > Is there an ETA for MySQL 4.1 Beta release? there is no ETA, but my guess is that 4.1.2 will be labeled beta, and I guess it will be released around Jan 25th, 2004. If you do not use the new features of 4.1.1, it seems to be very stable already. > Thanks, > > Puny Sen 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 which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SQL Tutorial Trouble in MySQL
you can use the concat function: http://www.mysql.com/doc/en/String_functions.html SELECT concat(vend_city,', ',vend_state,' ',vend_zip) FROM Vendors ORDER BY vend_name; > -Original Message- > From: Gilbert Wilson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 10, 2003 2:42 PM > To: [EMAIL PROTECTED] > Subject: SQL Tutorial Trouble in MySQL > > > Hi all, > > I am following the lessons in Sams Teach Yourself SQL in 10 Minutes > using MySQL as the databse app. I am having some trouble > with Lesson 7: > Creating Calculated Fields where you are suppose to > concatenate several > fields. > > The Input looks like this: > > SELECT vend_city+', '+vend_state+' '+vend_zip > FROM Vendors > ORDER BY vend_name; > > The output should look like this: > > --- > Anytown,OH44333 > Bear Town ,MI4 > Dollsville ,CA9 > New York ,NY1 > London , N16 6PS > Paris , 45678 > > The output that I get is this: > > +-+ > | vend_city+', '+vend_state+', '+vend_zip | > +-+ > | 44333 | > | 4 | > | 9 | > |NULL | > | 1 | > |NULL | > +-+ > > According to the text: > > The solution is to concatenate the three columns. In SQL SELECT > statements, you can concatenate columns using a special operator. > Depending on what DBMS you are using, this can be a plus sign > (+) or two > pipes (||). > > Neither seem to work. > > Can anyone point me in the right direction? > > Thanks. > > Gilbert Wilson > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Tutorial Trouble in MySQL
> SELECT vend_city+', '+vend_state+' '+vend_zip > FROM Vendors > ORDER BY vend_name; SELECT CONCAT( vend_city, ', ', vend_state, ' ', vend_zip ) FROM Vendors ORDER BY vend_name > The solution is to concatenate the three columns. In SQL SELECT > statements, you can concatenate columns using a special operator. > Depending on what DBMS you are using, this can be a plus sign (+) or two > pipes (||). The pipes are the concatenation operator in PGSQL, I know. What others they are used in I do not know. I'm not sure what DBMS uses the plus sign. But then, I'm only familair with mySQL and PGSQL. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL Tutorial Trouble in MySQL
Hi all, I am following the lessons in Sams Teach Yourself SQL in 10 Minutes using MySQL as the databse app. I am having some trouble with Lesson 7: Creating Calculated Fields where you are suppose to concatenate several fields. The Input looks like this: SELECT vend_city+', '+vend_state+' '+vend_zip FROM Vendors ORDER BY vend_name; The output should look like this: --- Anytown,OH44333 Bear Town ,MI4 Dollsville ,CA9 New York ,NY1 London , N16 6PS Paris , 45678 The output that I get is this: +-+ | vend_city+', '+vend_state+', '+vend_zip | +-+ | 44333 | | 4 | | 9 | |NULL | | 1 | |NULL | +-+ According to the text: The solution is to concatenate the three columns. In SQL SELECT statements, you can concatenate columns using a special operator. Depending on what DBMS you are using, this can be a plus sign (+) or two pipes (||). Neither seem to work. Can anyone point me in the right direction? Thanks. Gilbert Wilson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1 Beta Release
Hi All, Is there an ETA for MySQL 4.1 Beta release? Thanks, Puny Sen
RE: MySQL License
You might want to talk to a real Mysql sales rep person and request a new license number. You really don't want to be posting info like that on a public forum! Best of luck and Happy Holidays Jacqueline Shaughnessy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Field Count Mismatch Using Code
Not sure if this is a MyODBC error or one in my code. I have code that inserts/updates records based on information from Lotus Notes documents. The columns to be inserted/updated are defined statically in the code so there's no way it's changing from one document to the next. As the code runs, it inserts two or three records then barfs with this error: Field count mismatch, Connector 'odbc2', Method -Insert- at 52 on doc 5417B537EEC7A29486256C2B006A898B I don't see how this could be since it's the same number of columns every single time. Any idea what this error could actually mean? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL on VMS
I am trying to get version 4 up and running on Alpha VMS 7.3-1. I got the process running but every time I try to run admin or mysql against it is say it can not connect to it I get this error ALPHA1::VMS> mysql -u user -p Enter password: ERROR 2005: Unknown MySQL Server Host 'local host' (0) if I enter the local IP address I get this ALPHA1::VMS> mysql -h 192.168.1.110 -u user -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.110' (61) what did I miss on the install ? or something !! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ALTER TABLE .. ORDER BY
Hello, Just a quickie. Does anyone know if issueing an ALTER TABLE t ORDER BY c is as good as an OPTIMIZE TABLE if I know the order I'll mostly be sorting with? Does the ALTER TABLE operation reclaimed deleted rows, for example? Or should I OPTIMIZE and then ALTER? Cheers :) -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Asking again... please help me!!!
You really need to look at your DW installation/user manual/tutorial: how to set up a site within DW and how to configure a db resource. The mySQL part as such seems to work ok, but I doubt there are any db connections defined yet (ODBC or JDBC). If this is new stuff to you take the ODBC route, it's easier especially if you are on Windows. Jan > -Original Message- > From: Lost Idols [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 09, 2003 18:15 > To: [EMAIL PROTECTED] > Subject: Asking again... please help me!!! > > > I did ask this before, but haven't got any help yet. > I'm trying this again... so please let me know if you know. > > Setting up MySQL and PHP on my Mac OS X 10.2 > Just made it work... well, at least I now have a databse > that I created and a table with two things inserted. > I can also see them when I do a SELECT... > > So, since I know it's working, I started my DW MX > to try to work from there, but I just get an error. > I've been setting up the database with all the info > and when I want to select from the list of databases > I just get the following message: > > HTTP Error Code 404 File Not Found. > Here are some possible reasons for the problem: > > 1) There is no testing server running on the server machine. > > What's wrong? Any clues here in this list? > > Staffan > > PS. I'm a newbie, so please write in newbie language ;-) > > _ > Hitta rätt på nätet med MSN Sök http://search.msn.se/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to use row multiple times in xref query?
Environment is MySQL 3.23.33, PHP Version 4.3.2. Have included a couple of extra columns here in an attempt to clarify what I am trying to do. In the table rid is a unique, auto-increment. The fields date_created and date_updated are datetime format mmdd hh:mm:ss. Passing a begining and ending date format of mm- as begdate 06-2003 and endate 11-2003 (those can be 1-24 months and cross a year boundry) into a single table query like ; *Code:* SELECT (date_format(date_created,'%m - %Y')) as RptMonth , SUM(IF(date_created != \"-00-00\", 1,0)) AS NEW , date_format(date_created,'%m - %Y')) as Created , SUM(IF(date_updated != \"-00-00\", 1,0)) AS Upd , date_format(date_updated,'%m - %Y')) as Updated from activity_table where ( (date_format(date_created,'%Y%m') between \"$begdate\" and \"$enddate\") or (date_format(date_updated,'%Y%m') between \"$begdate\" and \"$enddate\") ) group by rid Grouping by rid just to ensure that all rows are returned and to use the SUM function. Injected > and >> manually in the following table to highlight what I am trying to get as results. First result example set is a series of rows (small representative set is shown here). *Code:* Activity For period of Jun/2003 to Nov/2003 RptMonth New Created UpdUpdatedTotal 07 - 2003 1 07 - 2003 0 00 - 1 07 - 2003 1 07 - 2003 0 00 - 2 07 - 2003 1 07 - 2003 0 00 - 3 07 - 2003 1 07 - 2003 0 00 - 4 07 - 2003 1 07 - 2003 0 00 - 5 07 - 2003 1 > 07 - 2003 1 >> 09 - 2003 6 08 - 2003 1 08 - 2003 0 00 - 7 08 - 2003 1 08 - 2003 0 00 - 8 08 - 2003 1 08 - 2003 0 00 - 9 09 - 2003 1 09 - 2003 0 00 - 10 10 - 2003 1 10 - 2003 0 00 - 11 10 - 2003 1 10 - 2003 0 00 - 12 10 - 2003 1 10 - 2003 0 00 - 13 10 - 2003 1 10 - 2003 0 00 - 14 10 - 2003 1 10 - 2003 0 00 - 15 11 - 2003 1 11 - 2003 0 00 - 16 I am certain that a query can return a table that is like my desired output, but I am absolutely stuck on geting the results set. Desired output would be a table that looks like the following, note that the >> wouldn't actually be displayed it is added here, just to show where that row highlighted above would get counted. Also the Total is decremented by that 1. In the actual output I wouldn't even display the Created or Updated date. *Code:* Activity For period of Jun/2003 to Nov/2003 RptMonth New Created UpdUpdatedTotal 07 - 2003 6 > 07 - 2003 0 00 - 6 08 - 2003 3 08 - 2003 0 00 - 9 09 - 2003 1 09 - 2003 1 >> 09 - 200310 10 - 2003 5 10 - 2003 0 00 - 15 11 - 2003 1 11 - 2003 0 00 - 16 I have tripped and ripped and fallen all over myself on this, and think that it is something like - maybe i have to concat and sum by date_xxx and beg-enddate or a lengthy passed array or a mysterious moon phase (gasp): *Code:* SELECT (date_format(date_created,'%m - %Y')) as RptMonth , SUM(IF(date_created != \"-00-00\", 1,0)) AS NEW , date_format(date_created,'%m - %Y')) as Created , SUM(IF(date_updated != \"-00-00\", 1,0)) AS Upd , date_format(date_updated,'%m - %Y')) as Updated from activity_table where ( (date_format(date_created,'%Y%m') between \"$begdate\" and \"$enddate\") or (date_format(date_updated,'%Y%m') between \"$begdate\" and \"$enddate\") ) group by RptMonth Anybody offer any thoughts on this? Welcome all of them, as your idea might just kick my brains cells in another direction. TIA email nospam1001 at nonags dot com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Popper mysql db problem
Michael Sullivan wrote: I'm new to MySQL, so this might be a stupid question/problem, but I can't figure out the answer: I'm trying to install the Popper webmail client on my web server. I'm following the instructions exactly. It told me to log in to the mysql console with "mysql -u root -p" and then "create database popper", which I did. It then said to GRANT insert, update, select, delete, alter, drop, create ON popper.* TO [EMAIL PROTECTED] IDENTIFIED BY 'theuserpassword'; I changed the [EMAIL PROTECTED] to [EMAIL PROTECTED] and the 'theuserpassword' to an appropriate password, but whenever I switch to the mysql user account and mysql -p popper and put the specified password in, it gives me a ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using password: YES) I've even tried mysql [EMAIL PROTECTED] -p and it gives me the same error. What am I doing wrong? the user is mysql, not [EMAIL PROTECTED] locakhost is the host specified with a -h option. mysql -u mysql -h localhost -p -Michael Sullivan- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: foreign key errors
Mayuran Yogarajah wrote: Mayuran Yogarajah wrote: The following is a transaction from MySQL: smysql> show tables; Empty set (0.00 sec) mysql> CREATE TABLE Userlist ( -> UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> Status VARCHAR(1) NOT NULL, -> EmailAddress VARCHAR(64) NOT NULL, -> Password VARCHAR(32) NOT NULL, -> FirstName VARCHAR(64) NOT NULL, -> LastName VARCHAR(64) NOT NULL, -> CompanyName VARCHAR(64) NOT NULL, -> Address1 VARCHAR(128) NOT NULL, -> Address2 VARCHAR(128) DEFAULT '', -> City VARCHAR(128) NOT NULL, -> Zip VARCHAR(10) NOT NULL, -> Country VARCHAR(2) NOT NULL, -> Phone VARCHAR(24) NOT NULL, -> Fax VARCHAR(24) DEFAULT '', -> LastLogin DATE NOT NULL -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.05 sec) mysql> CREATE TABLE Sitelist ( -> UserID MEDIUMINT UNSIGNED NOT NULL, -> SiteID INT UNSIGNED NOT NULL AUTO_INCREMENT, -> Status CHAR(1) NOT NULL, -> Name CHAR(64) NOT NULL, -> URL VARCHAR(255) NOT NULL, -> Description VARCHAR(255) NOT NULL, -> MonthlyUnique INT UNSIGNED NOT NULL DEFAULT 70, -> FrequencyCap MEDIUMINT UNSIGNED NOT NULL, -> INDEX (UserID), -> FOREIGN KEY (UserID) REFERENCES Userlist(UserID) ON UPDATE CASCADE ON DELETE CASCADE, -> PRIMARY KEY (SiteID, UserID) -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.05 sec) mysql> CREATE TABLE Filters ( -> SiteID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> INDEX (SiteID), -> FOREIGN KEY (SiteID) REFERENCES Sitelist(SiteID) ON UPDATE CASCADE ON DELETE CASCADE -> ) TYPE=InnoDB; ERROR 1005 (HY000): Can't create table './test/AdvertiserFilter.frm' (errno: 150) Does anyone know why this is happening? As far as I can tell there is no syntax errors in my table declarations. Any input is much appreciated. Thank you Sorry, that last error should read: ERROR 1005 (HY000): Can't create table './test/Filters.frm' (errno: 150) Thanks. Nevermind, it was conflicting column types :( Sorry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Popper mysql db problem
Michael Sullivan wrote: >I'm new to MySQL, so this might be a stupid question/problem, but I >can't figure out the answer: I'm trying to install the Popper webmail >client on my web server. I'm following the instructions exactly. It >told me to log in to the mysql console with "mysql -u root -p" and then >"create database popper", which I did. It then said to > >GRANT insert, update, select, delete, alter, drop, create ON popper.* > TO [EMAIL PROTECTED] IDENTIFIED BY 'theuserpassword'; > >I changed the [EMAIL PROTECTED] to [EMAIL PROTECTED] and the >'theuserpassword' to an appropriate password, but whenever I switch to >the mysql user account and mysql -p popper and put the specified >password in, it gives me a > >ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using >password: YES) > > >I've even tried mysql [EMAIL PROTECTED] -p and it gives me the same >error. What am I doing wrong? > the user is mysql, not [EMAIL PROTECTED] locakhost is the host specified with a -h option. mysql -u mysql -h localhost -p > >-Michael Sullivan- > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: foreign key errors
Mayuran Yogarajah wrote: The following is a transaction from MySQL: smysql> show tables; Empty set (0.00 sec) mysql> CREATE TABLE Userlist ( -> UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> Status VARCHAR(1) NOT NULL, -> EmailAddress VARCHAR(64) NOT NULL, -> Password VARCHAR(32) NOT NULL, -> FirstName VARCHAR(64) NOT NULL, -> LastName VARCHAR(64) NOT NULL, -> CompanyName VARCHAR(64) NOT NULL, -> Address1 VARCHAR(128) NOT NULL, -> Address2 VARCHAR(128) DEFAULT '', -> City VARCHAR(128) NOT NULL, -> Zip VARCHAR(10) NOT NULL, -> Country VARCHAR(2) NOT NULL, -> Phone VARCHAR(24) NOT NULL, -> Fax VARCHAR(24) DEFAULT '', -> LastLogin DATE NOT NULL -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.05 sec) mysql> CREATE TABLE Sitelist ( -> UserID MEDIUMINT UNSIGNED NOT NULL, -> SiteID INT UNSIGNED NOT NULL AUTO_INCREMENT, -> Status CHAR(1) NOT NULL, -> Name CHAR(64) NOT NULL, -> URL VARCHAR(255) NOT NULL, -> Description VARCHAR(255) NOT NULL, -> MonthlyUnique INT UNSIGNED NOT NULL DEFAULT 70, -> FrequencyCap MEDIUMINT UNSIGNED NOT NULL, -> INDEX (UserID), -> FOREIGN KEY (UserID) REFERENCES Userlist(UserID) ON UPDATE CASCADE ON DELETE CASCADE, -> PRIMARY KEY (SiteID, UserID) -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.05 sec) mysql> CREATE TABLE Filters ( -> SiteID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> INDEX (SiteID), -> FOREIGN KEY (SiteID) REFERENCES Sitelist(SiteID) ON UPDATE CASCADE ON DELETE CASCADE -> ) TYPE=InnoDB; ERROR 1005 (HY000): Can't create table './test/AdvertiserFilter.frm' (errno: 150) Does anyone know why this is happening? As far as I can tell there is no syntax errors in my table declarations. Any input is much appreciated. Thank you Sorry, that last error should read: ERROR 1005 (HY000): Can't create table './test/Filters.frm' (errno: 150) Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
foreign key errors
The following is a transaction from MySQL: smysql> show tables; Empty set (0.00 sec) mysql> CREATE TABLE Userlist ( -> UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> Status VARCHAR(1) NOT NULL, -> EmailAddress VARCHAR(64) NOT NULL, -> Password VARCHAR(32) NOT NULL, -> FirstName VARCHAR(64) NOT NULL, -> LastName VARCHAR(64) NOT NULL, -> CompanyName VARCHAR(64) NOT NULL, -> Address1 VARCHAR(128) NOT NULL, -> Address2 VARCHAR(128) DEFAULT '', -> City VARCHAR(128) NOT NULL, -> Zip VARCHAR(10) NOT NULL, -> Country VARCHAR(2) NOT NULL, -> Phone VARCHAR(24) NOT NULL, -> Fax VARCHAR(24) DEFAULT '', -> LastLogin DATE NOT NULL -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.05 sec) mysql> CREATE TABLE Sitelist ( -> UserID MEDIUMINT UNSIGNED NOT NULL, -> SiteID INT UNSIGNED NOT NULL AUTO_INCREMENT, -> Status CHAR(1) NOT NULL, -> Name CHAR(64) NOT NULL, -> URL VARCHAR(255) NOT NULL, -> Description VARCHAR(255) NOT NULL, -> MonthlyUnique INT UNSIGNED NOT NULL DEFAULT 70, -> FrequencyCap MEDIUMINT UNSIGNED NOT NULL, -> INDEX (UserID), -> FOREIGN KEY (UserID) REFERENCES Userlist(UserID) ON UPDATE CASCADE ON DELETE CASCADE, -> PRIMARY KEY (SiteID, UserID) -> ) TYPE=InnoDB; Query OK, 0 rows affected (0.05 sec) mysql> CREATE TABLE Filters ( -> SiteID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, -> INDEX (SiteID), -> FOREIGN KEY (SiteID) REFERENCES Sitelist(SiteID) ON UPDATE CASCADE ON DELETE CASCADE -> ) TYPE=InnoDB; ERROR 1005 (HY000): Can't create table './test/AdvertiserFilter.frm' (errno: 150) Does anyone know why this is happening? As far as I can tell there is no syntax errors in my table declarations. Any input is much appreciated. Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Error
> If the user "master2" did nto exist or have the required GRANT rights, then I wud not have been able to get into the database itslef in the first place. Thanks again though. Any ideas ? If you read the GRANT section of the mySQL manual (http://www.mysql.com/doc/en/GRANT.html) you'll see that you can grant only use of SELECT, or SELECT and UPDATE, and so forth. Your import may be using an option you don't have the correct GRANT rights for. Please review the manual, check your current GRANT rights for your user, adjust as necessary, and let us know how it goes. Cheers, Joshua Thomas
MySQL 4.0.16 64bit crash report
I'm running 4.0.16 on a dual-Opteron using the 64bit mysql-max binary distribution (tar.gz, not rpm) from mysql.com. I have 8GB of RAM, and it was using about 4.5GB at the time of the crash. 031210 9:24:34 InnoDB: Assertion failure in thread 1171265904 in file row0upd.c line 713 InnoDB: Failing assertion: len == dfield_get_len(dfield) InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] InnoDB: Thread 1183455600 stopped in file ha_innodb.cc line 396 InnoDB: Thread 1176770928 stopped in file ha_innodb.cc line 396 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268435456 read_buffer_size=1044480 max_used_connections=336 max_connections=500 threads_connected=143 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1284140 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. InnoDB: Thread 1174018416 stopped in file ha_innodb.cc line 396 InnoDB: Thread 1214912880 stopped in file ha_innodb.cc line 396 Number of processes running now: 0 Any ideas? Thanks, Don -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Licence question
Good Day All, Let me attempt to provide some clarity on this issues (though it is important to note that I am not a lawyer or a judge.) The fundaments of the GPL are easy to understand. The GPL operates within standard copyright law. Under copyright law[0], the copyright holder has a bundle of rights related to their work. These rights including the right to control the copying, modification and distribution of their work. The holder can keep these right or they can grant others some or all of the rights as well. If they grant others rights to their work, they usually do so under the terms of a license. The GPL is one such license. It gives you the right to copy, modify and distribute the work as long as you follow some conditions. The important conditions for this discussion are: * You must distribute (or at least make available) the source code for the software. * If you form a derivative work with GPL licensed software, then the resulting work should also be GPL licensed. [1] Derivative work is a term from US copyright law (though most copyright laws have some similar concept). A derivative work is a work that is based in whole or in part on another work. There are no fixed rules on determining when a derivative work is formed. In some cases, it is very clear. If I were to modify GCC by changing a few constant names, it would certainly be a derivative work. If I had a program that used a database abstraction layer to allow it to communicate with a broad class of databases, maybe I would not be forming a derivative work with any of the databases. If I used an abstraction layer to specifically avoid creating a derivative work, but my product was intended to only work with one database, then it would be a different situation again. The technical process used (linking methods, abstraction layers, communication layers, ...) cannot be the only determining factor of whether a derivative work is or is not formed. If it were, then it would allow software licenses (both free and non-free) to be easily circumvented. Instead the end intent of the action must be taken into account. A good analogy for this is the case of someone dying due to someone else's actions. Consider the following cases: I drop a heavy potted plant on David. (He has a great comics collection that I covet. ;) I ask Mark to drop a heavy potted plant out the window, but I don't tell him that David will likely be killed by this. Mark falls out of the window because the plant is really heavy. David shoots Marks because he thinks that he is going to drop a potted plant on him. Which of the above is murder? Who is responsible? It really depends on how much is known about each situation. If David shoots Mark, and Mark is the only person who knew that I asked him to drop the plant out the window, then I would seem to be innocent (unless I was recorded urging Mark to drop the pot or I confessed). The context that an event occurs in has a tremendous effect on how it is perceived. My view on this issue are quite simple: If you are willing to pass on the rights that we grant you under the GPL, then please use MySQL under the GPL. If you do not want to pass on these rights then you should purchase a commercial license. In many ways, MySQL behaves like a typical Free Software/Open Source developer. We write software that we place under an open license. We also sell services and software so that we can make money. It just so happens that the same software that we put under an open license is the same software that we sell. [0] Note that different countries have different copyright laws. The exact bundle of rights and how they are protected vary from country to country. [1] A relevant section of the GPL is section 2b: 2. You may modify your copy or copies of the Program or any portion of it, thus forming a work based on the Program, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions: ... b) You must cause any work that you distribute or publish, that in whole or in part contains or is derived from the Program or any part thereof, to be licensed as a whole at no charge to all third parties under the terms of this License. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error
Thanks Josh, I wish that were the case.. I am already inside phpMyAdmin and I can manually edit and add new records. However when I try to add records from a file I keep getting the same error. If the user "master2" did nto exist or have the required GRANT rights, then I wud not have been able to get into the database itslef in the first place. Thanks again though. Any ideas ? Pushpinder On Wednesday, December 10, 2003, at 12:16 PM, Joshua Thomas wrote: 1) Your password for user 'master2' is wrong; 2) master2 doesn't have the proper GRANT rights to do what you want; 3) master2 doesn't exist.
mysql error
Hello mysql, MySQL 4.1.0-alpha-max-nt phpMyAdmin 2.5.4 /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) TYPE=InnoDB CHARSET=cp1251; INSERT INTO `sp_tovar_vid` VALUES (1, 0, 'string 1', ''); INSERT INTO `sp_tovar_vid` VALUES (2, 1, 'string 2', ''); INSERT INTO `sp_tovar_vid` VALUES (3, 2, 'string 3', ''); INSERT INTO `sp_tovar_vid` VALUES (4, 0, 'string 4', ''); INSERT INTO `sp_tovar_vid` (`id`,`id_tovar_vid`,`name`,`description`) VALUES ('','0','',''); UPDATE `sp_tovar_vid` SET `id` = '0' WHERE `id` = LAST_INSERT_ID() LIMIT 1 ; /* END DUMP */ /* BEGIN QUERY */ SELECT t1.`id`, CONCAT(if(t3.`name`='','',CONCAT(t3.`name`,' -> ')),if(t2.`name`='','',CONCAT(t2.`name`,' -> ')),t1.`name`) AS col1, t1.`description` FROM`sp_tovar_vid` AS t1, `sp_tovar_vid` AS t2, `sp_tovar_vid` AS t3 WHERE t1.`id_tovar_vid`=t2.`id` AND t2.`id_tovar_vid`=t3.`id` AND col1>'string' ORDER BY col1; /* END QUERY */ QUESTION: why ERROR caused: #1054 - Unknown column 'col1' in 'where clause' result wanted ++--+-+ | id | col1 | description | ++--+-+ | 1 | string 1 | | | 2 | string 1 -> string 2 | | | 3 | string 1 -> string 2 -> string 3 | | | 4 | string 4 | | ++--+-+ 4 rows in set (0.00 sec) /**/ -- Best regards, Alex mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Error
Several possibilites: 1) Your password for user 'master2' is wrong; 2) master2 doesn't have the proper GRANT rights to do what you want; 3) master2 doesn't exist. Check the mySQL manual. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- > -Original Message- > From: Pushpinder Singh [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 10, 2003 12:14 PM > To: [EMAIL PROTECTED] > Subject: MySQL Error > > > Hello All, > > I am trying to import data from a text file into MySQL. I > am using > phpMyAdmin to control the database. When I try to execute the query I > keep getting this error. " Access denied for user: > '[EMAIL PROTECTED]' > (Using password: YES) " > > Can anyone throw some light on this. > > Thanks in advance > Pushpinder Singh > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] >
MySQL Error
Hello All, I am trying to import data from a text file into MySQL. I am using phpMyAdmin to control the database. When I try to execute the query I keep getting this error. " Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) " Can anyone throw some light on this. Thanks in advance Pushpinder Singh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL Statement Help - Is this possible?
I have a database table that has one row entered every day by the user. If the user skips a day, it throws off our monthly totals. Assume a table with four columns: id (which is the key), date (-mm-dd), data1 (int), data2 (int) Is there a way to say "Select the first missing date in the last 30 days from this table"? I know I can select all the rows, ordered by date, and loop through them with PHP to look for first one that's missing. But that seems inefficient. And I know that once in place, in theory there should never be any more missing dates if I just grab the max date and add one. But I don't want to do that. I want the page to be SURE there are no missing dates in the last 30 days. Thanks, Mark As of November 1st, 2003, Brandywine Senior Care's Corporate Office new contact information is: Brandywine Senior Care, Inc. 525 Fellowship Road Suite 360 Mt. Laurel, NJ 08054 (856) 813-2000 Phone (856) 813-2020 Fax ** This e-mail and any of its attachments may contain Brandywine Senior Care, Inc. proprietary information, which is privileged, confidential, or subject to copyright belonging to Brandywine Senior Care, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. Thank You. **
Re: Difficulty with SELECT
Carsten Heidmann wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm having trouble composing the right SQL statement for my purpose: I am building a search interface to a database with research projects. The research projects (tbl_projects) have assigned keywords in german and english, which are in a seperate table (tbl_keywords). Because I want to build a thesaurus from the keywords further on, I try to keep the number of keywords as small as possible and assign the keywords to the projects via a third table (tbl_keywords_projects). When querying the database, I want to receive resultset which contains projects which have all of the entered keywords assigned. I started with: SELECT `tbl_projects`.`project_id`, FROM `tbl_projects`, `tbl_keywords_projects`, `tbl_keywords` WHERE `tbl_projects`.`project_id` = `tbl_keywords_projects`.`project_fid` AND `tbl_keywords_projects`.`keyword_fid` = `tbl_keywords`.`keyword_id` AND ( `tbl_keywords`.`keyword_de` IN ('keyword_1', 'keyword_2') OR `tbl_keywords`.`keyword_en` IN ('keyword_1', 'keyword_2') ) GROUP BY `tbl_projects`.`project_id` but this returns all the datasets which contain at least one of the keywords. I am looking for a SELECT statement which returns only the datasets which contain all of the entered keywords. Since I am not very familiar with complex SQL statements, I tried some other expressions which always returned an empty result set. I hope that this question is not _too_ stupid so that someone will have an answer for me, Carsten You are very close. Try SELECT tbl_projects.project_id AS id FROM tbl_projects, tbl_keywords_projects, tbl_keywords WHERE tbl_projects.project_id = tbl_keywords_projects.project_fid AND tbl_keywords_projects.keyword_fid = tbl_keywords.keyword_id AND (tbl_keywords.keyword_de IN (List_of_keywords) OR tbl_keywords.keyword_en IN (List_of_keywords)) GROUP BY tbl_projects.project_id HAVING COUNT(*) = Number_of_keywords Replace "List_of_keywords" and "Number_of_keywords" with appropriate values (For example, 'keyword_1', 'keyword_2' and 2). Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[RE-REPOST] Openssl support not activated?
I'm still having trouble figuring this out. Please help! I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the variables with mysqladmin, "has_openssl" is set to "NO". I've got OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian hosts. I'm not seeing any errors during the configure or compile phases. What could have happened to cause this, and how can I fix it? Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: sending array data using php mail
From: Abs [mailto:[EMAIL PROTECTED] > hi > the error is in this line: > $newvalue = $row["Password"]; > make it > $newvalue.= $row["Password"]; > (notice ^ the dot - for concatenation with the > previous value). > > and if u want to see each password in the browser too, > in that same loop, put: > echo "{$row["Password"]\n"; > > so it would now look like: > while ( $row = mysql_fetch_array($rows1) ) { > >$newvalue.=$row["Password"]; >echo "{$row["Password"]\n"; > } > > u may also want to use a in ur echo line to make > the browser output nicer, the \n affects only the html > code. and while u're at it, put a \n in $newline so > that ur email looks nicer. For the record, there's a syntax error in there -- the closing curly brace is missing. echo "{$row["Password"]}\n"; ^ Also, I've never tried this syntax with double-quotes. Do the curly braces keep the PHP parser from thinking that the opening " for Password is a close of the string? I use single quotes in that kind of situation, FWIW. -- Mike Johnson Web Developer/Systems Asst. Smarter Living, Inc. phone (617) 497-2500 x226 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: sending array data using php mail
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Hi, can anyone tell me what is the problem of my script: > > $sql2 = "SELECT * FROM Cash WHERE HP='$HP' and > SignUpDate='$SignUpDate'"; >$rows1 = mysql_query($sql2,$linkptr1) ; > > >$OwnnerMail ="[EMAIL PROTECTED]"; >$Subject = "Testing"; > >while ( $row = mysql_fetch_array($rows1) ) { > >$newvalue = $row["Password"]; >echo "$newvalue\n"; > > > } >$Body = $newvalue; >$From = "$HP"; >mail( $OwnnerMail,$Subject, $Body, "From: $From"); > > I can see all the data for $newvalue in browser. But, when i > receive email, i can only see the last data. > > can i know what is the problem? thank you. Your script is doing exactly what you told it to. After the while() loop, $newvalue is set to the last member of $row["Password"]. Try something like this... $sql2 = "SELECT * FROM Cash WHERE HP='$HP' and SignUpDate='$SignUpDate'"; $rows1 = mysql_query($sql2,$linkptr1); $OwnnerMail ="[EMAIL PROTECTED]"; $Subject = "Testing"; $Body = ""; while ( $row = mysql_fetch_array($rows1) ) { $newvalue = $row["Password"]; echo "$newvalue\n"; $Body .= "$newvalue\n"; } $From = "$HP"; mail( $OwnnerMail,$Subject, $Body, "From: $From"); See how $Body is initialized before the while() loop, and then appended to using .= inside the loop? Once the loop completes, $Body contains all values of $row["Password"], not just the last one. -- Mike Johnson Web Developer/Systems Asst. Smarter Living, Inc. phone (617) 497-2500 x226 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Popper mysql db problem
Michael Sullivan <[EMAIL PROTECTED]> wrote: > I'm new to MySQL, so this might be a stupid question/problem, but I > can't figure out the answer: I'm trying to install the Popper webmail > client on my web server. I'm following the instructions exactly. It > told me to log in to the mysql console with "mysql -u root -p" and then > "create database popper", which I did. It then said to > > GRANT insert, update, select, delete, alter, drop, create ON popper.* > TO [EMAIL PROTECTED] IDENTIFIED BY 'theuserpassword'; > > I changed the [EMAIL PROTECTED] to [EMAIL PROTECTED] and the > 'theuserpassword' to an appropriate password, but whenever I switch to > the mysql user account and mysql -p popper and put the specified > password in, it gives me a > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using > password: YES) > > > I've even tried mysql [EMAIL PROTECTED] -p and it gives me the same > error. What am I doing wrong? You should specify only user name (without host name) in the --user option: shell> mysql -u mysql -pmysql_password or shell> mysql -u mysql -h localhost -pmysql_password -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: limatation on user name in mysql - 16 characters: SOLVED
For everyone - I modify these files: include/mysql_com.h:#define USERNAME_LENGTH 16 tools/mysqlmanager.c:#define MAX_USER_NAME 16 mysql-test/install_test_db.sh: c_d="$c_d User char(16) DEFAULT '' NOT NULL," mysql-test/install_test_db.sh: c_u="$c_u User char(16) binary DEFAULT '' NOT NULL," mysql-test/install_test_db.sh: c_t="$c_t User char(16) DEFAULT '' NOT NULL," mysql-test/install_test_db.sh: c_c="$c_c User char(16) DEFAULT '' NOT NULL," scripts/mysql_fix_privilege_tables.sh: User char(16) DEFAULT '' NOT NULL, scripts/mysql_fix_privilege_tables.sh: User char(16) DEFAULT '' NOT NULL, scripts/mysql_install_db.sh: c_d="$c_d User char(16) binary DEFAULT '' NOT NULL," scripts/mysql_install_db.sh: c_u="$c_u User char(16) binary DEFAULT '' NOT NULL," scripts/mysql_install_db.sh: c_t="$c_t User char(16) binary DEFAULT '' NOT NULL," scripts/mysql_install_db.sh: c_c="$c_c User char(16) binary DEFAULT '' NOT NULL," Compile & install & install db & test - it works fine :-) Mysql version 4.0.15a. OldFrog. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication/InnoDB errors
Greetings, > > Didn't find any fields in table 'blah' > 031208 18:15:16 InnoDB error: > Cannot find table db/blah from the internal data dictionary > of InnoDB though the .frm file for the table exists. Maybe you > have deleted and recreated InnoDB data files but have forgotten > to delete the corresponding .frm files of InnoDB tables, or you > have moved .frm files to another database? > Look from section 15.1 of http://www.innodb.com/ibman.html > how you can resolve the problem. I found out what was causing this, for me at least. When I tar-ed the db's to copy to the new slave server, I did not include the file 'ibdata1' in the tarball. I scp-ed it over and bingo! Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.1 create table : why negatives values need quotation marks?
Christophe DIARRA <[EMAIL PROTECTED]> wrote: > > First, sorry, if my problem is know or documented. I have made a rapid > search on the MySQL site, but without success. > > Here is my problem : the following 'create table' command refuses to > execute on 4.1.1, if -1 is not put between a quottation mark: > > create table testTable (name varchar(10), age smallint default -1); > > If the value -1 is changed into '-1', the command works. Is this the > correct behaviour in 4.1.1 ? > > An application here (written by a colleague) was using numbers > without quotation marks as default values in the create command. The > application worked untill today. Before he updates the code, I would like > to have more precisions. > > Following is the output of the create commande with a 4.1.1 and a 4.0.3 > MySQL server. > > mysql> select version(); > +--+ > | version()| > +--+ > | 4.1.1-alpha-standard | > +--+ > 1 row in set (0.00 sec) > > mysql> create table testTable (name varchar(10), age smallint default -1); > ERROR 1064 (42000): You have an error in your SQL syntax. Check the > manual that corresponds to your MySQL server version for the right syntax > to use near '-1)' at line 1 > > mysql> select version(); > ++ > | version() | > ++ > | 4.0.3-beta-max | > ++ > mysql> create table testTable (name varchar(10), age smallint default -1); > Query OK, 0 rows affected (0.01 sec) > > Does somebody have the same problem ? Any idea ? > Thank you for bug report! It was entered to the bug database: http://bugs.mysql.com/bug.php?id=2075 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Difficulty with SELECT
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm having trouble composing the right SQL statement for my purpose: I am building a search interface to a database with research projects. The research projects (tbl_projects) have assigned keywords in german and english, which are in a seperate table (tbl_keywords). Because I want to build a thesaurus from the keywords further on, I try to keep the number of keywords as small as possible and assign the keywords to the projects via a third table (tbl_keywords_projects). When querying the database, I want to receive resultset which contains projects which have all of the entered keywords assigned. I started with: SELECT `tbl_projects`.`project_id`, FROM `tbl_projects`, `tbl_keywords_projects`, `tbl_keywords` WHERE `tbl_projects`.`project_id` = `tbl_keywords_projects`.`project_fid` AND `tbl_keywords_projects`.`keyword_fid` = `tbl_keywords`.`keyword_id` AND ( `tbl_keywords`.`keyword_de` IN ('keyword_1', 'keyword_2') OR `tbl_keywords`.`keyword_en` IN ('keyword_1', 'keyword_2') ) GROUP BY `tbl_projects`.`project_id` but this returns all the datasets which contain at least one of the keywords. I am looking for a SELECT statement which returns only the datasets which contain all of the entered keywords. Since I am not very familiar with complex SQL statements, I tried some other expressions which always returned an empty result set. I hope that this question is not _too_ stupid so that someone will have an answer for me, Carsten -BEGIN PGP SIGNATURE- Version: 6.5.8ckt iQA/AwUBP9cfv7jxzYr/SJ6uEQLdpACfUhB9ON/F8sv0bFqEkVIJXcEyvfEAnjJ4 RRCqfhgx38hfAtqF50fWASm9 =m7D3 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL License
Len, You shouldn't post private information to a public mailing list (never do that!). Please send these type of questions to [EMAIL PROTECTED] But my guess is you should download and install it if you have not already done so. Ken - Original Message - From: "Len Buchanan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 09, 2003 2:25 PM Subject: Re: MySQL License > Hi, > > I recently purchased a licence. I received this email. Do I download the > binaries myself or are you sending me a box? If I download it myself, do I > need to create an account? If I have one, I've long forgotten it. > > Regards, > > Len Buchanan > Datascape Technologies Inc. > > At 06:07 PM 12/5/2003 +0100, you wrote: > >Dear Customer: > > > >Included is your MySQL Classic License, ordered from MySQL AB. > >License number(s): 299376. > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: copy from table to it again
I think, there is an error in your syntax. (i am not sure) After FROM, what do you want to call as a2 ?? INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct` , 3 FROM `answer` where a2.qid=0 Vaso -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 3:14 PM To: [EMAIL PROTECTED] Subject: copy from table to it again i want to ask you a question i have a data in a table `answer` and i want to copy the data which have a specific value in a filed and inserted into it again but i will change the value i try to use this but it's give me an error === INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct` , 3 FROM `answer` as a2 where a2.qid=0 === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
copy from table to it again
i want to ask you a question i have a data in a table `answer` and i want to copy the data which have a specific value in a filed and inserted into it again but i will change the value i try to use this but it's give me an error === INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct` , 3 FROM `answer` as a2 where a2.qid=0 ===
Re: MySQL 4.1.1 Internationalization (ENUM)
Hi! > > > > create table t(a enum ('','ÐÐÐ','ÐÑÐ')); > > > > show create table t; > > > > CREATE TABLE `t` ( > > > > `a` enum('','???','???') default NULL > > > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251 > > firstly, upgrade you mysql to current stable version (4.0.16). I need 4.1, not 4.0 8) > and imho you need cp1251_ukrainian_ci to use ukrainian characters properly. And 4 ukrainian characters are not so impotant... I use cp1251_general_ci. WBR. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Production problem porting from PHP to ASP
hello, what about using: aspx (with c#) - c++ api - mysql (nt) - with win 2003 server (iis 6.0) the only thing where i'm no sure is the c++ api. can it be used with c# or will there be a .net framework version of the api? if this set up is possible i suspect that it may at least match php-... regards, tk --- Terence <[EMAIL PROTECTED]> wrote: > We just developed and re-wrote applications on PHP > from a previous ASP > environment. > The performance improvement from ASP-ODBC-MySQL to > PHP-MYSQL ranged > from 20-50% in some cases, so it's pretty normal to > expect a much slower > response. > > Also sorry to hear about the decision. > > Terence __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.1 Internationalization (ENUM)
On Wed, 10 Dec 2003 15:25:57 +0200 "Juri Shimon" <[EMAIL PROTECTED]> wrote: > Hi! > > > > > > create table t(a enum ('','__','__')); > > > show create table t; > > > CREATE TABLE `t` ( > > > `a` enum('','???','???') default NULL > > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251 firstly, upgrade you mysql to current stable version (4.0.16). and imho you need cp1251_ukrainian_ci to use ukrainian characters properly. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 do you mean ? Is it used to optimize searches ? No. Still there could be some speedup because, e.g, MyISAM will use binary search in the key pages instead of linear one, etc. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Remote connection: "Lost connection to MySQL server during query"
Hi all! I'm connecting from one server (192.168.0.2; 4.1.1-alpha-log) to another server (192.168.0.1; 4.1.0-alpha-log) like this: # mysql -h192.168.0.1 -uusername -ppassword But all I get is: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 82 to server version: 4.1.0-alpha-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select unix_timestamp(); ERROR 2013 (HY000): Lost connection to MySQL server during query This error occurs on EVERY query, no matter how simple: i.e. show databases; When I run the "mysql" command locally on the server I'd like to connect to, everythings fine. MySQL seems to be able to connect to the other machine and the query is started, but the error says it failed "during query"... Thanks a lot for any hints! Cheers, Hannes. --- Alles Kaufen und Verkaufen! eBay.at - der eigene Marktplatz für Österreich. http://www.austronaut.at/ebay.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.1 Internationalization (ENUM)
Hi! > > > create table t(a enum ('','ÃÃÃ','ÃÃÃ')); > > show create table t; > > CREATE TABLE `t` ( > > `a` enum('','???','???') default NULL > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251 > > But a bug in what? > CREATE TABLE `t` ( > `a` enum('','ÃÃÃ','ÃÃÃ') default NULL > ) TYPE=MyISAM > > Which sounds fine to me (except the charset thingy, I'm running 4.0). > > Perhaps it's a bug in your client tool? > my client tool is "mysql -u root < sql.file.in.cp1251" (migration from 3.23.58) and only enum chars are broken 8( WBR! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.1 Internationalization (ENUM)
Hi, > create table t(a enum ('','ÃÃÃ','ÃÃÃ')); > show create table t; > > CREATE TABLE `t` ( > `a` enum('','???','???') default NULL > ) TYPE=MyISAM DEFAULT CHARSET=cp1251 > > and this is a bug! But a bug in what? I've created the table with Database Workbench, and when doing a SHOW CREATE TABLE t; It displays: CREATE TABLE `t` ( `a` enum('','ÃÃÃ','ÃÃÃ') default NULL ) TYPE=MyISAM Which sounds fine to me (except the charset thingy, I'm running 4.0). Perhaps it's a bug in your client tool? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
BUGS: MySQL 4.1.1 Internationalization (ENUM)
Hi! create table t(a enum ('','ÃÃÃ','ÃÃÃ')); show create table t; CREATE TABLE `t` ( `a` enum('','???','???') default NULL ) TYPE=MyISAM DEFAULT CHARSET=cp1251 and this is a bug! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.1 and internationalization
Hi! How I can set server variable "character_set_system" to cp1251 ? I can use xxx'char' construction - but I need a downward compatibility. I can select USER() and parse result on clientside - but I wan't rewrite existing client apps. > mysql -u root -e "select substring_index(USER(),'@',1)" ERROR 1266 at line 1: Illegal mix of collations (utf8_general_ci,IMPLICIT) and ( cp1251_general_ci,COERCIBLE) for operation 'substr_index' > mysql -u root -e "show variables like '%character_set%'" +--+--+ | Variable_name| Value| +--+--+ | character_set_server | cp1251 | | character_set_system | utf8 | | character_set_database | cp1251 | | character_set_client | cp1251 | | character_set_connection | cp1251 | | character_set_results| cp1251 | +--+--+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: view warnings?
Bryan Harris <[EMAIL PROTECTED]> wrote: >>> I'm pretty new to MySQL, but I already like it. Kudos to the developers! >>> >>> I recently did a mysqlimport on a few data files, and it came back with over >>> 4000 warnings. How can I actually see what the warnings were? I'm still >>> not sure what it was upset about... >> >> You can't. >> From 4.1.1 you can see warning if you use LOAD DATA INFILE statement: >> http://www.mysql.com/doc/en/SHOW_WARNINGS.html > > I used mysqlimport because I could import a bunch of files all at once. > Does LOAD DATA have this capability? No. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Bug in 4.1.1 Internationalization on Windows2000 ?
- Original Message - From: "Juri Shimon" <[EMAIL PROTECTED]> To: "Victoria Reznichenko" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 12:56 PM Subject: Re: Bug in 4.1.1 Internationalization on Windows2000 ? > Hi! > > > > > What does 'SHOW CREATE DATABASE database_name;' show for this database? > > > > I've found it... > > 1. F:\Projects\has\sql>mysql -u root -e "create database t; show create > database t; drop database t" > +--+--+ > | Database | Create Database | > +--+--+ > | t| CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET cp1251 */ | > +--+--+ > > 2. F:\Projects\has\sql>mysql -u root -e "use_mysql; create database t; show > create database t; drop database t" > +--+--+ > | Database | Create Database | > +--+--+ > | t| CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET latin1 */ | > +--+--+ > > Where > F:\Projects\has\sql>mysql -u root -e "show create database mysql" > +--+ > --+ > | Database | Create Database > | > +--+ > --+ > | mysql| CREATE DATABASE `mysql` /*!40100 DEFAULT CHARACTER SET latin1 > */ | > +--+ > --+ > > Seems, there is dependence on current database charset and, IMHO, it's a > bug. > > > PS. > Why in libmySQL.dll of 4.1.1 entry for "mysql_connect" (and maybe other) is > absent? I can't use my middleware libraries 8((( > (I'm migrating from 3.23.55) > > WBR! Bye! > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL -- Sequences -- Do they exist
Hello noel. Wednesday, December 10, 2003, 5:09:30 PM, you wrote: nkmdi> If not is there anyway to automatically generate primary keys for nkmdi> tables in MySQL. CREATE TABLE ttt ( id int not null auto_increment primary key, name varchar(100) not null ); Please note "auto_increment" token in the example above. It tells MySQL that id is an auto-incrementing primary key for the table. So, to insert a row you'd just issue the following query: INSERT INTO ttt (name) VALUES ('some name here'); INSERT INTO ttt (name) VALUES ('another name here'); or INSERT INTO ttt (id, name) VALUES (NULL, 'some name here'); INSERT INTO ttt (id, name) VALUES (NULL 'another name here'); Anyway, you'll get the following two records after that: 1, 'some name here' 2, 'another name here' I hope that helps. -- See you, Andrey. [ [EMAIL PROTECTED] | ICQ# 114087545 | 2:5090/[EMAIL PROTECTED] ] ...Perfect guest: One who makes his host feel at home. pgp0.pgp Description: PGP signature
Re: MySQL -- Sequences -- Do they exist
[EMAIL PROTECTED] wrote: > > I am looking to create a sequence to use as a primary key for a table, I > have read about them on the mysql website but can?t seem to get them work= > ing. > Do they exist for version 4.1 and if so could someone give me some sampl= > e > code. If not is there anyway to automatically generate primary keys for > tables in MySQL. You can specify column as AUTO_INCREMENT: http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with mysqlimport
> --local is a valid option for mysqlimport in 3.23.49 according to the > manual. (Source: http://www.cict.fr/app/mysql/manual.html#mysqlimport) > What is the entire command you are using? Hi, My command is: mysqlimport -p -L ilk gwarancje.txt And I get error: "mysqlimport: Error: The used command is not allowed with this MySQL version, when using table: gwarancje" I used this command by Linux shell (logged as root). Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL -- Sequences -- Do they exist
Hi Noel, > I am looking to create a sequence to use as a primary key for a table, I > have read about them on the mysql website but can?t seem to get them working. > Do they exist for version 4.1 and if so could someone give me some sample > code. If not is there anyway to automatically generate primary keys for > tables in MySQL. Well, not "Sequence" objects like with Oracle or InterBase. You can create an auto-increment column, that increases with each new row. Check http://www.mysql.com/doc/en/CREATE_TABLE.html With regards, Martijn Tonies Database Workbench - developer tool for MySQL, InterBase, Firebird & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL -- Sequences -- Do they exist
Hello I am looking to create a sequence to use as a primary key for a table, I have read about them on the mysql website but can?t seem to get them working. Do they exist for version 4.1 and if so could someone give me some sample code. If not is there anyway to automatically generate primary keys for tables in MySQL. Thanks Noel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bug in 4.1.1 Internationalization on Windows2000 ?
"Juri Shimon" <[EMAIL PROTECTED]> wrote: > Hi! Is this a bug? What does 'SHOW CREATE DATABASE database_name;' show for this database? > > in my.cnf: > > [mysqld-4.1] > skip-locking > default-character-set=cp1251 > default_collation=cp1251_general_ci > key_buffer=16M > skip-innodb > skip-bdb > > > after server start: > >> show variables like '%character_set%' >character_set_servercp1251 >character_set_systemutf8 >character_set_databaselatin1 <--- MUST BE > cp1251 !!! >character_set_clientcp1251 >character_set_connectioncp1251 >character_set_resultscp1251 > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Embedded 4.1.1 - Linux
Hi, Is there any site with list of libs I need to link with libmysqld (linux)? I am currently using libmysqlclient and thisone needs libpthreads and libz to work fine. If I replace libmysqlclient with libmysqld, there is lot of symbols linker cannot find. Thanks, Mirza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INSERT INTO FROM same table failing
Ramesh <[EMAIL PROTECTED]> wrote: > > In mysql 4.014, the below INSERT statement works fine: > INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10 > > But in mysql 4.1, it fails, I get a message: > Error Code : 1066 > Not unique table/alias: 'TEST_TABLE' > (10 ms taken) > > Question: Is this a problem with 4.1 or is it supposed to fail? 4.1.0 was released before 4.0.14. Upgrade MySQL server to 4.1.1. > > Table is: > CREATE TABLE TEST_TABLE (id mediumint(9) NOT NULL, name varchar(255)) > TYPE = InnoDB > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: running mysql 3.23 and mysql 4.0 on same linux/suse box
Anyone has an idea about this issue? Thanks in advance!!! Regards, Stefan Stefan Egli wrote: Hi there, I'm having problems running two versions of mysql simultaneously on the same box. The versions I'm using are: * mysql 3.23.48 * mysql 4.0.16 What happens: * I have the 3.23 version up and running (can see that it has 5 processes running with ps, and 'bin/mysqladmin status' shows that it's nicely running locally * When I start up the 4.0.16 version it seems to bring down the 3.23 version... First, the 4.0.16 version itself starts up with error messages and the 3.23 can no longer be queried ('bin/mysqladmin status' says it cannot connect). The error message from the 4.0.16 startup is: 'Can't start server : Bind on unix socket: Permission denied' What I did with the 4.0.16 is to have it run on a different socket & file. Anyone can help me out on this? What could go wrong when you have two versions running? Am I running with wrong user? But then, why does the start of 4.0.16 somehow crash the 3.23 version (the processes of the 3.23 version are then still there but not reachable. Killing the child processes of the mysql daemon brings 3.23 up and running again)? Thanks for any help! cheers, -se -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Production problem porting from PHP to ASP
We just developed and re-wrote applications on PHP from a previous ASP environment. The performance improvement from ASP-ODBC-MySQL to PHP-MYSQL ranged from 20-50% in some cases, so it's pretty normal to expect a much slower response. Also sorry to hear about the decision. Terence - Original Message - From: "David Potter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 6:04 AM Subject: Production problem porting from PHP to ASP Dear Members, For the last two years we have had a large software application written in PHP 4.0.6 with a MySQL 3.23.56 database all running on a single box with RedHat Linux 9.0. This has worked fantasticly and it is very fast. For certain business reasons that I wont go into detail here, we had to rewrite all the code from PHP to Microsoft ASP. The box that contained the MySQL database on Linux remained as is. A second box was purchased and runs the ASP code on Windows 2000 Server. The existing database on the Linux box is called by an ODBC connection on the Windows machine. The problem is that now the software runs terribly slower. The reason could not be that anything is wrong with the MySQL database since the database on the Linux box was absolutely unchanged. I suspect that the culprit is that PHP connects through a native MySQL driver, while in our new way ASP connects through ODBC. Does anyone have any ideas about this ? David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bug in 4.1.1 Internationalization on Windows2000 ?
Hi! Is this a bug? in my.cnf: [mysqld-4.1] skip-locking default-character-set=cp1251 default_collation=cp1251_general_ci key_buffer=16M skip-innodb skip-bdb after server start: > show variables like '%character_set%' character_set_servercp1251 character_set_systemutf8 character_set_databaselatin1 <--- MUST BE cp1251 !!! character_set_clientcp1251 character_set_connectioncp1251 character_set_resultscp1251 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange Timestamp behaivor
"Matthew Boulter" <[EMAIL PROTECTED]> wrote: > > I have just started noticing some bizarre behaivor in tables in our = > database that contain a=20 > TIMESTAMP(14) field.=20 > > I only shown a small query, but it highlights the error: > > mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime =3D = > 20031210063712; > ++ > | ErrorTime | > ++ > | 20031211063712 | > ++ > 1 row in set (0.51 sec) > > mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime =3D = > 20031211063712; > Empty set (0.54 sec) > > > Why am I getting back 11-Dec dates when I requested the 10th? > Here's the table defn: > > CREATE TABLE `ErrorLog` ( > `ID` int(11) NOT NULL auto_increment, > `Code` varchar(5) default NULL, > `Severity` varchar(15) default NULL, > `Text` text, > `ErrorTime` timestamp(14) NOT NULL, > `Component` varchar(50) default NULL, > `Object` varchar(255) default NULL, > `Hostname` varchar(255) default NULL, > PRIMARY KEY (`ID`) > ) TYPE=3DMyISAM MAX_ROWS=3D4294967295 AVG_ROW_LENGTH=3D120 > Check if the table is Ok with CHECK TABLE statement or with myisamchk. If so, create repeatable test case, I wasn't able to repeat the above behaviour with my test data. What version of MySQL do you use and which OS? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.1 with cp1251
Hi! > Latin1 is the default as i know. > Let's check: > 2.3.3 Typical configure Options > 4.7 MySQL Localisation and International Usage I know this. BUT, when I set def char set = cp1251 and do CREATE DATABASE lalala I get new database created in latin1 Is this a bug? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Strange Timestamp behaivor
I have just started noticing some bizarre behaivor in tables in our database that contain a TIMESTAMP(14) field. I only shown a small query, but it highlights the error: mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime = 20031210063712; ++ | ErrorTime | ++ | 20031211063712 | ++ 1 row in set (0.51 sec) mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime = 20031211063712; Empty set (0.54 sec) Why am I getting back 11-Dec dates when I requested the 10th? Here's the table defn: CREATE TABLE `ErrorLog` ( `ID` int(11) NOT NULL auto_increment, `Code` varchar(5) default NULL, `Severity` varchar(15) default NULL, `Text` text, `ErrorTime` timestamp(14) NOT NULL, `Component` varchar(50) default NULL, `Object` varchar(255) default NULL, `Hostname` varchar(255) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM MAX_ROWS=4294967295 AVG_ROW_LENGTH=120 Thanx in advance for any help, Regards, Matthew. Matthew M. Boulter Software Engineer Saab ITS Pty Ltd Mobile: +61 (0)415 169 088 Phone: +61 (0)7 3854-4815 Fax:+61 (0)7 3854-4899 Email: [EMAIL PROTECTED] WWW:www.saab-its.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]