Well,
See the egg on face you get when using old technology.
I'll never use asbestos cutlery again,
and I'll upgrade myMySQL while I'm at it!!!
Thanks Paul, Dave
This brings ORDER to CHAOS!!!
Dave
(SoulScientist)
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Hello,
I just had a glance at your log-rotation file, and I think I might tell you about a
possible improvement:
In the file "mysql-log-rotate" I came across the following test case:
if test -n "`ps acx|grep mysqld`"; then
/usr/bin/mysqladmin flush-logs
fi
I th
Hello,
can anyone suggest a reasonable value for max_join_size
in MySQL server configuration as default value seems too
large? Clients should be able to run applications like
web forum but I want to prevent them from overconsuming
CPU time.
thanks,
Kirill Magdalinin
[EMAIL PROTECTED]
_
At 10:08 +1000 2/12/02, David Mackay wrote:
>Thanks for your quick response Dave,
>Have tried this, but no bannana...
>I get:
>"You have an error in your SQL syntax near 'abs(id)' at line 1"
If you can't put an expression in your ORDER BY, that means your version of
MySQL is older than 3.23. The
Or you could do it like this:
$query="some query "
."some more of this query "
."still some more query "
."and so on and so forth...;"
;
The tabs are no needed, I just put them there to make
it easy to understand that all those lines are actually
just one line.
Hello,
Can anyone help with an MySQL RPM installation that doesn't seem to be
working on RedHat 7.1?
First I did an `rpm -i mysql-max-4.0.1-alpha-win.rpm` install and it
didn't seem to give me all the files
but it did put a .sock file in
/var/run/mysql. Don't know how this rpm is different fro
Hi All,
I am trying to create a mysql table with one of the column to be for
.gif/jpeg, is there a variable type for gif/jpeg and after creating the
table, how do I insert the gif file on each record line.
Toks
---
It seems that either your server was started with the "--skip-networking"
flag, or that it's not listening on port 3306 (check your my.cnf), or your
machine has a firewall installed locally that doesn't allow network
connections to port 3306.
The MySQL command-line client will probably work in an
Hi Everyone,
I'm newbie with MySQL with some programming experience.
I'm about to implement an Internet shop. I would like to serve my
customers at a high level with, amongst other features, making sure that
every successful order will really be shipped due to a stock availability
check at order
Hello-
How does one run a client in non-interactive mode? Or, is there a way
to set interactive_timeout at the MySQL server to infinite? We have a
software component connecting to MySQL (using Mark Matthews JDBC driver)
and there may be a long time (> 8 hours) of inactivity.
Any suggestions mu
On 7 Feb 2002, at 8:20, Richard Reina wrote:
> I tried both ideas and neither one removed the white spaces. arrr!
> :-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage
returns, linefeeds), as it does in some programming languages. It
just removes spaces, unless you specif
now i try to migrate database from MS SQL server to My
SQL, I use Visual Basic and Crystal Report to generate
some reports, when i connect to MS SQL 2000, no
problem, but when i connect to MySQL , the crystal
report can't be previewed and get following message :
run-time error '20534' error detec
Whoops, originally sent this to just Heikki.
> On Monday, February 11, 2002, at 12:12 PM, Heikki Tuuri wrote:
>
>> for InnoDB 'dynamic rows', that is, rows where you define char columns as
>> VARCHAR, are faster because tables and indexes fit in smaller space.
>
> Is there reasoning specific to
Put quotes around the hostname:
grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net'
identified by 'X';
Peter
On Thu, 7 Feb 2002, Paul Faber wrote:
> Not sure if thius is supposed to go here but my version of MySQL
>
> mysql> status;
> --
> mysql Ver 11.15 Distrib 3.2
It could also have been fixed by changing the:
DBUG_POP();
to:
DBUG_POP()
Notice the ; on the end effectively terminating the if statement.
Happy coding.
Chris
> -Original Message-
> From: Jeremy Zawodny [EMAIL PROTECTED]
> [mailto:X]
> Sent:
Hi,
I'm wondering what the best way is to remove multiple records matching
against multiple instances found in another table. I'd like to avoid using a
scripting solution doing this in a loop.
Let's say I have two address books and there is some cross-over in entries.
I want to delete from addre
I am using mySQL 3.23.36 for RH Linux (came with the 7.1 install).
I am using mm.mysql-2.0.7-bin.jar JDBC driver.
When I attempt to connect, I am getting a Server Configuration denies
access... error.
When I have gotten this error in the past, it's been because the user wasn't
set up with the c
Hi,
can it be that there is a bug in count(distinct(putafieldnamehere)) ?
After restarting the server it runs, but after some time it doesnt return
any result-rows.
A count(putafieldnamehere) runs without problems in this situation.
Thanx for any sugesstions to solve this problem ...
mysql,dat
Hi all,
I solved my problem. Problem because another old mysql service running on
the same port.
regards,
sreedhar
- Original Message -
From: "sreedhar" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 6:33 PM
Subject: INSTALLATION and CONNECTION pr
I've created a menu system on a server with 3.23.24-beta and selectrow_array
calls work flawlessly. But when I move that same system to a server with
3.23.41, a seemingly updated version, selectrow_array calls work but return
with the error: fetch() without execute(). Looking at the DBI module it'
I am running MySQL 3.23.43 (installed via RPM)
The RPM's default socket is: /var/lib/mysql/mysql.sock
The my.cnf file that I setup has the following settings:
[mysqld2]
port=
socket = /tmp/mysql.sock.
master-host = 192.168.0.204
master-user = mysql_replica
At 9:07 -0500 02/07/2002, Ken Menzel was thought to have said :
>Many of the questions on this list are answered by people like
>myself who are users of MySQL. We are busy trying to run our own
>servers and put food on the table. That being said, you are
>wondering why your question did no
Greets Folks,
Suppose I wanted to upload a lot of files (1000 or so) to MySQL... sort of
like FTP-ing files to another server's directory... Is there a way to get
them all into MySQL like that? Uploading to a database seems much different
than uploading to a server...
Next, suppose I just F
Hi all:
I have various mysql tables (innodb type) where I am
inserting values in auto increment columns. The
value inserted into the auto increment columns is null
which automatically means that the table handler
inserts the next higher value in that column.
Problem is, many of these updates ar
select id from table_name order by abs(id);
Dave
Dundee!
On Tue, Feb 12, 2002 at 09:46:25AM +1000, David Mackay wrote:
> G'Day folks,
>
>
> New to PHP/MySQL.
>
> Want to order the results of a SELECT by their 'absolute' value, not their
> sign.
> So regardless of whether it's +37 or -37,
I'm currently trying to move a database (~1.6GB) from a Linux system to a
Sun (Solaris 8). The Linux machine is running:
mysqld Ver 3.23.35 for pc-linux-gnu on i686
The Sun is running:
mysqld Ver 3.23.47 for sun-solaris2.8 on sparc
I did a dump on the Linux box like this:
mysqldump -p --qui
http://www.mysql.com/doc/R/e/Resetting_permissions.html
after starting mysql with the --skip-grant-tables, you'll have to execute a grant
statement
http://www.mysql.com/doc/G/R/GRANT.html
GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY 'somepassword' WITH GRANT
OPTION;
then re
It shouldn't be a problem as long as the syntax is right...
Gurhan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:14 PM
To: MySQL list (E-mail)
Subject: long query on php
How is possible to pass a long query to MySQL server with php?
is mysqld running on your box?
Tyler
- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Monday, February 11, 2002 6:49 AM
Subject: Where Did Mysql Go?
> I was working on updating some databases yesterday and when I booted up
> my computer this m
If I understood you correctly you are comparing Record_ID to Phase_ID
try this:
SELECT rx.* FROM records rr LEFT JOIN records rx ON rr.Record_ID=rx.Phase_ID
WHERE rr.Record_Date>@date1 && rr.Record_Date<@date2
&& NOT (rx.Record_Date>@date3 && rx.Record<@date4);
This assumes that @date1, @d
If I understood you correctly you are comparing Record_ID to Phase_ID
try this:
SELECT rx.* FROM records rr LEFT JOIN records rx ON rr.Record_ID=rx.Phase_ID
WHERE rr.Record_Date>@date1 && rr.Record_Date<@date2
&& NOT (rx.Record_Date>@date3 && rx.Record<@date4);
This assumes that @date1, @d
Odhiambo,
Give this a try,
DELETE from relay_ip where UNIX_TIMESTAMP(rei_ts) <
(UNIX_TIMESTAMP(NOW()) - (10 * 60));
Eric Mayers
Software Engineer
Captus Networks
> -Original Message-
> From: Odhiambo Washington [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 10, 2002 11:22 PM
> T
If I understood you correctly you are comparing Record_ID to Phase_ID
try this:
SELECT rx.* FROM records rr LEFT JOIN records rx ON rr.Record_ID=rx.Phase_ID
WHERE rr.Record_Date>@date1 && rr.Record_Date<@date2
&& NOT (rx.Record_Date>@date3 && rx.Record<@date4);
This assumes that @date1, @d
Hello everyone, I need help.
I have these scripts that I load when I want to create new tables in the database.
I had DB1 full of data.
Then I created DB2 and forgot to change the database that I was working in, to DB2.
I loaded all .sql source files, and then I think you know what I'm gett
> > * 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
At 2:08 -0800 2/9/02, Joe Chesak wrote:
>I am attempting to combine COUNT, GROUP BY, and LEFT
>JOIN.. Adopting the theme on
>http://www.mysql.com/doc/C/o/Counting_rows.html my
>goal is to display only species/sex combinations that
>occur more than once. Additionally I wish to include
>the count fo
Placed At :
Hi all...
I was curious to know if mysql replication would be possible based on specific
rows in
a table rather than the replicating the whole table..
I have a set up which has slaves spread across geographically. and my master has
a t
Paul,
Saturday, February 09, 2002, 1:14:56 AM, you wrote:
PC> Can't connect to local MySQl server through port 111
Please, check the following link:
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
--
For technical support contracts, goto https://order.mysql.com/
This email is
Try to delete the index (drop index) of the table!
I had the problem and solved this this way.
regards,
Andreas
On Samstag, Februar 9, 2002, at 11:41 Uhr, DL Neil wrote:
> Keith,
>
>> I have the below query that returns the correct records but the
>> POINTFUND.description field is all NULL
hi,
i'm running a big query across a table containing more than 137 million rows comparing
them to another one with about 4000 rows and i'm wondering how long it will still
take...
is there a way to see how many operations have been made and how many are left?
as you can see it already took
Guilhem,
this is a known problem and mentioned in the Restrictions section of the
InnoDB online manual.
It is not the correct way to run SQL statements in the autocommit mode on
the slave server, while the master has normal transaction processing on.
I have asked Sasha to add COMMIT marks to th
> Ye, that did the trick. I was able to get the daemon restarted using the
> --skip-grant-tables & option, however now I can't connect to the
> monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try
> using /usr/bin/mysql -h hostname mysql
>
> Anyone know why I can't get
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
>Hi all...
>
>This is my first post to the list. I've been working on MySQL now for about a
>week and really like it. I have a question that I can't find in any of the
>books or how-tos.
>
>When I add a line to my customer's table I need it to put today's
Using 3.23.44 compiled from source from mysql.com on Linux Kernel 2.4.16
from RedHat distro.
I'm using a cross table to support many-to-many relationship between two
tables.
EXPLAIN shows that two of the joins aren't optimized.
All columns used in the two straight joins are of the same type and
Hi all,
I'm doing a quick and dirty import/export thingy, using the command LOAD DATA
INFILE ...
All fields in the table are of the type TEXT. and the text file (2be
imported) is comma seperated and fields are double quote enclosed.
Without use of the 'ENCLOSED BY' clause field data looks like
G'Day folks,
New to PHP/MySQL.
Want to order the results of a SELECT by their 'absolute' value, not their
sign.
So regardless of whether it's +37 or -37, they are both 37 and thus both
come between 38 & 36, regardless of whether they're + or -.
eg.
100
-99
-92
91
72
-38
37
-37
etc...
I have
>Description:
When configuring on a netbsd 1.5.2 system which does not have a threads
package readily available, the include "-I../mit-pthreads/include" is
not passed to innodb.
vio misses it
>How-To-Repeat:
configure/build without a threads library in the
Here are some queries I did:
First one did not do what I wanted it to do... But no surprise, since I left
out the 'IN BOOLEAN MODE'
The second and third query did give me the wanted results, but not in the
way I want to construct these kinds of queries.
But is there a bug or something with the las
Hi !
What is the usual approach when its needed to scale a mysqlserver. Of
course 1 server can be extended and upgraded in a number of ways. But is
it possible to have a cluster of server who works together and share the
load? So servers can be taken in and out of the cluster without much
work?
Using Perl/CGI and DBI::MySQL would work for forms. You could take the input
from the browser, and print the results back to the browser. Would that work?
j- k-
On Monday 11 February 2002 05:20, Jim Hatridge wrote:
> Hi all...
>
> First of all, I think that MySQL is really great. The
Hi,
I've read the man pages on this, but I can't figure out what to do. I have =
a
tab-delimited textfile containing spanish characters. I import those record=
s
using LOAD DATA INFILE... . All the special spanish chars are converted to
something different. How can I correct this? The columns in
Monday, February 11, 2002, 2:17:24 PM, you wrote:
js> After I've changed the root (mysql) password the logorotate programe (called
js> from cron) gives me the following error:
js> ===
js> errors occured while rotating /var/log/mysql.log
js> ./usr/bin/mys
Not only will mysqldump allow you to work on a specific table, but it will
also allow you to dump directly from one table into another. Sounds like
exactly what your looking for.
You'll need to use the correct syntax to keep it from adding CREATE TABLE
statements, but it's all clear on this pag
Eric,
for InnoDB 'dynamic rows', that is, rows where you define char columns as
VARCHAR, are faster because tables and indexes fit in smaller space.
Only in some rare cases where you want to avoid fragmentation caused by
updates which change a column length, a fixed-length CHAR(...) column can b
sreedhar,
Thursday, February 07, 2002, 3:03:35 PM, you wrote:
s> Hi All,
s> To Update current version on my new Redhat LINUX server I uninstalled MySQL
s> 3.23.26 rpm and installed all MySQL3.23.47 rpms.
s> When I tried to connect through
s> shell> mysql -u root mysql
s> Can't connect to lo
The Magana's writes:
> How do you install it I untarred it and now what do I do. I am running RH
> 7.0 downloaded mysqlgui-1.7.5.
>
> Thanks
>
> Andy Magana
> San Diego,Ca
>
>
Just follow instructions from README.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Si
Hi all (again),
Mysql tells methere are warnings during a importW. here can I find the
content of the warnings that occur.
Greetz Gerard, Thanx.
"Who cares if it doesn't do anything? It was made with our new
Triple-Iso-Bifurcated-Krypton-Gate-MOS process ..."
GrtzG
~
:wq!
I have a large data set (15 mil rows) consisting of a datetime column
and a char(255) column. I seem to recall seeing something about
performance benefits for using static length rows with MyISAM tables,
and I've heard some argument for using dynamic length rows (e.g., use
varchar rather than cha
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> * Monitor your slave to make sure it does not crash ( watch error log for
> stack trace messages), slave keeps running ( check with SHOW SLAVE STATUS),
> and data is consistent.
>
> * If there are problems, I will need the fol
I have installed the above as a service. The service seems to start ok, but
trying to run mysql console fails.
I am running this on Win2k Pro.
I have now reverted to MySQL4.0.1-NT running as a service and this works
fine.
Just a warning.
Richard
--
Is there a way to import XML files into MySQL?
David Sweeney
Adaptive Technology Services
Texas A&M University
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
Paul,
> > > I want to dump the contents of one table in to another table
> > > which has the same structure in MySQL, with just one column type changed
> > > from VARCHAR to TEXT. Whats the best way to do this?
> >
> > Would INSERT...SELECT suit you?
>
> Yes, but it's a big table. Is there a w
From: eerdman
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id: <[EMAIL PROTECTED]>
>Originator:ed erdman
>Organization:
>MySQL support: [none]
>Synopsis: Severity: <[
Hi ,
I am trying to upload a CSV file directly to the database using command
strSQL = "load data infile '" & strFNPath & "' into table products"
where , strFNPath =>Path of the file
But its not working correctly ,it uploads some data and then seem to stop
or enter values in the wrong places
Hi Rick et al
On Monday 11 February 2002 20:13, Rick Emery wrote:
> The PHP/MYSQL combo is also a good choice, as is PERL/MYSQL
The PHP/MySQL combo was what I was thinking about. But I'm having hell trying
to get the damn thing to work together. The PHP manual that is installed with
the
All morning I have been flooded by repeats of posts going back as far as February 2.
There have been several hundred
total messages.
Can't anyone fix this problem?
DET
(sql,query,table)
-
Before posting, please check:
I want to make mysql to support Chinese and Japanese under Win2K. I have
searched the offical manual but I could only find the section which taught
people to configure under Linux or Unix. However, I can't follow it because I
don't have Unix or Linux. If I want to configure it under Win2k, w
I am having some problems with MySQL and FreeBSD SMP 4.4 (STABLE) and
(FAST) on an Intel platform.
First, some vitals :
-
I am using the MySQL 3.23.48 FreeBSD 4.4 ELF binary, along with the
latest versions of DBI/DBD::MySQL.
I installed the binary, setup was no problem. I
At 01:43 AM 2/12/2002, you wrote:
>Hi,
>Does this work for you?
>
>select ad.id,adtype,name,sum(review.id is not null) from person
>review left join ad on ad.id=review.id
>group by ad.id;
this one returns 1 for the sum column no mater what.
>select ad.id,adtype,name,sum(if (ifnull(review.id,0)=
Hi everyone,
I am starting my first mySQL project .
I want to create 2 tables
Table User : userId , FisrtName, LastNAme, Gender with userId defined as
the primary key that auto-increments
I want that each time I insert a new row in this table, the field "userId" is
inserted as well in anoth
On Tue, Feb 12, 2002 at 01:31:43PM -, DL Neil wrote:
| Hello Nuno,
|
| > I'm trying to make a query with only one command but I can't see how to do
| > it.
| >
| > Supose that are 2 tables like:
| >
| > table QA table QB
| > ref text ref text
| > --- ---
| > a1 texta1
Roger,
> * DL Neil
> > Mysqldump is a command that is typed at the MySQL command
> > line - just as you would SELECT...
> huh? mysqldump is a command line utility... it can not be entered in the
> mysql monitor, it must be entered on the unix/linux/dos prompt.
>
> > =to be honest, I rarely use i
i cannot get my name off this list...I've tried 30 different emails/methods
sql,query
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
---
I've recently set up replication on one of my databases. Both master and
slave are running MySQL 3.23.46 on FreeBSD 4.1. The only tables that get
updated or inserted into hold approximately 140,000 records, growing at
a rate of around 50-100 every day. The issue is it is currently taking
approxima
If I change to the bin directory of mysql and start mysql from there it
starts up fine.
If I start it with an init script it dies just as soon as it starts.
The log files says:
020211 08:44:47 mysqld started
ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.3: open
failed: No such
Hi,
Using PHP? If so, this works quite nicely if you pass your dates as unix
timestamps:
SELECT * FROM table WHERE (FROM_UNIXTIME($theMaxTime) > col AND
FROM_UNIXTIME($theMinTime) < col)
In other words, "col" needs to be between $theMinTime and $theMaxTime as
in $theMinTime < col < $theMa
Andre,
Thursday, February 07, 2002, 1:55:26 PM, you wrote:
AS> Howto backup databases MySQL direct to a Tape Backup.
You can directly copy files whitch contain tables from mysql data dir.
You can also use mysqldump to dump your database and then you can
backup result file to a tape. But I think
Ed,
Monday, February 11, 2002, 4:12:13 AM, you wrote:
EL> I'm trying to update a database. Here's the query that's not working. Is
EL> there another way of doing it or is this impossible with MySQL?
EL> Thanks,
EL> -Ed
EL> update SiteIndex
EL> set
EL> SiteIndex.Visi
I have a series of data in one table that I need to put into a set of ranges.
Here is a simplified version of the tables:
data table fields (data):
val int(10) not null,
row_id int(10) not null auto_increment,
primary key
Range table fields (range):
lo int(10)
Hi all, new to the list... here's my problem, anyone have an answer?
I'm a long time MySQL user. At work, we have an RS6000 running AIX on which
we'd like to install MySQL. I downloaded the binaries from mysql.com.
However, it will not run... I get this error upon running mysql_install_db:
exe
The PHP/MYSQL combo is also a good choice, as is PERL/MYSQL
-Original Message-
From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 11:44 AM
To: Jim Hatridge; [EMAIL PROTECTED]
Subject: Re: forms?
Using Perl/CGI and DBI::MySQL would work for forms. You could
I think this may be a problem with MySQL and if it is not please tell me how
to resolve it.
mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
mysql> CREATE TABLE test( name char(255) NOT NULL, INDEX(name));
Query OK, 0 rows affected (0.01 sec)
mysql> INSERT INTO test VALUES('\"///\\o/\
In the last episode (Feb 11), Ilia A. said:
> I think this may be a problem with MySQL and if it is not please tell me how
> to resolve it.
>
> mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
>
> mysql> CREATE TABLE test( name char(255) NOT NULL, INDEX(name));
> Query OK, 0 rows affec
Well, first of all, if you're just starting out with all this and don't have
any critical data, I recommend you dump your PHP and MySQL installations and
install the latest, stable releases of everything: PHP 4.1.1 and MySQL
3.23.48 - there are a lot of bugs fixed and functionality added in these
UPDATE mytable SET newcol=oldcol;
-Original Message-
From: Max Mouse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:11 PM
To: [EMAIL PROTECTED]
Subject: Columns
Hey all,
Is it possible to copy the contents of one column to another column using
mySQL? I just
changed my
About 3 months ago, there was a long discussion thread about this very
topic.
Final answer: "the","a","an" must be handled in the language
(perl/php/etc...). Or, you must change data in your fields so that these
words are NOT the first in the field.
-Original Message-
From: abdul - "ÚÈ
Try
select * from QB, relAB where QB.ref = relAB.B and relAB.A='a1';
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 4:24 AM
Subject: is possible 1 query with 2 selects?
> Nuno,
>
> Friday, February 08, 2002, 11:04:
show us your table structure
show us your table values
-Original Message-
From: Barry J. Wiegan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: Table join question
Hi,
I'm trying to build a query to solve a fairly simple problem.
I ha
Join it to a table that has all the hours and to the query with an outer
join.
- Original Message -
From: "Almar van Pel" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 11:00 AM
Subject: Is it a bug / not implemented /me ?
> Hi,
>
> This morning is
Maybe you can try find the application at hotscripts.com.
regards,
Teddy
--
experience the online learning commmunity at http://www.mycyberclassroom.com
At 08:32 AM 2/7/2002 +0700, Franky Aniversarius wrote:
>when i click the icon client1(in end client, it's show up from php
>applicat
Was hoping that the OS X no-can-stop-db problem might me rectified in
the new .48 release of MySQL but, alas, I compiled from source and still
can't kill the processes without the dreaded -9.
Here's hoping that it gets fixed soon before I corrupt a database.
I know that this is not a consisten
Van <[EMAIL PROTECTED]> writes:
> Greetings:
>
> Anyone else getting lists messages from several days, or longer ago?
>
> Phrrrp!: sql database table mysql
Same here.
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Before posting
Hi, I want to ask what difference can be between two MySQL Table CHAR fields
the first one's size (In Design) is (10) and the other is (100), but the tow
contains the same length of charachters like 3 charachters.
Does it effect speed, data size...
Please advice
Best Regards
Hayan
-
* Van
> Anyone else getting lists messages from several days, or longer ago?
yes...
--
Roger
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
Hi ,
I am trying to upload a CSV file directly to the database using command
strSQL = "load data infile '" & strFNPath & "' into table products"
where , strFNPath =>Path of the file
But its not working correctly ,it uploads some data and then seem to stop
or enter values in the wrong places.
sm,
Tuesday, February 12, 2002, 11:10:28 AM, you wrote:
s> Hi
s> I'll want use MySQL server with databases in different charsets.
s> I don't found anything like it in manual.
s> I can set --default-character-set on server startup,
s> but databases with other charsets are not ordered correctly.
I've asked this before, but let me describe it another way, and see if
anyone has any bright ideas:
My client has 3 offices.
Each office needs to use same app (over MySQL).
Each office needs (effectively) same database.
Updates done at each office need to be used at other offices.
Updates v
Hi,
I am trying to create tables on a new database using SQL statements embedded
into Perl scripts. The problem I am having is that only the first six
fields/columns of the table can be populated, any following fields/columns
remain empty. This is happening on all the table I have created, despit
Read through the man doc lcalero gave you it tells everything you need to
know. Below is a basic example to help get you started:
#!/usr/bin/perl
use CGI;
use DBI;
$hostname = 'www.hostname.com';
$database = 'nameofdatabase';
$user = 'username';
$password
The list seems having some problems. I've rereceived many emails, like
this one, which were sent via the list last week!!
Anyone else has the same problem?
Trond Eivind Glomsrød wrote:
>
> "Vernon A Webb" <[EMAIL PROTECTED]> writes:
>
> > Anyone know the difference between MySQL and PostgreSQL
1 - 100 of 434 matches
Mail list logo
