Hi, all,
When i want to set session binlog_format, I got error which means i should have
the SUPER privileges,
So i want to know, why i need such privileges just for the session variable?
On Fri, 2008-11-14 at 14:30 +, Mark Goodge wrote:
> I wouldn't try to arbitrarily normalise the database for SQL
> efficiency.
> In a real-life situation, it's more important that the database
> design
> reflects your actual workflow and business requirements. Having a
> field
> that's empty
On Wed, 2008-10-15 at 12:08 -0400, Olaf Stein wrote:
> You can use the convert_tz function for this
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
> _convert-tz
>
> On 10/15/08 12:03 PM, "Madan Thapa" <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > Can we make adjus
On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I have a table of a 1 million users. I want to add a flag called
> > delete if a user wants to delete his account. Note that this situation
> > does not happe
On Thu, 2008-09-18 at 09:58 +0100, Stut wrote:
> Autonumber will accomplish that, so long as you don't delete any.
> And
> if you do, renumbering the bookings would cause more problems than
> it
> solved.
>
Autonumber has the possibility of gaps. When a record is insert, the
counter is incre
On Thu, 2008-09-18 at 08:34 +1000, Res wrote:
> Hi Peter,
>
> On Wed, 17 Sep 2008, Peter Brawley wrote:
>
> >> I'm looking at using the "@" symbol
> >
> > Don't. Restrict yourself to alphanums and '_'.
>
> Thanks, but is there any technical reason where using "@" might break
> something? Howeve
On Wed, 2008-09-17 at 23:29 +0100, Stut wrote:
> On 17 Sep 2008, at 22:34, Jerry Schwartz wrote:
> > Our Japanese partners will notice and will ask. Similar things have
> > come up
> > before.
> >
> > I want to be pro-active.
>
> Notice what? Why would it be bad? What type of data are we dealing
On Sat, 2008-08-02 at 16:16 -0500, Skip Evans wrote:
> Hey all,
>
> What is the most effective way to block HTML code
> in insert statements?
>
> I have a client with a comments form that is being
> bombarded with people inserting references to
> their own sites, etc, and I need an effective w
On Thu, 2008-07-31 at 11:47 -0500, Chris W wrote:
> My thought is you should develop an application that will give your
> users the information they need with out direct access to the DB. My
> thought is, if a user doesn't have a solid understanding of at least 1st
> and 2nd normal form, and ba
On Thu, 2008-07-31 at 11:24 -0400, Perrin Harkins wrote:
> On Thu, Jul 31, 2008 at 9:46 AM, Jerry Schwartz
> <[EMAIL PROTECTED]> wrote:
> > Other than the fact that an ENUM can have many more values than a SET, is
> > there any particular reason to choose one over the other?
>
> The only use for E
On Thu, 2008-07-31 at 10:24 -0400, Jerry Schwartz wrote:
> [JS] Users will have read-only access through MS Access, and have to filter
> on various fields.
You're assuming that your users will never, ever be granted anything but
read-access to only the data they suppose to have, either by accident
On Thu, 2008-07-31 at 09:56 -0400, Jerry Schwartz wrote:
> [JS] I added a dozen or so columns for a special purpose, and although MySQL
> doesn't care I wanted them in a certain order that would be intuitive to a
> user / programmer.
Why is a user looking at your database?
This is a security bre
On Wed, 2008-07-30 at 14:42 -0400, Jerry Schwartz wrote:
> Is there any reasonable way of re-arranging the order of columns in a table
> without losing their data? The best I could come up with was to copy the
> table, empty it, and then do an INSERT . SELECT specifying the new order of
> the field
On Mon, 2008-07-28 at 07:32 -0400, Gary Josack wrote:
> Andrew Martin wrote:
> > Hello,
> >
> > Is it permissible to order a clause such that the search term is the
> > first item (in the clause)?
> >
> > standard:
> > field1 IN (123, 654, 789)
> >
> > in question:
> > 123 IN (field1, field2, field
Why? Because it's Friday and I'm feeling silly :)
mysql> SELECT * FROM sales;
+--+---++
| company | state | sales |
+--+---++
| ABC | AZ| 140.01 |
| XYZ | AZ| 17.76 |
| ABC | NY| 123.45 |
| XYZ
On Thu, 2008-07-24 at 14:49 +0200, walter harms wrote:
> hi list,
> i have tables that look like this( <10.000 entries) :
>
> id,
> timestamp,
> value
>
>
> to get the latest value for each id i have queries like:
>
> select * from tab A where timestamp = (select max(timestamp) from tab B where
On Thu, 2008-07-24 at 17:36 +0530, Sivasakthi wrote:
> Hi all,
>
> How do I get the file names from a certain directory in SQL?
SQL is designed to deal with RDBs, not the rest of the computer system.
I suggest you switch to a modern language such as Perl, Python, Ruby, or
even PHP. Each has a g
On Thu, 2008-07-24 at 09:34 +0530, Sivasakthi wrote:
> How can we normalize the tables? could you explain bit more?
>
>
> Thanks,
> Siva
>
>
Normalization is a complex subject. I suggest you search the web for
tutorials. Try the search terms: RDBM normalization
--
Just my 0.0002 milli
On Wed, 2008-07-23 at 12:10 -0400, [EMAIL PROTECTED] wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+-
On Wed, 2008-07-23 at 17:05 +0300, Ali Deniz EREN wrote:
> Hi all,
>
> I have a problem as below:
>
> A text field -Lets call it 'field1'- contains datas seperated by
> commas(,) like this (123,5764,8795,9364,11,232,. and go on) And so
> my lines like these:
>
> id title filed1
> -
Classification: UNCLASSIFIED
Caveats: NONE
Well this is probably getting off topic, but I didn't start it ;). And I
know there's a lot of expertise on the list...
So, one of the items mentioned by Warrick dealt with
snip [ pre-defined reports (in which they may need to enter data, like
"St
Classification: UNCLASSIFIED
Caveats: NONE
All,
I'm getting the not-so-mysterious error in my slave log file as follows:
[ERROR] Error reading packet from server: log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master
(server_errno=1236)
[ERROR] Got fatal error 1236
Classification: UNCLASSIFIED
Caveats: NONE
All,
Having stability issues w/ Mysql 4.1.10 (innodb) on RH Linux 2.4.9-e.59smp
running AS 2.1. DB crashes randomly during execution of various SQL code
(all using user variables and temporarly tables and mostly simple selects,
inserts, joins, etc.).
I believe I have read or skimmed all of the posts to this group with
"Lock", "wait" and "timeout" in their body over the past year (172) with
no answers in sight (if I missed a post, please let me know).
I am unable to figure out what is causing this problem that is 100%
reproducible on a 4.0.2
repspected sir
my self bunty chunara, i am doing the project (for
database i have used mysql) i have downlaod it from
site but it, does not wok on my computer. i have
install it and when i open the mysql from the dos
promt it say that access deined at local host.
please sir give me proper info
Hi All,
I need with an SQL statement.
I have two tables in my database (mySQL): portfolio and categories.
In the portfolio table, I have a column called categories, and
there is a number value int here depending on where the item is
placed in my portfolio. So value 1 is web design, value 2 is
hi folks
A query become with STATE set to STATISTICS and all queries after this
query are LOCKED.
What is the decision please.
Best Regards
Bogomil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GV wrote:
> I think is better to have an additional record each time a user
> inserts
> new information
>
> Mr Orange wrote:
>> Hello all,
>>
>> I have a database with a type "longtext" called "notes".
>>
>> Say I wanted to append s
Hello all,
I have a database with a type "longtext" called "notes".
Say I wanted to append some text to this field, what command would I use?
I have tried the following sql..
update clients set notes=notes+"text to append" where id=1;
But this doesn't seem to do the job.
I am new to MySQL so
Hello all : )
Can anyone offer any advice on how to achieve the following with SQL?
Say I have a table.
CREATE TABLE page (
pgposition int(6) not null,
pgelement char(20) not null default '',
pgsize int(4) not null default '0'));
and it has this data in.
1,"TEXT",20
2,"TEXT",
Anybody seen a general page or study guide for the beta test yet? There
used to be a section on the MySQL site
(http://www.mysql.com/training/candguide/sec-core.htm) but its 404 now and
taking the test here in a couple days. Looked around on the site but the
information doesn't seemed to around a
Why not just split that field up into multiple fields. Seems ridiculous to
have multiple values in a single field in a RDMS
-Peter
> -Original Message-
> From: Paul van Brouwershaven [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 16, 2002 14:46
> To: [EMAIL PROTECTED]
> Subject: S
Hello,
Been using mysql on w2k for a couple years now and never used the DSN ODBC
connection. See a lot of articles (google/archives/etc) on how to use it ..
but none on why. Any particular reason I would even want to use ODBC for a
mysql connection as opposed to just directly connecting to it
Following this conversation myself (also a perl db newbie :) ... before
always just used php) and curious if you know definitely what db vendor you
are going to be using (mysql in this case), any reason to use dbi; as
opposed to just using vendor specific or net::mysql; . Is it just a
portability
Hi all,
I have recently downloaded mysql version 3.23.45 and I am struggling to get it to
start.
Every time I type in ./safe_mysqld the program starts and then shuts down immediately
with the following being written to the error log:
---
Hello,
After a year of doing database programming, try to actually normalize. Read
a couple online tutorials (phpbuilder, devshed) and the book mysql 2nd
edition and it just can't seem to stick. Understanding the concept/theory
but freeze up every time I try to implement. Trying to go from 0NF
Hello everybody
I'd like to know what does that means: "Writing to net" in the state row of
processlist.
I have to launch a perl script which do traitement on a mysql table with
1.750.000 records.
The request blocks during a long time everytime on the select of the hole
table and i can see in
saraswathy saras wrote:
> Hi everybody,
>
> Can anybody help me?
I'll give it a shot.
> is there any other specific command instead order by ID DESC to select
> all the record from table where the ID is the last ID.The ID is
> autoincrement.
Try this:
select last_insert_id() as ID from TA
i got a MySQL database that my supervisor wats me to do an ER diagram
for. The problem is that there is no/not much documentation on this
database. Also one cannot draw an ER-Diagram by looking at the mySQL-
Database, since there is no way (i know of) i can defining logical
relationships especi
Patrick,
Try this from your shell:
You want to flush the tables (I'm assuming you want to keep the database
up and running), do a recover, safe recover, and check to make sure you
don't get the error messages when everything is finished.
$ mysqladmin flush-tables
$ myisamchk -r -o /var/lib/mys
I'm in the process of converting all of my database tables from ISAM to
MYISAM table format. I'll run the mysql_convert_table_format script
which basically does an "Alter table". If during this conversion
someone accessed a web page which writes to the database (insert or
update), what will
Hi all,
My problem goes away after I have upgraded MySQL from
3.23.41 to 3.23.46. Thanks you for anyone who have
made suggestions or who have tried to figure out the
solution.
Kent.
--- Mr Kent Cheung <[EMAIL PROTECTED]> wrote:
> Date: Wed, 30 Jan 2002 20:01:21 -0800 (PST)
> F
u, 31 Jan 2002 12:12:01 +0200
> To: [EMAIL PROTECTED]
> From: Egor Egorov <[EMAIL PROTECTED]>
> Subject: Table names case sensitivity
>
> Mr,
>
> Thursday, January 31, 2002, 6:01:21 AM, you wrote:
> MKC> Dear MySQL community,
>
> MKC> I am new MySQL user. I w
wrote:
> > -Original Message-
> > From: Mr Kent Cheung
> > [mailto:[EMAIL PROTECTED]]
> >
> >
> > >SELECT * FROM Company;
> > >
> > >Then, an error occurs that tells me that the user
> > xxx
> > >is not allowed select the ta
Dear MySQL community,
I am new MySQL user. I want to migrate a M$ SQL Server
database to MySQL in a Linux box. Since table names in
MySQL@Linux is case sensitive, I am having troubles
connecting to the server via ODBC from a Windows box.
I search the documentation and find that I may be able
to
I am a new user to MySQL. The server is running, but I keep getting the
following error:
Host 'www.usapa.army.mil' is not allowed to connect to this MySQL
server.
When I enter the mysqladmin version command, I get the following:
mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linu
Hi everyone
This is the first time I have posted to this list and I was wondering if
someone could answer my question. I know you can run commands from a
shell prompt (such as unix...) like:
shell> mysql -e 'SELECT * FROM table' database
for a simple select query and
shell> mysqlimport --loca
>
>database,sql,query,table
>Can someone please tell me why this won't work.
>
>if (defined($res)){
> my $stmt = qq{select distinct symbol from portfolio where $res};
> my $sth = $dbh->prepare($stmt);
> $sth->execute();
>
> my $portsymbols = "";
>
> while ($sth->fetchrow) {
> $portsymb
Hi~
I have trouble with ssh tunneling.
I run this command as you told.
[wertyu@inos ~]$ ssh -L 12345:localhost:3306 localhost
Secure connection to localhost refused; reverting to insecure method.
Using rsh. WARNING: Connection will not be encrypted.
localhost: Connection refused
what's the pr
Why don't you try like this.
F:\\devkunde\\SENDTNER\\
'\' is escape character. so you must
use '\\' to insert '\'.
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
--
How would one load the results of the following query into a one line comma
separated list so that it could be then included with an IN expr to get
around the lack of subselect in MySQL
select distinct symbol from portfolio where type='401k' AND owner='jim'
select distinct p.symbol, i.name f
Would anyone know how the query below could be written to support MySQL?
my $stmt = qq{select distinct p.symbol, i.name
from portfolio p, stockinfo i
where p.symbol = i.symbol };
$stmt .= qq{and p.symbol in
(select distinct symbol from portfolio where $res)
I installed Embedded MySQL( compiled --with-embedded-server)
And I compiled source code from Manual.
(I did not modify the source)
compiled nicly, but I run the Embedded MySQL,
Segmentation fault occured
[wertyu@inos prog]$ ls
Makefile mysqld* mysqld.c mysqld.c~
[wertyu@inos prog]$ ./mysqld
Happy New Year!
I'm Sorry if this question has been posted often.
but i cannot find answer.
I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio
And...
mysql> SHOW VARIABLES LIKE '%ssl%' ;
+---+---+
| Variable_name | Value |
+---+---+
| have_o
I'm Sorry if this question has been posted often.
but i cannot find answer.
I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio
And...
mysql> SHOW VARIABLES LIKE '%ssl%' ;
+---+---+
| Variable_name | Value |
+---+---+
| have_openssl | YES |
You should use "binary" attribute.
mysql> select binary "fff " = "fff" ;
+-+
| binary "fff " = "fff" |
+-+
| 0 |
+-+
1 row in set (0.28 sec)
mysql> select "fff " = "fff" ;
+--+
| "
Hi!
I'll be happy if I know that when "Stable version 4.0" will be released.
Thanks!
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
--
WORK AT HOME USING YOUR COMPUTER!!!
_
Dear Friend,
You can earn $46,000 or more in next the 90 days sending e-mail.
Seem impossible? Read on for details (no, there is no "catch")...
___
My setup:
Dell PowerEdge 4200 with 512 mb ram, plenty of free disk space
WinNT Server 4.0 with sp6
MS Access 97
MySQL 3.23.38-nt (installed binany from mysql-3_23_38-win.zip)
MyODBC 2.50.38 (installed from myodbc-2_50_38-nt.zip)
My objective:
Copy data from two large MS Access 97 to MySQL tabl
(I'm sorry if my question does not fit to this
mailing list)
Hi~ there.!
Is there A Book about implementing RDBMS?
I just found "Database System Implementation"
written by Ullman.
looking for another Book if there is.
Monty, What's the Best Resource(helping you) when
you have started making "
I have made a script in PHP which creates a table in my MySQL database on Linux
environment.
When I run the script and give the name of table to create, there isn't problem if I'm
using ASCII; but if I use a Japanese Charater encoded (JIS), I'm getting error message
on those encoded characters
Hi~~~
My SHOW PROCESSLIST's output
| 22 | unauthenticated user | 10.169.xxx.xxx || Connect | | login |
what 'unauthenticated user' means?
who is he?
anonymous user?
Thank you for your advanced answer!
database
--MIME Multi-part separator--
Hi there,
A DB newbie question - can I use MS Access for remote mySQL databases using myODBC??
Thanks.
63 matches
Mail list logo
