sql,query
Hello,
i've tried the foreign key-example out of the documentation(3.5.6 Using
Foreign Keys) on W2K (3.23.49 + 3.23.50) and LINUX (3.23.49). The tables
persons and shirts are created as innodb-tables.
I could insert a shirt for a non-existing person. Also i could delete a
Hello everybody!
How can I do a fulltext search on several tables
with just one SQL query?
Best regards
/Peter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I have a table that looks smth. like this:
id product price store
--
1 p1100s1
2 p1120s2
3 p1100s3
4 p2120s1
5 p2 95s2
6 p2300s3
7 p3100s1
8 p3120s2
Hi,
Currently I am using | (pipe) (without quotes) to
separate values if they belong to the same user.
eg : If a user wants to receive an e-mail on Friday
and Saturday I will put in the required field 5|6.
And than retrieve that split/explode it with | and
check the value.
Is there any other
Hi everybody:
I´m looking for some information about server speed. The problem:
I need a server for about 40 concurren users, it will be in an
internal net, the server will manage a mysql database with a master
table of about 4000 records and some chil tables from 2 to
4 records,
When try to use BACKUP TABLE, i get an error
'Failed copying .frm file: errno = 2' in the result table.
What's the problem?
P.S. Unix FreeBSD, MySQL 3.23.40 and type of the table is MyISAM
(CHECK works fine).
-
Before posting,
pmoscatt,
Tuesday, May 28, 2002, 2:23:00 AM, you wrote:
p I am new to mysql and having trouble understanding the installation procedures for
linux (Mandrake).
p I have downloaded the mysql-3.23.49a-pc-linux-gnu-i686.tar.gz and unpacked it in
/usr/local as root.
p I then issued the following
yvon,
Monday, May 27, 2002, 11:33:42 PM, you wrote:
yd I tried to connect to a mysql database running on a
yd linux server using an odbc connection in windows 98. I
yd get the following message:
yd [TCX][MyODBC]Host x.x.x.x is not allowed to connect to
yd this MySQL server
yd
Matt,
Monday, May 27, 2002, 9:39:05 PM, you wrote:
MH Been there, done that. Didn't change a thing.
MH Guess I should have changed the e-mail before resending it, but I'm not
MH really sure what the problem is. The server won't start for more than a
MH tenth of a second. Here's what happens
Ma.,
Tuesday, May 28, 2002, 7:09:37 AM, you wrote:
MRC hi! im a newbie.. ive installed both mysql and php
MRC under windows 2000.. and ive tried the command
MRC mysqld-nt -install.. and it didnt work, only the net
MRC start mysql worked.. and i cant run php or browse in
MRC IE ..
Can you
(feed the hungry filters: sql, query)
On Monday 27 May 2002 2:14 pm, Victoria Reznichenko wrote:
ML Is there a simple way to do something like INSERT IF NOT EXISTS,
ML other than first doing a SELECT and checking if it returns any rows?
ML If not, that would be pretty high up on my
this is the error message I get
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Why is this ?
Here is a copy of the my.cnf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
At 17:04 5/16/2002 +0200, Melvyn Sopacua wrote:
I don't know what caused it, nor whether it's reproducable,
Well - it's at least repetative, cause I have the same thing again.
We're now at rep_log.81775.
Could I please get an insight on what possibly causes this, so I might find
the trigger
sql
From: [EMAIL PROTECTED]
To: Antoine Clanché [EMAIL PROTECTED]
Subject: Re: bug 11 wysql 3.23.49 win (OS Windows XP)
Date: Tue, 28 May 2002 10:32:48 +0200
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
select * from table_name where product like 'p1' order by price limit 1;
- Original Message -
From: Ciprian Trofin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 11:20 AM
Subject: Join or smth.
I have a table that looks smth. like this:
id product
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the
sql
Antoine Clanché
[EMAIL PROTECTED]
0663645239
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
On mardi, mai 28, 2002, at 09:35 , Evgeny Chuykov wrote:
When try to use BACKUP TABLE, i get an error
'Failed copying .frm file: errno = 2' in the result table.
What's the problem?
BACKUP TABLE write files with the user MySQLd is running...
So if your deamon run as mysql, you had to autorize
Hello everybody!
How can I do a fulltext search on several tables
with just one SQL query?
Best regards
/Peter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the
Doesn't work the way I want to: I want the result to be like:
id | product | price | store
1 | p1 | 100 | s1
3 | p1 | 100 | s3
5 | p2 | 95 | s2
7 | p3 | 100 | s1
CL select * from table_name where product like 'p1' order
When try to use BACKUP TABLE, i get an error
'Failed copying .frm file: errno = 2' in the result table.
What's the problem?
RC BACKUP TABLE write files with the user MySQLd is running...
RC So if your deamon run as mysql, you had to autorize user
RC mysql to write into your backup
Is it possible to set a variable to kill mysql-threads which sleeps for a
time e.g. 5 hours?
Which variables have to be set therefore?
Regards,
Anatol
-
Before posting, please check:
http://www.mysql.com/manual.php (the
RC On mardi, mai 28, 2002, at 09:35 , Evgeny Chuykov wrote:
When try to use BACKUP TABLE, i get an error
'Failed copying .frm file: errno = 2' in the result table.
What's the problem?
Sorry, my stupid mistake. As you said there was problems whith rights
and dir 'test' didn't exists in
Hello list,
In one of my mysql databases I have an ISAM type table that has the .ISM file
corrupted. I would like to recover this file but have no idea how to do it so that's
the reason I addres this time to the list looking for some help :-[ . I´m lost!
Does it exist any reconstructor
wait_timeout
8 hours as standard
Simon
-Original Message-
From: Anatol Mayr / HEXAGON [mailto:[EMAIL PROTECTED]]
Sent: 28 May 2002 09:26
To: [EMAIL PROTECTED]
Subject: killing mysql-threads?
Is it possible to set a variable to kill mysql-threads which sleeps for a
time e.g. 5 hours?
Can you tell me how the variable has to be declared? - time in seconds?
e.g. is wait_timeout=7200 for 2 hours OK?
Thanks,
Anatol
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: 'Anatol Mayr / HEXAGON' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 11:39
Hi,
I want to start the autoincrement field in mysql
primary key from 1000 instead of 1.
Any ideas.
Thank You.
Piyush.
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:FR/I/*KO_TBD// Admin Apache
Organization:
organization of RHODIA F.TOUITOU (multiple lines)
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
On Sun, 26 May 2002 23:15:22 +0200
Bjarne Jørgensen [EMAIL PROTECTED] wrote:
Hi!
I've watched the development of replication on mysql with great joy.
However I haven't been able to understand when og if mysql is going to
support 2 way replication. In other words.
Will it be possible to
sql,query
- Original Message -
From: [EMAIL PROTECTED]
To: Anatol Mayr / HEXAGON [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 12:07 PM
Subject: Re: Re: killing mysql-threads?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To
insert into table (auto_inc_field) values (1000);
mysql will carry on from there
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
create temporary table best_values
select max(product) as prodName, min(price) as bestPrice
from products group by product;
select products.* from best_values,products
where best_values.prodName = products.product
and best_values.bestPrice = products.price;
drop table best_values;
(and note
The short way between two points, it's right line
Hi,
If you use MySQL for inter process communication you waste
performance.Benjamin is right.
You can use the classical forms of IPC or not.But the principle must remain
the same if you wish than your work that not to be in vain/for nothing.
A
I'm sure this question should be put in the docs. It's asked at least once a
fortnight. Welcome to the wonderful world of Mysql variables.
create temporary table productorder select *,(@a:= IF(@b=product,@a+1,1)) as
cnt, @b:=product from
products order by product,price;
mysql select * from
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the
Hello everybody!
How can I do a fulltext search on several tables
with just one SQL query?
Best regards
/Peter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear Sir,
I did all the steps to compile the code i.e.
./configure --prefix=/usr/local/mysql
--with-named-curses-libs=/lib/libncurses.so.5.2
make
make install
scripts/mysql_install_db
and then I tried mysqld --user=root then it gave the following error
message.
Cannot initialize
Hi
Nothing is wrong! The behaviour of your example is correct, because
MySQL does not support the concept of foreign keys. See section 1.4.4.5
of the MySQL manual. In other words data integrity between two tables is
not ensured by MySQL. Your application code must solve this.
Regards
Rene
I'm a comparative MySQL newbie who is struggling with sub-selects. In
other DBMS's, I can use sub-selects to return a set that I can use in a
condition of a WHERE clause. An example is the recent query by Ciprian
Trofin about finding the cheapest price of a product. In other DBMS's
I would use:
Hi people,
Is there a way to have the mysqld log to syslog, instead of the errorlog
flatfile? I tried piping it to a stdin-to-syslog script, but that
wouldn't work either.
Thanks and cya,
Dries.
--
Dries Robberechts - Unix System Engineer Belgacom Skynet NV/SA, Rue
Carli 2-4, B-1140
Hi,
I have a problem by compiling Mysql 3.23.49 under Cygwin.
My Cygwin version is 1.2. I downloaded Mysql package from this url
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49.tar.gz
I didn't succeded in compiling these sources files, by following the
instructions.
I created
I'm sort of new/rusty to SQL and I was trying to figure out the best way to
do this problem. I'm creating a database for tracking a football pool. I'm
kind of stuck on displaying the Games database. The Games database has a
home team ID and an away team ID as well as the winning team ID. Thus I
i have a tag textarea in my file HTML as:
tdtextarea name=text rows=30 cols=15
maxlength=65000/textarea/td
In this field of the WEB page , i have many lines , i would like that each
line of this fied becomes a row in my Database
How do I have to do for my query ??
p,
Tuesday, May 28, 2002, 12:54:01 PM, you wrote:
ps I want to start the autoincrement field in mysql
ps primary key from 1000 instead of 1.
ps Any ideas.
You can examine the -A option of myisamchk.
Take a look also at CREATE TABLE and ALTER TABLE statements:
Neville,
Tuesday, May 28, 2002, 11:23:06 AM, you wrote:
NL this is the error message I get
NL Can't connect to local MySQL server through socket
NL '/var/lib/mysql/mysql.sock' (2)
NL Why is this ?
Check permissions on the MySQL datadir. Look also into the .err file
in the MySQL data dir you
Karan,
Tuesday, May 28, 2002, 2:05:37 PM, you wrote:
KS Dear Sir,
KS I did all the steps to compile the code i.e.
KS ./configure --prefix=/usr/local/mysql
KS --with-named-curses-libs=/lib/libncurses.so.5.2
KS make
KS make install
KS scripts/mysql_install_db
KS and then I tried mysqld
Evgeny,
Tuesday, May 28, 2002, 12:23:58 PM, you wrote:
When try to use BACKUP TABLE, i get an error
'Failed copying .frm file: errno = 2' in the result table.
What's the problem?
RC BACKUP TABLE write files with the user MySQLd is running...
RC So if your deamon run as mysql, you had to
I am attempting to get mysql-max running with Innodb. I am using the
latest version .49 on a Redhat 6.2 server. The following is my my.cnf,
which I have placed in the /var/lib/mysql directory:
# Example mysql config file for medium systems.
#
# This is for a system with little memory (32M -
Hello.
Have a look at the isamchk tool. Be sure to make a backup of the table
in question beforehand and to shut down the server while the tool is
running.
Regards,
Benjamin.
On Tue, May 28, 2002 at 11:37:15AM +0200, [EMAIL PROTECTED] wrote:
Hello list,
In one of my mysql
Hi.
That's an FAQ and explained in the tutorial:
http://www.mysql.com/doc/e/x/example-Maximum-row.html
Regards,
Benjamin.
On Tue, May 28, 2002 at 12:05:19PM +0100, [EMAIL PROTECTED] wrote:
I'm a comparative MySQL newbie who is struggling with sub-selects. In
other DBMS's, I can use
Hi.
Presuming you have the team names in a seperate table, you could write
something like:
SELECT home.name, away.name, winner.name
FROM games, teams AS home, teams AS away, teams AS winner
WHERE home.id = games.homeid AND
away.id = games.awayid AND
winner.id = games.winnderid
You will get better response if you post only once, and NOT as a reply
to someone else's question.
Peter Engström wrote:
Hello everybody!
How can I do a fulltext search on several tables
with just one SQL query?
Best regards
/Peter
I'm trying to find any and all thoughts on whether to store files in the db (PDF's,
word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead
because of new folders, each client having thier own folder(and subfolders) etc. And
then htaccess'ing the dir's
Can someone tell me what the correct syntax for this is?
SET SQL_SLAVE_SKIP_COUNTER=n
Skip the next n events from the master. Only valid when the slave thread is not
running, otherwise, gives an error. Useful for recovering from replication glitches.
mysql show slave status\G
Greetings from Nairobi, Kenya
Try MySql Front
You can download it from www.mysqlfront.de
Kind regards
Njamba
- Original Message -
From: andy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 27, 2002 4:48 PM
Subject: Visualizing the shema of the db
Hi there,
I am
Hi all!
Question. I try to understand with 4.3 Foreign key constraints
InnoDB Engine in MySQL-Max-3.23.50/MySQL-4.0.1.
I use MySQL Max (InnoDB) 3.23.49 for Win2000
I have created two tables:
CREATE TABLE parent (id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE
That works perfectly. I did not know that you could alias a table name
multiple times to get multiple distinct selects out of it.
Simple yet elegant. Thanks.
Hi.
Presuming you have the team names in a seperate table, you could write
something like:
SELECT home.name, away.name,
try timestamp(14) instead.
[EMAIL PROTECTED] wrote:
Description:
Problem with timestamp(8) and GROUP BY
How-To-Repeat:
mysql CREATE TABLE test (
- id int auto_increment,
- dd timestamp(8),
- data int,
- PRIMARY KEY (id)
- );
Query OK, 0 rows affected (0.01 sec)
I'm a little confused on how to add things to @Inc path...i'm trying to
install Msql-Mysql-modules and it says that my DBI/DBD is not in the
@INC
Thanks
Amy
-
Before posting, please check:
http://www.mysql.com/manual.php
I am new to transactions in mySql
I am using Visual Basic to access a mySql database.
I had seen somewhere that to use transactions through ODBC you have to send
the commit and rollback commands like a select statement.
But even when I send the begin work before my other statements, the commit
is
I am having a problem with a user having the correct privleges in mysql.
The user cannot connect to get access to the database, but everything looks correct to
me.
User table...
Host User Password Privs
localhostuser1password Only Y is for File_priv
It is kinda old (3.23.32), but I did set some kind of skip counter before, just can't
remeber how I did it.
-Original Message-
From: Harald Fuchs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 9:50 AM
To: [EMAIL PROTECTED]
Subject: Re: SET SQL_SLAVE_SKIP_COUNTER=
In article
Good morning, I'm trying to send an email to the list but this happens.
Im not sure if this is because it was an html email but I kept getting this:
**
Your message cannot be posted because it appears to be either spam or
simply off
I think any descent server would be fine:
Linux/FreeBSD
dual PIII
512MB ram (or better 1GB)
2 scsi drives with raid1
Frankly, you could even get cheaper than that with 1 processor.
-Original Message-
From: Javier Armendáriz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 3:33
This example is in InnoDB though, which should support foreign key
constraints.
Chris Book
In other words data integrity between two tables is not ensured by MySQL.
Your application code must solve this.
-
Before posting,
On 28 May 2002, 14:20, Benjamin Pflugmann wrote:
That's an FAQ and explained in the tutorial:
http://www.mysql.com/doc/e/x/example-Maximum-row.html
~~~
Thanks for the link, which I've bookmarked. Thanks also to those
that responded off-list.
Unfortunately, the approach given in the tutorial
You need to install DBI first.
Amy Zediak wrote:
I'm a little confused on how to add things to @Inc path...i'm trying to
install Msql-Mysql-modules and it says that my DBI/DBD is not in the
@INC
Thanks
Amy
-
Before
sitnikov,
Monday, May 27, 2002, 10:32:07 PM, you wrote:
s Description:
s Problem with timestamp(8) and GROUP BY
s How-To-Repeat:
mysql CREATE TABLE test (
s - id int auto_increment,
s - dd timestamp(8),
s - data int,
s - PRIMARY KEY (id)
s - );
s Query OK, 0 rows
maxim,
Tuesday, May 28, 2002, 4:47:13 PM, you wrote:
m Question. I try to understand with 4.3 Foreign key constraints
m InnoDB Engine in MySQL-Max-3.23.50/MySQL-4.0.1.
m I use MySQL Max (InnoDB) 3.23.49 for Win2000
m I have created two tables:
m CREATE TABLE parent (id INT NOT NULL,
m
Markus,
Tuesday, May 28, 2002, 2:15:09 PM, you wrote:
You can use IGNORE keyword in INSERT statement, but it's not quite the
same as INSERT IF NOT EXIST. If you specify IGNORE, any rows that
duplicate an existing PRIMARY or UNIQUE key in the table
will be ignored in INSERT:
ML Yes, I was
Hello,
excuse me. I've looked at the wrong place. I found the solution at
www.innodb.com:
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT,
INDEX par_ind (parent_id),
This is OT, perhaps post to comp.lang.perl.*?
Ric
p.s. try use DBI or use lib qw(/path/to/module)
- Original Message -
From: Amy Zediak [EMAIL PROTECTED]
To: MySql List [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 3:01 PM
Subject: @INC
I'm a little confused on how to add
Hi all!
Question. I try to understand with 4.3 Foreign key constraints
InnoDB Engine in MySQL-Max-3.23.50/MySQL-4.0.1.
I use MySQL Max (InnoDB) 3.23.49 for Win2000
I have created two tables:
CREATE TABLE parent (id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE
Hi,
I must tell you something for nothing you try to kill the user, because
if he try twice to execute some query, MySQL 1-st time respond something
like lost connction or Server is gone and the 2-nd time recovery
the last connection.
Regards,
Gelu
select id, product, min(price), store from tablename group by product
Better?
Regards
Chris
- Original Message -
From: Ciprian Trofin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 1:24 PM
Subject: Re[2]: Join or smth.
Doesn't work the way I want to: I
I am sure I did something to set the skip counter, it might not have been that
command, but I am sure I did it somehow at the direction of someone else on the list
when I had problems before
-Original Message-
From: Harald Fuchs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002
* [EMAIL PROTECTED]
I have a question on how MySQL JOIN has effect on query (search)
performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example
I am attempting to migrate a MySQL driven web application that, in my
opinion, was designed by a stupid monkey. The php web frontend
dynamically creates tables to store chunks of data rather than just
adding rows to existing tables. Don't ask me why! However, when
attempting to migrate
I want to write a batch file of sql statements so that I can schedule
this batch file to run at night automatically and send the sql commands
to a mysql database on a Win2K server. Does anybody have any experience
doing this? Any pointers in the right direction would be much
appreciated.
Tab
i use mysql_pconnect in php, but after call
mysql_pconnect every time,i find that connection
increase one.it says in php manual, mysql_pconnect
will first try to find a (persistent) link that's
already open with the same host, username and
password. If one is found, an identifier for it will
be
I seem to have answered my own question :-)
The answer is that you have to use -Q or --quote-names in mysqldump
Cheers!
Augey Mikus
Augey Mikus wrote:
I am attempting to migrate a MySQL driven web application that, in my
opinion, was designed by a stupid monkey. The php web frontend
The mysql command line client can accept batch files as:
mysql -uuser -ppassword database file.sql
file.sql is just a file with the plain text SQL statements in it that you
want to run.
Then since you are on Windows 2000, you could setup Task Scheduler to run it
every night at whatever time
Hi all.
I import a mysqldump from MyISAM database in a new innodb database. It gives
me an error saying that the table is full
ERROR 1114 at line 3035: The table 'LALBARANPR' is full
These are the values for the innodb variables in the my.cnf file:
innodb_data_file_path =
On 27 May 2002, at 22:32, [EMAIL PROTECTED] wrote:
mysql SELECT dd,count(*) FROM test GROUP BY dd;
+--+--+
| dd | count(*) |
+--+--+
| 20020527 |1 |
| 20020527 |1 |
| 20020527 |1 |
| 20020527 |1 |
I get this message when I do a myisamchk on a table right after I use
phpMyAdmin or other mysql client tools.
What do I need to do to get the table to close properly? I have been
having to run myisamchk -r on the talbe every time I do something to it.
Thanks in advance,
Chris
Where is msql.h located?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
My SQL query problem:
I met a strange problem:
For example, I have the following table:
Mytable:
No Name Date Project
1 Bob 2002-05-27Bob's project
2 John -00-00 John's project
When I use select * from
My SQL query problem:
I met a strange problem:
For example, I have the following table:
Mytable:
No Name Date Project
1 Bob 2002-05-27Bob's project
2 John -00-00 John's project
When I use select * from
Hello everyone.
I have an issue that can't figure out, and was wondering if someone can help
me with it.
I offer mySQL based e-mail account to my users.
The actual e-mails are stored in a text based directory.
Sometimes when the e-mail is put in the trashcan, it actually deletes the
e-mail
Hi,
the internal space for innodb is full...
create new extends (add another ibdata file and restart the mysql)
to see how much space is free, execute the command:
show table status like 'yourtableinnodb'
Iago Sineiro wrote:
Hi all.
I import a mysqldump from MyISAM database in a new innodb
or mysql.h?...is in your_src_directory/include
- Original Message -
From: Amy Zediak [EMAIL PROTECTED]
To: MySql List [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 7:59 PM
Subject: msql.h
Where is msql.h located?
Hi,
I have an interesting problem when updating columns of type DATETIME. It
seems that exactly one day is subtracted from the DATETIME value that I
submit in an update query. Has anyone encountered this? Any ideas?
Kevin
Hehe, this is almost identical to the post I submitted yesterday, entitled SELECT
'foobar' = 0
There's a patch in that post, doesn't work for dates but should give an idea of what
has to be done.
The reason is that 'WWW' has to be converted to a date. And the conversion gives it a
value of
I've created a dump file using mysqldump that is about 4MB. When I try to
load it on another server using mysql database dump.sql I get errors.
If I create a smaller dump file (below 1MB) it loads without a problem. I
noticed that the default max_allowed_packet size is 1MB, but I've not had
Hi, I also have a date problem:
My SQL query problem:
For example, I have the following table:
Mytable:
No Name Date Project
1 Bob 2002-05-27Bob's project
2 John -00-00 John's project
When I query select * from
On 28/5/02 at 12:59, [EMAIL PROTECTED] (Amy Zediak) wrote:
Where is msql.h located?
On which OS?
Regards,
Phil.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Since it's a date field, it's a date comparison and the date that you
specify ('WWW') gets parsed by the optimizer as being the date '-00-00'
since it can't find any valid date information. This is different from if
it was to convert the date to a string and do a string comparison, which is
Sigh, sanity check.
I did set a skip counter, and you were correct, it was on a newer version ( on a
different slave )
That slave server crashed, when we did the reinstall, i reverted back to 3.23.32 ( the
same as the rest of or slaves were running )
So that threw me for a loop seeing now that
1 - 100 of 145 matches
Mail list logo