Hi !!
Can I schedule a task in mysql ? I want to perform some operation on
database after a specific period of time. Is it possible ?
Please, tell me the link, from where do I get the information about the
same..
Waiting for your quick response,
Thank you,
Varsha.
---
I have what may seem a silly question on this list. As I am
fairly new to mysql, I am not sure what the answer might be.
I have noticed my software generating errors everytime I try
to place the single or double quote into the table columns.
At this time, I have scripted my perl to turn these q
Hello Victoria,
Try with DBtools is better than mysql-front and export all to My Sql with no
errors.
Only one question how work dynamic cursors with ADO. I have a big problem
with the speed when I use dynamic cursor with last version of ODBC .
This is the address to download
http://www.dbtools.
Hi everyone,
SQL
Iv'e been on innodb.com trying to find out the largest "ibdata" file size
acceptable to my system "RH Linux 7.2", at one part it states "data and log
files must be < 2GB", depending on the OS.
I specified 1M as the size for "ibdata", current "ibdata" size reflects1.8G.
Sorry,
Forgot to say that I am using PHP 4.0.5 and MySQL 3.23.48
>Date: Sat, 02 Mar 2002 15:11:10 +0800
>To: [EMAIL PROTECTED]
>From: Hoo Kok Mun <[EMAIL PROTECTED]>
>Subject: Number of working hours in a month.
>
>Hi,
>
>I have look thru the website on date and time functions but nothing that
Hi,
I have look thru the website on date and time functions but nothing that I
can use.
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
How do I dynamically calculate how many working hours in a particular month?
Has anyone do it before?
Here is the simple formula.
Add - Number of da
Yep. Check out the last_insert_id function that takes an argument:
create table sequence (id int not null);
insert into sequence values (0);
update sequence set id=last_insert_id(id+1);
select last_insert_id();
Repeat the last 2 lines a few times and you'll see that last_insert_id()
returns the
Actually I figured out the problem my db name was wrong, however I am
getting a new code, here is my code now tho and the error (with the pass
this time!):
\n";
while($num=mysql_fetch_array($search)) {
printf ("Name:%s
Number:%sTeam: %sPenalty: %sGroundballs:
%sShots: %sFaceoffs
Won:%sFaceoff
Does mySQL synchronization between queries? How does mySQL handle the
query synchronization. Does anyone know?
__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
---
Try adding this to your mysql_query() function.
$search = mysql_query()
or die("ERROR: ". mysql_error() . "(" . mysql_errno(). ")");
this will tell you whether or not the query is dieing for one reason or
another.
if it doesn't return the die() statement then you must assume that it was
succ
hi!
>> Description:
Paul> The new POSIX standard is now official (IEEE Std 1003.1-2001),
Paul> and it has removed support for some obsolete utility options
Paul> that mysql uses in a few places. Basically, the new POSIX
Paul> has removed digit-string options (e.g., "tail -1") and optio
Hi,
I encounter a strange problem on one of my server with a lot of heap table.
(I'm using latest mysql-4.0.2 version)
Here is the error :
mysql> use forum;
Database changed
mysql> SELECT * FROM online;
ERROR 1030: Got error 124 from table handler
mysql> SELECT * FROM online;
ERROR 1030: Got err
> "mysql" == mysql <[EMAIL PROTECTED]> writes:
mysql> Your message cannot be posted because it appears to be either spam or
mysql> simply off topic to our filter. To bypass the filter you must include
mysql> one of the following words in your message:
mysql> sql,query
mysql> If you just re
Hi!
> "Arjen" == Arjen Lentz <[EMAIL PROTECTED]> writes:
Arjen> Hi Tim,
Arjen> On Sat, 2002-02-23 at 02:46, Tim Allwine wrote:
>> So it appears there is a maximum of 32 keys (indexes) that can be
>> created on a table. Is there any way to increase this? If so how?
Arjen> I think it is ve
Every now and then the question comes up: LOAD DATA indicates a non-zero
warning count when I load a file into MySQL; how can I tell which values
caused the warnings?
As part of the stuff that's going into the MySQL Cookbook, I've written
a program that diagnoses your data file and tells you wher
This is very easy using mysqldump.
Instructions are found in the manual at:
http://www.mysql.com/doc/m/y/mysqldump.html
On Fri, 1 Mar 2002 18:25:19 +0100, Sigurd Stordal wrote:
>I've brand new to Mysql, and for now I have one machine, a private one, with
>a mysql database. No I want to move t
You're producing a query of the form
SELECT x,y,z FROM table WHERE cat ="a,b,c" AND subcat="d,e,f";
Try: IMPLODE("\" OR \"",$category)
or maybe even IMPLODE('" OR "',$category) to remove all the escaping.
Doug
On Fri, 1 Mar 2002 16:14:17 -, John Lodge wrote:
>This is the sort of thing
--- Heikki Tuuri <[EMAIL PROTECTED]> wrote:
> Rick,
>
> sorry, it is not mentioned in the manual that MySQL
> performs a CREATE INDEX
> by doing an ALTER TABLE. And ALTER TABLE has the
> feature (= documented bug)
> that it removes foreign key definitions.
Heikki:
Is there a fix planned for th
Hi:
I am running a simple INSERT query in perl code and am getting the
following error from myisamchk:
myisamchk: warning: 1 clients is using or hasn't closed the table
properly
Note that no such warning occurs when I issue a SELECT query.
I can clean up the warning by issuing a "check table",
"rahs" is the name of your db and your table?
It's a good idea to check for errors as you go. Try something like:
how do I fix it so mysql doesn't returns a 0? is my syntax wrong somewhere?
>
> Thanks!
>
> -Alex "Big Al" Behrens
>
> - Origina
what do you mean by checking each query manually? how do I do this?
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner
Boris,
thank you for the bug report! This is the only currently known bug in
MySQL/InnoDB-3.23.49:
"
February 15, 2002:
If a CREATE TABLE statement contains the string 'foreign' anywhere, and that
is succeeded by a non-space character, then the CREATE TABLE fails,
reporting errno 150. Fixed in
Hello Alex,
Check it manually wheather ur query returns any row.
-Uma
On Fri, 1 Mar 2002, Alex Behrens wrote:
AB>how do I fix it so mysql doesn't returns a 0? is my syntax wrong somewhere?
AB>
AB>Thanks!
AB>
AB>-Alex "Big Al" Behrens
AB>E
how do I fix it so mysql doesn't returns a 0? is my syntax wrong somewhere?
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 39695
[obfilter: mysql database]
Roger Baklund wrote:
> * Benjamin Pflugmann
>>Think the other way around: If the other option is to have no floating
>>point type at all, a "not perfect" one may be good enough for many
>>cases.
> I agree, to some extent, but a growing number of users are 'normal peo
Hello Alex,
If the mysql query returns 0 then it will display the message like this
-Uma
On Fri, 1 Mar 2002, Alex Behrens wrote:
AB>Hey All,
AB>
AB>I am new to mysql and I need help debugging this peice of code for my site:
AB>
AB>$db = mysql_connect("db30.pair.com", "net3dual", "rosevil
Hey All,
I am new to mysql and I need help debugging this peice of code for my site:
Name:%s #%sTeam: %sPenalty:
%sGroundballs: %sShots: %sFaceoffs
Won:%sFaceoffs Lost: %sDate:%s",$num["name"],$num["
number"],$num["team"],$num["penalty"],$num["groundballs"],$num["shots"],$num
["faceoffs_won"
Yes, you can do this in MySql, given that you are doing it from a procedural
language. You do a "compare and swap," adding 1 to the old value, then do
an SQL update with a where clause that checks the old value. You keep doing
this until you change a row.
Here's some sample code (in SQL and J
Well, it's possible, but it's not pretty.
The right way, of course, is to have subselects. Ah, well, someday...
You can't do it using just joins (inner or outer) and where clauses. The
reason is that the joins will give you a cross product and the on clauses
and the where clauses will throw a
I have realized my error. Please disregard and ignore.
> - Original Message -=20
> From: David Potter=20
> To: [EMAIL PROTECTED]=20
> Sent: Friday, March 01, 2002 1:53 PM
> Subject: Possible bug or corruption ?
>
>
> Hello,
> I am trying t
* Benjamin Pflugmann
> On Fri, Mar 01, 2002 at 07:10:10PM +0100,
> [EMAIL PROTECTED] wrote:
> > ...but as long as 0.55-0.5 != 0.05 I will call it a bug. It may be well
> > known and hard to fix, but that does not make the expression right. :)
>
> Well, IMHO no, a bug is an unexpected flaw.
I have
I forgot that mysql reverses the month and day so I was trying to input
yesterdays date (02-28-2002) so it gave me hte default zero value since 28
isn't a valid month number! oops thanks guys.
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Ur
At 18:07 -0600 3/1/02, Alex Behrens wrote:
>Hi All,
>
>I can't figure this out for the life of me, but since I'm rather new I know
>its a simple problem. I created a table an one of the rows has a 'datetime'
>for the defintions and everytime I instert data into the table it just comes
>up as, "00-
Hi All,
I can't figure this out for the life of me, but since I'm rather new I know
its a simple problem. I created a table an one of the rows has a 'datetime'
for the defintions and everytime I instert data into the table it just comes
up as, "00-00- 00:00:00. what is the proper way to inse
Hi,
Perhaps try to suppress -e and -f switch ?
Regards,
Jocelyn Fournier
- Original Message -
From: "Eric Mayers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 12:27 AM
Subject: myismchk messages (too small length)
I'm running myisamchk (when the database
I'm running myisamchk (when the database is not running) after a dirty
shutdown and getting what appear to be errors it doesn't fix...
bash-2.04# ./myisamchk -o -s -e -f /usr/local/var/ccdata/*/*.MYI
Found block with too small length at 56452; Skipped
bash-2.04# ./myisamchk -o -s -e -f /usr/l
For what it is worth, this does NOT cause 3.23.41 to crash.
On Friday 01 March 2002 3:47 pm, Tony J. White wrote:
> Using versions 3.23.47 or 3.23.49a on linux i386 precompiled binaries.
>
> Using ORDER BY on a column that is type text causes a crash.
>
> The following MySQL Query crashes it's My
Using versions 3.23.47 or 3.23.49a on linux i386 precompiled binaries.
Using ORDER BY on a column that is type text causes a crash.
The following MySQL Query crashes it's MySQL thread:
create table test (
id int,
note text);
insert into test
Thanks. I just saw the benchmark that InnoDB has on their site:
http://www.innodb.com/bench.html
and I was fairly surprised by the speed difference between InnoDB and MyISAM
when it comes to concurrent inserts/selects. I thought the new feature of
MyISAM tables being able to do simultaneous inse
I'm doing development directly in C.
So which API is recommended..?
Wilbur
Magic phrase... sql
Putting A Human Face On Technology ;-)
Literally! http://www.TheFaceOf.com
--
Greets Folks,
Quick question here... Is there a command I can use to select the most
recent files inserted into a MySQL table?
Thanks,
=)
Will
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
---
Ronald Arenas <[EMAIL PROTECTED]> writes:
> I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
> my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
> 3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My attempt
> to install MySql 4.01 en
On Fri, Mar 01, 2002 at 01:21:52PM -0800, Jeff Kilbride wrote:
> Hi Jeremy,
>
> Just out of curiosity, what kind of tables are you using on your
> production system? MyISAM, InnoDB, a mix of the two, etc...
We're 100% MyISAM right now, but are building some new things on
InnoDB. Based on data v
I would not recommend that. I completely messed up my RH 7.2 system when I
tried to forced the MySQL install with 4.1.
I had to reinstall the system to make it function right. There might have
been an easier way to fix all the broken problems that I caused, but I
couldn't. I just moved my data
On Friday 01 March 2002 2:51 pm, Thomas LaCicero wrote:
> I am not sure if this is going to sound like a stupid question but here it
> goes...
>
> If I have a table with a Float field and, an entry in that field that has
> at least one decimal place, and I try to do a SELECT * FROM some_table
>
What is your query? What error message do you get?
On Friday 01 March 2002 2:46 pm, Alexander Shaw wrote:
> Hi,
>
> I have an application running under Access 2000 with linked MySQL tables.
>
> At the moment I m trying to run a query to populate a second table. Some of
> the data in the query is
Hi.
On Fri, Mar 01, 2002 at 07:10:10PM +0100, [EMAIL PROTECTED] wrote:
[...]
> ...but as long as 0.55-0.5 != 0.05 I will call it a bug. It may be well
> known and hard to fix, but that does not make the expression right. :)
Well, IMHO no, a bug is an unexpected flaw.
The imperfection of the flo
I am not sure if this is going to sound like a stupid question but here it
goes...
If I have a table with a Float field and, an entry in that field that has
at least one decimal place, and I try to do a SELECT * FROM some_table
WHERE some_float_field = 3.2
the query will return 0 rows even
Perhaps the rpm expects to perform a (forced) upgrade
Ç:
-Original Message-
...
Your problem is because your new compile (or binary install) is expecting
the layout previously used by mySQL v3.
...
If anyone can offer us more, please do!
LP
> I have installed MySql 3.23.49, PHP 4
Awesome thanks, I thought it was under the INSERT command at first, but I
guess its the ALTER command, thanks bro! I'll check out the online manual
some more!
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Pl
Hi Big Al:
Here is an example:
INSERT INTO friends_table(first_name,last_name) VALUES('John','Johnson');
Check out: http://www.mysql.com/doc/I/N/INSERT.html
At 15:36 3/1/02 -0600, you wrote:
>Hey All,
>
>I recently got back into mysql again and haven't programmed for it in almost
>a year and
Hi,
I have an application running under Access 2000 with linked MySQL tables.
At the moment I m trying to run a query to populate a second table. Some of
the data in the query is a text description and for some reason is throwing
up an error when I try to insert into the table. The error itself
At 21:02 +0100 3/1/02, Steve Rapaport wrote:
>I need to change the variable ft_min_word_len, in mysql 4.0.1
It's a server variable, so you set it the same way as another other
variable. Here's what's in my my.cnf file:
[mysqld]
set-variable= ft_min_word_len=3
>
>The manual doesn't say how:
>
>
Ronald,
I ran into exactly the same problem you describe after compiling a new MySQL
v4...
I think I can offer you an unsophisticated workaround (read: HACK!), but I'd
defer to others on the list who know much more about this than I do...
Your problem is because your new compile (or binary inst
Hey All,
I recently got back into mysql again and haven't programmed for it in almost
a year and have a really dumb newbie question. I need to add another row of
data to an existing table what is the command to do so? Not like an UPDATE
command where you input data into the table, but rather a wh
I'm performing a query on 2 tables:
mysql> SELECT log.id, SUM (log.hours), empnum.lname
> FROM log, empnum
> WHERE log.id = '26009'
> AND log.id=empnum.id
> GROUP BY hours;
Empty set (0.01 sec)
The log table contains id numbers (plus a bunch of other data) but no
corresponding names. The name
Hi Jeremy,
Just out of curiosity, what kind of tables are you using on your production
system? MyISAM, InnoDB, a mix of the two, etc...
Thanks,
--jeff
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Guy Davis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday
What is the memory being used for? Linux aggressively caches data, so if
most of the memory is showing up as 'cached' or 'buffered', then the high
memory usage is caused the system's normal response to lots of database
and disk activity. It's trying to keep as much data in RAM as possible.
This
PHP is looking for the client library that gets installed with MySQL
3.23.4+. Now, you can try a QUICK fix that might not work, but it's worth a
shot. Go to the directory that has the libmysqlclient.so.11 file and type
the following:
ln -s libmysqlclient.so.11 libmysqlclient.so.10
That should cr
Hi!
On Mar 01, Steve Rapaport wrote:
> I need to change the variable ft_min_word_len, in mysql 4.0.1
>
> The manual doesn't say how:
>
> Here's the closest it comes:
>
> SHOW VARIABLES shows the values of some MySQL system variables. You can also
> get this information using the mysqladmin va
On Friday 01 March 2002 9:21 am, BLANCHET wrote:
> Hi,
> Is it possible to make simultaneous 2 SQL queries in a MySQL database(
> update, insert and the other) on only 1 table. Because my DB is on a server
> and i I've 5 clients who works on the same table. Samuel
For reasonable definitions of
Hi,
Try to upgrade PHP to the latest version (4.1.2) , it should run fine.
Regards,
Jocelyn Fournier
- Original Message -
From: "Ronald Arenas" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 9:18 PM
Subject: Please Help! MySql 4.01/PhP 4.06 looking for
Ronald Arenas wrote:
>
> I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
> my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
> 3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My attempt
> to install MySql 4.01 ends there.
>
> I di
I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My attempt
to install MySql 4.01 ends there.
I did some reading and found that "libmy
I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My attempt
to install MySql 4.01 ends there.
I did some reading and found that "libmy
I need to change the variable ft_min_word_len, in mysql 4.0.1
The manual doesn't say how:
Here's the closest it comes:
SHOW VARIABLES shows the values of some MySQL system variables. You can also
get this information using the mysqladmin variables command. If the default
values are unsuitabl
Edward Peloke wrote:
>
> I am trying to get it to work more like it does in MSSQL. In MSSQL, you can
> create a db named whatever and have several different "owners" in the
> database. For example in a database named 'Eddie' I can create a table
> named ed.table1, pe.table2, etc. In MYSQL, I c
Hello,
I'm running the latest MySQL on RH Linux 7.2, and I'm trying to figure out
how to make the MySQL server accessible via the net (on port 3306, I assume).
Right now, the server is just accessible from the localhost.
-J
-
SELECT COUNT(*) AS number_of_letters FROM tablename WHERE TO_DAYS(NOW()) -
TO_DAYS(datefield) <= 30 AND status='published' GROUP BY datefield;
But this won't return anything for the days when no letters has been
published though...
Gurhan
-Original Message-
From: John Hughes [mailto:[E
I am trying to get it to work more like it does in MSSQL. In MSSQL, you can
create a db named whatever and have several different "owners" in the
database. For example in a database named 'Eddie' I can create a table
named ed.table1, pe.table2, etc. In MYSQL, I can only create tables
prefixed b
* Benjamin Pflugmann
[me about round(2.55,1) -> 2.5 or 2.6 on different platforms.]
> I would argue whether that is a bug... it is inconsistent on different
> platforms, but it is consistent with the behaviour of other programs
> on the same platform. You always break the one or the other thing.
I have a database that tracks letters to the editor published in my
paper. The table includes a date field and a status field. Status can
be either "input" or "published."
What I want to do is create a report that tells me how many letters
were published on each of the last 30 days.
Is there a
Edward Peloke wrote:
>
> I was thinking more along the lines of creating a db called test and
> creating two tables:
> test.clients and test2.clients
>
> Like you can do in MSSQL, create many table owners in the same db.
> -Original Message-
Since you read the Grant section at
http://ww
On Fri, Mar 01, 2002 at 09:49:33AM -0700, Guy Davis wrote:
> I started replicating the MySQL DB on our production server last
> month. I was wondering if anyone who has been doing replication for
> a while has seen the need to resync the slave. (i.e. snapshot the
> master, install on slave, and
At 12:27 -0500 3/1/02, Edward Peloke wrote:
>I was thinking more along the lines of creating a db called test and
>creating two tables:
>test.clients and test2.clients
Huh? Those are two tables in different databases, not two tables in
the same database.
>
>Like you can do in MSSQL, create many
I've recently upgraded to the newest version of php and since doing so
many of my pages no longer work when it comes to updating, for whatever
reason. I simply do not have the time to waste trying to figure out why
so I'm thinking of going back to the previous revision I had on the box.
I'm ru
I was thinking more along the lines of creating a db called test and
creating two tables:
test.clients and test2.clients
Like you can do in MSSQL, create many table owners in the same db.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 200
I've brand new to Mysql, and for now I have one machine, a private one, with
a mysql database. No I want to move this database over to another computer.
How do I do it?
-
Before posting, please check:
http://www.mysql.com/man
At 10:09 -0700 3/1/02, Hector Rosas wrote:
>Hello, look I'm trying to insert an Image into a blob field with a
>Normal insert query. I know that the information that will be
>contained on the blob field should be between " (quotation marks),
>but if inside the info of the image is a quotation m
Mike,
http://www.gossamer-threads.com/scripts/mysqlman/index.htm
Its good.
David
At 11:51 AM 3/1/02 -0500, Mike Baranski wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>I was wondering if anyone knows of a module for perl to talk to mysql w/o
>DBI/DBD. Some sort of shell interface o
At 11:51 -0500 3/1/02, Mike Baranski wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>I was wondering if anyone knows of a module for perl to talk to mysql w/o
>DBI/DBD. Some sort of shell interface or something.
DBI is mature technology, you're probably better off using it.
Perhaps its
Hello, look I'm trying to insert an Image into a blob field with a Normal insert
query. I know that the information that will be contained on the blob field should be
between " (quotation marks), but if inside the info of the image is a quotation mark
it should be escaped with a \ (back slash).
Hi.
On Fri, Mar 01, 2002 at 01:14:43PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> there are a couple of bugs related to the round() function. (See the thread
> 'Can somebody help me with "round (columna,columnb) "?')
>
> One bug is already well known and documentet, it is related to different C
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I was wondering if anyone knows of a module for perl to talk to mysql w/o
DBI/DBD. Some sort of shell interface or something.
Mike.
- --
*
* Mike Baranski *
* Security Managment Consulting *
* 919-78
I started replicating the MySQL DB on our production server last month.
I was wondering if anyone who has been doing replication for a while has
seen the need to resync the slave. (i.e. snapshot the master, install
on slave, and re-start replication from snapshot)
Are there systems out there th
Hello sql guru's, I need help find SQL to solve a problem:
I have two tables, the first is persons:
person_id int unsigned not null auto_increment
firstname varchar(25)
lastname varchar(25)
The second is person_orgs
person_id int unsigned not null
org_id int unsigned not null
A person may be
Hi all,
I have a seperate linux server with just mysql running on it. But there are
alot of other things that I may need to take off. Anyway yesterday I
noticed after running TOP that the memory usage was real high. I did a
shutdown and checked it after the reboot and the memory usage was way d
Cip,
Friday, March 01, 2002, 6:12:54 PM, you wrote:
C> I just made the stupidest mistake I ever done:
C> I installed mysql on a RH Linux machine. And as usual I wanted to setup the
C> users I need and take out the ones that I don't. Only when I executed a
C> query, I did not realize that inste
This is the sort of thing I would do
$tmpquery = "SELECT item_pic, cat, sub, item_name, username FROM item_name
WHERE 1=1 AND";
if($category)
{
$filter1 = " cat =\"";
$filter1 .= implode("\",\"",$category);
$filter1 .= " \" ";
$tmpquery .= $filter1;
$tmpquery .= " AND ";
}
if($subcat)
{
$filter2
Hi,
Is it possible to make simultaneous 2 SQL queries in a MySQL database( update,
insert and the other) on only 1 table.
Because my DB is on a server and i I've 5 clients who works on the same table.
Samuel
-Message d'origine-
De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Date:
Hi all,
I just made the stupidest mistake I ever done:
I installed mysql on a RH Linux machine. And as usual I wanted to setup the
users I need and take out the ones that I don't. Only when I executed a
query, I did not realize that instead of deleting two users I deleted all
users...
And gu
I was wrong. My slave servers are STILL 'hanging' and not continuing
to replicate. They give no errors, the slave appears to stay running,
it just lags behind the master. Nothing I have done has fixed this.
Again I'm running 3.23.49.
To "fix" the problem I issue a slave stop, slave start comm
Keith,
At 21:51 2002-02-28, you wrote:
>That has certain advantages, but it's a pain for the user if it's in
>a application where you have to enter a lot of dates or fill out a
>form repeatedly. For that sort of data entry, typing digits is far
>preferable to selecting from a dropdown list.
Edward,
Friday, March 01, 2002, 5:25:23 PM, you wrote:
EP> Is it possible to specify more than one owner in a mysql db? I want to
EP> create tables with different owners.
Yes, it's possible. You can specify many users with different grants
on the same database, table, column...
You should use
Paolo,
Friday, March 01, 2002, 4:58:54 PM, you wrote:
PC> Hello,
PC> can MySQL manage transactions?
PC> Someone said me no. Is it true?
MySQL has transaction-safe tables, such as InnoDB and BDB. InnoDB and BDB
tables are supported in MySQL-max.
Take a look at the following links where you will f
At 10:25 -0500 3/1/02, Edward Peloke wrote:
>Is it possible to specify more than one owner in a mysql db? I want to
>create tables with different owners.
Databases and tables in MySQL don't have owners. They just exist.
But you can grant access to them by more than one MySQL user account,
if th
I am attempting to generate a query statement (using PHP) that is generated
based on user input from 2 sets of checkboxes. You can see a
barely-functioning version at this URL:
http://www.nobleaccord.com/view/view.php
The top part of the form just shows what the query statement looks like.
The
At 14:20 +0800 3/1/02, [EMAIL PROTECTED] wrote:
>Hi, all
>
>How to get the e-books of My SQL via download.
>
>Thanks , Dominic ZHOU
The MySQL Reference Manual is available at: http://www.mysql.com/
Safari has some MySQL books: http://safari.oreilly.com/
The listings include MySQL (New Riders) a
I need to have unique id's for every data element in my system no matter which table
it's in. In Oracle I can create a sequence and with one SQL query I can increment the
value and retrieve it for use in my next insert.
Can I do this in MySQL? I know about AUTO INCREMENT but that appears to
Hello,
Today, I compiled MySQL (mysql-3.23.49.tar.gz) on a Debian Potato system. I
configure'd with following options:
./configure --prefix=/usr/local/mysql --with-innodb
"make" and "make install" ran without any problems. Then I followed the
instructions in the INSTALL-SOURCE file. Everything
1 - 100 of 150 matches
Mail list logo