I am new to both PHP and MySQL (I have experience in ASP) and am trying
to get my server running both. I can connect to the MySQL server under
DOS using the command line and can create new databases this way. I want
to create a web data site so I need to accomplish this via HTML. I have
tried to
In http://slashdot.org/article.pl?sid=01/09/13/154222&mode=thread, it is
written:
- Writing and reading to the same innodb MySQL tables can be done since it
does row-level locking. But as load increases, it can start being less than
desirable.
-
Dear Friends & Future Millionaire:
AS SEEN ON NATIONAL TV:
Make over half million dollars every 4 to 5 months from your
home for an investment of only $25 U.S. Dollars expense one time
THANKS TO THE COMPUTER AGE AND THE INTERNET !
==
BE A MILLIONAI
OK quick question, Is there a limit to the amount of data the can be defined
when I create a field as a set. I am looking to have about 39 words in there
at the moment I have them in another table and have an index pointing to
them, but would like to move them to a set. if it is possible
thanks
> >
> > If I try gzip -cd DBI-1.18.tar.gz
> >The entire archive just decompresses and flashes across the console
> > never to disk..
> >
> > Tried to uncompress on two machines same results
> >
> > Caldera Linux kernals 2.2.14 and 2.2.10
>
> as you're using Linux, try
>
> tar xzf DBI-1.18
Woops! Nevermind. I didn't notice your data was denormalized.
- Original Message -
From: "Chris Johnson" <[EMAIL PROTECTED]>
To: "Jamie Burns" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 10:33 PM
Subject: Re: surely an easy quick one
If you want a count f
If you want a count for a specific team:
Select count(*) From table Where team = 'support';
If you want the counts for all the teams:
Select team, count(*) From table Group By team;
- Original Message -
From: "Jamie Burns" <[EMAIL PROTECTED]>
I have a table (ref, name, team, seminar_r
What data type should be used to store jpeg with MySQL connecting with VB
ADO. I think the answer would probably be Blob or Long Blob, but how? VB
complains MySQL's Long Blob data type is not compatible!
-Jason
-
Before posting
At 8:36 PM -0500 9/14/01, Deryck Henson wrote:
>I need to know the type of data to use for me to put in an IP Address. I
>tried INT and BIGINT. Neither worked HELP! I need this for my database
>bad!
If you expect to represent them in dotted-quad notation, use CHAR(15).
If you want to represen
I need to know the type of data to use for me to put in an IP Address. I
tried INT and BIGINT. Neither worked HELP! I need this for my database
bad!
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check
>I have FreeBSD 4.3-stable release. Yes the ports collection was also
>upgraded. How do i know the version of ports collection.
>
>thanks,
>siva
>
>
>
>What version of FreeBSD do you have installed? Was it upgraded from an
>earlier version? If so, was the ports collection upgraded as well?
>
>T
indrek siitan writes:
> Hi,
>
> > SO this does seem like a bug .. hope MySql guys see this. I have
> > looked but can't find anything about how to contact in case of bugs ..
>
> mail to [EMAIL PROTECTED] :-)
er, [EMAIL PROTECTED]
--
For technical support contracts, visit https://order.mysql
I have FreeBSD 4.3-stable release. Yes the ports collection was also
upgraded. How do i know the version of ports collection.
thanks,
siva
-Original Message-
From: Chris Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 7:15 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
d00d. manual. search it.
http://www.mysql.com/doc/S/o/Sorting_rows.html
ORDER BY VOTES DESC
dpk
- Original Message -
From: "Russ" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 3:27 PM
Subject: mySQL: ORDER
> how do i sort my results by reverse order ?? s
At 11:27 PM +0100 9/14/01, Russ wrote:
>how do i sort my results by reverse order ?? say the collume containts 1 2 3
>4 , if i use ORDER BY VOTES it returnes 1234 but i wont it in revers 4321
>etc is there any way i can do this with a sql function?
ORDER BY VOTES DESC
DESC = descending (reverse
In the last episode (Sep 14), Russ said:
> how do i sort my results by reverse order ?? say the collume containts 1 2 3
> 4 , if i use ORDER BY VOTES it returnes 1234 but i wont it in revers 4321
> etc is there any way i can do this with a sql function?
ORDER BY VOTES DESC
--
Dan Nelson
how do i sort my results by reverse order ?? say the collume containts 1 2 3
4 , if i use ORDER BY VOTES it returnes 1234 but i wont it in revers 4321
etc is there any way i can do this with a sql function?
Russ
-
Before posti
Can someone recommend an intro MySQL book. I'm looking for a
book with info on MySQL internals from the dba standpoint
as well as usage from a developer standpoint. I'm going to
take a look at MySQL by Paul Dubois. It seems to have good
reviews, but would be interested in other recommendations.
Has anyone used MySQL with perl to create a web interface with a database
that contains 100 or more tables that have 200,000 to 500,000 rows of data
each? I am interested to know if any performance issues have been
encountered and if any solutions were found. We are looking to create a new
service
"Shane Corgatelli" <[EMAIL PROTECTED]> writes:
> > It compiles here, on a Roswellish system (and slightly different
> > opions - no Gemini, only BDB and innodb)
>
> I removed the --with-gemini option and everything compiles beautifully. I
> tried it with the mysql+gemini-3.23.41 source and I st
> It compiles here, on a Roswellish system (and slightly different
> opions - no Gemini, only BDB and innodb)
I removed the --with-gemini option and everything compiles beautifully. I
tried it with the mysql+gemini-3.23.41 source and I still get errors.
I wanted to compare Innobase and Gemini,
At 11:17 AM -0700 9/14/01, Igbar Foosenhopper wrote:
>FYI ..
>
>I just tried this my self with
>
>CREATE TABLE 010823 (tstamp TIMESTAMP (14) ,
>name VARCHAR (10) not null , PRIMARY KEY (tstamp), INDEX (name))
>
>and got ...
>
>MySQL said: You have an error in your SQL syntax nea
Try this:
SELECT news.NEWSID, news.DATETIME, authors.AUTHOR, count(comments.CID) as
NUMCOMS from news LEFT JOIN authors ON news.AUTHORID=authors.AUTHORID LEFT
JOIN comments ON news.NEWSID=comments.NEWSID GROUP BY news.NEWSID ORDER BY
news.DATETIME;
I havent tested this, and you may have to add n
i have been running 3.22.25 on solaris 7 for quite a while. i ran into a
problem with it a few days ago where it basically took forever to delete
rows (these are huge tables - several million rows, with lots of indexes,
and i needed to delete some millions of rows... i started it, and let it
I would even suggest not using zcat given the solaris version only
examins .Z files.
try:
cat DBI-1.18.tar.gz | gunzip - | tar xvf -
this should work on all versions of solaris any just about any other
unix (assuming gzip is installed with a working tar)
"Adams, Bill TQO" wrote:
>
> rjtalb
hi !
seems like - if
Win32 static binary of MySQLGUI 1.7.5-2
( found at http://www.mysql.com/downloads/gui-mysqlgui.html )
seems to be "down/missing"...
please fix - it - thanx
lg
fred
-
Before posting, please ch
Hello,
On Fri, 14 Sep 2001, powlow wrote:
> fine. d122001 is also fine. is it not possible to create tables with only a
> number as the name? is there a way round this?
mysql> CREATE TABLE `123` (id INT);
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
++
| Tabl
Hi,
> SO this does seem like a bug .. hope MySql guys see this. I have
> looked but can't find anything about how to contact in case of bugs ..
mail to [EMAIL PROTECTED] :-)
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/
Sending this out again, haven't gotten any help yet.. anyone?
-Original Message-
From: Chad Day [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 9:38 AM
To: mysql
Subject: problems with a fairly basic join..
been banging at this for a while, can't get my head around it.
3 ta
Yup. amazingly enough the password entry in the user table was empty.
I have no idea how this was empty. I am the only admin on the machine and I
didn't do it.
mysqladmin Ver 7.11 Distrib 3.22.22, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.22
Protocol ve
FYI ..
I just tried this my self with
CREATE TABLE 010823 (tstamp TIMESTAMP (14) ,
name VARCHAR (10) not null , PRIMARY KEY (tstamp), INDEX (name))
and got ...
MySQL said: You have an error in your SQL syntax near '010823 (tstamp TIMESTAMP (14) ,
name VARCHAR (10) not null ,
At 6:39 PM +0100 9/14/01, powlow wrote:
>Hi,
>
>first posting to the list so hello. My name is Paulo. I live and work in
>lisbon, portugal.
>
>question : i want to create a table each month. want to call it somehting
>like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is
>fin
You're a good man Charlie Brown!!!. You were right on the money. I found
the module on CD2, loaded it, rebooted the server and I was off to the
races. Works perfectly. Life is good when you get good advice. Thanks.
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
Hi!
On Sep 10, [EMAIL PROTECTED] wrote:
> Where can I find a description of the algorithm that mysql uses for
> weighting results from a full text search?
in the source myisam/ftdefs.h
> Is there a way to provide some user specified criteria to alter the
> weighting? (i.e. a callback mechanis
Hi,
> I wanted to download the MySQLGUI 1.7.5 source code, but I couldn't.
> The erroneous link was:
> http://mirrors.sunsite.dk/mysql/Downloads/mysqlgui/mysqlgui-1.7.5.tar.gz
>
> mirrors.sunsite.dk is for sale now and only displays nasty commercials
> when accessed.
hm, from where I'm at, the
powlow wrote:
> first posting to the list so hello. My name is Paulo. I live and work in
> lisbon, portugal.
>
> question : i want to create a table each month. want to call it somehting
> like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is
> fine. d122001 is also fine. is
> After untaring each with tar -xvf this create's each new directory.
>
>
> /usr/local/mysql-3.22.32
> /usr/local/apache_1.3.20
> /usr/local/PHP 4.04i
>
> Next cd to mysql and
> ./configure then make and last make install
>
> Next cd to Apache
> Apache 1.3.20 Next
> ./configure -enabl
I have an error situation that I cannot resolve. I have a number of MySQL
DBs on a FreeBSD server and use MyODBC to hook into them via an MS-Access
front end. All goes well in that setup. Recently I had a few site migrate
to a RedHat server. I set up MySQL on the new server and all went wel
"Jason Radley" <[EMAIL PROTECTED]> writes:
> I have tried also and nothing. I have added the phpinfo(); and it tells me
> the configure command says --without-mysql
Because it's not compiled statically into the binary. It's compiled as
a separate module, so you won't have to install libraries y
"Dr. Randy Frid" <[EMAIL PROTECTED]> writes:
> I've tried that to no avail. Everything on my system works perfectly except
> for this. The MySQL website indicates the following:
Tried what? There is a specific php-mysql module. When you install
that (restart of apache may also be necesarry), i
Hi,
first posting to the list so hello. My name is Paulo. I live and work in
lisbon, portugal.
question : i want to create a table each month. want to call it somehting
like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is
fine. d122001 is also fine. is it not possible to c
*mysql-list has an annoying filter*
[EMAIL PROTECTED] writes:
> >Environment:
>
> System: Linux homer 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown
> Architecture: i686
It would be useful if you made sure that all errata are applied to
your machine, and then try again - the simples
My Steps
Everything is built in /usr/local and untar'd using -xvf
MySQL First of course
I left this out since it's straight forward. ./configure make make install
Apache 1.3.20 Next
./configure -enable-module=most --enable-shared=max
***(This enables the DSO support) ***
make then make in
I have tried also and nothing. I have added the phpinfo(); and it tells me
the configure command says --without-mysql
No ideas here.
-Original Message-
From: Dr. Randy Frid [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 10:53 AM
To: Jason Radley; Trond Eivind Glomsrød
Cc: [E
I've tried that to no avail. Everything on my system works perfectly except
for this. The MySQL website indicates the following:
---
Error: "Fatal error: Call to unsupported or undefined function
mysql_connect() in .." This means that your PHP version isn't compiled with
MySQL support.
I have the exact problem. If anyone has a step by step for a newbie I'd
appreciate it as well.
Cheers, Randy
- Original Message -
From: "Jason Radley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 9:06 AM
Subject: configure with mysql
> I have installed
"Jason Radley" <[EMAIL PROTECTED]> writes:
> I have installed redhat linux 7.1 with apache, php and mysql
> but when installed redhat it didn't add the configure --with-mysql it
> added --without-mysql is there any way to change this to configure
> --with-mysql.
Just install the php-mysql packa
>Description:
I am attempting to compile 3.23.42 for testing the innodb and
gemini tables. I'm also going to test the RAID tables. The
configure works fine. However, when the compiler enters the
sql directory there is an error in field.cc, this is shown below
Your original message got through the first time, but your email bounced.
I think what you are looking for is called mifluz and is the indexing
library that htdig uses. The link is http://www.gnu.org/software/mifluz/ .
If you develop any kind of bindings to use mifluz to index a mysql database
l
Dave McNicholl wrote:
> Hi,
> I have had a mysql database for a few years now. It is used for auth
> against apache using mod_auth_mysql. My apache conf has the username and
> password in it. These have not changed for some time.
> Now when I use mysqldump -u username -p mysql and
I have installed redhat linux 7.1 with apache, php and mysql
but when installed redhat it didn't add the configure --with-mysql it
added --without-mysql is there any way to change this to configure
--with-mysql.
Thanks
-
Before
rjtalbo wrote:
> I have been trying to uncompress DBI-1.18.tar.gz which I downloaded
> together with
> Msql-Mysql-modules-1.2216.tar.gz &
> Data-ShowTable-3.3.tar.gz
>
> from the MySQL down load page...
> I followed the direction in the DBE-1.18 README but if I use the pipe
> as instruct
Hi,
I have had a mysql database for a few years now. It is used for auth
against apache using mod_auth_mysql. My apache conf has the username and
password in it. These have not changed for some time.
Now when I use mysqldump -u username -p mysql and supply the correct
password I
On Friday 14 September 2001 18:31, rjtalbo wrote:
> I have been trying to uncompress DBI-1.18.tar.gz which I downloaded
> together with
> Msql-Mysql-modules-1.2216.tar.gz &
> Data-ShowTable-3.3.tar.gz
>
> from the MySQL down load page...
> I followed the direction in the DBE-1.18 README b
Hello,
I'm using a simple master-server replication setup for all the
databases. It is great, but sometimes someone tries to insert
something into the slave database by mistake. I would like to prevent
this, but I also mirror the mysql database (so if something happens
with the master,
>From http://www.mysql.com/doc/N/u/Numeric_types.html
The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as
permitted by the SQL92 standard. They are used for values for which it is
important to preserve exact precision, for example with monetary data. When
declaring a colum
I have been trying to uncompress DBI-1.18.tar.gz which I downloaded
together with
Msql-Mysql-modules-1.2216.tar.gz &
Data-ShowTable-3.3.tar.gz
from the MySQL down load page...
I followed the direction in the DBE-1.18 README but if I use the pipe
as instructed... gzip -cd DBI-1.18.tar.gz
>From http://www.mysql.com/doc/N/u/Numeric_types.html
The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as
permitted by the SQL92 standard. They are used for values for which it is
important to preserve exact precision, for example with monetary data. When
declaring a colum
O.k, how about this query.
SELECT DISTINCT name,count(1) AS numPeople FROM tester Where team
='support'
GROUP BY team
Its a bit dirty and it returns an extra column, but this could be ignored
--
Colin
-
Before posting,
Hi,
> SELECT COUNT(DISTINCT name) from tester WHERE team = 'support'
Could 2 queries do the trick?
insert into temptable
select count(name) from tester
where team = 'support'
group by team;
select count(*) from temptable;
Best Regards,
Sasa
P.S. create table temptable(tempfield integ
Please ignore my last post. I had lost track of what you were trying to
achieve with your query.
--
Colin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Go to http://www.mysql.com/doc/ and read through it. Pay very close attention to
http://www.mysql.com/doc/U/s/User_Account_Management.html the answere to your question
is in there.
Cheers
M;)
-Original Message-
FROM: jean.schuller
TO: Liste mysql
DATE: Fri 9/14/01 8:12
SUBJECT: New d
there is no password yet. so leave the -p option out.
jean.schuller wrote:
> Hi all,
>
> I installed a new linux Red Had version onto a PC.
> In this Linux, mysql(version 3.23.39) is already installed
> and mysqld is running. So I want to build a database
> with m
I am running a stats page for our Genome@Home team, and I'm trying to get a
simple SELECT that will get the data that I need...
Ok, I have a table setup like this:
Genomestats
---
usernamevarchar(255)
curDate datetime
wucount bigint
At 03:58 PM 9/14/01 +0200, jean.schuller wrote:
> I'm under root and say :mysql -u root -p password and
> mysql says ERROR 1045: Access denied for user: 'root@localhost'
>(Using password: YES)
> What can this password be ?? where can I get it ??
Did you set a password with
I am running a stats page for our Genome@Home team, and I'm trying to get a
simple SELECT that will get the data that I need...
Ok, I have a table setup like this:
Genomestats
---
usernamevarchar(255)
curDate datetime
wucount bigint
Hello,
Is there a way to force the queue to flush? That would be very nice. In
delphi and interbase I would use transactions. I would start a transaction
and process it every 1000 records. This was pretty efficient and the number
of records depended on the amount of ram.
Mark
p.s. your english
Yup, you're right. I told you I wasn't an SQL guru :-)
How are you running the query, and what do you want to
do with the number? If you're calling it from Perl then you
could run a variant of the query I gave and just look at
how many rows there are in the result.
On the other hand, I think if
>>
> this doesnt work as i need either :o(
>
> it returns 3 rows, each with a count of 3 inside. i just want to get a
> *single row* with the number 3 in it (for my example).
>
>
You just need to add another clause to the where statement
> > SELECT COUNT(*) FROM table WHERE team = "support" AN
Ok, here is my first suggestion, having worked with both now for a while.
Don't use the rs.open property. Not only is it slower, but it is more prone
to errors... So try it this way:
strSQL = "SELECT username, codeid FROM user_votes WHERE username = '" & user
& "'"
Set rs = dbconn.Execute(strSQ
Ok, i have figured it out...
SELECT COUNT(DISTINCT name) from tester WHERE team = 'support'
But this doesnt work on my development box which runs an older version of
mysql! Does anybody know how to get this type of functionality without the
DISTINCT keyword inside count?
:o)
Jamie.
- Orig
Hi all,
I installed a new linux Red Had version onto a PC.
In this Linux, mysql(version 3.23.39) is already installed
and mysqld is running. So I want to build a database
with mysql but whatever I try to type, I have systematically
errors messages
this doesnt work as i need either :o(
it returns 3 rows, each with a count of 3 inside. i just want to get a
*single row* with the number 3 in it (for my example).
:o(
thanks for trying though...
- Original Message -
From: "Lezz Giles" <[EMAIL PROTECTED]>
To: "Jamie Burns" <[EMAIL PROT
Hi,
idname group_name
--
> 1bill support 100
> 2bill support 101
> 3bill support 102
> 4bendevelopment 201
> 5bendevelopment 103
> 6bendevelopment 204
> 7bobs
this doesnt work as i need :o(
it returns a count of 9, not 3 in my example.
i want to know how many *individual* people are in the database for a given
'team'. in my example there are three in 'support' (this is what i want to
know), and they are each in the table three times (this is where yo
hi
just to say thanks for your help.
it appears my problems were caused by different versions of myql. apparently
UNIQUE command was introduced in MYSQL3.23 and my server is running
MYSQL3.22.25
the code that worked in the end was:
mysql> create table saveMovie (
-> id int not null auto_incr
Hi
One of your redirections has ceased working.
I wanted to download the MySQLGUI 1.7.5 source code, but I couldn't.
The erroneous link was:
http://mirrors.sunsite.dk/mysql/Downloads/mysqlgui/mysqlgui-1.7.5.tar.gz
mirrors.sunsite.dk is for sale now and only displays nasty commercials when
acces
>
> select count(*) from table where team='support' group by team
>
>
I think that should be a group by name not by team.
--
Colin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hello,
My idea is to have several (about 3) databases. Each DB will have one
admin, who is responsible for this DB and doesn't have access to other DBs.
The problem is, how to set privileges?
I did:
GRANT ALL PRIVILEGES on DB1.* to admin1@localhost WITH GRANT OPTION;
Then if admin1 is connec
been banging at this for a while, can't get my head around it.
3 tables, one called news that stores news items, one called comments that
stores user comments, one called authors that holds the author of the news
items name. I am trying to display the news item with the authors name, and
count t
I haven't tested this; I'm not an SQL guru. I just
like a challenge :-)
SELECT COUNT(*) FROM table WHERE team = "support" GROUP BY name;
Lezz Giles
- Original Message -
From: "Jamie Burns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 9:08 AM
Subject: sur
select count(*) from table where team='support' group by team
-Ursprüngliche Nachricht-
Von: Jamie Burns [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 14. September 2001 15:09
An: [EMAIL PROTECTED]
Betreff: surely an easy quick one
Hello again :o)
This is surely an easy quick one but m
Create an /etc/my.cnf file and
add entries for the socket location.
Bobby Chopra wrote:
> 'which mysql' just kicks back the expected '/usr/bin/mysql'
>
> The MySQL install was clean.
>
> Bobby
>
> - Original Message -
> From: "Thomas Spahni" <[EMAIL PROTECTED]>
> To: "Bobby Chopra" <[
Then add a language column and initialize it to the table name.
Deryck Henson wrote:
> Sure...
>
> SQL Query:
>
> SELECT * FROM asp, c, cpp, java, javascript, coldfusion, xml, pascal, vb,
> perl, cgi, php, assembly, python where user = '"&user&"'
>
> (gets an ambiguous error and I know why)
'which mysql' just kicks back the expected '/usr/bin/mysql'
The MySQL install was clean.
Bobby
- Original Message -
From: "Thomas Spahni" <[EMAIL PROTECTED]>
To: "Bobby Chopra" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 12:45 PM
Subject: Re: Connection
add buyer_name index for each table.
Simon Buchanan wrote:
> Huston we have a problem:
>
> table1:
>
> purchase_order (primary key)
> client_number
> buyer_name
>
> table2:
>
> client_number
> buyer_number
> buyer_name
>
> (all three combine for the primary key for table2)
>
> Query:
>
>
Hello again :o)
This is surely an easy quick one but my brain wont work!
I have a table (ref, name, team, seminar_ref) like:
1billsupport100
2billsupport101
3billsupport102
4ben development 201
5ben development 103
6ben
On Fri, 14 Sep 2001, Philippe Parmentier wrote:
> > as per the manual, when joining 2 tables, if one entry is not found in the
> > second table , a null records is displayed, but in that small example,
> > it's not working like this:
Philippe,
the very fine manual says:
* If there is no ma
On Fri, 14 Sep 2001, Bobby Chopra wrote:
> Slight problem that's confusing me a bit.
>
> Upon connection to mysql using 'localhost' I get the age old error 'Can't
> connect ... through /tmp/mysql.sock'
>
> Before anyone screams - read the archive etc. I have tackled this problem
> before but th
> as per the manual, when joining 2 tables, if one entry is not found in the
> second table , a null records is displayed, but in that small example,
> it's not working like this:
>
> CREATE TABLE test1 (
> number tinyint(3) unsigned NOT NULL DEFAULT '0' ,
> PRIMARY KEY (number));
>
> INSERT
Dear Mysqlers
mysql_config in the linux binary distro appears to have two similar bugs
...
When run it returns:
Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags[-I'/usr/local/mysql/include/mysql']
--libs [-static -L'/usr/local/mysql/lib/mysql
Hello,
I want to add a new function to mysql. Because i use mysql for windows and
there is not implemented adding function through the UDF interface, i must
add native function. I did it according to manual, but when i use a new
function in select command, it generate error.
I think that descripti
Slight problem that's confusing me a bit.
Upon connection to mysql using 'localhost' I get the age old error 'Can't
connect ... through /tmp/mysql.sock'
Before anyone screams - read the archive etc. I have tackled this problem
before but this time I am slightly confused.
The socket that mysql s
Bernard,
it is not a bug: in MySQL the LOCK TABLES
command commits the current transaction.
It is in the manual :). The reason is
that in MyISAM a transaction is simulated
by LOCK TABLES where you lock all the involved
tables at once to avoid deadlocks.
With InnoDB use of LOCK TABLES is normally
On Friday 14 September 2001 12:43, Steve McKeogh wrote:
> How do I get Japanese text to be inputted into a mySQL database and get to
> pull out correctly on the page.
>
> I've tested it already by inserting some dummy Japanese text and it inputs
> itself into the database as complete jibberish. Ho
How do I get Japanese text to be inputted into a mySQL database and get to
pull out correctly on the page.
I've tested it already by inserting some dummy Japanese text and it inputs
itself into the database as complete jibberish. How can I solve this?
--
IMHO it's possible but not the best way.
It would be better, if you change the start-Script
and point the data-dir to the new location.
Stefan
-Ursprungliche Nachricht-
Von: Keith Woodworth [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 14. September 2001 06:18
An: [EMAIL PROTECTED]
Betref
Try to load MySQL with out --skip-grant-tables.
Then you can see what is in your pass word db..
Simon
-Original Message-
From: David Tomsett [mailto:[EMAIL PROTECTED]]
Sent: 14 September 2001 10:05
To: [EMAIL PROTECTED]
Subject: FW: Stuck!
Hi,
I'm moving my intranet to a new server. I
Hown do I connect to a MySql database that is outside the firewall with
mysqlgui?
Jens Erik
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
Hi,
I'm moving my intranet to a new server. It's running Red Hat 7.1, Apache
1.3.19 and have installed mysql 3.23.36 during setup. Previous server was
running Red Hat 6, Apache 1.3.12 and mysql 3.22.32.
Copied the mysql database files from the old server to the new but can't
access the database
1 - 100 of 101 matches
Mail list logo
