On Wed, Jul 09, 2003 at 01:08:56PM -0400, Dave [Hawk-Systems] wrote:
> >> load). Is there a known issue (running on FreeBSD 4.8,
> >> MySQL 3.23.55 MyISAM)?
> >
> >its been a known issue for quite a long time
> >use linuxthreaded version and it should work fine.
> >
> >although much of work has be
On Mon, Jul 07, 2003 at 10:57:52AM -0500, Dan Nelson wrote:
> In the last episode (Jul 07), Nils Valentin said:
> > Thank you for the superfast reply. I actually was looking for other
> > information. I understood the actual feature difference of the
> > standard and f.e max version. Sorry if this
hi
I am running one centralized mysql server, its runnig fine and conneded with
localhost and his own ip very fine.
But when i want to connect him from remote system or other lan system
it give me errror like that.
[EMAIL PROTECTED] root]# mysql -h 192.168.0.63 mysql
ERROR 2013: Lost connection to
It says lost error during query.. but I'd be suspect if it even
succesfully connected/authenticated..
I'd do a quick check first to ensure your mysql server is listening on the
192.xxx interface.. if it's unix, netstat -atn
On Thu, 17 Jul 2003, zafar rizvi wrote:
> hi
> I am running one cen
On Wed, Jul 16, 2003 at 10:10:35PM -0500, Dan Nelson wrote:
>
> I don't know exactly how LT allocates its threads
That, it turns out, is the key piece of info. :-)
We figured it out and are now testing the solution. If it holds up,
I'll post details soon.
> A possibly more interesting question
In the last episode (Jul 16), DePhillips, Michael P said:
> To be a bit clearer,
>
> should the MYI index files betweened two slaves of a mirrored
> database be different?
>
> I would think they would be identical, right?
If both master and slave are set up identically, then theoretically
they s
In the last episode (Jul 16), Jeremy Zawodny said:
> On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote:
> > In the last episode (Jul 16), Jeremy Zawodny said:
> > > Does anyone have MySQL built with LinuxThreads running on FreeBSD
> > > 4.x and handling more than 950 connections?
> > >
>
To be a bit clearer,
should the MYI index files betweened two slaves of a mirrored database be
different?
I would think they would be identical, right?
Thanks
-Original Message-
From: DePhillips, Michael P
To: [EMAIL PROTECTED]
Sent: 7/16/2003 6:18 PM
Subject: MYI file difference
Hi Al
Hi Henry,
You created an alias for a table columnname. But either you
either you created the alias twice with the same name or you are refering to
two columns (one in each table with the same name).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 16日 水曜日 23:35、Henry さんは書きました:
> I have 2 table
Asfar as I know that is the default settings in the mysql server to be
returned.
So you will have to set the necessary parameter from the mysql command line
client.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 16日 水曜日 22:32、Weir Travis さんは書きました:
> I have noticed that mySQL Control Center
Hi All:
I am trying to run mysql in a Windows XP environment. I downloaded the
binary and installation went smoothly. What I am expecting is that if I
have winmysqladmin in my startup it should launch and I should be able to
connect using the mysql control centre as my client. So far no joy.
Contents are Direct Alliance Corporation CONFIDENTIAL
-
I have a table with 10 cols. 8 of which all need to be searched on
independently of each other.
Does creating 8 separate indexes for that table affect the speed of how
mysql searches each index?
In other words would keeping my indexes to on
Hi All,
I tarred up the data directory from mirror1 data base - slave. Copied the
tarball to mirror2 with the hopes of rebuilding mirror2 - another slave.
Backed up the data directory from mirror2 into old and untarred mirror1
Then I did a diff -r against another mirror and the diff came ba
On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote:
> In the last episode (Jul 16), Jeremy Zawodny said:
> > Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x
> > and handling more than 950 connections?
> >
> > If so, did you need to do anything special to make it work?
This issue is closed. THANKS !
> -Original Message-
> From: Sagar, Sanjeev
> Sent: Wednesday, July 16, 2003 3:28 PM
> To: [EMAIL PROTECTED]
> Cc: Sagar, Sanjeev
> Subject: Error while using Mysqldump
>
> Hello All,
>
> I am using Mysql 4.0.13-max-log on Solaris 2.8
>
What Operating system are you using and how are you measuring
unresponsiveness?
--
Michael Conlen
Tim Fountain wrote:
This may be a silly question but what can be done to stop
load-intensive MySQL processes taking down a server? Things like
adding fulltext indexes to very large tables, or select
>
>
>
>
use this:
echo '';
where "0,0" is the result-set index for your mysql field. you might
use other mysql functions of course, but the place to put the output
in is the same
the html-source code will look like it is only a normal image path,
but the server sends the binary data
Hi,
I'm new to mysql. Coming from the oracle database a couple of questions
came up. Perhaps somebody, who has also experience in oracle, can set me
on the tracks.
Questions:
1. is mysql simular organized as oracle: instance/users/tables,
so that I have to connect to chossen instance and
On 16 Jul 2003 at 16:02, John Hicks wrote:
> Thanks for the reply, Rudy.
>
> My source for the statement that decimal values are stored
> as strings is:
> http://www.mysql.com/doc/en/Numeric_types.html :
DECIMAL values may very well be stored as strings, but presumably
you're going to do some
Hello All,
I am using Mysql 4.0.13-max-log on Solaris 2.8
If I run mysqldump like below
/usr/local/mysql/bin/mysqldump -u root -pabc -d -r
/usr/local/mysql/testbackup/schemadump.sql --all-databases
It abort with following error
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table '
In the last episode (Jul 16), Jeremy Zawodny said:
> Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x
> and handling more than 950 connections?
>
> If so, did you need to do anything special to make it work? I'm
> seeing this:
>
> Can't create a new thread (errno 35). If you
Dan Anderson wrote:
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
I've done some notes on this at
http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html
- assuming of course you're using PHP as a WWW backend to
dig the stuff o
Thanks for the reply, Rudy.
My source for the statement that decimal values are stored
as strings is:
http://www.mysql.com/doc/en/Numeric_types.html :
"DECIMAL and NUMERIC values are stored as strings, rather
than as binary floating-point numbers, in order to preserve
the decimal precision of
I need to find out if it's possible to do two things with mysql. The first is
external authentication, preferably with kerberos5, but PAM will work as well.
Second, encrypting the data stream. Specifically with jdbc connections.
--
MySQL General Mailing List
For list archives: http://lists.my
Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x
and handling more than 950 connections?
If so, did you need to do anything special to make it work? I'm
seeing this:
Can't create a new thread (errno 35). If you are not out of available
memory, you can consult the manual for
Could anyone tell me how to get past this error please? When I 'make
test' some of the tests run but then it dies with.
create [ pass ]
ERROR: /home/tekton/src/mysql-4.0.13/mysql-test/var/run/master.pid was
not created in 30 seconds; Aborting
Or can this be safely ignored
Hi,
I'm using mysql along with Postfix MTA and courier imapd to run a virtual
aliased domain email server. I have no problem connecting to and
retrieving mail when i use clear passwords, but when i have the imap
client try to connect using tls/ssl..it fails. I've read the docs and
know that i ne
Since the first query works, the second one should also work as it is
virtually the same. It is querying the same database using the exact
same query. The only difference is the variable names passed to it by
the form.
i.e.
$playerfrom may = Hossa
$playerto may = Alfredsson
$namefrom may = Bill
Hi,
This is a PHP issue not MySQL.
If anything got inserted at all it will be blanks for no where in your
code were your variables ('$productid', '$itemname', '$description',
'$price', '$information') defined.
Try this in the productsave.php code right at the TOP after your include
:
//(si
Hello Tim,
OK
>easiest thing to is cd to /tmp and issue "ln -s
/var/lib/mysql/mysql.sock
>mysql.sock"
What else can I do?
Oliver Etzel
-Original Message-
From: Oliver Etzel - GoodnGo.COM (R) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject:
Hello all,
after Installing mysql I started the mysql daemon.. The I tried to log
in to my mysql database and got the message could not find mysql.sock
in /tmp.
In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0)
I
changed the place for the socket file from
"socket=/var/lib/mys
Those are php notices (not warning or errors) .. change your ini error
reporting settings.. you can either disable those messages or correctly
initialize all variables before trying to use them.
I'd suggest posting your msg to PHP list..
On Wed, 16 Jul 2003, Prabu Subroto wrote:
> Dear my fr
Hi!
- Original Message -
From: "Blah Blah" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 16, 2003 7:03 PM
Subject: Re: 4.1.0 Roadmap ?
> Yes, any information at all would be helpful.
>
> daniel
>
> "Andy J" wrote in message
> news:[EMAIL PROTECTED]
> > Hi
At 9:02 -0800 7/16/03, Tim Johnson wrote:
Hello:
I'm using version 3.23.41.
How may I change the default value of
an existing table?
(type will remain the same)
Pointers to docs are welcome and invited.
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.a
Hmm...
I am running RedHat 8.0 with 2.4.18smp. The machine itself has been up for
270 days, but MySQL does crash from time to time and also sometimes tables
are corrupted. I think I may be left with trial and error at this point. I
will try the following things in order:
1. Install the forthco
Greetings all,
I have formerly installed mysql 4.0.12 on my machine running win2k
Advanced Sever, with Apache 2.0.46 and PHP 4.3.2. Somehow I messed up
my configuration file and decided to start the whole thing from scratch.
Now I hear that version 4.0.14 release date is only days away. My
quest
It is a Redhat 7.2 with a 2.4.7-10smp kernel.It was upgraded last
september and mysqld has never been restarted since then (mysqld
uptime is now 316 days).
Hope this helps
Joseph Bueno
Richard Gabriel wrote:
I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it
solved the probl
Hello:
I'm using version 3.23.41.
How may I change the default value of
an existing table?
(type will remain the same)
Pointers to docs are welcome and invited.
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http:
Thanks a lot
that is the solution
El Mié 16 Jul 2003 12:24, Egor Egorov escribió:
> Patricio Gigoux <[EMAIL PROTECTED]> wrote:
> > Hello:
> > I have 2 tables
> > t1:
> > id age
> > 1 7
> > 2 6
> > 3 7
> > 4 8
> > 5 9
> > 6 4
> >
> > t2:
> > age
> > 7
> > 9
Sure I could create an external process that will poll the process list every few
minutes but I was hoping for some direction on how to have the MySQL server do it
internally. At least that was my impression from reading the docs on the
'wait_timeout' value.
Paul
Rudy Metzger <[EMAIL PROTECTE
Have you checked the query in an editor to see if they are working?
Just substitute known values in the place of the variables you are
using.
Jef
> -Original Message-
> From: C. Reeve [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 16, 2003 10:16 AM
> To: [EMAIL PROTECTED]
> Subject: M
At 11:39 -0500 7/16/03, Gordon wrote:
I have 2 tables t and t1. In this case, t1 is a copy of t. I want to
delete rows from t1 based on criteria on the t table and a relationship
between t ad t1 (in this case the id column). In the results below, I
would think that the delete should have deleted ro
Hi,
i have a quick question in phpadmin when i create an Index on an none empty table.
i see that in Cardinality is either a number or has written None what does it mean??
Thank you
Anthony
hello,
i have what seems to me a very common operation i'm performing. i need to
find the balance on an invoice. i was not having any problems until the
production server was upgraded to mysql v4.0.13-standard for
pc-linux. there must be a better way to query for this information than
the m
I have 2 tables t and t1. In this case, t1 is a copy of t. I want to
delete rows from t1 based on criteria on the t table and a relationship
between t ad t1 (in this case the id column). In the results below, I
would think that the delete should have deleted row 1 {1 5 me) and not
row 3 (1 5 th
Place an echo in the productsave.php page and check the SQL query. If
the query that is getting passed is correct then the problem is on the
productsave page. Otherwise, your values aren't being passed to the
query.
Jef
> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent
> I tried but nothing
>
> At 10.52 16/07/2003 +0100, Andy Eastham wrote:
>>Try using only single quotes rather than a mixture of single and double
>> quotes?
>>
>>Andy
>>
>> > -Original Message-
>> > From: Sbandy [mailto:[EMAIL PROTECTED]
>> > Sent: 16 July 2003 10:32
>> > To: Rudy Metz
Patricio Gigoux <[EMAIL PROTECTED]> wrote:
> Hello:
> I have 2 tables
> t1:
> id age
> 1 7
> 2 6
> 3 7
> 4 8
> 5 9
> 6 4
>
> t2:
> age
> 7
> 9
>
> then I like select all in t1 without are in t2, so I need a result as follow
> id age
> 2 6
> 4
Hi,
Not sure if the problem here is PHP or MySQL, but here we go. I am
trying to do two queries on a database - one after the other, but the
second one never seems to get executed. The two queries are identical
except for two variables. I have checked my form and they are correct
and are being se
"julio" <[EMAIL PROTECTED]> wrote:
>I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have
> installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8.
> # make
> No suffix list.
To me it looks like you are running the wrong make, not GNU one.
>Can help me
What I have found that works, in PHP, is using a form that allows the
user to browse for a file or an image. Upon submitting the form the file
is uploaded to a set location on the web server and the name of the file
is added to the database.
When displaying the information associated with the imag
-Original Message-
From: Moritz Steiner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:46 AM
To: Jay Blanchard
Subject: AW: monitoring
I want to see:
Number of queries
Number of Connections
Network Data In/Out
Key writes
Key reads
Types of queries
Temporary and d
Hello:
I have 2 tables
t1:
id age
1 7
2 6
3 7
4 8
5 9
6 4
t2:
age
7
9
then I like select all in t1 without are in t2, so I need a result as follow
id age
2 6
4 8
6 4
Thanks in advance
--
MySQL General Mailing List
For list archi
Wy can't I start the service in windows 2003 server have any one a solusion?
Pleas help
Ivo tompert
Accidently?
You just asked if you could delete the .MYI table because of your disk
full error.
Oswaldo Castro wrote:
Hi Everybody
I have acidentally deleted an index file (.MYI) from a table. Is there another way, besides its backup, to recover this table ?
Thanks for any help
--
MySQL
[snip]
How are you monitoring on your databases? Who has a good solution?
[/snip]
What do you mean by monitoring?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How are you monitoring on your databases? Who has a good solution?
Moritz
Hi Everybody
I have acidentally deleted an index file (.MYI) from a table. Is there another way,
besides its backup, to recover this table ?
Thanks for any help
I'm having some trouble updating a mysql database with a perl cgi.
Here's the perl:
$sql = "UPDATE grants SET agency2 = \"$agency2\" WHERE agency2 = \"$key\"";
$rv = do($sql)
or die "Can't execute $sql: $dbh->errstr\n";
Here's the error returned in the browser:
Can't execute UPDATE grants
I don't Mysql very well, but I would be very surprised if that was
supported, based on my experience with Oracle. You need to distinguish
between data and database object names. You can use derived_tables to return
data, but niot names.
You can't do " select * from 'table'", because 'table' is a s
Kill them :)
http://www.mysql.com/doc/en/KILL.html
Cheers
/rudy
-Original Message-
From: PAUL MENARD [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 16:44
To: [EMAIL PROTECTED]
Subject: How to terminate dead connections that are in SLEEP?
Good morning all,
I have a problem with
Try this instead:
SELECT pubishers.pub_id, titles.pub_ID FROM pubishers JOIN titles ON
pubishers.pub_id = titles.pub_id
HTH.
** For great Emap magazine subscription & gift offers visit
http://www.emapmagazines.co.uk **
Good morning all,
I have a problem with inceasing connection to my database that eventually result in
connections being rejected. I know I have an application that is terminating a thread
without closing the database handle. Problem is I'm waiting for the fix on some other
changes.
Here i
I have 2 tables with the following fields :
table : publisher
field1: pub_id - Primary, int, auto
table : titles
field1: title_id - Primary, int, auto
field1: pub_id - int
Using sqlyog I noticed that the indexes had already been created for the
Primary keys but according to my tutorial I also h
I tried but nothing
At 10.52 16/07/2003 +0100, Andy Eastham wrote:
Try using only single quotes rather than a mixture of single and double
quotes?
Andy
> -Original Message-
> From: Sbandy [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 10:32
> To: Rudy Metzger; [EMAIL PROTECTED]
> Subj
Hi List
I got an "no space left on device" error.
Is there a way to drop an index without having MySQL create a temporary table?
Can I delete the .myi file directly from the operating system?
Thanks in advance
Oswaldo Castro
Prabu,
This is kind of off-topic, as it is a PHP problem. ;) Those error
messages are telling you that the variables you are trying to use were never
initialized. This suggests to me that your PHP installation is set up with
the register_globals option turned off. This means all of your
Hi
I'm hitting lots of brick walls after moving from an Access-driven website
(before it grew big) to MySQL, which is all new to me. The problems I have
centre around MySQL Server timeouts and various memory problems on the
server. The client's getting jumpy and I don't have much time so I'm hop
I have noticed that mySQL Control Center (beta 092), will only return back
1000 rows
whenever I doubleclick on a table that I know contains an amount greater
than 1000 rows.
I've checked all properties in mysqlcc and nothing makes a difference. When
I select the
table and then choose Return all
You can also use my native ADO.Net provider for MySql found at
http://www.bytefx.com
Thanks
Reggie
> -Original Message-
> From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 16, 2003 5:15 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Question: us
Ok, but this only works for the current session, if I close and restart the client the
settings are reset...
-Ursprüngliche Nachricht-
Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 16. Juli 2003 11:19
An: [EMAIL PROTECTED]
Betreff: Re: switch query logging whil
SELECT concat( substring_index(DATE,'-',-1),
'-',
lpad(
field(substring_index(substring_index(DATE,'-',2),'-',-1),
'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug',
'Sep','Oct','Nov','Dec'),
2,'0'),
I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it
solved the problem? What 2.4 version exactly did you run and was it a
RedHat kernel? Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Joseph Bueno"
What do you consider "high" volume? Also, please keep me in the loop on
this. Any configuration changes that help would be appreciated. Thanks!
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Tom Roos" <[EMAIL PROTECTED]>
To: "Ri
I need to convert dates in the format below into mysql date format. If I try to change
the column type to date, it wipes out the data.
+-+
| 26-Jan-2001 |
| 26-Jan-2001 |
| 15-Apr-2001 |
| 1-Nov-2001 |
| 31-Oct-2001 |
| 26-Jan-2001 |
| 22-Jun-2001 |
| 23-Jul-2000 |
| 1-Nov-2001 |
|
Aric,
Are you running the linux version of your database on a shared web host?
Some web hosts prevent you from using % as a host identifier for security
reasons. I would also check to see if the permissions were defined at the
proper level (in other words, have you set up access prvis for
I am running the current version which is labeled ColdFusion MX. According
to Macromedia, you need a Pentium Processor, 128M RAM Minimum, 256M RAM
recommended, and 512M RAM preferred, and 350M id HD space. I was running
MySQL, Apache standard & secure, Sendmail for 25 people, ColdFusion MX, an
For the following I am assuming you didn't edit that output for security
reasons. What I see immediately wrong is that you are not passing a
username to mysql (If you were, then there would be something like
'[EMAIL PROTECTED]' there). Of course you can set MySQL up so that it does
not require a
SELECT EXTRACT(HOUR_SECOND FROM "1999-07-02 01:02:03");
-Original Message-
From: Johannes Pretorius [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 13:32
To: [EMAIL PROTECTED]
Cc: Pieter
Subject: RE: Simple newbie question - CURTIME()
Thanks
\0-\-==-0-=
I have seen my error and hav
Hi,
I have installed MySQL on Windows98se twice under different paths, and then
deleted the second installation. When i run MySQL as usual using the line
"C:\Program Files\nusphere\mysql\bin\mysqld-opt.exe" , i get the following
error msg:
C:\Program Files\nusphere\mysql\bin\mysqld-opt.exe: Fatal
Thanks
\0-\-==-0-=
I have seen my error and have changed it to be as follows :
//== SNIP ==
mysql> select date_add(now(),INTERVAL 6 HOUR);
+-+
| date_add(now(),INTERVAL 6 HOUR) |
+-+
| 2003-07-16 19:00:
WRONG!
What will happen in this case? The DB is converting/casting the DATE
(curtime()) into an integer and then ads 6. So what you get does not
necessarily represent a valid date/time!
Just replace 06 with 24 and see what you yet.
Cheers
/rudy
-Original Message-
From: Joha
You can access a mysql database within VS.Net through odbc. To do this
you have install myodbc. You can get this from mysql website. After
installing myodbc you have to create a new datasource. Then you can
connect to mysql with the help of adodb object in vs.net. I have never
tried to connect
While accessing MySQl data base by means of perl the value of variable $! sometimes
equals " Resource temporarily unavailable". At the mean time everything works correct.
What does that mean?
___
http://chat.bigmir.net/ - ñàìûé óäîáíûé
Thanks I have figured it out, I only have to add 06 to the curtime()
function as example :
//== SNIP
mysql> select curtime() + 06 as TimePlus6, curtime() as TheCurrenTime;
+---+---+
| TimePlus6 | TheCurrenTime |
+---
I'm trying to build mysql from the development sources of mysql 4.1.,
retreived using bitkeeper under win2k using cygwin.
I have made "bk -r edit", and now I'm having a problem
running aclocal:
aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library
When I make "automake --version" a
Try using only single quotes rather than a mixture of single and double
quotes?
Andy
> -Original Message-
> From: Sbandy [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 10:32
> To: Rudy Metzger; [EMAIL PROTECTED]
> Subject: RE: Can someone help me??
>
>
> I use phpmyadmin
>
> At 11.26 16/0
I use phpmyadmin
At 11.26 16/07/2003 +0200, Rudy Metzger wrote:
Did you do that on the mysql command line? Or did you use a different
client and/or API?
Cheers
/rudy
-Original Message-
From: Sbandy [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 11:21
To: [EMAIL PROTECTED]
Subject: C
If you manually updated the tables, use flush privileges to inform the
DB server of your changes.
Cheers
/rudy
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 11:23
To: [EMAIL PROTECTED]
Subject: Re: Connection problem!!! Windows to Linux
Aric
Did you do that on the mysql command line? Or did you use a different
client and/or API?
Cheers
/rudy
-Original Message-
From: Sbandy [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 11:21
To: [EMAIL PROTECTED]
Subject: Can someone help me??
I am new in mysql
I wrote this query
Aric Cheah <[EMAIL PROTECTED]> wrote:
>
> I wrote a program application for windows which can add and delete data
> from this application, it working fine with my own MySQL install on the
> same windows OS.. Now I try to change the connection this dayabase to
> the server whihc runnign under l
I am new in mysql
I wrote this query:
INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione,
ordine, codice) VALUES (10 ,6 ,5 ,"10 - 99:" ,12 ,50 ,'S12IT3' )
and server reply to me:
Query was empty
Can someone tell me where i do mistake?
Thanks a lot..
Sbandy
[EMAIL PR
[EMAIL PROTECTED] wrote:
>>Description:
> It would be nice if general query logging could be switched on and off
> while the MySQL server is running, and not only at startup time.
> While debugging an application that uses foreign database access
> libraries, this would be very helpful. One could s
I think it is the code in functions you need to look at or the path in one of
your ini files :)
Andrew
>-Original Message-
>From: Prabu Subroto [mailto:[EMAIL PROTECTED]
>Sent: 16 July 2003 10:14
>To: [EMAIL PROTECTED]
>Subject: first time to use MySQL on MS Platform with PHP.
>
>
>Dear m
These are not real subselects. You speak of a subselect when you are
define a select in the FROM clause of a kwiri. If you define them in the
WHERE clause, you speak of derived tables. Putting them even into the
SELECT clause is something specific to MySQL (as far as I know).
Ok, now this is theor
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
"
Notice: Undefined variable: product
Johannes Pretorius <[EMAIL PROTECTED]> wrote:
> I have looked in the manual and seem to be missing it or not understanding
> correctly,
>
> The curtime() function resturns the current server time. my problem is the
> clients are not in the same
> country as the server, thus the time of the syst
Hi Everybody,
1- I am trying to upsize an access database to my MySQL server on my
website. I tried to get connected within access and failed. Please advise. I
am using Win XP as the operating system and MS Office XP Pro.
2- How to connect a Visual Studio.NET project to a MySQL data base locate
Please check the manual, search for DATE_ADD().
/rudy
-Original Message-
From: Johannes Pretorius [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 8:01
To: [EMAIL PROTECTED]
Cc: Pieter
Subject: Simple newbie question - CURTIME()
Good day
\-=0=-=00-
I have looked in the manual and
InnoDB is using a totally different concept than MyISAM. Where in MyISAM
all the data is in one file, InnoDB uses the principle of Tablespaces
(like ORACLE). This puts the whole tables (and metadata) into one HUGE
file (in theory. In practice this file can be split and extends can be
defined of how
1 - 100 of 118 matches
Mail list logo
