On Wed, 9 Feb 2005, Batara Kesuma wrote:
> Hi,
>
> I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine
> is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL
> won't start if I set innodb_buffer_pool_size to >= 2GB. Here is my
> ulimit.
Are you trying this on a 3
On Tue, 8 Feb 2005, Heikki Tuuri wrote:
> You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
> 000 rows, and a runaway rollback can no longer happen.
This is very nice!
Are there any plans for the same with INSERT ... SELECT -type statements?
--
MySQL General Mailing List
On Mon, 7 Feb 2005, Bjorn van der Neut wrote:
> Hello Everyone,
>
> Can someone tell me If you can find out if the replace into function has
> done an insert or an update?
It actually never does an update, it always INSERTs.
It either does an insert or delete(s) followed by an insert.
--
MySQ
On Tue, 1 Feb 2005, matt_lists wrote:
> >> now we have this added on a few tables in the dump
> >>
> >> DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
> >> DIRECTORY='E:\mysql\data\campbell\'
> >
> > DATA DIRECTORY='E:\\mysql\\data\\campbell\\' INDEX
> > DIRECTORY='E:\\mysql\\data\\campbell\\'
> >
e problem on Windows is that
it uses \ instead of / in the path names there, which makes it use it as an
escape character. Since dATA/INDEX DIRECTORY in CREATE TABLE is ignored on
Windows when importing anyways, it's safe to remove those clauses.
If you can find a way to reproduce it, feel f
On Wed, 3 Nov 2004, Anders Green wrote:
> Tobias Asplund wrote:
> >If you installed MySQL 4.1.7 on Windows with the new installer
>
> Yes I did.
>
> >it will automatically use InnoDB tables as the default
>
> Ah ha. Thanks. :)
>
>
> That just leaves this:
On Wed, 3 Nov 2004, Chaitra Yale wrote:
> ...how can union be the same as intersect..iam trying to get the names
> of comapnies that are in both queries.for example the first query
> gives me companies A, B AND C and the second query gives A , B..i want
> the intersect of these 2 queriesso
If you installed MySQL 4.1.7 on Windows with the new installer, it will
automatically use InnoDB tables as the default unless you specify different.
(This is different from earlier versions), so the error was probably not in
the Query Browser, but in the server settings in this case.
On Wed, 3
On Thu, 21 Oct 2004, C.F. Scheidecker Antunes wrote:
> Hello,
>
> On a further inspection and by reading Paul DuBois' I guess m y system
> has to many bin logs. How can I get ride of them?
Assuming you don't need them for replication or point-in-time recovery, you
can use the PURGE command.
http
action 2:
> START TRANSACTION;
> DELETE FROM results WHERE id_job = 25919;
> INSERT INTO results(result,id_job) VALUES (25.388607,25919),(22.650234,25919);
> COMMIT;
I think this manual page might explain what's happening:
http://dev.mysql.com/doc/mysql/en/InnoDB_Next-key_locking.ht
On Tue, 14 Sep 2004, Yves Goergen wrote:
> Hi,
> I can vaguely remember there was something like "INSERT... on duplicate
> key UPDATE..." in MySQL, but the documentation search is almost as
> useful as I'm used to - it cannot tell me anything about this. Can you
> please? How does this work, what'
On Tue, 14 Sep 2004, joe mcguckin wrote:
> If I perform a fulltext search for 'foo', it won't match text like
> 'foo, inc'.
In addition to the other suggestions, make sure our ft_min_word_len isn't
more than 2, because it won't index words shorter than that many characters.
--
MySQL General Ma
> Can anyone tell me what's going on? Are there MySQL parameters that can
> improve things?
To know if you need to tune something, you can send us the copy of SHOW
STATUS; and SHOW VARIABLES;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
On Tue, 14 Sep 2004, Sheraz wrote:
> when I try following:
>
> CREATE TABLE `MyTable` (
> `SNumber` char(32) NOT NULL,
> `UserID` char(32) NOT NULL default '0',
> PRIMARY KEY (`SNumber`)
> ) TYPE=MyISAM;
>
> It created the exactly correct table, But when i add
> any varchar field in the abo
On Tue, 7 Sep 2004, matt ryan wrote:
> Still have not got this fixed, I'm all out of idea's, the slave has been
> reloaded again today
I forgot, did you have multiple slaves on multiple machines? If so, do they
have identical hardware/drivers?
--
MySQL General Mailing List
For list archives: h
On Tue, 7 Sep 2004, Lee Denny wrote:
> Hello,
>
> I need to perform a select that compares two dates
>
> I need to return all records that haven't had date_2 set after a given
> number of days since date_1.
>
... WHERE date_2 < date_1 + INTERVAL X DAY
Where X is the number of days.
Assuming th
On Fri, 26 Mar 2004, Seena Blace wrote:
> Select group,hostname,details from table1 order by group;
>
> I want the output should be like
> Group hostname details
> aa abababa
> abababababab
>zzz
On Mon, 15 Mar 2004, Boyd E. Hemphill wrote:
> Using a tool to generate a data model I go the following statement:
>
> Create table StateN (
> StateId Int NOT NULL AUTO_INCREMENT,
> StateNm Char(50) NOT NULL DEFAULT '',
> StateCd Char(7) NOT NULL DEFAULT '',
> SortInt Int N
On Sun, 8 Feb 2004 [EMAIL PROTECTED] wrote:
> the only way I can connect to the server is typing
>
> mysql -h localhost -u root
>
make sure you don't have a line "skip-networking" in your /etc/my.cnf
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
On Fri, 6 Feb 2004, Alvaro Avello wrote:
> the questions is , the wildcard in host field doesn't
> involve localhost o a machine host's ? Which kind of permissions we
> have to put in host fields to have a mobility and not to be afraid to
> move our servers for an emergency ?
When the host field
On Fri, 30 Jan 2004 [EMAIL PROTECTED] wrote:
> >Description:
> When creating a table, mysql 5.0.0-alpha (binary package)
> does not accept column name 'Found'.
>
> >How-To-Repeat:
> create table log (Found INT UNSIGNED NOT NULL);
>
FOUND is a reserved word. Use within backticks, ie `Found`
http
On Wed, 28 Jan 2004, Deven Phillips wrote:
> Hello,
>
> There is a web site associated with the web-radio. Users of the web site
> can rate songs which are contained in the database. The rating system
> works such that users can rate songs from +3 to -2. Now, what I would
> like to accomplish is t
On Fri, 23 Jan 2004, Rob Kemmer wrote:
> Hi, MySQL Team!
>
> I've downloaded and successfully installed v5.0 win2k, and am happily using stored
> procs, but seem to be encountering problems with subqueries in stored procs. When I
> run a stored proc containing a subquery, the first pass works,
On Wed, 21 Jan 2004, Yves Arsenault wrote:
> Thanks for your response,
>
> I'm using ColdFusion along side of MySQL to server dynamic content to some
> websites.
>
> When I run the page that this code is in, I get an SQL syntax error:
> Syntax error or access violation: You have an error in your S
On Tue, 20 Jan 2004, Todd Burke wrote:
> Is there any way to disable replication of all temp tables using
> replicate-ignore-table or some other means? The names of the temp tables
> are generated randomly by a script. Thanks
If you could have all temporary tables starting with "tmp" or someth
On Tue, 20 Jan 2004, Mike Mapsnac wrote:
> In the table value login_count is int(4). For example if value login_count
> equal to 3 and each time user login I want to increment by one.
>
> update customer set login_count='how?" where id=12121212;
SET login_count = login_count + 1
--
MySQL Gene
On Tue, 20 Jan 2004, Chris Boget wrote:
> > > The data I'm working with looks like this:
> > > table1.columnA = '1;3;4;6;8;9;12;13;14;15';
> > > table2.columnA = '3';
> > > table2.columnB = 'this';
> > > I need to write a query that will do something along these lines:
> > > SELECT * FROM table1,
On Tue, 20 Jan 2004, Chris Boget wrote:
> The data I'm working with looks like this:
>
> table1.columnA = '1;3;4;6;8;9;12;13;14;15';
>
> table2.columnA = '3';
> table2.columnB = 'this';
>
> I need to write a query that will do something along these lines:
>
> SELECT * FROM table1, table2 WHERE
>
On Tue, 20 Jan 2004, Marco Paci wrote:
> Since the process of inserting a new record and reading its PK field
> value is a two step process implemented by:
> 1) insert into tablename (columnnames) values()
> 2) select last_insert_id()
> ,and since because of the architecture of my application
On Mon, 19 Jan 2004, Ian O'Rourke wrote:
> Regarding the following query:
>
> SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
> %y'),SectionID,Title,Summary,Content FROM articles
> ORDER BY EntryDate
> DESC LIMIT 10
>
> Okay, I've looked in the manually up and down, as I know how to do it in
> Acce
On Mon, 19 Jan 2004, Mike Mapsnac wrote:
> I think that main disadvantage of this command is thah it works for the
> database but not for specific table. So if a database has 200 tables, find
> result for specific table is not an easy task.
SHOW TABLE STATUS LIKE 'tablename'\G
cheers,
Tobias
On Sun, 18 Jan 2004, Hassan Shaikh wrote:
> Hi,
>
> How do I resize (shrink & expand) InnoDB file?
>
You can read about the various InnoDB specific startup options here:
http://www.mysql.com/doc/en/InnoDB_start.html
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.m
On Sat, 17 Jan 2004, Mike Mapsnac wrote:
> Is it possible to find out when the table was created? How to get information about
> the table?
>
You can use the unix command `stat`, the last of the 4 dates will be the
creation date (in the order of Last Accessed, Last Modified, Last Inode
modificat
On Sun, 18 Jan 2004, Nitin Mehta wrote:
> I need to select a column's value as different columns and other fields grouped by
> those values.
>
> I want to select distinct values of reseller column as individual columns and other
> data grouped on these values.
Since the approach of tables usual
On Fri, 16 Jan 2004, Jough P wrote:
> Greetings all, I'm trying to grant a user the file privilege and am
> getting error messages. Here's my SQL statement
>
> mysql> GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
> 'password123';
>
> It gets the following error:
>
> ERROR 1144: Illeg
On Thu, 15 Jan 2004, Jamie Murray wrote:
> Hi Guys,
> after waiting about a minute I get
>
> ERROR 2013 (HY000): Lost connection to MySQL server during query
>
See if changing any of the
SHOW VARIABLES LIKE 'net%timeout';
helps.
Not sure why the crash popup comes up, however.
cheers,
Tobias
--
On Fri, 16 Jan 2004, tait sanders wrote:
> yep I've already done this.
> everything I do comes back with the same error:
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> I even deleted the mysql.sock and used 'mysql_config --socket' to
> recreate it.
> t
On Wed, 14 Jan 2004, Ugo Bellavance wrote:
> mysql 4.0.17 on redhat 9 or debian 3.0
>
> mysql> show variables like 'log';
> +---+---+
> | Variable_name | Value |
> +---+---+
> | log | ON|
> +---+---+
> 1 row in set (0.00 sec)
>
> mysql>
On Tue, 13 Jan 2004, EP wrote:
> I am wondering:
>
> I can see the MySQL data files for my various databases.
>
> What technically prevents me from simply copying those files and using copies
> - to move my database to another file structure or server
> - to back-up my current db
Copying will not
On Tue, 13 Jan 2004, Priyanka Gupta wrote:
> Hi,
>
> I am trying to do some performance analysis by trying different indexing
> schemes and testing how long it takes. To get consistent results, I would
> like to use something like SQL_NO_CACHE. However, the mysqld version that I
> have installed d
On Mon, 12 Jan 2004, Viktor wrote:
> Hello mysql,
>
> Table-level privileges do not work at all... (on Windows)
Works fine for me:
4.1.1a-alpha-max-nt:tmp >GRANT SELECT ON tmp.tmp TO [EMAIL PROTECTED]
IDENTIFIED BY 'aaa';
Query OK, 0 rows affected (0.18 sec)
4.1.1a-alpha-max-nt:tmp >\q
Bye
On Mon, 12 Jan 2004, Lewis, Jason wrote:
> Okay I have a field in my db called MemberLevel in this field you can be one of 5
> levels.
>
> Platinum
> Gold
> Silver
> Paying
> Non-Paying
>
>
> now my question is, how would I ORDER BY MemberLevel and get it to come out in the
> above order? I have
> Hello,
>
> What do I need to add to the my.ini file? Can anyone post a typical setup
> of this as an example?
I install with mysqld-nt-max --install servicename
servicename in those cases are MysQL40, MySQL41 and MySQL50
Those are the relevant rows:
[mysqld]
[mysql40]
basedir = C:/mysql/4.0
On Mon, 12 Jan 2004, Alaios wrote:
> Hi there. Do u know how can i backup my database?
> (create && insert)
http://www.mysql.com/doc/en/Backup.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, 12 Jan 2004, Ed Lazor wrote:
> Is there an abstract way to refer to field names in a result set?
> select ID, Name, Price from Products order by field(1)
> where "field(1) would be the abstract way of referring to the specific field to sort
> on.
ORDER BY #
Where # is the number of the c
On Mon, 12 Jan 2004, Hassan Shaikh wrote:
> Hi,
> The following does not work for InnoDB tables. The manual says "The next
> AUTO_INCREMENT value you want to set for your table (MyISAM). "
> ALTER TABLE AUTO_INCREMENT = ;
>
> Any suggestions for InnoDB?
Insert a row with a custom value, then de
On Tue, 6 Jan 2004, Luc Foisy wrote:
> There was a user comment under the Foriegn Key section of the documentation reading:
> To restore from a mysqldump file that uses foreign keys:
>
> mysql> SET FOREIGN_KEY_CHECKS = 0;
> mysql> SOURCE your_dump_file;
> mysql> SET FOREIGN_KEY_CHECKS = 1;
>
> T
On Tue, 6 Jan 2004, Knepley, Jim wrote:
> Any chance that there's a quarterly strategic roadmap published
> somewhere?
>
> I have projects that sometimes depend on a feature in the next rev' or
> some such, and I need to plan out for my organization... Difficult to
> answer my boss when the depend
On Tue, 6 Jan 2004, Martijn Tonies wrote:
> Hi,
>
> In MySQL 4.1, is there a function to know what the
> current default server-wide characterset is?
You can find all those with:
SHOW VARIABLES LIKE 'character_set%'
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.m
On Mon, 5 Jan 2004, Allen Weeks wrote:
> Hi All,
>
> Just a quick question, does anyone have a good estimate of when ver 4.1 will
> go production.
When known bugs are fixed.
You can read up on MySQL's release policy here:
http://www.mysql.com/doc/en/Release_philosophy.html
--
MySQL General Maili
On Mon, 5 Jan 2004, Hal Vaughan wrote:
> I've found an odd problem in queries.
>
> I have a lot of data regarding vehicle speeds in a survey. All the data is in
> the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles
> per hour in a 55 miles per hour zone. 80/55 means we
On Mon, 5 Jan 2004, Douglas Sims wrote:
> The test was a bit harder than I anticipated. I should have paid more
> attention to column types and database name, among other things. But I
> did pass - at least, the preliminary report said pass, but also said
> that the exam will be reviewed and "If
On Mon, 5 Jan 2004, Greg Owen wrote:
> I tried (you can laugh here) to do it this way, but failed miserably:
>
> mysql> select class,count(questnum),count(difficulty='0'),
>count(difficulty='1'),count(difficulty='2'),
>count(in_use='0'),count(in_use='1') from Questions
>group by class;
On Mon, 5 Jan 2004, Marc Dver wrote:
> Based on the collective experiences of the members of this group, what
> are the best methods for learning mysql, both from the perspective of
> certification and of learning enough to excel in the production
> environment? My interests include both the spec
This bug was fixed to 4.0.17, it happened when you inserted a negative
value manually into an auto_increment column
for more info see:
http://bugs.mysql.com/bug.php?id=1366
On Mon, 5 Jan 2004, Donald Henson wrote:
> Please post your table schema. As to why rather than zero, I'll
> have to def
On Mon, 5 Jan 2004, Matthew Stuart wrote:
> I am trying to create a couple of columns (one createddate and one
> updateddate) in a MySQL table that are DATETIME or TIMESTAMP values,
> but I am having trouble understanding how it works. I want both columns
> to auto add a date and time when a recor
On Fri, 2 Jan 2004, Roger Baklund wrote:
> * Gohaku
> > I was just curious if there's a shorthand way of replicating a Table
> > Schema.
> > I use the following to create a new Table with the same schema.
> > >create table new_table ( select * from table);
> > >delete from new_table;
>
> You can
On Fri, 2 Jan 2004, Jonathan Villa wrote:
> I have a loop which is similar to the following:
>
> while(array contains elements) {
> UPDATE users SET status = no WHERE name = array[i]
> }
> great, it works but the query runs many times. I want to make only one
> call to the database and have all th
On Fri, 2 Jan 2004, Caroline Jen wrote:
> In case that a user has multiple roles; for example,
> John Dole is both author and editor,
>
> 1. I should have two rows for John Dole?
>
>John Dole author
>John Dole editor
>
>or. I should have only one row and use comma ',' to
>
>
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
might help you do what you're looking for.
On Thu, 1 Jan 2004, Schulman, Michael wrote:
> As far as I know min(price) and max(price) will return the lowest and higest
> price, not the first and last in the group. Again I kno
On Mon, 29 Dec 2003, Leo wrote:
> I know someone already ask this,
> and the answer generally 'NO YOU CANT' :b
>
> but, is there any work around so i can make a backup server (slave),
> from many other server (master) through replication?
You could run a server instance per database replicated and
On Mon, 22 Dec 2003, Jeff McKeon wrote:
> Is it possible to have 2 database on one server replicating from the
> same Master server?
yes.
> In other words. DB01 is the Master on System01,
> System02 has DB01_rep1 and DB01_rep2, each with their own replication
> from DB01.
Shouldn't be a problem.
Can the user the mysqld process run as (usually the mysql user) read/write
the /var/lib/data directory without problems?
Does your /etc/my.cnf file contain a
datadir = /var/lib/mysql
or is it pointing somewhere else?
Did adding skip-innodb to your my.cnf solve anything?
On Fri, 19 Dec 2003, lan
On Fri, 19 Dec 2003, K Q-B wrote:
> I am creating a table and would like to use auto
> increment, but I would like one column to increment in
> only odd numbers 1,3,5... and another column of the
> same table to increment in even numbers 2,4,6...
>
> Is it possible to do this?
Not without a little
On Mon, 15 Dec 2003, Paul Fine wrote:
> If I have a table like with a column being the PK for the table and being an
> Auto Increment value, what is the best way to return this value to my
> script?
If you insert a row LAST_INSERT_ID() will return the primary key value in
this setup.
The other w
On Mon, 15 Dec 2003, Roberts, Mark (Tulsa) wrote:
> I have an order taking system where the tables are store in a MySql database. I need
> to develop a select statement to output all new orders to a .csv formatted file.
>
> Is this possible to do in MySql. I would try looking this up, however, I
> Sven Köhler wrote:
>
> >> I set the isolation level to READ_REPEATABLE and use mysqldump |
> >> bzip2 to get the result. I've tested the restore and it's fine!
> >
> >
> > So how does mysqldump handle binary data?
> >
> > If it does embed the data into the SQL-statement somehow, that's crap,
> >
On Mon, 15 Dec 2003, Graham Little wrote:
doing selective quoting below.
> LOAD DATA INFILE "D:\mysql\sql\CountryData.txt"
> INTO TABLE cou (id, country);
See how you try to load from a file into the columns id and country in the
cou table?
> The table the data is being inserted int
On Mon, 15 Dec 2003, Peter Lovatt wrote:
> Try
>
> Insert INTO `table` ( `inc_field` ) values (10)
>
> the auto inc field will then generate the next sequential numbers
>
> HTH
>
> Peter
Or just use
ALTER TABLE table AUTO_INCREMENT=10
That way you don't have to enter a record jus
On Wed, 10 Dec 2003, Gavin Dimmock wrote:
> Hi All,
>
> I want to change the default port on mysql server from 3306 to 5 (for
> example). The server is NT. Has anyone done this before?
>
> Any help really appreciated,
>
Can either modify the service to start with the --port parameter or add i
On Tue, 9 Dec 2003, Mayuran Yogarajah wrote:
> Diana Soares wrote:
>
> >Use "PURGE {MASTER|BINARY} LOGS TO 'log_name'" instead of "RESET
> >MASTER".
> >>From the manual:
> >
> >"
> >Deletes all the binary logs listed in the log index that are strictly
> >prior to the specified log or date. The log
You have a few ways to do this.
What's happening here is that you do a comparison in a string context,
which means that it will sort according to the ascii values, and 1 comes
before 8.
To sort the way you want you need to specify to MySQL that you want to do
it in a numeric context.
You have two
On Thu, 4 Dec 2003, Uros Kotnik wrote:
> I posted this few days ago, but with no answer, also posted it to
> benchmark list..
>
> Executing this SQL, takes ~5 sec.
>
> select artists.name , cds.title , tracks.title from artists, tracks,
> cds
> where artists.artistid = tracks.artistid and cds.cdi
If you do a fulltext search on multiple columns at once, there must be a
combined fulltext index on this exact set of columns. Just having an index
on them individually will not work.
On Wed, 3 Dec 2003, Mirza wrote:
> Hi,
>
> I have error 1191 "can't find fulltext index matching the column li
I think that
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
covers your problem here.
You either have to solve it with Temporary tables, the MAX-Concat trick
(in the url above) or a subquery (which will be more inefficient than the
other two options).
On Thu, 20 Nov 2003, Yve
On Sat, 8 Nov 2003, Michael Satterwhite wrote:
> This has got to be a common question, but I'd really appreciate a little help.
>
> I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run
> that deletes this.
>
> When I try to start mysql, I get the message
>
> "Can't connect
MySQL doesn't support TOP, however, there's a LIMIT syntax for MySQL that
roughly does the same thing:
http://www.mysql.com/doc/en/SELECT.html for a brief explanation.
In your example what you are looking for is:
SELECT DateCreatedField
FROM my_table
ORDER BY DateCreatedField DESC
LIMIT 10;
It depends on your filesystem's and OS's max-size of a file in its
filesystem.
HOWEVER, there are a few ways you can get around this.
You can use InnoDB tables, or read about RAID types here:
http://www.mysql.com/doc/en/CREATE_TABLE.html (almost at the bottom of the
page).
You can also use MERGE
If you have 4.0.2 or later you can use the CAST() function, if you have
earlier you should be able to emulate it with the BINARY keyword for the
ORDER BY clause, examples below:
[EMAIL PROTECTED]:tmp > CREATE table sort (
-> num int
-> );
Query OK, 0 rows affected (0.00 sec)
[EMAIL PRO
put this command in
> a script to make it automatic to insert records.
>
> Nestor :-)
>
> Nestor A. Florez
>
>
> >>> Tobias Asplund <[EMAIL PROTECTED]> 10/15/2003 12:02:21 PM >>>
>
> > c:\>mysql mydb < myfile.sql
> > ERROR
80 matches
Mail list logo
