Hi Daniel,
just download the latest mySQL distribution including everything you need!
Regards
Andy
> -Ursprüngliche Nachricht-
> Von: Daniel Kiss [mailto:[EMAIL PROTECTED]
> Gesendet: Samstag, 15. November 2003 21:52
> An: [EMAIL PROTECTED]
> Betreff: Client library
>
>
> Hi all,
>
> I h
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
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 maxim
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`),
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:http://lists.mysql
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 Syb
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 slash
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
> 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 pa
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
>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 Img
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"
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,
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
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 ap
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.mysql&scoring=d
Hope this helps,
Joseph Bueno
Pe
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
Hi
I am not sure how this "limit" works , but in oracle
if you use a rownum<100 (guess it is some of the same),
the sorting are done After the limitation so...
if u say rownum<100 , it gives u 100 lines abitrary order and then it
sorts that 100 lines
HTH
Kim G. Pedersen
>>Description:
>
> When
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 ther
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,
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 retu
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
F
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 n
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.
Man
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 t4,tblUserProfil
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
A
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]
27 matches
Mail list logo