I think that you would have got the answer by now, but initally mysql does
not need a password. You can just login without the password, then change
it using mysqladmin newpassword.
Adrian
On Fri, 9 Mar 2001, Luis wrote:
> I read the manual plus look on the site. I been having trouble setti
The best way (for me) to make csv files...
Create the file in MS Excell
Save as csv file
Hope it helps.
Svmks
--- Floyd Baker <[EMAIL PROTECTED]> wrote:
>
>
> Hi..
>
> I have win32, mysql, php4. For mysql building, I've
> been using the (dos)
> environment and a simple windows admin progra
> the table was
> created with the pwd as a VARCHAR(15) <--- will this long enough to held
> the encrypted password??
There's your problem. PASSWORD() returns a CHAR(16).
--jfarr
-
Before posting, please check:
http://w
People,
I am new in this mailing list and new to mysql, so sorry if this question
has been asked before repeatedly.
I am developing a user table where my highschool alumni can register and
set their own password to access the member function using php. I found
from the document that I can st
Hi
How can I get mysql.sock file, it has been deleted by accident? Please let me
know.
Syed
/var/lib/mysql/mysql.sock
Hello,
Thank you very much for your quick answer .
(I had forgotten to give my OS : solaris 2.7 on Sparc)
This has solved the connection problem. So, now I can launched mysqlgui because
I'm able to connect to mysqld .
Unfortunately, mysqlgui crashes on 'Select QUERY' when
* I chose 'fil
On Thu, Mar 08, 2001 at 10:30:18PM -0500, Justin wrote:
>
> Typically, in a database backed website with a very high percentage
> of selects to inserts, people do not "expect" update operations
> (posts and so on) to complete very fast. But they do "expect" page
> requests to be very fast.. the d
Select Name, lower(name) as sortOrder from users order by sortOrder;
Not exactly what you wanted, but closer.
Cal
http://www.calevans.com
-Original Message-
From: Kif Henderson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 7:38 PM
To: [EMAIL PROTECTED]
Subject: Case Sensitiv
On Wed, Mar 07, 2001 at 07:49:22AM -0600, Mike Thompson wrote:
> Yes, I've tries that here is the error I get.
>
> Your MySQL connection id is 247 to server version: 3.23.33
>
> mysql> CREATE TABLE foo(
> -> id INT NOT NULL AUTO_INCREMENT,
> -> name BLOB NOT NULL,
> -> PRIMARY KE
Hi,
Can somebody PLEASE help me
If I send a query to get a list of names, like this:
SELECT Name FROM users ORDER BY Name,
I get a list of users like this...
Bob
Jon
Mark
Sally
andy
lucy
mary
steve
when what I REALLY want is this...
andy
Bob
Jon
lucy
Mark
mary
Sally
Steve
Can someone g
I must agree. I thought you were nuts at first but I've run several GRANT's
myself and can't find one that will affect it.
Possibly it's being depreciated as people start using GRATNs and not
manually adding people into the mysql database?
Cal
http://www.calevans.com
-Original Message---
I was doing a basic query on my windoze 98 system like so:
Select * from table_name order by RAND() LIMIT 1;
When i tried to port this to a linux box running mysql 3.22.32 it doesn't
seem to work. I thought this was compatible with that version but i guess
not. Can anyone recommend another way
On Fri, 9 Mar 2001 18:41:46 -0500, "Tac/Smokescreen Action Network"
<[EMAIL PROTECTED]> wrote:
>>
>>I've searched the MySQL manual and can't figure out how to convert one (or
>>all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to
>>3.23).
>>
>>I think there's a way to do it
Try:
alter table [tablename] type = myisam;
There is a script that purports to do this for you, but the copy that I had wouldn't
run properly, so I just made a file of the SQL needed, and ran it through mysql...
Tac/Smokescreen Action Network wrote:
> I've searched the MySQL manual and can't f
Thanks Setve,
but right now I cant change the filesystem, so I need to go for the
with-raid option,
I read the manual and recompiled my MySQL, but I still cant get bigger
files than 2GB. Accordning to the manual it shall create sub directorys
named 00, 01, 02, etc
any idea?
/roger
>From: Steve
I've searched the MySQL manual and can't figure out how to convert one (or
all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to
3.23).
I think there's a way to do it from the ALTER TABLE command, but I can't
seem to find any examples.
Thx,
Tac
---
I found the error. I was using "" around the "+" where I should have been
using '', like '+'.
SELECT
IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
- ',CMEYR))),' - ')
FROM
TABLE;
Thanks for your help.
John Halladay
-Original Message-
From: Boulat Khakimov
Anyone know an easy way to migrate a Database from Postgres to MySQL?
-Jason Bell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
Charles L Hagen wrote:
> I just went through this. I found that it would be better to download and
> install the binary from mysql.com because there is scant information.
>
> With the binary install you get specific instruction sheets.
>
> Charles
>
> On Fri, 9 Mar 2001, Randall Paulk wrote:
>
>
Keneth wrote:
>
> "When I try to dump sql database it gives me some errors 1.Error 1045
> mysqldump --opt database > backup-accp.sql mysqldump: Got error: 1045:
> Access denied for user: 'accp@localhost' (Using pass word: NO) "
>
> can you help?
>
> with best regards,
> Keneth
Read the manual,
[EMAIL PROTECTED] wrote:
>
> On Fri, 9 Mar 2001, Jon Haworth wrote:
>
> > Not sure exactly what you're after... MySQL isn't an Apache module, it's a
> > separate program.
> > Where can I find Apache module for mySQL ??
>
> maybe "mysql module for apache"?
>
> regards
> --
You mean mod
I believe it is also something that has to be enabled and configured in
the apache server.
Charles Hagen
On Fri, 9 Mar 2001 [EMAIL PROTECTED] wrote:
> On Fri, 9 Mar 2001, Jon Haworth wrote:
>
> > Not sure exactly what you're after... MySQL isn't an Apache module, it's a
> > separate program.
>
On Fri, 9 Mar 2001, Jon Haworth wrote:
> Not sure exactly what you're after... MySQL isn't an Apache module, it's a
> separate program.
> Where can I find Apache module for mySQL ??
maybe "mysql module for apache"?
regards
--
Bartosz Sienkiewicz
MULTINET SA
---
Please provide guidance!
I've been looking over the documentation, but haven't come across any
instructions for creating your own binary distribution. The MySQL source
distribution is installed and running on our development system. Now I want
to make it into a binary distribution for installat
I recently got MyODBC to run on Win2k and it works fine.
-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: March 9, 2001 6:53 AM
To: Dave Loisel; MySql
Subject: Re: ODBC
Dave:
Not sure I follow the question ... we have 50+ systems (WinNT Server or
WinNT Workstatio
John Halladay wrote:
>
> I'm getting a warning that says "the supplied argument is not a valid MySQL
> result resource."
>
> Here is the SQL that I'm trying to write in a php document.
>
> SELECT IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
> - ',CMEYR))),' - ')
>
When you reimported the text file, did you include REPLACE? For example:
LOAD DATA INFILE 'textfile.txt' REPLACE INTO TABLE table_name;
Tracy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of scott
Sent: Friday, March 09, 2001 4:19 PM
To: MySQL
Subject: C
I've already run quite a few GRANT commands. None of them have done
anything to the mysql.host table. I'm pretty familiar with the db and user
tables. Chapter 6 barely mentions that the host table exists. The
statements it makes about its (the host table) interaction with the db table
do not pa
I reimported the text file which should overwrite the data right which
did not work. If not how do I overwrite the data?
You are expecting an awfull lot from mysql to remember data that it
never
recorded. When you inserted something into the varchar(50) column that
was
longer than 50 it dropp
I'm getting a warning that says "the supplied argument is not a valid MySQL
result resource."
Here is the SQL that I'm trying to write in a php document.
SELECT
IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
- ',CMEYR))),' - ')
FROM
TABLE;
Is it not possible to nest
Then run some GRANT commands, and see what they do to the privilege
tables.
Chapter 6 goes into quite a bit of detail on this topic.
Jeff Brewer wrote:
>
> I've been over Chapter 6 quite a few times, however I don't see any actual
> example of using the host table in conjunction with the db tabl
I had this same problem. I could connect via the mysql client if I was
ROOT, but not otherwise.
You may have a permissions problem. Ensure that /var, /var/lib, and
/var/lib/mysql are set to: drwxr-xr-x
That cured it for me.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROT
I get an error when trying to configure. The configure command I am
useing is as follows:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
--without-debug
The error I get is as follows:
checking return type of sprintf... configure: error: can not run test
program while cross comp
>Description:
The mysql_install_db script hangs when I try to install mysql. I've tried a
src rpm, a binary rpm and the binaries. When you run mysql_install_db, three
different mysqld's are started but none actually do anything. They are all just
sitting there.
>How-To-Repeat
You are expecting an awfull lot from mysql to remember data that it never
recorded. When you inserted something into the varchar(50) column that was
longer than 50 it dropped the rest of the string that would not fit.
Changing the column size will not bring back the data.
ryan
> I had a column
Try
mysqldump -u username -p --opt databasename > dumpfile.sql
to get it back into another mysql server you need to create the database you
want to put it in, and then
cat dumpfile.sql | mysql -u username -p databasename
Hope that helps.
ryan
- Original Message -
From: "Jorge Cordero"
There should be no password for root@localhost initially. Try
$mysqladmin -u root password 'thisIsMyNewPassword'
instead. The password mysqladmin is asking for is the current password.
The one on the command line is the new one. In your situation the current
password is nothing.
-Jeff Brewer
I just went through this. I found that it would be better to download and
install the binary from mysql.com because there is scant information.
With the binary install you get specific instruction sheets.
Charles
On Fri, 9 Mar 2001, Randall Paulk wrote:
> Dear Sirs:
>
> I am trying to install
I've been over Chapter 6 quite a few times, however I don't see any actual
example of using the host table in conjunction with the db table. One
concrete example, I think, would be enough to get me on the right track, but
there just doesn't seem to be any and I certainly can't make heads or tails
Did you read chapter 6 in the manual?
Jeff Brewer wrote:
>
> I've been trying to understand how in the world the host table interacts
> with the db table to provide permissions. None of the documentation seems
> to help. I've been able to grant database/host specific access to certain
> users.
I read the manual plus look on the site. I been having trouble setting up a
password for root.
here's the message i get.
First I run this
$mysql_install_db
$mysqladmin -u root -p password 'newpassword'
Enter password: < I enter the password same as above >
mysqladmin: connect to server at 'l
Dear Sirs:
I am trying to install MySQL on Red Hat Linux 7.0. It seems to install correctly, but
I am unable to test it. I follow the instructions in the manual (starting on page
96), but I get an error after the command safe_mysqld --user=mysql &. The following
is output to the scrreen:
[
I've been trying to understand how in the world the host table interacts
with the db table to provide permissions. None of the documentation seems
to help. I've been able to grant database/host specific access to certain
users. Unfortunately, the exact same configuration (between user/db/host)
Defaults can only be constants.
You might want to look at timestamp.
The first timestamp field in a row gets updated every time teh record
changes.
All other timestamps in a row only get updated automatically on insert.
Jamie S Buchanan wrote:
>
> Hello all,
> I'm a third year uni student in Sco
Jamie,
mySQL doesn't support triggers, and you'd need them (or a stored
procedure). Surely you could just set both A and B explicitly in your
application logic to the same value though ? Or am I missing your point
?
P
On Fri, 9 Mar 2001, Jamie S Buchanan wrote:
> Hello all,
> I'm a third year
Hello all,
I'm a third year uni student in Scotland doing a year long project which
involves a fair amount of MySQL. I have the following problem and would be
appreciative if I could get some advice on solving it:
- in the script I run to create a table how do I code one DateTime field
to intiall
I had a column that was set to varchar(50) which ended up not being enough
space. So I went in and did a:
alter table main change description description varchar(255) not null;
It said everything went ok, I reimported the text file, but the words stop
after 50 characters still did I miss something
isamchk order_stats
Checking ISAM file: order_stats
Data records: 264282 Deleted blocks: 0
- check file-size
- check delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check record
Hej!
Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC.
Ran optimize on a table, and after 10 minutes :
010307 17:00:00 Out of memory; Check if mysqld or some other process uses
all available memory. If not you may have to use 'ulimit' to allow mysqld to
use more memory or
> -Original Message-
> From: Bob Vastine-Parker
> Sent: Friday, March 09, 2001 10:32 AM
> To: John Runnels
> Subject: RE: status report
>
>
>
> -Original Message-
> From: John Runnels
> Sent: Friday, March 09, 2001 10:28 AM
> To: MY
> Subject:
I wanna access to a DB via php but when I run it in a navigator y get the
following message
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/home/httpd/html/challa.php on line 10
Unable to connect to database
I can get
Hi,
I wanted to create a UDF for MySQL that can use the ASpell engine to
generate a string of spelling suggestions, given a single word
parameter. Thus, select aspell('wrd') should return Aspell's suggested
spellings.
I don't know C very well at all, so I began using an existing UDF
function alr
If all the databases are running in the same mysqld then it might be
possible, if you have select permission on all of them and you preface the
table names with the database name. (select * from database.table...) You
will have to use a JOIN clause to get them all into a single statement which
mea
Roger Westin wrote:
>
> Hi,
> Have a problem with big tables,
> Cant get them over 2GB
> Using mysql 3.23.33
> and ReadHat Linux 6.0 Kernel: 2.2.5
>
> Need to biuld a table atleast 70Gb so Anyone?
>
switch to a file system that supports very large files
The problem should be with linux no mys
Hi,
I'm trying to load test an old application that was written using the gjt
jdbc drivers for mysql.
When I start hitting it with ~10+ concurrent application sessions (each of
which do multiple, short db queries) I start seeing things like this crop
up in the log file:
java.lang.NumberFormatEx
This bug has been around for some time. The script relies upon a certain
form of output from "hostname". However, it fails when a host is named,
for example, "machine.net". It then thinks the name is "machine". Where
it will work if the name is "machine.machine.net".
This should be fixed
Hi,
Have a problem with big tables,
Cant get them over 2GB
Using mysql 3.23.33
and ReadHat Linux 6.0 Kernel: 2.2.5
Need to biuld a table atleast 70Gb so Anyone?
/roger
_
Get Your Private, Free E-mail from MSN Hotmail at htt
I have several seperate databases which i would like to search using one sql query.
All stores have varying field names:
store1.products - author,title,description ...and other fields which i do not need to
use
store2.products - artist,title,comments
store3.products - author,title, comments
Another alternative is: http://www.intercession.net/specialoffers
That site provides Apache/PHP (3.0.7)/MySQL for $60 per year. Just keep
clicking through the links to get to the price list.
-Original Message-
From: Cally [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 12:10 AM
Not sure exactly what you're after... MySQL isn't an Apache module, it's a
separate program.
You want MySQL to run on Apache? http://www.mysql.com/downloads/
You want Apache to run MySQL on? http://httpd.apache.org/
HTH
Jon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROT
Hi,
> In using the application there is one feature I see missing.
>
> 1. Inability to execute multiple statements in sequence.
If you are talking about the MySQL command-line client program, then you
definitely can execute multiple statements at once, just by making sure you
terminate each sta
Hello All,
Where can I find Apache module for mySQL ??
--
Best Regards,
Winson Chang
3F, 2, 150 Lane, Sec. 5, Hsin I Rd., Taipei, Taiwan, R.O.C.
Tel: +886-2-27225333 ext 376
Fax: +886-2-27222330
Email: [EMAIL PROTECTED]
Hi..
I have win32, mysql, php4. For mysql building, I've been using the (dos)
environment and a simple windows admin program. However it doesn't *upload*
data to the database... I've been doing that by hand up til now...
The table with very many fields is done, but now I have a CSV file
What application would that be?
Ciaka Flemister wrote:
>
> In using the application there is one feature I see missing.
>
> 1. Inability to execute multiple statements in sequence.
>
> -
> Before posting, please check:
>ht
Hi, Does anybody out there know if MySQL supports the Thai language, and if
so how? If I try to insert Thai font into a MySQL database then I get an
error! (I don't have the same problem with Access)
Regards
Craig Riley
Web Developer
Reading Room
77 Dean Street
London
W1V 5HA
www.readingroo
> > >
> > > Doug Poland wrote:
> > > >
> > > > Hi,
> > > >
> > > > I'm having a dickens of a time getting mysqldump to
> > > > work. No matter what I enter, mysqldump says...
> > > >
> > > > /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an
>argument
> > > >
The prob
Hello friends.
I am using mysql 3.23.33 on win 98 and win Nt on 2 different disks.
On both the systems I need a sample database for importing into mysql so I
can learn
php4.
can anyone advise where I can find a database or a tab separated text file
which I can import into mysql after creating t
In using the application there is one feature I see missing.
1. Inability to execute multiple statements in sequence.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello
I have installed the MySQL server on a Windows 2000 server, and set up passwords and
usernames. And one database with 3 tables. Each tables uses auto increment fields.
(these are marked as index fields as they should be).
And then i have inserted a few test records. When i do a standard
For some strange reason, all HEAP table indexes only process WHERE clauses
with = and <=> operators ONLY. There's nothing you can do about it. I'm
pretty sure of that because I remember the MySQL mentions something like
this about HEAP tables.
-Original Message-
From: Jeff S Wheeler [mail
Dave:
Not sure I follow the question ... we have 50+ systems (WinNT Server or
WinNT Workstation) running MySQL using the MyODBC drivers.
G. Jensen
- Original Message -
From: "Dave Loisel" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 8:13 AM
Subject: O
This question is where the mySQL manual would save you tons of time. The
procedure you are referring to is called a sub-select. Unfortunately, for
some strange reason, MySQL does not support sub-selects at this time.
However, I know from the development team that sub-select is a major TO-DO
for t
I've set up a site with ColdFusion and MySQL in win2k just a month ago. It
works great. No problems I know of.
About the setting up, the only pointer I have is that the DSN must be a
system DSN, or ColdFusion won't recognize it. Other than that, ODBC should
be smooth sailing.
-Original Messa
You may have a permissions problem. I had the same error.
Ensure that /var, /var/lib, and /var/lib/mysql have the following
permissions: drwxr-xr-x
then restart the client.
rick
-Original Message-
From: Omaro A [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 8:25 PM
To: [EM
There are many ways to handle this.
You might get the current quantity on hand, and compare to orderqty
update inventory set qtyonhand=qtyonhand - orderqty where
itemno='myitemno' and qtyonhand=myqtyonhand
If the query fails, repeat until qtyonhand < orderqty or update
succeeds.
Every hour or so,
On Fri, Mar 09, 2001 at 08:13:24AM -0600, Gerald L. Clark wrote:
> I think you meant
> select sum(deci) as s where deci<0;
> > select sum(deci) as s from deci having s<0;
No, I really meant my SELECT. MySQL counted the 3 values together but
instead of coming to the conclusion that the sum is zer
If I could see the structure of the table with the name of the key field,
I may be able to help.. otherwise, there's just not enough info.
Thanks,
Michael Ridinger
On Fri, 9 Mar 2001, Gerald L. Clark wrote:
> I would suggest that if you really want help, you should at least supply
> a little i
Read the privileges section of the MySQL manual, and GRANT some
privileges.
Peter Daum wrote:
>
> If have a problem to connect to my MySQL-Server on the Internet:
>
> the MySQL-Manager show me this error-message:
>
> Connecting to Server MySQL ... (Host 'pD900A48E.dip.t-dialin.net' is not
> al
I think you meant
select sum(deci) as s where deci<0;
Christian Hammers wrote:
>
> Hello
>
> CREATE TABLE deci (deci decimal(8,2));
> INSERT INTO deci VALUES (-2427.88);
> INSERT INTO deci VALUES (2427.89);
> INSERT INTO deci VALUES (-0.01);
> select sum(deci) as s from deci having s<0;
> +---
I would suggest that if you really want help, you should at least supply
a little information for people to work with.
You might post the table schema, the line that won't insert, and the
query and results
that you ran that shows that the indicated key are not in the table.
Since there are 600.000
Does anyone out there have any success with Mysql ODBC driver for a server
on Windows NT?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
On Fri, 9 Mar 2001, Cal Evans wrote:
> You can't. SQL wasn't designed to do that.
>
> Do all your tables have the same structure?
For a quick and dirty solution: what about using a shell script getting
table names from the data directory and launching the mysql client for
every table?
Thomas
On 09.03.2001 10:29:28 Christian Hammers wrote:
> Is this a bug or is the decimal type just evil or how should *I* behave
> when having such a table?
If I'm not mistaken, then decimal is handled internally like a float. And as
such, problems like yours are really expected, because there simply
You can't tell me this isn't in the archives.
Since you didn't run it as
mysql_install_db --user=mysql
the databases were created with the wrong owner.
chown -R mysql /usr/local/mysql/var ( or whatever it is on your system )
I wish mysql_install_db would error out and complain if no user is
spe
Herve Gaudillat writes:
> Hello,
>
> Currently, I'm evaluating the last version of MySQL products :
>
> mysql-3.23.33
> mysql++-1.7.8
> mysqlgui-1.7.4 (beta)
>
> I have big pb to launch mysql++ and mysqlGui : it crashes during DB
> connection
>
> After spending many day
Please, any idea how to manage concurent requests,
for example like in a shopping cart?
Scenario:
1. I have a counter A (a field in a database row), set to 1, so A=1
2. A client wants 1 unit from A , it checks and it's OK,
there is available.
3. Another client wants 1 unit from A, it check
Hi,
I've installed MySQL (latest version from the web) on my Win
ME computer using OmniHTTPd.
MySQL worked fine for a whole day... (I experimented with
several commands, made tables in databases, etc...). Then I
turned off my computer and when I rebooted, I kept having
'red light' (mysqld.exe is
Hi,
I'm looking for help in an area that I'm without much experience. I
want to create a UDF for MySQL that can use the ASpell engine to
generate a string of spelling suggestions, given a single word
parameter. Thus, select aspell('wrd') should return Aspell's suggested
spellings.
I don't know C
If you are ftp'ing make sure your set to binary transfer method.
Pat...
- Original Message -
From: "ALICE CHIAPPETTA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:37 PM
Subject: Problem
> I have downloaded the stable release for Solaris. Everytime I t
Adam,
The reason you don't find any info on it is because, while not technically
impossible, it is a very bad idea.
If all the tables are not of like structure then are you intending to search
through every field in every table?
if so, yes, you could do it in PHP.
Query for the list of tables.
Try setting the use manager cursors in the MyODBC panel for the database in
question.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Uwe Hein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:17 PM
Subject: Bug in MyODBC 2.50.36-nt ??
>
> Hi everybody,
no, they do not have the same structure,
someone said something about creating a loop using php
since idealy this will end up being a web published database
this sounds good to me, just i have no idea how i would do that
*claims being new to sql & php*
I've scanned thru both of the manuals (mysq
You can't. SQL wasn't designed to do that.
Do all your tables have the same structure?
Cal
http://www.calevans.com
-Original Message-
From: Adam Crawford [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 1:53 AM
To: [EMAIL PROTECTED]
Subject: searching ALL tables
Hi all,
I ju
On Fri, Mar 09, 2001 at 02:05:42PM +0200, Richard Ellerbrock wrote:
> Add another index on your timestamp column. Also, I think timestamp is a reserved
>word. Maybe you should rename the column to something else.
...
> PRIMARY KEY (timestamp,hostname,interfacename)
> ) TYPE=MyISAM PACK_KEYS=1;
If have a problem to connect to my MySQL-Server on the Internet:
the MySQL-Manager show me this error-message:
Connecting to Server MySQL ... (Host 'pD900A48E.dip.t-dialin.net' is not
allowed to connect to this MySQL server)
Give it a Work-Around or something else??
Hello
My selects still last several hours. Can anybody give me a hint which
parameters to tune when the main selects look like the following one on a
1.5GB big table with aprox 1 million affected rows?
join_buffer_size| 131072
key_buffer_size | 67104768
max_heap_table_size
- Original Message -
From: Radoslav Vasilev
To: [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 12:24 PM
Subject: can't add remote user with mysql3.23
The problem I've never had before is that I can't add remote new user on mysql-server
3.23 (installed as freebsd port on freebsd 4.2)
Hi Jorge,
you usually do something like
mysqldump -u USER -p TABLE > FILE
where TABLE is dumped to the FILE. USER must have privileges to do so (I
usually take the superuser).
The other way around you simply have to do
mysql -u USER -p TABLE < FILE
Should work then,
Tobias.
-Ursprünglich
Steven,
I had an experience the other day in a controlled test environment that appears
to be similar. An advantage is that i know precisely what was taking place.
Consider the following:
1) A servlet makes a single 'insert delayed' into a relation. (no auto increment
field - and just a simple pr
Hello
CREATE TABLE deci (deci decimal(8,2));
INSERT INTO deci VALUES (-2427.88);
INSERT INTO deci VALUES (2427.89);
INSERT INTO deci VALUES (-0.01);
select sum(deci) as s from deci having s<0;
+---+
| s |
+---+
| -0.00 |
+---+
Well for the values given above - monetary values - t
1 - 100 of 101 matches
Mail list logo