I took 5 points with 10$, your book deserve only 1 ! :)))
So I have 4 more points left to look for other books in one month I have
subscription.
It will take a couple of days to copy it in my HD as html. I take a first
look to the book at the same time.
Thanks Safari! (and Paul of cource )
Maki
Do you mean when you retrieve data from the database? If so, yes, it has
this ability. Look at the ORDER BY clause that is part of the SELECT
statement.
http://www.mysql.com/doc/S/E/SELECT.html
--jeff
- Original Message -
From: "Paul Wallace" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Why don't my replies go to the list, instead of the person posting the
message? Is this the way it's supposed to be on this list? Here's one I sent
earlier that didn't make it to the list...
-
I'm going to be implementing a keyword search pretty soon myself, so I'd
Hello,
Further to my last entry, and hopefully more simple, does MySQL have the
capability of sorting data alphabetically using the ROMAN alphabet? Ie A-Z.
Thanks for all input
Paul.
-
Before posting, please check:
http
I have some tables, with the rows like below:
mysql> select count(*) from job_main;
+--+
| count(*) |
+--+
| 6835 |
+--+
1 row in set (0.00 sec)
mysql> select count(*) from company_main;
+--+
| count(*) |
+--+
| 8177 |
+--+
1 row in set (0.
Hi David,
Does this work for you?
select customer.custcode, bookings.cust from customer left join bookings on
customer.custcode=bookings.cust
group by (customer.custcode) having max(ifnull(bookings.stdt,'-00-00')
<= '2002-02-16';
Regards,
Anvar.
At 09:06 PM 26/02/2002 +, you wrote:
>
I was successful to get result from select (this sub-select appear in MySQL
manual).
At 21:20 26/2/2002 -0600, Paul DuBois wrote:
>At 9:18 +0700 2/27/02, Sommai Fongnamthip wrote:
>>Hi,
>> MySQL has insert into function and sub select (mysql style) but
>> I could not conclude these func
Hi,
On Wed, 2002-02-27 at 02:55, JW wrote:
> Hello,
>
> We're been running a pretty large MySQLd with InnoDB support, last night it
> crashed on us in the middle of the night. I have never sent in a bug report
> like this before so please give me a little slack. I do not have any clue as
> to
At 22:05 -0500 2/26/02, John Fulton wrote:
>I have to port a DB from a system with mysql_3.23.33 to a system
>with mysql_3.22.32. The older system does not seem to have the
>source command. root is too busy to talk to me. Do any of you
source was added in MySQL 3.23.9.
>know if disabling sour
At 9:18 +0700 2/27/02, Sommai Fongnamthip wrote:
>Hi,
> MySQL has insert into function and sub select (mysql style)
>but I could not conclude these function togethter.
>
> If I want to select not existing row in 2 table, I used:
>
> SELECT table1.* FROM table1 LEFT JOIN ta
I have to port a DB from a system with mysql_3.23.33 to a system
with mysql_3.22.32. The older system does not seem to have the
source command. root is too busy to talk to me. Do any of you
know if disabling source is an option he could have used to keep
his system more secure or is it a ver
Hi,
I wish to alphabetically sort data retrieved from MySQL using JSP for
web a page. The data will be stored in Japanese. I understand there are
multiple alphabets/dialects in Japanese with a large number of characters
for each, so this may be difficult / impossible (for the Japanese out ther
if you decide to display only first 4 item try to used limit clause after
the SQL statement. otherwise use any count variable within your loop.
Sommai
At 20:33 26/2/2002 -0600, Paul DuBois wrote:
>At 18:42 -0600 2/26/02, Craig Westerman wrote:
>>The following lists 12 items from a fruits table
At 18:20 -0800 2/26/02, David M. Goodstein wrote:
>I've set up an ssh tunnel between my local machine and a remote host
>("Fred") as follows:
>ssh daveg@fred -L 3306:localhost:3306
>in an effort to access a remote mysql database running on fred. I've
>verified that the tunnel is working by te
At 18:42 -0600 2/26/02, Craig Westerman wrote:
>The following lists 12 items from a fruits table.
>
>$results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice
>FROM fruits");
>while ($data = mysql_fetch_array($results))
>{
>?>
> - -
> -
>}
>
>How would I modify the loop to disp
I've set up an ssh tunnel between my local machine and a remote host
("Fred") as follows:
ssh daveg@fred -L 3306:localhost:3306
in an effort to access a remote mysql database running on fred. I've
verified that the tunnel is working by telnetting into fred 3306 and
seeing the mysql version inf
Hi,
MySQL has insert into function and sub select (mysql style) but I
could not conclude these function togethter.
If I want to select not existing row in 2 table, I used:
SELECT table1.* FROM table1 LEFT JOIN table2 ON
table1.id=table2.id where table2.id is null
t
MySQL 3.23.46, running on Linux (redhat 7.1 w/ 2.4.17 kernel).
Static binary MySQL distribution from mysql.com.
Getting these errors on the slave:
020226 17:29:26 Slave: Failed reading log event, reconnecting to retry, log
'korean-bin.011' position 5252923
020226 17:29:26 Slave: reconnected
Dear all,
How to make MySQL with Chinese Big5 support? Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
www.phpbuilder.com
www.hotscripts.com
www.devshed.com
Good Luck
Mark
-Original Message-
From: Floyd Baker <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, February 26, 2002 6:03 PM
Subject: running mysql w/php..
>
>Hi.. Can anyone tell me some good places
Hi All,
I am trying to compile php with mysql and apache into it, however during the
./configure, I keep getting "Invalid Apache directory - unable to find
httpd.h under /usr/include/apache", even though that is where the header
file httpd.h is. I am using Redhat 7.1. does anyone know the rigth p
Hi Everyone,
This was my bad. I forgot that I had encoded all passwords with
base64_encrypt() in PHP. So, the passwords in the database weren't in their
plaintext forms. So, my password wasn't matching up with what was in the
database.
Everything works good now. :)
Thanks for your help!
tyl
Hi.. Can anyone tell me some good places to look for sample snips,
tutorials or other assistance specifically for making PHP and mySQL
cooperate. Running mysql queries using php syntax. Mysql talks about
mysql queries, etc. and php talks about php functions, etc. but I'm
finding it difficult w
Problem:
1. in a phone book, a single field may contain several words, e.g.
District 52 Police Station.
2. The query for this record may contain some or all of these words, but not
necessarily in that order, e.g. Police district 52.
3. Searching for all of the query words can be done in many w
Roger:
I found using variables to work as expected with 3.23.43 and Win98.
I was unable to duplicate your changing outputs.
mysql> select @a:=digits,number,round(number,@a) from testme;
++--+--+
| @a:=digits | number | round(number,@a) |
++--
The following lists 12 items from a fruits table.
$results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits");
while ($data = mysql_fetch_array($results))
{
?>
- -
-
<>
[EMAIL PROTECTED]
-
Befo
Greetings MySQL Enthusiasts:
Blue World is proud to announce the release of Lasso Professional 5,
with an embedded MySQL database server.
For details, visit:
http://www.blueworld.com/blueworld/news/02.26.02-LP5Release.html
Cheers!
CC
--
-
Has anyone tried to use Mysql++ with Microsoft Visual C++ .NET?
Better yet, has anyone had any luck and how?
Thanks for your help,
Josh
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
You could create a table that is the combination of manufacturer and
products table, with identical column and key information as the custom
table -- call this say manprod table, then create a merge table from the
manprod and custom table, and run one select query against the newly created
merge t
Try:
UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND
password='myfakepassword';
I am using and it works fine.
-- Stewart
--- Tyler Longren <[EMAIL PROTECTED]> wrote:
> Well, here's the query that PHP is generating:
> UPDATE users SET board_posts=board_posts+1 WHERE us
Boy, that was easy. I just figured it out after sending the question:
mysql> SELECT period,hours FROM log GROUP BY MONTH(period);
-Original Message-
From: Forer, Leif
Sent: Tuesday, February 26, 2002 5:32 PM
To: '[EMAIL PROTECTED]'
Subject: group by month
There is a date column in a
There is a date column in a table and I want to select data from the table
by month (instead of by every single entry within each month).
Here's a sample of the table:
mysql> SELECT period,hours FROM log GROUP BY period;
++---+
| period| hours |
++---+
| 1
Hi Dan,
Your suggestion works but it slows down things a lot.
Thats just a workaround, my quick tests showed it takes about 30% longer for
the query to complete...
It seems to be a bug in mysql, but the problem is that my whole thing is
running fine on a bigger production system and I'd not lik
Good afternoon, list!
I am attempting to figure out how to get the following two queries smashed into one.
Both of these
work very well on their own. I am not sure if this is possible, but it seems like it
should be :-)
=-=-=-=-=
QUERY #1
=-=-=-=-=
SELECT
mt.manufacturer,
pt.model,
rt.qty
Nope, privs are the same.
Tyler
- Original Message -
From: "Daniel Rosher" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>; "DL Neil"
<[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 5:19 PM
Subject: RE: "SET field=field+1" no longer w
On Tue, Feb 26, 2002 at 05:43:25PM -0500, Mark Engelhardt wrote:
> Hello everyone...
>
> I am looking for some thoughts and recommendations...
>
> We are going to upgrade our production mysql servers
> tomorrow... What version of mysql should we run with --It MUST be
> stable-- so we can have th
Have privileges changed?
Dan
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 27 February 2002 11:55 a.m.
> To: DL Neil
> Cc: MySQL List
> Subject: Re: "SET field=field+1" no longer works?
>
>
> Well, here's the query that PHP is generating:
> UPDA
At 15:00 -0800 2/26/02, Scott Broderick wrote:
>Hello group! I am a newbe to this listing.
>
>What I am attempting to do is pass a number like "0123456" to a field in the
>mysql database which is setup as int(11) but for some reason, the zero is
>not
>written into the database but instead all that
Perhaps this is something like what your looking for?
select
substring(round(number,digits) ,1,instr(round(number,digits),'.')+digits) as
roundednumber,digits,number
from testme
Regards,
Dan
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 27 February 2
On Tuesday 26 February 2002 4:00 pm, Scott Broderick wrote:
> Hello group! I am a newbe to this listing.
>
> What I am attempting to do is pass a number like "0123456" to a field in
> the mysql database which is setup as int(11) but for some reason, the zero
> is not
> written into the database bu
Hello group! I am a newbe to this listing.
What I am attempting to do is pass a number like "0123456" to a field in the
mysql database which is setup as int(11) but for some reason, the zero is
not
written into the database but instead all that is written into that field is
"123456"
What am I doi
At 14:31 -0800 2/26/02, John D. Kirkpatrick wrote:
>I have tried to create a MySQL table with the following lines:
>
>$query[] = "CREATE TABLE member (
>IDbigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
>userName varchar(40) NOT NULL,
>.
>.
>.
>
>RecordCreationTime TIMESTAMP
Well, here's the query that PHP is generating:
UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND
password='myfakepassword'
If I copy and paste that exactly into the mysql client, it's executed
correctly. If I use phpMyAdmin to execute it, it IS NOT executed correctly
(same as
At 13:08 -0500 2/26/02, Philip Mak wrote:
>On Tue, Feb 26, 2002 at 12:03:25PM -0600, Paul DuBois wrote:
>> >it set the integer columns to 0 if they were blank in the text file.
>> >How can I make it set those to NULL instead?
>>
>> You'll have to preprocess the file to convert empty fields to \
I have tried to create a MySQL table with the following lines:
$query[] = "CREATE TABLE member (
IDbigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
userName varchar(40) NOT NULL,
.
.
.
RecordCreationTime TIMESTAMP NOT NULL DEFAULT '0',
LastLoginTIMESTAMP NOT NULL
Hi!
My name is Ricardo Castro and i'm writing for Ensenada, Mexico. My problem
installing MySQL is next:
I've unzipped MySQL (mysql-max-3.23.49-pc-linux-gnu-i686.tar.gz)in /usr/local/;
i've follow all the steps that the INSTALL-BINARY indicates; but i have the
problem that in the moment t
Is there any database only (currently I'm doing this in perl) solution
to update a record or insert it if criteria isn't met:
for example, I have a table:
mysql> describe tblHits;
++--+--+-+-+---+
| Field | Type | Null | Ke
Hi, new to the list.
I mainly run Novell Netware servers for myself and my customers. I
assume most of you are running Linux and other OS's as well. I do have
a Linux system with MySQL, but because of my lack of Linux knowledge, I
am trying to find out if anyone has a source for MySQL and Netwa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I'm about to embark on a rather large project using MySQL, and am
eagerly awaiting fail-safe replication. However, due to deadline
restraints, I need to get started right away... I'm willing to
develop using beta, but I was wondering when fail-
Sasha, I am on Rehat 7.2 and am experiencing exactly the same signal 4
problem. I have pasted the ouput from the rpm install, execution of the
mysqld with --log, and as you requested, the cat info for my box.
RPM -i output
~~
> rpm -i M
It's late, and I'm being dumb, so can anyone help ?
I know that
select customer.custcode, bookings.cust from customer left join bookings on
customer.custcode=bookings.cust
where bookings.cust is null;
will show me all customers with no corresponding entry in bookings table.
But I want to know
Thanks for the article it is definitely helpful and narrow down my choice.
Anything against the 4.0 MAX here?
|-+>
| | "Tyler Longren" |
| | |
| ||
| | 0
Hello,
I'm trying to optimize a table but not sure what more I can do. I have a
table like the following:
CREATE TABLE `outgoing` (
`rpath` varchar(80) default NULL,
`auth` varchar(80) NOT NULL default '',
`ip` varchar(80) default NULL,
`hfrom` varchar(80) default NULL,
`hto` varchar(8
I'm having an issue with BLOB columns (MEDIUMBLOB and LONGBLOB, more
specifically) in a table that's intended to store files (with filename,
content-type and length columns). Generally, the problem seems to be that
MySQL thinks that it's out of memory when dealing with arbirarily large
values, ei
Good Day All,
eWeek has posted a poll that asks which database server is most critical
to your organization.
The poll tracks the following databases:
- IBM DB2
- Informix
- Microsoft SQL Server
- MySQL
- Ingres
- Oracle
- PostgreSQL
- Sybase Adaptive Server Enterprise
- Sybase SQL Anyw
I suggest you use MySQL from MySQL AB. Progress Software (parent of
NuSphere), is having some legal troubles.
http://www.newsforge.com/article.pl?sid=02/02/26/1825200
Tyler
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 1:01 PM
S
Hello,
I'm running the same code in 2 different environments, but both
environments access the same MySQL database (3.23.47 Max, running on
Solaris 2.8) and both use mm.mysql-2.0.7.
Environment 1: IBM VisualAge for Java, which has JDK 1.2.2, running on a
Windows machine
Environment 2: JDK 1.3.1 r
Hello,
I downloaded the beta version of MySQLGUI and was unable to perform any
table creation. Is this feature currently not supported?
Thanks,
Charles
Charles Davis
Member Engineering Staff, Data Analysis Systems
Lockheed Martin - Naval Electronics & Surveillance Systems
MS 530-2, 199 Borton L
Not sure if this helps, but we've had a situation like this, and the
cause was the network. We found that a query from the mysql client on
the machine was really fast, but from anywhere else it was slow. We
finally traced the problem down to a duplex conflict between the machine
and the swit
Hello,
I'm not sure if this list is appropriate for this issue but I'll go ahead
ask for your input anyway. We're trying to decide to choose DBMS as a
backend of our web portal. The portal will take online orders and other
requests from end users and this is going to be available enterprise wide
Very interesting article on leading DB's in the world.
MySQL the best among them:
http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp
--
yahmino liano
__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.c
Make a batch file that contains the appropriate information that you would normally
enter on the
command line. Save this as backup.bat. Go into task scheduler and Add a New Task. When
it asks for
the program to run, find your backup.bat file. Then you can schedule it at whatever
times you want,
* [EMAIL PROTECTED]
> mysql> select round(number,digits) from testme;
> +--+
> | round(number,digits) |
> +--+
> | 100.4240 |
> | 85.4000 |
> +--+
> 2 rows in set (0.08 sec)
This looks like a bug... and using var
Are you adding the data in order ? If Btree is not "balanced" then it
matters. It search them all. But I don't believe it is not balanced.
Makis
> -Original Message-
> From: Battini, Chandrashekar
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 4:38 PM
> To: '[EMAIL PRO
Ok - I am going to show my complete ignorance here now.
How do I configure my task scheduler to run mysqlhotcopy ?
If I want to run mysqlhotcopy at 3:30 am and copy and/or zip to a specific
dir - how is this configured in mysqlhotcopy ?
Thanks
Mark
-Original Message-
From: Nathan <[
On Tue, Feb 26, 2002 at 12:03:25PM -0600, Paul DuBois wrote:
> >it set the integer columns to 0 if they were blank in the text file.
> >How can I make it set those to NULL instead?
>
> You'll have to preprocess the file to convert empty fields to \N.
Damn, that's what I thought. I guess I'll hav
At 12:43 -0500 2/26/02, Philip Mak wrote:
>I made an Excel spreadsheet containing grades of students in my class,
>like this:
>
>(name) (email) (assignment 1 grade)(assignment 2 grade)
>
>For when a student did not submit an assignment, I just left the field
>blank.
>
>I'm trying to import the
1. Task Scheduler. Every 32-bit flavor of Windows has a task scheduler, and you can
have it execute
batch scripts which can easily do your MySQL commands for you. Look a folder in your
system
directory called Tasks if task scheduler is not already running in the system tray.
2. As opposed to...
Hi Richard,
> i want to round() the value of a column, but the number of digits is
> depending on the value of another column. i found out, that this doesn't work:
>
> create table testme
> -> (number double (5,4),digits tinyint(3));
> Query OK, 0 rows affected (0.08 sec)
>
> mysql> explain
I made an Excel spreadsheet containing grades of students in my class,
like this:
(name) (email) (assignment 1 grade)(assignment 2 grade)
For when a student did not submit an assignment, I just left the field
blank.
I'm trying to import the spreadsheet into a MySQL table of the
following f
Thanks a lot Benjamin,
that was just what I needed.
I have very nearly got http://www.melati.org/ working with MySQL,
which will be a big step forward for me and Melati.
When I have it working I will let the list know.
cheers
timp
On Tuesday 26 February 2002 16:54, Benjamin Pflugmann wrote:
>
i have installed
perl 5.6.1
mysql 3.23.48
DBI 1.18
Apache 1.3.6
Suse Linux 6.0
DBD-mysql-2.1011.tar.gz
there is following problem:
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/i586-linux/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/local/lib/perl5/site_
2 quick questions -
1. What is the Windows equivelant to a cron job. I would like to perform an
automated back-up of MySQL tables and data on a Win 2K server..
2. Is mysqlhotcopy always performed from the command line?
Thanks
Mark
-Original Message-
From: Victoria Reznichenko <[EMAIL
Hello,
You probably need to check the permissions for the directory that mysql is
trying to create the databases in. Make sure mysql has write permissions in
the directory. then run mysql_install_db again and you should be ready to
go.
- Original Message -
From: "jake williamson 28" <
Hi.
IMHO your query should work. This looks like a bug to me. I can
confirm this on 3.23.46, but have no more current version available
for testing.
Bye,
Benjamin.
PS: Forwarded to [EMAIL PROTECTED]
On Tue, Feb 26, 2002 at 05:08:59PM +0100, [EMAIL PROTECTED] wrote:
> Hi
>
> I'm hav
sorry guys, it isn't intended to post a message
repeatedly. Yahoo keeps telling me that the message
was not delievered due to some sort of size problem.
Anyway, I'm still seeking a solution to my problem and
would appreciate any of your help. Thanks
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
>Description:
RedHat 7.2 running on a crappy Pentium. Tried to install
MySQL from 3.23.49 rpms with -i (and every other imaginable way, too)
but I only get errors. Tried the same with .41 that came with the RH
distribution, got the same result.
resolve_stack_dump returns this:
0x806e2
It looks as if you need the php function nl2br().
John L
-Original Message-
From: Julio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 4:33 PM
To: [EMAIL PROTECTED]
Subject: help | i'm new
hi. i'm a dumb newbie. excuse my ignorance.
i'm using a field to store content f
This is what I usually do..
In the file you use to update the content for the page
(I'm assuming it's a file with a textarea box on it)
I have this function:
//-
function htmlchars2txt($text) {
$text = ereg_replace("&(quot|#34);","\"",$text);
$text = ereg_replace("&(amp|#38
Hello,
We're been running a pretty large MySQLd with InnoDB support, last night it
crashed on us in the middle of the night. I have never sent in a bug report
like this before so please give me a little slack. I do not have any clue as
to what actually caused the crash, I only have the logs an
Hi.
On Tue, Feb 26, 2002 at 02:20:46AM +, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am trying to make a database-neutral application.
> What is the MySQL idiom to replace the Postgres EXISTS function?
That's explained at the following place of the fine manual:
http://www.mysql.com/doc/A/N/ANSI_
Hi.
Could you please stop to post your message repeatedly with only some
minutes in between?
I never used INTERSECT, so I don't know... does it do anything a
normal join doesn't? Like
SELECT *
FROM table1 t1, table2 t2, table3 t3
WHERE t1.id=t2.id AND t2.id=t3.id
Bye,
Benjamin.
O
hello!
i'm rapidly loosing the hair i have left
i've managed to get our old clockwork pc running redhat 7.1 and php4. apache
is a rockin and now i've just installed the mysql RPM...
this is where everything's come to a grinding halt...
everything's gone in and mysql seems to be up and runn
Hello alec,
Tuesday, February 26, 2002, 6:01:48 PM, you wrote:
>> Direct copying files is not recommended way to backup databases.
acqc> Is this true even for a "dormant" system? I plan to have a pair of
acqc> replicated servers. I intended to do backup by stopping the slave, copying
acqc> the
It would help to see either the PHP code or the SQL statement.
=S.
On Tue, 26 Feb 2002, Edward Ionescu wrote:
> Hello,
>
> I'm using MySQL 3.23.32 and PHP. When an URL is etieved from the database,
> two things can happen:
> 1. it's working
> 2. it's not working and in look like:
> "htt
> Direct copying files is not recommended way to backup databases.
Is this true even for a "dormant" system? I plan to have a pair of
replicated servers. I intended to do backup by stopping the slave, copying
the files, then starting the slave again (at which point I hope it will
catch up with up
Ive seen the mysql documentation and that why I ask this question. The
docs just confuse me because the mysqldump page says mysqlhotcopy is the
preferred way, and vice versa.
The docs seem to favor mysqlhotcopy but then the page also says only to
use it when your sure data isnt being written.
hi. i'm a dumb newbie. excuse my ignorance.
i'm using a field to store content for a webpage. The problem i have
is that i enter text into the field in a formatted way (with line breaks,
etc) and when i pull it back out into the PHP page from a query it gets rid
of all the
line breaks and par
need help
following problem
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/i586-linux/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/local/lib/perl5/site_perl/5.6.1/i586-linux/auto/DBD/mysql/mysql.so:
undefined symbol: __mempcpy at
/usr/local/lib/perl5/5.6.1
Hello!
I have problems trying to install mysql 3.23.47 Binary version ('tar' file)
on UNIX/AIX 4.3
Following is the result of the 'mysqlbug' script and error messages i get.
Please help!
*
When i run 'mysqlbug', i get the follow
Hi
I'm having a simple but annoying problem:
i want to round() the value of a column, but the number of digits is
depending on the value of another column. i found out, that this doesn't work:
create table testme
-> (number double (5,4),digits tinyint(3));
Query OK, 0 rows affected (0.08
Stewart,
Tuesday, February 26, 2002, 5:13:58 PM, you wrote:
SG> I want to create a cron job that does nightly backups of a database, tars
SG> and gzips it, then ftps it to another server.
SG> I was wondering what the perferred method of copying the data would be.
SG> mysqldump, mysqlhotcopy or
At 13:06 +0200 2/26/02, savaidis wrote:
>There is not your book here in Thessaloniki/Greece. This is the second
>bigest city of Greece.
>(at least at bigest bookstore I checked, they have only O'Reily books and
>they have only one about MySQL with 3 writers)
>So I intend to take a subscription to
Aravind,
MySQL stores all dates as -MM-DD, if you must use MM/DD/ then you
can store it as a string.
The best method would be to let MySQL store the date as -MM-DD and
use:
select date_format(mydate, '%m/%d/%Y');
That will return mydate as "MM/DD/".
=S.
On Tue, 26 Feb 2002
At 20:48 +0530 2/26/02, Battini, Chandrashekar wrote:
> Hi ,
> I am using Mysql in Linux OS. I created a table in Mysql. The
>table has 3 fields and one is Primary key among them. I have populated 40K
>entries in the table. While populating the entries in the table, For each
>500 e
Hi ,
I am using Mysql in Linux OS. I created a table in Mysql. The
table has 3 fields and one is Primary key among them. I have populated 40K
entries in the table. While populating the entries in the table, For each
500 entries that i populated in the table, i have searched for
> Hi ,
>
>
>I am using Mysql in Linux OS. I created a table in Mysql. The table has
> 3 fields and one is Primary key among them. I have populated 40K entries
> in the table. While populating the entries in the table, For each 500
> entries that i populated in the table, i have searched for
I want to create a cron job that does nightly backups of a database, tars
and gzips it, then ftps it to another server.
I was wondering what the perferred method of copying the data would be.
mysqldump, mysqlhotcopy or just copying the files.
=S.
-
From: rogelio
To: [EMAIL PROTECTED]
Subject: bug in mysqlimport with many rows
> Description:
if I split a 3 rows file in 5000 chuncks, I can run mysqlimport
on each one over a deleted table
but if I don't use --delete, the first mysqlimport work ok but
the second hangs, and
Hi Tyler,
[back on-list so that others can offer their wisdom!]
OK, so it's not a problem with the MySQL client, then it's likely the PHP. Most likely
that the username and
password data values are strings and need to be properly contained with single- or
double-quotation marks.
If you need fu
1 - 100 of 141 matches
Mail list logo
