Re: DECIMAL math?

Bill, - Original Message - From: ""Bill Todd"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, September 08, 2003 3:02 AM Subject: DECIMAL math? > Since DECIMAL fields are stored as strings how are calculations performed? > Does MySQL use string math routines or do

Upgrade from 3.22 to 4.0

I upgraded as stated in the subject, but my databases don't show up in mysql. The databases are still physically there, but mysql just ignores them. Apparently, it overwrote all my old system db data, because the users and privileges were gone too. I installed the binary version first, hoping th

MySQL research

Dear Sirs, We are Vietnamese students and both of us are interested in database. Therefore, we did choose our graduation thesis that is researching some DBMS and designing a small DBMS which is relyed on that research. SO documents about MySQL architecture, especially about its storing in disk an

MySQL studiers

Dear Sirs, We are Vietnamese students and both of us are interested in database. Therefore, we did choose our graduation thesis that is researching some DBMS and designing a small DBMS which is relyed on that research. SO documents about MySQL architecture, especially about its storing in disk an

mysql import log

Hi All, Can anybody tell me how can I get a log of my database import command. Sohail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Sharing between Linux and Windows

I've got a dual-boot computer running RedHat 9 and WindowsMe. Because I'm exploring different frontends for my MySQL database, I never know which OS is going to be up, so I was hoping to share the data between operating systems. I set them to point to the same directory (on the Windows partit

Re: fail to connect to mysql 4.1 server from older clients

At 16:05 +0300 9/7/03, Lior Nisim wrote: i run mysqld with "--old-passwords" switch ,and it didn't help How-To-Repeat: You probably added the switch after creating new-format passwords. --old-passwords is used to keep the server from creating new-format passwords. If you've already created them,

splitting tables based on row length

ok, i've got this table (20 columns). keeping in mind how/which web pages would access them, i decided to keep the last 7 in a different table, since that data would only be shown if they clicked on a link they were interested in (30-40% probablity). although, when they do view it, i'd retrieve all

DECIMAL math?

Since DECIMAL fields are stored as strings how are calculations performed? Does MySQL use string math routines or does it convert the string to a double and use the double for the calculation? The real question is, can floating point imprecision errors occur when using the DECIMAL type? Bill --

enum for bool in the future

hi i know this has been discussed before, storing bools in the right column type. in the case of enum as: enum("N","Y") or "n","y", etc. it might be easy to read when u're looking at the database table itself, but if u had to communicate this properly to other programmers designing a front-end, the

Re: Encrypt/protect Database

At 01:57 PM 9/5/2003, you wrote: This may be a weird question, but we were wondering if there was some sort of way to encrypt or protect the database just in case of someone hacking into the server it resides on. Since there might be some sensitive info in the database, we'd like to go to as great

Re: searching for %

On Sunday, September 07, 2003 10:27 PM CEST, Wayne wrote: > Hi All, > > silly question... does anyone know how to search for '%'? i.e. > overriding the normal wildcard use > > Wayne select anything from table where col like "...\%..." mysql manual: manual_Reference.html#Functions (i've just look

searching for %

Hi All, silly question... does anyone know how to search for '%'? i.e. overriding the normal wildcard use Wayne Wayne [EMAIL PROTECTED] http://www.Micromouse.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Fulltext Index and Unicode (MySQL 4.1)

Sergei Golubchik wrote: > On Sep 06, Andreas Schwarz wrote: >> Egor Egorov wrote: >> > Andreas Schwarz <[EMAIL PROTECTED]> wrote: >> >> >> >> is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) >> >> fields in 4.1? >> >> >> > >> > Nope. Fulltext search doesn't work with multi-byte

Re: Command not found

[EMAIL PROTECTED] wrote: > Here is another strange question: > > When I use "show databases", it shows me that I only have one database > called "test", and no database called "mysql" show up. > > However, I go back to the shell, under the "/usr/local/mysql/data/", it shows > me that I Do have

getting started on a SQL project

Hello, I'm new to SQL and trying to start out with a relatively simple project. I'm hoping someone can give me a few tips on how to accomplish my goal. I want to have a table for registered users reg_user (username, userID, password, email, status) I also want to have a table associated with each

mysqlbug

hello, previously is had installed a complete installation of apache/php/mysql but now i tried to install them all apart, but now i have the problem that when is try to start mysql i get this error: C:\Apache2\mysql\bin>mysqld-nt --standalone 030907 14:09:53 Can't find messagefile 'C:\phpdev5\

different select syntax in 4.0.xx?

Hello, I have just updated from MySQL 3.23 to MySQL 4.0.14. My operating system is Mac OS X (10.2.6). I have now encountered an odd problem with some "select" statements which appear to work differently in the new version: I want to do a join on two tables which are in two different databases

Fw: mysqlbug

i have fixed it! sorry (c:\my_cfg*) - Original Message - From: Richard Korebrits To: [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 2:15 PM Subject: mysqlbug hello, previously is had installed a complete installation of apache/php/mysql but now i tried to install them all apart

fail to connect to mysql 4.1 server from older clients

i run mysqld with "--old-passwords" switch ,and it didn't help >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization:Intel LTD >MySQL support: none >Synopsis: connection fail Severity: critical >Priority: high >Category: mysql >Class

Fw: CREATE TABLE and CHECK Clause

sorry, it's only for testing Kraan Deufe even more than Kojak - Original Message - From: Kraan Deufe To: [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 1:07 PM Subject: CREATE TABLE and CHECK Clause ok here we are, first of all, hi to every one since i'm new to this list. then

CREATE TABLE and CHECK Clause

ok here we are, first of all, hi to every one since i'm new to this list. then it's my first real advanced experience with mysql, even if i've already used SQL Server, PostgreSQL and (kof kof) Access. well, then i'm trying to create a heavy database with many relations and check clauses. An

Problem with MySQL 4.0.14 - Server Crash

I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. MySQL always crashs with error 11 Segmentation fault. I don't know why but I try to dump database (about 200,000 lines) and install MySQL 4.0.14 windows version and try to import database again to MySQL windows ve