Hi all,
I am trying to compile mysql-3.23.49 on OpenBSD 3.1-stable
with pth lib. Note: since OpenBSD 3.1 mysql is compiling
with native OpenBSD threads. And I found it is very unstable.
I meant ports collection.
I am running mysql with pth lib on OpenBSd 2.9 without problems.
Once I get mysql
MySQL Bothway Replication - Fail Back - Hold Master while Slave is
Synchronizing.
I have the following question:
Is it possible to have a slave on machine M1 synchronizing with a master
on another machine M2 while the master on the first machine M1 does not
accept requests yet (i.e. it is not
When will testing be finished of compiling mysql with gcc 3?
--
Roos IT webmail
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Benjamin, thanks for the answer!
There are at least two reasons to have such a common table shared between
databases, and having it explicitly appear as a regular table in each of the
DBs:
1. to make such a table accessible for users, which suppose to live entirely
in their DBs.
2. to make such
Hi,
MySQL is creating about 50% of temp tables on disk and this is with 10Meg of
temp table cache. Is this normal? and sould I up temp table cache further.
Below is the output from SHOW STATUS
Cheers
John Wards
SportNetwork.net
Var Name Value
Aborted_clients 19559
Hi, Sergey!
As stated in description:
A MERGE table is a collection of identical MyISAM tables that can be used as
one. , i.e. content of these tables, being merged, is merged also. I need the
opposite - one physical table being represented in multiple DBs as if these
replicas are regular
Hi!
Benjamin == Benjamin Pflugmann [EMAIL PROTECTED] writes:
cut
Benjamin How-to-repeat:
shell cat /tmp/in EOF
Benjamin 1
Benjamin 2
Benjamin \N
Benjamin \N
Benjamin 10
Benjamin \N
Benjamin EOF
shell chmod a+r /tmp/in
mysql CREATE TABLE ntest2 ( a INT UNSIGNED NOT NULL AUTO_INCREMENT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 20 August 2002 10:33, Marc Roos wrote:
When will testing be finished of compiling mysql with gcc 3?
We already successfully compiled MySQL with gcc 3.1 and have just started some
tests with gcc 3.2 - so far it looks good...
Bye,
Hi All, i've sent a letter to [EMAIL PROTECTED] but until now it still no answer.
Actually it's an active email address or not ?
Please give me better suggestion, because i love this MySQL products and i want to
make a partnership with them
Hi,
I wonder if there is a utility for transferring Paradox tables to MySQL.
Nickos
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi!
On Aug 20, Dmitry Kuznetsov wrote:
Hi, Sergey!
As stated in description:
A MERGE table is a collection of identical MyISAM tables that can be used as
one. , i.e. content of these tables, being merged, is merged also. I need the
opposite - one physical table being represented in
Hi... I've got the folowing question, our servers are running pretty
busy these days and our main DB server is taking high load peaks (memory
is OK but the cpu has almost no idle time). We have another spare server
and I'm thinking about mounting the database over NFS (100mb LAN) to the
spare
hi list
Can I also execute mysql commands from the shell.
Something like this:
% mysql -u root -pmypass --execute=use mydb; select * from mytable;
Thanks..
ilyas
-
Before posting, please check:
IK hi list
IK Can I also execute mysql commands from the shell.
IK Something like this:
IK % mysql -u root -pmypass --execute=use mydb; select * from mytable;
You can do something like this i think :
% mysql -u root -pmypass mydb --execute='select * from mytable'
David
sql, Query
Hark ye experts!
Here I stand an expert grunt.
Trying to understand,
The syntax of constraint.
I was directed to the constraint doc.
And found the constraint doc doth suck.
Here's my ploy, renewed, refined.
Please see if you can help.
To create my Foreign table I used the following
Hello,
I have mysqld-max (3.23.51) running on a Windows 2000 machine. Is it
possible to run another MySQL server alongside it, using the same my.ini
file but set on a different port, e.g. with
mysqld-max --standalone --console --port=3307
The reason I want to do this is to check
* Harald Fuchs
In article [EMAIL PROTECTED],
Victoria Reznichenko [EMAIL PROTECTED] writes:
As you can see txt1 and txt2 contain text file ~ 8M
UPDATE tbl1 SET total=CONCAT(txt1,txt2) WHERE id=1;
SELECT id, LENGTH(txt1), LENGTH(txt2), LENGTH(total) FROM tbl1;
Hello,
I get a nasty segmentation fault as soon as a SQLconnect fails using
unixodbc,
e.g. the isql coming with! The ddd output is quoted below.
Let me tell you how I build the Drivers etc., maybe the
error is related to this.
I used gcc version 2.95.3 20010315 (SuSE), to compile:
Dear Sir,
We are facing a problem related to mysql connections.
The error saying that:-
TOO MANY CONECTONS OPEN:
Mysql server max_connections variable is currently set to 100,
please tell me how i can change the max_connections value.
Thank you,
Mansoor Alam.
On Tuesday 20 August 2002 08:00 am, Jim Bailey wrote:
http://www.mysql.com/doc/en/SEC447.html
RTFM, couldn't be more clear, the columns in both master and slave which are
constrained need to be indexed, and yes the FOREIGN KEY and REFERENCES
sections name the INDEXES, not the columns. Its
On Tuesday 20 August 2002 06:39 am, Luis Calero wrote:
NFS locking is ALWAYS problematical. You might have no problems, you might
also be instantly in hell.
Its really hard actually to answer your question. NFS implementations vary
greatly in their quality. In addition it depends on the NICs
On Tuesday 20 August 2002 06:27 am, Sergei Golubchik wrote:
The key quote from the manual is...
All used tables must be in the same database as the MERGE table itself.
which makes sense. Fundamentally a database is an independent unit of data
storage. You can't share data between two seperate
This is an interesting idea. I would be a happy man if it would actually
work. My experiences with NFS would lead me to believe that this would not
help and could hurt the performance of existing MySQL server even more. My
use has been limited to a file server for our web nodes, so, this is a
Also, what we have done is used a replicating box as a select only server.
This requires you to write your code in such a way that only selects get
sent to the slave. A simple function wrapper in PHP is all we needed.
Brian.
- Original Message -
From: Brian Moon [EMAIL PROTECTED]
To:
On Tuesday 20 August 2002 05:52 am, Nick Lazidis wrote:
Its relatively straightforward to do it with a perl script.
Just set up an ODBC data source to the Paradox database and install perl DBI
and the DBD::ODBC and DBD::MySQL drivers. Then you can simply read records
from Paradox via ODBC and
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
* Harald Fuchs
In article [EMAIL PROTECTED],
Victoria Reznichenko [EMAIL PROTECTED] writes:
As you can see txt1 and txt2 contain text file ~ 8M
UPDATE tbl1 SET total=CONCAT(txt1,txt2) WHERE id=1;
Isn't that what the MySQL-Replication is for?
Thomas
On Tue, 20 Aug 2002 08:07:24 -0500
Brian Moon [EMAIL PROTECTED] wrote:
This is an interesting idea. I would be a happy man if it would actually
work. My experiences with NFS would lead me to believe that this would not
help and could
Hi Nick,
If you don't mind about the OS, yes there is. DBTools can handle Access,
ODBC, Excel, Paradox, FoxPro, ClipperDBase. You can get it from
http://www.dbtools.com.br.
[]s
Crercio
- Original Message -
From: Nick Lazidis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
On Monday 19 August 2002 09:12 pm, Jocelyn Fournier wrote:
except, leave off the 'f.' on 'f.count(*)'. Remember there is only one count
of records, the count of returned rows from the join, there is no need to
qualify that with a table identifier... (and I think it would be a syntax
error if
Also, what we have done is used a replicating box as a select only server.
This requires you to write your code in such a way that only selects get
sent to the slave. A simple function wrapper in PHP is all we needed.
I've been thinking of this idea too but it's a bit of a problem because
Tod,
thanks for your input,
I cannot find this requirement in my help-file for MySQL 3.23.45. I think, it
appears in MySQL 4
Anyway, in MySQL 4, one can symlink tables, as described in chapter
5.6.1.2 Using Symbolic Links for Tables
Well, well, probably old-fasionated way to acces through DB
Brian,
Monday, August 19, 2002, 11:48:16 PM, you wrote:
BJ I have a SQL statement to create a PostgreSQL table that include a line 'id serial'
BJ This line creates a integer field with a sequence atached to it to create an
autonumber
In MySQL you can use AUTO_INCREMENT:
Randy,
Tuesday, August 20, 2002, 8:51:36 AM, you wrote:
RJ Here is an insert from the innodb reference manual
[skip]
RJ The solution is to perform the SELECT in a locking mode, LOCK IN SHARE MODE.
RJ SELECT * FROM PARENT WHERE NAME = 'Jones' LOCK IN SHARE MODE;
[skip]
RJ This means that if
Mansoor,
Tuesday, August 20, 2002, 4:55:28 PM, you wrote:
MA We are facing a problem related to mysql connections.
MA The error saying that:-
MA TOO MANY CONECTONS OPEN:
MA Mysql server max_connections variable is currently set to 100,
MA please tell me how i can change the max_connections
Randy,
Monday, August 19, 2002, 7:29:43 PM, you wrote:
RJ Thanks for your reply, is it documented somewhere?
That COMMIT and ROLLBACK release locks? Of course, look at:
http://www.mysql.com/doc/en/InnoDB_transaction_model.html
--
For technical support contracts, goto
Magnet,
Monday, August 19, 2002, 11:11:38 PM, you wrote:
M I manage a web server having a lot of http connections, using
M Apache/PHP/MySQL. When there are too many simultaneous connections (so, many
M MySQL requests), MySQL stops working efficiently and makes my load average
M increase a LOT
Hello,
Edit your my.cnf and add the following line in the [mysqld] section:
set-variable = max_connections=500
or set it to anything you need.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
Hi
Not sure if this is simpler or not but..
install MyODBC, set up a Paradox alias for your MySql database
Using Paradox, copy the paradox tables to the MySql database. This converts
all the field types and copies the data over. I am not sure if it will do
memo fields it may depend
hi,
i use delphi, myodbc and mysql(myisam tables)
when i select large query ( approximately 2000 records) then
my program alert BDE Error $000F
, it is memory error ok, but i could not its solutions
-
Before posting, please
Ta,
But is it normal to have Temp table bigger than 10meg? And a lot of them?
Here is my latest data from STATUS
Created_tmp_disk_tables 46598
Created_tmp_tables 87839
Uptime 81773
And I have set tmp_table_cache to 10M
I know I could just up the tmp_table_size but I am more concerned about
We use a class for all our MySQL stuff that has some error stuff and
commonly used function combinations (like do a query then do a numrows). In
that we create a connection only when the query method is called. So, until
a query is run, no connection is made. If the update server name does not
* Luc Foisy
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
* Harald Fuchs
In article [EMAIL PROTECTED],
Victoria Reznichenko [EMAIL PROTECTED] writes:
As you can see txt1 and txt2 contain text file ~ 8M
UPDATE tbl1 SET total=CONCAT(txt1,txt2)
Actually... Jay Greenspan's MYSQL Weekend Crash Course is a very quick read
and has NT instructions in it.
It is limited in its functionality, but if you are used to MS SQL Enterprise
Manager, MyCC will be a quick learn for you. The Windows version installs
quickly and work reasonably well.
Ady,
Tuesday, August 20, 2002, 12:11:03 PM, you wrote:
AW Hi All, i've sent a letter to [EMAIL PROTECTED] but until now it still no answer.
AW Actually it's an active email address or not ?
AW Please give me better suggestion, because i love this MySQL products and i want to
make a
I created 4096M raw InnoDB space
-- all was fine. Right after this
I tried to create some type=InnoDB
table. It fails with the message
can't create table './db/tbl.frm'
(errno=133).
After I change newraw to raw in my.cnf
and restart MySQL it works fine.
Not a big problem for me but maybe it
Hi, all
I need help on this.
I'm testing mysql.
I did a very simple table and I'm writing a C++ application to read data
from it.
The connection/authentication/query part of the application seems to work
fine.
However, the text data I'm getting from the database seems encrypted by some
simple
in a innodb table type using mysql max
is a begin statement the same as set autocommitt = 0??
Randy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Heh...ya I knew I fogot to do something. You would think that would be an
install step.
Next task is recompilling the apache httpd as it doesnt like not having
the libmysqlcleint.so.10 file which is now libmysqlcleint.so.11
thx for the tip. =D
-Nick
louie miranda said:
Add the mysql lib path
is a begin statement the same as set autocommitt = 0??
Nope, I didn't change autocommit.
Yuri.
FOR FILTER: sql, connect
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Filter fodder: mysql, query
Hi,
I think the O'Reilly books
- Managing and Using MySQL
- MySQL and mSQL
and _very_ good.
and if you want a real tome, then try
- Mastering SQL, by Martin Gruber, pub. by SYBEX
Donna
On Tuesday 20 August 2002 3:40 pm, John Gruber wrote:
Actually... Jay
hello
i have just insalled mysql++ API and I am trying to run Example Program
I am gettin error : undefined reference to MysqlConnection::~MysqlConnection(void)
-I am a newbie in C stuff particularly on linux platform,please help me to solve this
problem
I am using Redhat7,2 and gcc version
Hello,
I have two machines that I am trying to use replication on. Here are their
configurations:
master (my.cnf)
log-bin
serveri-d = 1
slave:
server-id = 2
master-host=master.domain.com
master-user=replicate
master-password=replicatedb
log-bin
I followed the steps in the manual but
I am new to this group. I am part of a small website dev shop and we just started
using MySQL. I was tasked with the following:
Write a perl script(did this part) to open up the MySQL database and create a View (a
temp table) from 3 different tables. I thought no problem I know how to do this I
in a innodb table type using mysql max
is a begin statement the same as set autocommitt = 0??
Randy
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
You are displaying your strings in hexadecimal format.
Sergio Barbosa Villas-Boas wrote:
Hi, all
I need help on this.
I'm testing mysql.
I did a very simple table and I'm writing a C++ application to read data
from it.
The connection/authentication/query part of the application seems to work
I have a simple query that I must have framed incorrectly, because MySQL
returns an error:
SELECT c.customerID,CONCAT(...) as Cust FROM customers c,invoice i WHERE
c.customerID = i.customerID ORDER BY COUNT(i.customerID) LIMIT 0,10;
This tells me ERROR : Invalid use of group function
How
Hi,
I have completed a web-based application using java
servlet with mysql as the backend database and tomcat
as the server. I try to test my application
performance using a free test tool. i found one called
Microsoft Web Application Stress tool) it is free. but
it's test script is used by AsP.
Do you need to create a temp table or a heap table? Temp tables support
those columns fine. Heap tables do not.
Brian.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 11:44 AM
Subject: MySQL and creating views..
| I am new to
Froilan Mendoza wrote:
Hello,
I have two machines that I am trying to use replication on. Here are their
configurations:
master (my.cnf)
log-bin
serveri-d = 1
slave:
server-id = 2
master-host=master.domain.com
master-user=replicate
master-password=replicatedb
log-bin
I
SELECT c.customerID,CONCAT(...) ,COUNT(i.customerID) as Num
FROM customers c,invoice i WHERE c.customerID = i.customerID GROUP BY
c.customerID ORDER BY Num DESC LIMIT 0,10 ;
Sorry, solved my own difficulty.
On Tue, 20 Aug 2002, Quinten Steenhuis wrote:
Date: Tue, 20 Aug 2002 13:01:17 -0400
I am confused. (innodb table type)
Client 1.
starts transaction
selects balance from table where id=1 for update
update table set balance=100
#At this point from what i have read the balance could be selected by anther
user.
committ
I have read that a select balance from table where id=1
Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE
What I want to know is can I do the following:
create temporary table (select [distinct] jump.name, jump.address,
bike.city, bike.state, skate.zipcode, skate.car, skate.name, skate.city
from jump, bike inner join
That should work just fine.
Brian.
- Original Message -
From: [EMAIL PROTECTED]
To: Brian Moon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 12:51 PM
Subject: Re: MySQL and creating views..
| Thanks Brian. But another question is, I looked up CREATE TEMPORARY
Oh, but the caveat for this is that the table will be destoyed when the
connection is closed. So, if you need this to hang around, you will just
need to create another table with this data, or just use that join in your
query.
Brian.
- Original Message -
From: [EMAIL PROTECTED]
To:
Is it fixed only in MySQL 4.x, or will it be in the next point
release of 3.x as well?
Cheers,
Rich
-Original Message-
Thanks for bug report!
If NULL is present (t_calllog_calls.call_end -
t_calllog_calls.call_start 5) the result_type is changed from
int to char.
It was fixed.
Through your MySQL documentation, I wasn't able to find a function that I
think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field,
it will still be able to add the next highest value to this column on an
INSERT (ex. If after INSERTing rows, you DELETE a row with a value of
Hi.
On Tue 2002-08-20 at 10:58:53 +0200, [EMAIL PROTECTED] wrote:
As stated in description:
A MERGE table is a collection of identical MyISAM tables that can be used as
one. , i.e. content of these tables, being merged, is merged also. I need the
opposite - one physical table being
I am trying to install MYSQL on Solaris 9 sparc edition. I am using the
following options:
CFLAGS=-O3 -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc
CXXFLAGS=-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptio
ns -fno-rtti
./configure --prefix=/usr/local/mysql
Hello.
On Tue 2002-08-20 at 13:18:04 -0500, [EMAIL PROTECTED] wrote:
Through your MySQL documentation, I wasn't able to find a function that I
think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field,
it will still be able to add the next highest value to this column on an
Sql, query
Hi,
I have a field that I need to do a join on. Unfortunately, the column is
allowed to be null (and it should be). My plan is to return the literal
string 'None' if the column is null, and otherwise to return the joined
value. How can I do this, when the inner join that I want
It used to do what you are saying. That was very bad. For example, we
stored click data for articles. Whe the articles were archived for speed
reasons, MySQL started filling in the holes. When we got back around to
archiving those rows, we could not do so as the archive table already had
rows
On Tuesday 20 August 2002 01:06 pm, bin cai wrote:
check out www.owasp.org, there are some good links there for various tools,
mostly for correctness and security testing, but it should give you some good
starting points. Check out www.freshmeat.net as well, I am pretty sure some
stuff has
Hi all,
I will appreciate if someone could give me some advice.
I am going to make a 6.5 mill. phone directory database, and after some
previous advice I am able to make a search in a fraction of a second.
However there should only be a single search line, not different fields for
First, Last -
On Tuesday 20 August 2002 01:26 pm, Randy Johnson wrote:
I am confused. (innodb table type)
I'm really not so sure about the 'lock in share mode' thing, but to the best
of my knowledge if you do a
SET TRANSACTION_ISOLATION_LEVEL=SERIALIZABLE
and then start a transaction where you read data
you grab the balance , manipulate it by adding or subtracting an amount then
updating it.
Randy
- Original Message -
From: Tod Harter [EMAIL PROTECTED]
To: bin cai [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 3:35 PM
Subject: Re: web application test tool
On
I get the following error when loading the mysql.h header file.
[C++ Error] mysql_com.h(118): E2303 Type name expected
[C++ Error] mysql_com.h(118): E2139 Declaration missing ;
The error is occuring in teh mysql_com.h header file when the my_socket data member in
the structure st_net.
Frank
I have a web based ad hoc query builder I built for running against SQL
Server databases.
I am trying to port it to mysql. I need a way to return table info through
a query. Is
there a way to return syscolumns type info in standard column and row
format?
__
Lon
Quinten Steenhuis wrote:
Sql, query
Hi,
I have a field that I need to do a join on. Unfortunately, the column is
allowed to be null (and it should be). My plan is to return the literal
string 'None' if the column is null, and otherwise to return the joined
value. How can I do this,
Hi!
Like the manual states, CREATE TABLE, INSERT etc. database operations are
blocked when 'newraw' is specified. That is a safety measure. You must not
forget 'newraw' to my.cnf, as that will wipe over the partition at the next
startup.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB -
Hello,
I am having troubles with Load Data Infile and cannot figure out the problem.
I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So
when I import I only get '-00-00' rather than the date. How can I tell MySQL what
the format is?
I
I need to know if there is a way to do a simple insert from a .txt file, using insert
and only populate one column. Its a streamline db and I want to enter only a few of
the columns.
I have exported all data into txt files at this point. I can not find any mention on
mysql's site other than
Hello Serge,
I am having troubles with Load Data Infile and cannot figure out the
problem. I have a date field but the format is 'Jan 1 1986' rather than
mysql's default. So when I import I only get '-00-00' rather than the
date. How can I tell MySQL what the format is?
I have read
This is the only option? That's not a very automated process and I must import this
data once a day. I also will not be able to get them to reformate their data since
I'm only one of many many people downloading everyday. Is their no way for load data
to do this automaticaly?
Serge.
On
Hi,
Maybe can be useful.MySQL suport and UDF.
But you can solve this problem in the next way:
@a:=0;-initialize variable a
select @a:MAX(YOUR_COLUMN_FROM TABLE) from YOUR_TABLE;
select @a:=@a+1;
insert into YOUR_TABLE SET YOUR_COLUMN_FROM TABLE= @a,bla,bla...;
Regards,
Gelu
On Tue, Aug 20, 2002 at 04:03:03PM -0400, Lon Lentz wrote:
I have a web based ad hoc query builder I built for running
against SQL Server databases. I am trying to port it to mysql. I
need a way to return table info through a query. Is there a way to
return syscolumns type info in
Joseph,
I need to know if there is a way to do a simple insert from a .txt file,
using insert and only populate one column. Its a streamline db and I want to
enter only a few of the columns.
I have exported all data into txt files at this point. I can not find any
mention on mysql's site
On Tue, Aug 20, 2002 at 04:40:25PM -0400, Serge Paquin wrote:
This is the only option? That's not a very automated
process and I must import this data once a day. I also will
not be able to get them to reformate their data since I'm
only one of many many people downloading everyday. Is their
Walt,
At 01:09 PM 8/20/2002 -0400, walt wrote:
on the slave you should run
show slave status
on slave:
mysql show slave status;
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
Date: Tue, 20 Aug 2002 16:50:39 -0400
To: [EMAIL PROTECTED]
Subject: Re: insert command
On 21 Aug 2002, at 4:27, Joseph Grundy wrote:
I need to know if there is a way to do a simple insert from a .txt
file, using insert
Serge Paquin wrote:
This is the only option? That's not a very automated process and I must import this
data once a day. I also will not be able to get them to reformate their data since
I'm only one of many many people downloading everyday. Is their no way for load data
to do this
Serge,
Why didn't you give this information/constraint in the first place? Why now
complain that it is not a very automated solution? Why narrow your mind to
assume that the problem is with MySQL?
Them are going to be a problem to many of their 'clients' then, because
CCYY-MM-DD is the
What I need to obtain is the table information. Column names, type,
length, etc. Someone suggested using the EXPLAIN or DESCRIBE commands, but
ColdFusion is not returning it as a valid queryset. Are the result sets of
these commands ODBCable? I am using MyODBC on Linux.
-Original
- Original Message -
From: DL Neil [EMAIL PROTECTED]
Date: Tue, 20 Aug 2002 21:51:24 +0100
To: Joseph Grundy [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: insert command
Joseph,
I need to know if there is a way to do a simple insert from a .txt file,
using insert and only
I am new to MySQL and PHP.
Having looked at PHPMyAdmin the GUI I was wondering if it's possible to
create a new database within the system?
If so what are the commands? I ask because I only have one database on my
server and don't want to populate it with different tables, I'd rather have
Do you have phpMyAdmin running yet? If so you create new databases with the
click of a button. The first page you see should say Welcome to phpMyAdmin
...ver etc. If you have set phpMyAdmin to run on an existing MySQL install,
the drop down boxes should contain your existing databases if
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
Date: Tue, 20 Aug 2002 16:50:39 -0400
To: [EMAIL PROTECTED]
Subject: Re: insert command
On 21 Aug 2002, at 4:27, Joseph Grundy wrote:
I need to know if there is a way to do a simple insert from a .txt
file, using insert
- Original Message -
From: DL Neil [EMAIL PROTECTED]
Date: Tue, 20 Aug 2002 21:51:24 +0100
To: Joseph Grundy [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: insert command
Joseph,
I need to know if there is a way to do a simple insert from a
.txt file,
using insert and only
On Tuesday 20 August 2002 09:02 pm, Froilan Mendoza wrote:
Walt,
At 01:09 PM 8/20/2002 -0400, walt wrote:
on the slave you should run
show slave status
on slave:
mysql show slave status;
+-+-+-+---+
On 21 Aug 2002, at 5:01, Joseph Grundy wrote:
Example I have a table created lets say prices, in table prices
there are 15 columns named 1 through 15. I want to be able to
populate one column say 8 with data I exported from a column
in a different database, using the txt file.
So you have
I would use some sort of scripting language (PHP for
example) to format the date, and have that script
import the data into your table, rather than using
LOAD DATA INFILE.
If you post a sample of how your data file is
formatted, someone will gladly help you out. You might
want to post this to
1 - 100 of 114 matches
Mail list logo