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!
-
B
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 wou
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 pr
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
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.
>
>
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. Zawo
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. Unfortun
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
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, t
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
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
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 t
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?
-
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
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?
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:
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, 2
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 thre
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.
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
>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.
> Bu
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.
> -Or
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
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,
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
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'
>
> I
>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_cl
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
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
___
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 writt
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
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 PROTEC
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
>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
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
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?
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\\')"
(b
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
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..
>
>
> ---
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 thr
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
__
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
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.
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
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 t
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'(1006
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 gene
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
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, delet
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 cha
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
>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
---
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 a
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
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
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'
mak
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 P
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:\Re
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 t
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
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
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 developi
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 pipe
> -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
> --
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
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
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.my
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 M
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
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?
--
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);
-> 'ra
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,
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 o
* 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
--
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,
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
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 Oc
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',
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 t
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 PROTECTE
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():
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
N
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_
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.
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 i
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
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 pro
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
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:
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
- Or
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 s
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
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 ne
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 w
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
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 be
96 matches
Mail list logo
