Hi,
mysql> show table status like ''\G
will report you the date and time of creation, updation,etc of the specified
table. 'SHOW STATUS' enables only view.
Note 1: For some storage engines, this value is NULL. For example, InnoDB
stores multiple tables in its tablespace and the data file tim
Thanks, Jocelyn. That's what I was looking for.
Jocelyn Fournier wrote:
Hi,
SELECT products.sku, products.title, products.price,
qty_price.qty, qty_price.qprice
FROM products LEFT JOIN qty_price ON (products.sku = qty_price.qsku)
WHERE products.vendor_id=15 AND products.category='widgets';
s
I'm getting "Error 1109 : Unknown table 'questions' in where clause" when I
do the simplest query.
This is the query:
SELECT * FROM questions;
My database has the following two tables:
CREATE TABLE subscribers(
subscriber_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
email varchar(50),
I'm getting "Error 1109 : Unknown table 'questions' in where clause" when I
do the simplest query.
This is the query:
SELECT * FROM questions;
My database has the following two tables:
CREATE TABLE subscribers(
subscriber_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
email varchar(50),
Hi All,
If someone could suggest some advice/guidance I would be very
grateful. I'm trying to determine why the following SELECT query table
locks the "bad_behavior" table referenced the query.
'bad_behavior' is MyISAM
'c' is InnoDB
'a' is InnoDB
Query:
select item_p from (select inet_ntoa(ip)
Hi, I didn't find a way to know the time and date of the last update of
table, not the data but the table info itself.
Is this possible?
I want to use this info in order to show it in a web page.
Mysql 4.1
Apache
Myisam
Regards
Marcelo Fabiani
--
MySQL General Mailing List
For list archive
On 12/21/06, Behrang Saeedzadeh <[EMAIL PROTECTED]> wrote:
Hi,
What is your favorite GUI tool for working with MySQL. EMS SQL Manager
is feature-rich but sometimes buggy and also very expensive. Navicat
is not very handy. It forces to switch between mouse and keyboard
repeatedly.
What is your f
do you know if the mysql daemon is running.. ?? when you do:
ps -aux | grep mysql,
what do you see. .do you see mysqld?
-Original Message-
From: eng.waleed [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21, 2006 8:16 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: socke
this is the result of users
mysql> select host,user from mysql.user;
++--+
| host | user |
++--+
| NMS.aya.sy | |
| NMS.aya.sy | root |
| localhost | |
| localhost | root |
++--+
4 rows in set (0.05 sec)
- Original Message ---
the file mysql.sock does not exist what I have to do?
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 21, 2006 4:35 PM
Subject: RE: socket error
you might also need to check that the my.cnf file is configured to
reference
the sock file. additional
Leo,
Leo Huang wrote:
Heikki,
Thanks for you help!
I also read the comment in file of innodbase/lock/lock0lock.c in which
you said "Different transaction can have conflicting locks set on the
gap at the same time.". I think that the innodb gap lock's behavior
just like an IX lock's behavior.
In the last episode (Dec 21), Asif Lodhi said:
> Would you like to express your opinion as to what design strategy to
> take if a table (used for read operations only) is supposed to get
> more than 3GB of data per day? With 1000 simultaneous users ?
With that data rate, you'll definitely have to
I ran into this before. They had a system of spreadsheets that worked
for them and they didn't want that to go away. What I did was installed
them a MySql server on a RHEL box, and rework all the spreadsheets that
had special links to point to the database.
My argument to them was this allow
you might also need to check that the my.cnf file is configured to reference
the sock file. additionally, you should check to make sure the mysql
app/daemon is even running. (this has bit me a few times when i've been
tired!!)
sample my.cnf file..
[EMAIL PROTECTED] ~]# cat /etc/my.cnf
[mysqld
On Thursday 21 December 2006 02:25, eng.waleed wrote:
> hi
> I have this error on mysql engine Could not connect: Can't connect to local
> MySQL server through socket '/var/lib/mysql/mysql.sock' (13) is there any
> suggestion my version is 3.23.58
> BR
I think it's either you don't have read permi
Here is a question:
Were you attempting to login on the localhost machine ??
Can you login to the MySQL server from an external client, in other words,
outside of the localhost ??
When you do 'select host,user from mysql.user;'
Does any user in the 'mysql.user' table have access ??
The should b
Waleed,
First, please try to upgrade your mysql.
Try to review in your my.cnf if your configuration socket appear two twice (
in two lines ).
Verify in your environment if your mysql is running using "ps -aux | grep -i
mysql".
$ service mysql stop
$ ps -aux | grep -i mysql
$ (if still running
and also
http://fabforce.net/dbdesigner4/
sorry for 2 seperate emails.
saqib
http://www.full-disk-encryption.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sqlyog is pretty nice:
http://www.webyog.com/
saqib
http://www.full-disk-encryption.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
> What is your favorite GUI tool for working with MySQL. EMS SQL Manager
> is feature-rich but sometimes buggy and also very expensive. Navicat
> is not very handy. It forces to switch between mouse and keyboard
> repeatedly.
>
> What is your favorite tool?
Mine is Database Workbench, but hey
Hi,
Would you like to express your opinion as to what design strategy to take if
a table (used for read operations only) is supposed to get more than 3GB of
data per day? With 1000 simultaneous users ?
--
Thanks in advance,
Asif
On Thursday 21 December 2006 11:28, Scott Haneda wrote:
> >> What you should do, is grab the 50 images ahead of time, in one select,
> >> and use some php to iterate them and display them.
> >
> > Second, your suggestion is not an option in my case, since the image and
> > the thumbnails are not st
>> What you should do, is grab the 50 images ahead of time, in one select, and
>> use some php to iterate them and display them.
>
> Second, your suggestion is not an option in my case, since the image and the
> thumbnails are not stored in the database. The database contain image id,
> image attr
On Thursday 21 December 2006 11:03, Scott Haneda wrote:
> > Hello,
> >
> > I have been using mysql_connect in a script that display a lot of
> > thumbnails for an album. Each thumbnail is displayed using the code:
> >
> >
> >
> > thm.php use a mysql_connect to the database to access the info about
Hi,
What is your favorite GUI tool for working with MySQL. EMS SQL Manager
is feature-rich but sometimes buggy and also very expensive. Navicat
is not very handy. It forces to switch between mouse and keyboard
repeatedly.
What is your favorite tool?
Regards,
Behi
--
"Science is a differential
> Hello,
>
> I have been using mysql_connect in a script that display a lot of thumbnails
> for an album. Each thumbnail is displayed using the code:
>
>
>
> thm.php use a mysql_connect to the database to access the info about the
> picture based on the id.
>
> This worked fine. However, the S
Hello,
I have been using mysql_connect in a script that display a lot of thumbnails
for an album. Each thumbnail is displayed using the code:
thm.php use a mysql_connect to the database to access the info about the
picture based on the id.
This worked fine. However, the SQL server is located
I think this will work
SELECT products.sku, products.title, products.price,
qty_price.qty, qty_price.qprice
FROM products, qty_price WHERE products.vendor_id=15 AND
prod_test.category='widgets';
Ruan
-Original Message-
From: boll [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21,
Hi,
SELECT products.sku, products.title, products.price,
qty_price.qty, qty_price.qprice
FROM products LEFT JOIN qty_price ON (products.sku = qty_price.qsku)
WHERE products.vendor_id=15 AND products.category='widgets';
should do what you want.
Regards,
Jocelyn Fournier
www.mesdiscussions.
This query will display from the 'products' and 'qty_price' tables when
the 'products.sku' and 'qty_price.qsku' fields match:
SELECT products.sku, products.title, products.price,
qty_price.qty, qty_price.qprice
FROM products, qty_price WHERE products.sku = qty_price.qsku
AND products.vendor_id=1
30 matches
Mail list logo
