I am using mysql version 4.0.12 on a solaris sparc box. My server has
stopped creating the log-bin files although it is defined in my.cnf. The
directory permissions of the data directory are fine. What is wrong with
the setup?
Sohail
--
MySQL General Mailing List
For list archives: http://lis
I have the following setup :
Apache 2 + mod_perl 2
mysql 3.23.54
I need to is measure the perfomance of a ticketing system (written in
perl)which has web interface (html::mason, apache2) with Mysql as a
backend. Users of the ticketing system can only connect to the backend
via the web interface a
Hello all.
I am working with MySQL 4.0. I have a requirement to create a data-driven
Web page to display Chinese text from a MySQL table. I'm completely new to
this, can someone tell me exactly what I need to do to make this happen?
1. For example, how do I insert the Chinese text from my source
Joshua,
Joshua Spoerri wrote:
On Tue, 5 Aug 2003, Alexander Keremidarski wrote:
MySQL will never use any index for small tables. With just few rows using index
adds overhead only. Table scan is faster in such cases. This is docummented behaviour.
is 100,000 rows small? my simple OR queries take
> Hi,
>
> I don't know if it has anything to do with your problem, I just wanted to
> comment on the use of a timestamp column in a primary key...
>
> * David Bordas
> > +--+--+--+-+-+
> > +
> > > > | Field| Type
Hi,
This is my first post here so forgive me if its too simple or not right.
basically what i do is:
SELECT COUNT(*) FROM table1 where cno=3;
(and dumping it into a variable $theResult - I am using PHP)
and it gives me the result, but now i need to do this in 5 tables...
I can of course run 5 cou
When I try to import a text file with new data for an existing
table I get the error "1148 - the used command is not allowed
with this MySQL version."
I have tried with both PHPMyAdmin2.3 and with MySQLFront 2.5.
Both these GUI programmes have an "import from text file" command
which I have used s
You are referring to fragmentation. In this case I'm pretty sure it's
just a matter of updating the indexes so that MySQL makes the correct
assumptions about the distribution of data. MySQL assumes data values
have an equal distribution in a database, updating the indexes will
force MySQL to u
Eddie,
- Original Message -
From: "Eddie" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, August 07, 2003 11:06 AM
Subject: transfer InnoDb in correct order ??
> Hellu,
>
> I want to transfer the structure of my InnoDb database to another
> mysql server 3.23.
> H
Is mysql still in business? Their web page is down.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 11:16 -0400 8/7/03, [EMAIL PROTECTED] wrote:
Hi all,
Just a quick question here.
May I know how to get a result without heading in Mysql (like "set heading
off" in Oracle) ?
Thanks and regards,
Helen
The context of your question is unclear, but if you're talking about
issuing clients using the
For MYISAM tables selects cause table locks while INNODB does row level
locking.
Now if your select is taking a long time you might want to look at your
index schema. If that does not work for you then split up your data.
-->-Original Message-
-->From: xuefer tinys [mailto:[EMAIL PROTECTE
At 11:32 -0700 7/31/03, Grant Cooper wrote:
I am opening 4 different databases and was hoping when I do a mysql_query I
could just grab the connection id rather than reconnecting everytime I want
to query a new database.
But what does that have to do with wanting a unique identifier?
If you want t
when i show processlist
1 of my queries is "sending data" (SELECT ...)
while others queries (SELECT/UPDATE) is "locked"
what's up?
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list a
Check you mysqld server veriable thread_concurrency. I'm not sure that
this will solve your problem since your problem has changed from a
select locking to concurrent selects.
-->-Original Message-
-->From: xuefer tinys [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, August 07, 2003 11:18 A
Dear list,
does anyone know what it means when it says state = NULL doing the "show processlist"?
Thanks
Bernd
=
Please note that this e-mail and any files transmitted with it may be
privileged, confiden
-->-Original Message-
-->From: Ian Neubert [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, August 07, 2003 1:00 PM
-->To: Dathan Vance Pattishall
-->Cc: [EMAIL PROTECTED]
-->Subject: RE: MySQL Replication
-->
-->Off hand do you know any good resources on how to setup a highly
-->available
-
On Thu, Aug 07, 2003 at 05:42:12PM -0400, Bernd Jagla wrote:
> Dear list,
>
> does anyone know what it means when it says state = NULL doing the "show
> processlist"?
Usually you see this when the 'command' is sleep. That means the
thread is idle.
--
Jeremy D. Zawodny | Perl, Web, MySQL,
At 14:37 -0700 8/1/03, Ray Kiddy wrote:
I am trying to insert data using the C API.
Particulars:
OS: Mac OS X 10.3 (7A179)
MySQL: MySQL 4.1.0-alpha
table type: tried both MyISAM and InnoDB
I have a table:
mysql> describe testtable;
++-+---+--+-+-+--
Greetings all.
I have a bit of a problem here, a database i'm administering was somehow corrupted,
and i'm unable to recover it in any way. Is there any way at all to recover a corrupt
InnoDB database? (I read on innodb.com that it is impossible, but hope it is not)
When I run a query from any
I just installed mysql 4.0 .There were many problems
with upgrading from 3.23 to 4.0 so I deleted 3.23 and
made a fresh start with 4.0. Everything works fine now
but the only problem to connect to the server is via
the /usr/local/mysql/bin directory. Is there a way to
connect if I am root. thanks f
The PHP one is indeed used less, probably by about 10% of the users
while it's being tested. I was simply wondering if the idle timeouts
were possibly responsible for the CPU usage problems, and I thought
(rightly or wrongly?), that setting the 'xxx_timeout' options would
close those persistent co
scuse the ignorance are u saying high cpu usage is better used on one query
or better be freed up for other queries ? ram is always an issue as the
queries get buffered
> Jonathan Hilgeman wrote:
>
>>Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
>>considering moving to a P4 2 Gh
Testing ..Please ignore this email
Hi!
On Aug 07, Nils Valentin wrote:
> [Warning: LNG TEXT - enjoy ;-)]
>
> Hi Victoria,
>
> sorry for the misunderstanding. I just tried to reproduce the sample. While I
> have records what I did I did not write down all commands exactly as they
> are.
>
> The problem(s) occured on Redhat
[snip]
It's a little messy but that's the only other way I can think of doing
it.
Sorry.
[/snip]
If he has the file locally to himself he can do this via phpMyAdmin
through the load text file option. Depending on the version there is
always a way to load files ... even to remote servers
For i
We just installed mysql 4.0.14 on an xserve. When trying to add users via
mascon I'm finding an issue I have not seen in previously releases. When
adding a user it seems that the new column ssl_cipher is a required field.
I know this is new for v4 but is it supposed to be a required field? What
I was trying to design it so that the slaves wouldn't know they had
connected to a different master, as they both masters would have the same IP
address that gets failed over based on the Linux Virtual Server software and
VRRP (like heartbeat from Linux-HA).
I'm beginning to think that my configur
> >How can I see if a record was deleted from a database?
> You can attempt to SELECT it, and if you get no result, it's not there.
> But that doesn't necesarily mean that it was once there and has now been
> deleted. If you want to determine that, you'll need to create a log
> of record deletions
FYI
After digging out some documentation ( RFM indeed ) it is all so simple in
DBD::mysql ...
As of version 3.23.49 LOCAL within LOAD DATA _may_ be disabled in the
_client_ library. By adding an option to the DSN-string within the connect
statement the function is re-enabled at the client side too
Yes, I think you're right on that. Any idea what the cause might be or what
I can do to find out? I do have a core file, but I'm at a loss as to what to
do with it...
Original Message Follows
From: Sergei Golubchik <[EMAIL PROTECTED]>
Subject: Re: myisamchk Illegal Instruction
Date: Fri,
lol mysqladmin -u root -p create database desenv ??
> Hi,
>
> I was received a error when I was trying to create a new database on
> freebsd 5.1, mysql 4.0.14. The "test" database is working well.
>
> COMMAND:
> mysqladmin create desenv
> or
> mysql
> create database desenv;
>
> ERROR:
> mysqladmi
Patrick,
You need "outer joins" to do this. Try searching for "outer join sql
tutorial" on Google.
Hope this helps,
Andy
> -Original Message-
> From: Patrick Crowley [mailto:[EMAIL PROTECTED]
> Sent: 07 August 2003 16:51
> To: [EMAIL PROTECTED]
> Subject: STUMPED: How Can I Pull Relate
> "ORing on two different fields" is what I have been asking about :).
This is not optimized, and I don't think it is set to be optimized until
5.1 (as per someone else's comment).
> Using a composite index was suggested
This is bad information. It works for AND, not for OR.
You have two workar
exactly, NULL is a good thing. It means that php isn't constantly
tearing down sessions and starting new ones. The connect process is
virtually always the longest step of the query (except the big queries,
but the goal is to keep them minimized in an application and use good
design, indexes, etc.
I've noticed that when I reboot a hung server (S1) that was using mod_perl
to gain access to a remote mysql server (S2), the mysql threads on S2
persist even after S1 returns to active duty.
This can (did) lead to the dreaded "Too many connections" error.
I really don't want to hup S2/mysqld if
"adrian GREEMAN" <[EMAIL PROTECTED]> wrote:
> I have also read the manual section on this {as I should have
> done] to try and understand it
> and how to enable reading a local file - the discussion section
> seems confusing and confused.
>
> I tried following what others have done and
> modified
On Thu, Aug 07, 2003 at 03:22:58PM -0700, Ian Neubert wrote:
> Good question :)
>
> I got a message from a person off the list that suggested I use
> network disk mirroring or a NAS/SAN/NFS system to handle that. I'm
> not sure if the mirroring would be 100% perfect, but the NAS/SAN
> solution sho
"Paulo Fonseca Jr." <[EMAIL PROTECTED]> wrote:
>
> I was received a error when I was trying to create a new database on freebsd
> 5.1, mysql 4.0.14. The "test" database is working well.
>
> COMMAND:
> mysqladmin create desenv
> or
> mysql
> create database desenv;
>
> ERROR:
> mysqladmin: CREA
Joseph Maxwell <[EMAIL PROTECTED]> wrote:
>
> I am uploading records from a user data entered log file with
> mysqlimport on a periodic basis. I would like to prevent the duplication
> of records to keep the system non-redundant. How can I best achieve
> this?
Create UNIQUE key on those columns t
> Sounds as if your table is not normalized for that kind of query. If
> there are multiple directors id'd by multiple movies you could left
> outer join the movie.id with the director.id
>
> Make sense?
Actually, it's normalized beyond that.
Sometimes, movies have more than one director, so th
On Fri, Aug 01, 2003 at 03:31:02PM +0100, Khaled D Elmeleegy wrote:
>
> I am studying the scalability of MYSQL on SMPs on Linux. I am
> wondering if any one has performed scalability studies. If so, I
> would be interested in a pointer to the results; if not, I am
> curious if there is interest i
On Fri, Aug 08, 2003 at 04:30:21PM -0500, Jackson Miller wrote:
> I am going to have to put MySQL on it's own box, and I am wondering what makes
> the biggest difference with hardware.
>
> I am hoping to set max_connections to 1000 at least (and I will probably use
> at least 500 several times a
* Dan Jones
[...]
> This leads me to another question. What's the standard way of handling
> something like the author of a book when you have a collaboration or an
> anthology with multiple authors?
Normalizing.
> The only way I can think of to handle it is to have a sentinel value
> that indic
[snip]
Can any 1 tell me whats the up level commands are well u might know what
i
mean i know windows servers uses this type of way to go back a level
such as
..\root-folder\ but whats Linux ? on my linux server how could i go
back a
level to go to another folder ? i already tried using ..\ but it
On Thursday, August 14, 2003, at 08:04 PM, Jennifer Goodie wrote:
I have 2 tables used for an online calendar...
first table fields: primary_key , start_date, event_name,
event_description
second table fields: primary_key, end_date
Tables fields are shortened and can't be changed.
My second tab
Hi Ulises,
Is that option only available on a Windows MySQLCC ??
I didnt find it on the linux version.
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 9日 土曜日 01:47、Cabanillas Dulanto, Ulises
さんは書きました:
> The option "Automatically limit SELECT queries to " must be set in the
> Query Config
> It looks like Igor comitted it to the 4.1 tree on the 2nd of this
month:
I'd assume that this change is necessary but not sufficient for the
MySQL table type table locking issue...
I know, I know, there is InnoDB for that, but there are reasons not to
use it despite this particular wonderful ad
>Description:
ft_dump failed to link on Tru64 UNIX V4.0F with gcc 3.1:
/bin/ksh ../libtool --mode=link gcc -O3 -DDBUG_OFF -mieee
-DUNDEF_HAVE_GETHOSTBYNAME_R -o ft_dump ft_dump.o libmyisam.a ../mysys/libmysys.a
../dbug/libdbug.a ../strings/libmystrings.a -lm -lpthread
gcc -O3 -DDBUG_OFF
James Johnson wrote:
Hi,
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11. Can someone tell me why
this SQL query isn't working?
$ISBN = $_GET['isbn'];
$query = "SELECT * FROM book_details WHERE ISBN = '$ISBN'";
Since the
> I have 2 tables used for an online calendar...
>
> first table fields: primary_key , start_date, event_name,
> event_description
> second table fields: primary_key, end_date
>
> Tables fields are shortened and can't be changed.
>
> My second table only contains events that have a end date. I want
--- Begin Message ---
On 8/9/03 11:20 PM, "Andreas" <[EMAIL PROTECTED]> wrote:
Andreas,
Thanks for the help...
The error log shows:
030810 14:52:48 mysqld started
030810 14:52:49 InnoDB: Started
030810 14:52:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
0308
In my earlier post i forgot to mention about limit,10,20 to be added in
query.
- Original Message -
From: "Binay Agarwal" <[EMAIL PROTECTED]>
To: "Roger Davis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 5:22 AM
Subject: Re: Quick ones to speed up acces!
> Tha
In the last episode (Aug 09), Vinod Bhaskar said:
> I have MySQL 3.23.41 in my Mandrake Linux 8.1. I am using PHP 4.0
> queries to access the MySQL database, in Apache 1.3.2 environment.
>
> Now a days, some of my php modules are very slow. eg., earlier a
> report generation program in PHP use
I forwarded your mail to the mysql list so that everyone who cares knows
what is going.
Bill Hernandez wrote:
The error log shows:
030810 14:52:48 mysqld started
030810 14:52:49 InnoDB: Started
030810 14:52:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
030810 1
The following program will solve your problem. Feel free to miss use ;)
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
81/1-A North Jatrbari
Dhaka 1204
Bangladesh
sms://+447765341890
sms://+880171859159
http://www.ceobangladesh.com
http://www.DhakaStock
Richard,
> thd->query at 0x89af670 = SELECT * FROM order_data WHERE viewed='' ORDER
> BY order_num DESC
what does
SHOW CREATE TABLE order_data;
say?
What does
CHECK TABLE order_data;
say? Does it print anything to the .err log in the MySQL datadir?
Please resolve the stack trace below:
> S
I have uninstall and reinstall mysql 2 to 3 three times at my home. I am trying to
create a database by doing some inserts but it will not let me. It is just blank. I
would really like to know what I am doing wrong or do I just need to remove all the
components and start over again?
I do not kno
On 11 Aug 2003 at 8:49, James Johnson wrote:
> I'm building a member signup form. Fields that contain more than one
> word are being truncated when being inserted into the MySQL table.
It's very unlikely this has anything to do with MySQL or PHP. It
sounds like you're missing quotes around the
On Fri, Aug 08, 2003 at 12:10:18PM -0400, Adam Nelson wrote:
> Also, one has to work out the cost of high availability. If you're
> talking about a situation where you reduce downtime from 4 hours/yr to
> .5 hours/yr and it costs you x dollars, you have to make sure that the
> extra 3.5 hours of d
On Thu, 14 Aug 2003 16:48:15 -0700, Jonathan Hilgeman wrote:
>> >Delete anonymous user('') from table user. Don't forget about FLUSH
>PRIVILEGES.
>> >
>> Thanks, that worked. Why?
>
> I suggested this yesterday, at the very beginning of Mark's
>question, and I also suggested it again today in a pr
Hi all,
Does anyone have any suggestion for converting a Sequel database to MYSQL?
I just want to copy a Sequel database data to a Mysql one.
Thanks in advance for any suggestion,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
I have 2 tables used for an online calendar...
first table fields: primary_key , start_date, event_name, event_description
second table fields: primary_key, end_date
Tables fields are shortened and can't be changed.
My second table only contains events that have a end date. I want to create
a qu
what ever happend to a unique primary key like userID ?
>>> "gord barq" <[EMAIL PROTECTED]> 08/11/03 11:15am >>>
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how
MySQL does not use an index when you do "%blah%". It would use the index
for "blah%" however. See the following reference.
http://www.mysql.com/doc/en/MySQL_indexes.html
I would suggest you alter your tables to use a FullText Search.
http://www.mysql.com/doc/en/Fulltext_Search.html
Roger
> --
Hello Guys,
Is there support for ADO?
Im a proffesional Delphi developer and must access mySQL via ADO.
Kind Regards,
Lennie De Villiers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all
Is there anybody out there who has managed to successfully configure
Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a couple
of hundred users at any one time? I have chucked absolutely everything
I can think of at this, but the MySQL (it seems) simply eats all the
available
I would like to know (if possible, there is no explanation in the documentation) the
exact meanning of the column "time" in the "show processlist" command.
Why is it sometime so hight ?
When is it reinitialize (and why) ?
Is there any correlation between the time column and the variables "wait t
I'm looking for any online resources/tutorials and such about transactions.
Preferable for MySQL, but others will do.
Other than that, is there any good book about transactions. Again preferable
for MySQL.
/T
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
Thanks to both Ed and Amer for the excellent suggestions.
This is definitely the time in my project for db changes :) I think you've
both nailed what fundamental I was missing. In the long run, a bit of
re-thinking now will simplify a lot down the road.
Ed, sorry to be so dense, but by PK field d
Hi Daniel,
Here's what is echoed back. It looks valid to me.
SELECT * FROM book_details WHERE ISBN = '1---1'
James
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 5:40 PM
To: James Johnson; [EMAIL PROTECTED]
Subject: Re: MySQL field
Hi about 2 months ago I had trouble with alter table on large tables
blocking all database activity and started a thread on this list called
"alter table blocks other tables!"
I tried to resolve the problems by upgrading to mysql 4.0.14, putting
the database that I needed absolute best performa
may be you can check whether the older version is uninstalled properly before
trying the new version .
if u installed using rpm , then rpm -qa shows all the installed files .
System wrote:
> Hello All,
>
> I have compiled mysql-4.1.13 using the binary package these were my
> configure options
>
Jeremy Zawodny wrote:
On Tue, Aug 12, 2003 at 02:32:00PM +0800, Ariz Jacinto wrote:
i've created a simple UDF (for testing) that returns a string.
my problem is that the string that it returns, contain some
of the characters of the longest string in the column.
example:
Table
+
I can use innodb in Redhat9 but failed in redhat 7.2. I find the
version of mysql in both redhat is identical. I wonder why it is the
case.
Version of mysql
mysqladmin Ver 8.23 Distrib 3.23.56, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This
Hi Kim,
no offense, but are you actually using the JOIN syntax correctly ?
Could you post your query please ?
My guess is you are doing a JOIN without any set conditions. hat would give
you the result as described (which is normal). You would use the WHERE clause
or for a LEFT JOIN ...the ON c
Gary
Does your php code use persistent connections?
mysql_pconnect() rather than mysql_connect() ?
If so, that would ramp up the CPU usage fairly quickly, AFAIAA.
Just a thought
Terry
--Original Message-
> Hi all
>
> Is there anybody out there who has managed to successful
how can it be confusing ? nobody ever experienced it before?
simply when you join 2 tables together if you get 5 records from the second
table the first table will display 5 times aswell
> Hi Daniel,
>
> I am still not sure what exactly you are trying to achieve.
>
> If you specify the WHERE cond
While logged in to my Linux server as root, I went in to MySQL and (with no
databases selected, so that the "GRANT" statement would apply globally),
ran the command:
mysql> grant all privileges on * to bhaselto identified by '';
where is, of course, the password I wanted to use for the user
'
Hi,
I'm running mysql version 4.0.13 and trying to create a temporary table
from a php script. For some reason, even though I have the permission
set up correctly, I can't seem to create a temporary table from the
script. The permission say that create_tmp_table_priv=Y for the user in
my connectio
On Wed, Aug 13, 2003 at 12:58:06AM +0530, Binay Agarwal wrote:
> Hi
>
> While using OR in the query, Mysql doesn't use indexes.. right? Hence takes more
> time.
>
> If queries have to be ORed on various coloumns (demand of the application) what one
> can do to speed it up.
>
> Table structure:
On Tue, Aug 12, 2003 at 11:43:50AM +0200, Mechain Marc wrote:
>
> I would like to know (if possible, there is no explanation in the
> documentation) the exact meanning of the column "time" in the "show
> processlist" command.
It's the amount of time that thread has been in its currnet state.
--
J
Thanks Nils
Binay
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 12:24 PM
Subject: Re: Reading table structure and data from sql file.
> Hi Binary,
>
> I see you want to use the
Hi
While using OR in the query, Mysql doesn't use indexes.. right? Hence takes more time.
If queries have to be ORed on various coloumns (demand of the application) what one
can do to speed it up.
Table structure:
CREATE TABLE npg_search (
sno int(11) NOT NULL auto_increment,
fileid var
Hello again...
I opened mysql.h and found this...
---
#ifdef USE_OLD_FUNCTIONS
MYSQL * STDCALL mysql_connect(MYSQL *mysql, const char *host,
const char *user, const char *passwd);
int STDCALL mysql_create_db(MYSQL *
hello
for mysql_create_db() use mysql_query() and give an
SQL Statement ("CREATE DATABASE XYZ") as an argument.
the same for mysql_drop_db ("DROP DATABASE").
for mysql_connect: use mysql_real_connect.
the same is valid if you are using the Ruby MySQL
Modul. but it is very easy to extend the Ruby
ALTER TABLE tmp DROP COLUMN col_1, DROP COLUMN col_2, DROP COLUMN col_3,
DROP COLUMN col_4;
Or, for short,
ALTER TABLE tmp DROP col_1, DROP col_2, DROP col_3, DROP col_4;
> -Original Message-
> From: Adam Fortuno [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 12, 2003 6:22 PM
> To: My
At 00:47 13/8/2003 +, Miguel Cardenas wrote:
Hi,
Hello list...
Am developing an application with mysql support and it works fine, but today
changed from 3.23 (deinstalled completely) to 4.0.14 and when recompiling my
program get the following errors:
-
Hi Kim,
You can create a temporary table by using a table alias. The temporary table
will only be accessable by the current connection. Any other connection will
not be able to use it.
If you want to make a table which can be used by several connections (f.e for
a join) you could create a HEAP
"R.Dobson" <[EMAIL PROTECTED]> wrote:
> Hi, I have a db where I have converted all the tables innodb. I have 2 tables in
> particular called gene and name.
>
> They both have a primary key call id. I want the primary key from name to be deleted
> when the corresponding key is deleted from gene.
asif mahmood wrote:
hi, this is my first question on list, well i m using
MySQL 4.1 and i m new user of MySQL.i want to tranfer
my database from one computer to other. i want to
shift the whole database to other system. so if any
one can help me regarding this. if there is any script
or program th
> >Delete anonymous user('') from table user. Don't forget about FLUSH
PRIVILEGES.
> >
> Thanks, that worked. Why?
I suggested this yesterday, at the very beginning of Mark's
question, and I also suggested it again today in a private message, but both
of my suggestions got ignored, I guess. Keep
G'day Nils
> just send a reply a minute ago. I got it now. You want to change the way the
> data is presented at the screen and thats a different issue. You would have
> to make this in your apllication, not with mysql itself I believe.
> You basically want the DISTINCT function within the JOINS -
Hi Daniel,
I am still not sure what exactly you are trying to achieve.
If you specify the WHERE condition correctly (or ON or USING for the LEFT
JOIN) then there is no duplicate entry.
I believe what you are asking has more to do with the way how to present the
data in the output.
Best rega
[EMAIL PROTECTED] wrote:
> select compid,company,phone from companies where MATCH (phone) AGAINST
> ('+27-21-*', IN BOOLEAN MODE); something like that
'something like that' triggered me ... try
select compid,company,phone from companies where phone LIKE '+27-21-%';
IIRC LIKE will, as a bonus, us
Hi Daniel and Kim,
Isn't
> product_name product_category
> product_name product_category
> product_name product_category
> product_name product_category
> product_name product_category
the way its supposed to be ?
You are using the LEFT JOIN syntax, but actually using it just as a JOIN.
You c
he is getting the same problem as me as i explained
i use joins left join and inner join
SELECT * FROM products p LEFT JOIN product_cat_join pcj ON
p.productID=pcj.productID LEFT JOIN product_category pc ON
pc.catID=pcj.catID;
products
productID
product
product_cat_join
joinID
productID
catID
asif mahmood <[EMAIL PROTECTED]> wrote:
> hi, this is my first question on list, well i m using
> MySQL 4.1 and i m new user of MySQL.i want to tranfer
> my database from one computer to other. i want to
> shift the whole database to other system. so if any
> one can help me regarding this. if ther
Hi guys,
I've got a weirdo problem with replicating a database. Sometimes I get
some duplicate keys problems for _only_ one table. There is nothing
special about this table, it looks like:
+--+--+--+-+-++
| Fiel
All
I am having an issue in using your dbProvider with ASP.NET on the Framework 1.1
Each time I make roughly 20 odd DB trips I get the following error and cannot seem to
find the solution on the internet.
Maybe you have come across this before.
If you have would you mind passing on the solution
1 - 100 of 567 matches
Mail list logo
