Hi,
I have a table that has following fields;
code, explanation, level1, level2, level3, level4, level5
A A
A01 A01
A0101 A0101
etc
The problem is that I need to get explanation
SELECT
How do i delete a user utterly from the usertable
Haven't find it right now in the doc(thanks Ian B.)
janB
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
I am new to MySQL and would like to know what encryption capabilities the
MySQL database have.
Regards
Thomas
**
This email and any files transmitted with it are confidential and
intended solely for the use of the
Hi,
How to tell mysql server to kill sleeping sessions after certain time while
using LinuxThreads on FreeBSD 4.4 ? None of wait_timeout and
interactive_timeout values seem to work.
-
Before posting, please check:
Hi!
Copied message:
..
Hi,
I'm a regular mysql user, and a very newbie to innodb. :)
I would like to use innodb because of its row-level locking feature.
Presently I have to use table locks, and they're causing lots of speed
problems. (I've tried Gemini tables, but mysql always crashed
Is there really a SOURCE command? Where is it in the official manual?
source is a command available within the mysql client only. It is not a SQL command.
The client can also get external batch files by piping the commands, in Unix style.
Once you have your file of SQL instructions (say
Dear friend,
I would be grateful if you could tell me if mysql and iplanet are compatible. If it is
possible, what requirements are needed?
Best regards,
Urtzi Larrazabal
-
Before posting, please check:
You can export using
SELECT fieldlist INTO OUTFILE filename FROM table;
This will create a file with tab separated fields. It is Excel default separator.
Within Excel, you can open the file, by giving filetype text, and a wizard will
guide you through the translation.
You can create a CSV file
Just to clarify;
My understanding now,
If I delete row 14 (example) the next time I create any data in my database
it will be put in the now slack space that used to contain row 14 ?
if it does not entirely fit in this space, the data that did not fit will be
put in the next empty / slack
Hi all,
i have a strange situation here,
i am trying to execute an sql insert via prepared statements.
though it is a simple insert process, i am having a syntax error message.
Doesn't mysql support this?
can someone please tell me what is wrong with this query?
String query=insert into
Hi all,
i have a strange situation here,
i am trying to execute an sql insert via prepared statements.
though it is a simple insert process, i am having a syntax error message.
Doesn't mysql support this?
can someone please tell me what is wrong with this query?
String query=insert into
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 20 Nov 2001, Heikki Tuuri wrote:
When someone buys a particular type of good, I would like to lock those
rows from the table, but since the quantity will change, I don't even want
other users to see these rows until I'm finished.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi,
another question on innodb.
right now I'm using table locks. They work, but of course they are slow as
hell. low-level locking would be great. but. my application could
cause an innodb deadlock just about anywhere.
(2 users attacking each
connect mysql
delete from user where user='xxx' ;
flush privileges;
and you also can use revoke statement
- Original Message -
·¢¼þÈË: behrens [EMAIL PROTECTED]
ÊÕ¼þÈË: [EMAIL PROTECTED]
·¢ËÍʱ¼ä: 2001Äê11ÔÂ20ÈÕ 16:17
Ö÷Ìâ: how to delete user from the usertable
How do i delete a
Thanks Hans,
when i replcaed ? with ? , this time i ma having
java.lang.ArrayIndexOutOfBoundsException
at org.gjt.mm.mysql.PreparedStatement.set(PreparedStatement.java:1192)
at
org.gjt.mm.mysql.PreparedStatement.setString(PreparedStatement.java:581)
error message.
However, i am
NODEFAULT would cause all the MSVCRT functions to become unresolved, would
it not?
Pat...
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, November 19, 2001 8:22 AM
Subject: Re: mysql++ linker errors with VC++ ver6
last couple of lines of output from 'configure'
checking for gethostbyname_r in -lnsl_r... no
checking for gethostbyname_r in -lnsl... no
checking for setsockopt... no
checking for setsockopt in -lsocket... yes
checking for yp_get_default_domain... yes
checking for p2open... yes
checking
HI,
I have two problems:
1)
I have the following table:
desc users;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| username | varchar(128) | | PRI |
last couple of lines of output from 'configure'
checking for gethostbyname_r in -lnsl_r... no
checking for gethostbyname_r in -lnsl... no
checking for setsockopt... no
checking for setsockopt in -lsocket... yes
checking for yp_get_default_domain... yes
checking for p2open... yes
hi all,
first post, and i hope it hasn't been covered last week or something!
is it possible to reference a newly created column in a sql function, for
example:
(simplified version compared to real problem!)
select (id * 5) AS score1, (id * 10) AS score2, (score1 + score2) AS
finalscore
Yilmaz,
Recommend you simplify. Test on (say) the first five fields, then the next five,...
and try to work out which
field is causing the issue, then analyse by narrowing down until you figure it out.
The data value (in the (?,?,?,...) list, must be formatted to suit the type in the
column
If you use MySQL I respectfully ask to to avoid NuSphere.
Do not support spammers.
Here Here !!!
This really ticks me off, I mean really ticks me off big time.
Have they no shame?
Wait until you read this.
For a long time now Nusphere has been treading on far too many peoples toes
(who do
Patrick Sherrill writes:
NODEFAULT would cause all the MSVCRT functions to become unresolved, would
it not?
Pat...
Beats me, but I know who could help you.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/
Andy Woolley wrote:
For a long time now Nusphere has been treading on far too many peoples toes
(who do they think they are) not only are they annoying MySQL users with
their exasperating antics they are also trying to steal MySQL from the very
people that actually wrote the software.
It looks like this site is designed to fool a newcomer into thinking
that they've stumbled onto the MySQL site -- there is a tiny mention on
the splash page that 'if you are looking for MySQL AB, click here'. I'm
sorry, but when I was first looking into MySQL, I had no idea what
'MySQL AB' was.
Thanks Neil,
even with only one parameter it doesn't work.
it keeps throwing:
javax.servlet.ServletException: Syntax error or access violation: You have
an error in your SQL syntax near '?)' at line 1
when i replace ? with '?' it throws:
java.lang.ArrayIndexOutOfBoundsException
at
Hei
I asked this question sometime ago but I did not get any answer :-( and I
can not find any explanation of this in the mysql manual.
Could anybody explain me the different between a question and a
sql-request in mysql?.
F.example:
If I send a sql-request to mysql:
select * from Table
Well,
i am answering my own question.
It was keeping telling me that there is a syntax error.
However, the real problem was at the bottom the preparedstatement code
snippet
stmt.executeUpdate(query);
statement should have been
stmt.executeUpdate(); (without parameter)
Wouldn't it make our lives
There have been issues with certain prepared statements and older versions
of MM.MySQL. I suggest you upgrade to the latest (2.0.7) available from
http://mmmysql.sourceforge.net/.
You should not surround your ?'s with single quotes (leave them bare), and
contrary
to the previous messages, you do
HI,
I had an access db with some character like
(germany ä, spain ñ, scandinavia char ), it's well ordered under
access.
but my export in mysql latin1 give a wrong order.
How can I do to have a well classed db like under access (with win1250
charset I think ?, how can I make to have the
Description:
I do not seem to be able to login as mysqladmin to set the root
password , it says connect to server at 'server name' failed
and host 'ip address' is not allowed to coonect to this MySQL server
it seems that there are some fundamental issues not mentioned
on install that I
Hi!
Arjen == Arjen G Lentz [EMAIL PROTECTED] writes:
cut
The problem is, how would you add a new bus and a new driver to the
database? Whichever one is added first, you're going to get an error
because its counterpart doesn't exist yet, violating referential integrity.
You could
key buffer is about 8M
key_buffer_size | 8388600
I just tried bumping my settings up to these that I found in the
manual...
safe_mysqld -O key_buffer=64M -O table_cache=256 \
-O sort_buffer=4M -O record_buffer=1M
It shaved a second off... 2.29, and later call took
only .88
Hi all,
Am facing a strange problem... I am running MySQL on a WIN 2000 server and
was running fine till this morning..
I am using PhpMyAdmin to administer the databases.. Suddenly all of a sudden
I could no longer connect to the databases and keep getting an error saying
Can't connect to
I will try to be as complete as possible here. This is the query that I'm
trying to run:
SELECT
usr_id,
usr_username,
usr_first_name,
usr_last_name,
usr_show_real_name,
4.0 does support SSL connections. Note that this isn't an encrypted database,
it's just that the connection between you and the server is encrypted --
which is of course, good. One more thing: you have to specifically use the
SSL feature -- don't assume that your connection is encrypted! I
Summary
If I have a filed of type DATETIME in a table and do a query with an order
on that field than records with a datetime in the afternoon are returned
before articles in the morning.
EG:
mysql select pubtime,articleid,headline from articles where articleid
mysql 3050 order by pubtime;
3076 is 2:53 in the morning, not the afternoon.
On Tuesday 20 November 2001 08:46 am, Andy wrote:
Summary
If I have a filed of type DATETIME in a table and do a query with an
order on that field than records with a datetime in the afternoon are
returned before articles in the morning.
EG:
Hi
This is not an atempt to start a flamewar!!
We're about to build a db server for educational purposes. Running 150+
databases pr. semester. Nothing big, nothing demanding when looking at a
single database, but combined it may give some load (might be a lot of
concurrent activity during
Unable to start the service MySQL thru ctl panel/services too.
Tried reinstalling MySQL but to no avail...
frustrating...
sandeep
- Original Message -
From: yilmaz [EMAIL PROTECTED]
To: Sandeep Murthy [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 3:22 PM
Subject: Re: Mysql Daemon
Thomas S. Iversen wrote:
Back to the question: we're on a limited budget, and have to choose
between either inexpensive but large IDE disk or fast but small SCSI
disks. The machine has 1GB memory. First thought would be IDE disks since
we have enough memory to cache the DBs.
If you're on
Hi.
On Tue, Nov 20, 2001 at 09:58:46AM +0530, [EMAIL PROTECTED] wrote:
Hi,
I am developing an application which shows Meta Data of the MySql database in Tree
Structure.
In this i am displaying nodes like Tables and its childs are Tables in the database,
Indexes and its child nodes are
Mr Gerber,
thank's for the fast and helpful respons (the result is in point 2).
1. I also have another problem when I created a simple C-API code, I
couldn't compile correctly, I always get this error below
[EMAIL PROTECTED] [/usr/local/mysql]:cc
-I/usr/local/mysql/include/mysql
Cancel this,
I found the problem. Had to grant FILE privileges to this user! total forgot
about that!
TIA,
On Tue, 20 Nov 2001 10:14:52 +0100, Giuseppe Maxia [EMAIL PROTECTED] wrote:
You can export using
SELECT fieldlist INTO OUTFILE filename FROM table;
This will create a file with tab
sorry, uname -X
[EMAIL PROTECTED] [/usr/local/usr/lib]:uname -X
System = SCO_SV
Node = mfs09
Release = 3.2v5.0.5
KernelID = 98/07/02
Machine = PentII(D)
BusType = ISA
Serial = 2HA142698
Users = 5-user
OEM# = 0
Origin# = 1
NumCPU = 1
-Original Message-
From: Mohamad Waluyo
Sent:
I'd say that if your database can fit on the SCSI drive you can afford, there
is no reason for not choosing SCSI. Or, hec, if it's a really small database,
why not ramdist?
In regard to your question about whether it confirms a write before commiting
a transaction. First of all, check to see
Hi,
I would like to send multiple SQL statements using the C
API mysql_query. I have a large string with 20 SQL statements. When
I call mysql_query with that string, only the first one is processed.
Is there a way to do what I'm doing without separating the statements
into individual calls to
Y have make a function like
Result CSql_tools::SendaQuery(CString request)
{
Result res;
Query query = GetQuery();
// This creates a query object that is bound to con.
queryrequest;
res=query.store();
// Query::store() executes the query and
On Tue, 20 Nov 2001, Ken Kinder wrote:
Date: Tue, 20 Nov 2001 08:41:20 -0700
From: Ken Kinder [EMAIL PROTECTED]
To: Thomas Kotze` [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: MySQL and encryption
I would like to know if anyone has some advice on encrypting credit cards
myself, as
In the last episode (Nov 20), yilmaz said:
Well,
i am answering my own question.
It was keeping telling me that there is a syntax error.
However, the real problem was at the bottom the preparedstatement code
snippet
stmt.executeUpdate(query);
statement should have been
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi,
On Tue, 20 Nov 2001, Anna Winkler wrote:
I would like to send multiple SQL statements using the C
API mysql_query. I have a large string with 20 SQL statements. When
I call mysql_query with that string, only the first one is processed.
Hi!
On Nov 20, William R. Mussatto wrote:
On Tue, 20 Nov 2001, Ken Kinder wrote:
Date: Tue, 20 Nov 2001 08:41:20 -0700
From: Ken Kinder [EMAIL PROTECTED]
To: Thomas Kotze` [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: MySQL and encryption
I would like to know if anyone has
At 15:06 20/11/2001 +, Sandeep Murthy wrote:
Hi,
Every time you have problems to start the server, the best way
to find the problem is try the start in the prompt DOS mode
using the parameters --standalone --console.
In this way you should see the message error and fix it. Also
you find at
database,sql,query,table,database,sql.query,table,
You may also need to pub a temporary link from libsocket.so.1 to
libsocket.so.2 There will be a new patch that will install this
libsocket.so.2 library. So you will need to remove the link when it comes
out.
Good Luck,
--
Boyd Gerber
Is there a GUI for MySQL that runs on OSX?
Patrick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
On 11/20/01 at 6:22 PM, Sergei Golubchik wrote:
Hi!
On Nov 20, William R. Mussatto wrote:
On Tue, 20 Nov 2001, Ken Kinder wrote:
Date: Tue, 20 Nov 2001 08:41:20 -0700
From: Ken Kinder [EMAIL PROTECTED]
To: Thomas Kotze` [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: MySQL
Andy,
Assuming you have not made a mistake in reading 02:53:32 as afternoon, when in fact it
appears to have been
early-morning; is there a problem with the code that INSERTs the data in 12-hour
instead of 24-hour format?
=dn
- Original Message -
From: Ken Kinder [EMAIL PROTECTED]
To:
Patrick Stroud writes:
Is there a GUI for MySQL that runs on OSX?
I don't know if there are any platform-dependent GUIs
that have been ported, or if there is a Java GUI, but
I do know that if you have a web server and PHP, you
can use e.g. phpMyAdmin. I use it and I like it, but
others might
It'd be interesting to know if A LOT of people have had this happen.
If so, maybe we should apply some social pressure and see if they're
see the error of their ways.
Thoughts?
Yeah.. I think I remember there was a Federal Trading.. thing (forgot it's
name) somewhere in the USA which was
Hello,
I am trying to perform the following delete command:
delete from my_table where match(keywords,title,description)
against('this_word')
When I perform a similar select and count with the above query, I come up
with 47 records found. However, when I issue the above delete command, no
11/19/01
Linux version 2.2
rpm -i MySQL-3.23.44-1.i386.rpm MySQL-client-3.23.44-1.i386.rpm
Error Message: MySQL-client-3.23.44-1.i386.rpm can not be installed
RPM files in usr/local/mysql
client
server
benchmark
libraries
shared libraries
Hi Donna,
Try this. That was the way i've installed Mysql on my server.
rpm -ivh MySQL-3.23.44-1.i386.rpm
rpm -ivh MySQL-client-3.23.44-1.i386.rpm
Please notice, that you have to use the RPM command 2 times.
Regards
Frank
Denmark.
---
http://www.tuffy.dk
---
-Oprindelig
Michael, et al:
I want to assure everyone that there is no attempt to spam anyone on
this email list, this email list is a valuable community service and
not to be abused. Regardless, I'm sorry that anyone even has that
impression. If you have any concerns after reading this please
feel free
What's wrong with this inplode / array / mysql-querry ??
From an html site i get the following variables
zimmermulreg bezirkmul: Usually string arrays from a multiselect-field
qmvon, qmbis, mietebis: string
if ( $mietebis == '') {$mietebis='100';};
if ( $qmvon == '')
I've been using mysql on a single-box install for data analysis
for 6 months or so to great success. I've recently had to
expand this to a several-machine configuration as part of a big
growth in the amount of data that's being processed, of which
mysql is just a part. I've run into two
Hi. I'm doing a search of a 2-million-record book table. The table is
searched very heavily, and while most queries are finished in a second or
two, some take a disproportionately long time - any time a very common word
such as 'john', which matches upwards of 80,000 records, is included in the
Hi!
On Nov 20, Laurence Aronberg wrote:
Hi. I'm doing a search of a 2-million-record book table. The table is
searched very heavily, and while most queries are finished in a second or
two, some take a disproportionately long time - any time a very common word
such as 'john', which matches
Hi Craig,
Just wanted to gloat about how much I love the new 4.0 version =)
:)
===
Server version: 4.0.0-alpha-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset:latin1
Server characterset:latin1
UNIX socket:
What a shameless plug.
Given other questions, I'll provide a quick update on NuSphere.
Our product line has been expanding recently and we are pleased to
- Jonathan
Speaking of green eggs and ham, that is the breakfast of choice
for our developers - the ones who made our new product:
I find the easiest is to use a unix timestamp in your db (int), then use the
date() php function to format the display as your please.
On Tuesday 20 November 2001 04:29 pm, Joel Wickard wrote:
Hello all.
I'm developing a web-based app with php / mysql. I'm interested in
hearing peoples
At 9:51 AM -0800 11/20/01, Patrick Stroud wrote:
Is there a GUI for MySQL that runs on OSX?
MacSQL Monitor
(and SQL Language Module for BBEdit)
Runtime Labs
http://www.rtlabs.com/
SQL4X Manager
MacOS Guru
http://www.macosguru.de/
phpMyAdmin
Phpwizard.net
I have been trying to perform a join with several tables and I am having no
joy.
Can some one send me a query (just a select * is fine) for these tables
the ID's i'm using below aren't the real column names but they will do for
the purpose of this email.
select * from
table1 left join table2 on
I am trying to display a hierarchically related list of folders via a
recursive SQL statement (each row in a table represents a folder).
What is needed is a select that will sort the folders and associate
the parent folder with their child, sub-folders. The kicker is that
the items in the
i am having this problem, ( http://www.pafo.net/mysql.gif, a gif file that illustrates
the problem )
i am using a firewall and i am connected to the internet all the time.
regards
pafo
-
Before posting, please check:
just wondering, when you start the database replicating, the bin files start
counting
at .000
host-bin.001
host-bin.002
host-bin.003
...
host-bin.999
what happens when you reach .999?
does it start over at .001 and over-write you initial files, or does it
continue on?
Thanks,
Jim Lucas
i fixed the first problem, i had personal web server installed but i had turned it
off
now my next problem is this, http://www.pafo.net/mysql2.gif
how can i get pass this.?
regards
pafo
- Original Message -
From: Pafo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday,
Hi,
I am trying to get MySQL 3.22 (off a CD from a manual) running on Windows
98. I have installed it on my C drive and am trying to run the following
command from DOS:
c:\mysql\binmysqld --standalone
I can get to the mysql\bin directory, but when I type the
mysqld --standalone, I get a Bad
If I have a process inserting into an innodb table in 200 insert chunks.
i.e. it commits after every 200 inserts, must another process, which wants
to delete data from this table, wait for the next commit on the insert end?
If not is there any reason why my process is doing this.
Ric
Hi Dan,
- Original Message -
From: Dan Buckner [EMAIL PROTECTED]
I am trying to get MySQL 3.22 (off a CD from a manual) running on Windows
98. I have installed it on my C drive and am trying to run the following
command from DOS:
c:\mysql\binmysqld --standalone
I can get to the
Hi,
- Original Message -
From: Pafo [EMAIL PROTECTED]
i am having this problem, ( http://www.pafo.net/mysql.gif, a gif file that
illustrates the problem )
i am using a firewall and i am connected to the internet all the time.
The latter shouldn't be an issue, since according to
Hi there
I am passing an SQL statement through to Mysql, in certain circumstances
(not very often), the information within the statement is the same as what
is in the database, therefore 0 records are affected. This is great from a
speed perspective, but I want to know that 0 records were
Hi Friends,
If any body knows please,
Does MySQL server supprots dropping a user. If yes, what is the syntax to
drop a user.
Thanks,
bye,
Omkaram Sangem
iNuCom (India) Ltd
Secunderabad:53
Phones:+91-40-7893817/7812959
Fax:+91-40-7809071
Email: [EMAIL PROTECTED]
www.inucom.com
On Wednesday 21 November 2001 05:55, Dieter Hansen wrote:
What's wrong with this inplode / array / mysql-querry ??
From an html site i get the following variables
zimmermulreg bezirkmul: Usually string arrays from a
multiselect-field qmvon, qmbis, mietebis: string
In your form, you should
83 matches
Mail list logo