Hi,
I have installed the package bk-3.0.4-x86-win32.EXE
from Bitkeeper.com, to get the Mysql-4.1.1 source code
for Windows 2000 box.
It's installed successfully and frame the shortcuts in
my Start menu -- program -- Bitkeeper with
sub menus for
bash shell1
bash shell2
Helptool
--- W. D. wrote:
I am a relative newbie to MySQL and PHPmyAdmin. I
tried adding
data into an existing table by 'uploading' a file in
PHPmyAdmin.
I know the INSERT INTO commands are valid, since I
can import
several hundred records using PHPmyAdmin. However,
when I
try to import a few
At 02:03 3/18/2004, olinux wrote:
--- W. D. wrote:
I am a relative newbie to MySQL and PHPmyAdmin. I
tried adding
data into an existing table by 'uploading' a file in
PHPmyAdmin.
I know the INSERT INTO commands are valid, since I
can import
several hundred records using PHPmyAdmin.
Mark,
I've had some of the same thoughts as yours. Others have mentioned SHOW
CREATE TABLE.
I created a Windows program to put a GUI interface on designing tables for
MySQL to ease the load on my memory while setting up a database. It
includes the ability to insert new fields at any place and
A quick question for the hardcore MySQL experts out there.
I have a simple table;
---
ID varchar (PK)
DATA longblob
---
This table is a simple persistence cache for one of our servers. It
regularly INSERTs and SELECTs into this table data of approximately 2KB
-
When I first mail to [EMAIL PROTECTED] they said
Quick answer: you probably have an incorrect Internet Proxy setting.
Test if you can connect to mysql.bkbits.net port 14690 using telnet:
C:\ telnet mysql.bkbits.net 14690
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table;
---
ID varchar (PK)
DATA longblob
---
This table is a simple persistence cache for one of our servers. It
regularly INSERTs and SELECTs into this table data
Keith Thompson [EMAIL PROTECTED] wrote:
All of my tables are now InnoDB only. So, what I'd like to do is
reduce MySQL tunable variables down as much as possible for things
that don't affect InnoDB so that I'm not wasting memory on buffers
that will get little or no use.
It's obvious which
Thanks for that Chris, interesting thoughts.
For clarification, there is *NO* UPDATEs running on this table. Not a
single one! :) Many more SELECTs than INSERTs
Chris Nolan wrote:
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table;
hi
wondering whether someone can set me straight on whether it's possible to
request a set of records from a single table with multiple conditions.
for instance, a story table, containing id, title, text, section and
published_date. what i would like is to retrieve is the 5 most recently
Hi Alan,
Thanks for that Chris, interesting thoughts.
For clarification, there is *NO* UPDATEs running on this table. Not a
single one! :) Many more SELECTs than INSERTs
If you value your data, and these INSERTs are part of
a multi-insert batch of related data, go with the table-type
that
Hi,
I want to CREATE a TABLE an specify a collation.
If I do
CREATE TABLE ... DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
SHOW TABLE STATUS shows me Collation: latin1_swedish_ci
If I omit the keyword DEFAULT the requested collation latin1_german1_ci
is shown by SHOW TABLE STATUS.
Kris Burford [EMAIL PROTECTED] wrote:
hi
wondering whether someone can set me straight on whether it's possible to
request a set of records from a single table with multiple conditions.
for instance, a story table, containing id, title, text, section and
published_date. what i would
Jochen,
what's the result of
prompt mysql -uroot -pXXX -hxxx.xxx.xxx.xxx
when you do it on the client host? (I still suspect that permissions are
not properly granted).
Regards, Thomas Spahni
On Wed, 17 Mar 2004, Jochen Kaechelin wrote:
I use the following Script to backup a remote
Hello colleagues,
Im'using the MySQL 3.23,
I've found the following commands
SET SQL_LOG_BIN=0 Disables update logging if the user has process
privilege. Ignored otherwise. (Master)
SET SQL_LOG_BIN=1 Re-enables update logging if the user has process
privilege. Ignored otherwise. (Master)
[EMAIL PROTECTED] wrote:
Hello colleagues,
Im'using the MySQL 3.23,
I've found the following commands
SET SQL_LOG_BIN=0 Disables update logging if the user has process
privilege. Ignored otherwise. (Master)
SET SQL_LOG_BIN=1 Re-enables update logging if the user has process
Hi all,
It is better i got the settings for *BitKeeper Wizard*
parameters. Becaz when i run it shows parameters and i
select one out of them as;
description : MySQL Source
category : development/building
email: [EMAIL PROTECTED]
name : Arun
street :
city :
The following SQL (bugzilla):
SELECT
products.product,description,disallownew,votesperuser,maxvotesperbug,votestoconfirm,COUNT(bug_id)
FROM products LEFT JOIN bugs ON products.product=bugs.product GROUP BY
products.product ORDER BY products.product;
Causes this error:
ERROR 1: Can't
May be Unix acces permissions on /root/tmp
(Errcode: 13) = EACCES Permission denied
Like you are using an ORDER BY, mysql needs some temporary space to do the order.
Marc.
-Message d'origine-
De : Søren Neigaard [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 18 mars 2004 13:29
À : [EMAIL
S?ren Neigaard [EMAIL PROTECTED] wrote:
The following SQL (bugzilla):
SELECT =
products.product,description,disallownew,votesperuser,maxvotesperbug,vote=
stoconfirm,COUNT(bug_id) FROM products LEFT JOIN bugs ON =
products.product=3Dbugs.product GROUP BY products.product ORDER BY =
This is just my guess, I am still too new to know for sure, but I would say
php can do what ever the user that is logging in can. phpMyAdmin will
create databases, and it is just a PHP Script.
Todd Hackathorn
-Original Message-
From: Elly Wisata [mailto:[EMAIL PROTECTED]
Sent:
On Thursday 18 March 2004 15:41, you wrote:
Hm it really is the problem i think, so next question :) Where do I
specify the location of the temp dir? Can I do that somehow in the
/etc/my.cnf file?
Sure. Put into my.cnf:
[mysqld]
tmpdir=/path/to/the/tmpdir
User that runs mysqld ('mysql' by
Hi,
-Original Message-
From: Elly Wisata [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 1:55 AM
To: [EMAIL PROTECTED]
Cc: 'BGLefty'
Subject: RE: php script for new database and user
I don't think php script can create database. But maybe I am wrong.
If I am, please
I wish to learn MySQL on my Linux box [SuSE 8.1]
Can I install MySQL on my hard drive and use it for learning *from* the
hard drive, without having to set up a server/network? This would include
MySQLCC.
In other words, can I run MySQL like Access, strictly as a local database,
for learning
Please read the attached file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes! Yes you can!
Ahem
Basically, MySQL is always a network-aware database whether connections
come in via Named Pipes (blame Bill for those), TCP/IP, UNIX sockets or
via the funky shared memory whatsit that was brought in with MySQL 4.1.x.
All that will be happening in your case is that
Hi,
-Original Message-
From: Elly Wisata [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 1:55 AM
To: [EMAIL PROTECTED]
Cc: 'BGLefty'
Subject: RE: php script for new database and user
I don't think php script can create database. But maybe I am wrong.
If I am, please
Oh, thanks for your information. I used phpMyAdmin b4, but I never noticed
that it makes from php script! Gosh!!!
Thanks for make it straight.
- Original Message -
From: [EMAIL PROTECTED]
To: Bernd Tannenbaum [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 9:45 PM
we are faced to a problem where creating databases
the installation is succeded but we can't create the databases correctly
the instruction ./scripts/mysql_install_db shows
prepare installing database inspite of creating db table
what is the solution?
Do you Yahoo!?
Yahoo! Mail - More
Hi all,
I'm trying to create new columns in a table with 308.000 records and 135
columns. It last 14 minuts to create one column. I make it trough
MySQL4XManager. I don't think is a problem of MySQL4XManager.
I guess is something about two many records and to many columns. Am I wrong?
If I am
Hi all:
Long time ago I've installed MySQL on my Debian Machine and I'm pretty sure I did'n
left the sa pwd blank as recommended.
Now, I'm installing other apps that need that sa pwd in order to be installed
properly butI can't remember the pwd.
is possible to recover the sa password?
jose manuel
We have various client applications who will need data stored in MySQL
database. We are planning to send data requests from these clients to MySQL
database server through a DBMGR application.
We would like to keep the DBMGR as a single threaded application servicing a
configurable number of
I haev three tables:
Table 1
id_2 | date
Table 2
id_1 | id_2
Table 3
id_1
I want to set the table1.date = '2004-03-18' for each record in table3. Any
ideas?
Thanks,
Russell.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
UPDATE table1 t1, table2 t2, table3 t3
SET t1.date = '2004-03-18'
WHERE t1.id_2 = t1.id_2
AND t3.id_1 = t2.id_1
On Thu, 18 Mar 2004, Russell Horn wrote:
I haev three tables:
Table 1
id_2 | date
Table 2
id_1 | id_2
Table 3
id_1
I want to set the table1.date = '2004-03-18'
I've made a mess of this MySQL installation. I would like to uninstall and start
over.
- Started out installing via YaST
seemed to work but couldn't find MySQL or run it
- Tried installing binaries
had trouble running 'make install' (installed 'make' via YaST but never did find
Sorry if I posted this twice - I had some email issues yesterday, and I
didn't know if this made it to the list:
I am using php with mysql, and after moving my tables to a new server, I am
suddenly getting this error:
Query failed: You have an error in your SQL syntax. Check the manual that
Hello,
Does anyone have any idea why the following don't work in MySQL
4.1.1-alpha with InnoDB tables:
1. cannot change column type without first dropping the foreign key
(when there is one)
2. cannot drop the column without first dropping the foreign key (if
there is one)
3. cannot explicitly
Table 1
id_2 | date
Table 2
id_1 | id_2
Table 3
id_1
I want to set the table1.date = '2004-03-18' for each record in table3. Any
ideas?
Based upon your description you could probably use:
UPDATE table3, table2, table1
SET table1.date = '2004-03-18'
where (table3.id1 =
1. The column types must match in order to establish a foreign key
relationship. Alter the data type would invalidate the Foreign key. Therefore
the key must be dropped first.
2. You can not have a relationship on a column that does not exists. Once again
the key must first be dropped.
3-4.
People,
I have a php web application that has an admin page for inserting course records and
one for selecting course records
and a client page for selecting course record.
In the admin side I insert records with an insert into Course_Eng and I select
records witha select * from Course_Eng
On Mar 17, 2004, at 4:41 PM, Paul DuBois wrote:
At 14:06 -0800 3/17/04, James Hughes wrote:
I want to set up some automated table checking and the research I've
done has left me scratching my head.
I'm looking for a definitive answer to this thread:
Hi!
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 18, 2004 8:21 PM
Subject: Re: InnoDB - alter column
1. The column types must match in order to establish a foreign key
relationship. Alter the data type would
You need to stop your MySQL process and then startup MySQL without the
grant tables (skip-grant-tables option). You can then change the
password.
Here some documentation on how to do it in Windows, but it's pretty
much the same for Unix.
http://www.mysql.com/doc/en/Resetting_permissions.html
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions to process the statements. This
will be an online registration process for our business, using PHP and
MySQL. PHP is using
Scott Plumlee wrote:
I've looked through the PHP Cookbook and the MySQL cookbook and haven't
seen a solution. I've thought about trying to make some unique hash
with the data to be inserted but if there's another identical set of
data, then the hash would match. I can't use a timestamp in
Mysqlians,
1. How can I tell how many words a fulltext index has indexed?(for
purposes of estimating performance)
2. How can I tell how much index file space a full text is responsible for?
( for regular indicies I use (key_length +4)/.067 ) but my
fulltext's are all on text's.
Thanks,
I used YaSt to uninstall - though I wasn't really happy with the uninstall because I
used the find command on 'mysql' and found lots of stuff that was left behind after
the uninstall.
Anyway I then reinstalled with rpm -i
It probably isn't working 100% yet but it is working enough that I can
Hi, everybody
I have in my office two pc machines. One of them is a Pentium III with Windows
98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP
and MyODBC 2.50.39. The MySQL database is running on a linux server, and via
MyODBC I connect to the MySQL server to run my
Jos Angel Blanco Linares wrote:
Hi, everybody
I have in my office two pc machines. One of them is a Pentium III with Windows
98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP
and MyODBC 2.50.39. The MySQL database is running on a linux server, and via
MyODBC I
You're using a foreign key.
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html. In order
for the constraints to work, the DB must be type InnoDB. Otherwise the data
checks for integrety must be done by you in the INSERT program.
Respectfully,
Ligaya Turmelle
pramilav [EMAIL
* Scott Plumlee
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions to process the statements. This
will be an online registration process for our business, using PHP and
MySQL.
Does MySQL have a string contatenation operator, or must you use the
CONCAT() function?
SELECT firstname + ' ' + lastname AS fullname
FROM customers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 19:14 18/3/2004, José Angel Blanco Linares wrote:
Hi,
Hi, everybody
I have in my office two pc machines. One of them is a Pentium III with Windows
98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP
and MyODBC 2.50.39. The MySQL database is running on a linux server,
or must you use the CONCAT() function?
Yes
SELECT concat(firstname,' ',lastname) AS fullname FROM customers;
Cheers,
Andrew
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday 18 March 2004 22:30
To: [EMAIL PROTECTED]
Subject: String Concatenation Operator?
Not sure if you can...
Maybe add it to the ToDo list at:
http://www.mysql.com/doc/en/Fulltext_TODO.html
Cheers,
Andrew
p.s. also see you at the conference...
-Original Message-
From: Trevor Price [mailto:[EMAIL PROTECTED]
Sent: Thursday 18 March 2004 21:10
To: [EMAIL PROTECTED]
Has anyone done much testing with RAID stripe sizes for heavy
concurrency InnoDB-based applications?
I'm expecting that using a stripe size that matches InnoDB's page size
would make sense, but it could save a lot of testing if someone else
has already done this.
Thanks,
Jeremy
--
Jeremy D.
I need some help with a complex query of mine.
The query in question looks like this:
SELECT DISTINCT film_film.filmid, titel, pdf, termin, aar,
film_serier.serieid, serienamn, screener, har_affisch, har_bilder, max(
datum )
FROM (
(
(
`film_film`
LEFT JOIN film_rel_regissoerer ON
I have a table that has employee names, pay rates, and unique IDs. I want
to select all of the distinct employee names, and if there are two employees
with the same name, I want to be able to choose only one; the one with the
highest pay rate. If there are two identical employee names with the
Hello people ! I was hoping for some wisdom from the good folks on this
list about moving databases from access to MySQL.
I am aware of the brute force method of exporting in CSV format or tab
delimited formats and using mysqlimport to move the tables.
1. I was wondering if there was a way to
Hi bob ! thanks for your quick reply. I did do a search on google. I
bumped into a bunch of stuff that really lead nowhere. Do you have any
specific sites or utilities in mind ?
Arjun Subramanian
Georgia Tech Station 32003
Atlanta GA 30332
Cell: +404.429.5513
I'm MySQL certified. Are you?
Arjun Subramanian wrote:
Do you have any
specific sites or utilities in mind ?
Try the code posted in this newsgroup posting:
http://groups.google.com/groups?q=macro+access+export+mysqlhl=enlr=ie=UTF-8oe=UTF-8selm=tchs8rl5phqib7%40corp.supernews.comrnum=3
It's a little long to post here. It
It looks as though, when I go into my databases, and use the command
SHOW TABLE STATUS, that InnoDB tables do not have some information.
I am on MySQL 4.1.0-alpha-debug. Has this been fixed in later versions?
Example:
mysql show table status;
Found that function right after I posted. Thanks, it should do exactly
what I need.
Roger Baklund wrote:
* Scott Plumlee
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions to
Try SQLyog - www.webyog.com
I use the ODBC Import Facility regularly.
regards
Karam
--- Arjun Subramanian [EMAIL PROTECTED] wrote:
Hello people ! I was hoping for some wisdom from the
good folks on this
list about moving databases from access to MySQL.
I am aware of the brute force method
Hi *,
Can somebody show me how to sum for time, my format is hh:mm:ss, need to do
sum for the time as we usually sum a field with integer type. But I am not
sure sum can use for time format.
Thanks in advance
~Elle~
Arjun
The free DBTools DBManager can import Access databases directly to MySQL :
http://www.dbtools.com.br/EN/dbmanagerpro.php
Freddie
-Ursprüngliche Nachricht-
Von: Arjun Subramanian [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 19. März 2004 02:56
An: [EMAIL PROTECTED]
Betreff:
Hi,
Hello people ! I was hoping for some wisdom from the good folks on this
list about moving databases from access to MySQL.
I am aware of the brute force method of exporting in CSV format or tab
delimited formats and using mysqlimport to move the tables.
1. I was wondering if there was a
Excuse me for late response.
When I do it from the mysql prompt it works fine but trough the API (I use
DAC for MySQL from microolap, maybe the bug is in there software!!) it
doesn't work fine.
I have try it on several versions: 4.1.1, 5.0.0 and 4.0.0.
Thank you for your help. If you think
*Dear Friends!*
Can someone shed some light on how SQL injection attack occurs when
*magic_quotes_gpc *isON and how it prevents when its OFF. To my
understanding apostrophise are escaped automatically in POST/GET/COOKIE
when its ON, so how it tends towards SQL Injection.
Someone suggested
70 matches
Mail list logo