MySQL Database Forum

Hi, I got a forum on my website .... it;s located in 2 databases: 1 for the topic names and one for the text and user info: the first has 20371 entries ... the second 2124 CREATE TABLE `forumtext` ( `id` int(5) NOT NULL auto_increment, `text` text NOT NULL, `naam` varchar(100) NOT NULL default '', `email` varchar(100) NOT NULL default '',...

Hi, I got a forum on my website .... it;s located in 2 databases: 1 for the topic names and one for the text and user info: the first has 20371 entries ... the second 2124 CREATE TABLE `forumtext` ( `id` int(5) NOT NULL auto_increment, `text` text NOT NULL, `naam` varchar(100) NOT NULL default '', `email` varchar(100) NOT NULL default '',...

--Apple-Mail-2-720579055 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed when I enter: cd /usr/local/mysql sudo chown -R mysql data/ sudo echo

--Apple-Mail-2-720579055 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed when I enter: cd /usr/local/mysql sudo chown -R mysql data/ sudo echo

Hi all I have some data in Excel ( I didn't put it there - a customer did ). I'm setting up an import routine for it, with an Access front-end. I don't like the way Access imports Excel files, though, and I'm thinking about getting the user who will import it to first open the spreadsheet and save it as a csv file. Then I'll use...

Hi all I have some data in Excel ( I didn't put it there - a customer did ). I'm setting up an import routine for it, with an Access front-end. I don't like the way Access imports Excel files, though, and I'm thinking about getting the user who will import it to first open the spreadsheet and save it as a csv file. Then I'll use...

Where is the list of full options in my.cnf? I am looking for the full list of options in my.cnf. Where can a detailed list be found in the documentation?

Where is the list of full options in my.cnf? I am looking for the full list of options in my.cnf. Where can a detailed list be found in the documentation?

Hi all. Another question... I'm trying to diagnose a problem I'm having with MyISAM tables, and it was recommended that I use the binaries instead of compile MySQL myself. I noticed the binaries have 'i686' in their name. Does this mean they are optimised for an i686, or will only work on an i686? I have a K6-2 which only likes things...

Hi all. Another question... I'm trying to diagnose a problem I'm having with MyISAM tables, and it was recommended that I use the binaries instead of compile MySQL myself. I noticed the binaries have 'i686' in their name. Does this mean they are optimised for an i686, or will only work on an i686? I have a K6-2 which only likes things...

Here's the situation: I have a Perl-based forum that I wrote myself. It currently supports user accounts, but these are stored in a flat text file (as is everything else for that matter). I'm looking to convert this to a MySQL database so that I can do more with that information, but with less processing time (reading through that huge text...

mysql> CREATE DATABASE csttrainrep -> ; ERROR 1044: Access denied for user: '@localhost' to database 'csttrainrep' mysql> GRANT ALL ON csttrainrep. TO helen -> ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TO helen' at line 1 mysql>...

Folks, When creating a table, is there any advantage in specifying the columns in any special order? For example, what about columns with data used more frequently listed first, or column/data types giving some? Or.... am I being pedantic even thinking about such? All help is much appreciated, thanx randelld

Hi, I want to store jpg files to BLOB field of a table. That table has other fields which are integer and char types. So i tried inserting image using LOAD DATA INTO ...... statement . It got stored , but when i retrieve it back , i'm not able to see the image file.I hope it didn't get stored in proper format. How do i acheieve this ??...

------=_NextPart_000_004F_01C34CC0.ACC94810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI! I have problem to download=20 http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip=

------_=_NextPart_001_01C34D0C.B261DC50 Content-Type: text/plain; charset="iso-8859-1" Hi there Quick and simple question. Does the windows version of Connector/J run under Windows NT, the documentation implies only 9X and ME

Thanks a lot, that solved my problem! Moritz -----Urspr=FCngliche Nachricht----- Von: Egor Egorov =20 Gesendet: Freitag, 18. Juli 2003 10:16 An: mysql@lists.mysql.com Betreff: Re: WG: wait_timeout in my.cnf

Hi, I'm having a problem with decimal places in an ecommerce website. I have insterted the prices for products into the DB and set the decimal places to 2. The problem comes when I enter a number such as 1.50 which then becomes 1.5 in the database. This isn't a problem with my code as if i manually insert the same figure, the result is the...

------=_NextPart_000_0039_01C34D4C.F19F7B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, =20 i am unable to install mysql 4.0 on my Rh. 6.2 box. i have glib 1.2.6. When try to install the mysql it gives the message "Mysql-server-version no.cannot be

------=_NextPart_000_0039_01C34D4C.F19F7B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, =20 i am unable to install mysql 4.0 on my Rh. 6.2 box. i have glib 1.2.6. When try to install the mysql it gives the message "Mysql-server-version no.cannot be

Hi All, I am managing a small database where a few fields are defined as being of type text. In my understanding, this would allow the user to enter up to about 65,000 characters in the text field. However, if the user types about 2,000 characters, then nothing is entered in the database. I have checked the max_packet_allowed and the...

Hi All, I am managing a small database where a few fields are defined as being of type text. In my understanding, this would allow the user to enter up to about 65,000 characters in the text field. However, if the user types about 2,000 characters, then nothing is entered in the database. I have checked the max_packet_allowed and the...

------=_NextPart_000_0024_01C34D0E.474DFC80 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable I've been through the mysql doc for the C API in both mysql 4.0 and 4.1, = but I don't see anything that explicitly supports non-blocking and/or cancel-able operations. For example, the mysql_real_query API...

------=_NextPart_000_0024_01C34D0E.474DFC80 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable I've been through the mysql doc for the C API in both mysql 4.0 and 4.1, = but I don't see anything that explicitly supports non-blocking and/or cancel-able operations. For example, the mysql_real_query API...

--=_9CC2B6D0.7C1D6E08 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello all, I have just finally finished my error free installation of mysql 4.0.13 on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced Server.