Rgds,
Indrek
--
MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy
/_/ /_/\_, /___/\___\_\___/ Uuemõisa, Haaps
to our documentation page
(http://www.mysql.com/documentation/index.html) now.
Rgds,
Indrek
--
MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /_
is and much more information about the limits
of MySQL and other databases at our Crash-Me pages at:
http://www.mysql.com/information/crash-me.php
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/?ref=mtfr
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
heck out: http://www.mysql.com/doc/P/r/Privileges_options.html
You need to run the server with the --safe-show-database option.
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /I
technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
<___/ www.mysql.com
--
ysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
<___/ www.mysql.com
-
Before post
r.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
<___/ www.mysql.com
-
Before posting, p
ing on straightening this out, so our downloads should
be operational again real soon.
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /
f you are downloading a binary distribution, you should download
the MySQL-Max binary, that has BDB/InnoDB compiled in (the
default MySQL does not).
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Indrek Siita
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /___/\___\_\___/ Tallinn,
sql
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Indrek Siitan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru
/_/ /_/\_, /__
Hi,
> mysql> select * from logezboo;
> ERROR 1016: Can't open file: 'logezboo.MYD'. (errno: 145)
shut down your mysql, change to your MySQL data directory (as root or the user
MySQL runs as) and run:
myisamchk -r */*.MYI
and then restart MySQL after that and you should be back and running.
Hi,
> -> DAY) >'$tdate' and city.id=special.cityid order by RAND() limit 1;
> ERROR 1064: You have an error in your SQL syntax near 'RAND() limit 1' at
> line 3
>
> select version();
> +---+
> | version() |
> +---+
> | 3.22.32 |
> +---+
>
> What could be the proble
Hi,
> I can not access to an access file via ODBC
> It gives me
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]
> The Microsoft Jet database engine cannot open the file '(unknown)'.
> It is already opened exclusively by another user, or you need
> permission to view its data., SQ
Hi,
> I have just done this:
> select * from indexed_table where match(indexed_col)
> against ('"visual basic"')
> This returns rows with either visual or basic. I read
> phrase searching was allowed in mySQL v4.0? Can someone please advise.
you're right, phrase and AND searches will be in MySQ
Hi,
> How can I insert an image file into a blob field? I search the MySQL
> Documents but nothing came up specificaly on inserting images from files.
INSERT INTO sig
VALUES (
1,
'Paul',
'Davolio',
LOAD_FILE('d:/signatures/paul.txt')
);
Rgds,
Tfr
--==< [EMAIL PROTECTED]
Hi,
> I have to manipulate (or access) MySQL Database through pure C or
> C++, but I am not getting the exact libraries for it. Also, I don't
> know how to do it. Please anybody would tell me if it is possible
> or not. And if it is possible, then let me know how to do it and
> what to do for it.
Hi,
> Hi,
> I'm trying to use an if then alike statement in MySQL, myabe
> anyone can tell me the correct syntax if got a variable named
> naam. when the content of this variables is empty the following
> SQL statement should be executed:
> select * from beheerder;
> when naam is not empty:
> sel
Hi,
> Does anyone know the correct syntax to connect to a mysql database
> with DBI? I tried the syntax mentioned in the Perl DBI O'Reilly
> book, but I got errors.
i'm pretty sure the syntax given in the O'Reilly book was right.
and it would really make it easier to help solve your problems, if
Hi,
> I just installed the latest version of MySQL (3.23.38 I believe) from
> an RPM on Red Hat Linux 7.0. My question is when configuring
> PHP4 I need to include the --with-mysql= ? statement. Where
> would the correct file be with the RPM install. I have tried almost
> every directo
Hi,
> i am trying to import or export using MYSQL driver. that time it
> gives following error;
> "Access Denied For User '[EMAIL PROTECTED]' (Using password:YES)
did you give all the privileges manually through editing the grant
tables, or by the GRANT command (the right command should be some
Hi,
> we have to migrate a database from Lotus Domino (.nsf format)
> to MySQL. Is there anybody out there having had experience on
> this kind of job? Let we know, we are a bit .. desperate ...
the easiest way is to try to make SQL dumps from your current
database (Domino) and then work around
Hi,
> Tried doing isamchk on the .ISM files and got that following error
> The Exception Integer division by zero
> (0xc094) occured in the application at the location 0x0040224a.
getting such errors usually means you've got hardware (bad memory?)
or some serious software installation probl
Hi,
> I have a project which need to synch our mysql db with external
> Oracle DB.
> It requires that anytime DB admin modifies their Oracle DB, the
> change should be synched remotely with our DB in mysql. To make
> thing easy, we could use the same table structure on both end.
just a quick i
Hi,
> The server where the db was located got hacked and I had to
> reinstall the whole thing. The old HD is preserved as was
> and the server got a new HD. I moved the old db to the new
> disk and when I try to access it, I get the following error:
>
> mysql> use thedb;
> Can't read dir of '
Hi,
> I have some tables in the ISAM format in the database. The tables
> have the data, but whenever I do a select * from table_name, it
> returns an empty set for most of the tables. Whenever I do a
> count(*) query I get the total no of records.
try running isamchk (c:\mysql\bin\isamchk
Hi,
> mysql> use lumina;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Didn't find any fields in table 'absences'
> Didn't find any fields in table 'admins'
> Didn't find any fields in table 'classe
available without paying)
* ask for database name in the connection parameters or only
display the list of databases user has access to
Rgds,
Indrek
---
Indrek Siitan, CEO eMotion Ltd. [http
Hi,
> Table 1 is called: active_users
> Table 2 is called: deleted_users
>
> When "joe_smith" wishes to be deleted, I want to remove his entry
> from the active_users table, and place it into the delete_users
> table, with exactly the same information.
INSERT INTO deleted_users SELECT * FROM
Hi,
> TABLE: shop
> FIELD: article int unsigned auto_increment
>
> 1) insert into shop values (null);
> 2) select max(article) from shop;
for that purpose, you can use the mysql_insertid() function.
Rgds,
Tfr
--==< [EMAIL PROTECTED] >==< MySQL development team >==< T
Hi,
just #include "mysql.h" and when compiling, add
-I/usr/local/mysql/include/mysql flag to the compiler options.
Rgds,
Indrek
-------
Indrek Siitan, tegevjuht eMotion OÜ [http://www.eMotion.
Hi,
> I was looking to see the length or size of the BLOB data type in the
> manual and it is not listed. Does anyone know the size of BLOB?
> Also what is the largest number that can be stored in BIGINT?
you can find answers to both of your questions at:
http://www.mysql.com/doc/C/o/Column_ty
33 matches
Mail list logo
