Howto: insert PHP code into mysql blobs
Just a noob question... (I suppose)
When I try just putting php code in my insert query, it goes like this:
insert into mytable values('')
select * from mytable, returns:
Some string
Any help would be greatly appreciated!
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- e-shop B2C B2B
Hello ,all I am developing an online store for a small or medium business. This is my degree project and I hope to turn it into something larger. A question came up. How can I organize this with MySQL/PHP/Apache for high availability? We had thoughts about a mirrored database. But then, how would you set up a hot swap? i.e. if the primary database fails, bring up the mirrored database? This is an interesting question in general. I would be grateful for any information or links. -- Best regards, maxim mailto:[EMAIL PROTECTED] - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Memory Leak ??
On Thu, Apr 11, 2002 at 12:05:45PM -0700, Steven Deaton wrote: > > I am having a problem with a mysql server that I have that starts up > with about 10-15 processes at 12MB each.and then JUMPS to a > couple hundred processes at 100MB each. in just a couple minutes > time. Can you get a processlist from MySQL when that happens? That'd be helpful in understanding what's going on. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,563,906 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: nvarchar
On Thu, Apr 11, 2002 at 06:47:39AM +, saraswathy saras wrote: > hi, > > what is the function of nvarchar...is it can use in mysql7. Huh? -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,588,428 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: performance for single/multiple databases
On Wed, Apr 10, 2002 at 12:12:32AM -0500, Truong Thai wrote: > > I have a performance question between having a single database for > all tables or splitting up tables into multiple databases. > > The hosting service I use charges extra for multiple databases. > Using PHP/MySQL for website. > > I currently have 12 tables in one database. Are there any > performance advantages if I create 3 databases and split up the > tables? No. The only real performance advantages would appear if you had 300,000 tables in a single database. (I made that number up.) The difference between 3 and 12 or even 1,000 just isn't significant. > Also, if I split up the databases...how would i perform > a table join from two tables which are in different databases. Fully qualify the names, such as: mydb.mytable.mycolumn Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,526,716 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table - query help
On Tue, Apr 09, 2002 at 09:38:47AM -0500, Aman Raheja wrote: > I want to alter 50 tables, and for each the names start with the > string 'mak' Is there an SQL query, so that I can do the change in > one command. Nope. You need an outside programming language to do it. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,511,277 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to automate bin-log clean-up with replicated MySQL servers?
On Thu, Apr 11, 2002 at 09:46:18AM -0400, Marc Prewitt wrote: > We have a slightly smarter script which checks each slave to find > the furthest one behind and purges up to that number. However, it > currently figures out who the slaves are by checking a process > status on the master. Unfortunately, this doesn't work if one of > your slaves is down. So, I'm going to rewrite it to check the known > slaves. Yeah, there are a lot of ways to skin that cat. I've debated trying to come up with something smarter, but never bothered. We've got a heartbeat mechansim monitoring all our slaves, so I get mail/paged if any one falls to far behind (more than 2 minutes). Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,480,055 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: conditionnal loops in mysql
On Tue, Apr 09, 2002 at 10:01:25AM +0200, Van Overbeke, Tom wrote: > > now, i'd like to change each record in table1 where a field contains > a +ADSM entry, lookup the corresponding records in table 2, and, in > this case for example, add 3 records to table1 where the +ADSM field > is replaced by anr2343e in record 1, anr4523e in record 2 and > anr7823e in record 3. > > But i have no idea if this is possible in mysql, and if it is, how I > should do it. MySQL is mainly for data storage and retrieval. You'll want to use a programming languages such as Perl, Python, PHP, C/C++, Java, etc. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,460,856 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: slow to a crawl
On Wed, Apr 10, 2002 at 08:39:03PM +0200, Benjamin Pflugmann wrote: > > Hm. From vmstat output it looks like the second query is disk-bound on > writing. Most probably writing temporary table(s) as EXPLAIN tells so > (compare http://www.mysql.com/doc/E/X/EXPLAIN.html). Agreed. [snip] > Well, to sum up: Your first query mainly seems to be bound on disk > read speed (your table is about 1GB?). The second one needs a much > larger tmp table (which it also has to sort!) and "trashes" your disk, > that's probably why the machine feels unresponsive. That's what I'm thinking as well. > For now, I have no further ideas than playing with "tmp_table_size" > and trying to use an index over all column. Please do post the results. I'm very curious to see what helps. I don't expect an index to make any difference. But ya never know. > Anybody else? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,432,003 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Facing problems in transaction control
Dear Sir / Madam We at www.axistech.com are developing a web based application that requires transaction control we are using java 1.3 , jsp and MySql MySQL 3.23.49 we will be using windows version and linux version we would like to know which of the windows version supports --- Transaction locking through java the specific driver and the specific database for windows the specific driver and the specific database for linux ---Row level locking the specific driver and the specific database for windows the specific driver and the specific database for linux looking for your precious suggestions at the earliest we will highly appreciate if u can send the links of the relevant information kindest regards Mukul Jaggi __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB tables
On Tue, Apr 09, 2002 at 10:17:56AM +0200, Luke van Blerk wrote: > Hi everyone, > > I've been reading up about InnoDB tables and they seem to have lots > of advantages. I'm particularly interested in using the foreign keys > as this will save me some much need time. In the benchmark tests on > the InnoDB website they show up faster than MyISAM tables That's a great sign for you. :-) > but will foreign keys have a slow down effect? And are there any > issues I need to know about before switching to InnoDB tables? Of course things will be slower with foreign keys. The question is how much slower. I suspect that the difference will be very, very minor. But why not run a benchmark with FKs and see? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,288,043 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: prefix
On Tue, Apr 09, 2002 at 05:45:04PM -0700, David Turner wrote: > Thanks, but what I need to do is have > > make install install everything into /home/turner/mysql/test then > I'll check everything out to make sure it is how I want it and last > I'll copy it all to /usr/local. > > Any way to do this > > ./configure --prefix=/usr/local (default) > make > make install prefix=/home/turner/mysql/test Not that I know of. I belive some of the paths are compiled into MySQL, so recompilation is necessary. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,174,978 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Bug
On my computer both old 'stable' releases and new alpha downloads of MySQL report this error: 020411 21:21:31 Can't find messagefile 'c:\mysqin\share\english\errmsg.sys' 020411 21:21:31 Aborting Although I have checked several times for the files existence. Any Idea? - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication problem
Hi. I got the problem with replication if I use SQL command "LOAD DATA INFILE..." to update data in master table the data change to the new one correctly but in slave table nothing happen the data still have the old value. how to solve this problem ?? Kittiphum Worachat,M.T. www.hatyailab.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication incompleteness problem
A couple of questions below:
Wendell Dingus wrote:
>
> ...
>
> cron entries:
> -
> Server2:
>
> 20 4 * * * /etc/rc.d/init.d/mysql stop 1>/dev/null 2>/dev/null
> #
> 25 4 * * * /bin/rm -f /var/lib/mysql/master.info 1>/dev/null 2>/dev/null
Why are you deleting master.info? It's my understanding that this is
where the replication position is stored. The slave will loose it's
position if you do this, I believe.
> #
> 30 4 * * * /etc/rc.d/init.d/mysql start 1>/dev/null 2>/dev/null
>
> Server1:
>
> 0 4 * * * /usr/bin/mysql -uroot -px /dev/null
> 2>/dev/null
> Note: File "fl" contains "flush master;"
Are you sure the command you are using is flush master and not PURGE
MASTER LOGS TO {logname}
That is normally how the old master logs are deleted.
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: binlog and replication stuff
Yes. Davide Giunchi wrote: > > FLUSH LOGS in the master and all is ok? binlog will be rotate and slaves will > see it, continue to work and update master.info? > > Regads > > Il 15:31, giovedì 11 aprile 2002, hai scritto: > > FLUSH LOGS safely rotates the binlog. > > > > Davide Giunchi wrote: > > > You are right, but my master generate about 150Mb of binlog x day, i a > > > slave fail after 4 day it will reexec a lot of query and take some time. > > > how can i safely rotate the log in master+slaves without restarting them? > > > The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 (or > > > > 001) file, but what about if the binlog is always the same? > > > I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the > > > slaves, it wouldn't loose the sync? > > > > > -- > Davide Giunchi. > Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it > GPG Key available on http://www.keyserver.net > Fingerprint: 8075 363A B4FA 0196 FEEC AF9C 19A9 66C7 CDAB D0D5 - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Math Computations
Hi Adam,
Thanks for your reply.
How about if I have more than 3 rows and I'm continously adding entries in
my table. What do I need to do?
Delz
- Original Message -
From: "Adam Alkins" <[EMAIL PROTECTED]>
To: "delz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 5:44 PM
Subject: Re: Math Computations
> Something like
>
>
> $db = mysql_connect("localhost","database_user","password");
> mysql_select_db (database_name);
>
> $query = "SELECT * FROM table_name";
> $result = mysql_query($query);
>
>
> echo "Computers | Department | Price Per PC | Total Amount";
>
> while ($row = mysql_fetch_row($result)){
> $subtotal=$row[0]*$row[2];
> $total+=$subtotal;
> echo "$row[0] | $row[1] | $row[2] | $subtotal";
> $comptotal+=$row[0];}
> }
> echo "$comptotal $total";
>
> ?>
>
> Obviously format it into a table would make sense, e.t.c.
>
> Adam
> - Original Message -
> From: "delz" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, April 11, 2002 5:29 AM
> Subject: Math Computations
>
>
> > Hi,
> >
> > I have this table that looks like this
> >
> > Computers | Department | Price per PC | TotalAmount |
> > 15 | Marketing | $500.00| |
> > 5 | Purchasing | $ 300.00 | |
> >
> > I want this table to display the total price wherein Computer * Price
Per
> PC
> > = TotalAmount
> > and want to display the total no. of computer and the OverAll
TotalAmount.
> >
> > I want the output to look like this
> >
> > Computers | Department | Price per PC | TotalAmount |
> > 15 | Marketing | $500.00| $ 7500.00 |
> > 5 | Purchasing | $ 300.00 | $ 900.00 |
> > - ---
> > 20 $ 8400.00
> >
> > Can anyone help me how to do this in mysql or php. I will surely
> appreciate
> > any help I
> > can get.
> >
> > Thanks.
> >
> > Delz
> >
> >
> > -
> > 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 PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
>
>
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
regarding libmysqlclient and libmysqlclient_r
Hi,
I'm using the mysqlclient_r library to access the database.
I have written some code as an interface to access the MYSQL databse and
have written the following test code to test the library.
I'm using Linux 2.4.4-4 as the platform.
I'm putting locks around my entire test case so that two threads do not
share the same connection at the same time.
as suggested earlier I have also built the library with local pthreads
i.e. --with-pthread=-pthread or --with-pthread=-lpthread
This code still is not working when compiled with libmysqlclient_r
but works with libmysqlclient.
The following is the code with places of my_init(), my_init_thread(),
and my_thread_end().
Since I'm new to using this library I would be grateful for any kind of
guidance on where I'm going wrong.
regards,
void * threadTest2(void *jl){
int *te = (int *)jl;
int t1 = (*te);
// my_thread_init();
test2(t1);
my_thread_end();
pthread_exit((void *)NULL);
}
void startThreadsTest2(){
Init();
my_init();
int ThreadNum[MAXTHREADS];
int i;
for(i = 0; i < MAXTHREADS; i++)
ThreadNum[i] = (i + 1);
pthread_t threads[MAXTHREADS];
for(i = 0; i < MAXTHREADS; i++){
my_thread_init();
pthread_create(&threads[i], NULL, threadTest2, (void*)
(ThreadNum +i));
}
for(i = MAXTHREADS - 1; i >=0 ; i--)
pthread_join(threads[i], NULL);
cout << endl << endl;
for(i = 0; i < MAXTHREADS; i++)
cout << "SuccessQuery[" << (i + 1) << "]: " << SUCCESS_QUERY[i]
<<
endl;
cout << endl << endl;
for(i = 0; i < MAXTHREADS; i++)
cout << "failureQuery[" << (i + 1) << "]: " <<
FAILURE_QUERY[i] <<
endl;
}
void test2(int l = 0 ){
//LOCK
pthread_mutex_lock(&lockmutex);
FASDBConnection conn1;
conn1.Connect("lithium.ini.cmu.edu","shivam_test","shivam","shivam_pass");
if(conn1.isConnected())
cout << "Success Connection" << endl;
else
cout << "Failed Connection" << endl;
for(int i = 0; i < 1000; i++){
string query = "SELECT * from STUDENTS ";
FASDBStatement *r = conn1.createStatement();
FASDBResult rr;
rr = r->ExecuteQuery(query);
int num = rr.getNumRows();
if(num == 0){
cout << "Query failed number: " << (i+1);
if(l != 0){
//FAILURE_QUERY[l-1]++;
cout << " Failure Thread Num: " << l;
}
cout << endl;
delete r;
continue;
}
// SUCCESS_QUERY[l-1]++;
cout << "QUERY NO." << i << endl;
while(rr.nextRow()){
FASDBRow row = rr.getCurrentRow();
cout << setw(10) << row.getString(0);
cout << setw(10) << row.getString(1);
cout << setw(10) << row.getInteger(2) << endl;
}
cout << "Index : " << (i+1) << "ThreadID: " << l << endl;
delete r;
}
conn1.Close();
//UNLOCK
pthread_mutex_unlock(&lockmutex);
}
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL 4.0 Beta
On Thu, Apr 11, 2002 at 07:16:34AM -0700, va ku wrote: > Hi, > > We want to use only MYSQL4.0 for our production database. Please > let us know when the Beta release is scheduled. When it's ready. :-) Seriously, check the archives. This comes up a lot and the answer is nearly always the same. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,712,129,532 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with very large Indexes
On Thu, Apr 11, 2002 at 10:46:43AM +0200, Stefan Siefert wrote: > Hi all, > > we have a little problem with the size of our index file. We need to > set a lot of combined Indexes and singel Indexes (we have a table > with ca. 40.000.000 entries and something about 20 Columns). I'm > pretty sure that the index file will get over the 4 GB size. We use > Linux 2.4.x with a new glibc and MySQL compiled with > --enable-largefile. I'm not sure, but this means we are limited to > at least 4GB per file (or am I wrong?). We have RedHat 7.1 and 7.2 based machines that have files much larger than 4GB on them. We have a 9GB .MYD file in at least one place. There's no reason a .MYI file can't be that large. We're using the standard MySQL binaries on box of those machines. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,712,121,041 queries (312/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access Denied
>Hello, All: > >Once I complete the installation, I try to set up password for root user: > >/usr/bin/mysqladmin -u root -p password 'mypassword' > >It did prompt me for new password, I reentered. The prompt is for your *current* root password. If you don't have one yet, just hit return. > But I got error back: >Connect to server at 'localhost' failed. >Error: Access denied for user root@localhost (using password: yes). > >How can I fix this problem? Thanks in advance for help. > > >Jane Tsai >[EMAIL PROTECTED] - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL concept question
if you are interested in selecting records in the order in which they were inserted, apply an auto-increment/identity field to your table schema and when you select, use ORDER BY on that field. This is the only guaranteed way to retrieve records in the order in which they were inserted. > -Original Message- > From: Thi Cao [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 11, 2002 6:09 PM > To: MySQL > Subject: MySQL concept question > > > All, > > When I insert records into a database, the records will be > inserted in the > order that I have them listed in my insert statement. So my > question is, > will the MySQL database always return the records in the > order of insertion > when I perform any type of select query in the future? Of course, I'm > excluding queries that specify an order with the 'ORDER BY' > clause. Does > the MySQL database maintain some type of internal ordering ID for each > record, and if so, can I always rely on the database to give > me the records > back as I have given to it? I know I can specify an order by having a > column with some type of ordering value, but that's not what > I'm interested > in, so any answers to the above questions would be much appreciated. > > T.I.A. > > Thi > > - > 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 PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL concept question
On Thursday 11 April 2002 4:09 pm, Thi Cao wrote: > All, > > When I insert records into a database, the records will be inserted in the > order that I have them listed in my insert statement. So my question is, > will the MySQL database always return the records in the order of insertion > when I perform any type of select query in the future? Of course, I'm > excluding queries that specify an order with the 'ORDER BY' clause. Does > the MySQL database maintain some type of internal ordering ID for each > record, and if so, can I always rely on the database to give me the records > back as I have given to it? I know I can specify an order by having a > column with some type of ordering value, but that's not what I'm interested > in, so any answers to the above questions would be much appreciated. While I cannot speak for MySQL, you cannot generally rely on this. Certainly, SQL specifications are clear that you cannot rely on this and in general, it is a very bad plan. - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL concept question
All, When I insert records into a database, the records will be inserted in the order that I have them listed in my insert statement. So my question is, will the MySQL database always return the records in the order of insertion when I perform any type of select query in the future? Of course, I'm excluding queries that specify an order with the 'ORDER BY' clause. Does the MySQL database maintain some type of internal ordering ID for each record, and if so, can I always rely on the database to give me the records back as I have given to it? I know I can specify an order by having a column with some type of ordering value, but that's not what I'm interested in, so any answers to the above questions would be much appreciated. T.I.A. Thi - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't change ft_min_word_length on mysql-max
At 13:17 -0700 4/11/02, Kevin Lewandowski wrote: >Hi, All. > >I'm running mysql-max version 3.23.49a-max and am not able to >change ft_min_word_length. It also does not show in the list >when I run "show variables". When I try to specify it on the >mysql command line start mysqld just dies. > >Is this configurable with this version? It's configurable in 4.x. With 3.23.x you have to mess with the source and recompile. By the way, it's ft_min_word_len? - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access Denied
Did you run the mysql_install_db? http://www.mysql.com/doc/P/o/Post-installation.html -- sh On Thu, 2002-04-11 at 13:53, Jane Tsai wrote: > Hello, All: > > Once I complete the installation, I try to set up password for root user: > > /usr/bin/mysqladmin -u root -p password 'mypassword' > > It did prompt me for new password, I reentered. But I got error back: > Connect to server at 'localhost' failed. > Error: Access denied for user root@localhost (using password: yes). > > How can I fix this problem? Thanks in advance for help. > > > Jane Tsai > [EMAIL PROTECTED] > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libmysqlclient on Darwin/OS X
>Heya: > >in openBSD I have a cli interface for simple i/o to mysql database. >Written in C. >it works perfectly. > >On Darwin and OS X it won't compile. >It gives the following errors. > >$ cc -lmysqlclient -I/usr/local/mysql/include testmy.c linklist.c >/usr/bin/ld: Undefined symbols: >_mysql_close >_mysql_error >_mysql_fetch_row >_mysql_init >_mysql_query >_mysql_real_connect >_mysql_store_result > Darwin cc compiler requires the arguments in search order: cc -omytest testmy.c linklist.c -lmysqlclient misread the docs . . . sorry for your trouble. -- Liam Allen [EMAIL PROTECTED] it may be that your sole purpose in life is to serve as a warning to others - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access Denied
Hello, All: Once I complete the installation, I try to set up password for root user: /usr/bin/mysqladmin -u root -p password 'mypassword' It did prompt me for new password, I reentered. But I got error back: Connect to server at 'localhost' failed. Error: Access denied for user root@localhost (using password: yes). How can I fix this problem? Thanks in advance for help. Jane Tsai [EMAIL PROTECTED] - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't change ft_min_word_length on mysql-max
Hi, All. I'm running mysql-max version 3.23.49a-max and am not able to change ft_min_word_length. It also does not show in the list when I run "show variables". When I try to specify it on the mysql command line start mysqld just dies. Is this configurable with this version? thanks -Kevin __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: search pattern matching
HI CRAIG, i'ts possible to use this query with multiple search terms? query: "select * from TABLENAME where if(right(SEARCHFIELD,1)='s',left(SEARCHFIELD,lenth(SEARCHFIELD)-1),SEARCHFIE LD) like '%SEARCHTEXT%' " i.e: one user search for: "passaros jogos campos" [in portugueze] the app is written in perl...forum system.. tanks, Lucas >I don't believe you could do that with a single SQL statement. The best >way would be to build intelligence into an application that would look at >the search term, determine if it is a plural by looking up it some sort of >dictionary, and then use the singular in the form %singularsearchterm%. It >gets complicated because this varies from language to language. While, I >don't like it, here is a 'quick and dirty' sql statement that will look at >the term, if it ends in s, it then drops the s. But don't forget about >words like DOS, was, houses, Ross, etc. These would all cause problems >using this simplified method (not to mention terms in other languages). >select * from TABLENAME where >if(right(SEARCHFIELD,1)='s',left(SEARCHFIELD,lenth(SEARCHFIELD)-1),SEARCHFI ELD) >like '%SEARCHTEXT%' >Hope this sheds some light on it! >Craig Ostrander - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Converting VARCHAR 255 column to TEXT 64
It'll expand the limit. You'll lose the data if you convert from a larger form back to a smaller one. ( Text to Varchar.. if the text is longer than 255. ) -- sh On Thu, 2002-04-11 at 12:09, Alex Pilson wrote: > Does converting one type of column to a bigger type such as listed in > my subject lose the information that is contained in that row/column > or does it just expand the limit? > -- > <-> > Alex Pilson > FlagShip Interactive, Inc. > [EMAIL PROTECTED] > 404.728.4417 > 404.642.8225 CELL > > // Web Design > // Lasso Application Development > // Filemaker Pro / SQL Development > // Sonic Solutions Creator Authoring > // Apple DVD Studio Pro Authoring > // Macromedia Director/Flash Authoring > <-> > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Converting VARCHAR 255 column to TEXT 64
Does converting one type of column to a bigger type such as listed in my subject lose the information that is contained in that row/column or does it just expand the limit? -- <-> Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macromedia Director/Flash Authoring <-> - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Memory Leak ??
I am having a problem with a mysql server that I have that starts up with about 10-15 processes at 12MB each.and then JUMPS to a couple hundred processes at 100MB each. in just a couple minutes time. What can cause this, other than just some loop in a script? Any ideas anyone? This is on a system with the following config: mysql Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i686) (mysql -v) Linux 2.4.5-beta4va3.17smp-piii #1 SMP Wed Jun 20 22:10:48 PDT 2001 i686 unknown (uname -a) Red Hat Linux release 6.2 (Piglet) (cat /etc/redhat-release) (this is actually VALinux) 2GB ram (free) 48GB hdd (raid5) (df) Any help anyone can provide would be greatly apprciated.thanks. :) TIA ---Steven - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Possible issue with long pathnames and socket locations.
>Description: The first of these problems is the long pathname. I've already tracked this down and fixed it in a local copy. The problem is that in the files: libmysql/errmsg.c libmysql_r/errmsg.c mysys/my_vsnprintf.c sql/mini_client_errors.c The space for the path in the error message is fixed to a length of 64 characters while the maximum pathname is much longer (256) This produces error messages that are "misleading" The line below that starts with "error: " shows you the truncated error message while the next line shows you the entire/full pathname of the file at issue. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ending Tests Shutting-down MySQL daemon Master shutdown finished mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/dvlp/home/mtiernan/Work/Post_40/unix/optional/public_domain/WHC' (146)' Check that mysqld is running and that the socket: '/dvlp/home/mtiernan/Work/Post_40/unix/optional/public_domain/WHCmysql/distrib/src/SunOS-5.7/mysql-3.23.49/mysql-test/var/tmp/mysql-slave.sock' exists! Slave shutdown finished gmake[1]: *** [test] Error 1 gmake[1]: Leaving directory `/dvlp/home/mtiernan/Work/Post_40/unix/optional/public_domain/WHCmysql/distrib/src/SunOS-5.7/mysql-3.23.49' make: *** [build.SunOS] Error 2 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= The second issue is with the location of the socket that it is looking for. The configure command specified the socket as: --with-unix-socket-path=/wh/var/tmp/mysql.sock and yet it seems to be searching for the socket in the wrong place based on the current test environment. (Which MAY be a desired feature for testing...) >How-To-Repeat: >Fix: Remove the limitation of the length of the path field: <84:sql/mini_client_errors.c: "Can't connect to local MySQL server through socket '%-.64s' (%d)", >84:sql/mini_client_errors.c: "Can't connect to local MySQL server through socket '%s' >(%d)", Please note, I only show you ONE occurance of it but this problem exists in MANY of the library functions. >Submitter-Id: >Originator:Mike Tiernan >Organization: GENUiTY Web Hosting Engineering. (Being used for personal experience, not corporate sanctioned activities.) >MySQL support: none >Synopsis: Truncated error messages are output. >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.49 (Source distribution) >Environment: System: SunOS whe-inf-101.bbnplanet.com 5.7 Generic_106541-17 sun4u sparc SUNW,Ultra-Enterprise Architecture: sun4 Some paths: /wh/bin/perl /wh/bin/make /wh/bin/gmake /wh/bin/gcc /wh/bin/cc GCC: Reading specs from /wh/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1707532 Oct 15 19:23 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 24 2000 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 Oct 15 19:23 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1707532 Oct 15 19:23 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 24 2000 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 Oct 15 19:23 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/wh --with-mysqld-user=mysqladm --with-named-z-libs=no --with-unix-socket-path=/wh/var/tmp/mysql.sock - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database setup
Sorry I am still having some problems with how to create random security
keys. Would you mind please give me an example code? A few lines is fine. My
codes are as follows.
Regards,
Norman
// connect to mysql
$authdb = mysql_connect('localhost', 'webauth', 'webauth')
or die("Cannot connect to database.");
// select the appropriate database
mysql_select_db('auth')
or die("Cannot select db.");
// query the database to see if there is a record which matches
$query = "select * from auth where
usrname='$HTTP_POST_VARS[logname]' and
usrpass=md5('$HTTP_POST_VARS[logpass]')";
$result = mysql_query($query)
or die("Cannot run query.");
$row = mysql_fetch_row($result);
if (mysql_num_rows($result) > 0)
{
if (($row[0]==1) || ($row[0]==2))
{
echo "Successful.";
die();
}
}
else
{
echo "Go Away!";
echo "You are not authorized to view this resource.";
die();
}
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Norman Zhang'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 11:29 AM
Subject: RE: database setup
First, I assume that the same value for "userlevel" may be used by multiple
users. That is, multiple users can have userlevel equal to 1 or equal to 2
or 3 or whatever. Therefore, you CANNOT use userlevel as PRIMARY KEY.
PRIMARY KEY is a UNIQUE identifier. Thus, I recommend that each user be
identified by a unique user_id.
user_id int unsigned not null primary key,
userlevel unsigned tinyint not null,
username char(8) not null,
userpass char(16) not null,
security_key int
Next, once the user is authenticated, you can pass value of user_id through
sessions, to preserve security. Include with the session values a unique,
random key that is generated during authentication. Store this random key
in security_key. When a user makes a download/upload request, ensure that
the key stored in the database is the same as that of the session.
-Original Message-
From: Norman Zhang [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 12:49 PM
To: [EMAIL PROTECTED]
Subject: database setup
Hi,
I am setting up a mysql database, with two tables. One keeps the user
authentication info such as user name, password and user level. The other
table with contains files for upload and download. Is there a good way to
setup the user authentication table so it can check appropriate user rights
(user level) then provide the appropriate upload or download page?
I came up with a scheme as follows,
userlevel unsigned tinyint not null primary key,
username char(8) not null,
userpass char(16) not null
I can store user passwords using MySQL's password encryption. But when I
need to access the upload/download table I need to somehow notify the
database that what level of access the user has. If I set userlevel=1 (or
any number) after succesful authentication in the script, I would
compromised the other table. As hackers can change userlevel in the php
script without going through the authentication. Can someone please provide
me a couple of pointers how I go about setting up my database? TIA.
Regards,
Norman
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: EMS MySQL Manager 1.7 released
Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.7) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.7? 1. MySQL Manager Direct feature was added. Now you can easily check for MySQL Manager updates and download the latest version just from the application. Use "Help->MySQL Manager Direct" menu item to open the MySQL Manager Direct window and click the Update button to receive the latest information about MySQL Manager. 2. Now it is possible to invoke Export Data, Export Data As INSERT statements, Import Data and Load Data functions directly from the DB Explorer. Just select the table in the DB Explorer tree, right-click for the popup menu and choose the required item from Data Manipulation submenu... (*) 3. The ability to export all the MySQL Manager settings was added. Now you can easily export all or partial MySQL Manager settings (such as registration info of the databases, environment or editor options) to single *.reg file, which you can apply to MySQL Manager installed on another machine or use to restore the previous settings. You can run the export wizard through "Options->Save settings" menu. 4. Load Data Wizard now works properly with libmysql.dll library compiled without local-infile option. 5. Commit/Rollback dialog now does not appear if connection to server is lost. 6. Fixed some bugs with localization of multiple instances of table editor window and SQL Editor. 7. Some minor bugfixes and small improvements. (*) - Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: About escape character '\'
sorry, I should say add 3 extra '\' and not just one in my previous
email, since if I add 3 more and it becomes:
"INSERT INTO files (filepath) VALUES ('c:RepositoryPack')"
which represents the following string in Java:
"INSERT INTO files (filepath) VALUES ('c:\\Repository\\Pack\\')"
(because in Java '\' is also an escape character)
So, in MySQL 'c:\Repository\Pack\' will be inserted, while in MS SQL and
Oracle 'c:\\Repository\\Pack\\' will be inserted and that's the problem
for me...
-Original Message-
From: Bill Easton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 7:27 AM
To: [EMAIL PROTECTED]
Cc: Kathy Sung
Subject: Re: About escape character '\'
Kathy,
You shouldn't have a problem here--it's Java, not MySQL, that requires
the
doubled '\' in a string literal.
In Java, the string literal:
"INSERT INTO files (filepath) VALUES ('c:\\Repository\\Pack\\' )"
represents the string whose content is
INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\' )
so what gets inserted is, in fact,
c:\Repository\Pack\
> Subject: About escape character '\'
> Date: Wed, 10 Apr 2002 19:44:21 -0400
> From: "Kathy Sung" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
> Hi all,
>
> I want to insert the string 'c:\Repository\Pack\' into a mysql table
> using java and I did it as follows:
>
> sql =3D "INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\'
)";
> insertStmt.execute(sql);
>
> I got an error and I know I should add an extra '\' to escape each of
> the '\' in the above sql statement. But, the problem is MS SQL and
> Oracle do not treat '\' as an escape character in sql statements, and
I
> want to keep my Java program as database-independent as possible. (and
I
> don't want the whole string 'c:\\Repository\\Pack\\' to be stored in
the
> database when I use MS SQL server or Oracle)
>
> Any suggestion to my problem will be greatly appreciated.
>
> Thanks,
> Kathy
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about Chinese Windows XP and MySql
Anyone has experience with Chinese Windows Xp Professional and MySql? I am not able to install MySql on Chinese Windows. I got an unknown character error message (The package I am using is from Canada). Do I have to use the package from Asia (China, Taiwan or Hong Kong). Please advise. Thanks in advance. Andrew _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: row count in tables
figured it out... - Original Message - From: "destr0" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 11:51 AM Subject: row count in tables > sql, query > Is there a built-in to get the number of rows in a table.. > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
row count in tables
sql, query Is there a built-in to get the number of rows in a table.. - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL package on HPUX, REDHAT and Windows
Hi, I am looking for MySQL package on HPUX, REDHAT and Windows. Can anyone tell me where I should look for standard package for MySQL? For HPUX, I found one at: http://hpux.cs.utah.edu/hppd/hpux/Development/Languages/mysql-3.23.42/ Thanks a lot! Zengfa __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqladmin
Thanks Egor, I just did it now and I find that. I start the installation today so that's I am missing some elements. Again thanks for your help. Hisseine - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 12:22 PM Subject: Re: mysqladmin > Hisseine, > Thursday, April 11, 2002, 7:13:58 PM, you wrote: > > HD> I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm > HD> I did the installation on linux redhat 7.2, everything is ok, but I can't > HD> locate the msqladmin command. > HD> I try find command as root but nothing in the result. > HD> Does binary files are missing in this version? > > mysqladmin is a client-side utility. You should install client package of the MySQL. > > HD> Thanks, > HD> Hisseine > > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqladmin
Hisseine, Thursday, April 11, 2002, 7:13:58 PM, you wrote: HD> I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm HD> I did the installation on linux redhat 7.2, everything is ok, but I can't HD> locate the msqladmin command. HD> I try find command as root but nothing in the result. HD> Does binary files are missing in this version? mysqladmin is a client-side utility. You should install client package of the MySQL. HD> Thanks, HD> Hisseine -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin
Hi all, I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm I did the installation on linux redhat 7.2, everything is ok, but I can't locate the msqladmin command. I try find command as root but nothing in the result. Does binary files are missing in this version? Thanks, Hisseine - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About BLOBS
Hisseine, Thursday, April 11, 2002, 5:21:09 PM, you wrote: HD> Does MySqL database supports BLOBs operation? (Insert, delete etc ...) HD> If yes which API can use to do these operations? (MySqL++)? BLOB are just the same thing as other field types. You can use INSERT, UPDATE, DELETE statements to work with tables that has BLOB fields. You can read about BLOB types at: http://www.mysql.com/doc/B/L/BLOB.html To add file to the BLOB column you can use LOAD_FILE() function, look at: http://www.mysql.com/doc/S/t/String_functions.html If you don't use LOAD_FILE don't forget to escape special chars in your query. See http://www.mysql.com/doc/S/t/String_syntax.html for more info about strings and blobs. In the MySQL++ documentation you can find example how to load binary file to a BLOB column, look at: http://www.mysql.com/documentation/mysql++/4_Tutorial.html#SECTION03161000 HD> Thanks for help -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myODBC
Andrew, Wednesday, April 10, 2002, 7:26:01 PM, you wrote: AH> I'm trying to use the old MS Visio Modeler with mysql. I have AH> downloaded and installed the myODBC driver and set up a DNS. But I keep AH> getting this connection error: AH> "Can't connect to MySQL server on 'www.jsicorp.com'(10060)" AH> I set the username and password the same as what works with phpMyAdmin. Is your MySQL server running? Check it using telnet. Look at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html You can find description of error there, it may help you. AH> Any thoughts? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE:PHP Question
Thanks for all of you who responded with ideas. I think I'm going to go with the temp page,redirect solution. Seems to me that this is the simplest and easiest way to deal with it. I could have dont it with MySQL as some one stated by entering a unique identifier andkeeping track of that, but generating and passing that around could become a hassel, and Iknew there must have been a better way. Thanks again, -Nick - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Another question of Date.
Hi, > I got a small problem I like to be able to read a DATE but I don't want to > read the Year. I only want to read the month and the date. For example, I > like to read the a Birthday Field to see who Bithday is today. > Also like to > be later be able to read that same field but this time the year so that I > can see how old a person is. Is there any example on the net of this? I think what you really want is the following functions: * DAYOFMONTH() * MONTH() * YEAR() They all take as an argument a date field and return the appropriate part of the date. There are similar functions for hours, mins, secs, etc. See this section of the manual for more info: http://www.mysql.com/doc/D/a/Date_and_time_functions.html So, using your example of finding all records with date of birth the same as today, regardless of year, we would issue a query like this: SELECT dob FROM yourtable WHERE MONTH(dob) = MONTH(NOW()) AND DAYOFMONTH(dob) = DAYOFMONTH(NOW()); And, to see how old a person is, given their date of birth, you would do something like this: SELECT YEAR(NOW() - YEAR(dob) AS age FROM yourtable; Hope this helps. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About BLOBS
Thanks Paul, Hisseine - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Hisseine Dj." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 10:40 AM Subject: Re: About BLOBS > >Hello, > > > >Does MySqL database supports BLOBs operation? (Insert, delete etc ...) > > Yes. > > >If yes which API can use to do these operations? (MySqL++)? > > Any. BLOB columns are just character columns. They need not be > accessed in separate hunks like in some other databases. > > > > >Thanks for help > > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert into select failing and read only tables
SQL SQL SQL SQL hi, i have 2 problems here. 1) i have 2 tables: currency rates +-+ ++ | code char(3)| | currency char(3) | | name varchar(10)| | rate double| | bcurrency char(1 ) | | ryear varchar(4) | | | | rmonth varchar(10) | +-+ ++ I'm have a form, from which i pick 2 value "2000" and "february". I'm trying to insert fields form currency to rates, matching particular conditions in order to avoid data duplication. The rate table basically has the exchange rate for a particular currency in a particular year and a particular month. The trio currency,ryear,rmonth SHOULD be unique. My query is the following: insert into rates (currency,ryear,rmonth) select a.code, "2000", "february" from currency a, rates b where a.bcurrency="N" and a.code<>b.currency and b.ryear="2000" and b.rmonth="february" The error message i get is: "INSERT TABLE 'rates' isn't allowed in FROM table list". How can i solve this problem?? PS:This query works well when i don't add the condition after the first condition in the where clause. 2) i have a "read only table!" error message when i try to execute a "insert into ...select" from a program. How can i check this status of the table?? Is there a command to tell me which table is read only at a particular time? - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP Question
At 09:13 AM 4/11/2002, you wrote: >Ok so this really doesnt have anything to do with MySQL but I thought this >might be a good placeto ask. >Ok heres the problem. I am constructing a Message Board with MySQL and php >(was usingASP) and I dont want the user to reload/repost data. For >example, say the >user goes to post amessage, after they hit the post button it takes them >to a temp page >saying that there post wassuccesful with a link to go view the post. The >problem arises if some one >decides to hit thereload button. Because of the way I have the posting >page setup it will >reload the page and postthe message again! doh! >Anyways, has anyone come up against a similar problem and found a >way around it? > >Thanks in advance. >-Nick Nick, PHP solution. I suppose you could create a session variable with the last topic posted ($last_topic_posted) that gets set in the temp page (confirmation page). The previous page (Post.php) would check to see if the session variable exists when the user presses the "Post" button. If it does it warns the user it was already posted. MySQL solution. You would have to uniquely identify each post from the user to define a unique index in MySQL. Perhaps use the session id and topic title to prevent two such records from existing in the table. Brent _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About BLOBS
>Hello, > >Does MySqL database supports BLOBs operation? (Insert, delete etc ...) Yes. >If yes which API can use to do these operations? (MySqL++)? Any. BLOB columns are just character columns. They need not be accessed in separate hunks like in some other databases. > >Thanks for help - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP Question
Hi, > Ok so this really doesnt have anything to do with MySQL but I > thought this > might be a good placeto ask. Why? As you say, it's not in any way related to MySQL. > reload the page and postthe message again! doh! > Anyways, has anyone come up against a similar problem and found a > way around it? Take a look at the header() function and please make use of the php-mailinglist next time. :wq //andreas http://phpwizard.dk - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ADODB.Connection- Error
I have the following message since that time I installed the new MS-Securety Patch: ADODB.Connection- Fehler '800a0e7a' Der Provider kann nicht gefunden werden. Möglicherweise ist er nicht richtig installiert worden. can anybody help me? It's an Windows 2000 System (GERMAN) with myODBC 2.5 and mySQL 3.23.43 Mit freundlichen Grüssen Stephan Schröder === Dipl. Ing. Stephan Schröder Software & Entwicklung ProWebMa Hosting GbR Web: http://www.ProWebMa.de === - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP Question
Here's what I do: Insert their post into the database at the very top of the page. Then use php's header() function to forward them to another page after the post has been put into the database. This way, they can reload all they like because they'll no longer be on the page that puts the post into the db. Tyler - Original Message - From: "Nick Stuart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 9:13 AM Subject: PHP Question > Ok so this really doesnt have anything to do with MySQL but I thought this > might be a good placeto ask. > Ok heres the problem. I am constructing a Message Board with MySQL and php > (was usingASP) and I dont want the user to reload/repost data. For example, say the > user goes to post amessage, after they hit the post button it takes them to a temp page > saying that there post wassuccesful with a link to go view the post. The problem arises if some one > decides to hit thereload button. Because of the way I have the posting page setup it will > reload the page and postthe message again! doh! > Anyways, has anyone come up against a similar problem and found a > way around it? > > Thanks in advance. > -Nick > > > > > - > 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 PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql install 3.23.49 *make* cobalt raq2
when running a make i get the follow errors: In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: warning: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/home/redhat/BUILD/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/redhat/BUILD/mysql-3.23.49' make: *** [all-recursive-am] Error 2 Has anyone seen this before? Thanks, Richard - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL COMPILING ON HPUX 11.00
HELLO, ANYBODY HAS COMPILED MYSQL - MAX IN HPUX 11.0 ? THANKS, Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina S.A. __ Visit us On Line at www.equiplus.com Email addresses: Operations: [EMAIL PROTECTED] Consulting: [EMAIL PROTECTED] Technical: [EMAIL PROTECTED] Web related: [EMAIL PROTECTED] General: [EMAIL PROTECTED] - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About escape character '\'
Kathy,
You shouldn't have a problem here--it's Java, not MySQL, that requires the
doubled '\' in a string literal.
In Java, the string literal:
"INSERT INTO files (filepath) VALUES ('c:\\Repository\\Pack\\' )"
represents the string whose content is
INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\' )
so what gets inserted is, in fact,
c:\Repository\Pack\
> Subject: About escape character '\'
> Date: Wed, 10 Apr 2002 19:44:21 -0400
> From: "Kathy Sung" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
> Hi all,
>
> I want to insert the string 'c:\Repository\Pack\' into a mysql table
> using java and I did it as follows:
>
> sql =3D "INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\' )";
> insertStmt.execute(sql);
>
> I got an error and I know I should add an extra '\' to escape each of
> the '\' in the above sql statement. But, the problem is MS SQL and
> Oracle do not treat '\' as an escape character in sql statements, and I
> want to keep my Java program as database-independent as possible. (and I
> don't want the whole string 'c:\\Repository\\Pack\\' to be stored in the
> database when I use MS SQL server or Oracle)
>
> Any suggestion to my problem will be greatly appreciated.
>
> Thanks,
> Kathy
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP Question
Ok so this really doesnt have anything to do with MySQL but I thought this might be a good placeto ask. Ok heres the problem. I am constructing a Message Board with MySQL and php (was usingASP) and I dont want the user to reload/repost data. For example, say the user goes to post amessage, after they hit the post button it takes them to a temp page saying that there post wassuccesful with a link to go view the post. The problem arises if some one decides to hit thereload button. Because of the way I have the posting page setup it will reload the page and postthe message again! doh! Anyways, has anyone come up against a similar problem and found a way around it? Thanks in advance. -Nick - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL 4.0 Beta
Hi, We want to use only MYSQL4.0 for our production database. Please let us know when the Beta release is scheduled. Regards See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About BLOBS
Hello, Does MySqL database supports BLOBs operation? (Insert, delete etc ...) If yes which API can use to do these operations? (MySqL++)? Thanks for help - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Web based search
Hi, Thanks for the reply. Currently We are using fulltext index search only. What I am looking forward is another effective way of doing it -- On Wed, 10 Apr 2002 15:15:08 Cathy Cunningham (Blue World Lasso Evangelist) wrote: >At 1:08 PM -0700 4/10/02, va ku wrote: >> >>We are developing a webbased serch application on MYSQL and PHP. I >>am sure most of you must have already implemented >>such application. Could you share with me the logic of such >>application. We were planning to keep a keyword search >>and my people feel that that will require additional load of >>keeping track of keyword and they are not interested in that. The >>other option is fulltext >>serch on all the data for one table, but concern about of the >>performance issue. >>Wondering how you guys are doing out there ? Which is the best way ? >>Any suggesstion appreciated . > >We need some more details to provide meaningful assistance. That >having been said, if you're going to be doing a project with massive >amounts of text and want to provide full text searching capabilities, >definitely take a look at MySQL v4 which provides some great >enhancements along the lines of full text indexing/searching. >Indexing is purportedly 100x faster and full text searching is >purportedly 2x faster. There's also a wealth of new search operators >planned (I don't know yet it they're implemented) which help with >defining the search. > >HTH > >CC >-- > >- >Cathy Cunningham [EMAIL PROTECTED] >Lasso Evangelist >Blue World Communications, Inc. http://www.blueworld.com/ >- > >Lasso Studio is "the easiest way to create a database-driven Web site" > - Macworld Magazine > See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connection -- Can't open named pipe error
http://www.mysql.com/doc/W/i/Windows_vs_Unix.html Can't open named pipe error If you use a MySQL 3.22 version on NT with the newest mysql-clients you will get the following error: error 2017: can't open named pipe to host: . pipe... This is because the release version of MySQL uses named pipes on NT by default. You can avoid this error by using the --host=localhost option to the new MySQL clients or create an option file `C:\my.cnf' that contains the following information: [client] host = localhost Starting from 3.23.50, named pipes are only enabled if mysqld is started with --enable-named-pipe. -Original Message- From: Frederic Cormann [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 5:28 AM To: [EMAIL PROTECTED] Subject: Connection Importance: High I have the following message: Microsoft OLE DB Provider for ODBC Drivers- Fehler '80004005' [TCX][MyODBC]Can't open named pipe to host: 192.168.97.2 pipe: MySQL (5) /hopital/Web/De/TMP20w8iuel5u.asp, line 5 can anybody help me? - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to automate bin-log clean-up with replicated MySQL servers?
> -Original Message-
> From: Marc Prewitt [mailto:[EMAIL PROTECTED]]
> Sent: 11 April 2002 14:46
> To: [EMAIL PROTECTED]
> Cc: paul
> Subject: Re: How to automate bin-log clean-up with replicated MySQL
> servers?
>
>
> PFIZER GLOBAL RESEARCH AND DEVELOPMENT
>
> This message and any attachment has been virus checked by the
> PGRD Sandwich Data Centre.
>
>
> We have a slightly smarter script which checks each slave to find the
> furthest one behind and purges up to that number. However,
> it currently
> figures out who the slaves are by checking a process status on the
> master. Unfortunately, this doesn't work if one of your
> slaves is down.
> So, I'm going to rewrite it to check the known slaves.
>
> -Marc
>
Marc,
Can you posted an updated version to the list when you've done it ?
Thanks
Greg
> Jeremy Zawodny wrote:
> >
> > On Tue, Apr 09, 2002 at 10:15:12AM +0200, paul wrote:
> > > Hello all,
> > >
> > > I have setup a replication between two MySQL v4.01a servers on
> > > FreeBSD, which works really fine. The only problem is
> that since we
> > > have MANY updates on the master database, the bin-logs grow very
> > > fast. We need to do a manual clean-up at least once every
> other day,
> > > otherwise the disk space will get exhausted: "SHOW SLAVE
> STATUS" on
> > > the slave, write down the 'Log_File' name, and pass that to "PURGE
> > > MASTER LOGS TO 'logname'" on the master.
> > >
> > > Does anybody have an idea how we could automate this procedure, or
> > > should we manage the log-files is another way?
> >
> > Here's a quick home-grown solution that works well for us. It's not
> > the smartest approach, but we never let a slave get too far behind
> > (they're all closely monitored), it works qutie well.
> >
> > This is purge_master_logs:
> >
> > ---snip---
> >
> > #!/usr/local/bin/perl -w
> > #
> > # $Source: /CVSROOT/yahoo/finance/mysql/bin/purge_master_logs,v $
> >
> > ## On a mysql server, purge the replication logs if there are "too
> > ## many" sitting around and sucking up disk space.
> >
> > $|++;
> >
> > use strict;
> > use RunMutex '/tmp/.write_heartbeat.lock';
> > use DBIx::DWIW;
> >
> > my $MIN_LOGS = 4; ## keep at least three binary logs around
> >
> > my $db = DBIx::DWIW->Connect(
> > DB => "mysql",
> > User => "root",
> > Pass => "password",
> > Host => 'localhost',
> >);
> >
> > if (not $db)
> > {
> > die "Couldn't connect to database!";
> > }
> >
> > my @logs = $db->FlatArray("SHOW MASTER LOGS");
> >
> > ## see if there are enough to bother
> >
> > if (@logs < $MIN_LOGS)
> > {
> > exit;
> > }
> >
> > ## if so, figure out what the last one we want to kee is
> >
> > my $last_log = $logs[-$MIN_LOGS];
> >
> > print "last log is $last_log\n" unless $ENV{CRON};
> >
> > ## and purge the rest
> >
> > $db->Execute("PURGE MASTER LOGS TO '$last_log'");
> >
> > exit;
> >
> > __END__
> >
> > ---snip---
> >
> > Jeremy
> > --
> > Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> > Technical Yahoo - Yahoo Finance
> > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
> >
> > MySQL 3.23.47-max: up 61 days, processed 1,654,071,336
> queries (311/sec. avg)
> >
> >
> -
> > 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 PROTECTED]>
> > To unsubscribe, e-mail
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
PFIZER GLOBAL RESEARCH AND DEVELOPMENT
This message and any attachment has been virus checked by the
PGRD Sandwich Data Centre.
-
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 PROTECTED]>
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: binlog and replication stuff
FLUSH LOGS in the master and all is ok? binlog will be rotate and slaves will see it, continue to work and update master.info? Regads Il 15:31, giovedì 11 aprile 2002, hai scritto: > FLUSH LOGS safely rotates the binlog. > > Davide Giunchi wrote: > > You are right, but my master generate about 150Mb of binlog x day, i a > > slave fail after 4 day it will reexec a lot of query and take some time. > > how can i safely rotate the log in master+slaves without restarting them? > > The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 (or > > > 001) file, but what about if the binlog is always the same? > > I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the > > slaves, it wouldn't loose the sync? > > -- Davide Giunchi. Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it GPG Key available on http://www.keyserver.net Fingerprint: 8075 363A B4FA 0196 FEEC AF9C 19A9 66C7 CDAB D0D5 - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to automate bin-log clean-up with replicated MySQL servers?
We have a slightly smarter script which checks each slave to find the
furthest one behind and purges up to that number. However, it currently
figures out who the slaves are by checking a process status on the
master. Unfortunately, this doesn't work if one of your slaves is down.
So, I'm going to rewrite it to check the known slaves.
-Marc
Jeremy Zawodny wrote:
>
> On Tue, Apr 09, 2002 at 10:15:12AM +0200, paul wrote:
> > Hello all,
> >
> > I have setup a replication between two MySQL v4.01a servers on
> > FreeBSD, which works really fine. The only problem is that since we
> > have MANY updates on the master database, the bin-logs grow very
> > fast. We need to do a manual clean-up at least once every other day,
> > otherwise the disk space will get exhausted: "SHOW SLAVE STATUS" on
> > the slave, write down the 'Log_File' name, and pass that to "PURGE
> > MASTER LOGS TO 'logname'" on the master.
> >
> > Does anybody have an idea how we could automate this procedure, or
> > should we manage the log-files is another way?
>
> Here's a quick home-grown solution that works well for us. It's not
> the smartest approach, but we never let a slave get too far behind
> (they're all closely monitored), it works qutie well.
>
> This is purge_master_logs:
>
> ---snip---
>
> #!/usr/local/bin/perl -w
> #
> # $Source: /CVSROOT/yahoo/finance/mysql/bin/purge_master_logs,v $
>
> ## On a mysql server, purge the replication logs if there are "too
> ## many" sitting around and sucking up disk space.
>
> $|++;
>
> use strict;
> use RunMutex '/tmp/.write_heartbeat.lock';
> use DBIx::DWIW;
>
> my $MIN_LOGS = 4; ## keep at least three binary logs around
>
> my $db = DBIx::DWIW->Connect(
> DB => "mysql",
> User => "root",
> Pass => "password",
> Host => 'localhost',
>);
>
> if (not $db)
> {
> die "Couldn't connect to database!";
> }
>
> my @logs = $db->FlatArray("SHOW MASTER LOGS");
>
> ## see if there are enough to bother
>
> if (@logs < $MIN_LOGS)
> {
> exit;
> }
>
> ## if so, figure out what the last one we want to kee is
>
> my $last_log = $logs[-$MIN_LOGS];
>
> print "last log is $last_log\n" unless $ENV{CRON};
>
> ## and purge the rest
>
> $db->Execute("PURGE MASTER LOGS TO '$last_log'");
>
> exit;
>
> __END__
>
> ---snip---
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.47-max: up 61 days, processed 1,654,071,336 queries (311/sec. avg)
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]>
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: binlog and replication stuff
If the master crashes, you can move the ip of you master to the slave machine and it can become the new master. However, to move back to teh master, you will need to copy the stuff back to the master. There's some good information in the manual about how to plan disaster recovery: http://www.mysql.com/doc/R/e/Replication_FAQ.html [EMAIL PROTECTED] wrote: > > How about if master crashes?...is there anyway to recover?...aside from > copying all stuff from slave to master... > > R.B.Roa > PhilCom Corporation > Tel. No. 858- > Mobile No. (63) (919-xxx) > > -Original Message- > From: Davide Giunchi [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 5:37 PM > To: Marc Prewitt > Cc: [EMAIL PROTECTED] > Subject:Re: binlog and replication stuff > > You are right, but my master generate about 150Mb of binlog x day, i > a slave > fail after 4 day it will reexec a lot of query and take some time. > how can i > safely rotate the log in master+slaves without restarting them? > The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 > (or > 001) > file, but what about if the binlog is always the same? > I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the > slaves, > it wouldn't loose the sync? > > Regards > > > When a slave crashes or reboots, it should start replicating from > where it > > left off--at least ours do work that way. The current replication > state > > is saved in master.info on the slave and when it starts up again, > it > > should read that file and resume reading the binlog on the master > where it > > left off. The master.info file contains the binlog#, location, > user, > > password, etc... neccessary to restart replication. > > > > In you case, does the slave give you any error messages in it's > error log > > about why it couldn't resume replication? If it doesn't try to > start > > replication, have you tried doing a 'slave start' on the slave > after it > > reboots? > > > > -Marc > > -- - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: binlog and replication stuff
FLUSH LOGS safely rotates the binlog. Davide Giunchi wrote: > > You are right, but my master generate about 150Mb of binlog x day, i a slave > fail after 4 day it will reexec a lot of query and take some time. how can i > safely rotate the log in master+slaves without restarting them? > The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 (or > 001) > file, but what about if the binlog is always the same? > I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the slaves, > it wouldn't loose the sync? > > Regards > > > When a slave crashes or reboots, it should start replicating from where it > > left off--at least ours do work that way. The current replication state > > is saved in master.info on the slave and when it starts up again, it > > should read that file and resume reading the binlog on the master where it > > left off. The master.info file contains the binlog#, location, user, > > password, etc... neccessary to restart replication. > > > > In you case, does the slave give you any error messages in it's error log > > about why it couldn't resume replication? If it doesn't try to start > > replication, have you tried doing a 'slave start' on the slave after it > > reboots? > > > > -Marc > > -- > Davide Giunchi. > Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it > GPG Key available on http://www.keyserver.net > Fingerprint: 8075 363A B4FA 0196 FEEC AF9C 19A9 66C7 CDAB D0D5 - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SBS and MySQL
Hello all, We recently Installed MySQL on M$ lovely Small Business Server, and since then we have been experience some problems. I was wondering if any one had experience with SBSand MySQL and if they did or did not have any problems with it. Personally I don't think it is MySQL that is crashing it but try telling that to the IT guys =) Apparently some of the problems include the kernel crashing and some of the backups are failing for no apparentreason. Is there any way at all that MySQL could be responsible for these? I wouldn't thinkthat MySQL would do this as it simply runs as a service and doesn't particularly mess with anywindows settings. Thanks for the help! -Nick - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connection
I have the following message: Microsoft OLE DB Provider for ODBC Drivers- Fehler '80004005' [TCX][MyODBC]Can't open named pipe to host: 192.168.97.2 pipe: MySQL (5) /hopital/Web/De/TMP20w8iuel5u.asp, line 5 can anybody help me? - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Another question of Date.
About midway down the page...:
http://www.mysql.com/doc/S/t/String_functions.html
SUBSTRING(str,pos)
SUBSTRING(str FROM pos)
Returns a substring from string str starting at position pos:
mysql> select SUBSTRING('Quadratically',5);
-> 'ratically'
mysql> select SUBSTRING('foobarbar' FROM 4);
-> 'barbar'
This function is multi-byte safe.
C:~
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 5:10 AM
To: Mike; [EMAIL PROTECTED]
Subject: Re: Another question of Date.
Mike and the mysql list,
This is the SQL statement I am using now;
SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) <=7 AND (TO_DAYS(D\
OB) >= TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
Lname
But it only works because I had to change the year to 2002, I don't want to
change 2002. That was my question I want to read the field but only the
month and the date. NOT FORMAT. I also like to read that field but only the
year and take this year to get how old a person is. I hope that clears it
up.
Chuck
on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:
> Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
> function to supply a date for a WHERE clause in a sql statement.
>
> Mike
> - Original Message -
> From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
> To: "Mike" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, April 11, 2002 7:53 AM
> Subject: Re: Another question of Date.
>
>
>> Thanks but I want to be able able to use this in SQL statement not format
>> the output.
>>
>> Chuck
>>
>> on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
>>
>>> http://www.mysql.com/doc/D/a/Date_and_time_functions.html
>>>
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
>>> -> 'Saturday October 1997'
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
>>> -> '22:23:00'
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00',
>>> '%D %y %a %d %m %b %j');
>>> -> '4th 97 Sat 04 10 Oct 277'
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00',
>>> '%H %k %I %r %T %S %w');
>>> -> '22 22 10 10:23:00 PM 22:23:00 00 6'
>>> mysql> select DATE_FORMAT('1999-01-01', '%X %V');
>>> -> '1998 52'
>>>
>>>
>>> Mike
>>> - Original Message -
>>> From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
>>> To: <[EMAIL PROTECTED]>
>>> Sent: Thursday, April 11, 2002 7:42 AM
>>> Subject: Another question of Date.
>>>
>>>
Hi,
I got a small problem I like to be able to read a DATE but I don't want
> to
read the Year. I only want to read the month and the date. For example,
> I
like to read the a Birthday Field to see who Bithday is today. Also
> like
>>> to
be later be able to read that same field but this time the year so that
> I
can see how old a person is. Is there any example on the net of this?
Chuck
Sql and MySql
-
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 PROTECTED]>
To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>>
>>>
>>> ---
>>> Outgoing mail is certified Virus Free.
>>> Checked by AVG anti-virus system (http://www.grisoft.com).
>>> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>>>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>
-
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 PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
Sorry that second 2002 should be year. I don't want to change year to get it
to work.
Chuck
on 4/11/02 8:10 AM, Chuck "PUP" Payne at [EMAIL PROTECTED] wrote:
> Mike and the mysql list,
>
> This is the SQL statement I am using now;
>
> SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
> emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) <=7 AND (TO_DAYS(D\
> OB) >= TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
> Lname
>
> But it only works because I had to change the year to 2002, I don't want to
> change 2002. That was my question I want to read the field but only the
> month and the date. NOT FORMAT. I also like to read that field but only the
> year and take this year to get how old a person is. I hope that clears it
> up.
>
> Chuck
> on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:
>
>> Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
>> function to supply a date for a WHERE clause in a sql statement.
>>
>> Mike
>> - Original Message -
>> From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
>> To: "Mike" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>> Sent: Thursday, April 11, 2002 7:53 AM
>> Subject: Re: Another question of Date.
>>
>>
>>> Thanks but I want to be able able to use this in SQL statement not format
>>> the output.
>>>
>>> Chuck
>>>
>>> on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
>>>
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
-> '22:23:00'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
-> '4th 97 Sat 04 10 Oct 277'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql> select DATE_FORMAT('1999-01-01', '%X %V');
-> '1998 52'
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another question of Date.
> Hi,
>
> I got a small problem I like to be able to read a DATE but I don't want
>> to
> read the Year. I only want to read the month and the date. For example,
>> I
> like to read the a Birthday Field to see who Bithday is today. Also
>> like
to
> be later be able to read that same field but this time the year so that
>> I
> can see how old a person is. Is there any example on the net of this?
>
> Chuck
>
> Sql and MySql
>
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail
>> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>>
>>
>> ---
>> Outgoing mail is certified Virus Free.
>> Checked by AVG anti-virus system (http://www.grisoft.com).
>> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>>
>
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
Mike and the mysql list,
This is the SQL statement I am using now;
SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM
emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) <=7 AND (TO_DAYS(D\
OB) >= TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB,
Lname
But it only works because I had to change the year to 2002, I don't want to
change 2002. That was my question I want to read the field but only the
month and the date. NOT FORMAT. I also like to read that field but only the
year and take this year to get how old a person is. I hope that clears it
up.
Chuck
on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:
> Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
> function to supply a date for a WHERE clause in a sql statement.
>
> Mike
> - Original Message -
> From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
> To: "Mike" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, April 11, 2002 7:53 AM
> Subject: Re: Another question of Date.
>
>
>> Thanks but I want to be able able to use this in SQL statement not format
>> the output.
>>
>> Chuck
>>
>> on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
>>
>>> http://www.mysql.com/doc/D/a/Date_and_time_functions.html
>>>
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
>>> -> 'Saturday October 1997'
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
>>> -> '22:23:00'
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00',
>>> '%D %y %a %d %m %b %j');
>>> -> '4th 97 Sat 04 10 Oct 277'
>>> mysql> select DATE_FORMAT('1997-10-04 22:23:00',
>>> '%H %k %I %r %T %S %w');
>>> -> '22 22 10 10:23:00 PM 22:23:00 00 6'
>>> mysql> select DATE_FORMAT('1999-01-01', '%X %V');
>>> -> '1998 52'
>>>
>>>
>>> Mike
>>> - Original Message -
>>> From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
>>> To: <[EMAIL PROTECTED]>
>>> Sent: Thursday, April 11, 2002 7:42 AM
>>> Subject: Another question of Date.
>>>
>>>
Hi,
I got a small problem I like to be able to read a DATE but I don't want
> to
read the Year. I only want to read the month and the date. For example,
> I
like to read the a Birthday Field to see who Bithday is today. Also
> like
>>> to
be later be able to read that same field but this time the year so that
> I
can see how old a person is. Is there any example on the net of this?
Chuck
Sql and MySql
-
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 PROTECTED]>
To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>>
>>>
>>> ---
>>> Outgoing mail is certified Virus Free.
>>> Checked by AVG anti-virus system (http://www.grisoft.com).
>>> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>>>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Another question of Date.
* Chuck "PUP" Payne > Thanks but I want to be able able to use this in SQL statement not format > the output. SELECT * FROM table WHERE DATE_FORMAT(birthday,'%M %D') = DATE_FORMAT(now(),'%M %D'); -- Roger query - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
function to supply a date for a WHERE clause in a sql statement.
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: "Mike" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
> Thanks but I want to be able able to use this in SQL statement not format
> the output.
>
> Chuck
>
> on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
>
> > http://www.mysql.com/doc/D/a/Date_and_time_functions.html
> >
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
> > -> 'Saturday October 1997'
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
> > -> '22:23:00'
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00',
> > '%D %y %a %d %m %b %j');
> > -> '4th 97 Sat 04 10 Oct 277'
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00',
> > '%H %k %I %r %T %S %w');
> > -> '22 22 10 10:23:00 PM 22:23:00 00 6'
> > mysql> select DATE_FORMAT('1999-01-01', '%X %V');
> > -> '1998 52'
> >
> >
> > Mike
> > - Original Message -
> > From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, April 11, 2002 7:42 AM
> > Subject: Another question of Date.
> >
> >
> >> Hi,
> >>
> >> I got a small problem I like to be able to read a DATE but I don't want
to
> >> read the Year. I only want to read the month and the date. For example,
I
> >> like to read the a Birthday Field to see who Bithday is today. Also
like
> > to
> >> be later be able to read that same field but this time the year so that
I
> >> can see how old a person is. Is there any example on the net of this?
> >>
> >> Chuck
> >>
> >> Sql and MySql
> >>
> >>
> >> -
> >> 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 PROTECTED]>
> >> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
> >
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
SELECT DATE_FORMAT(date column,'%W %M %Y') as date FROM table;
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: "Mike" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 7:53 AM
Subject: Re: Another question of Date.
> Thanks but I want to be able able to use this in SQL statement not format
> the output.
>
> Chuck
>
> on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
>
> > http://www.mysql.com/doc/D/a/Date_and_time_functions.html
> >
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
> > -> 'Saturday October 1997'
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
> > -> '22:23:00'
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00',
> > '%D %y %a %d %m %b %j');
> > -> '4th 97 Sat 04 10 Oct 277'
> > mysql> select DATE_FORMAT('1997-10-04 22:23:00',
> > '%H %k %I %r %T %S %w');
> > -> '22 22 10 10:23:00 PM 22:23:00 00 6'
> > mysql> select DATE_FORMAT('1999-01-01', '%X %V');
> > -> '1998 52'
> >
> >
> > Mike
> > - Original Message -
> > From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, April 11, 2002 7:42 AM
> > Subject: Another question of Date.
> >
> >
> >> Hi,
> >>
> >> I got a small problem I like to be able to read a DATE but I don't want
to
> >> read the Year. I only want to read the month and the date. For example,
I
> >> like to read the a Birthday Field to see who Bithday is today. Also
like
> > to
> >> be later be able to read that same field but this time the year so that
I
> >> can see how old a person is. Is there any example on the net of this?
> >>
> >> Chuck
> >>
> >> Sql and MySql
> >>
> >>
> >> -
> >> 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 PROTECTED]>
> >> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
> >
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
Thanks but I want to be able able to use this in SQL statement not format
the output.
Chuck
on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote:
> http://www.mysql.com/doc/D/a/Date_and_time_functions.html
>
> mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
> -> 'Saturday October 1997'
> mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
> -> '22:23:00'
> mysql> select DATE_FORMAT('1997-10-04 22:23:00',
> '%D %y %a %d %m %b %j');
> -> '4th 97 Sat 04 10 Oct 277'
> mysql> select DATE_FORMAT('1997-10-04 22:23:00',
> '%H %k %I %r %T %S %w');
> -> '22 22 10 10:23:00 PM 22:23:00 00 6'
> mysql> select DATE_FORMAT('1999-01-01', '%X %V');
> -> '1998 52'
>
>
> Mike
> - Original Message -
> From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, April 11, 2002 7:42 AM
> Subject: Another question of Date.
>
>
>> Hi,
>>
>> I got a small problem I like to be able to read a DATE but I don't want to
>> read the Year. I only want to read the month and the date. For example, I
>> like to read the a Birthday Field to see who Bithday is today. Also like
> to
>> be later be able to read that same field but this time the year so that I
>> can see how old a person is. Is there any example on the net of this?
>>
>> Chuck
>>
>> Sql and MySql
>>
>>
>> -
>> 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 PROTECTED]>
>> To unsubscribe, e-mail <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Another question of Date.
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
-> '22:23:00'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
-> '4th 97 Sat 04 10 Oct 277'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql> select DATE_FORMAT('1999-01-01', '%X %V');
-> '1998 52'
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another question of Date.
> Hi,
>
> I got a small problem I like to be able to read a DATE but I don't want to
> read the Year. I only want to read the month and the date. For example, I
> like to read the a Birthday Field to see who Bithday is today. Also like
to
> be later be able to read that same field but this time the year so that I
> can see how old a person is. Is there any example on the net of this?
>
> Chuck
>
> Sql and MySql
>
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Another question of Date.
Hi, I got a small problem I like to be able to read a DATE but I don't want to read the Year. I only want to read the month and the date. For example, I like to read the a Birthday Field to see who Bithday is today. Also like to be later be able to read that same field but this time the year so that I can see how old a person is. Is there any example on the net of this? Chuck Sql and MySql - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- OpenSSL and MySSL ... Is it real?
Hello All In MySQL 4.x MySQL Reference Manual for version 3.23.49 in 1.1.6 The Main Features of MySQL there is a support OpenSSL. Who used that this opportunity in MySQL + php? What impressions? Difficulties? Features? -- Best regards, maxim mailto:[EMAIL PROTECTED] - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: get date
saraswathy, Thursday, April 11, 2002, 12:41:29 PM, you wrote: ss> I want to get date expire according to their term joining...let say 6 month ss> term..so i have to get the date when reach 6 month can anyone help me... Take a look at MySQL date and time function, such as DATE_ADD(), DATE_SUB(): http://www.mysql.com/doc/D/a/Date_and_time_functions.html ss> query ss> sql -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysqldump when using query caching
Nick, Wednesday, April 10, 2002, 7:27:20 PM, you wrote: NP> I'm using Mysql 4.0.1 with query caching: NP> set-variable = query_cache_limit=10M NP> set-variable = query_cache_size=10M NP> set-variable = query_cache_startup_type=1 NP> The Command: NP> mysqldump -q -K -t --tab='.' \ NP> --fields-optionally-enclosed-by='"' \ NP> --fields-terminated-by=',' sched oweek NP> The first execution of the command writes the expected NP> data to oweek.txt. NP> Any subsequent executions do not. This is because of query caching. NP> I can run --> mysql -e "reset query cache" <-- which will enable NP> the next call to mysqldump to write data. NP> I believe that mysqldump should write data whether query caching NP> is enabled/disabled or not-flushed/flushed. Looks quite interesting, but can you please try to run that on MySQL official binary release? As it seems that you have compiled MySQL from source, and it's tricky to do that correctly. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: modifying varchar to char on the fly
Description: e> When attempting to modify a column from varchar(40) to char(40) the command returns successfully, however the table is unaltered e> How-To-Repeat: e> (prepare a table table_name with a column column_name varchar(40) e> alter table table_name modify column_name char(40) NOT NULL default ''; e> describe table_name e> Fix: e> alternative right now is to drop the table and recreate it What is the structure of your table? In some cases MySQL changes column specification. If your table have any variable-length column, all your CHAR columns that are longer than 3 characters are changed to VARCHAR columns. Look at: http://www.mysql.com/doc/S/i/Silent_column_changes.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql Ver 3.23.49 installation issues with binary
TruthXayer, Wednesday, April 10, 2002, 9:53:15 PM, you wrote: T> I downloaded mysql Ver 3.23.49 binary to T> a local directory. other than (/usr/local) T> I changed ./bin/mysqlaccess for MySQL location, etc. T> but for some reason it dies as sooon as starts. T> I notice that some scripts and files in bin directory T> are pointing to /usr/local and /tmp paths. Also perl T> pointer is default. T> Please advice how I can fix these... T> thanks, T> ./bin/safe_mysqld & T> Starting mysqld daemon with databases from T> 020410 11:50:47 mysqld ended T> ./bin/mysqld & T> ./bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' You can specify path to your messagefile using "--language" option of mysqld. Look at: http://www.mysql.com/doc/L/a/Languages.html Or you can create a symbolic link on the error message dir. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: share/mysql/mysql.server start does somthing but also shuts down mysql.
Chris, Thursday, April 11, 2002, 8:22:40 AM, you wrote: CT> the command (run from my mysql basedir) "share/mysql/mysql.server start" CT> gives me this message CT> - CT> Starting mysqld daemon with databases from /usr/local/ CT> mysql/var CT> 020411 17:25:51 mysqld ended CT> CT> Thats it. MySql wont start, I cant connect to MySQL. Any Help? Chris, give me some more info: 1. Version of the MySQL server. 2. Your OS. 3. Show me the contents of your .err file CT> Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqladmin security
Okan, Thursday, April 11, 2002, 12:52:04 PM, you wrote: OC> When I execute mysqladmin drop database database_name it drops the database OC> without asking for a user or password. How are the security features are set OC> about mysqsladmin? Check permissions on databases. Looks like the anonymous user (user '' in MySQL) has drop privileges on your database. You can read about MySQL privilege system at: http://www.mysql.com/doc/G/R/GRANT.html http://www.mysql.com/doc/P/r/Privileges.html OC> Regards OC> Okan -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Core dump when execute safe_mysqld
Truc, Wednesday, April 10, 2002, 8:25:35 PM, you wrote: TT> >Description: TT> I have downloaded a binary version of mysql, perform all installations steps TT> from the manual. As soon as I started to execute safe_mysqld --user=mysql & TT> I got a core dump and the program exited. Please help TT> >Release: mysql-3.23.39 (Official MySQL binary) This binary is broken. Please take the latest official MySQL binary release from http://www.mysql.com/downloads/mysql-3.23.html or compile from source by yourself. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL UDF questions
On Thursday, 11. April 2002 10:26, Fei Chen wrote:
> Dear Georg,
>
>
> * notation. Just as normally I can say
> select * from myTable;
> can I write a UDF to handle
> select my_udf(*) from myTable; ?
> There is the builtin function
> select count(*) from myTable;
> But the manual does not say how this is to be accomplished using UDFs.
No, the udf is outside from mysql in a shared library. So the udf doesn't
know anything about the used table(s) and his fields.
When you want functionallity like count, you have to write an aggregate udf.
The diffrence between a normal udf and a aggregate udf is that _reset and _add
functions will be called for first row/each row.
> Indeed UDFs can return (char *), but my question is, is there a way to
> return an array of intergers (int *)? or some more complicated structure,
> say, (myStruct *)? If UDFs are limited to returning (char*), (long) or
> (double), does that mean the only way out is to turn (myStruct*) into
> some kind of string and return it as (char*)?
>
An user defined function (udf) is not a api-function. It would make no sense
to return other values, or a structure. What output should be displayed, when
udf would return a structure?
SELECT UDF("foo");
Regards Georg
mysql, query
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin security
Hello, When I execute mysqladmin drop database database_name it drops the database without asking for a user or password. How are the security features are set about mysqsladmin? Regards Okan - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Math Computations
Something like
";
while ($row = mysql_fetch_row($result)){
$subtotal=$row[0]*$row[2];
$total+=$subtotal;
echo "$row[0] | $row[1] | $row[2] | $subtotal";
$comptotal+=$row[0];}
}
echo "$comptotal $total";
?>
Obviously format it into a table would make sense, e.t.c.
Adam
- Original Message -
From: "delz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 5:29 AM
Subject: Math Computations
> Hi,
>
> I have this table that looks like this
>
> Computers | Department | Price per PC | TotalAmount |
> 15 | Marketing | $500.00| |
> 5 | Purchasing | $ 300.00 | |
>
> I want this table to display the total price wherein Computer * Price Per
PC
> = TotalAmount
> and want to display the total no. of computer and the OverAll TotalAmount.
>
> I want the output to look like this
>
> Computers | Department | Price per PC | TotalAmount |
> 15 | Marketing | $500.00| $ 7500.00 |
> 5 | Purchasing | $ 300.00 | $ 900.00 |
> - ---
> 20 $ 8400.00
>
> Can anyone help me how to do this in mysql or php. I will surely
appreciate
> any help I
> can get.
>
> Thanks.
>
> Delz
>
>
> -
> 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 PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
-
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get date
hi everybody, I want to get date expire according to their term joining...let say 6 month term..so i have to get the date when reach 6 month can anyone help me... query sql thanks in advance. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Math Computations
Hi, I have this table that looks like this Computers | Department | Price per PC | TotalAmount | 15 | Marketing | $500.00| | 5 | Purchasing | $ 300.00 | | I want this table to display the total price wherein Computer * Price Per PC = TotalAmount and want to display the total no. of computer and the OverAll TotalAmount. I want the output to look like this Computers | Department | Price per PC | TotalAmount | 15 | Marketing | $500.00| $ 7500.00 | 5 | Purchasing | $ 300.00 | $ 900.00 | - --- 20 $ 8400.00 Can anyone help me how to do this in mysql or php. I will surely appreciate any help I can get. Thanks. Delz - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with very large Indexes
Hi all, we have a little problem with the size of our index file. We need to set a lot of combined Indexes and singel Indexes (we have a table with ca. 40.000.000 entries and something about 20 Columns). I'm pretty sure that the index file will get over the 4 GB size. We use Linux 2.4.x with a new glibc and MySQL compiled with --enable-largefile. I'm not sure, but this means we are limited to at least 4GB per file (or am I wrong?). If so, is there any posibility to split indexes in more than one physicaly file (one index=one file and not all indexes in one file)... or do you know any hack which makes me able to adress files larger than 4 GB on a linux system? Thanks in advance and sorry for the poor english :) Stefan - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL UDF questions
Dear Georg, Thanks for replying. I have read the mysql manual but unfortunately have not been able to find the answer. I realize UDFs can have field names as their parameters, as in select my_udf(fld1, fld2, fld10) from myTable; but here the field names have to be specified explicitly. What I'm wondering is there a shortcut way to specify all the fields from myTable, using the * notation. Just as normally I can say select * from myTable; can I write a UDF to handle select my_udf(*) from myTable; ? There is the builtin function select count(*) from myTable; But the manual does not say how this is to be accomplished using UDFs. > UDF functions can return STRING (char *), INTEGER (long) OR REAL (double). > Please read the Manual: http://www.mysql.com/doc/A/d/Adding_UDF.html Indeed UDFs can return (char *), but my question is, is there a way to return an array of intergers (int *)? or some more complicated structure, say, (myStruct *)? If UDFs are limited to returning (char*), (long) or (double), does that mean the only way out is to turn (myStruct*) into some kind of string and return it as (char*)? Thanks a lot, fei - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Wich version of FreeBSD is better?
On Thu, Apr 11, 2002 at 09:39:56AM +0200, Iago Sineiro wrote: > Hi all. > > I've read the manual of mysql and it says that for mysql is better > use FreeBSD 3.x because the thread package is much more integrated > (2.6.4.1 FreeBSD Notes). That's a bit outdated now. > I have the doubt if this it's comentary refers to FreeBSD 3.x and > next versions (FreeBSD 4.x) or it refers that FreeBSD 3.x is better > than FreeBSD 4.x for mysql. Isn't it a little strange that FreeBSD > 3.x is better than FreeBSD 4.x? 4.x is certainly better. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 62 days, processed 1,698,402,307 queries (313/sec. avg) - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Wich version of FreeBSD is better?
Hi all. I've read the manual of mysql and it says that for mysql is better use FreeBSD 3.x because the thread package is much more integrated (2.6.4.1 FreeBSD Notes). I have the doubt if this it's comentary refers to FreeBSD 3.x and next versions (FreeBSD 4.x) or it refers that FreeBSD 3.x is better than FreeBSD 4.x for mysql. Isn't it a little strange that FreeBSD 3.x is better than FreeBSD 4.x? Also anybody has any experience with FreeBSD 5.0 and mysql (the current development version) and its new support for smp? I have to configure a dual Pentium III machine and I want to know if FreeBSD 5.0 is sufficient stable for work with it because it has an enhanced support and performance for smp than FreeBSD 4.x. Iago. - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
