LOAD DATA INFILE with space after quote but before comma

I ran across a curious issue, I'd call it a bug but I'm sure others would call it a feature. I have a csv file with space between the " and , and it causes MySQL to eat that field and the field after it as a single field. Is there a setting I can use to remedy this or do I just have to make sure n

MySQL dying?

I have heard that due to Oracle taking over, the OS community is shifting to other type of DB's . Any thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: best way to have a unique key

Although I did berate you for your obvious cheek, I will of course complement the acuteness of your response. On 1/20/2011 2:10 PM, Anthony Pace wrote: Dude, come on. I know that all primary keys have to be unique; however, I was obviously referring to the use of uuid over auto

Re: best way to have a unique key

I know of uuid() my problem is that there can be conflicts when copying the DB to a different machine, or working with sections of the db on different machines for load balancing. On 1/20/2011 1:44 PM, Krishna Chandra Prajapati wrote: > Please keep in mind this variable will also be displayed

Re: best way to have a unique key

your current employer. Neither MySQL nor any other RDBMS will allow you to establish a primary key that is not unique. - michael dykman On Thu, Jan 20, 2011 at 1:32 PM, Anthony Pace wrote: Due to certain reasons, the company I am doing business with has decided that the primary key, for an

best way to have a unique key

Due to certain reasons, the company I am doing business with has decided that the primary key, for an orders table, be a unique key; however, I don't like the possibility of it conflicting if moved to another machine. What are some pitfalls of using a unique key, that is generated by a server

Prevent user from changing passwords?

sword? -- www.suave.net - Anthony Ball - a...@suave.net -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Excuse me. Haven't we met somewhere before? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?

Does the order of tuples in a bulk insert impact query performance?

Does the order of tuples in a bulk insert impact later query performance? E.g. will sorting the rows before a bulk insert cause queries to perform better for indexed or non-indexed fields? Thanks, Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Re: Could not start the service MySQL:Error 0

Try looking in Control Panel->Administrative Tools-> Services and deleting all the MySQL services.

Re: Could not start the service MySQL:Error 0

I suffered the same problem, and the following worked for me: http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/

Mysql Web interface for normal Users

Hello, i am looking for a simple Web interface, for normal users (non admin), that will only have access to their Database, and have the possibility to manage their tables (create,delete,insert,...). for root access, i already have phpMyAdmin installed on the server. -- MySQL General Mailing

Field name DESC

Hello, i want to know how i can create a table with the feild name "desc" ? when i do: CREATE TABLE bank ( name varchar(50) NOT NULL default '', desc varchar(50) NOT NULL default '', ) the desc is badely interpreted... -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: can't start daemon

i actually don't have anything valuable in my database, it's on my home pc. I upgraded with the standard procedure. On 6/17/06, Dan Trainor <[EMAIL PROTECTED]> wrote: Anthony Ettinger wrote: > I just upgraded to mysql 5, and can't restart the daemon. > > > 0606

can't start daemon

1:57:43 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:43 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. -- Anthony Ettinger Signature: http

Re: MySql GUI

Chris Sansom wrote: OK, so I suggested phpMyAdmin. Dan Trainor said: I highly suggest staying away from PHPMyAdmin. and, even more helpfully, 'Anthony' wrote: :-\ Fine - from this I gather php

Re: MySql GUI

Dan Trainor wrote: I highly suggest staying away from PHPMyAdmin. :-\ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: remotely show databases

------- > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Ettinger > Sent: Tuesday, 10 January 2006 9:33 AM > To: Logan, David (SST - Adelaide) > Cc: Mikhail Berman; mysql@lists.my

Re: remotely show databases

On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > Hi Anthony, > > If you are accessing the db from perl, just execute a show databases > from there using the DBI interface. There is quite an amount of doco > about this and other features at cpan.org

Re: remotely show databases

'SHOW DATABASES;' | mysql -u foo -h bar.com this works, I haven't tested it with other databases though. On 1/9/06, Mikhail Berman <[EMAIL PROTECTED]> wrote: > > Hi Anthony, > > I am not sure if you have an installation of MySQL on your local server. > If you

remotely show databases

run "SHOW DATABASES"; I tried $man mysqlshow, but didn't see any easy way of simply returning a \n seperated list of databases. Any suggestions? I also need to do this for postgresql if anyone else knows of a standalone app that dumps the databases for a specific user. -- Anthony

Re: mysqldump: Got errno 32 on write ?

Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > --- > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Beh

Re: mysqldump: Got errno 32 on write ?

Turns out I forgot the gzip > filename, only had | gzip filename. But the real problem here is I'm getting packet loss and loosing my connection, which is probably why I get that error 32. On 1/5/06, Anthony Ettinger <[EMAIL PROTECTED]> wrote: > > I am, I'm running a

mysqldump: Got errno 32 on write ?

"mysqldump: Got errno 32 on write" -- any ideas? I think it may be mysqldump is not run as user, because dump dir is 0700?? -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html

Re: cannot connect to database

-- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html

Re: Trojan Horse in MySQL

File is: C:\mysqldata\erqed.dll > > Anything known about this? > > please reply to [EMAIL PROTECTED] > > Gary > > -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html

Re: optimizing mysqldump

Horpak.com/air - > > แหล่งรวมผู้ให้บริการติดตั้งเครื่องปรับอากาศ > > http://www.EasyHorpak.com/internet - > > แหล่งรวมผู้ให้บริการติดตั้งอินเตอร์เน็ตในอพาร์ทเมนท์ > > http://www.EasyHorpak.com/software - แหล่งรวมโปรแกรมสำหรับอพาร์ทเมนท์ > > http://www.EasyHorpak.com/mo

optimizing mysqldump

ase backup tool, and I do not have direct access to the database server to run it locally. -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html

Joining data from two databases

Hi, I have one database that I would like to split into two.. Well actually my client does.. I don't think we should. But, is there a way to join data from the seperated databases? One table authors will be connected to a table called contacts each residing in different databases on the same ser

RE: what is causing these XX.1.1.1.1 logs?

om: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 12:17 PM To: Ciarochi, Anthony; '[EMAIL PROTECTED] ' Subject: RE: what is causing these XX.1.1.1.1 logs? Are you in the process of stopping and restarting the MySQL Database server? -Original Message----- From:

what is causing these XX.1.1.1.1 logs?

For some reason, I am getting hundreds of zero-length binary log remnants in my log area. Any idea what could be causing this? Is there any danger in deleting the logs that don't show up in 'show master logs'? show master logs output: mysqld_bin.058 mysqld_bin.059 bash-2.05b# ls -altr |

ADODB.Connection - How do I open a DB, create if not there, open table, create if not there and add a single record?

This should be simple, no? I can't make it work Objective: - bring up a panel to ask for MySQL User/Host/Password and save settings if we get logged in. - when we start (likely on a new machine) create a new Weather DB if it doesn't exist - when we start ("" """) create a new TimeTable tabl

Spanish Accents

Hello, I am building a web page using Windows 2000 Server, IIS 5.0, ASP (with vbscript) and MySQL database with MySQL Connector/ODBC. The content of this web page is in Spanish thus the database will contain letters with Spanish accents. My problem is that the Spanish characters are not displ

CRN Has A MySQL Poll...

...on the front page: http://www.crn.com/ Not that I am recommending we stack the poll or anything... :) -- Anthony L. Awtrey Vice President __ I.D.E.A.L. Technology Corporation - Orlando Office http://www.idealcorp.com - 407.999.9870 x13

RE: How to 'customize' GROUP BY?

you would need to create a temporary table. So lets say you want to check 'id' column for highest value, you would do the following: CREATE TABLE tmp SELECT MAX(id) AS max_id FROM tbl; SELECT * FROM tbl WHERE tmp.max_id = tbl.id; Another approach would be to use an SQL variable, again if you want

sorting using substring

I am trying to write a query that will sort results using one or two substrings in item number. So for example I have item numbers that start with SE, TS, N0, W00, etc. So let say I want results sorted in the following order TS, SE, N0, W0 I have tried the followi

Re: Populating a Table with Data by Inserting a Textfile

Stephen Tiano wrote: What I'd like to do is create a textfile and then import the whole thing into a table. So, naturally, I've a few questions. Do I need to include the column heads as a line in my textfile, or can I simply go straight to the data? No ... you can simply go straight to the data

Re: Loading a flat file

MyWeeklyLeads.com wrote: I have a flat file that I am trying to load to a MySQL database (fixed-length fields). When I try: LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable It is generating a ton of errors, but the end result is that it's populating only the first field for all records and al

non-root users cannot run mysqlimport

Hi, I need to periodically load a dumpfile from another DB into mysql. Now, since this is a cronjob, and for which I would need to avoid interactivity, I DO NEED to run this as a non-root user. I have setup such a user, and have granted the user all on the destination database. The user also has

Two problems

1) Windows ME seems incapable of applying passwords to usernames. On my webspace, I can only log into the SQL database if I include the password. On my WinME PC, only if I do NOT give a password. 2) Using the Opera browser, I open my pages and it sends variables through "?var1=value1&var2=val

need help with select statement

I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time | time | YES | | NULL | | | object | varchar(40) | YES | | NULL | | | observing_site | varchar(40)

function question

Hi, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Thanx for the info Anthony -- MySQL General Mailing List For

Re: join error

Hi, I saw the error. For interested it is in the place.latitude BETWEEN section Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

join error

n( radians( 33.00 ) ) + cos( radians( place.latitude ) ) * cos( 33.00 ) * cos( radians( - 96.00 - place.longitude ) ) ) ) <= 250 AND table1.id = table2.id AND table2.id = table3.id AND table3.id = table4.id AND table4.id = table5.id AND table5.id = place.id Any

Re: Join question

Hi, what is the difference between your way and Mike Hillyer way?? (I can see the INNER join). But thanx to both of you. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql language

Hi, I was looking in what language what myslq written in? Just curious Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join question

here table1.cl1 = 1 and table1.cle2=5 and table1.cl3 IN(1,2,5,8) Join Select id from table2 where table2.cl1 = 4 and table2.cle2IN(10,12,81) and table2.cl3 IN(3,7) Join Select id from table3 where table3.distance BETWEEN 1 and 99 where table1.id = table2.id=table3.id Any help is appreciated Antho

load file

Hi, I have a a text file delimited with | and I don't how to load the data into a table and say delimited by '|' I think it is this: LOAD DATA INFILE 'C:\data.txt' INTO TABLE table2 FIELDS TERMINATED BY '|'l Any clarification would help. Anthony --

good or bad?

zip range longlat longlat 8 NULL 4323 where used What do you think? I can't really read that eventough I tried to go Mysql.com . For my conclusion it is time to buy a book about MySQL!! any help is appreciated. Anthony

Re: efficient query or not?

))) < 1000 Because the problem, is that I have to join this with 3 other tables. Thanx Agai. Anthony W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: efficient query or not?

se I don't understand the use of loc1.id=1 and loc2.id=2 Thanx for the help. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

efficient query or not?

) * sin($latitude) ) * 3963 <= 1000); Would you consider this HORRIBLY inefficient or GOOD. if it is horrible how can i make it efficient? Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

IN function

Hi, I have written a program that creates statments for me, and sometimes I end with SELECT..WHERE number IN(1) instead of SELECT... WHERE number IN(1,2,3,4) would number IN(1) works, for the moment i have no mean to test it, it is why i'm asking. Regards, Anthony -- MySQL Ge

Row Number

o SELECT...LIMIT nex-ten-starting,10 Regards, Anthony W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advice on improving our current method

Hi, I'm not to familiar with MySQL, but as far as I can seem, you might want to look at programming. I.e a program in C++ or Perl, or Visual Basic. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Statment Question

Hi, I have to search a big database. Now there are many categories i.e computerlanguage = C++, Perl,Php,Visual Basic, C, Javascript. In my table C++ =1 Perl = 2 PhP = 3 VB = 4 C = 5 Java = 6 and i have a select statment like this SELECT * FROM lang WHERE language = 1 OR language = 2 OR language

RE: oracle.

'select table_name from user_tables' to see your own tables. To see all tables you have to select from dba_tables. -- anthony -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:35 AM To: [EMAIL PROTECTED] Subject: oracle. hi, m a fre

4.1 Download

Where/how can I get a copy of 4.1? Thanks, Anthony sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: libmyisam help...

query and sql... bah! On Fri, Oct 25, 2002 at 01:32:14PM -0500, Paul DuBois wrote: > At 10:42 -0400 10/25/02, Anthony R. J. Ball wrote: > > Does no one know how to compile a program with the myisam > >library? > > Not me. Never tried it. Maybe no one else has, either. >

Re: libmyisam help...

proper gcc line is to link everything in right is... On Thu, Oct 24, 2002 at 10:36:49AM -0400, Anthony R. J. Ball wrote: > > Hi all... I am attempting to play with the myisam > api to try to make loading hordes of data a little > simpler/faster, and so am trying out the myis

Re: can anybody tell me!!!

Do you have the date field keyed in the table definition? I assume you have numbers after the date, or text, otherwise you should be doing an = without the %... Really to speed it up you should have a date field you query on, which is keyed, and whatever is in the record after the date sho

Re: libmyisam help...

Hi all... I am attempting to play with the myisam api to try to make loading hordes of data a little simpler/faster, and so am trying out the myisam interface... specifically, eventually to try an wrap it in a perl module. Herein lies my problem... I know enough C to get by, but am having s

[Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]

Any thoughts with regards to the problem outlined below would be appreciated! Thank You, Anthony Original Message Subject: 2nd Attempt: Fwd: Access Denied (1045)] Date: Fri, 18 Oct 2002 06:59:21 -0400 From: "Anthony W. Marino" <[EMAIL PROTECTED]> To: [EMAIL PR

2nd Attempt: Fwd: Access Denied (1045)]

I'm boxed in a corner and would appreciate some suggestions, please! Thank You, Anthony Original Message Subject: Access Denied (1045) Date: Tue, 15 Oct 2002 08:47:05 -0400 From: "Anthony W. Marino" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] I"v

Access Denied (1045)

h-to-userX-area/temp/mysql.sock" 2) When the user tries to run "mysql", "mysqladmin" and etc the following error message is received: "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)". Please note that no passwords have been setu

Re: MySQl db as filesystem.

Here's something: http://no.spam.ee/~tonu/modules.php?name=News&new_topic=2 Anthony Jayce^ wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Actually, I remember reading about a mysqlfs system, like that, cd to a table, >ls for records.. rm to remove and such.

Re: MySQl db as filesystem.

Pretty interesting stuff: http://www.osnews.com/story.php?news_id=836 http://newsforge.com/article.pl?sid=02/03/22/204220&tid=9 Anthony Anthony W. Marino Pres./CTO, AWM Objects David Garamond wrote: > Jan Steinman wrote: > >> Today's "modern" operating sys

Re: User Specific Instance Running

Victoria Reznichenko wrote: >Anthony, >Friday, October 11, 2002, 5:26:39 AM, you wrote: > >AWM> There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in >AWM> this users environment (RH 7.3). >AWM> "my.cnf" has been modified to include ind

User Specific Instance Running

t user and is passed as "--defaults-file" through "mysqld_safe" script. Data directories are already available with this user/group's ownership. All attempts to run "mysql -u root file" and other privledged commands (also tried --skip-grant-tables) end up with Error

mysql.server Mods for Multiple Instances/Users

l fi # delete lock for RedHat / SuSE if test -f /var/lock/subsys/mysql then rm /var/lock/subsys/mysql fi Thank You, Anthony - Before posting, please check: http://www.mysql.com/manual.

Re: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?

> Just out of interest, do you see the equivalent of a core file when this > happens? Or anything in the mysql logs? Don't see any cores... here is the error log entry mysqld got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it wa

SHOW VARIABLES bug in 4.0.3 on solaris 2.7?

I just installed the 4.0.3 binary of mysql on our solaris 2.7 development box, and whenever I do a show variables, mysql crashes... I can view some variables, and going through the list is seems that querying 'log_slave_updates' is the one that is killing mysql... mysql> show variables like '

Application for Employment / Contract Work

*** Please Note: Do Not Use your Reply button if you wish to respond to this email *** *** Please reply to [EMAIL PROTECTED] *** Hello, I came across your website, and thought I would send you a copy of my CV / Resume (please scroll down the page) to see if you are in need of any help in pr

RE: object pool benchmark over 100mbit lan

hi, which version of MySQL? ___ Anthony Johnston [EMAIL PROTECTED] Antix Software Limited http://www.antix.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 17 June 2002 22:18 To: [EMAIL

Re: Recent Updates

Thanks alot!!! Anthony > In the last episode (May 30), Anthony W. Marino said: > > Where/how can I access the most recently updated code for MySQL Max > > 4.x. > > http://www.mysql.com/doc/I/n/Instal

Recent Updates

Where/how can I access the most recently updated code for MySQL Max 4.x. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Select Past 7 days

Try this: SELECT a, b FROM tblName WHERE TO_DAYS(NOW()) - TO_DAYS(pubDate) <= 7; Anthony > What is the proper query for slect all from the past > number of days. > > i.e. I would like to return all articles from the past > week. Right now I am using SELECT blah, bla FROM tab

Changing field size

I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL db? Thanks! Tony ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (t

Re: Mysql 4.0.x enough stable to be in production ?

What table types are you using? Anthony > I've been running 4.0.1-alpha on a development server for our new internet > bookstore. Holds around 1.3million books, 100k bookcovers and a lot of > other information. > > I haven't experienced any crash/problems except for o

Re: Getting the most recent record per id before date X

klund wrote: > * Anthony R. J. Ball > > I am trying to figure out the best way to select > > the row of data for a specific id that is the most > > recent entry on or before a specific date. > > What about: > > SELECT * FROM table > WHERE > id = $s

Getting the most recent record per id before date X

I am trying to figure out the best way to select the row of data for a specific id that is the most recent entry on or before a specific date. I realize that I could create a temp table and select where date <= X and group by id, inserting the max date into the table with the id, then do a

Help w/ "join" syntax

When I call the following PHP script, $qry_1 doesn't work (No query # 1!). DONE"; flush(); exit; ?> Thank you! Anthony F. Rodriguez ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.c

Re: [linux-lvm] System Suggestions

o comments there. > > We're also having some problems with Mysql that people keep pointing > fingers at LVM for, but at this time we're point right back and > saying "No!" in a firm voice... What

Re: [linux-lvm] System Suggestions

On Wednesday 06 March 2002 02:40 pm, Petro wrote: > On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: > > Could someone, please, provide me with a link and/or facilitate some > > suggestons for configuration of the following components for a new DB > >

Re: MySQL Availability

On Wednesday 06 March 2002 01:37 pm, Ken Menzel wrote: > http://www.mysql.com/doc/I/n/Installing_source_tree.html Someone, replying earlier, mentioned that MySQL AB folks don't grant permission to nightly stuff. I'll test it out, regardless. Thank You, Anthony > -

MySQL Availability

Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

System Suggestions

have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS Thank You, Anthony - Before posting, please check: http://www.mysql.com/manual.php

Re: Can't restart MySQL after innodb table filled up

ater, plans for an automatic procedure for deleting an InnoDB Db and ALL associated files (ie; "Delete DB and all") ? Thanks, Anthony > Best regards, > > Heikki Tuuri > Innobase Oy > --- > Order technical MySQL/InnoDB support at https://order.mysql.com/ > Speed up adding

Re: I heard that MySQL 4.01 supports Views?

On Wednesday 27 February 2002 05:16 pm, you wrote: > At 17:09 -0500 2/27/02, Anthony W. Marino wrote: > >On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > > > >Does MySQL 4.01 support Views? And if so, how? > > > > > > Ask the person who to

Re: I heard that MySQL 4.01 supports Views?

On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > At 16:31 -0500 2/27/02, Stephen Cox wrote: > >Does MySQL 4.01 support Views? And if so, how? > > Ask the person who told you that it does to substantiate the assertion. > > >Stephen Cox > >Web Development, Webmaster > >[EMAIL PROTECTED]

Changed localhost?

All of a sudden Apache and MySQL are not running correctly under Windows 98. It appears that somehow localhost was changed from 127.0.0.1 to something else. Could the fact that I NOW have a 24/7cable connection to the Net cause the problem? Thanks! Anthony Rodriguez ([EMAIL PROTECTED

MySQL 4/XFS Journalling FS

Would anyone like to share their experiences with MySQL 4 on XFS and kernel 2.4.16? I'm getting prepared to create a system with the above and would appreciate any thoughts. Thank You In Advance! Anthony - Before po

Re: MySQL 4.x Timeline

On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote: > Hi Anthony, > > On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote: > > > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: > > > > > Is there a timeline/status for 4.x functionality available? > &

Transaction Enhanced Formats

Can anyone point me to a comparison of +'s and -'s with each Transaction enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.

Re: MySQL 4.x Timeline

On Friday 22 February 2002 06:26 am, Arjen Lentz wrote: > Hi Alec, > > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: > > > Is there a timeline/status for 4.x functionality available? > > > I would like to use MySQL 4.x, however, I'm looking for some of the > > > highly requested functional

Re: Paul DuBois Book

On Friday 22 February 2002 05:48 am, Simon Green wrote: > It would be nice to see some thing for V4. > > PS Paul...its only because we liked the first one so much. > > -Original Message- > From: D Bamud [mailto:[EMAIL PROTECTED]] > Sent: 22 February 2002 10:47 > To: [EMAIL PROTECTED] > Sub

Re: MySQL 4.x Timeline

On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: > On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: > > Is there a timeline/status for 4.x functionality available? > > No. It'll be ready when it's ready. :-) > > There are folks using 4.0

MySQL 4.x Timeline

fall into place. This will help me plan my development effort as well since I don't need everything at once. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Possible bug in mysqldump -d on mysql-max 4.0.1

I just noticed that mysqldump -d outputs /*!4 ALTER TABLE equity_ind1 DISABLE KEYS */; at the end of the dump of the table def... If I understand this correctly... this will be executed by any version of mysql version 4 and up... That would be fine, except that since it is not dumping

Plz help w/ query

The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. Thanks! Anthony F. Rodriguez ([EMAIL PROTECTED

Re: Getting only the latest entries in a table...

e. > > Of course, if the table is not being updated synchronously with loading of > the files, all this is probably a pipe dream, for which I apologize. > > --Erv > > At 02:06 PM 1/24/2002 -0500, Anthony R. J. Ball wrote: > > Is it possible to select only the latest en

  1   2   >