Show us your code.
What are your table structures like?
-Original Message-
From: AOK Lansing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject: PHP does not see Table updates
I am using PHP to access a MySQL DB. If I stop MySql and
Ok.
My hardware hangup and i installing a new server.
Howto i restore from tape to a new instalation.
André Sartori
[EMAIL PROTECTED]
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 7 de fevereiro de 2002 09:56
Para: Andre Sartori
Assunto:
Replication with temporary table issue:
HostA: MySQL 3.23.42-log
HostB: MySQL 3.23.42
Replication: HostA --to-- HostB
Issue: After followed the MySQL Manual recommendation to: SET SQL_LOG_BIN
= 0;
to create, insert and drop a temporary table,
example:
SET
Hi dn, thanks for replying.
I suspect you're right about my 'problem' - I'm probably misunderstanding
some simple SQL construct :-)
Let's say I have the following tables:
parts (partid int, partname varchar(255))
cats(catid int, catname varchar(255))
parts_cats (id
I read in Paul's book that to use MySQL on a Windows platform you need
to pay for it.
I have downloaded a version of the server and client software from the
official MySQL.com site and installed it on XP without incident.
Paul also writes that the version for windows will be shareware only.
Replication with temporary tables:
HostA: MySQL 3.23.42-log
HostB: MySQL 3.23.42
Replication: HostA --to-- HostB
Issue: After followed the MySQL Manual recommendation to: SET SQL_LOG_BIN
= 0;
to create, insert and drop a temporary table,
example:
SET SQL_LOG_BIN =
What do your tables look like? Structure?
What are you trying to do?
What does your data look like?
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 8:12 PM
To: [EMAIL PROTECTED]
Subject: Can this be done?
I'm trying to update a database.
I need to optimize the following query:
SELECT user, sum(in), sum(out) FROM stats WHERE from='20020205'
AND to='20020206' GROUP BY user;
In,out are bigint, user is varcher(20) and from,to are timestamp
And I want to speed up this type of query, but I have not been able to
to get it to use an
I am trying to trim both leading and trailing whitespace from a TEXT
column in my SELECT query. I found the TRIM() command in the manual,
however, I can't get it to act upon a column name instead of an
actual string. Can anyone help?
If you just say TRIM(col_name) it will return the
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
Seems a not-valid thing to do these days...
Is there a work around?
Dave
from
Oz
select id from table_name order by abs(id);
Dave
Dundee!
Hi,
more and more frequently we are seeing this error:
Lost connection to MySQL server during query
during queries. I have seen it reported previously on the list, but i
haven't been able to find a remedy. Does anyone have a solution to this?
Any ideas are appreciated.
Thanks,
james
--
Hi folks -
I am still having 2 related problems with the timezone setting for mysqld
was hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values which
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
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
...uhm duh. My apologies. I had the LIKE switched around when I tried
it and after reading through the manual and not finding anything about
LIKE (it isn't mentioned as a parameter in the SELECT section) I assumed
it wasn't supported. Thanks for your comments. Aaron =20
-Original
Paul DuBois writes:
At 12:50 -0800 2/7/02, Cindy wrote:
Rutledge, Aaron writes:
MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand...sigh.
sigh, what? RLIKE works. It's the same
Here is how I do it:
$query = some query ;
$query.=some more of the same query ;
$query.=still more query ;
$query.=and so on... ;
$rst = mysql_query($query);
NOTE: you need to add a space at the end of each line (after the last word
and before the closing quotations) if you plan on
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col a,;
$query .= tabledef for col b,;
$query .= lots more table defs,;
$query .= welcome to line 400;
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wrote:
Hi James,
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 not get an answer, it may be the
length of the message and
Sinisa Milivojevic wrote:
Shankar Unni writes:
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working on that?).
When you are saying that there is no native Windows or OS X port, what
were you referring to ??
Oh,
Hello everyone,
There used to be a section in mysql documentation, which explained about all the
entries in my.ini file. Do you know what happened to it?
There is a part about my.cnf but that's not what I want. There was more.
Problem Solved!
Thanks
- Original Message -
From: AOK Lansing [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 1:37 PM
Subject: PHP does not see Table updates
I am using PHP to access a MySQL DB. If I stop MySql and then restart it
and
then open my webpage the
I have a (probably dumb) question.
My table temperatura has two fields described bellow.
snip
When I try to select rows with floats, the result is an empty set.
This is not a MySQL problem, nor a database one, but a general computer
science one. It is
almost never save to compare two
Hi There!
I am using mysql 3.23.41, for redhat-linux-gnu (i386).
My problem is this.
In java, I am trying to extract a blob field from a mysql table - I am
using
Byte[] somebytes = RS.getBytes(FPPICTURE);
String somestring = new String(somebytes);
This gives me a string of the blob
I am using PHP to access a MySQL DB. If I stop MySql and then restart it and
then open my webpage the table values are correct. If I make a change to the
table, close my browser and restart it, the table values are the old values.
If I stop MySQL after changes and then restart it, all works
Hi,
As I am new to MySQL, perhaps this is a common question you have been asked.
I have a field Id which using auto_increment. Now I want to reset the
value of auto_increment, that is the Id starts form 1 and does not skip
the number. I have spent a few hours to find a way, but all failed.
Tshering,
Wednesday, February 06, 2002, 7:29:11 AM, you wrote:
TN Dear list,
TN I have a telephone database which has Name as one of the fields/columns.
TN This field contains single name e.g Robert, double names e.g Robert
TN Downing and more than double names. I want to make a SELECT query
Joachim,
Thursday, February 07, 2002, 11:18:43 AM, you wrote:
JH I am using the following versions of mysql on suse linux 7.2:
JH frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
JH server: version 3.23.47
JH If I try to use the GRANT
I did this at a previous job, and we split the data up more or less
this way (we used a pre-existing item number for the split which was
essentially random in relation to the text data), with a aggregator that
did the query X ways, each to a separate box holding 1/X of the data.
The results from
dear friends,
in Mysql, under sql, we have the function PASSWORD('mypasswd') where we
can encrpt
'mypasswd' into a 16 character scrambled word.
which function in sql is used to decrypt the same and get back the
original mypasswd.
thanking you
--
Sumeet Shroff
proprietor
Prateeksha Printing
The following deletes all records and re-starts renumbering from 1;
DELETE FROM mytable;
The following deletes all records and continues counting from where the
table last left off:
DELETE FROM mytable WHERE 1;
If you are trying to restart numbering while not deleting records,
forget-about-it.
It seems to me like the best solution that could be implemented as-is
would be to keep a random int column in your table (with a range of say
1-100) and then have fulltext server 1 psudo-replicate records with a
the random number in the range of 1-10, server 2 11-20 and server 3
21-30 and so
On Thursday 07 February 2002 14:53, Brian DeFeyter wrote:
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext indexes do a good job of indexing a moderate amount of data,
but when you get a lot of data to be indexed, the
Yesterday, from savaidis:
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query(create bla.
bla.
bla
bla blabla
.
bla
.bla
);
So the limit isn't also set to
Has anyone successfully saved Microsoft Projects within MySQL? When I
attempt to save a project I get a MyODBC error on the syntax, on, what I
presume is one of their table creation SQL statements.
Anyone have any insight?
-
try:
DELETE FROM relay_ip WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(rei_ts)
600;
-Original Message-
From: Odhiambo Washington [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 1:22 AM
To: [EMAIL PROTECTED]
Subject: Clear table contents
Hello gurus,
Please allow me to
Hi,
When I run perl run-all-tests --server=mysql --cmp=mysql,pg,solid
--user=test --password=test --log in the sql-bench direcotory. I
encountered following error messages:
Can't locate DBI.pm in @INC (@INC contains:
/usr/lib/perl5/5.6.0/ia64-linux /usr/lib/perl5/5.6.0
something easier:
DELETE FROM relay_ip WHERE NOW() - rei_ts 1000;
-Original Message-
From: Rick Emery
Sent: Tuesday, February 12, 2002 3:03 PM
To: 'Odhiambo Washington'; [EMAIL PROTECTED]
Subject: RE: Clear table contents
try:
DELETE FROM relay_ip WHERE UNIX_TIMESTAMP(NOW()) -
Steve Rapaport wrote:
On Friday 08 February 2002 06:14 pm, James Montebello wrote:
Distribution is how Google gets its speed. You say clustering won't
solve the problem, but distributing the indicies across many processors
*is* going to gain you a huge speed increase through sheer
A quick method is to create a new table:
CREATE TABLE newtable SELECT DISTINCT * FROM oldtable;
note; manually verify newtable has your data. Then proceed:
DROP TABLE oldtable;
CREATE TABLE oldtable SELECT * FROM newtable;
DROP TABLE newtable;
-Original Message-
From: Rich
I apologize for using bandwidth...it appears my posts are no longer going to
the [EMAIL PROTECTED] mailing list.
I'm just verifying before rteporting it, if necessary
magic words: sql,database,query
-
Before posting, please
The mySQL manual says that embedded double quotes within a single quoted
expression (as in 'OHara') need no special treatment. However, when I try
to update a data base field using such an expression, as in:
UPDATE table set col1='OHara'
the result I get is that everything to the
Hello MySQL users
I was wondering if one of you could advise me on the best solution to a
problem I'm having - I'm sure this has been done before but haven't found
anything in the archives.
Basically the problem I am having is how best to handle multiple values for
a specific column, in this
Jochen Kaechelin wrote:
What licence do I need when a want to install a MySQL-Server
in a intranet on a Linux-Box where 4 Win-Clients use it by running
a PHP Groupware Application?
I'd say you can just go and use it without a fee AFAIK, but for a
judicial correct and valid answer I
Thanks, but it was just a typo. And I tried it again, but with the same =
result. It's really a strange installation.
mysql GRANT ALL PRIVILEGES ON *.* TO root@localhost
- IDENTIFIED BY 'salach01' WITH GRANT OPTION;
ERROR 1047: Unknown command
JoacHim
-Urspr=FCngliche Nachricht-
On Fri, Feb 08, 2002 at 06:10:34PM -, DL Neil wrote:
There are some RDBMS-es that implement SQL to the point of apparently setting up a
construct that links tables -
foreign key based data integrity being the first example that springs to (my) mind.
However relational logic
suggests that
Did you try SQRT(id)? Should rank things the way you want if it's legal
(*_*)
-Original Message-
From: David Mackay [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 7:08 PM
To: 'David Turner'; David Mackay
Cc: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY an ABSolute value
Perhaps I should have split this up into two mails, but I saw them related
in the difference of databases
On mysql Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686)
this works
SELECT SQL_BUFFER_RESULT DATE_FORMAT(ORDERHEADER.AvailableAt,'%y/%m/%d') AS
'Date',
Shankar Unni writes:
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working on that?).
Here is an unofficial install package of the new PostgreSQL 7.2:
http://www.entropy.ch/software/macosx/postgresql/
You can get an unofficial
hi,
on redhat 6.2, you have a package manager (rpm) version which cannot
interpret rpm's created with package manager version 4. afaik, rpm 3.0.6
is able to read both formats, so you should upgrade your package manager
software to version 3.0.6 to be able to install the new mysql package.
don't
Hi
Is there any reason to reboot MySql periodically?
Short answer: No.
My server has been up for just under 6 months without a reboot,
That is not unusual.
and some of
the queries are noticeably slower. This may well be because the data has
grown, but I wondered if there is any
Hi.
You forgot around temp example:
mysqlselect datetime,temperatura from temperatura where
datetime=2002-02-08 09:30:00 and temperatura=15.8;
Regards
/PM\
Miguel Figueiredo wrote:
Hello all,
I have a (probably dumb) question.
My table temperatura has two fields described bellow.
Why is it that Altavista can index terabytes overnight and return
a fulltext boolean for the WHOLE WEB
within a second, and Mysql takes so long?
I don't know about Altavista, but if you read up on Google, they do indeed
do some sort of
spreading of keywords across multiple machines - last I
Hello ppl.
I am playing hard with mysql, cause my ultimate objective is to make a big
databank for a game.
I notice that i cant find a way to make relations beteen tables.
Must i do it also with PHP ?
Thanck for the tips.
And if i am rigth, my dont gays put so relation ?
Ooops, factual error:
If, say, Google, can search 2 trillion web pages, averaging say 70k
bytes each, in 1 second, and Mysql can search 22 million records, with
an index on 40 bytes each, in 3 seconds (my experience) on a good day,
what's the order of magnitude difference? Roughly 10^9.
Hello André
I am playing hard with mysql, cause my ultimate objective is to make a big
databank for a game.
I notice that i cant find a way to make relations beteen tables.
Must i do it also with PHP ?
Just to confuse you, the mathematical jargon for table is relation...
May I suggest
Hi, Fellows!
Sorry for my poor english. Thats why I can explain myself properly.
:- )
What I really want is a calculate column with consecutive numbers from n to
m, where n can be any number, and m depending on the result of the WHERE
clause. I need to print pay orders for students, this pay
I said:
Why is it that Altavista can index terabytes overnight and return
a fulltext boolean for the WHOLE WEB
within a second, and Mysql takes so long?
On Friday 08 February 2002 08:56, Vincent Stoessel wrote:
Apples and oranges.
Yeah, I know. But let's see if we can make some
This would fail dramatically. The squareroot of a negative number is not
a real number.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith A. Calaman [mailto:[EMAIL PROTECTED]]=20
Sent: Monday, February 11, 2002 5:24 PM
To: David Mackay; 'David
i need help!!
i an doing my assignment using mysql to establish a database!!
i already create the table and insert the data,
but i don't know how to create a export file,
anyone can help me!!
_
Ãâ·ÑÏÂÔØ MSN
Hi
Is there any reason to reboot MySql periodically?
My server has been up for just under 6 months without a reboot, and some of
the queries are noticeably slower. This may well be because the data has
grown, but I wondered if there is any memory leakage at all.
Anybody with more experience
Hello,
I am relatively new to Mysql. I am have a strange problem that is
preventing me from setting up
my database to test out mysql as a backend to an IDS system. When I
start the mysql command
I get the following output.
srsids01# ./mysql
Welcome to the MySQL monitor. Commands end with ; or
If you want to get the most out of MySQL, then you really need to learn to
use the command line tools. MySQL has the easiest to use tools and language
of any database I've used. SQL allows you to do really powerful things
easily.
Download the Windows version and install it. You can use the
any reason not to select distinct into a tmp table?
On Sun, 10 Feb 2002, DL Neil wrote:
Rich,
How does one go about removing one of two identical records in a MySQL
database? My mistake in an earlier database was not applying a unique
number to each record (1, 2, 3, ---). I know it's
All,
Say I have a batch file I am attempting to run like this:
shellmysql -h host_name -u username -p batch_file
Further, say this batch_file has multiple WHERE lines as follows:
use dB1
SELECT x,y,z,zXXName, zYYName, zZZName FROM tblXXX WHERE
zXXName = run0 AND zYYName = farther0 AND zZZName
G'day all,
For some reason I am receiving messages from the MySQL list (only) which I
have already received - some more the a week ago. Is anyone else getting
repeat posts?
kim
-
Before posting, please check:
Dan,
Thanks for your response.
I see what you're saying.
However, in our case, the only 'clients' connecting to the MySQL server are
software modules, no humans. Well actually, humans too, but only through our
software modules.
So no clients getting disconnected until the server is restarted is
the GRANT command errors out when the domain name has a '-' dash in it.
mysql grant Select, Insert, Update, Delete on X.* to [EMAIL PROTECTED]
identified by 'X';
ERROR 1064: You have an error in your SQL syntax near '-tech.net
identified
by 'X'' at line 1
Try
grant Select, Insert,
On Wed, Feb 13, 2002 at 12:04:22AM +0100, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
Should I just put these words
Hello,
I'm writing a application to connect to a mySQL database over a modem link.
Since the link is very slow, I need to limit the number of records returned
when the database and tables are opened. I connect to the database using a
ODBC driver.
Are there any settings I can set to limit the
Please ignore earlier message -- mySQL stores embedded quotes just fine.
Wyckham Seelig
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
On Tuesday 12 February 2002 03:22 pm, Vjay LaRosa wrote:
srsids01# ./mysql
Welcome to the MySQL monitor. ?Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.47-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Segmentation fault (core dumped)
I'm using MySQL-Max-3.23 and I need to keep a table from exceding a
certain size. I plan on running a cron job that checks the size of the
table and if its close to the max, executes a delete statement. The
problem I have is that 3.23 doesn't support delete from .. order by ..
-- this was added
OK, here's the setup:
Using the binary package in
mysql-3.23.47-sun-solaris2.8-sparc.tar.gz
all unpacked, untarred (with gtar, yes), etc.
I follow all the instructions in the INSTALL-BINARY file,
with this one change: I intend for the user to be mysql_st, not
mysql. But according to note #4
Yep I have been getting lots of old messages as well.
Sinisa Milivojevic [EMAIL PROTECTED] 02/12 3:43 PM
Van writes:
Greetings:
Anyone else getting lists messages from several days, or longer ago?
Phrrrp!: sql database table mysql
Van
--
Hi all,
could someone help me? I'm looking for one quick answer. I've code
like this
$result = mysql_query(SELECT FROM ...);
$rows = mysql_fetch_array($result);
Problem is, when the result have no rows. I receive an error message
from MySQL on the second line, which is OK.
I'm getting duplicate messages separated by several hours. Am I alone
in this, or are others seeing it too?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 5 days, processed
Becky,
You would have to change NET_WAIT_TIMEOUT in mysql_com.h in the source from
8*60*60 to n*60*60 where n is in hours, then recompile.
Regards,
Dan
-Original Message-
From: beckymcelroy [mailto:beckymcelroy]On Behalf Of Becky McElroy
Sent: Wednesday, 13 February 2002 8:08 a.m.
This may be due to 'max_allowed_packet' size ... have a look at
http://www.mysql.com/doc/P/a/Packet_too_large.html
This is configurable
Regards,
Dan.
-Original Message-
From: Alain Fontaine - Consultant and developer
[mailto:[EMAIL PROTECTED]]
Sent: Friday, 8 February 2002 1:30
On Tue, 2002-02-12 at 15:38, Steve Rapaport wrote:
David Axmark writes:
So the standard answer with Apples and Oranges certainly apply here!
More like Äpplen och Apelsiner, that is, different but similar. You Swedish
guys should know. Thanks for answering, David, I appreciate the
http://www.mysql.com/doc/p/e/perror.html
use perror to get more information:
Error code 2: No such file or directory
Regards,
Dan
-Original Message-
From: user lacko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 12 February 2002 4:15 a.m.
To: MYSQL
Subject: error messages
I personally use PHP which it would use your familiar web browser. You
can also use PERL, and I believe ASP as well.
PHP is easy for a front end and doesn't take much to develop!
There is also a web based GUI for mySQL called phpmyadmin which is
awesome if you know nothing about
Hello,
Can anyone help?
When trying to run mysql I get an ERROR 1045: Access denied for user:
'root@localhost' (Using password: No).
In the documentation it mentions 'Using password: YES'. Have tried
starting mysql with --skip-grant-tables and then mysqladmin
flush-privileges which doesn't seem
Try
1) create table c as select a,b as b1,b as b2 ... from a
2) drop a;
3) alter table c rename to a;
Instead of 2) you can rename the table and drop later, or tar-up the
.MYI,.MYD and .frm files for the table before doing the above.
Regards,
Dan
-Original Message-
From: Keith A.
Hi,
Yes I have made some mistakes. There was problem with the outer
join. It should have been ad outer joined to review, not the other way.
I didn't notice the first tabel person in the query.
Try the following with two tables ad and review and later add person
table. We don't know the
[comparisons to Google...]
While any speed up with a full table fulltext search would be helpful
and useful, there are instances where the search is intersected with
another column and the problem of search is therefore more complex but
also leads to potential optimizations.
In our case we
Yaniv,
Set the field of user_id to INT then make the size 10 or larger, which
will produce an ID size of up to 99. Now set it to auto
increment then set the user_id field to Primary key, this should solve
your problem, if I understand you correctly
-Original Message-
From:
You know, I am getting rather fed up with all this too.
Tried to unsubscribe, but the admin isn't hearing me or something. I sent
17 unsub requests today and I haven't gotten a single confirmation e-mail
yet. They will probably come next week and by that time, the request
would have expired.
Hi.
I use mysql 3.26.47, established on Windows 2000 Server Russian.
After I set property - default-character-set = cp1251, web-server on a
beginning to give out a massage - File ' c:\mysql \\ share\charsets
\?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a
compiled character set
I have finished a script that takes the bit keeper sources and makes
MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well. I can put these
up on our site for download if you want. They might get others trying the
code out.
I use the spec file included with the source code.
I'll put it up
I need to create a database in MySQL that I need to bundle with my
program
for distribution. The user will have its own copy of MySQL running. User
using my program will not bother about database issues and the bundled
database will provide him, through my application program GUI, to
At 16:56 2002-02-12, Egor Egorov wrote:
It's possible and it is covered in the manual as well.
Look at: http://www.mysql.com/doc/A/d/Adding_character_set.html
That only explains how to install extra character sets - not how to use different
character sets with different databases on the same
Does anyone know how to cause WO to recognize and offer MySQL as an adaptor?
i.e., how to get WO5 to use MySQL?)
Thanks in advance.
Ted Rogers
FSU MathNet | Apple Systems
-
Before posting, please check:
Is there anyone who could help me with this simple query.
Did i ask anything in a wrong way because I still got no answers to my
request?
SELECT at.name, av.value, at.unit, at.id, a.product_id
FROM attribute_type at
LEFT OUTER JOIN attribute a on (at.id = a.type_id)
LEFT OUTER JOIN
David Ayliffe a écrit :
I read in Paul's book that to use MySQL on a Windows platform you need
to pay for it.
I have downloaded a version of the server and client software from the
official MySQL.com site and installed it on XP without incident.
Paul also writes that the version for
Hello Robert,
Hello experts, I've got a small problem with an sql query here that's got
me completely stuck.
In my MySQL database I've got two tables here that have identical design,
e.g.
table 'detail' - columns sales-order, quantity, part-number, price,
date-sent
and
table 'archived'
On Mon, 2002-02-11 at 02:04, Jeremy Zawodny wrote:
On Mon, Feb 11, 2002 at 03:04:47PM +1300, Ian Collins wrote:
In mysqlhotcopy, function copy_files, there is a line,
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
(dont you just love perl?).
If the database name in question is,
Hello experts, I've got a small problem with an sql query here that's got
me completely stuck.
In my MySQL database I've got two tables here that have identical design,
e.g.
table 'detail' - columns sales-order, quantity, part-number, price,
date-sent
and
table 'archived' - columns
Hi Abdul,
Can Mysql ignore alphabet , like 'the' when
ORDERING a name.
A sample :
I have a table (first_name) :
- The test.
- Falcon
- The Armageddon
- Battle
When ordering it will be :
Battle
Falcon
The Armageddon
The test.
Can it be like this :
The Armageddon
Battle
Falcon
The test.
Hi Stanley,
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
Hi
I have just moved a copy of a database from and old MySQL server to a new
one.
But I am geting the folowing error.
---snip---
mysql select * from customers;
ERROR 1016: Can't open file: 'customers.ISD'. (errno: 138)
---snip---
Can some one please tell me what this error is, or tell me where
1 - 100 of 212 matches
Mail list logo