Hi !!
You could maybe buffer the data in Your application
and then run inserts later... like this.
struct oneRow{
double timestamp;
double data;
etc, etc
}
struct oneRow rows[num_of_rows];
for (int i = 1; i num_of_rows; i++)
{
// collect data
rows[i].timestamp = (double) i;
Hi,
I'm developing a web application using mysqld as a localhost but
accessed from anywhere. My problem is simple, after entering form
data, and execute the php script, always returns an error I wrote in
case of unsuccesful connection to the db.
I did everything , create a user with many
Hi All
Is there any function in mysql which acts similar like decode() in Oracle..
The decode function acts like a procedural case statement inside a single
SQL statment to return different values or columns based on the the values
of other columns in the select statement.
It is extremely
Have a look below:
--
If expr1 is TRUE (expr1 0 and expr1 NULL) then IF() returns expr2,
else it returns expr3. IF() returns a numeric or string value, depending on
the context in which it is used:
mysql select IF(12,2,3);
- 3
mysql select IF(12,'yes','no');
-
Type this line of code before your line
$db = mysql_pconnect(localhost, testdb, test123) or
die(mysql_error());
The error u get will be pretty descriptive.
If not revert back to me.
nev L.
-Original Message-
From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]]
@ $db =
Hi.
I need help with InnoDB configuration.
- The machine is a 2 Pentium III 1000GHz, Memory 1G, 30GB SCSSI.
- The operating system is FreeBSD 4.5.
- The mysql server is 3.23.49 (using FreeBSD port).
I read carefully section InnoDB in MySQL manual and set the innodb
parameters as:
#
Hi,
I've seen this question asked before, but I'm hoping maybe this is now
possible.
When one does a LOAD DATA INFILE... or similar and get a result
like this:
Query OK, 428 rows affected (4.30 sec)
Records: 428 Deleted: 0 Skipped: 0 Warnings: 431
...is there any possible way to see the
Hello!
Can anyone help me in this situation -
S1: One MySQL on FreeBSD with direct connection to internet;
S2: One MySQL on FreeBSD without direct connection (just intranet);
I can't connect to S2 from non-intranet but I can connect to S1.
What I need is to synchronize S1 and S2 realtime or, at
Hi,
Within MySql if you have a large amount of data of the same format and also
know that there are distinct groups within this data which you need to run
many comprehensive searches against; is it better to have a well indexed
large table or many small tables / databases for each distinct group
There are two ways to do this.
One open a hole in the firewall.
Two put a second Ethernet card in each system and use this for BIN updates.
Simon
-Original Message-
From: Agris [mailto:[EMAIL PROTECTED]]
Sent: 31 May 2002 09:17
To: [EMAIL PROTECTED]
Subject: Mirroring / synchronizing
Hello People,
I was just designing my database and I was planning to finally use the new
feature provided by InnoDB : ON DELETE CASCADE
So I tried the example :
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT,
First way is unacceptable, for sure.
Second, hmz. Still not what i need. The deeper problem is:
I want to put and to get data to that S2 from outside LAN (using Windows
application).
Besides, both servers must be active all the time.
Ok, thanks for help. It seems i have to code some tool to do
Sorry If this is the wrong list for this topic, I hope someone can shed some
light onto my problem.
I am building a php/ Mysql web site for a client which is a picture gallery.
The web site has 3 frames (required by the designer so that the whole thing
doesnt refresh all the time).
Frame 1-
Hello,
I am quite new to the world of databases, but need to know if I can
implement an e-learning solution using Mysql database and PHP. What then
happens to the LMS Accorn standard if I need to track my students' progress.
Please advise.
Olusola
show index from gwarp;
mysql
+---+++--+-+---+
-+--++-+
- | Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Comment |
-
(been trying to answer this question for a long time; a recent post on the
topic has convinced me to admit defeat and ask the list...)
I have a large database and would like to output 'results' page by page.
'Results' refers to fairly general database computations, including groups,
joins,
Depending on your available RAM length of your sampling runs, you
could write records to heap (in-memory) tables -
http://www.mysql.com/doc/H/E/HEAP.html
- and then dump those to disk after the sample was done. You might
even be able to use heap tables as a buffer with one process
Dear List,
since i am working on a project that uses extensively full text search i
have to find a source distribution of 4.0.2 source code which has some very
important features and bug fixes respect to 4.0.1 and try to compile it
with different charset e.t.c.
Unfortunately i don't have any
Hi, all
I am using mysql - 3.23.46, Intel, Solaris 8
Some questions:
1) Why cardinality value don't automaticly change when query change set of
unique values in index ( insert or update ) ?
Example:
mysql create table a ( a int not null, index ( a ) );
Query OK, 0 rows affected (0.02 sec)
hello,
i have major problem with setting up replication.
both ends are running mysql 3.23.49
i have set up proper entries in my.cnf on both sides and
have replicated the dbs.
now,
on master:
show master status reads:
++--+--+--+
| File
Hi there,
I am just trying to configure my root server. The provider has preinstalled
mysql on suse72. So I did try to get rid of this installation with yast, but
this did not work out. After compiling php,apache and mysql, PHP is still
trying to connect to the old server. The new server is
Hello,
You could maybe buffer the data in Your application
and then run inserts later... like this.
This is not a solution for me as the data acquisition can take hours without
any break.
I might be missunderstanding You since I don't get this together...
You wrote:
The following C++
im missing the mysql and mysqladmin binaries after my admin guy installed
the most recent stable mysql rpm on a (linux) machine. are these included in
the client rpm that he may have missed or is there something new that i
missed?
Luke
More than likely you have missed the step that the slave database has to be
the exact one that the master has before the start of the binlog. Shutdown
both servers, grab a copy of the master's data directory and tar that up,
move that to the slave, delete the slave's current data directory, now
Charles,
Friday, May 31, 2002, 10:55:20 AM, you wrote:
CS I've seen this question asked before, but I'm hoping maybe this is now
CS possible.
CS When one does a LOAD DATA INFILE... or similar and get a result
CS like this:
CS Query OK, 428 rows affected (4.30 sec)
CS Records: 428 Deleted: 0
kmlau,
Friday, May 31, 2002, 1:18:26 PM, you wrote:
k show index from gwarp;
k mysql
k +---+++--+-+---+
k -+--++-+
k - | Table | Non_unique | Key_name | Seq_in_index | Column_name |
k Collation
Chris,
Friday, May 31, 2002, 4:51:37 AM, you wrote:
CG Somewhat new to the list (and very new to mySQL), so thanks for you help
CG in advance. I installed RedHat 7.1 (Seawolf) on a PC, and it came with
CG mysql 3.23.36. I logged in as a regular admin user and typed mysql to
CG get started...
On Fri, 2002-05-31 at 20:54, Cesar Mello - Axi wrote:
Hello,
You could maybe buffer the data in Your application
and then run inserts later... like this.
This is not a solution for me as the data acquisition can take hours without
any break.
Whatever you do, with any SQL you get stuck
I have data on CD ROM for the Marine Casualty and Pollution Database,
comprised of fourty data tables, a data dictionary and a readme file. I
would like to access the data using mysql, which I have on my Mandrake 8.1
linux box. The readme file says ... Analysis of data is conducted at Coast
[snip]
The readme file says ... Analysis of data is conducted at Coast
Guard Headquarters using a 4GL Relational Database Management System.
[/snip]
Which 4GL Relational Database Management System? It may use a proprietary
file type for which you may have to have that database's engine to export
Hi All
How do i use RowId 's in MYSQL..
Can anyone throw some light on it
Regards,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi all,
How is the best tool for acess Mysql By SSL protocol ?
---
Marcel P. Tardelli
DBA - DBLive Corp.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-
Before posting, please check:
Which 4GL Relational Database Management System are they talking about?
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Phil Reardon [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 7:57 AM
To: [EMAIL PROTECTED]
Subject: newbie question
I have data on CD ROM for the
[snip]
The readme file says ... Analysis of data is conducted at Coast
Guard Headquarters using a 4GL Relational Database Management System.
[/snip]
Which 4GL Relational Database Management System? It may use a
proprietary
file type for which you may have to have that database's engine to
Hello all... please read
I've struggled with this for YEARS
-
THE PROBLEM:
-
MySQL alone cannot represent a complex data-structure.
Re-modeling of MySQL data is required in Perl,
Dear List,
since i am working on a project that uses extensively full text search i
have to find a source distribution of 4.0.2 source code which has some very
important features and bug fixes respect to 4.0.1 and try to compile it
with different charset e.t.c.
Unfortunately i don't have any
* Arul
Is it possible that i can use 3 tables in a Join Query..
Assuming that i have 3 tables
Sure!
artist table contains artistid , artistname
cd table contains cdid,artistid , Filmname
artistaddress table contains artistid , City , phone no
[...]
If i execute this query i get only 3
On Fri, 2002-05-31 at 17:52, Marcel wrote:
Hi all,
How is the best tool for acess Mysql By SSL protocol ?
What do you need to do? MySQL C API has all neccessary stuff to use SSL
and mysql command line tool can use it from 4.0.x versions.
Tònu
I've been trying to find it too. Haven't had any luck yet...
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 9:06 AM
To: [EMAIL PROTECTED]
Subject: Trying to find source Tarball for 4.0.2
Dear List,
Does MySQL have any facility for using SSH to tunnel ports for use in
replication? Has anyone implemented anything like this?
We can't just assume if we create an SSH tunnel manually that the
connection will stay up.
Thanks,
Mark R. Andrachek, Jr.
Analyst I
Federal Reserve Bank of Richmond
On Fri, May 31, 2002 at 10:01:34AM -0500, Ryan Hatch wrote:
-
THE PROBLEM:
-
MySQL alone cannot represent a complex data-structure.
Re-modeling of MySQL data is required in
Thanx Lewis..It worked
- Original Message -
From: Neville Lewis [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 12:34 PM
Subject: RE: Alternative to decode() in Oracle
Have a look below:
--
If expr1 is TRUE (expr1 0 and expr1 NULL) then
I can¹t seem to make any of the describe or show queries work when I apply a
search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like user_access;
Does no work.
Thank You
I can¹t seem to make any of the describe or show queries work when I apply a
search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like user_access;
Does no work.
Thank You
I'm compiling on Tru64 ver 5.1 using GNU 3.1 and make 3.79. I am receiving
the following error:
Any help will be appreciated.
Dean
inition
In file included from ../include/my_sys.h:35,
from mysys_priv.h:19,
from my_pthread.c:20:
is there a place to get the manual that is split a bit more then the current
manual_split.
these are the 2 pages i end up reading the most
even though its usually for just the grant, create, insert syntax (human in
need of memory upgrade)
416k Sep 26 2001
[snip a lot...]
MySQL alone cannot represent a complex data-structure.
[/snip]
Incorrect, and if it IS the case (from your POV) then no RDBMS can represent
a complex data structure.
[snip]
Re-modeling of MySQL data is required in Perl, PHP, Java, etc.
In each language - I have had to re-model
You can create another frame that's invisible by having a zero height or
width. This can be your page that does all the queries and refreshes.
You can then use the javascript command document.write() to update the other
frames without having to hit the server again. Or, retrieve the data in the
Hi Mark,
At 11:14 5/31/2002 -0400, [EMAIL PROTECTED] wrote:
Does MySQL have any facility for using SSH to tunnel ports for use in
replication? Has anyone implemented anything like this?
We can't just assume if we create an SSH tunnel manually that the
connection will stay up.
There was an
If HEAP table won't do because of memory constraints, why not use straight
flat files like typical Unix or Web logs? Start a new file at set intervals,
whether it be time intervals or record intervals. Then you can use the
LOAD DATA command to load the files.
Your situation seems similar to that
Hi all,
I just wonder. I have tried this example from www.mysql.org Doc.
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE
Hello!
I am a newbie, to group and MySQL.
I just downloaded MySQL for win 2000.
The zip file, when opened and clicked on install,
it created c:\mysql directory and did the install.
Now what next?
DOnt I have to start the server?
How do I create instances?
How do I get into the dbadmin to
I'm getting an error -incorrect column specifier
using MySQL 3.23.37 on SuSe 7.2
This line -
building_idx decimal(8,0) unsigned zerofill DEFAULT '' not null
auto_increment
-is in a supplied perl script and causes the error message.
I acknowledge this is just one line from a fairly long
Richard,
Say, that's really good!
I'm still not used to taking advantage of those variables. Clever.
Also, I think you can remove all but the rows showing gaps by adding a group
by and having clause...
select id,@b:=IF(id=@a+1,id,concat(@a+1,..,id-1)) range,@a:=id,
@flag:=IF(@b=id,id,MISSING)
Hey guys,
i'm still doing this web ODBC thing, and i was wondering since, all the
wqueries i'm going to use are in a database, is there a way (using
php/mysql/odbc) to access and call on those queries without typing them over
in my php script?
So basically i just want to connect to queries.mdb
Does anyone know where I can get help writing an MySQL update statement that
contains a join in the where clause?
Thank you.
All the best,
Joe
Joseph W. Cherner, President
SmokeFree Educational Services, Inc.
http://www.smokefree.org
Never doubt that a small group of thoughtful citizens can
Most of what you desire has already been done in products called FileMaker
(Apple Computer) and Access (Microsoft). It's been a while since I used
Access, but FileMaker will automatically change all references to a
field/column if you change the field name. It will warn you of broken
references
Hello.
On Fri, May 31, 2002 at 02:08:57AM +0100, [EMAIL PROTECTED] wrote:
[...]
BP So you may consider upgrading and check if you find the problems
BP still reproducable.
[...]
I generally only update on a needs basis, most notably for security,
as I like to keep things stable and
On Fri, May 31, 2002 at 06:06:02PM +0300, Nikolaos Georgiafentis wrote:
SO if anybody could point me a place where i can download the whole
4.0.2 code in .tgz format it will be a HUGE help for me.
Follow the instructions here:
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Hi.
On Fri, May 31, 2002 at 03:24:52PM +0200, [EMAIL PROTECTED] wrote:
Cesar, you really should consider using placeholders and bind_param (if
available). Without using placeholders, the insert statement will contain
the literal values to be inserted and has to be re-prepared and re-executed
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Mark [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 8:42 PM
Subject: Re: I need 50.000 inserts / second
The general idea is correct, but note that MySQL does not support
this (yet)...
Really?
In the last episode (May 31), Mark said:
Cesar, you really should consider using placeholders and bind_param
(if available). Without using placeholders, the insert statement will
contain the literal values to be inserted and has to be re-prepared
and re-executed for each row. With
Melvyn Sopacua wrote:
-
Does MySQL have any facility for using SSH to tunnel ports for use in
replication? Has anyone implemented anything like this?
We can't just assume if we create an SSH tunnel manually that the
connection will stay up.
There was an excellent piece in August
Hi Jeremy,
I've done some tests grouping the INSERTs in groups of 1000 and 1, and
it got very faster, in my Pentium III 700 from job I could get less than 3s.
But I'm still doing concatenation to get the INSERT clause in the form
values (x,x), (x,x) Is there a way to make a template
Hi all,
It seems that some is misunderstanding my problem, so i try to re-write my problem
again.
I just wonder. I have tried this example from www.mysql.org Doc.
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind
Hi.
As 4.0.2 is not released yet, there is not tarball of it. Bitkeeper is
the only method to retrieve a version of the current 4.0.2 tree.
You do not have to have much experience with Bitkeeper to get a
working tree. A step by step explaination can be found in the manual:
Hi.
I am not sure, but I guess that AUTO_INCREMENT is not allowed for DECIMAL.
Bye,
Benjamin.
On Fri, May 31, 2002 at 11:56:36AM -0500, [EMAIL PROTECTED] wrote:
I'm getting an error -incorrect column specifier
using MySQL 3.23.37 on SuSe 7.2
This line -
building_idx decimal(8,0)
Hi.
On Fri, May 31, 2002 at 01:26:34PM -0400, [EMAIL PROTECTED] wrote:
Hey guys,
i'm still doing this web ODBC thing, and i was wondering since, all the
wqueries i'm going to use are in a database, is there a way (using
php/mysql/odbc) to access and call on those queries without typing them
Jeremy,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 8:43 PM
Subject: Re: innodb rollbacks
On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote:
However, if there are lots
Hi.
On Fri, May 31, 2002 at 11:39:12AM -0500, [EMAIL PROTECTED] wrote:
Does anyone know where I can get help writing an MySQL update statement that
contains a join in the where clause?
Multi-table updates are not supported (yet) by MySQL.
You have to construct the updates on the application
On 31 May 2002, at 11:56, T. Dahms wrote:
This line -
building_idx decimal(8,0) unsigned zerofill DEFAULT '' not
null auto_increment -is in a supplied perl script and causes the
error message.
An AUTO_INCREMENT column has to be an integer (see
MySQL wrote:
Hi all,
It seems that some is misunderstanding my problem, so i try to re-write my problem
again.
I just wonder. I have tried this example from www.mysql.org Doc.
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT,
I currently am a MySQL dba and am having issues from a security/linux
administrator that doesn't want me to have access to the /etc/my.cnf.
What can't I do with local database .cnf files that I can only do with
my.cnf?
Any ideas? I have looked at the documentation and it doesn't really say
In the last episode (May 31), [EMAIL PROTECTED] said:
I currently am a MySQL dba and am having issues from a security/linux
administrator that doesn't want me to have access to the /etc/my.cnf.
What can't I do with local database .cnf files that I can only do with
my.cnf?
There are no
MySQL alone cannot represent a complex data-structure.
not true at all, it's just not object oriented but don't you know that
there is still no good (consistent and complete) theoretical model for
OO-DBMS. Relational Model _has_ good underlying theory and I think this
is the main
Frank,
please check with SHOW TABLE STATUS that the tables really are InnoDB type.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
- Original Message
Hi!
Please check that you are using = 3.23.50.
I tested this on Win NT-4.0 with 3.23.52, and it worked:
mysql CREATE TABLE parent(id INT NOT NULL,
- PRIMARY KEY (id)) TYPE=INNODB;
Query OK, 0 rows affected (0.14 sec)
mysql CREATE TABLE child(id INT, parent_id INT,
Hi, I'm trying to make a query to my database based upon an index.
Eg.
we have last name,first name, eyecolour,age
we search for all the records with the last name starting with 'smi'
and I'm browsing forward through the records using mysql_use_result
I get halfway through the last name 'smith'
hi,
I am installing mysql3.23.49. For that, I just installed ncurse
In the ./configure --help, I found this switch --with-named-curses-libs=ARG
what should I put inc the ARG when I do ./configure?
Thanks,
Wei
-
Before
I have a table that includes numerous column names of the form
'%_Dry_Weight' -- that is, they start with a
percent sign. I am unable to query these columns, as mysql returns a
you have an error in your SQL syntax'
message. When I try to escape the % character with a backslash, the
error
Hi,
How do I deal with the import of this file? Every example I see involves a
dump of a single database, or else uses a command line like my subject, but
with no corresponding mysqlimport. If I use mysql dump.txt then I end up
with errors that stop the process. With mysqlimport I can use
Genius. I knew there must be a way of tricking Mysql into applying a having
statement and hence doing the whole query in a non join based statement.
I have found the variable features of mysql most useful for a query of the
type, select the top x rows per group. i.e. a limit per group. This is
In the last episode (May 31), David Adam said:
I have a table that includes numerous column names of the form
'%_Dry_Weight' -- that is, they start with a
percent sign. I am unable to query these columns, as mysql returns a
you have an error in your SQL syntax'
message. When I try to
I am having major troubles creating this query...ok here's some
background info:
I have three tables: members, which contains info about the member, such
as city, state, zip, marital status, etc; interests, which stores just
an interest_id and name; and member_interests, which stores just
As a follow up to my previous question, two possible solutions came to
mind:
1) Query members table for all members matching criteria stored in that
table (country, marital status, income, etc). Then, take all those
member_ids, and query member_interests table for members who match
there. i.e.,
Hrm. Closest I can think of is
EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access';
I think this is what you mean.
Adam Hooper
[EMAIL PROTECTED]
On Fri, 31 May 2002 08:44:49 -0700
marc malacarme [EMAIL PROTECTED] wrote:
I can¹t seem to make any of the describe or show queries work when
Hi All
Is it that i can make a column auto increment only if its data type is
integer.
Can i not set auto increment value for a numeric datatype
-Arul
sql,query
-
Before posting, please check:
87 matches
Mail list logo