Hello 'mysql',
I found your address on http://lists.mysql.com.
I'm a freelance programmer from British Columbia, Canada,
with a college degree (well, almost) in computer science,
and four years experience. I'm currently looking for
programming contracts that I can fulfill over the Internet.
These RPM's tend to set you up to run mysql automatically upon
boot.
Instead of trying to run mysql, just log into it:
% mysql -h localhost -u root -p press enter
then it will prompt you for root user password. Enter it and off
you
go.
~Shilo
--- David Richards [EMAIL PROTECTED] wrote:
Hi,
Could anyone please let me know how I can transfer data from excel to a mysql
database? If it is possible. The data is stored in an excel file on my PC. And I want
to transfer the contents (about 500 records with 20 fields) of this excel file to a
mysql table on a remote linux server.
Hello Heikki,
Friday, February 23, 2001, 6:51:33 PM, you wrote:
HT Peter and Sander,
HT relevant questions, I will try to answer them.
Good questions - I have a few more :)
A) why does it seem to use fixed-size storage units. (The files)
HT I have copied the concept of a tablespace
Sir,
i Like to work on Mysql, in Windows 95 or Windows Nt,
i saw ur site, it is nice, what should i download from the
net , because lot of softwares are there
and also i like to work in Php - server side on Pws or iis
as web server . is there is any dll or api for this .
are u
Hi All
Thanks for the info but I need to be able to read a selected file from client
host and write this to te db.
I use this to get the file from client
Picture:input type="file" name="picture_path"br
input type="Submit" name="submit" value="Enter information"
this gets the path and file
Steven Roussey writes:
Some clarification. On this table there are a lot of indexes, but there is
one unique/primary key, and it is that one that the replace should be
checking for. The other indexes have the same fields in different places
though. Table key def is something like this:
Mark Chalkley writes:
According to the MySQL manual (section 7.7.1), CHAR columns defined to be greater
than 3 chars in length are converted to type VARCHAR. I understand the space
efficiency issues involved here, but when the column is used in an index, doesn't
that impose a performance
Hi,
I`m setting up a email system, the same type of system as Yahoh Groups,
Topica etc.. I`m just in need of some advise as to how best to handle my
tables. At the moment I have the following tables setup..
Lists - Stores info about the list
ListOwners - Stores all List Owners info
Christopher McClan writes:
Hello,
The staticly compiled mySQL gui, comes up with the following when I start
mysqlgui :
Can't connect to local mySQL server through socket (111)
I'm doing this as root, I have set a password, and managed to create a
databse (using mysqladmin),
Dear MySQL masters,
Can I select a random record from a table. After doing a query on a table
can i retrieve a record randomly. Is there a way in MySQL to achieve this.
If, can you please send me details.
thanks
Sheni R Meledath
[EMAIL PROTECTED]
Could someone help me out with the following line I think the slashes are
causing the problem but I am not sure:
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Can someone help me with the following command? The slashes seem to be
causing a problem. It doesn't find /images/covers?
update products set products_image='images/covers' where
products_image='/images/covers%';
-
Before
Hackley, Susan writes:
Help I ran into this problem while compiling.
root @
fwnau060.usco.com:/root/mysqlgui/fltk-1.0.10
= make
=== making src ===
Compiling Fl.o...
Artem Koutchine writes:
Hi!
I have posted a message about INSERT DELAYED
crashing the 3.23.33 server build from tar ball
on FreeBSD 4.2-STABLE using
--felide-constructors
--fno-exceptions
--fno-rtti
to make it work on high loads. However, with
or without mentioned compiler
Hi!
I have posted a message about INSERT DELAYED
crashing the 3.23.33 server build from tar ball
on FreeBSD 4.2-STABLE using
--felide-constructors
--fno-exceptions
--fno-rtti
to make it work on high loads. However, with
or without mentioned compiler params i could never
do any INSERT DELAYED on
Check the archives, we had this discussion a few weeks ago and someone came
up with a good solution.
Cal
http://www.calevans.com
-Original Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 24, 2001 9:05 AM
To: MySQL Masters
Subject: Random record from
Hello,
I'm trying to understand MySQL indexing but am having trouble understanding the
differnences (and when to use each) between Primary Key, Key, Unique, an Index. Can
you help?
Thank you!
Hello,
I need some help. Does anyone see what I'm doing wrong here:
create table MeetScores (
MeetScoresId default 100 not null auto_increment,
meet varchar(5) not null default '',
sess varchar(3) not null default '',
GymnastNumber integer not null default 0,
Gymnast varchar(30) not null
Hi all,
I'm trying to get a query to work but am having no luck. It seems so
simple, it should work, but obviously, I'm doing something wrong.
Table: Employees
Fields: FirstName
LastName
EmployeeID
Table: Sales
Fields: SubTotal
EmployeeID
What I want to do is
Ward, Brian writes:
Any idea why the create or edit table don't seem to do anything? I select
them and nothing happens?
Explanation is simple.
One is on TODO and second one is in the works.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/
Karl Stubsjoen schrieb:
Hello,
I need some help. Does anyone see what I'm doing wrong here:
create table MeetScores (
MeetScoresId default 100 not null auto_increment,
Thanks!
test:
create table MeetScores (MeetScoresId DEFAULT '100' not null
auto_increment,primary key (MeetScoresId));
Danie Weideman schrieb:
I played around with fread PHP function but with no-luck
how about fopen(),
or
$fp=fsockopen( "$host", 80,);
$anfrage="GET $seite HTTP/1.0\r\n");
etc.
IrmundThum
-
Before posting, please check:
Hi, I have Downloaded Binary distribution and when I runned
/usr/local/mysql/configure it told me that I did not needed to do that, that
is a binary distribution and that it was going to start the mysqld for me
along with some initialization tables or data from
/usr/local/mysql/data. But when I
Get the New Riders MySQL book. It is a very good tutorial and reference on
MySQL. You should also look at the online documentation.
The setup and configuration of MySQL is very simple. In addition, my
preliminary test show that it is very fast. I have almost 500,000 records
stored and
Did you set up the database with the scripts/mysql_install_db command?
Brady...
Original Message Follows
From: David Richards [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySql Install problems
Date: Sat, 24 Feb 2001 01:59:56 -0500
Description
I have installed MySql version
Dear Mysql,
After unpacking Mysql mysql-3.23.33.tar on solaris x86 with gcc 2.95. i run configure
with
CC=gcc CFLAGS="-O6 -fomit-frame-pointer -DHAVE_CURSES_H" CXX=gcc CXXFLAGS="-O6
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -DHAVE_CURSES_H"
./configure
Hi folks,
after having carefully tuned all statements within a larger web based
application rewriting SQL statements and optimizing them by adding indices,
there are still two statements left, which are awkward concerning
performance. Maybe I am just too blind to see how to get them working
Is there mysql 's BDB table version download for
Windows 95 - NT ?
-
Regards
Yusuf Incekara
Avukatpro Limites Sirketi
http://www.avukatpro.com
for Mysql Visual Basic Samples
http://www.avukatpro.com/mysql.html
Hello list
I've just installed mysql-3.23.33 with db-3.2.9a (linux on a ppc) and
still have dog slow bdb tables with data errors.
How fast are bdb tables really, for those where they work? Doing 3
queries/sec is not a real option for me.
Note that I had to change the makefile in
Hi!
Does the skip_counter bug is fixed or how to fix it ?
Thanks
Jimmy
Visitez mon site web:
http://www.llimzsoft.com/
__
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur,
Hi everyone,
I've got a problem with my MySQL-Database that I've been dealing with
for nearly two weeks now and I don't seem to get a clue of what it's
about. My webspace-provider (Schlund Partner in Germany:
http://www.schlund.de) doesn't have a solution either, nor have some of
my
This should be very simple, but for some reason, my query does not return the
desired results
I have the following two tables:
CREATE TABLE Rank (
Rank CHAR(40) NOT NULL PRIMARY KEY,
ReportsTo CHAR(40) NULL
);
CREATE TABLE ROSTER (
EntryNumber INTEGER NOT NULL AUTO_INCREMENT
I posted this problem before and heard nothing, but this time I
compiled mysqld to debug and have posted some of the debugging output.
The following worked fine under 3.23.8. It fails miserably
under 3.23.32 - also 3.23.33 but I used 3.23.32 for the output
below. It seems that mysqlimport reads
First let me explain what I am trying to do. I want to archive many many
messages into a mysql database. The format is pretty simple... either the
message is a parent, or it is a reply. The problem is that some of the
queries are taking 5-10 seconds, which is not acceptable for my application.
Hi...
If slave went down, while master worked and some update made on master.
after slave restart, slave could not get update information and
slave's data unchanged.
What Can I do for
this situation?
Thank you for advanced
answer!
---
Sorry for going slightly off-topic...I realise this is more a Perl
question , but suspect someone here might know the answer.
I'm halfway through writing a module (it's at alpha stage) to cache
mysql/DBI query results, either within RAM using shared memory or to disk
using Storable. Testing
I doing a newspaper site. My database has a different table for each
category (local, sports, etc). All of the columns are the same for each
table (Headline, byline, body, etc). Is there any way to search all of the
tables at once (since they all have the same columns)?
To further
One quick question, I am trying just replace part of the entry ie:
change:
/image/covers/009.jpg
to
image/covers/09.jpg
I have tried to update products set products_image='image/covers' where
products_image like '/images/covers%'; but it seems to replace the whole
field and not leave the
Many thanks. Problem is cured
- Original Message -
From: "Thalis A. Kalfigopoulos" [EMAIL PROTECTED]
To: "Cory Whitesell" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, February 24, 2001 4:26 PM
Subject: Re: Stumped
This should be very simple, but for some reason, my query
On Fri, Feb 23, 2001 at 03:05:19PM -0500, Sander, Ryan wrote:
I doing a newspaper site. My database has a different table for each
category (local, sports, etc). All of the columns are the same for each
table (Headline, byline, body, etc). Is there any way to search all of the
tables at
Marcus Ouimet wrote:
One quick question, I am trying just replace part of the entry ie:
change:
/image/covers/009.jpg
to
image/covers/09.jpg
I have tried to update products set 'image/covers' where
products_image like '/images/covers%'; but it seems to replace the whole
field and not
On Sat, Feb 24, 2001 at 09:43:45AM -0700, Karl Stubsjoen wrote:
I'm trying to understand MySQL indexing but am having trouble
understanding the differnences (and when to use each) between
Primary Key, Key, Unique, an Index. Can you help?
Index and Key are the same.
A Primary Key is a
I have a question about index usage. I've got a query that's showing up in the -slow
log (it's taking less than long_query_time seconds, but I've got --log-long-format
set), indicating that it's not using an index, and I don't understand why.
Given two tables:
CREATE TABLE c1 (id INT(8) NOT
i'm newbie.
how come i can create but cannot drop? (errno: 21)
i am root.
mysqladmin asks if i am sure... i say 'yes' and i get the same (can't
rmdir. errno: 21)
TIA
-
Before posting, please check:
On Sat, Feb 24, 2001 at 11:33:40PM -0500, Mark Chalkley wrote:
I have a question about index usage. I've got a query that's
showing up in the -slow log (it's taking less than long_query_time
seconds, but I've got --log-long-format set), indicating that it's
not using an index, and I don't
At this point, there's only 1 row in companies, and 8 in contacts.
table typepossible_keys key key_len ref rowsExtra
companies system PRIMARY,comp_id 1 Using filesort
contactsALL cont_comp_id_idx
It sound like you are using a version of MySQL that had a replication
bug in it. I suspect that if you upgrade to 3.23.33 the problem will
go away.
Jeremy
No, Master is 3.23.33, and slave is 3.23.32
The manual says "Shutting down the slave(cleanly) is also safe,
as it keeps
48 matches
Mail list logo