In the last episode (Jul 03), David Blomstrom said:
> I've published several tables to two different online databases using
> phpMyAdmin. It seemed fairly simple, so I was surprised when it
> didn't work for me tonight.
[snip]
> Next, I "Browse" to the SQL file I want to import. If I remember
> cor
I've published several tables to two different online
databases using phpMyAdmin. It seemed fairly simple,
so I was surprised when it didn't work for me tonight.
I'm not sure if I forgot part of the process, or if
something's wrong with the database, website, etc.
In phpMyAdmin, I click "Query Wi
Hi all.
I'm pleased to announce the first public release of my first open-source
project: a Perl class to automate the synchronization of data from a
database server ( via DBI ) with fields on a Glade-generated form ( for
a Perl / Gtk2 app ). MS Access users take note: an alternative is on the
Asalamualikum
Thank you for contacting. Inshallah we shall try our utmost best to reply to you as
soon as possible.
Wasalaam
Brother Sayful-Islam (Web Team admin)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
This should work
select C.cId cc, count(D.catId) dd from C
left outer join D on C.cId = D.catId
group by cc;
- michael dykman
- [EMAIL PROTECTED]
Kapoor, Nishikant wrote:
Hello List,
It sounds like a simple query but I have spent quite a few hours already, and still do
not have a solutio
I take it this is the back end for a web application of some kind.
removing the dashes before the insert with the procedural language
should be trivial. What language is on the front end of this?
Creating a regular expression which would match dashed or non-dashed
number would not be that hard
At 21:06 +0500 7/2/04, Muhammad Fayez Aziz wrote:
Are the techniques used in the following query new discoveries?
That's kind of a broad question. What techniques, specifically, are
you referring to?
$result=mysql_query(" select ProductSerNo from Products where
(@pos:=locate(concat('#',ProductSer
After you finish installing MySQL, you need to start it up before
connecting to it -- the installation won't do that automatically for
you.
http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html
That manual page will give you the right commands. Basically, after
installation, run the mys
Hi All
I have a spate of questions about mysql fields but I'll start with this one as
its probably the simpliest of mistakes I am making, I am using php echo to
retrieve records echo "$fieldrecord"; where the field have yet the page
it is displayed in does't show the break looking at the source t
Description:
MySQL is not properly configured for first run.
How-To-Repeat:
Run standard installation:
./configure
./make
su
./make install
exit
# (exit su)
mysql
-- mysql failed:
ERROR 2002 (HY000): Can't connect to local MySQL server
through socket
Are the techniques used in the following query new discoveries?
$result=mysql_query(" select ProductSerNo from Products where
(@pos:=locate(concat('#',ProductSerNo,'#'),'#12#10#1#9#'))!=0 order by @pos
");
(@pos is a user variable, ProductSerNo is an auto_increment column of
Products table, '#
--- Rhino <[EMAIL PROTECTED]> wrote:
> > > 2. What happens when you do 'select count(*)' on
> > > your new table?
> >
> > I'm not familiar with that command. If I type
> select
> > count (*) into the "query" box on phpMyAdmin, it
> says
> > count(*) = 0 Or is this a type of table query I do
> on
>
Hi.
Navicat is excellent and a linux version is available. I would assume it is
the same as the windows version but I have not used it personally.
http://www.navicat.com/linux_overview.php3
Best Regards
>>> Andrew
SpamNet - Stop spam immediately and help me too!
www.cloudmark.com/spa
What other processes are running on the Solaris box? Solaris tends to favour
giving each process a fair share of the processor rather than getting one
process (e.g. MySQL) to complete as quick as possible. I suspect that if you
compared the time taken for much larger queries on the Solaris machine
To do the restore:
1. Stop the MySQL server. On Windows NT/2000/XP you should use the command
"net stop mysql" assuming you have installed MySQL as a service. On
Unix/Linux, if you installed the init script, simply issue a command
something like "/etc/rc.d/init.d/mysql stop" or
"/etc/rc.d/init.d/m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi bas,
You did not provide details on your harddisk in your message, you
might want to know that
MySQL performance is highly related to your diskconfiguration. If you
want to speed it up you could do a softwareraid 0 over as much disks
that fit in y
Hi listers,
I just got here, so please let me know if this is not the appropriate
list! :)
Running MySQL 4.0.20 on Fedora Core 1, with InnoDB tables. Installed
from RPMs provided at MySQL.com.
Last night the beastie came down hard, and requred a physical reboot in
order to free/kill some mys
dear users ...
i use MySQL 4.0.20 on RH7.3 on a sun fire workstation.
Can some one of you suggest a good GUI for mysql.
I also use Mysql 4.0.13-pc-linux-i686 on P4.
many thanks in advance ..
--
Ra. Gowthaman,
Graduate Student,
Bioinformatics Lab,
Malaria Research Group,
ICGEB , New Delhi.
INDIA
Hello mysql,
This bug make impossible to use backup with 'mysqldump','mysql' pair.
How-to-repeat:
---
drop table if exists t1;
drop table if exists t2;
create table t1 (a int, b enum('А','Б')) DEFAULT CHARACTER SET cp1251;
create table t2 (a int not null, b enum('А','Б'))
On Friday 02 July 2004 11:40 pm, Your Name wrote:
> ... I now realize the importance of normalizing my
> data,
>... what [is] the easy way... of getting
> it done now that I already have a database set up.
>
> Suppose I have a table "books", consisting of "id",
> "title", and "publisher"; the "pu
hi...
i have a user that i've created
mysql> insert into user (host,user,password)
-> values ('192.168.1.%', 'test', password('XX'));
Query OK, 1 row affected (0.00 sec)
mysql> insert into db (host,db,user,select_priv)
-> values ('192.168.1.%', 'temp', 'test', 'Y');
Query
21 matches
Mail list logo