hello mysql-team,
i am sorry if i do not correctly report this bug, but i do not know how i
should make it sure with a script, that you can verify or repeat this bug.
however i have a dump of my mysql-database attached to this mail and hope
it will be enough.
i am using mysql source
Is there some kind of pattern in fields containing
binary data - so you can be sure that is really IS
binary!?
I.e. if I in my database have a BLOB-field and
sometimes write a string, and sometimes a file?!
Regards David
-
upssorry - i forgot to attach the database :-)
(See attached file: econDB.dump)
---
hello mysql-team,
i am sorry if i do not correctly report this bug, but i do not know how i
should make it sure with a script, that you can verify or
Please tell me how to select the 10 (or 5) newest records or posts from a MySql table.
Best Wishes
Signe Hasseriis
What is mysqlclient and mysql server.
Where will I get it.
What is the difference between them.
Thanks in advance.
Poornima Visvesvaran.
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
Hello John,
There is a tute of sorts at:
http://terra.tafe.tas.edu.au/~beechd/rdb/rdbd_mysql_intro.html
which will help if you have problems with the acces/privilege model.
Also: Have you installed an ODBC driver (MyODBC) correctly? and
set up a DSN?
It is most likely that the problem is an
Hi
Before enabling replication between two live machines, I've been doing some tests in
the office
between two similar machines.
Everything appears to work well, as expected, except the command
LOAD TABLE x FROM MASTER;
This records an error on the screen
ERROR 1188: Error From master:
On 29-May-01 Griff Hamlin wrote:
Hello,
snip
I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help
and now I'm out of ideas. Any suggestions would be appreciated.
localhost.dread$ perror 28
Error code 28: No space left on device
put --tmpdir on a bigger disc.
On Tue, 29 May 2001, Signe Hasseriis wrote:
Please tell me how to select the 10 (or 5) newest records or posts from a MySql
table.
Best Wishes
Signe Hasseriis
IMHO, there's no fair way.
May be this trick works. add a field with type timestamp to your table,
for example
'modified'.
Hi,
See 'BLOB' column type in the manual.
David Lidström wrote:
Is there some kind of pattern in fields containing
binary data - so you can be sure that is really IS
binary!?
I.e. if I in my database have a BLOB-field and
sometimes write a string, and sometimes a file?!
Regards
Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases?
I have seen a tool on the MySQL site called MyTool-DLL, this does the job but the code
is licenced, I am looking at source code to do this if possible!
Hi all.
I want to optimize a query that is executed often in the application we use
at work.
NOTE: Excuse me for using spanish names for the tables and the columns.
In the database we have three tables for article: ARTICULOINFO (information
of an article), LARTICULOINFO_IDIOMA (information of
I use an Open Source mySQL API.
[homepage] http://www.icarz.com/mysql/index.html
/ d
-Original Message-
From: Cyber Monkey [mailto:[EMAIL PROTECTED]]
Sent: den 29 maj 2001 11:20
To: [EMAIL PROTECTED]
Subject: MySQL++ for Visual Basic
Has seen an ocx for the MySQL++ to allow
Cyber Monkey wrote:
Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases?
Actually you dont't need a ocx. You can call the MySQL API functions,
which are in a dll file.
Robert
-
Before
Hello mysql,
I just tried to build replica on the fly and encountered
strange problem. When I do LOAD table stopword from master
it hangs forever and in logs I'm getting this
010529 14:04:13 Duplicate key 1 for record at 315 against new record at 0
010529 14:04:13 fetch_nx_table: failed
Dear Sir,
When I run this php script then system show some errors.
script and errors is below .
Please advice me how can I resolv this problem.
/var/www/html/test2.php
---
?
$dbuser = 'root';
$dbhost = 'localhost';
$dbpass = 'root';
$dbname = 'mysql';
$dbtable = 'user';
You can use MyODBC to establish database connection to your server using
Delphi application.
http://www.mysql.com/downloads/api-myodbc.html
In addition to that you can use secure shell (OpenSSH/SSH) port forwarding
facility for secure connection to your server.
good luck,
--
Im having aproblem in connecting via Odbc to the MySql Server. I working on
a pentium III with NT 4.0 Server. The error is the following:
SQLDriverConnect returned: SQL_ERROR=-1
dbc: szSqlState = S1000, *pfNativeError = 2003, *pcbErrorMsg = 65
MessageText = [TCX][MyODBC]Can't
Hi
Problem solved.
After adding select permission (now file+select) to the replication user the command
LOAD TABLE x FROM MASTER
works perfectly.
The only question is, why does this command need SELECT permission, whilst the rest
of replication does not ?
Simon
On Tuesday 29 May 2001
Hello All:
Did anybody setup multiple mysql servers on single machine? Do
I have to use mysqld_multi? I tried using this but gives me
this error:
ABORT: Bad GNR: mysql2 See mysqld_multi --help
This is how I ran mysqld_multi:
mysqld_multi --config-file=/etc/my.cnf start mysqld2
Here are the
Hi,
Can some one let me know how can I insert current time
into the MySQL table's time column.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at
Field | Type | Null | Key | Default | Extra
---+--+--+-+-+---
hora | time | YES | | |
insert into hora values (curtime())
- Original Message -
From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May
Hi!
Try this:
INSERT INTO my_table (myTimeField) VALUES (CURTIME())
[also see] http://www.mysql.com/doc/D/a/Date_and_time_functions.html
-Original Message-
From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]]
Sent: den 29 maj 2001 15:07
To: [EMAIL PROTECTED]
MySQL users,
Our department is in the midst of reengineering the way data on our
email server (MySQL on Linux) is kept in sync with the data on our
administrative server (UniData on Tru64). I am not familiar with ODBC
connectivity but from what I have heard and read, it might be our only
Hi,
Mytool is GPL, use any way you like. For current mytool docs see
(www.icarz.com/mysql/index.html ). The tools uses the MySQL windows
dll, you can of course use this directly. Mytool is licensed that
same as MySQL. That was the intent.
Also www.scibit.com sells a nice library for VB.
Hi, I see there are ways to have MySQL obtain data from a FoxPro database--using
ODBC--which is very nice, I'm sure.
However, is it possible to run a FoxPro program that gets data from a MySQL
database??
Thanks!
-
Before
Hello
I have just installed MySQL on a Win98 machine and on trying to load mysqld.exe I get
the following error:
can't initialise InnoDB as innodb_file_data_path is not set
can anyone help with this?
Many thanks,
Sean Browne.
This isn't awfully useful to you, but it's dead easy to do this on a Unix
system. All you do is copy the data over wherever you like (to a big, fat,
drive), and then link the new directory from the /usr/local/mysql/data/
directory (ln -s).
OTOH, I guess you can't link a file/directory in
conditions:
MySQL-3.23.32
FreeBSD 4.2-RELEASE
problem:
==
MySQL documentation:
16.1 Adding a New User-definable Function
[...]
The MySQL source
distribution includes a file `sql/udf_example.cc' that defines 5 new
functions. Consult
within VFP it is.
Cal
http://www.calevans.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 8:50 AM
Subject: FoxPro6 and MySQL, odbc
Hi, I see there are ways to have MySQL obtain data from a FoxPro
database--using
On 29 May 2001 09:28:04 +0200, Signe Hasseriis wrote:
Please tell me how to select the 10 (or 5) newest records or posts from a MySql
table.
SELECT * FROM table ORDER BY posttime DESC LIMIT 5
--
MySQL Security Administrator
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Tonu
On 29 May 2001 00:27:42 -0700, Poornima Visvesvaran wrote:
What is mysqlclient and mysql server.
mysqlclient is name of MySQL client side library. mysql server is a
MySQL Server.
Where will I get it.
http://www.mysql.com
What is the difference between them.
MySQL server stores data
Hi,
I have also noticed these aborted connections, unfortunately my
time is too divided to give this 100%. I have just created a test
situation with 3 server and a large application that inserts about
300,000 large rows. This application aborts after several hours with
an aborted connection
I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The
problem I'm having is that my php scripts work fine, mysql works fine. When
I run a php script, everthing in the script works up to the point were I try
mysql_connect. I get no error, but the script just hangs. It never
Tuesday, May 29, 2001, 6:11:31 PM, you wrote:
MVA conditions:
MVA MySQL-3.23.32
MVA FreeBSD 4.2-RELEASE
MVA problem:
sorry for spam.
I'm newbie in this stuff.
Now i compiled this example, but it still doesn't work
bash-2.04$ mysql -p -u admin
mysql CREATE FUNCTION metaphon RETURNS STRING
Hello all!
Can anyone help me why I cannot change a user's password in the Windows
version of MySQL (except for the root account)? I keep getting the ERROR
1133: Can't find any matching row in the user table error message everytime
I try to change a user's password, both from mysqladmin and from
Hello, I am a novice to Apache, MySQL and PHP. I have just installed these
on my Win98SE machine, and want to do some off-line ('localhost') exercises
before I go on the web. Apache and PHP work; I can run PHP scripts that do
not access a database. But as soon as I try mysql_connect(), I get
On Mon, 28 May 2001, Pat Suwalski wrote:
I'm doing a school project for which I'm to write a PHP script with MySQL
that searches a dBase database.
I've got my code planned out, but the problem right now seems to be that
mySQL can't directly read dBase databases.
It's a fairly large database
You can do this with NT Server as well. It is called Distributed File
System (DFS). You may have to download it from Microsoft but it is free. I
think it is built into Win 2000. You will have to muck around in the
documentation for the details.
HTH
Tracy
-Original Message-
From:
have you tried using mysql_connect without the preceding @?
This may give you some error info on the page...
of course, I am a newbie too and I am using it on a Unix box so I could be
totally off..
thanks,
shawn
On Tue, 29 May 2001, Marco Bleeker wrote:
Hello, I am a novice to Apache, MySQL
Look up link or something in the manual. There is a way to do
virtual symbolic links in NT with mysql without installing anything,
it has to do with adding paths to the my.cnf file, see the docs
for details.
Tracy A. Mitchell wrote:
You can do this with NT Server as well. It is called
Hey everyone!
I'm hoping someone can help me out with this... I'm trying to write a
perl/cgi to connect to mysql. This is my code:
#!/usr/bin/perl
print Content-type: text/html\n\n;
use DBI();
connect(DBD::mysql,usertest);
read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'});
@pairs =
Hi Marco,
The usual method is something along the lines of:
--start--
$server = localhost;
$username = your username;
$password = your password;
$database = your database name;
$db_handler = mysql_connect($server, $username, $password) or die
(mysql_error());
mysql_select_db ($database);
When I do my query:
mysql_query(SELECT * FROM users WHERE name='$sentname');
it always returns 0 elements. $sentname is comming from form input on a
page that POST's to my current page. I have checked this value and it
is what I expect, usually Scott for testing purposes. The first record
in
[client]
port=3309
socket=/tmp/mysql.sock.shoja
Now the problem is when I'm trying to run my cgi from command prompt there
is no error and it connect successfully.
But when I'm trying to run it through web browser I get this error
message:
Can't connect to local MySQL server through
Thanks for your reply
The question is why in command line there is no problem?
It is looking for /tmp/mysql.sock and the one that exists is
/tmp/mysql.sock.shoja
Two different files.. It can't find what it is looking for. Try:
safe_mysqld --socket=/tmp/mysql.sock
and it should work
I don't know for sure... perhaps, the apache+php binary just treats it
differently than when interacting with it directly from the shell...
I am a newbie and I just had the same problem 2 minutes ago...
hope it works out...
thanks,
shawn
On Tue, 29 May 2001, Mohammad Shoja wrote:
Thanks for
Hi,
If one installs a newer version of mysql over the top of a current
version (in my case this will be done from the FreeBSD ports
collection), will the current tables and data remain intact?
If not OR if a worry, is there a single command using mysqldump to dump
everything in one go,
In message [EMAIL PROTECTED], Tonu Samuel
[EMAIL PROTECTED] writes
On 29 May 2001 09:28:04 +0200, Signe Hasseriis wrote:
Please tell me how to select the 10 (or 5) newest records or posts
from a MySql table.
SELECT * FROM table ORDER BY posttime DESC LIMIT 5
is the column/field posttime
I'm still stuck... but Im making progress? This is the new problem:
- Original Message -
From: Heather Wagamon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 10:57 AM
Subject: install_driver(mysql) failed: Can't locate object method
bootstrap via package
Hey
-Original Message-
From: Scott Spearman [mailto:[EMAIL PROTECTED]]
Sent: 29. maj 2001 18:50
To: [EMAIL PROTECTED]
Subject: Novice mySQL and PHP problem
When I do my query:
mysql_query(SELECT * FROM users WHERE name='$sentname');
it always returns 0 elements. $sentname is
Any specifics?
Informative/interesting articles on your Nerd Herd web site, Cal !
Better fix INPUT TYPE=hidden NAME=item_name VALUE=ConsultaingAssistance
I have the Que book, Special Edition, Using Visual FoxPro 6, but all it ever
discusses is how *other* applications can access _FoxPro's_
I have mysql 3.23.32 installed in my system OpenBSD 2.8, worked fine for almost one
year,
but recently he is restarting frequently and crash after many restart and I need
restart mysql
myself. The following messagem is showed in error file:
mysqld got signal 11;
The manual section 'Debugging
Thank you! :)
Go grab the ODBC driver for mysql. Install and create a DSN for your mysql
database.
Then go into VFP and open your DBC, add it as a connection.
Now you can add updateable views of all your mysql tables into it and use
them like you could any other remove view.
NOTE: I've
Howdy,
I currently have an application which uses DAO and ADO coding in VBA/VB as
well as databound objects in VB to access a MS Access database. Can DAO and
ADO in VBA/VB and databound objects in VB be made to work with a MySQL
database?
Anybody done this successfully?
Cheers,
Mike
Or is anyone working on this? Also, how about stored procedures? Does
mysql support stored procedures?
Thanks.
Yes it can, via ODBC.
I've never done it though. (I don't work in VB)
Cal
- Original Message -
From: Thompson, Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 12:37 PM
Subject: VBA/VB DAO/ADO MS Access to MySQL?
Howdy,
I currently have an application which
Ah, yes, I remember seeing some of this COM or ADO stuff in the Que book, plus
the SQL passthrough stuff. I remember putting the book to one side for some
reason, and that reason follows:
It looked to me as if you certainly *could* manage to *read* data from another
machine, but (tell me if
No, you can read and write the data. The problems arise when old
fox-jockey's like myself try to treat the remote views exactly like dbfs.
No can do.
When creating your remote views make sure you go to the update panel and
tell it you want to actually send the sql updates. (You have to specify a
I've done it by installing the MyODBC driver on NT4.0 WS running VB6sp2, and
connecting to a RHLinux6.2 box running MySQL vs .36 -
I've only done it w/ ADO over the ODBC layer, and it seems to work fine,
however I am using disconnected recordsets and have not attempted binding a
control to the
From 'man mysqldump'
mysqldump [OPTIONS] --all-databases [OPTIONS]
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: Marco Kammerer [EMAIL PROTECTED]
To: MYSQL [EMAIL PROTECTED]
Sent: Tuesday,
Hi!
We have noticed some mails posted by Windows users having problem
in the first start of mysqld.exe on Windows platforms. Then, below
the explanations how to avoid the problems reported:
1- According with our MySQL-Max download page is noticed that the
regular distribution 3.23.38,
PLEASE if anyone can help!! We are past deadline
Object: Retrieve rows from table D.
GIVEN:
1. MySQL ver 3.23.33 (but must run on 3.22.25!)
2. Table D is connected to tables E,F,K through tables dE,dF,dK.
3. Table D is connected to table L through tables dK then Lk.
D - dE - E
D - dF - F
D -
This works fine from VB6. Install the MyODBC driver (get it from the
MySQL web site), then set up a datasource just as you usually would.
Ideally, you won't have to change any of your VB code - just bind the
ADO/DAO controls to the MySQL datasource rather than the Access
datasource.
Note
Hi,
Can any one please tell me which version of MYSQL to
use if my uname -a command gives the following output:
SunOS ny-dmdbld02 5.6 Generic_105181-23 sun4u sparc
SUNW,Ultra-2
Thanks
Giri
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you
Excellent! This looks like it should work.
Another useful reference is
http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:2861:200102:nofjdmbdkfaebemidbgl
From: Christopher R. Jones
Date: Wed, 21 Feb 2001 16:00:33 -0500
I have it working. Here is what I did:
I. MyODBC
Create a System
I prefer dumping things one database at a time so I can more easily
recover them. See script below, run from the mysqlback directory which
is at the same level as the directory containing the directories of all
of the files.
Sincerely,
William Mussatto, Senior Systems Engineer
Hi,
I've setup a database to keep track of various events. Now I'm working on
displaying these events on the screen through a web browser. I've got all
the crucial information displaying - now its time for a little fine tuning.
All the dates in my database are ISO format, so -MM-DD, I'd
Hi,
was wondering as am starting a database with just some 5000 different ID
entries and each entry having some 60 datafields, which would work
best/faster a single table of the data or divided into separate tables?
Jari Mäkelä
Hi Tim!
You could do something like this:
$sqlstr = select date_format(EventStartDate, '%M %D %Y') as mydate, (rest of your
SQL string here) ;
$result = mysql(mydb, $sqlstr, $connect) ;
$myformatteddate = mysql_result($result, 0, 'mydate') ;
This should do it for you :) HTH
$Result = @mysql_query (SELECT DATE_FORMAT(EventStartDate,'%M %D %Y') AS
EventStartDate FROM EventsTable);
$Row = mysql_fetch_array($Result);
printf(Event Date:%s, %Row['EventStartDate'];
Hope this helps :o)
--Patrick
# -Original Message-
# From: Tim Thorburn [mailto:[EMAIL
At 2:39 PM -0500 5/29/01, Tim Thorburn wrote:
Hi,
I've setup a database to keep track of various events. Now I'm
working on displaying these events on the screen through a web
browser. I've got all the crucial information displaying - now its
time for a little fine tuning.
All the dates in
What if the queries were updates instead of inserts? Would I need or be
able to lock the tables then?
Can I go without locking the bdb tables and not worry about the data
integrity on those tables during updates and inserts?
-Seth Hall
Student Programmer
Ohio State University Main Library
Bruce,
Thanks for your reply!
1- Yes I've tested using MySQL GUI 1.7.4 with the same results
2 - Don't know, will have to find out
3 - I'll find and check that too
Paul,
Have you tried the SQL from mysql to see wht it does outside of PHP? IS
the MySQL server configured to log all queries?
I currently have Access97 as a front end of MySQL database. Would any of
you be able to suggest me any other easy front end for the database.
Employees in my company are very slow to learn, so something like Access
would be good to find. The reason I am asking is, because every damn time I
Previously, I used SELECT table_name FROM tabs to get all the table names, but now,
I logged into a new box using SQLPlus, but there is no record in the tabs table. So,
how can I get the table names in that database (Oracle)?
Thanks!
hi.
this is a php question, and is offtopic for this list...
...but values in single quotes are sent without parsing to mysql from php.
use double quotes instead.
-ravi.
-Original Message-
From: Grosen Friis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 1:07 PM
To: 'Scott
Have a look at urSQL from http://www.urbanresearch.com/ursql.
On Tue, 29 May 2001, Apolinaras Apollo Sinkevicius wrote:
I currently have Access97 as a front end of MySQL database. Would any of
you be able to suggest me any other easy front end for the database.
Employees in my company
You should split the data-fields into tables containing 'categories' of
fields.
* 'textual' (or informational) fields would be the main 'item' table
* 'quantity' and other 'numeric' fields that are updated frequently (i.e.
quantity sold, quantity on-hand) would be in the table that
Description:
When I tried to compile mysql source with make,
I have the following errors :
make[2]: Entre dans le répertoire
`/installation/install/MySql/Tarball/source/mysql-3.23.38/client'
/bin/sh ../libtool --mode=link c++ -O3 -DDBUG_OFF
-fno-implicit-templates -rdynamic -o mysql
I'll add my two cents along with what everyone else has said because I have
worked with all three.
In short, MySQL works best when you are strictly using ADO and not DAO. On
top of that, it's fast becoming (if it's not already) an ADO world! So, in
the long run you might be better off converting
Hello all. I'm new to the list, and I just have a quick question.
Hopefully somebody can help me out.
Anyway, here's the basics of what I want to do:
I want to update a record or, if that record does not exist, create a
new one.
Now I could easily do this on the client side in another
Randolpho St John wrote:
Hello all. I'm new to the list, and I just have a quick question.
Hopefully somebody can help me out.
Anyway, here's the basics of what I want to do:
I want to update a record or, if that record does not exist, create a
new one.
Try the REPLACE... query. Look
Please send me the actual physical query that was locking things up.
This sounds like a simple join, include table/key structures in your
response.
More than likely you aren't joining somewhere nicely, and if you don't,
you end up with really really large result sets.
- Original Message
Oh, and response time should be 'faster', since you can locate the different
tables on separate storage devices, allowing for concurrent drive access to the
different parts of the item.
Steve Brazill wrote:
You should split the data-fields into tables containing 'categories' of
fields.
I am using mysqlhotcopy from within a cron job to make a backup copy of
my database each night. Once I have run mysqlhotcopy and made
the backup directory in my /usr/local/mysql/data directory, I'm able to
do select statements on the data in the backups, but the mysqlshow
command does not show
Actually you dont't need a ocx. You can call the MySQL API functions,
which are in a dll file.
Robert
Do you have any examples of that with VB?
D'Arcy
-
Before posting, please check:
http://www.mysql.com/manual.php
I've never heard of UniData or Tru64 but if they are unix based, I have
heard of a MyODBC for unix systems. Don't know much about it as most of my
ODBC experience has been on Windoze platforms.
- Original Message -
From: Allen Belk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL
It's a little difficult solving your problem as you have not provided as
with samples of the commands you used, but
1. Check that the user exists in the first place.
and
2. Did you use GRANT to set up a user in the first place? Not just insert a
user into the tables.
- Original Message
Firstly, you are way off topic. This is a MySQL list, not an Oracle list.
Secondly, any good book on SQL in general will tell you how.
- Original Message -
From: Zhu George-CZZ010 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 4:48
Subject: what's the command to
At 9:16 AM +0200 5/29/01, David Lidström wrote:
Is there some kind of pattern in fields containing
binary data - so you can be sure that is really IS
binary!?
I.e. if I in my database have a BLOB-field and
sometimes write a string, and sometimes a file?!
Given that a file can contain
Hi,I meet a problem.I install mysql in Turbolinux workstation 6.1,it works seem ok.But
when I connect it in another computer(using mysql client,odbc ect.),Err occured seem
the host '' not allow connect mysql
How can I do?
At 9:50 AM +0800 5/30/01, zhenlei wrote:
?Hi,I meet a problem.I install mysql in Turbolinux workstation
6.1,it works seem ok.But when I connect it in another computer(using
mysql client,odbc ect.),Err occured seem the host '' not allow
connect mysql
How can I do?
The server you're
Hello
I am trying to display a table depending if the registration date is
between a certain period. To do this , I want to pull the 'day' field
from another table and construct one of the comparison dates with this
value. It is probably best explained with a query.
This is what I am trying
I'm trying to convert a primarily php script which does a zip code lookup
into a mostly mysql one. I've got alot of the math done, but don't know
how to pull some of the data from my tables. Here's the scenario, I have
to get the number of miles between 2 zip codes, which are stored in 2
Hi,
I am installing MySQL in Windows 2000 Advanced Server.
However, the installation comes with two files for NT, namely
mysql-nt.exe and mysql-max-nt.exe.
Which one I should use ?
Nyon
At 2:23 PM +0200 5/28/01, Alessandro Staltari wrote:
Hello. I'm new to MySQL but I have a problem that appears serious,
al least for me.
I can't create a table with a field named INFILE. I think mysql
consider INFILE as a keyword. Is there work around for this?
Shouldn't INFILE be used only
This was what I did:
As root:
mysqlGRANT ALL ON mydb.* to [EMAIL PROTECTED] identified by 'mypassword';
mysqlFLUSH PRIVILEGES;
Trying to change myaccount's password from mysqladmin:
C:\mysqladmin -u myaccount -p password newpassword
Enter password: **
C:\MYSQL\BIN\MYSQLA~1.EXE: unable
At 4:44 PM +0900 5/28/01, jamal wrote:
Hi all,
How to use MySQL LOAD DATA command to load comma separated text data
Huh? Your LOAD DATA statement below specifies |-separated data,
not comma-separated data.
but one of the field can contains comma character as part of of the
string context.?
- Original Message -
From: Stephanie Deville [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 22:30
Subject: mysql/php problem
I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The
problem I'm having is that my php scripts work fine, mysql works
1 - 100 of 106 matches
Mail list logo