ere. I have also tried to
let my code run later in the evaluation process
of MySQL but the result stays the same.
Best regards,
Tobias Krueger
ding my schema
is already normalized and over-normalization generally decreases
performances. I guess I would then run into other problems.
Greetings
Tobias
-Ursprüngliche Nachricht-
Von: Michael Dykman [mailto:mdyk...@gmail.com]
Gesendet: Dienstag, 5. Januar 2010 17:14
An: mysql@l
, team2_points, no_fight
FROM matches
)
) m ON (a.id = m.player_id)
I hope someone can help me with this.
Thanks in advance.
Regards
Tobias
Hy there,
I'm planing to to build a small "partial replication" on MySQL 5.0 using the
Spread Toolkit and the Message API for MySQL. Therefore I'll create a trigger
(on insert) which fetches the row and sends it to the message group XY.
I was wondering if there is a way to tell MySQL in an SQL
List,
I am bulk inserting a huge amount of data into a MyISAM table (a
wikipedia page dump).
Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE
KEYS; LOCK TABLES page WRITE;
The dump consists of about 1,200 bulk INSERT statements with roughly
12,000 tuples each.
For the
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
tp://bugs.mysql.com/bug.php?id=6660
(Or send me the test-case and I can do it).
I haven't gotten the bug approved since I can't reproduce it (but it does
happen quite often, just haven't been able to find out why, not even by
replaying binary logs).
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
I have a problem with a query. I have a given amount of values (id:s)
(for example 1,2,6,12,77,78,79,122,123,124), these are related to a
table, "pref", and belongs to a specific category, "pref_cat"-table. So,
1,2,6,12 are connected to id 1 in "pref_cat", 77,78,79 to id 2 and
122,123,124 t
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:/
when i add
> any varchar field in the above sql..then generated
> table is like it has all the fields of type Varchar
This behaviour is documented (although slightly annoying) here:
http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html
cheers,
Tobias
--
MySQL General Mailing List
For
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
Hi!
I have restarted the Linux server. Typing
>mysqld
result:
040607 11:32:47 Can't start server: Bind on TCP/IP port: Address
already in use
040607 11:32:47 Do you already have another mysqld server running on
port: 3306 ?
040607 11:32:47 Aborting
040607 11:32:47 mysqld: Shutdown Complete
T
did I wrong???
It seems, that the certs & keys are vaild only for some hours.
Maybe someone could help me.
Thanks.
Tobias Gunkel
Germany
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s.
Maybe I can link the Update Values with an XOR and a Mask, but how must
I do it in MySQL?
Up to now a haven’t figured it out how to UPDATE a SET Value with a
"binary Value".
I use only the "Strings" or the "Decimal Value".
Thanks if someone is a little bit more famil
abababababab
> anannanananna
> bbllololololool
Hi Seena,
Try this:
SELECT IF(@a != group, @a := group, '') AS group, hostname, details FROM
table1 ORDER BY group
Cheers,
Tobias
--
MySQL General Mailing List
For list archive
got an answer and still don't know what’s going
on with my Sockets!
(Has someone an Idea ??)
Best regards,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
istakes in English!
Best regards,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Then you will remove one of the two indexes on the StateCd column.
for example:
DROP INDEX StateId ON StateN;
DROP INDEX StateCd ON StateN;
That would leave you with the Primary Key on StateId and a unique index
called ak_State on the StateCd column.
cheers,
Tobias
--
MySQL General Mailing Lis
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 archi
cation
connect to 127.0.0.1 or the computer's IP.
This however will slightly decrease performance, since a Unix socket is
faster.
A fix if you have to emergency move the server could be to just change the
fields from localhost to '%'.
cheers,
Tobias
--
MySQL General Mailing List
word. Use within backticks, ie `Found`
http://www.mysql.com/doc/en/Reserved_words.html
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1
This will generate random numbers between 0 and 8-13 depending on what the
average vote for the song is, you can change the + 10 to any number to
weigh them differently (although, if you use 0-2 votes with low averages
might never be played since their values will always be negative).
Mig
the first pass works, but a second
> consecutive call to the proc crashes the server.
>
> Other than that, I haven't encountered any other problems.
This sounds very similiar to bug #2460:
http://bugs.mysql.com/bug.php?id=2460
cheers,
Tobias
--
MySQL General Mailing List
For lis
You have an error in your SQL syntax near
> '(theDate) = '31' and month(theDate) = '9' and year(theDate) = '2003''
>
> The right values are displayed from ColdFusion server, but I keep getting
> the syntax error.
In 3.23 you have to use DAY
tements will not be replicated if the database name
matches the database pattern (foo% here) (this magic is triggered by %
being the table pattern). Escaping wildcard characters _ and %: see notes
in the description of replicate-wild-do-table just above.
cheers,
Tobias
--
MySQL General Mailing List
For
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
ith appropriate
columns).
The first line checks if ,column, exists, which will be in all cases when
it's not either first or last.
The second line checks if it exists first in the commaseparated list, and
the last line checks if it exists last.
There's probably an easier way to do this, but since I submitted a faulty
reply I should atleast make up for it ;)
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
g along these lines:
>
> SELECT * FROM table1, table2 WHERE
> table2.columnB = 'this'
> AND
> table1.columnA LIKE CONCAT( '%', table2.columnA, '%' );
>
AND
INSTR(table1.columnA, table2.columnA)
You can find more info about the INSTR function at:
|
|
|
v
TimeThread 1 Thread 2
Axis
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,Author,DATE_FORMAT(EntryDate,'%d %m %y') AS something,
SectionID, Title, Summary, Content
FROM articles
ORDER BY EntryDate DESC
LIMIT 10
(The AS isn't mandatory, you can just state the alias if you want, the AS
can be good for readability, however)
cheers,
Tobias
--
MySQL General
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'
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 lis
this case it shows that the table was created Dec 21.
stat -f %B
will give you only this data in a unixtime format, if that would suit you
better.
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
asily accomplish this with the SELECT ... CASE ... control flow
function as documented at:
http://www.mysql.com/doc/en/Control_flow_functions.html
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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,
thanks heaps for all your help.
You can see if MySQL is actually running with ps.
If it is running you can see what socket it's using with `netstat -a |
grep mysql`
You can try to connect through tcp/ip instead of the socket by using -h
127.0.0.1 at the commandline.
If the server isn't up
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>
rent db
Copying will not work across certain versions, will also not work between
system archtechtures, port to other RDBMS or if you do not have physical
access to the files.
For the cases above mysqldump works fine.
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lis
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
; to clear the buffer.
4.1.1a-alpha-max-nt:(none) >SELECT * FROM tmp.tmp;
+--+
| a|
+--+
|1 |
+--+
1 row in set (0.42 sec)
4.1.1a-alpha-max-nt:(none) >SELECT * FROM tmp.meep;
ERROR 1142 (42000): select command denied to user: 'tmp'@'localhost' for
table
ak it out into another table andgive them ids in the order they
should be sorted
3. use a CASE statement:
SELECT col, CASE col WHEN 'Platinum' THEN 1 WHEN 'Gold' THEN 2 ... END AS
sortby ORDER BY sortby
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http:
r = C:/mysql/4.0-tree/
datadir = C:/mysql/4.0-tree/data
port= 3307
[mysql41]
basedir = C:/mysql/4.1-tree
datadir = C:/mysql/4.1-tree/data
port= 3308
[mysql50]
basedir = C:/mysql/5.0-tree
datadir = C:/mysql/5.0-tree/data
port= 3309
cheers,
Tobias
--
MySQL General Mailing List
For l
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]
the number of the column counting from left to right starting
at 1.
cheers,
Tobias
--
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, 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
ons, make a beta release of 4.1 in January followed by a gamma
release ASAP."
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
F
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
ike 61/55 or 32/25).
mysql> SELECT SUBSTRING_INDEX(speed, '/', 1) AS clocked,
-> SUBSTRING_INDEX(speed, '/', -1) AS zone, ...
-> WHERE SUBSTRING_INDEX(speed, '/', 1) > SUBSTRING_INDEX(speed, '/',
-1) AS zone
That is for finding all the speeder
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
x27;),count(in_use='1') from Questions
>group by class;
>
You can use SELECT class, COUNT(questnum), SUM(IF(difficulty = 0, 1,
0)), SUM(IF(difficulty = 1, 1, 0)), ...
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
>
> > Why id (primaty , and auto_increment) start from 2147483647 and not from 0
> > or 1
> >
> > Thanks
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e the cleanest
> way to give it to you. The way the zeros, hyphens and colons are typed
> is how I would like to store my dates if at all possible.
The only issue here is that when you insert a new article you need to set
the createdate column to NOW().
ie,
INSERT INTO all_articles (createddate
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
About two weeks ago I received "The table Worklist is full" error. Since
what type of table? MyISAM?
how big is 'full'?
"If you don't specify any of the above options, the maximum size for a
table will be 4G (or 2G if your operating systems only supports 2G tables)."
i dont know how big files can
would be used instead even though
the fulltext-index would have been better. But that's not so bad - we would
scan maximum 999 rows with the use of another index - no problem! ...not
compared to my 100.000 rows scans that's the result of picking a
fulltext-index when it gives a lo
SELECT product_id, name, description, sales.sale_id
FROM products LEFT JOIN sales ON products.product_id = sales.product_id
WHERE sales.customer_id = 10 AND sales.sale_id IS NULL
This query should return no rows, because if you retrieve rows where sales.sale_id is NULL, customer_id for these rows
Andy Hall wrote:
Hi,
I have just started using MySQL from MSSQL 7. I need to port the following
into MySQL from an existing (working) query on MSSQL Server:
SELECT product_id, name, description
FROM products
WHERE product_id NOT IN (SELECT product_id FROM sales WHERE customer_id =
10)
i.e. get al
What do you mean with secure connection, ssh?
How to configure this on MySql?
- Original Message -
From: "Fortuno, Adam" <[EMAIL PROTECTED]>
To: "'Flavio Tobias'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 2:17 P
I need to access a database thru internet. It is secure to do this using MySql?
Thanks
Flavio Tobias
If you want a simple solution for windows, check
RSSmyperfmon
www.rss-software.de/en
> MTop (MySQL Top) is a really nice little utility:
> http://mtop.sourceforge.net/
>
> Shows what queries are running, and elapsed time.
>
> Daivd
> - Original Message -
> From: "Prem Soman" <[EMAIL PROTEC
hangs at the last line...
Any ideas how to avoid this problem?
Thanks in advance,
Tobias
>my_init
| >my_win_init
| libmysql_init
my_malloc
| my: Size: 544 MyFlags: 48
| exit: ptr: 4d144c8
mysql_real_connect
| enter: host: 127.0.0.1 db: rssvertrieb user: rss
| info: Server name:
I think I need a MySQL code guru...
I am using the 4.0.12 client library on a Win2k host to
connect to a 4.0.13 linux server.
If I connect directly to the server using mysql_real_connect, everything
runs fine.
However, I want to use SSH tunneling.
So I set up a SSHv2 tunneling connection from l
1 - 100 of 160 matches
Mail list logo
