Noamn [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I asked about a week ago how to get mySQL to index correctly in Hebrew,
and
the best answer that I received was to define a my.cnf file as follows
[mysqld]
set-variable = default-character-set = hebrew
I created the file
When I change the value of fMySQLSocket to NULL
i.e., 05 C-cMySQLSocketpic x(8).
88 fMySQLSocket value NULL.
The compiler shows the following error;
219 E NULL initial value invalid for 'NULL'
So how can I assign NULL to this condition name variable?
Hi,
I posted this question in MySQL mailing list and got no reply.
The basic problem is that I have committed the transaction and then
replicated to another DB. Now I want to rollback the committed transaction.
Is there a way to rollback to a particular point. This requirement is very
FIRST() and LAST() are not available (yet, I'll keep hoping) but you can
mirror their functionality using TEMP tables, and you could probably do it
with SubQueries (4.1+). There are options out there to get around them.
The experience I've had with with temp tables has been quite good, though
I'm fairly sure there is *no* way to do it. COMMIT says 'I want this data in
the database' not 'I think I want this data in the database'
Chris
-Original Message-
From: karthikeyan.balasubramanian
[mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 11:37 PM
To: [EMAIL PROTECTED]
If you want to build something like a web form you will need to use HTML and a
scripting language. A common solution to do what you are asking is to use PHP.
You will need to be familiar with PHP to go further. Go to http://www.php.net
to get a hold of the basics.
There is no way to write a
Hi Chris,
Thank you for you quick reply.
Is there any alternative way to get back to the old state of the database?
Looking forward for your response.
Karthikeyan B
- Original Message -
From: Chris [EMAIL PROTECTED]
To: karthikeyan.balasubramanian
[EMAIL PROTECTED]; [EMAIL
Troy T. Hall wrote:
I know this sounds stupid but I'm totally lost.
I've created a MySQL DB whose purpose is to track customers who have not
gotten a newspaper.
I've created all the necessary fields, and have managed to learn how to
add/delete/modify the records in mysqlcc, but what I want is
Hi,
I saw an example of creating tables (see below). I
wonder what the primary key (user_name, role_name) in
the table user_roles means? Does it mean that both
user_name and role_name are the primary key of the
user_roles table? How does a table have two primary
keys?
create table
In case that a user has multiple roles; for example,
John Dole is both author and editor,
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and use comma ',' to
separate the roles?
John Dole author, editor
2.
Caroline Jen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
In case that a user has multiple roles; for example,
John Dole is both author and editor,
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and
Hi,
In case that a user has multiple roles; for example,
John Dole is both author and editor,
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and use comma ',' to
separate the roles?
John
tom poe [EMAIL PROTECTED] wrote:
What's the command for dropping multiple tables?
Example:
12 tables that all start with:
phpbb_
What? Well, the install isn't going as planned. I am having to
reinstall as I try to work out script path (I think) or some other piece
of info that isn't
fredag 02. januar 2004, 12:11, skrev Egor Egorov:
tom poe [EMAIL PROTECTED] wrote:
What's the command for dropping multiple tables?
Example:
12 tables that all start with:
phpbb_
What? Well, the install isn't going as planned. I am having to
reinstall as I try to work out script
Hi Tom,
Look at the docs:
http://www.mysql.com/doc/en/DROP_TABLE.html
Happy New Year and best regards,
Mikhail.
- Original Message -
From: tom poe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 8:33 AM
Subject: dropping multiple tables with one command
But you can do DROP table1; DROP table2; DROP table3; etc..
You can do even better:
drop table table1, table2, table3;
:)
Best regards,
Mikhail.
- Original Message -
From: Arne K. Haaje [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 02, 2004 12:29 PM
Subject: Re:
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
might help you do what you're looking for.
On Thu, 1 Jan 2004, Schulman, Michael wrote:
As far as I know min(price) and max(price) will return the lowest and higest
price, not the first and last in the group. Again I know
Am Fr, den 02.01.2004 schrieb karthikeyan.balasubramanian um 09:28:
Is there any alternative way to get back to the old state of the database?
The only way I can think of is to dump the respective tables (e.g. every
night) and re-import them when needed.
Note that this can't be done by mysql
On Wed, 31 Dec 2003 19:19:32 -0800 (PST), Caroline Jen
[EMAIL PROTECTED] wrote:
Hi, I tried to create a table. This table has
seventeen fields. My create table syntax gets too
long and I was only able to specify 5 fields at the
mysql prompt in the DOS window (DOS does not accept a
command
On Fri, 2 Jan 2004, Caroline Jen wrote:
In case that a user has multiple roles; for example,
John Dole is both author and editor,
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and use comma ',' to
separate
What version is more quick? MySQL 5.x or 4.x
Innodb or MyIsam tables?
Regards for all
Carlos Souza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I've been unable to find a single reference to the thread status of unauthenticated
user on any mysql documentation - from time to time I get this status when connecting
from one particular host. The real problem is that whilst in this state the requesting
host appears to those
Has anyone used Crystal Reports successfully with MySQL? I tried the ODBC
driver but it was rejected with a message that the Professional version
was needed.
Eldon Ziegler
Atlantic Software, Inc.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
You can add a version field to each row. Then add a seperate table with
info with a list of the versions and a flag for deleted. Queries would
look for each record that has the highest version number thats not
deleted. Having a lot undo/redo info can get kind of complicated,
especialy with
On 2 Jan 2004, at 12:26, Eldon Ziegler wrote:
Has anyone used Crystal Reports successfully with MySQL? I tried the
ODBC driver but it was rejected with a message that the Professional
version was needed.
The issue might be with Crystal Reports itself and nothing to do with
MySQL. Are you
Randy,
that is expected:
http://www.innodb.com/ibman.php#Locks_set_by_statements
If a FOREIGN KEY constraint is defined on a table, any insert, update, or
delete which requires checking of the constraint condition sets shared
record level locks on the records it looks at to check the
Chris W [EMAIL PROTECTED] wrote:
I am having trouble revoking the rights of the anonymous user or setting
a password for that user. Can some one help. I can just do an update
or delete but I want to do it with revoke and set password.
What exactly problems do you have? Show your REVOKE and
Franky,
you apparently have just the PRIMARY KEY defined on the table and no
secondary indexes. I guess the fragmentation comes because you delete rows
from in the middle with respect to the primary key ordering? Or do you also
insert in random order? Anyway, you cannot do anything to prevent
Every shutdown MySQL I found error as this
shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)'
I tried to find solution of this error, but I didn't find it.
Because of that I need solution of this error.
Please give me the solution.
Regard's
Muliadi
I'll be fighting with rights over tmp tables time ago, basically I want give full temporary tables management but notforotherall tables, including select right.
The only way to do that work was insert in tables_priv for each user a "user/tmp_table_name" record granting full privileges.
Question: Is there a way to find available MySQL Server via broadcast in the
network using Win-sockets?
I have some data and want to send it to the SQL server. The user should see
all available SQL server in a list, can chosen one (don't care MSSQL or
MySQL) and the program will store the data
How are you shutting down MySQL?
-Original Message-
From: ikm [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 11:14 PM
To: [EMAIL PROTECTED]
Subject: Shutdown error
Every shutdown MySQL I found error as this
shutdown failed; error: 'Access denied for user: '@localhost'
On Jan 2, 2004, at 4:28 AM, Caroline Jen wrote:
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and use comma ',' to
separate the roles?
John Dole author, editor
2. How do I create the table for the second
* Caroline Jen
In case that a user has multiple roles; for example,
John Dole is both author and editor,
1. I should have two rows for John Dole?
John Dole author
John Dole editor
or. I should have only one row and use comma ',' to
separate the roles?
John Dole
I am freshly install MySQL on my computer with Windows 98 as operating system.
I used MySQL ver. 3.23.58-max-debug. I am new user of MySQL and have problem when
shuttingdown WinMySQLAdmin.
The error as this:
Error on shutdown:
Access denied for user: '@localhost' (Using password:
Hi Guys,
I am running winxp with mysql. Seeing this is a home machine there is no workstation
just one computer which I guess at this point is acting as my server and client for
mysql. I am just getting acquainted with mysql so I have been playing around with both
4.1 and 5.0. Neither database
Hello,
The two columns of my table are name and city. I am trying to do a list which contains
only the different names. This can be done this by distinct keyword. But all the same
names which have different cities also have to be included in my list. So I can not do
this with a distinct
if you are tryin to shutdown mysql you have to be the superuser mysql/root then give
the mysqladmin -u root -p command or something. If you are doing this and it is not
working then the permissions for the superuser are not set rite go change the
permissions in the user table to allow root or
* Veysel Harun Sahin
The two columns of my table are name and city. I am trying to do
a list which contains only the different names. This can be done
this by distinct keyword. But all the same names which have
different cities also have to be included in my list. So I can
not do this with a
:) I have solved the problem.
Thanks.
[EMAIL PROTECTED] (Veysel Harun Sahin) wrote:
Hello,
The two columns of my table are name and city. I am trying to do a list which
contains only the different names. This can be done this by distinct keyword. But all
the same names which have different
select distinct(col1,col2) should work.. Group by most certainly will... Select
col1,col2 from table group by col1, col2.. Same thing
Hello,
The two columns of my table are name and city. I am trying to
do a list which contains only the different names. This can
be done this by distinct
Hi,
try to use group by clause in your select, e.g.
select name, city from mytable group by name, city order by name, city;
Best regards,
Mikhail.
- Original Message -
From: Veysel Harun Sahin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 02, 2004 4:42 PM
Subject:
I wish you all a very happy new year
Brasil, 2004
This message was sent using IMP, the Internet Messaging Program.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-
Searchable archives for this list are available at
http://www.listsearch.com/mysql.lasso
--
I'm trying to open mysql.sock file as a ROOT and receive the error message
permission denied.
Why mysql.sock has such permission?
_
Tired of slow downloads? Compare online deals from your local high-speed
providers now.
dear fellow MySQL users,
i am developing a photo gallery with php4/mysql4.0 that uses faceted classification.
-my tables:
photos(photoid)
metadata(photoid,facetid)
-to select all of the photoid's that are associated with either facetid 1 or 2:
SELECT DISTINCT photos.*
FROM photos,metadata
I have a loop which is similar to the following:
while(array contains elements) {
UPDATE users SET status = no WHERE name = array[i]
}
great, it works but the query runs many times. I want to make only one
call to the database and have all the elements in the array be included
in the query
--
Try forming the query with only the first array element, then iteratring
through the rest concatinating OR clauses onto the end of the query. And
then after the loop sending the query to the db. See my below pseudo code.
String query = UPDATE users SET status = no WHERE name = array[0]
Hi!
Sorry for delayed answer - I was on vacations...
On Dec 08, Uros Kotnik wrote:
OK, I will give you more details.
Table CDS, have 1,053,794 rows, FT index on title,
Data 67,646 KB, Index 70,401 KB
Table ARTISTS, Rows 292,330, FT on name,
Data 8,096 KB
Index 17,218 KB
Table
On Fri, 2 Jan 2004, Jonathan Villa wrote:
I have a loop which is similar to the following:
while(array contains elements) {
UPDATE users SET status = no WHERE name = array[i]
}
great, it works but the query runs many times. I want to make only one
call to the database and have all the
You probably want the IN comparison operator
(http://www.mysql.com/doc/en/Comparison_Operators.html)
For example:
UPDATE users SET status=no WHERE name IN ('Joe', 'Wally', 'Bob', 'Cynthia');
Of course, you can create this statement from the list of names by
joining all of the names with
What language are you using? It's not clear from your example what language
you're using (no $s, but you also forgot to increment your array so?), so
I'll give you an example in PHP:
$query_string = implode( OR name = , $yourarray);
mysql_query(UPDATE users SET status = no WHERE name =
I am COBOL illiterate. You could try passing hex zero 0x00 as NULL. I have
no idea of the correct syntax for doing this in COBOL.
Pat...
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: Patrick Sherrill [EMAIL PROTECTED]
Cc: mySQL List [EMAIL PROTECTED]
Sent: Friday,
yeah, if its owned by mysql with no write privs. That doesn't mean you cant change it
using root..
I'm trying to open mysql.sock file as a ROOT and receive the
error message
permission denied.
Why mysql.sock has such permission?
--
MySQL General Mailing List
For list archives:
* Seamus R Abshere
i am developing a photo gallery with php4/mysql4.0 that uses
faceted classification.
-my tables:
photos(photoid)
metadata(photoid,facetid)
-to select all of the photoid's that are associated with either
facetid 1 or 2:
SELECT DISTINCT photos.*
FROM
Have you tried this code using:
hostaddr.sin_port :=htons(3306);
I've never done this but the code looks like it is checking the appropriate port on
all machines found. See what happens when you use the MySQL default port.
--
MySQL General Mailing List
For list archives:
It wasn't code, just an example to get my question across clearly...
I will try the IN, however the manual says Returns 1 if expr is any of
the values in the IN list I want to do it for every value. So I'm
trying to accomplish this in one query:
UPDATE users SET status = no WHERE name = bob;
Hello:
I am installing MySQL 5.0.0 (on a fresh install RH9). I am following binary
installation as outlined in official MySQL documentation with default
location /usr/local. I sure appreciate if somebody on this list is kind
enough to email or list contents of my.cnf file.
Thanks.
Kirti
--
I've forwarded this reply to the list so other people may benefit from
the information.
Steve.
Begin forwarded message:
From: Eldon Ziegler [EMAIL PROTECTED]
Date: 2 January 2004 18:58:36 GMT
To: Steve Folly [EMAIL PROTECTED]
Subject: Re: MySQL and Crystal Reports?
I found their capabilities
I need help width formulating the most
effective (in terms of processing time)
SQL query to count all the new
documents in the repository, where new is
defined as from 00:00:01 up to 23:59:59
today. My current query does not give me
satisfactory results, it creates a
Hi,
Look at /usr/local/mysql/support-files directory.
There are several examples of my.cnf files for different configurations
there (my-huge.cnf, my-large.cnf, ...).
Best regards,
Mikhail.
- Original Message -
From: Kirti S. Bajwa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
The correct entries for your my.cnf will vary depending on which features that you
want to support. There is no standard contents. See the manual for the chapters on
installation, configuration and optimization. Most distributions come with sample cnf
files called: my-huge.cnf, my-large.cnf,
One other thing to check is that there are indexes on the fields in the other tables
that you are joining to.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In MS SQL Server 2000, it is possible to create what MS refers to as
clustered indexes. You can have only one clustered index per table,
because the index is created by sorting the entire table by the row that is
to be the clustered index. If you have a table with a row called ZIPCODE,
for
on 1/2/04 12:59 PM, Adam i Agnieszka Gasiorowski FNORD wrote:
Tell me if you need any additional information.
Thank you for all your help.
Some additional information would help, yes. What exactly are the sections, for
example? Do you need to know the number of new _articles_ total, the new
on 1/2/04 12:40 PM, Jeremy March wrote:
What language are you using? It's not clear from your example what language
you're using (no $s, but you also forgot to increment your array so?), so
I'll give you an example in PHP:
You can still do better than that. IN will be more readable than a
In all probability it's (x_section.Status 1) = 0 and
(x_instance.Status 255) = 0 that's giving you the problem.
Unfortunately this is a database schema problem not a query fix. By putting
a computation on a field into the WHERE clause, you're forcing the database
to do that computation on
InnoDB does clustering in the Sybase style but MyISAM is lean, mean
and quick.
If you really wanted to do this though, you could probably do the
following:
CREATE TABLE tab SELECT * FROM old_tab ORDER BY zip_code ASC;
And then add the indexes!
One thing you should know though - MyISAM's
Its been a long time since I've looked at RT. I was trying to remember what
I had seen before that did things very similar to what I'm doing and now
you've reminded me... ty.. I don't think its 100% of my solution, but it
might be part. More reading LOL
Troy
Asif Iqbal [EMAIL PROTECTED]
Thanks for the good tips... I'll be doing that this weekend. I think the
hardest part is going to be trying to figure out how to store a contract
once all the fields have been populated. Its an OO document at this point.
Troy
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
If you
Hi,
I have a table having 3 field of text datatype. One of the field is Age_type where the
data is either 0+ or 75. Its found that on executing the select statement, this
particular column is showing blank in linux system, where as the same is showing the
datain windows system. In both system(
71 matches
Mail list logo