You could always look into hacking the code that drives the `file'
application, to a point it can determine the binary data type.
David Lidström wrote:
>
> Let's say it's an image, zip archive or a PDF-file!?
> I am creating a GUI-client, so it's when a table is
> listed, and the field is
Let's say it's an image, zip archive or a PDF-file!?
I am creating a GUI-client, so it's when a table is
listed, and the field is containing a file I'd like
to know this somehow... If possible!!
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: den 30 maj 2001 0
Thank Mr DuBois,
I am sorry I made mistake when I stated my problem and confused some people.
Actually it is not comma separated field, but field separated by '|' like
this
2101|13 Ghosts|01:28||Olivier Ducastel,Jacques Martineau||
But when I loaded field data 'Olivier Ducastel,Jacques Ma
Hi, all...
I configured for mysql-3.23.33 below:
--prefix=... --enable-static --with-pthread --enable-thread-safe-client --
with-unix-socket-path=... --with-tcp-port=... --with-charset=euc_kr
At first, --prefix, --with-unix-socket-path and --with-tcp-port options is
used because already
Hello:
What exactly is GNR number according to mysqld_multi script file?
...Rohit
Respected Sir,
I have been trying to go through MySQL source and was not able to
understand the flow. I wanted to understand the source and compile it after
doing some modifications.
Could you direct me to some resource available and that I could use for
the same.
Please respond soo
>Description:
The database test case rpl15 fails. It appears from the
'diff' output (withing the test output appended below) that the
testcase was expecting to run on port 9998 when it actually
ran on port 3050. As you can see from the output from the
mysqlbug script, the --with-tcp-port=305
Try
C:\mysqladmin -u [EMAIL PROTECTED] -p password newpassword
or even
C:\mysqladmin -u myaccount -h 127.0.0.1 -p password newpassword
- Original Message -
From: "Ardianto Rustandi" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, May
- 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
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
This was what I did:
As root:
mysql>GRANT ALL ON mydb.* to [EMAIL PROTECTED] identified by 'mypassword';
mysql>FLUSH 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 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
At 10:45 AM +0800 5/30/01, nyon wrote:
>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
The differences are described at:
http://www.mysql.com/do
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 12:21 PM +1000 5/30/01, Steven Wren wrote:
>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
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
differe
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 to
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
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: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 cont
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 comman
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 -
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 P
> 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/man
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 any
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.
>
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 --
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.
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 language,
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
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
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 wou
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 com
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 Sp
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!
-
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
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?
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
On
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 d
$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 PROTECT
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
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,
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
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
CyberStrategie
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 D
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
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 that
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 - dK
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, contai
>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: Tu
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 b
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
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 I'
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 applicatio
Or is anyone working on this? Also, how about stored procedures? Does
mysql support stored procedures?
Thanks.
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
Hello
on
http://www.mysql.com/articles/mysql_intro.html#SECTION000100
there is the text
...
The function mysqldump can be used to backup !! all !! databases,
several databases, one database, or just certain tables within a
given database. In this section, the syntax involved with each
scen
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 spent
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
Any specifics?
Informative/interesting articles on your Nerd Herd web site, Cal !
Better fix
I have the Que book, "Special Edition, Using Visual FoxPro 6", but all it ever
discusses is how *other* applications can access _FoxPro's_ database. I don't
want to do that. I'm considering this re
> -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. $sentnam
I'm still stuck... but I"m 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
> >
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/fiel
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, knowin
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
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
>
> [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 serve
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 t
Hello all,
I've just joined to the list and I have a problem when I want to connect
to MySQL from my CGI when I'm running it through HTML.
This is my code:
my %attr = (
PrintError =>0,
RaiseError =>0
);
$dbh = DBI->connect(
"DBI:mysql:array;mysql_read_def
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);
> 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'});
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
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 a
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: [EM
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 data
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 er
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 fro
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 STRI
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
co
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
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
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
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
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 this
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 Win
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.
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 po
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.
GL,
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 hope
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]
Subje
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,
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 http://mail.yah
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 en
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 10:06,
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 co
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,
--
[EM
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
---
";
}
?>
Errors after browsing via web page:
---
Warning: MySQL Con
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: faile
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 post
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 Visual
1 - 100 of 110 matches
Mail list logo
