AW: Client library

Hi Daniel, just download the latest mySQL distribution including everything you need! Regards Andy -Ursprngliche Nachricht- Von: Daniel Kiss [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 15. November 2003 21:52 An: [EMAIL PROTECTED] Betreff: Client library Hi all, I have

Creating statistics

Hello, I have table with messages, and i have users table, the are linked via PK UserID - UserID, what i need is to select Messages for current month and calculate top 5 posters list for current month. I have create following query but it's not complete: SELECT Handle, Screen_Name from MBoard

Problem about the maximum isze of MYISAM table

Hi, I've found the problem about the maximum size of MYISAM table. The error occured while I'm trying to insert data into the table by using LOAD DATA command. I got an error message like this: ERROR 1114 at line 1 in file: 'table.list': The table 'table.list' is full The maximum

forbidden syntax search

Hi, I need a little help on my SQL syntax. I want to store forbidden inputs from the GUI in a table and query it on input from the user; simple layout: CREATE TABLE `forbidden_input` (`lfdnr` TINYINT (3) UNSIGNED DEFAULT '0' AUTO_INCREMENT, `input` VARCHAR (255) NOT NULL, PRIMARY KEY(`lfdnr`),

Next release of 4.1x , any release plans

Hello Since it quite buggy using 4.1 in combination with subselect it could be nice to know next planned release of 4.1.x regards Kim G. Pedersen macaos/elprint Development -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Analytic database?

One column per MyISAM table, I think you mean: each column in a MyISAM table would also be a column in Sybase IQ. The disk requirements in IQ would be different since IQ uses a compression technique. Since storage is column-based the compression can be done more efficiently. I work primarily at

RE: Backslash and full text searches

Hi there, I had a similar problem wanting to match 'words' like 42.3.1.1 as technical references. I couldn't get them to match using a fulltext index, I assume because the full stops are used by the parser in MySql to break the text into words for indexing - maybe this is the same for the

Re: Creating statistics

Try something like this: select Screen_Name,count(*) from MBoard where Message_Date='2003-11-00' group by Screen_Name order by 2 desc limit 5; Peter Sap - Original Message - From: Daniel Harik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:28 PM Subject:

Re: secure automated access (was Re: Backing up all databases)

Mysterious. I assume `mysql -p` prompts you for root's password and works as expected, since without -p it says you're not using a password, rather than saying there's something wrong with the password. Yes, that works. When you tried the defaults-file option, did you use the full path?

Re: SQL: forbidden syntax search

On Sun, Nov 16, 2003 at 03:31:18AM +0100, M. Bader wrote: Hi, I need a little help on my SQL syntax. I want to store forbidden inputs from the GUI in a table and query it on input from the user; This doesn't answer your question specifically, but rather, describes a separate solution...

ORDER BY DESC order different when using LIMIT

Description: When using ORDER BY column DESC the lines are shown in one order but when I use LIMIT 0,1 the second line insted of the first line are shown. And when I use LIMIT 2,1 the same line as if use LIMIT 3,1 are shown. The table has 4 rows. How-To-Repeat: mysql SELECT

Re: MYSQLD Dump - Locks Database

As far as I know no locking will be done, unless you use the --lock-tables flag: the tables in a database are locked before the dump starts. When using InnoDb, use the flag --single-transaction to get a consistent snapshot of your database. Peter Sap - Original Message - From: Paul Fine

Re: Problem about the maximum isze of MYISAM table

You could try to use MERGE tables to get around this problem. Put all your data in several MyISAM tables and create a merge table on top of them. Peter Sap. - Original Message - From: Niran Angkawattanawit [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday,

Re: rollback error

You start a transaction but you insert into a non-transactional table (probably MyISAM). Change your table type into InnoDB or DBD and it will work. Peter Sap - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 14, 2003 4:54 PM

Bug? mysql replication mysql 4.0.16..

Hi.. Replication does not happend if inserts (update not tested) is made without mysql_select_db(database, $connection); (yes, I use php..). Working: mysql_select_db(database, $connection); mysql_query(INSERT INTO table (text1, text2) VALUES ('bah', 'bah')); Not working (data only apreas in

Re: Problem about the maximum isze of MYISAM table

MyISAM tables can be larger than 4Gb without using merge tables. This topic has been discussed several times on this list. You will find all details in Google groups archive: http://groups.google.com/groups?q=myisam+4Gb+limit+group:mailing.database.mysqlscoring=d Hope this helps, Joseph Bueno

Re: Problem about the maximum isze of MYISAM table

Hi Niran, See here: http://www.mysql.com/doc/en/Full_table.html By default, with dynamic row length tables, MySQL only uses data pointers large enough to address 4GB of data file. To have a data file 4GB, you need to specify MAX_ROWS and AVG_ROW_LENGTH in CREATE/ALTER TABLE (assuming your file

Re: ORDER BY DESC order different when using LIMIT

Hi I am not sure how this limit works , but in oracle if you use a rownum100 (guess it is some of the same), the sorting are done After the limitation so... if u say rownum100 , it gives u 100 lines abitrary order and then it sorts that 100 lines HTH Kim G. Pedersen Description: When using

Optimizing regular expression query

Hi. I'm working on a query I would like to sort a certain way. If the search term matches the start of any word in the title of a book, I want this result first. If there are multiple matches, I want them sorted by date submitted. Afterwards I want matches from the book description, and if

Moving data files

Does anyone know of a good step-by-step document demonstrating moving the data files of a 3.23.5x installation (5 databases, each with several tables) to a new partition on the same Linux box. I want to do this before upgrading to MySQL 4. I think I understand how to do it from reading the docs,

ORDER BY DESC order different when using LIMIT

This is not an error. The results returned by MySQL are correct. Since each value of CreatedDate in your example occurs twice, ORDER BY CreatedDate DESC only says that the ImgId's 2 and 3 should precede ImgId's 1 and 4. The database is free to return ImgId's 2 and 3 in either order and to

Mysql 4.0.16 stop working

Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen. I download Mysql for Windows but not purchase the Commercial Licence yet. Is there a time based restriction here? -- MySQL General Mailing List

Re: Mysql 4.0.16 stop working

William IT wrote: Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen. I download Mysql for Windows but not purchase the Commercial Licence yet. Is there a time based restriction here? No, there is

InnoDB Set-up

My background is Micorosoft Access and SQL server. The InnoDB table type gives me a much close option to move my databases. I found the database a little complex and would like to know if there is a better step-by-step explanation of setting up InnoDB in MySQL 4.1 on a Windows 2000 machine.

Please help DB Error: unknown error

Hi all, I have a problem with my query on mySQL 4.0. DB Error: unknown error I don't know what is the problem. Please help me!!! Thanks in advance. Regards, Thai SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile

Re: Next release of 4.1x , any release plans

On Sun, 16 Nov 2003, Kim G. Pedersen wrote: Hello Since it quite buggy using 4.1 in combination with subselect it could be nice to know next planned release of 4.1.x I would guess the end of the year. -- Boyd Gerber, Software Engineeer Support Specialist MySQL AB, www.mysql.com Are you

Merging duplicate rows

How do you merge duplicate rows? All rows involved contain identical data in each column. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]