In Sum(), join people IDs to people IDs, not to event IDs.
In the article, the SQL statement is mostly ok, but the explanation
section proves, once again, that I shouldn't be proofreading my own stuff.
I've cleaned it up, so there won't be any more errors until I look at
it the next time.
On
> mysql_select_db("books");
> $query = "SELECT * FROM books WHERE ".$searchType." LIKE
> '%".$searchTerm."%'";
> $result = mysql_query($query);
>
> $num_results = mysql_num_rows($result); //This is where I am getting the
> error actually: "Warning: mysql_num_rows(): supplied argument is not
On Wed, Jan 22, 2003 at 06:44:11AM +0100, Daniel Kiss wrote:
> Hi all,
>
> Can anyone tell where can I find some documentation about the new features
> released in MySQL 4.1?
The features aren't all there, but here's what I've seen (and used) so
far:
* mixing of character sets in a table
*
ERROR 2002: Can't connect to local MySQL server
through socket '/var/run/mysql/mysql.sock' (38)
I've been reading and searching the documentation for
hours and I know this is simple to fix but I can't
figure it out. I've been at it for our hours. The
mysql directory above does not exist but if I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Here's the syntax I use.
$db=mysql_connect( "$host", "$db_user","$db_password")
or die ("".mysql_error()."");
mysql_select_db("$db_name", $db);
$rs
checkout http://www.webyog.com/
sql,query
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
-
Before postin
Hi All,
Could any one tell me how to get the
Indian Languages Support in MySQL???
Regards,
N.Velmani
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
I've been reading every e-mail I could find within this list that talked
about ReiserFS within the last year and I've found very little information
on is ReiserFS really better than ext3. I did find that almost everyone
said that ReiserFS handled large amounts of files much better than ext2 or
ext
Hello all,
I've tried the following sql queries:
mysql> create table a(id int unsigned not null auto_increment primary key,
name text);
Query OK, 0 rows affected (0.01 sec)
mysql> insert into a values(null, 'one'), (null, 'two');
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Wa
Hi all,
Can anyone tell where can I find some documentation about the new features
released in MySQL 4.1?
Thanks,
Daniel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
Hi Josh,
I'm hesitant to make the following suggestion, mainly because I'm not
terribly clued up with SQL myself, however the following APPEARS to
deliver something close to what you're looking for. It relies on
breaking your recordsets into 3 tables, as your situation appears to
already do, 1 for
How about (not to be rude, but that do it for me!! attitude should not be
accepted) you go to mysql.com, or google and type in those same two
questions... Much faster.
-Chris
On Tuesday 21 January 2003 07:16 pm, M A wrote:
> hi,
>
> would someone please tell me how to create mysql user?
maybe its best to echo your entire query string and post back as $searchType
could be anything , also a good way to check your query , is echo your query
string then do an sql query in phpmyadmin.
>= Original Message From "Lane Johnston" <[EMAIL PROTECTED]> =
>Ok php gurus,
>Little info
On Wed, 2003-01-22 at 00:31, Lane Johnston wrote:
> $query = "SELECT * FROM books WHERE ".$searchType." LIKE
> '%".$searchTerm."%'";
echo $query;
It might help seeing query syntax.
__
/ \\ @ __ __@ Adolfo Bello <[EMAIL PROTECTED]>
/ //
Check out urSQL from http://www.urbanresearch.com/ursql
You might also have a look at the MySQL website, there are many different
clients available...
On Tue, 21 Jan 2003, David Driscoll wrote:
> I have a fairly basic mysql database running on unix. Now I need to make this
> data available to ot
Greetings
Try SQLyog at
http://www.webyog.com/sqlyog/download.html
Its the best i know and also it works like butter on
remote connections
karam
--- David Driscoll <[EMAIL PROTECTED]> wrote:
> I have a fairly basic mysql database running on
> unix. Now I need to make this
> data available to ot
At 23:10 -0500 1/21/03, Stephen Tiano wrote:
mysql
Thanks for responding, Paul. What's interesting is that pet.txt was
still "not found" when I used the path as you suggested. What would
be the reason for it being "invisible"?
That that isn't really the correct path. I was just guessing what
Ok php gurus,
Little info on system: XP, localhost, port 3306
i am tring to connect to a db in mysql and i looks like that I am doing
something wrong?
Here is the code...
@ $db = mysql_pconnect("localhost:3306", "omegaweb", "jesus316");
if( $db ) { echo "Connected"; }
if( !$db )
{
echo "Er
On Tue, 2003-01-21 at 15:51, Josh L Bernardini wrote:
> I can't come up with the join syntax to mimic this subselect query to list
> people not attending an event (*epeople.eid == event.id):
>
> select people.id as pid, concat(lastname, ", ", firstname) as name from
> people where people.id not in
Currently I have three InnoDB log files, whose size is 256MB and main
memory is 2GB.
Since I use 1GB of InnoDB buffer pool, I think log files'd better get
bigger to some extent;
possibly 1GB.
You know, only changing the value in my.cnf cause mysqld not to start
due to error.
I'm wondering if
mysql
Thanks for responding, Paul. What's interesting is that pet.txt was
still "not found" when I used the path as you suggested. What would be
the reason for it being "invisible"?
Steve Tiano
So I issue the command
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
and, for the first
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld &
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done./safe_mysqld
leo:/usr/bin # cd /var/lib/mysql
leo:/v
Certainly.
http://www.mysql.com/doc/en/User_Account_Management.html
On 22 Jan 2003 06:50:27 +0800, Jon Miller wrote:
>> Is there a way to check or view in mysql what permissions users have to certain
>> databases?
>--
>Jon Miller <[EMAIL PROTECTED]>
>MMT Networks Pty Ltd
---
Thats what was strange with the results. One of the meetings the user was
attending had a value of 9, the other 0.
Might just give up doing this and use 2 queries to accomplish the same so
don't spend anymore time on it unless your curious yourself.
thanks just the same,
jb
|-+--
At 21:42 -0500 1/21/03, Stephen Tiano wrote:
Okay, I found User Comments at the end of the section of the user
manual online that contained the info I needed to get the option of
loading a textfile into a table.
The startup line I use for that is:
/usr/local/bin/mysql -u root --local-infile
Maybe I'm dumb for saying this, but sql joins seems expensive to do in
terms of performance (yes, I indexed the joined fields). If I do a query
search of a 2,600,000 record defendant table WITHOUT a join (SELECT
DISTINCT CaseNumber FROM Defendants WHERE Defendant LIKE "owen%" OR
Defendant LIKE
Maybe I'm dumb for saying this, but sql joins seems expensive to do in
terms of performance (yes, I indexed the joined fields). If I do a query
search of a 2,600,000 record defendant table WITHOUT a join (SELECT
DISTINCT CaseNumber FROM Defendants WHERE Defendant LIKE "owen%" OR
Defendant LIKE
Hi there,
I'm trying to set up replication between two RH7.2 Linux servers running MySQL
3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual
(section 4.10 Replication in MySQL), and when I do the following command on the slave:
change master to master_host='db1', ma
¿ ?
OT.
Defryn, Guy wrote:
Is it possible to detect mysql servers on the network without knowing the hostname?
cheers
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
At 15:33 +1300 1/22/03, Defryn, Guy wrote:
Is it possible to detect mysql servers on the network without
knowing the hostname?
cheers
Is there a discovery protocol? No.
sql, query
-
Before posting, please check:
http://w
Okay, I found User Comments at the end of the section of the user manual
online that contained the info I needed to get the option of loading a
textfile into a table.
The startup line I use for that is:
/usr/local/bin/mysql -u root --local-infile -p menagerie
where 'menagerie' is the databa
On Tue, 2003-01-21 at 23:12, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply
hi,
would someone please tell me how to create mysql user? and how to set the
mysql root password?
Thanks
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
On Tue, Jan 21, 2003 at 01:38:42PM -0800, Josh L Bernardini wrote:
>
> Bob,
> First of all, thank you. I never would have gotten here on my own. Only I
> am not quite there.
> Using your example, I have managed to list all the events a person is
> attending and not attending. Wondering if you migh
Is it possible to detect mysql servers on the network without knowing the hostname?
cheers
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Dave,
> I am looking for an
> easy to use, easy to install mysql client which would enable users to
query
> my database.
What about a web browser? It's most probably installed on all laptops.
You could use some simple PHP script (not as mighty as phpMyAdmin, I
would suggest) to convert SQL queri
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Hi,
I'm running Connector/J 2.0.14 with J2SDK1.4.1_01. Prior to these upgrades, all my code ran fine. However, I upgraded all my packages (MySQL, J2SDK, and to Connector/J, as already stated) and now I keep getting an IOExcep
Nothing's wrong with Linuxthreads :)
But eventually the SA stuff that FreeBSD has chosen to implement will give
better performance than kernel threads, so I was asking when the Mysql team
was thinking of tackling getting a binary out for 5.0.
Peter
<^_^>
-Original Message-
From: Jeremy Z
Have you check out MyCC from mysql.com ?? It can be used as a front-end of
MySQL.
Cheers,
Michael
-Original Message-
From: David Driscoll [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 3:53 PM
To: [EMAIL PROTECTED]
Subject: simple windows client for mysql
I have a fairly ba
>I am looking for an
>easy to use, easy to install mysql client which would enable users to
query
>my database. It seems that installing mysql server for windows on
each
>machine would do this but it seems like using a shovel to swat a fly.
>Suggestions? Cheap is good too.
Try SQlyog
http://
Kris,
- Original Message -
From: ""Krzysztof Karski"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, January 21, 2003 11:35 AM
Subject: replication problems with InnoDB tables...?
> So I have been reading a lot lately about replication but I can't find a
> good sum
On Mon, Jan 20, 2003 at 02:20:10PM -0500, Grigor, Peter wrote:
> Alrighty then!
>
> Now FreeBSD 5.0 has been released, what are the plans for mysql to evaluate
> the new (really new :) thread implementation.
What's wrong with LinuxThreads on FreeBSD? It works great with
FreeBSD 4.x.
Jeremy
--
Solaris 8 (sparc)
gcc 3.2
Configuring from source version mysql-3.23.54a
2 problems:
1. I get a checksum error when untar'ing the tgz file found on any of the
download servers.
2. config.status: error: cannot find input file: readline/Makefile.in
The directory exists, but there are no files.
An
Hello all,
sorry if this maybe a bit OT, but we've seem to be getting this error 110:
Connection timed out.. from our Perl scripts connecting to our MySQL database...
is this perl or the mysql server related issue ?
thx's
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Inter
Bob,
First of all, thank you. I never would have gotten here on my own. Only I
am not quite there.
Using your example, I have managed to list all the events a person is
attending and not attending. Wondering if you might provide some further
clues as to how to restrict the query to those events a
Hi,
I'm running Connector/J 2.0.14 with J2SDK1.4.1_01. Prior to these upgrades, all my
code ran fine. However, I upgraded all my packages (MySQL, J2SDK, and to Connector/J,
as already stated) and now I keep getting an IOException. Why is this happening? I've
thought about the timeout scenario b
Hi,
Indeed...this happend in both main version of MySQL (ver. 3.x and 4.0.x)
However ,if you use :
select * from test_table where NAME='2';
you will have the correct result.
Regards,
Gelu
___
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAI
I have a fairly basic mysql database running on unix. Now I need to make this
data available to other people. These would be various engineers and
administrators using every version of windows from 95 (japanese version) to
XP all using laptops connected to our internal network. I am looking fo
"ppl1" converted to numeric is 0.
You are compareing to a number.
Valdir Stiebe Junior wrote:
Sorry, correcting my last email, the sql result the two rows when i use
'NAME = 0'.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Valdir Stiebe Junior" <[EMAIL PROTECTED]>;
I just tried it myself and I get an empty set as expected.
What do you get when you do a 'select * from test'?
> -Original Message-
> From: Valdir Stiebe Junior [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 22 January 2003 5:48 am
> To: [EMAIL PROTECTED]
> Subject: Re: Hi and why
>
> > I
Hi !!!Anybody can help me with this problem?
Thanks
I've just installed Control Center
Version:
0.8.9-beta Linux (Intel glibc 2.2 systems, static) (3.1M)
Operating System RedHat 7.1
When I try to execute the program it have the following error
[root@LINUX1 mysqlcc]# ./mysqlcc
Segmenta
At 18:11 -0200 1/21/03, Valdir Stiebe Junior wrote:
> I'm stlll surprised that NAME = 2 returns anything. When I tried your
example, it returned no rows. I get two rows with NAME = 0, nothing
with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
NAME =
> I'm stlll surprised that NAME = 2 returns anything. When I tried your
> example, it returned no rows. I get two rows with NAME = 0, nothing
> with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
> NAME = 0 is a string-to-number conversion. MySQL converts th
At 16:47 -0200 1/21/03, Valdir Stiebe Junior wrote:
> I don't know why it returns the first two rows, but (assuming you didn't
really end your query with two question marks) what error are you
expecting
to occur?
I didn't end my query with the two question marks. :)
And if i put 0 instead
I can't come up with the join syntax to mimic this subselect query to list
people not attending an event (*epeople.eid == event.id):
select people.id as pid, concat(lastname, ", ", firstname) as name from
people where people.id not in
(select epeople.pid from
epeople
left join people on epeo
Frank,
> Yep Jermey are right what he says - Anyone know about using Database
link in Mysql???
This is not built in. You will have to do this within your application.
You can also use some of the MySQL helper apps for this, like mysqldump
in combination with mysql (the command line tool), like t
Sorry, correcting my last email, the sql result the two rows when i use
'NAME = 0'.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Valdir Stiebe Junior" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 4:33 PM
Subject: Re: Hi and why
> At 15:02
Craig,
> I want to have users give a description in a form and varchar(255)
wont give
> me enough space so I thought I would use text(650) but it seems the
'text'
> type wont take the limit of (650), it simply offers the user (65535):
way
> too much.
In MySQL, you have TINYTEXT (2**8 = 256, like
You are looking for a list of people rather than a list of events and
the people attending them. So you want to start your select from People,
not from Events. Get a list of all the people, then filter out those
attending event id 2. You don't want to start you select from epeople
because then
Well...I uninstalled mysql and installed it again and I still can't get the service to
run!!!???
==BEGIN FORWARDED MESSAGE==
> From: "FlashGuy" <[EMAIL PROTECTED]>
> To: "FlashMX" <[EMAIL PROTECTED]>
> Date: Tue, 21 Jan 2003 09:05:52 -0500
> Reply-To: "FlashGuy
On Tue, Jan 21, 2003 at 08:43:29AM -0800, Josh L Bernardini wrote:
>
> I have three tables, people, events and epeople. epeople includes a person
> id and an event id and works as a list of people attending events in the
> database.
>
> The following query returns a list of all the people partici
> I don't know why it returns the first two rows, but (assuming you didn't
> really end your query with two question marks) what error are you
expecting
> to occur?
I didn't end my query with the two question marks. :)
And if i put 0 instead of (2 or any different of zero) after the equal sign
the
On 21 Jan 2003, at 17:27, Craig melia wrote:
> I want to have users give a description in a form and varchar(255)
> wont give me enough space so I thought I would use text(650) but it
> seems the 'text' type wont take the limit of (650), it simply offers
> the user (65535): way too much.
Use a TE
Yep Jermey are right what he says - Anyone know about using Database link in Mysql???
Regards
Frank
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Egor Egorov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 4:35 PM
Subject: Re: Mysql and
At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote:
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and have to acomplish some tasks using a mysql based database. So
i'm looking about how things work in mysql.
My question... i created a table TEST, with two column
At 17:27 + 1/21/03, Craig melia wrote:
Hi
I am building my 1st app in php with Mysql and I hope you can help.
I want to have users give a description in a form and varchar(255) wont give
me enough space so I thought I would use text(650) but it seems the 'text'
type wont take the limit of (6
Your joins are probably not using indexes and the tables could be joining in
an inefficient order. Try running an explain on your query to see how it is
being done.
-Original Message-
From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 1:31 AM
To: [EMAIL PROT
If you want to limit the amount of text coming in or going out, wouldn't it
be easier to it either in your php script or constrain the html textarea?
Just a thought.
-Chris
>> -Original Message-
>> From: Craig melia [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, January 21, 2003 12:28 PM
Hey all,
I hope you can help with this issue, as it seems to be something wrong with my MySQL
installation: I recently upgraded my RedHat install, and in doing so upgraded Java and
MySQL. I had JDBC code which worked perfectly prior to the upgrade, but now cant
connect. It continuously tells me
Hey All,
I want to install the mySql 4.0.9 to try out some features but I want to
make sure my 3.23.54 release stays 100% as is.
I'd like to have both servers running, using different data dirs etc. etc.
In short I don't want anything at all shared between the two.
I've read a bunch of docs on th
I would like to get the difference of the results from query 2 and query 1,
or the people not attending event [id 2] (referenced by epeople.eid).
Thought the answer would be query three, but as you see, I get an empty
set. Any advice would be appreciated.
jb
Here is everyone attending the event [
Hi,
I didn't test this.
Assuming that Swordfish.scanner.scanner_id <> 0 for all rows (and
that's why it doesn't appear in the results list from the first query):
SELECT InteractV2.Job_Queue.TargetRange AS TargetIP,
IFNULL(INET_NTOA(Swordfish.scanner.ipaddr),'ANY SCANNER') AS ScannerIP
FROM In
EL día Mon, 20 Jan 2003 16:22:55 -0500
Walter <[EMAIL PROTECTED]> escribió:
-->I have a Red Hat 7.3 box running MySQL 3.23.49 (installed with the Red Hat
-->rpms). I am about to upgrade to 4.0.9 and would prefer using the RPMs from
-->MySQL. My plan was to just un-install the Red Hat rpms and
Hi
I am building my 1st app in php with Mysql and I hope you can help.
I want to have users give a description in a form and varchar(255) wont give
me enough space so I thought I would use text(650) but it seems the 'text'
type wont take the limit of (650), it simply offers the user (65535): way
Hi,
substr() doesn't exist in MySQL.
Use substring().
UPDATE DocComms SET ItemHSCode = concat(substring( ItemHSCode, 1, 4 ),
substring( ItemHSCode, 6, 2 ), substring( ItemHSCode, 9, 2 ))
On Tue, 2003-01-21 at 15:34, Don wrote:
> Hi,
> RESENT DFUE TO TYPO
>
> I want to change a field in a tab
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and have to acomplish some tasks using a mysql based database. So
i'm looking about how things work in mysql.
My question... i created a table TEST, with two columns, ID_TEST int(11) and
NAME varchar(50).. and added
I have three tables, people, events and epeople. epeople includes a person
id and an event id and works as a list of people attending events in the
database.
The following query returns a list of all the people participating in a
particular event
given an event id.
select people.id as pid, conca
* Don
> I want to change a field in a table. Currently the data is in
> theformat -->
> 4818.50.00
> I want to remove the decimal points so that it is like --> 48185000
> I tried the sql code below but am getting a syntax error. Can someone
> please point out the error of my ways?
>
> UPDATE DocC
* Jonas Eriksson
> We are upgrading our mysqlserver to 3.23.54 from a old one.
> But we can't get mysqldump to import all the tables to the new
> server becouse some of the table names have - sign in it. Like ip-number
>
> Is it any way to come around this error or do we have to contact our
> cust
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Clemente --
...and then Clemente said...
%
% Hi,
Hi!
% Thanks a lot for all those replies! It seems like my hosting company is using the
cheapest and/or easiest way to make a full, consistent backup. And I guess the
Happy to help. Yes, it sound
* Philipp Sutter
> Am Die, 2003-01-21 um 15.03 schrieb Roger Baklund:
> > * Philipp Sutter
> > > I have a Mysql-table with a field of type double. when i retrieve
> > > very small
> > > numbers from this table I get them allways in a scientific notation:
> > > i.e. 8.34e-05. what i have to do, that
On Tuesday 21 January 2003 16:06, Alejandro C. Garrammone wrote:
> The problem is this. Always when I start the server, when I try to show the
> table mysql, I get an error message that saids "Access Denied to user "
> but when I put the same command with the --user=root it works.
> the questi
On Tuesday 21 January 2003 17:11, Jonas Eriksson wrote:
> We are upgrading our mysqlserver to 3.23.54 from a old one.
> But we can't get mysqldump to import all the tables to the new
> server becouse some of the table names have - sign in it. Like ip-number
>
> Is it any way to come around this e
Clemente wrote:
The question is then whether such backup is necessary on a daily basis
I run incremental tapes hourly at some client locations. You may only
need weekly backups. If the server room filled with water tomorrow and
you had to return to your last backup, when do you want that b
In the last episode (Jan 21), Ken Menzel said:
>Thanks for that information, does that mean (for us simple SQL
> guys) that even though I am running 5.0RC3 and can compile and
> install MySQL just fine (from ports or with my own script) it is
> using the threads library from 4-STABLE branch no
Read up on the GRANT command in MySQL. This sets up the security level
for the tables, hosts and even columns. MySQL defaults to only allowing
the localhost to connect ot the database, which is fine if you are
running the webserver and something like PHP on that computer. Once you
separate them
Hi,
Thanks a lot for all those replies! It seems like my hosting company is using the
cheapest and/or easiest way to make a full, consistent backup. And I guess the
ideal method from those mentioned is to have a slave server you can take down for
backup.
The question is then whether such backup i
Hi,
RESENT DFUE TO TYPO
I want to change a field in a table. Currently the data is in theformat -->
4818.50.00
I want to remove the decimal points so that it is like --> 48185000
I tried the sql code below but am getting a syntax error. Can someone
please point out the error of my ways?
UPDATE
Hi,
I want to change a field in a table. Currently the data is in the
format --> 4818.50.00
I want to remove the decimal points so that it is like --> 4818.50.00
I tried the sql code below but am getting a syntax error. Can someone
please
point out the error of my ways?
UPDATE DocComms SET Item
Roger Baklund:
> * Philipp Sutter
> > I have a Mysql-table with a field of type double. when i retrieve
> > very small
> > numbers from this table I get them allways in a scientific notation:
> > i.e. 8.34e-05. what i have to do, that i get the same number in normal
> > notation: 0.834?
>
>
Hi!
On Jan 21, Dennis Kruyt wrote:
> Hi,
>
> When I try the hoagie_mysql exploit from http://void.at/releases.html
> on a 3.23.54a MySQL server (witch sould be safe) then i can crash the
> database with this.
>
> How did I do it?
>
> I start hoagie_mysql with a valid db user (not root). Then pr
Steve Quezadas wrote:
However. I notice that if I do two separate searches it goes quicker
(about 2.5 seconds combined). I can do a criteria search on defendants
and then put all the resulting case numbers in a temporary table. Then
do a join of that temporary table to the much smaller Cases t
Hi
We are upgrading our mysqlserver to 3.23.54 from a old one.
But we can't get mysqldump to import all the tables to the new
server becouse some of the table names have - sign in it. Like ip-number
Is it any way to come around this error or do we have to contact our
customers
to make them chan
David T-G wrote:
Hmmm... Speaking as a SysAdmin, that looks like a cover-all-bases
general announcement.
I was going to say the same thing; its always good (legally) to say you
might be down, instead of doing it and having people sue you.
Indeed. If your provider is going to take down your
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alex --
...and then Alejandro C. Garrammone said...
%
% The problem is this. Always when I start the server, when I try to show the
% table mysql, I get an error message that saids "Access Denied to user "
% but when I put the same command with t
At 09:05 21/01/2003 -0500, FlashGuy wrote:
Hi,
Hi,
I had MYsql running on a nt4 server and w2k server. I uninstalled it a few
weeks ago and just recently tried installing it again. The install went
fine but when I start the service I
keep getting an error no maater what I try. Using localhost
Hello,
Here is a set based solution.
Using v4.0.6 gamma on w2k pro.
CREATE TABLE broad (name varchar(10) not null,
groups varchar(20) not null,
primary key (name));
INSERT INTO broad values("DOG","1,3,4,2"),
("CAT","2
Hi Dan,
Thanks for that information, does that mean (for us simple SQL
guys) that even though I am running 5.0RC3 and can compile and install
MySQL just fine (from ports or with my own script) it is using the
threads library from 4-STABLE branch not the new threads?
Also does this have soemthi
On Tuesday 21 January 2003 09:56, Saju Pappachen wrote:
> In my MySQL I have 3 tables like this and I have a pblm. in setting the
> foreign key.Pls. help
[skip]
> create table employee_skill_details(EMP_ID int(10) not null references
> employee_details(EMP_ID), SKILL_ID varchar(5) not null refere
The problem is this. Always when I start the server, when I try to show the
table mysql, I get an error message that saids "Access Denied to user "
but when I put the same command with the --user=root it works. the question
is: How can I start the server whit root priviledges?
thxs.
Alex.
-
1 - 100 of 129 matches
Mail list logo
