Hi, again.
Hmm.
1) Lets supose, i have ISP that supports mysql+apache+PHP.
My php+mysql+apache based system is located on the ISP server.
When i sell this PHP application to my client (any Company), this company
works with my system over Internet on ISP.
Anybody need licence ? I, the Client or my
Can MySQL or PostgreSQL build up a cluster for failover or improve the
database performance just like Oracle or Sybase ones?
If can, where we can get such setup documentations?
-
Before posting, please check:
http://www.mysql
Hi:
I build this HA SQL Server ( Mysql ) with two Linux Boxes with
Heartbeat Cluster Software, but you need a shared storage between this
ones ( or backend NFS Server ), generating a volume group shared,
deporting and importing depending if the node is master or slave just
with Linu
hi,
I have connected mysql & vb. But unable to update the records.
Could you suggest any sample program.
help me out.
[EMAIL PROTECTED]
WWW.COM - Where the Web Begins! http://www.www.com
Admin/Admin,
Tuesday, February 26, 2002, 10:07:25 AM, you wrote:
AA> Hi,
AA>Thx for all your help, I can export the tables in exportSQL scripts.
AA>But how to make the procedure of inserting data more easy instead of
AA> using mysql daemon od MySQL GUI?? Both of them need to use Sql langu
Hi,
How can I insert a date in mm/dd/ format in MySQL?
Meseems, it only supports -mm-dd format. As I'm a
beginner to MySQL, could anyone help me out and make
me solve this problem?
Thank you.
Aravind
__
Do You Yahoo!?
Everything you'll ever
S,
Tuesday, February 26, 2002, 11:11:47 AM, you wrote:
SA> Hi,
SA> How can I insert a date in mm/dd/ format in MySQL?
SA> Meseems, it only supports -mm-dd format. As I'm a
SA> beginner to MySQL, could anyone help me out and make
SA> me solve this problem?
You can do it by yourself using
AFAIK, you'll have to do the conversion before inserting the date into the
database because MySQL does not support the MMDD format.
Regards,
Al
> -Original Message-
> From: S Aravind [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 5:12 PM
> To: [EMAIL PROTECTED]
> Subje
New to list so please excuse me if this is an obvious question.
Is there any tools / documentation to simplify porting MS Access databases
to MySQL ?
This Internet E-mail is intended solely for the person to whom it is addre
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 Safari but I want to know if I will
have acc
Client: MS Visual Basic 6.0 - ADO 2.5, Windows 2K Professional, Win 95, Win
98.
Server: Redhat Linux 7.0, MySQL 3.23.41.
For trouble shooting purposes, I've done the followings (as recommended by
someone):
1) In Linux server, I run df - The useage for all filesystems are less than
50 %.
2) In
Hello,
You've been invited to join the bilgisayar_bolumu group,
an email group hosted by Yahoo! Groups, a free, easy-to-use email group
service.
JOIN NOW, IT'S EASY:
1) REPLY to this email by clicking "Reply" and then "Send"
in your email program
-OR-
2) Go to the Yahoo! Groups site at
Hello,
You've been invited to join the bilgisayar_bolumu group,
an email group hosted by Yahoo! Groups, a free, easy-to-use email group
service.
JOIN NOW, IT'S EASY:
1) REPLY to this email by clicking "Reply" and then "Send"
in your email program
-OR-
2) Go to the Yahoo! Groups site at
Hello,
You've been invited to join the bilgisayar_bolumu group,
an email group hosted by Yahoo! Groups, a free, easy-to-use email group
service.
JOIN NOW, IT'S EASY:
1) REPLY to this email by clicking "Reply" and then "Send"
in your email program
-OR-
2) Go to the Yahoo! Groups site at
Hello,
You've been invited to join the bilgisayar_bolumu group,
an email group hosted by Yahoo! Groups, a free, easy-to-use email group
service.
JOIN NOW, IT'S EASY:
1) REPLY to this email by clicking "Reply" and then "Send"
in your email program
-OR-
2) Go to the Yahoo! Groups site at
Um, it sounds very inviting... is that Euskera or Hungarian, or what?
I'm not familiar with GrubaSQL...
-- m
On 26 Feb 2002, bilgisayar_bolumu moderator wrote:
> Here's an introductory message from the group moderator:
> ---
This one gets answered about 6 times per month, so
perhaps the Mysql doc team could consider putting
an FAQ or heading in the documentation for it.
For example, under "A Problems and Common Errors",
which is not English, by the way, there should be
a heading "Porting, Importing, and Exporting".
Hello Tyler,
Did someone pick up this question - haven't spotted a response on the list?
I haven't spotted any such mis-behavior under either Win2000 or WinNT.
Are you entering the query at the command line or into some tool?
Have you tried another client?
If it is still unresolved, send me (NO
> Is not possible to copy e-book either, I think!
=how could one download it then?
> (PS: You're so sick to read work books at home ? :)
=if I work at home, does that mean I'm reading home-books at work, or work-books at
home?
- either way, yes I know, I must be doubly "sick"!
BTW some of us
Hi,
I was wondering if I could achieve a speed increase if I did chattr +A to
mysql data files. I'm not interested in knowing when the table was last opened
for reading. But I'm affraid mysql uses it internally for something. Can I do
it? TIA
Rafal
table, database
---
You download the program to read it and the source togeter. It is copy
protected.
Try www.glassbook.com (there are various solutions by Abobe)
I have one Glassbook with poems, free, downloaded from a Greek bookstore. It
works just fine and has many possibilites : it's contex sensitive, with
zoom,
Sometimes I have in my .err file Error in accept: Bad file descriptor
FreeBSD 4.4, mysql 3.23.47
startup script:
-O key_buffer=256M -O table_cache=18000 -O sort_buffer=32M -O
record_buffer=16M --log-slow-queries -O long_query_time=180 -O
max_connect_errors=50 -O back_log=500 --warnings -O max_
Matt,
Tuesday, February 26, 2002, 12:52:08 PM, you wrote:
MJ> New to list so please excuse me if this is an obvious question.
MJ> Is there any tools / documentation to simplify porting MS Access databases
MJ> to MySQL ?
MySQL-Front can help you.
You can download MySQL-Front and find info about t
Also check out http://www.mysqlfront.de.
No disrespect intended to MySQL. :)
Regards,
Kevin Smith
-Original Message-
From: Victoria Reznichenko <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Tue, 26 Feb 2002 11:14:01 +0200
Subject: Easy way to insert data in MySQL DB
> Admin/Admin,
It's Turkish. (It's also half-converted from ISO-8859-9 which makes the Turkish
somewhat hard to read ;-) )
It appears to be a computer group, so it's conceivably *possible* MySQL could be
discussed there - but it looks more like ordinary spam..
At 12:49 2002-02-26, you wrote:
>Um, it sounds v
hello all,
I just want to thank everybody in the list for their help.
I'm unsubscribing from the list for now.
But I would definitely comeback as soon as I can.
Thanks again for all the help.
luie
sql, query
__
www.edsamail.com
--
Hello,
I'm using MySQL 3.23.32 and PHP. When an URL is retieved from the database,
two things can happen:
1. it's working
2. it's not working and in look like:
"http://localhost/"http://www.test.com/";
My big question: WHY using the same DB the URL is well retreived in a page
and wrong in another
This is do-able, but slightly off topic, perhaps you want to continue this
off list?
Your senario is a little ambiguouse, are you trying to insert into the
databse over the web via a form. Or do you want to query a database and
include the results? Or both?
--
Simon Oliver
"Will K." 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:
"http://localhost/"http://www.test.com/";
My big question: WHY using the same DB the URL is well retreived in a page
and wrong in
Hello,
innodb can't be created on xfs ???
InnoDB: Warning: operating system error number 2 in a file operation.
InnoDB: Cannot continue operation.
020216 14:25:49 mysqld ended
S pozdravem
Michal Dvoracek [EMAIL PROTECTED]
Capitol Internet Publisher, Korunovacni 6, 170
Hello Edward,
> I'm using MySQL 3.23.32 and PHP. When an URL is retieved from the database,
> two things can happen:
> 1. it's working
> 2. it's not working and in look like:
> "http://localhost/"http://www.test.com/";
> My big question: WHY using the same DB the URL is well retreived in a page
>
Hi Maxim,
This is an error from the operating system and might be more
appropriate on freebsd-stable mailing list. There are many users of
FreeBSD on this list (including me). However hopefully someone will
know the answer. I am going to try and guess that kern.maxfiles=65535
might not be al
Does the MySQL-API support MySQL v4 databases?
If so to what extent - i.e. what features does the API not provide that
v4 databases offer?
I could see nothing on here about it:
http://www.mysql.com/downloads/api-mysql++.html
I'm talking primarily about the Linux api but information on the wind
Rafal,
Tuesday, February 26, 2002, 1:52:52 PM, you wrote:
RJ> Hi,
RJ> I was wondering if I could achieve a speed increase if I did chattr +A to
RJ> mysql data files. I'm not interested in knowing when the table was last opened
RJ> for reading. But I'm affraid mysql uses it internally for somethi
Tim,
Tuesday, February 26, 2002, 4:20:46 AM, you wrote:
TP> Hi,
TP> I am trying to make a database-neutral application.
TP> What is the MySQL idiom to replace the Postgres EXISTS function?
TP> I have two tables:
TP> mysql> select * from groupcapability;
TP> ++--+
John,
Monday, February 25, 2002, 9:29:10 PM, you wrote:
JM> Compiled MySQL 3.23.49 from source and I still can't kill the server
JM> without -9 in OS X 10.1.3
Try to use "mysqladmin shutdown" command.
JM> sigh...
--
For technical support contracts, goto https://order.mysql.com/
This emai
Would anyone like to share their experiences with MySQL 4 on XFS and kernel
2.4.16? I'm getting prepared to create a system with the above and would
appreciate any thoughts.
Thank You In Advance!
Anthony
-
Before posting, ple
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 a single entr
> 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 f
Eric Mayers <[EMAIL PROTECTED]> wrote:
> Okay, this is clearly not what I want. I'm looking for a method to see
> how much space a table is using compared to the total amount of space
> available. Is there a way to do this (with innodb tables)?
I haven't used InnoDB tables, but since no one el
> 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 fo
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
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
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.
-
> 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
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
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 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
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
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
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
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
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
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.
> 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
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
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
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
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
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_
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
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
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
>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
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]>
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
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" <
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
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_
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 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
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
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...
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
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
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 <[
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
* [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
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,
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
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
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 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
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
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
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'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
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
Thanks for the article it is definitely helpful and narrow down my choice.
Anything against the 4.0 MAX here?
|-+>
| | "Tyler Longren" |
| | |
| ||
| | 0
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
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
-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-
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
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!
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
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
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 \
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 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
1 - 100 of 141 matches
Mail list logo
