On 07/04/2013 01:15 PM, Emmy Santi wrote:
my name is Effiong Emmanuel.I love your products and your ways of helping
human.pls can you send me MYSQL COMPILER to enable me install it in my laptop
computer and practice.I will be gratefull if my request is kindly granted.
what do you refer to w
Using deductive reasoning one would surmise that Effiong wants to
install the MySql Database on a laptop,
But then the question to Effiong is:
What Operating System is running on your LapTop?
NOTE: You'll need a MySql Server and a MySql Client, and maybe a Gui
Interface/WorkBench?
You can do
Am 03.07.2013 14:50, schrieb Emmy Santi:
> my name is Effiong Emmanuel.please, I love your products and your ways
> helping human.pls can you send me MYSQL COMPILER to enable me install it in
> my laptop computer and practice.I will be gratefull if my request is kindly
> granted.
what are yo
Hi,
On Thu, June 14, 2007 18:16, Jake Peavy wrote:
> Hi all,
>
> Can someone suggest a good method or normalized schema for storing product
> information (id, description, price) which changes over time so that as a
> product is gradually discounted, an order will reflect the cost of that
> partic
Hi,
It works, thanks you for your help :-)
ViSolve DB Team wrote:
Hi Gabriel,
Try as:
mysql > select * from forum where topoc like "%%";
To search for '\', specify it as ''; this is because the
backslashes are
stripped once by the parser and again when the pattern match is made,
l
Hi Gabriel,
Try as:
mysql > select * from forum where topoc like "%%";
To search for '\', specify it as ''; this is because the backslashes are
stripped once by the parser and again when the pattern match is made,
leaving a single backslash to be matched against. (Exception: At the end o
Bruce Carey wrote:
> - my problem is that when a text field, with html in it, it makes it
> into several hundred recs
Well, that's strange -- I use mysqldump to dump/xfer/load records
with fields containing HTML regularly, using the mysqldump defaults,
and have no problems.
Have you tried the de
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different line/r
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different lin/re
Bruce Carey wrote:
> I posted this earlier, could someone take a look at it?
In the time since you first posted, you could have at least glanced
at the Fine Manual :-) which shows that:
>> mysqldump --opt --fields-terminated-by='\t'
>> --fields-optionally-enclosed-by='#*#*#'
Any of the field-
I posted this earlier, could someone take a look at it?
TIA,
Bruce.
On Mon, 19 Dec 2005 02:15:54 -0500
"Bruce Carey" <[EMAIL PROTECTED]> wrote:
Hi List,
I have recently had a crash coursh in the fineer points
of db recovery due to a mis-managed server.
Could someone help me out with advi
n" <[EMAIL PROTECTED]>
> To: "Bruce Feist" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, 11 July, 2003 22:16
> Subject: Re: Request modelling
>
> 2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> > Hi Bruce;
> >
>
<[EMAIL PROTECTED]>
To: "Bruce Feist" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, 11 July, 2003 22:16
Subject: Re: Request modelling
2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> Hi Bruce;
>
> Thank you for the reply.
>
> I passed the core
Hi Bruce,
Thank you for the reply.
Just for the record the options order must be
SELECT schedule_id,count(schedule_id)
FROM attendance
GROUP BY schedule_id
HAVING count(schedule_id) <10;
(swapped GROUP BY and HAVING)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 10:20、Bruce Fe
Hi Bruce;
Thank you for the reply.
I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Thank you very much for the reply.
Best regards
Nils Valentin
2003年 7月 12日 土曜日 10:20、Bruce Feist さんは書きました:
> Nils Valentin wrote:
> >I would like to list all courses with have less t
2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> Hi Bruce;
>
> Thank you for the reply.
>
> I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Aeeh thats was supposed to be ... life and learn..
Perhaps somebody knows a good spellchecker for logical mistakes ?? ;-)
That woul
Hi John,
Thank you for the reponse. I tried that (I didnt post it here), but that gives
me the error
mysql> SELECT schedule_id,count(schedule_id) AS ct FROM attendance WHERE ct<10
GROUP BY schedule_id ;
ERROR 1054: Unknown column 'ct' in 'where clause'
Best regards
Nils Valentin
Tokyo/Japan
Nils Valentin wrote:
I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?
schedule_id is the course itself
SELECT schedule_id,count(schedule_id) FROM attendance WHERE
count(schedule_id)
On Fri, 2003-07-11 at 13:41, Nils Valentin wrote:
> Hi MySQL Fans ;-)
>
> I would like to list all courses with have less than lets say 10 participants.
> Does anybody know how I would have to modify the code below to get this to
> work ?
>
> schedule_id is the course itself
>
>
> SELECT sche
On Wed, Apr 02, 2003 at 11:14:56AM -0800, Michael Shulman wrote:
>
> Please try to use more informative subject lines in your
> queries. You'll be more likely to get good help quickly.
Agreed.
I simply delete messages with subject lines that don't say anything
specific.
I wish ISPs asked all th
Alex:
It appears you use the following mailer:
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
Use this link to unsubscribe to this list:
http://lists.mysql.com/php/unsubscribe.php
I'm so tempted to say more, but I'm restraining myself considering the mailer
you us
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:12 AM
Subject: Re: request
If it is not, his computer should probably not have been on to begin with.
:)
- Mark
> if it's not you have probably just shamed hi
if it's not you have probably just shamed him into never turning his computer
on again.
Quoting Chris Knipe <[EMAIL PROTECTED]>:
> LOOL! This *IS* a joke right? ;)
>
> - Original Message -
> From: "lateef ayinla" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday,
LOOL! This *IS* a joke right? ;)
- Original Message -
From: "lateef ayinla" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:13 AM
Subject: request
> Dear sir,
> i come across yourmanual [mySQL Reference] when browsing
through the i
Hi,
Perhaps try to upgrade first from 4.0.0 to 4.0.3 to see if the problem still
happens ? (many fixes have been introduced, especially on FT search)
Regards,
Jocelyn
- Original Message -
From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 01,
Hi,
If i understand well, you wish to use MySQL C API function in VBScript.It's
not possible in this way.
But why you don't wish to use ADO?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi,
I just got this similar problem in mysql install. I fixed this by ignoring
the follow line in /etc/my.cnf :
socket=/tmp/mysql.socket
Hope this help you.
Hung Lam
- Original Message -
From: "Subbiah Nishant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 14,
',subject='$subject',carbon='$carbon',body=
'$body',postedby='$postedby' WHERE idx='$idx'";
$result = mysql_db_query("e-bulletin", $query);
$query = "SELECT * FROM czz";
$result = mysql_db_query("e-bulletin", $query);
my
',subject='$subject',carbon='$carbon',body=
'$body',postedby='$postedby' WHERE idx='$idx'";
$result = mysql_db_query("e-bulletin", $query);
$query = "SELECT * FROM czz";
$result = mysql_db_query("e-bulletin", $query);
my
p?idx=$idx&date=$date&too=$too&subject=$subject&carbon=$
> carbon&body=$body&postedby=$postedby\">Edit
> ";
>
> }
>
> echo "";
>
> } else {
>
> echo "No data.";
>
> }
>
> mysql_free_result($result
ginal Message -
From: "Andreas Frosting" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 09, 2002 10:06 AM
Subject: RE: Request-URI Too Large
> > I'm using php and mysql as my server, when I'm updating a large
> > page on my database u
> I'm using php and mysql as my server, when I'm updating a large
> page on my database using a browser I get
> "Request-URI Too Large
> the requested URL's length exceeds the capacity limit for this server.
> request failed: URI too long"
> Why is this so? Do I need to adjust something on mysql
Andreas,
If anyone else is interested, I have solved the problem in stepwise/tutorial fashion
below (best viewed using a
fixed font).
If anyone is skilled in the user of FROM...JOINs, (I'm sure Andreas, and) I'd welcome
a critique/any
improvements!
I have taken a look at this problem, and bein
That would be great. Thanks!
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message-
> From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 10:45 pm
> Subject: RE: Request for help in testing new replication code in 4.0.2
it up if it's something you might find useful.
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:41 PM
To: 'Sasha Pachev'
Cc: 'Mysql'
Subject: Re: Request for help in testing new replication code in 4.0.2
&g
X]
> Sent: Sunday, February 10, 2002 3:28 PM
> To: XXXX
> Subject: Re: Request for help in testing new replication code in 4.0.2
>
>
> On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn
> [Presence-PC] wrote:
> > Hi,
> >
>
> > * If you want to do it this very moment, read the instructions at
> >http://www.mysql.com/doc/I/n/Installing_source_tree.html and
install a
> > pre-release 4.0.2 MySQL on your test server. You may also wait until
4.0.2 is
> > released, but in that case, replication in 4.0.2 may have a bug
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> So I need your help with field testing of my code. For those of you
> who are wondering why you should - this will help us stabilize 4.0 a
> lot of faster, and not only replication, but also the general SQL
> features. So if you de
I don't actually see the error message in the output you sent. but I found a
similar problem yesterday and have the following work around:
= myisamchk.c 1.69 vs edited =
*** /tmp/myisamchk.c-1.69-20535 Thu Feb 7 17:21:33 2002
--- edited/myisamchk.c Sat Feb 9 22:48:57 2002
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> In myisamchk.c replace the following line :
>
>if (argument && *argument == '0')
> DBUG_POP();
> else
> DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
>
> by
>
> if
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> Dear MySQL users,
>
> I have just pushed my latest changes in the replication code in our
> 4.0 development tree, which change the slave to use two threads -
> I/O thread that gets the data from the master and logs it, and SQL
> thre
> * If you want to do it this very moment, read the instructions at
>http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a
> pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2
is
> released, but in that case, replication in 4.0.2 may have a bug you cou
On Sunday 10 February 2002 02:20 pm, Jeremy Zawodny wrote:
> I run `BUILD/compile-pentium --prefix=/home/mysql` and it fails after
> several minutes. ?The output is large, so I've posted it here:
>
> ? http://public.yahoo.com/~jzawodn/mysql-build.log
>
> (the good stuff is at the end, of course.
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
On Sunday 10 February 2002 06:06 pm, Jeremy Zawodny wrote:
> One question:
>
> ? Can you explain the relay log a bit. ?Does it shrink eventually? ?I
> ? see it growing and growing, so I don't know if the space is
> ? recycled, or if I need to do something to periodically flush the
> ? executed qu
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> So I need your help with field testing of my code. For those of you
> who are wondering why you should - this will help us stabilize 4.0 a
> lot of faster, and not only replication, but also the general SQL
> features. So if you de
I don't actually see the error message in the output you sent. but I found a
similar problem yesterday and have the following work around:
= myisamchk.c 1.69 vs edited =
*** /tmp/myisamchk.c-1.69-20535 Thu Feb 7 17:21:33 2002
--- edited/myisamchk.c Sat Feb 9 22:48:57 2002
On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> In myisamchk.c replace the following line :
>
>if (argument && *argument == '0')
> DBUG_POP();
> else
> DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
>
> by
>
> if
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 10:20 PM
Subject: Re: Request for help in testing new replication code in 4.0.2
> On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> > Dear MySQL users
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> Dear MySQL users,
>
> I have just pushed my latest changes in the replication code in our
> 4.0 development tree, which change the slave to use two threads -
> I/O thread that gets the data from the master and logs it, and SQL
> thre
> * If you want to do it this very moment, read the instructions at
>http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a
> pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2
is
> released, but in that case, replication in 4.0.2 may have a bug you cou
Anything you could want to know, and more, can be found here:
http://www.mysql.com/downloads/gui-mysqlgui.html
Mike
[EMAIL PROTECTED] wrote:
>Hello,
>I have the Mysql 3.23.27-beta version installed on my Windows NT PC and I am able to
>create the database and query from the command line and f
You can also use a tool like urSQL (http://www.urbanresearch.com/ursql) to
convert the table schemas. urSQL has the ability to save MySQL tables as
MS Access CREATE TABLE scripts and the ability to build a script of insert
statements that can be run against the new table. (You can also save MS
A
:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 11:22 AM
To: Rob Vonsee
Cc: [EMAIL PROTECTED]
Subject: Re: Request for information (MS Access & MySQL)
Rob Vonsee wrote:
> Dear developer,
>
> In the past several years, we have developed a database application in
> MicroSoft's A
Rob Vonsee wrote:
> Dear developer,
>
> In the past several years, we have developed a database application in
> MicroSoft's Access '97.
> With our user base growing, we're encountering more and more limitations in
> the Microsoft development environment, especially in the stability and
> number
Rob,
You may start by checking the utility at download.com that claims to be
able to convert Access to MySQL databases. I am currently trying to get
a company off of Access 2000 and onto MySQL in America, but I have not
tried this tool yet and any reviews from someone that knows Access well
are w
Hi,
> > I have a feature request: How about adding a built-in function
> to convert
> > IP addresses from strings to "INT UNSIGNED", and another function to
> > convert vice versa.
> Have you taken a look at INET_ATON and INET_NTOA functions ??
Yes, you might want to take a read of section 7.4.
"Philip " <[EMAIL PROTECTED]> writes:
> Hello,
>
> I have a feature request: How about adding a built-in function to convert
> IP addresses from strings to "INT UNSIGNED", and another function to
> convert vice versa.
>
> This makes it easier for e.g. people whose web applications log IP
> addre
In the last episode (May 24), Michael Widenius said:
> - Message from "Joshua J. Kugler" <[EMAIL PROTECTED]> -
>
> Joshua> So, I can "SELECT id FROM table_name WHERE id IS NULL" as many times as I
> Joshua> need/want to, and it will return the proper value. Very nice.
>
> Joshua> So,
I understand you reasoning. If you don't change the official source code, I
can always make the change when I get a new version. Whatever you feel is
best.
But what scares me is a comment in the source code by the line I commented
out:
/*
** Handles this special case for some ODBC applicati
Joshua J. Kugler writes:
> I've been arguing with MS Access lately. Fortunately, I won. But only
> because I had the source to MySQL available. Here's the situation:
>
> (If you're looking for the feature request, skip to the end of the e-mail.
> This message is a summary of a series of mes
On Tue, May 22, 2001 at 04:21:03PM +0200, Pascal Bruyere wrote:
> I'd like to know how many similtanous request support a MySql
> database .
It depends on the hardware/software involved, but you can pretty
easily handle a few thousand on good hardware and a good operating
system.
Jeremy
--
Jer
I think you've got the wrong list.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 24, 2001 6:33 AM
To: [EMAIL PROTECTED]
Subject: ..request...
Hi,
I would like to know if I need to give a permission to t
Hello.
On Mon, Mar 12, 2001 at 05:16:59PM -0600, [EMAIL PROTECTED] wrote:
> Seems like it would be relatively easy to implement inserting into merge
> tables. I'd like to be able to at an absolute minimum round-robin
> insert, but even better would be something like you can do with
> partitioning
Get the New Riders MySQL book. It is a very good tutorial and reference on
MySQL. You should also look at the online documentation.
The setup and configuration of MySQL is very simple. In addition, my
preliminary test show that it is very fast. I have almost 500,000 records
stored and loo
68 matches
Mail list logo
