Re: intersting bug with full text match against

i have also noticed that the boolean default is OR how can i explicitly set it to AND like i'd like both exact matches in the search currently its exact match 1 or exact match 2 :| Daniel Rossi [EMAIL PROTECTED] 05/29/03 01:23pm i am getting people to try and break a search engine i built

Mysql 4 search features

Hi guys i messaged before regarding mysql 4's search capabilties, i am doing up a scope for a tape library database change over from access , there is 100,000+ records, i am trying to find the most effiecient way to build the search capabiltiies, there will be fields like title, tx date,

RE: MYSQL Newbie

you probably want php which intergrates into mysql nicely, as mysql being the database for the content, http://www.php.net/ http://www.phpbuilder.com/ there is also some links on the php site u might want to check out http://www.php.net/links.php with mysql you prob want to master the sql

Re: external connection

do? Frederic Lecul Have you reloaded the grant tables? You have to do that when you alter / add users / permissions etc. mysqladmin reload -p -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2

Re: external connection

with the mysql command-line client: mysql -h HOSTNAME -u USERNAME -p See if that gives any errors, and if so post them also. It's a bit hard to say where the problem is otherwise. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2

Re: external connection

if you tell us what grant commands you've used so far. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com -- MySQL General Mailing List

intuitive searching in mysql4

ok so we can ingore the last message i've finally convinced that mysql 4 will be the best option for the searching, i am moving over an access database of a tape library which is 100,000 records. this is pretty massive search wise , what could be the best way to go about this , we have a title,

table structure design

is there any table structure design program in a graphical layout for windows available ? i have tables and fields on paper but would like a way to be able to lay them out on a screen and show which table joins to what and what keys it uses let me know thanks -- MySQL General Mailing List For

Re: Can we make some C, Java based Mysql App Server

hmm a middleware product would be good , extra processing=time ? also stored procedures would be excellent , also maybe a middleware product to load balance between slave and master and delegate slaves if a master goes down is there such a thing ? Nitin Nanivadekar [EMAIL PROTECTED] 04/03/03

useful use of transactions

hi guys , i am trying to sort out if the app i am about to build would require the use of transactions, there may be a few users simultanously entering data, but possible not updating the same data and maybe a lot of users accessing the data (search/select) , will this require some form of

RE: What port to forward ?

i'd also like to know this as i've tried to access the local db which is the the lan server aswell , i have a firewall iptable script running on it and i cant seem to connect using mysqlcc = Original Message From [EMAIL PROTECTED] = Well, I have a firewall on my LAN, but need to have

Re: compiling issue

woah let me get it straight , u are compiling on a RH 6 machine to be installed on a RH 7 ? why not compile and install on the same machine , i really cant say if it makesd a difference but they do have different kernels and are years apart , i've had no trouble whatsoever compiling and

get table name from select staement as output as field

hi guys is this possible ? select tablename1 as table1, id from tablename1 , tablename2 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql scripts

Hi all, I have a question about mysql client. How can I use it in such a way that it just executes a script on a specified database and then exists? Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Serial column type

John Griffin wrote: Has anyone got a way to implement column type 'serial' in a innodb table? -jpg int unsigned not null auto_increment -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922

two order by fields

hi guys is this possible ? order field1 and order by field 2 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: two order by fields

heh i've never tried it ?? all this bloody time = Original Message From Paul DuBois [EMAIL PROTECTED] = At 13:34 +1100 3/28/03, Daniel Rossi wrote: hi guys is this possible ? order field1 and order by field 2 ? Perhaps, depending on what you mean. Did you try ... ORDER BY field1, field2

Re: Soon?

ooo thats sounds like something to avoid , if the compiling doesnt even work dont go there, painful Martin Gainty [EMAIL PROTECTED] 03/28/03 09:38am Hej Michael- In order to to see 4.1 mysqladmin working I started to compiling the 4.1 source obtained from bitmaker Originally I had 1000

get the table name from a field for 3 different tables

hi there i would like to find out how to get the table from a field if i am joining three tables together for instance select a.id, b.id, c.id from a, b, c when i get the results i need to be able to get the table name a if i get the result from a.id , is it possible ? -- MySQL General

Re: Cannot Restore MySQL 3.23.37 dump to Mysql 3.23.55

to the current table to make the import happy. If you don't know what it was, just make it varchar(100) or something, then drop it after the import if you don't want it. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922

RE: IN and comma delimitered id's

wicked thanks heaps this worked select * from User where userID=3 AND FIND_IN_SET(34, site_access); your a champ ! Don Read [EMAIL PROTECTED] 03/24/03 03:02pm On 24-Mar-2003 Daniel Rossi wrote: hi there i have a field which i place comma delimitered id's like so 64,14,13,15

IN and comma delimitered id's

hi there i have a field which i place comma delimitered id's like so 64,14,13,15 these are site id's which i check against a user who has access, i also use it to check if to show a banner on a particular site, although further checking showed that say i did a select * from table where

Re: access-myodbc-interruption_mode?

and not MySQL / MyODBC. Maybe it's even intended... -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

CFLAGS=-march=k6 ?

of my CFLAGS. So is it safe? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Re: Fw: problem about bulk insertion

; -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting

Re: Trouble upgrading to 4.0 on Mandrake Linux

in /var/lib/mysql somewhere Anyway, look for your_hostname.err somewhere. Probably you don't have directory permissions set up properly. See the INSTALL-SOURCE file for details of how to set the permissions. It's around 20-30% through the file. -- Daniel Kasak IT Developer * NUS Consulting Group

Re: AW: EMS MySQL Manager for Linux 1.15 released!

attention on real spam. There's plenty to go after without taking things out on people providing software for our favourite database. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email

Paul, do you address this in any of your books?

this with sql only, would it be able to do it once subselects or other features are available in future releases? Anyone used postgresql? I wonder if it could handle it. Any thoughts? Thanks, Daniel - Before posting

I want sql query result with userid 1st col followed by 1colum for each date all corresp numbers

other add on programming language? Does anyone have a canned sql example for this type of situation? Can you think of any key phrases I can use to search for sql solutions to this type of problem? Any idea if this type of problem has a particular name? It seems kind of basic. Thanks, Daniel

Master (pc) Slave (laptop) Replication

the slave is not connected, How to I sync up the slave ? (without dumping the db or creating a snapshot) mysql - master = 3.23.33 mysql - slave = 3.23.52 Thank you, --- -Daniel Negron

Re: Master (pc) Slave (laptop) Replication

in it, it replicates with no problem. is there anyway to force a sync ? Thank you, --- -Daniel Negron // \\* / _ __ ___ \Lotus Notes Admin / Developer

RE: inquiry

have u set the pass or is it correct ? usually mysqladmin -u root password newpassword then mysqladmin -u root -p create sample_db = Original Message From Philip McCarthy [EMAIL PROTECTED] = Dear mysql I have just downloaded mysql 3.23 for Windows and I am running XP. I have

License

Hi all, If I develop a software for my company that works with MySQL and this software will be used only inside the company, do I have to purchase commercial license? Thanks, Dan - Before posting, please check:

Thist script does not run

Hi all, I am trying to run this script below on a MySQL-4.0.11-NT server. It stops at the UserLogs table, but if I swap the last two tables' creation order, it runs correctly. Can anyone help me with this? Thanks Dan /* Begin */ CREATE TABLE `Branches` ( `Id` int unsigned not null,

Thist script does not run 2

Hi all, Sorry, I forgot to tell, that my default table type is InnoDB. I am trying to run this script below on a MySQL-4.0.11-NT server. It stops at the UserLogs table, but if I swap the last two tables' creation order, it runs correctly. Can anyone help me with this? Thanks Dan /*

Re: mysqldump and InnoDB tables

started at 1. Maybe when mysql gets told to put a zero in there it assumes you want it to auto-increment. Dunno. Never tried it. Do you have quotes around the zero? Thanks very much for any help. 's OK -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney

Re: Temporary Tables

or does MySQL provide a timestamp (or use some other means) to identify the tables? I believe MySQL uses the client's connection ID (which is unique) to identify the temporary table. You don't have to use different names, no. Cool, eh? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18

Re: Temporary Tables

instance of the script screwing with the 1st. If you have some form of unique identifier, then append it to the table name. Otherwise consider creating your own (and testing for it's existance before using it) and appending it to the table name. -- Daniel Kasak IT Developer * NUS Consulting Group

What's up with this query?

to select into a tmp table first, and then back into the original... So do I? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Re: What's up with this query?

Daniel Kasak wrote: Hi all. Hi spam filter. SQL. Query. I'm trying to append data to a table ( Powertel_CCD_LineList ) if it doesn't already exist in the table: insert into Powertel_CCD_LineList ( AccountNo, ServiceNumber, ServiceNumberDescription ) select Powertel_CCD_CallDetails.AccountNo

Re: libmysql.dll(v4.0.10) + delphi 7 + dbexpress

libraries with the new server, but as you noted, new features won't be available. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

RE: problem: Loosing .MYD Files

of the same 3 tables, missing. I will try fix the filesystem and see what happens. Thanks for your help! Sincerely Daniel -Original Message- From: Joshua J.Kugler [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:41 PM To: Daniel Geske; Jerry; [EMAIL PROTECTED] Subject: Re: problem

Re: rollback a table?

-zcvf backups_$DATE.tar.gz backups echo Backup of MySQL databases complete! -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

problem: Loosing .MYD Files

Daniel Geske - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

RE: problem: Loosing .MYD Files

from you soon. Sincerely, Daniel Geske -Original Message- From: Jerry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 10:25 AM To: Daniel Geske; [EMAIL PROTECTED] Subject: Re: problem: Loosing .MYD Files Have you done anything to the files by hand ? I used to get this when

SPAM

receiving posts? He's adding EVERYONE who posts to his spam lists. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Re: List of Tables

be GREATLY appreciated. Jeff Pearson I use: use DATABASE_NAME show tables -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Problem Editing mysql Text field

Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I

Re: Problem Editing mysql Text field

This is weird, all of a sudden it starts working, if it happens again though I will try another front end. Thank you for your advice Thank you, --- -Daniel Negron

Re: 4.1 Self Compiled Problems

be a problem that existed on that day, or maybe just me... -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Formatting SQL in Access

-line into my queries so they look pretty? Thanks in advance! Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Re: Formatting SQL in Access

Daniel Kasak wrote: Hi all. Hi spam filter. SQL. Query. I'm writing some code in Access 2002 which builds an sql string and then saves it as a pass-through query. I would like to be able to build in some new-line characters or something so that the query is nicely formatted so that when I

Re: Licence Free Import/Export for Access?

to/from MDB files without using the Access tool. I saw *someone* talking about this sort of thing. Hm. Let me search my email Have a look at this: http://mdbtools.sourceforge.net/gmdb/gmdb2screenshot.png Might be what you need. -- Daniel Kasak IT Developer * NUS Consulting Group* Level

RE: RAND is mysql 3.22

hi guys i just tried this on my works old mysql server and it doesnt seem to work , is it possible ? :| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Counting null values

Hi Octavian, Try this: select FieldName, count(*) from TableName group by FieldName Bye, Danny At 16:39 2003.02.08._+0200, you wrote: Hi all, I have a table where I have something like this: | abc | | abc | | xxx | | null | | null | | null | I want to count these lines to give the

Re: date issue

: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Daniel Rossi [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 03, 2003 12:58 PM Subject: Re: date issue Daniel, (you posted this question twice, but I will only answer it once ;-) have a month string January from a get query string

RE: date issue

(Berlin) [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 6:59 AM To: Daniel Rossi; [EMAIL PROTECTED] Subject: Re: date issue Daniel, (you posted this question twice, but I will only answer it once ;-) have a month string January from a get query string like so ?month=January

date issue

hi there i am having an issue formatting a date string back to mysql for a query, say i have a month string January from a get query string like so ?month=January , and i need to check a range of results within an endate so i need WHERE end_date $_GET['month'] , how can i format the month

date issue

sorry if you may get this twice, my work is persistant to not give me newsgroup access and their email server is shitty and slow , i think being on novell heh anyway here is the message. hi there i am having an issue formatting a date string back to mysql for a query, say i have a month string

Re: Access XP crashes regularly when linked to MySQL via MyODBC

the bug is in Access. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Re: Access XP crashes regularly when linked to MySQL via MyODBC

;-) -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting

RE: sub select , distinct and mysql4

hi guys i was wondering if sub selects were possible in mysql 4 ? more specifically , whenever i do a join , i sometimes require a distinct select on the field in the first table and the second table may have many rows therefore returns the same value more than once from the first table which

RE: how to get the Nth record of a result ?

will a LIMIT start,end work ? = Original Message From alx [EMAIL PROTECTED] = HI all I'm trying to get the Nth record of a query which i don't know nothing but the table name. I mean something like select * from table where condition . give me the Nth result; I hope someone can help

RE: Need the PHP gurus for this one...

maybe its best to echo your entire query string and post back as $searchType could be anything , also a good way to check your query , is echo your query string then do an sql query in phpmyadmin. = Original Message From Lane Johnston [EMAIL PROTECTED] = Ok php gurus, Little info on

4.1 features

Hi all, Can anyone tell where can I find some documentation about the new features released in MySQL 4.1? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: How2unsubscribe?

on the list in the first place? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Problem using the C-API for MySQL Program breakdown after about 1Mio SQL-statements

I checked the SQL statement which is sent at that time an it is ok and leads to suitable result. Does any one have an idea why my program breaks down ? Greetings, Daniel P.S : Here is my code for accessing the database : (some code. ) mysql2 = mysql_init(NULL

Mysql Error

to connect at all. Is it possible to remove MySql (and how do I go about it) so that I can reinstall it again? Sorry if these are stupid questions, but I can't seem to find how to uninstall MySql in the manual. Thanks -- Daniel Florian [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL

Re: Problem using the C-API for MySQL Program breakdown after about1 Mio SQL-statements

Thanks for your advice. I tried it with the higher value (3M) but the program broke down like before. I increased the other buffer values too after that and am testing now if this helps. Greetings, Daniel Gelu Gogancea wrote: Hi, Maybe it's a good ideea to increase the value

Re: mysqldump file fails to recreate database

- and these people will be the least able to diagnose the problem. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Bug Report: Restrictions on index naming

to get the index there), or is it considered too expensive to do these kinds of checks? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Re: Question or Wish feature

If mycommand.CommandText = sqlstr mycommand.Execute End If myconn.Close Set myconn = Nothing Set mycommand = Nothing End Function -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED

InnoDB on update cascade

Hi all, Does anyone know why 'on update cascade' option does not work in InnoDB foreign keys? Is it supported anyway? Thanks, Daniel mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: tracing ips

i've looked into this , HTTP_X_FORWARDED_FOR should get actual client ip's behind a proxy but some proxies dont send this which is a bugger or it would be a goer , i also need to know how = Original Message From Alex Behrens [EMAIL PROTECTED] = hey everyone, Kind of an OT subject, but

Re: Update Year of Date Field using sql statement

, but brackets usually indicate a function. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

mysqlgui, win32, delete keypress on table row in results window hangs.

Using: Win32 static binary of MySQLGUI 1.7.5-2 on win98SE Mysql 4.04-beta serving on win2000 run MySQLgui select * from test; displays table correctly in mysql results window -click-select a row in the MySQL results display -press the delete key (intent is to delete that row) -hang,

Re: table myisam and roll back?

CN YEONG wrote: Hi, May I know that if it is posibble to roll back the sql query automatic if the sql query get error by using myisam table type and not using innodb type? Thank for help. No. You need to use a transactional table handler, like InnoDB. -- Daniel Kasak IT Developer * NUS

Re: No descending index ?

everyday). With ascending index, mysql doesn't use it. My current trick is crawling back (ie 1 month) and forward (if any in that month), but this is really annoying. Any plan / trick for this ? TIA. Tertanda, Oguds [36856104] ??? What's wrong with using: order by MyIndex DESC -- Daniel Kasak

Re: No descending index ?

Mpu Gondrong wrote: Selasa, 17/12/2002 7:38:52, Daniel menulis: DK What's wrong with using: order by MyIndex DESC If I have 100 rows and mysql calculates with desc got 90 or more (30%) rows, index won't be used. I have thousand rows, and just want to get the last row. Without index

Re: ODBC query freezes server

for ADO - you'll find plently of examples. Note that using Access to query MySQL over the internet isn't exactly secure. Someone correct me if I'm wrong here, but doesn't this send clear-text passwords across the internet? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker

Addendum to the MySQL 3.23.54 release

I get an error after adding the test bit: /usr/local/mysql/bin/safe_mysqld: 5=nice --5 nohup: command not found - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Different thread states in 3.23.54

Hi. Version downloads/mysql-3.23.htm3.23.54 seems to run the mysqld processes in the SN state (as opposed to S state that the previous versions did) - negative nice values. There is no reference to anything like this in the change logs - any reasons why? Please cc reply to my email address.

Re: LEGAL information about MySQL.

MySQL and PostgreSQL and MS SQL for the same task as alternatives. In this case your purchaser don't need to buy any MySQL licence to use it. So this is how I interpret the licence stategy of MySQL AB. Please correct me if i have mistaken in something. Bye, Daniel At 10:41

Re: OBDC and MySQL 4.0.5a

) and compile install with --without-server. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

warning database is running out of disk space

out of space? Thanks Daniel Ziener - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: Building Web Pages

Date: Tue, 10 Dec 2002 11:38:40 -0800 From: Grant Cooper [EMAIL PROTECTED] Subject: Building Web Pages To: MySQL mailing list [EMAIL PROTECTED] Message-id: 000a01c2a083$bfe3c310$040a0a0a@donatev49iknkl MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1

Re: How to get MySQL to list current db's ?

Hi, At 11:35 2002.12.09._-0500, you wrote: Is there a way to ask MySQL to list the db's that are currently created? Yes: SHOW DATABASES Good luck, Daniel - Before posting, please check: http://www.mysql.com

mysqladmin shutdown leaves stray processes (repost)

mysql root@vortex:/usr/local/mysql/var# kill -9 7859 7895 root@vortex:/usr/local/mysql/var# MySQL was compiled with the recommended flags (from the INSTALL-SOURCE file). It's running on a stock Slackware 8.0 install with a 2.4.19 kernel. Any clues? Anyone else having this problem? -- Daniel Kasak

RE: mysql and php

this is a vague one , would be good to copy and paste the php debug message = Original Message From Jerry M. Howell II [EMAIL PROTECTED] = Hello all, We are leasing a dedicated server and seem to pe having problems getting our php script working with mysql. The script was working fine

RE: I don't understand this error!

INSERT INTO comment_lines VALUES('02075030009219','09','20','35','N',' ','3',''); try that u didnt seem to have quortation around the 3 = Original Message From Freedom Advocate [EMAIL PROTECTED] = This is the command I am having problems with and the error that I am getting.

RE: I don't understand this error!

INSERT INTO (comment_lines) VALUES('02075030009219','09','20','35','N','','3',''); maybe even that = Original Message From daniel [EMAIL PROTECTED] = INSERT INTO comment_lines VALUES('02075030009219','09','20','35','N',' ','3',''); try that u didnt seem to have

a little help please

the respetive file: mysqlcc-0.8.6-win32.zip. thanks for your collaboration. Carlos Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: using Delphi with MySql to store binary data

to the parameter from the cursor to the end of the stream. (you can use .LoadFromFile method the same way). Then you can just execute the query. Good luck, Daniel p.s.: You must do it the same way in case of any SQL servers. At 07:34 2002.11.28._+0200, you wrote: Hi, I would like

Quick Nasty upgrade...

a 'make install' and then dump my old /usr/local/mysql/var directory on top of the new one and all will be OK? I am using MyISAM and InnoDB tables. Or should I use the 'safe' method of backing up with mysqldump and importing into the new install? Thanks! -- Daniel Kasak IT Developer * NUS

Where is 4.1 source

Hi all, Where can I download MySQL version 4.1 source code? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Help me optimize my query

before spamming the list with advertising. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com

Re: importing form a file (question)

mysql through the console. mysql backup.sql -p You may want to drop the tables before running the script, as it will re-create the tables. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989

question about Sum()

'' (nothing) I expected to be 0, but it's not. And because of that I need to convert this through code. Is that anyway to force Sum() to return 0 if nothing found? Thanks. Daniel - Before posting, please check: http

Version 4.1

Hi all, I would like to know when MySQL version 4.1 will be available for windows as compiled install kit? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Unable to connect, Connection lost during query. Solved

for it :) I didn't see anything in the doc's about MySQL using the hosts.allow/hosts.deny. Umm query,sql Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

<    5   6   7   8   9   10   11   12   13   14   >