* [EMAIL PROTECTED]
> I'm new to MySQL and have tried many attempts myself and looked
> all over for
> this answer to no avail. How do I write MySQL joins to accomodate the
> Oracle equivalent listed belowany help would be appreciated.
>
> From
> iteration,
> story,
> person tracker,
Mark Matthews wrote:
[snip]
On the same page, there's a note about requiring Bison-1.75 or newer to
compile MySQL-4.1 (the same holds true for 5.0 as well). You can check
what version you have by issuing 'bison --version' in your shell.
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software
Luis Lebron wrote:
I have a test results table that looks like this
student_id test_id score
1 1 90
1 1 100
1 1 80
2 1 95
2 1 85
2
I have a test results table that looks like this
student_id test_id score
1 1 90
1 1 100
1 1 80
2 1 95
2 1 85
2 1 75
I'm new to MySQL and have tried many attempts myself and looked all over for
this answer to no avail. How do I write MySQL joins to accomodate the
Oracle equivalent listed belowany help would be appreciated.
From
iteration,
story,
person tracker,
person customer,
person develope
Flavio Tobias wrote:
>>> I need to access a database thru internet. It is secure to do this
>>> using MySql?
>> Sure. If you use a secured connection.
> What do you mean with secure connection, ssh?
> How to configure this on MySql?
I'ld think about SSL
http://www.mysql.com/doc/en/Secure_ba
Fortuno, Adam wrote:
I would suggest a SQL statement like this to get the results you're looking
for.
SELECT COUNT(a.id), a.lname, a.fname
FROM people AS a
GROUP BY a.lname, a.fname
HAVING COUNT(a.id) > 1;
That's a great way of doing it if Grant doesn't need the IDs, which he
*did* have listed in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> I'd be willing to bet if you implement serializable, serialize it and dump
> it to a binary column (blob) .. you should be able to restore...
>
If you use PreparedStatements, Connector/J will do it 'automagically'
for you a
That seems like a lot of work to do when mysql has it built in.
http://www.mysql.com/doc/en/Secure_basics.html
4.3.9.1 Basics
Beginning with version 4.0.0, MySQL has support for SSL encrypted
connections. To understand how MySQL uses SSL, it's necessary to explain
some basic SSL and X509 concept
Hi,
It looks like your slave can't connect to the master you've defined.
Here are the steps you need to follow :
1- On shell type
mysql -h mail.dbi.tju.edu -urepl -pPASSWORD
You need to replace word PASSWORD with your actual password. This will
show you if you can connect to master from yo
We use a point to point VPN between server sites for this... so the
security/encryption is totally transparent to mysql, it's just connecting
to an IP address on tcp/3306 and the vpn appliances down the line deal
with all the data security...
There are cheaper solutions such as using freeswan, s
I'd be willing to bet if you implement serializable, serialize it and dump
it to a binary column (blob) .. you should be able to restore...
On Fri, 29 Aug 2003, Dennis Knol wrote:
> Hello,
>
> Is it possible to store Java objects in the mysql database?
>
> Kind regards,
> Dennis
>
>
> _
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 29 Aug 2003 15:59:18 -0400, Fortuno, Adam wrote:
> I need to access a database thru internet. It is secure to do this using
> MySql?
>
If the database traffic is encrypted, yes. I do not know if that is an option in
Mysql.
If you did not
Can we 'unanalyze' a table? I'd like to remove the statistical
information from my analyzed table, for testing purposes.
Thanks
Kevin
As stated before, it is possible via ssh.
This assumes 2 things:
1: Your client machine is windows
2: Your server is running a ssh server. (Which USUALLY means it's a flavor
of Unix but there are ssh servers for windows...why, I don't know but
there are.)
First, grab putty. Putty is a ssh client
Actually, Secure Shell is built on Secure Socket Layer.
You generally speak of SSL with HTTPS connections.
You can open an SSH session with a remote Unix box (or anything with an sshd running)
then MySQL through that and it's encrypted. You can also create tunnels with SSH, but
I've never done
I think your thinking of SSL.
There is some work for mySQL that allows a sol connection and even some
work to sol the replication over the net.
Look for SSL on mysql.com
-->-Original Message-
-->From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
-->Sent: Friday, August 29, 2003 12:59 PM
-->To
> select value from tableName where date in (select max(date) from
> tableName where id = 4);
>
> But, it doesn't work with mysql 4.0.
>
> Any ideas? Does anybody had this problem before?
What about:
SELECT value, date
FROM tablename
WHERE id = 4
ORDER BY date ASC
Just pick the first row.
Flavio,
Sure. If you wanted to MySQL into a DB over the internet. I'd think ssh'ing
would do the trick. This actually has nothing to do with MySQL, but allot to
do with your OS. If you're running OS X, Linux, or some forms of Unix. SSH
is probably a default package. Follow-up with the documentatio
Hi
I have a "little" problem with my sql skills.
I have a table with the following fields:
id (int) | value (varchar) | date (date)
I need to show for a given id the value of the oldest date.
Normally, I'd do something like this:
select value from tableName where date in (select max(date)
What do you mean with secure connection, ssh?
How to configure this on MySql?
- Original Message -
From: "Fortuno, Adam" <[EMAIL PROTECTED]>
To: "'Flavio Tobias'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 2:17 PM
Subject: RE: It is secure to access MySQL thru i
Grant,
Sure, anything's possible. Assuming you're table looks something like this:
CREATE TABLE people (
id INT NOT NULL,
fname VARCHAR(15) NULL,
lname VARCHAR(20) NULL
) Type=InnoDB;
With data something like this:
INSERT INTO people (id, fname, lname) VALUES (1, 'John', 'Smith');
INSERT I
I am having problems to start MySQL replication. I followed all the
steps outlined on the website, but replicaiton is not working. slave
status shows the following:
mysql> show slave status\G
*** 1. row ***
Master_Host: mail.dbi.tju.edu
sorry got it
Sanya Shaik <[EMAIL PROTECTED]> wrote:I have the mysql dump for only 1 table from a
database and i want to populate only that table back into the database.
how do i do that ?
-
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
-
I'm trying to get a query to work by listing all the people in a row with
the same last name and first name.
key, fname, lname
1 ,John, Smith
4, John, Smith
5, Cody,Edwards
2, Cody, Edwards
Don't list anyone that has a unique first name last name. Is this possible?
Trying to use the Count comman
I have the mysql dump for only 1 table from a database and i want to populate only
that table back into the database.
how do i do that ?
-
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
Greg,
Since you're executing this from a perl script. Try saving the result of
"SELECT MAX(cycle) FROM test.results WHERE snum = '$snum';" to a variable.
Then use that variable in your embedded SQL statement. This alleviates that
issue all together. If you're updating multiple rows, you're query s
Dear MySQL gurus,
I am trying to update on a Perl program that connectes to Oracle through DBI.
I want to develop to a local MySQL database because I don't have access Pro*C to build
DBI::Oracle on my Sun box.
The problem is that my update statement is giving errors. The query as written work
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Spam Bait wrote:
> Hi all.
>
> It's about time I tried out MySQL-5.0. I want to get comfortable with
> the stored procedures so I'm ready to go when it's released.
>
> I'm running Gentoo ( current, of course ).
>
> I ran:
>
> export WANT_AUTOMAKE=1.5
>
Hi all,
Now that technologies such as Reiser4 are emerging that offer atomic
filesystem operations, is it expected that MySQL
will take advantage of them?
I guess I'm asking a massive number of questions with the above
simplistic statement. Admittedly, this is currently a
Linux-centric thing (t
Sure. If you use a secured connection.
A$
-Original Message-
From: Flavio Tobias [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 1:11 PM
To: [EMAIL PROTECTED]
Subject: It is secure to access MySQL thru internet?
I need to access a database thru internet. It is secure to do this
I need to access a database thru internet. It is secure to do this using MySql?
Thanks
Flavio Tobias
I wonder if you could serialize your object, and then store it in a blob
column.
I'd be interested to know ...
Dennis Knol wrote:
>
> Hello,
>
> Is it possible to store Java objects in the mysql database?
>
> Kind regards,
> Dennis
>
> _
Keith Bussey wrote:
Hi all,
I was wodnering if someone has a better way of re-sync'ing a slave when
replication fails.
Here's my setup:
1 - MASTER
5 - SLAVES
Now sometimes, one of the slaves will fail. Usually when it's the sql that stops
running, I can fix it and get it back. However sometimes,
Hi,
How do you copy a table in mySQL.
I know I can do it in phpMyAdmin but I want the actual syntax.
Thanks!!
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
1600 Bedford Highway, Suite 212
Bedford, Nova Scotia
B4A 1E8
www.samplingtechnologies.com
[EMAIL PR
Hello,
I have set up a master/slave replication environment using
4.0.13 but would like to know if there is a way to set up
master/master replication between two databases, both able
to be inserted/updated/deleted, tables created, etc., with
the changes on both databases propagated to each other.
At 05:17 PM 8/28/2003, you wrote:
Hi,
no - adding a limit doesn't really help.
thanks,
- Mark
Mark et al,
Has anyone tried MNOGoSearch (http://search.mnogo.ru/) as a full
text replacement for MySQL? Although it 's primary focus is to index web
pages, it can also be used directly on MySQ
Hi,
I am not sure how to upgrade to MySQL4.1-alpha (window) from MySQL4.0, so i
just copy the file in the folder which i downloaded from web and then paste in the
mysql folder in C:\mysql . But later i found out that the winmysqladmin in the bin
folder can not be opened( i double click an
Hi all,
I was wodnering if someone has a better way of re-sync'ing a slave when
replication fails.
Here's my setup:
1 - MASTER
5 - SLAVES
Now sometimes, one of the slaves will fail. Usually when it's the sql that stops
running, I can fix it and get it back. However sometimes, I also get the "m
Michael Piko <[EMAIL PROTECTED]> wrote:
> Its a standard RedHat 8.0 install. MySQL version is 3.23.52-3 installed from
> the standard RPMs
Run mysqld with --thread-stack=192K option:
http://www.mysql.com/doc/en/Linux-x86.html
>
> - Original Message -
> From: "Victoria Reznichenko
"Suresh Babu A. [IT Engineer]" <[EMAIL PROTECTED]> wrote:
>
> I couldn't start the mysql in the red hat 8, due the bad
> configuration in my.cnf and non availability of data file for
> the database. I want to reinstall the mysql, kindly let me know how to.
You can just edit my.cnf file.
>
> I h
Hello,
Is it possible to store Java objects in the mysql database?
Kind regards,
Dennis
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
MySQL General Mailing
Hello,
we're trying to do a BOOLEAN full text search over a table with about
200.000 entrys and 650MB of data (full text index is about half the size
of the data, the average row length is about 3,2kB) on the System stated
below. A sample statement we're trying to run is:
SELECT
id, title
FR
This is perfectly legal and right. A null should not be used for a
value, and null should be used where a value will be put but has not
been yet, so if I plan on putting 3 entries in where they are all the
same but that in future will be different this is correct. Anyways two
NULLS should not b
Hi Team,
I couldn't start the mysql in the red hat 8, due the bad
configuration in my.cnf and non availability of data file for
the database. I want to reinstall the mysql, kindly let me know how to.
I have also tried "rmp -e .rpm' and removed the files from
/var/lib/mysql. Reinstalled everything
* Enrique Andreu
> Hello, I think I have explained bad. I want to pass
> the arguments to the sql script.
> The argument is for the sql script.
>
> For example:
> myscript.sql should be:
> GRANT ALL PRIVILEGES ON *.* TO &1@'%'
> where &1 would be parameter 1
>
> I want to do something like that:
>
Is it giving you access denied, or is it failing to find the host machine?
if it's access denied you will need to add the username and hostname (of
whichever machine you are connecting from) and grant that user access.
use the 'mysql_setpermission' script to do this.
If you can't actually see the m
Hello, I think I have explained bad. I want to pass
the arguments to the sql script.
The argument is for the sql script.
For example:
myscript.sql should be:
GRANT ALL PRIVILEGES ON *.* TO &1@'%'
where &1 would be parameter 1
I want to do something like that:
dos>mysql mysql -u root -p < myscript
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I use a CPanel Shared hosting environment where MySQL user is not permitted
> with FILE privilege. Please help me by telling what is the alternate
> process to LOAD DATA from a text data file to MySQL table.
>
You can use LOAD DATA LOCAL. In this
Hi all.
It's about time I tried out MySQL-5.0. I want to get comfortable with
the stored procedures so I'm ready to go when it's released.
I'm running Gentoo ( current, of course ).
I ran:
export WANT_AUTOMAKE=1.5
export WANT_AUTOCONF_2_5=1
These are ( I think ) Gentoo-specific commands that m
If it's going to be a simple batch file then use %1, %2, ... inside the
script to get the parameters passed to it.
Or better install & use a real scripting language like perl. ;-)
Lian Sebe, M.Sc.
Freelance Analyst-Programmer
www.programEz.net
> -Original Message-
> From: Enrique Andreu
Hello,
I have found a very interesting UDF function called MyPHP. There is no
problems with UDF installation on Linux based machine but my latop and
all developing tools are working on windows and I don't know how to
install UDF on windows. Can anyone help me with this ??
ML
--
MySQL General
> When I execute the following query I get duplicate
> product_id's as shown
> below:
>
> SELECT * FROM product, product_category_xref, category WHERE
> product_parent_id=''
> AND product.product_id=product_category_xref.product_id
> AND category.category_id=product_category_xref.category_id
> AND
Its a standard RedHat 8.0 install. MySQL version is 3.23.52-3 installed from
the standard RPMs
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 7:56 PM
Subject: Re: Querying a Linux machine
> Michael Piko <[EMAIL
Michael Piko <[EMAIL PROTECTED]> wrote:
> I have mysql on a Linux machine and can connect to through 'localhost' and
> its real IP/hostname. I cannot connect to it from other machines. Is there
> anything I need to do to make this happen?
Please, provide some more info
1. Version of MySQL
2. Do yo
florence florence <[EMAIL PROTECTED]> wrote:
>
> I have downloaded the folder which contains MySQL 4.1 alpha. For the notes in
> the documentation, i still can not understand how to upgrade to version4.1. I am
> just start to use MySQL and straigh forward want to upgrade to 4.1 but there is
Hello.
I have to do an script to create MySQL users, the name
of the new user have to be a parameter of the script.
I have no idea, someone can helps me.
I'm an NT user.
Thanks:
Enrique Andreu
___
Yahoo! Messenger - Nueva versión GRATIS
Super We
Good morning.
In a normal case, to install Mysql in windows we need to run setup.exe and
it's launch a wizard when we define some things like a destination
directory.
I want to know (if somebody can help me) if it is possible to install mysql
and the wizard not be launched.
How to do it??
Hello
If You need some elp You have to give us more details:
What version You use?
Does exist one fulltext index on title + keywords?
The schema and indexes.
The result of:
explain select count(*) from resources where match title,keywords
against('common word');
I think index file size is small.
gerald_clark wrote:
Andreï V. FOMITCHEV wrote:
Hello everyone,
I use Valgrind to check my programs and this last found leaks in
libmysqlclient.so.
My code is simple:
char * requete = "SELECT * FROM "NOM_TABLE_1;
Looks like a misplaced '"' .
lol
#define NOM_TABLE_1 "files"
The problem is a
Here it is:
/var/log/mysqld.log
Number of processes running now: 1
mysqld process hanging, pid 17153 - killed
030829 09:28:31 mysqld restarted
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysq
On Fri, 29 Aug 2003 01:02:57 -0400 (EDT)
"Jordan Morgan" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm very new to MySQL. I normally use MS Access but my project needs
> MySQL. I'm able to set a field(categoryID) in table A(product) a lookup
> field to another table(category) in Access but I can't fin
On Fri, 29 Aug 2003 09:15:48 +1000
Michael Piko <[EMAIL PROTECTED]> wrote:
> I should have mentioned the error:
> [kryten2] ERROR 2013: Lost connection to MySQL server during query
check your MySQLd log to see what happends.
usually you can find it in /var/log/
---
WBR,
Antony Dovgal aka tony200
Hi,
I have downloaded the folder which contains MySQL 4.1 alpha. For the notes in the
documentation, i still can not understand how to upgrade to version4.1. I am just
start to use MySQL and straigh forward want to upgrade to 4.1 but there is not setup
file there. How to do? Thanks.
reg
Hi,
I'm very new to MySQL. I normally use MS Access but my project needs
MySQL. I'm able to set a field(categoryID) in table A(product) a lookup
field to another table(category) in Access but I can't find anywhere that
teaches me how to do that in MySQL.
I'm managing MySQL through a web interface
I use a CPanel Shared hosting environment where MySQL user is not permitted
with FILE privilege. Please help me by telling what is the alternate
process to LOAD DATA from a text data file to MySQL table.
Thanks in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
All,
After installing MYSQL, APACHE, PHP.. My first goal was to get PHP working with MYSQL.
That is pretty easy (Just requires editing the php.ini file) and now you have the Web
Based
PHP communicating with your MYSQL database. So at least you know something is working
and in fact, I got the
When I execute the following query I get duplicate product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND product.product_p
68 matches
Mail list logo
