/var/lib/mysql must be world searchable:
/var/lib/mysql/ must be writeable by the user mysql.
/var/lib/mysql.sock will be created when mysqld starts, and must be
world writable.
jude dashiell wrote:
Here's the output I get only as a user to mysql but not logging in as
root:
Script started on
Because now - a future date is a negative number, and therefore 30.
Trevor Sather wrote:
Hello,
Any idea why the following doesn't work? It's taken from the MySQL manual
which says it should return records in the last 30 days. As you can see,
I'm getting records spanning some 19 months from
mike wOZniewski wrote:
Hi... silly question maybe.
I want to execute the following query:
mysql_query(SELECT MIN(order), MAX(order) FROM downloads WHERE class='1');
order is a reserved word.
try:
MIN(`order`), MAX(`order`)
Note use back ticks ` NOT '
...but it doesn't work and gives me a
You have no ON condition for image_cat_location_link.
Chris Cameron wrote:
The gist; the below query doesn't finish, can't figure out why.
-- Query --
SELECT
images.iid,
images.locnetid,
images.path,
images.CD,
lightbox_location_image_LINK.iid
FROM
It just means you didn't enter the password for root.
2Hosts.com wrote:
Hi Nils,
So if I su to root and try to start mysql, I get the following... does that
mean I'm secure? I am still finding the very confusing, but doing my best
to look it up on dejanews and in books etc so as to not stress
WHERE TAB2_ID 2
is the problem.
Do you want = or or what?
Also your version of MySQL must support sub selects.
James Moe wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote:
SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2
chown -R mysql /usr/local/mysql
alain POULET wrote:
HELP!
Description:
Try starting daemon
[EMAIL PROTECTED] mysql]# ./bin/safe_mysqld 38;
Starting mysqld daemon with databases from /usr/local/mysql/var
030404 11:32:37 mysqld ended
Trace:
[EMAIL PROTECTED] mysql]# cd var
[EMAIL
If the perl program is a daemon, than it can keep the connection open.
If you are running the same perl program many times, it will have to
make the connection each time.
Kory Wheatley wrote:
We have a perl cgi program that refreshes every 45 seconds and
connects to a mysql database to update
Read the section of the manual on table types.
Different table drivers offer differnt types of locking.
ISAM and MYISAM don't,
but BDB and INNODB types offer different types of row and or page locking.
[EMAIL PROTECTED] wrote:
Hello,
I would like to know if MySQL allows for record locking.
What do you mean by mysql won't create databases? -- notice stupid
'?' inside of quotes when I am not quoting a question.
[EMAIL PROTECTED] wrote:
actually i know how to make connections in dreamweaver and since mysql won't create databases, i kinda figured i should start there. thanks for
someone. i'm sure the rest of the list is incredibly impressed with your wit and knowledge. everyone must be looking up to you now as you bask in the glory of being so wonderful!
- Original Message -
From: gerald_clark
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, April 04
You can't add constraints referencing indices that don't exist.
Create your indecies first.
Ian Hartas wrote:
Description:
I have a database schema .sql file which is accepted when run with MyISAM
tables. If I change the tables to be type = InnoDB, then it fails with the error
Because neither 0.7 nor 0.1 have an exact binary floating point
reprsentation.
Use Decimal type instead.
LeTortorec, Jean-Louis wrote:
Hello every one,
I have a simple table, with a float field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.
Cal Evans wrote:
Ed,
1: It depends on your hardware. I don't think MySQL imposes a restriction.
2: It doesn't work that way. It's not like VFP or Access where you 'edit' a
record. You can SELECT the contents of a record, you can manipulate them and
then you can UPDATE that record (assuming
. not both. It it's you
then you own the record. If it's someone else then someone slipped in and
grabbed it from you.
=C=
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Cal Evans [EMAIL PROTECTED]
Cc: Ed Kiefer [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Wednesday, April 02
Yes, but both men think they have the record.
So 'A' looses bigtime.
My version catches this.
Cal Evans wrote:
last man wins.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Cal Evans [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:10 AM
Delete from table where num in ( 1,13,34) ;
Pag wrote:
Hi,
I am kinda new to this mysql thing, so please forgive the basic
question.
What i need to do is, list my records on a table with a checkbox
for each. After we choose several of the records, we click a button
and i want to
Check the manual for last_insert_id().
Noel Wade wrote:
Hi All,
Say I have a table with an auto_increment field that is being used at the primary key.
When I insert a new record, is there any way to easily grab the primary key value for that new record? I had another unique field that I was
Why don't you try it yourself.
You could have tried it in less time than it took to mail the question.
The manual works too.
I'm not going to answer because you need to learn how to learn.
Noel Wade wrote:
I know its possible to use multiple fields for the primary key in a table
i.e. primary
Add your database directory to your my.cnf file.
They were possibly compiled with diferent default
database locations.
[EMAIL PROTECTED] wrote:
Description:
I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat
operating system. On 3 machines I only upgraded the RPMs
Don't do that !!!
You will eventually get the wrong row when someone else inserts after you.
Use last_insert_id().
MySQL List wrote:
Nevermind I got it
$next_number = $dbh-selectrow_array(qq{ SELECT MAX(id) FROM
whatever_table });
Richard.
- Original Message -
From: MySQL List
If this is an April fools joke, you are off a day.
Seth Brundle wrote:
I really hate mailing lists - they are dinosaurs for this type of thing.
A web discussion board is a much more powerful and flexible tool for this
type of community. Thread tracking, archiving, searching, dont have to
Joseph Bannon wrote:
I'm upgrading from 3.23.53 to 4.0.12 and noticed that
4.0.12 wants to pull data files from /var/lib/mysql. I
set the prefix to be /home/mysql4, so why is it
wanting to get the data from this new location?
When I installed 3.23.53, I set the prefix as
/home/mysql3 and it
warm-fusion wrote:
Hi, I'm just wondering what the right syntax for using the delete
statement is? I'm trying to write a simple garbage collection/deletion
query similar to the queries below.
delete from 'item' where 'quantity_of_item_in_stock' = 10;
delete from item where
[EMAIL PROTECTED] wrote:
I'm trying go get a future date from a query that contains a datetime
column. I figured I would be able to use an alias in the query to
calculate the future date as follows:
select expires as date_add('date' + interval 180 days) from table;
'date' is a string.
Did you
Those are binary log files used in replication.
If you are not running replication, remove the line
bin-log
from the config file.
Tiele Declercq wrote:
Hey guys,
Ii could not find an answer on the innodb website, i'm using InnoDB now for some months and i'm very happy since the constant
, ad_type, date_add('submit', interval 180
day) as expires from table;
'submit' is a string.
Leave off the quotes!
Any ideas on this one??
TIA,
Ed
On Mon, 31 Mar 2003, gerald_clark wrote:
[EMAIL PROTECTED] wrote:
I'm trying go get a future date from a query that contains a datetime
I delete the old binlogs after doing my nightly mysqlhotcopy.
Tiele Declercq wrote:
Hey, thanks fopr the tip. Indeed the line was in there. Can i now erase
those bin files that have been written before ?
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Tiele Declercq [EMAIL
This is not really a MySQL docs problem.
The manual gives the mysql syntax, but you are expected to already know SQL.
You need to get a book on SQL.
SELECT data.id, data.title
FROM data,archive
WHERE data.favorite=archive.favorite AND data.favorite='Y';
Bob Sawyer wrote:
First, a little rant: I
Charles Hauser wrote:
All,
I am having difficulty loading data into a DB using a perl script.Linux
RH8 box.
DB creation:
mysql -uroot -p -e 'create database yeast'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
mysql -uroot -p -e 'grant all privileges on
You may consider it a bug, but it is the documented behavior.
Dyego Souza do Carmo wrote:
I'm using MySQL/InnoDB 4.0.12
I set replication to replicate only database escribaupdate...
The bug is:
I connect in database escribaupdate and run:
delete from escriba_autorizacao;
go to shell and
If it is MYISAM:
ALTER TABLE projected
ADD COLUMN partnumber INT UNSIGNED NOT NULL AUTO_INCREMENT ,
ADD UNIQUE KEY (projectid,partnumber);
If you don't want to keep the automatic incrementing of the partnumber
for each project,
then drop the key.
Renger van Nieuwkoop wrote:
Hi
I have the
You have several problems.
Both tables have duplicate keys.
You don't have a (c_id) key in table2 to add a constraint to.
William Hambleton wrote:
I can't seem to be able to create foreign keys. Here are my create
procedures and the error I am receiving.
CREATE TABLE `test1` (
`a_id`
You did not show us your actual insert statement, but
You can not insert into a table listed anywhere in the select.
Udo Schubert wrote:
hi there!
i'm wondering about these sub-selects and the mysql-version peroblems
they cause!
somewhere on mysql.com is said:
sub-selects need mysql
Try reading your return codes.
You got a duplicate key error that you were ignoring.
C. Reeve wrote:
I got it - stupid me has a unique field that I wasn't using in the test
script I was using - so every I tried to add an entry this field was a
duplicate and as such did not add the record. Is
Error 13 is a permissions denied problem.
Make sure the data directories and files are owned by mysql.
Bill Davies wrote:
I am having trouble getting MySQL 3.23.51 running on macOS X 10.1.5
(Darwin)
** First it won't let me assign a root password, I think because it's
not running.
Trying to
Read about replication in the manual.
This may be what you need.
Ville Mattila wrote:
Hello everyone,
I was wondering how could I make a mirror copy of a table to another server
in the easiest way? I browsed through the MySQL documentation but didn't
find any clue of a COPY TABLE command or a
The mysql data directories and files must be owned by mysql.
Error 13 is a permission denied operating system error.
Toto Gamez wrote:
i installed mysql-3.23.41-1 on my RH7.2 box but when i run safe_mysqld, mysql daemon
started but dies i tried to check the log and says:
030326 14:35:46 mysqld
Create a .my.cnf file in your home directory with permissions set to 600.
In that file put the lines
[mysql]
user=root
password=mysql
now you can enter:
mysql did.query did.out
Marianadin, Didier wrote:
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix
Did you check the source?
Sean Biganski wrote:
Any know what algorithm MySQL uses for its encode/decode functions??
Sean
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Did you add a socket option to the proper paragraph in /etc/my.cnf?
Ex:
[client]
socket=/raid2/var/lib/mysql/mysql.sock
Ville Mattila wrote:
Hi there,
I'm upgrading my old MySQL 3.2 to a new MySQL 4.0 and at the same time I
decided to change the location of my data directory. Everything went
Esteban Cabezudo wrote:
First of all, I want to say hello and sorry because my english it s very
poor. I hope you don't care about it.
My name is Esteban, I'm from Uruguay.
I begin whit mySQL and I have a simple question... for the moment... :)
If I define a BLOB(760) column. The maiximum size
Well, then I would buy a $50.00 product using MySQL, and then
your $5000.00 product. Oh, and subtract the $500.00 license fee.
I already have a license.
I prefer to pay a flat fee for each license, not a fee based on the
price of your software.
John Griffin wrote:
Hello David,
Since you were
solution for.
John
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 2:49 PM
To: John Griffin
Cc: David Axmark; Damir Dezeljin; MySQL List
Subject: Re: InterBase vs. Mysql
Well, then I would buy a $50.00 product using MySQL, and then
your $5000.00
How do you know these possibly duplicate records are not already in the
table?
What is wrong with adding a unique index on (fld2,fld3) ?
Hu Qinan wrote:
Dear all,
I intend to write a large volume of records to a table tbl.
tbl:
fld1, int unsigned not null auto_increment primary key,
fld2,
Maybe I am missing something, but why not:
UPDATE T SET T.Data = 1 WHERE . . .
With only 2 fields, what could be in your WHERE clause?
Hu Qinan wrote:
A table T contains two fields: T.ID, T.Data.
I want to set its T.Data to one of three values: NULL, 0, 1 according to its T.ID.
This is what I
You did not create 'root'. You set the root password to 'therootpassword'
Did you enter the same password you set?
Enter Password : therootpassword
Chien-Lung Wu wrote:
hi,experts:
I installed mysql (3.23.49, server client) at my NT4.0 machine.
As I unziped and set up mysql, everything seemed
Linux systems normally run with file locking off.
With NFS shares, this can allow the server to read the
index file as it is being updated. This can cause the crash
make sure you don't use --skip-locking.
root wrote:
Description:
I installed the most recent rpm for RedHat Linux 7.2. After
to post to the list
At 11:17 AM 03/12/2003 -0600, gerald_clark wrote:
You have to show us.
Steve Holt wrote:
I am sure I am missing something very simple but I cant see it
I am using MS Access 97 as a front end to MYSQL
I have a table with the following desc
CREATE TABLE `tblcoursesoffered
Vlad Shalnev wrote:
Hi, All
Can two mysql servers work on the same database directory ? It it possible in
read only mode or in read and write mode ?
With best regards
Yes, if you don't disable file locking.
Why would you do this though?
Each server will have to lock the files, blocking
Please read the warning.
It attempting a LOCAL connection.
Please enter the host ( server) you wish to connect to.
Jon Miller wrote:
I'm having a problem connecting to MySQL database using phpMyAdmin from
a remote location. I've had a look at the manual but I'm not too clear
on what has to be
You are mixing table and global grants together here.
Use separate grant commands. I am too lazy to look
it up right now, but FILE is global. I am not sure about
CREATE and DROP.
Aso, I believe that should be 'id'@'127.0.0.1'
not localhost.
localhost always connects to the pipe.
SSH connects to
No, it is not distributed.
Bruce Feist wrote:
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.
You already find it.
Is MySQL really distributed, or just client-server? I've seen no
indication of distributed capabilities; I'm new to MySQL, so maybe I
just
mysql -h 127.0.0.1 -u user -p --port=2000
Murad Nayal wrote:
Hello,
how can I force mysql interactive client (actually the client library as
well) to use a TCP port on the local host
if I do:
mysql -h localhost -u user -p --port=2000
I get:
ERROR 2002: Can't connect to local MySQL server
You moved the prototype startup script, not the output script created by
'make'.
You need to check the error log to see what the problem is.
Defryn, Guy wrote:
I have installed 4.0.9 from source.
After compiling it I want to start it with
/usr/local/mysql/bin/mysqld_safe --user=mysql
and
You have to show us.
Steve Holt wrote:
I am sure I am missing something very simple but I cant see it
I am using MS Access 97 as a front end to MYSQL
I have a table with the following desc
CREATE TABLE `tblcoursesoffered` (
`DateCourseCreated` datetime default NULL,
`Specialty` int(25) NOT
It doesn't explain the problem at all, since you didn't say what the
problem was..
I would have expected an error message because:
You can't join USING (player) because 'Players' has no 'player', and if
it did, the WHERE
clause would be redundant. The WHERE clause also references the
It is automatic.
Next time you connect your laptop to the network,
and start mysqld on your laptop, it will catch up to the master
provided the bin logs are still on the master.
Daniel Negron/KBE wrote:
I have set up replication and have it working properly for the most part.
If I update the
Phil Dowson wrote:
Literally in MSSQL server you would have (but I cant use subselects)
SELECT t1id FROM t1 WHERE t1id NOT IN (SELECT t2id FROM t2 WHERE t2gid = 192)
SELECT t1id FROM t1 left join t2 ON t1.t1id =t2. t2id AND
t2.t2gid = 192 WHERE t2.t2id IS NULL
This is correct.
WHERE clause returns (1,1)
HAVING eliminates all records not HAVING f2=3.
[EMAIL PROTECTED] wrote:
Description:
HAVING in SELECT is evaluated before WHERE. This is not the
correct behaviour as HAVING should deal with the remainder of the WHERE
selection (according to
Your whole query is malformed. You have an aggregate function in the
having.
try:
select f1,max(f2) from tt where f1=1 group by f1;
Gabriel Tataranu wrote:
Hi,
this is NOT correct behavior. Where clause returns (1,1) and (1,2). The HAVING
clause should be applied to what WHERE has
You grant IP address does not match the IP address of the client failing
the connection.
Steve Pirk wrote:
That was a great suggestion (getting rid of the
blank user), but alas, it did not work. Here
are the three examples: (first one fail because the
blank user was removed)
[EMAIL
Perhaps TIMESTAMP will provide what you need.
Daevid Vincent wrote:
http://www.mysql.com/doc/en/CREATE_TABLE.html states Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE.
Is
Make sure you have an index on billingstatus.
Murugavel wrote:
Dear Mr. Venu Tech Group,
We are facing few problem in mysql database.
Take an eg.
we have table called bb_usersession0
user A is trying to delete a record which is having the billingstatus B .
User A
delete from
The user under which the mysql server runs must be the owner of these files.
Kevin Chan wrote:
Dear all,
I was downloaded the mysql-3.23.53-sol8-sparc-local.gz from
www.sunfreeware.com . But I don't know why I got the following error when
I start the mysql service :
030306 16:10:14 mysqld
Is your temp directory running out of disk space?
Seth Brundle wrote:
I attempted to optimize a table last night, which usually takes about 5
minutes but I expected to take longer as I had done a slew of deletes.
Well, it took over an hour, and from the last modified dates on the table
and temp
Band members should probably be in a separate table.
One person may be a member of several bands, and
the membership in a band changes over time.
This will make modeling difficult.
[EMAIL PROTECTED] wrote:
Hello,
I`m doing a database in MySQL to catalog cds, and i`m not sure if my table
You don't select last_insert_id() from table.
This will return the last_insert_id() for each row of the table.
You just select last_insert_id().
Tea Yu wrote:
Hi! I just tried
Windows ME + MySQL Server - 4.0.9/4.0.11 +
ConnectorJ - 3.0.4/3.0.6/3.1.0
with an InnoDB table
test (id
Databases are neither slave nor master, servers are.
A master may have many slaves, but a slave may have only
one master.
Brandl, Thomas wrote:
Hey guys,
Simply said, imagine this scenario:
A MySQL server with about 10 databases: A and 1 to 9.
Database A contains a 'special' table that is
Juan Carlos wrote:
Hello Everybody
I using MySQL and I want to show the record id for the SELECT
I know you can do
SELECT clientCode, clientName limit 20, 3
2030John
2040Charles
2050Mery
The limit show from record 21 (record id = 20) because the first start in 0
I want to
You may not have enough rows to make it worthwhile to use an index.
Sebastian Bergmann wrote:
For this query
mysql EXPLAIN
- SELECT COUNT(accesslog.document_id) AS item_count,
- data_table.stringAS item
-
-FROM pot_accesslog accesslog,
If the databases are owned by mysql.mysql, how can this happen?
You don't allow users to become the mysql user, do you?
Dyego Souza do Carmo wrote:
I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem...
My users is hacking the database because the MySQL system tables are
stored in .MYD
I your customers have root access to their machine, then there is no
security, nor can there be.
Dyego Souza do Carmo wrote:
MM You should use the filesystem security your operating system provides to
MM prevent common users from copying the database files. The directory that
MM the database
And you still have not shown us how you are entering the question marks.
Daneman wrote:
At 10:06 24-2-03 -0500, Keith C. Ivey wrote:
On 24 Feb 2003, at 13:42, Daneman wrote:
I use a perl script DBI to insert records into a mySQL database.
This database holds 1 text-column. Now when this
Danny wrote:
Can you update an auto_increment with NULL in MySQL? Obviously if you
try and put a NULL in directly it will increment to the next integer.
Is there some way to actually get a NULL in there instead of the
integer?
No.
Why would you want to?
are entering the string now() where you probably want the value
for the function now(). Leave off the quotes.
Daneman wrote:
At 14:25 24-2-03 -0600, gerald_clark wrote:
And you still have not shown us how you are entering the question marks.
Like this:
$sql = qq{ INSERT INTO main (id, categorie
Since you are comparing a string to a number, it probably can not use
the index.
Perhaps you should be more careful with your queries.
Gatica, Mario Alberto wrote:
I found the following error with mysql server version 3.23.52.
mysql select snb,id_servicio from Abonados_Servicios where
Stéphane Pinel wrote:
I've installed 3.23.53 on a MacOS X box.
verything seems to be OK except:
when I use mysql like this :
/usr/local/bin/mysql test
..no problem.
but if I want to use any option like :
/usr/local/bin/mysql test -u
This is not valid usage.
/usr/local/bin/mysql -u
Show us.
We have no idea how you defined your tables,
loaded your data, or structured your query.
Bryan Koschmann - GKT wrote:
Hello,
I'm creating a table where one column will be prices. How is this type
supposed to work? I tried it, loaded the data, and it cuts it off at the
decimal when I
understand it.
Thanks,
Bryan
On Fri, 21 Feb 2003, gerald_clark wrote:
|Show us.
|We have no idea how you defined your tables,
|loaded your data, or structured your query.
|
|Bryan Koschmann - GKT wrote:
|
-
Before posting
I don't have a mailing list, and I don't appreciate your email.
You subscribed to the mysql mailing list, or you would not be getting it.
The instructions to unsubscribe are at the bottom of every message.
Kip McGee wrote:
will you please take me off of your mailing list if you dont im gonna
Looks to my like skuagent should be using the varchar fields instead of
the int fields.
Then you could just insert ignore each line from your test file.
Paul Chvostek wrote:
Hi all.
I need some help figuring out how to update a many-to-many relationship
from a text file.
For the fun of it,
Stephen Tiano wrote:
I'm just starting out, doing tutorials and exercises up the wazoo,
trying to learn MySQL and PHP.
I've created a table in a test database. When I do a DESCRIBE
[table_name], the columns come up just as they should. Populating them
with data's another story.
I've
Sort them yourself after retrieving them.
Rob wrote:
I have a question regarding the use of LIMIT with ORDER BY. My problem is
as follows:
I want my users to be able to pageanate through result sets, so I've written
some code
that will display the results of a query 15 rows at a time in a
create newtable select from oldtable where 1=0;
Admin wrote:
In MySQL is it possible to create a temporary table without having to
specify all the properties? On SQL Server (at least via query analyzer) you
can create temp tables fairly easily and the properties of each field are
inherited
chown -R mysql.mysql/var/lib/mysql
Substitute the actual location where mysql stores its data files.
J. A. Tovey wrote:
ok :)
all killed now,
(not quite there yet though :))
I am now getting the error:
030211 16:26:51 mysqld started
030211 16:26:51 /usr/local/mysql/bin/mysqld:
Can't
There are three kinds of people in this world;
those who can count, and those who can't.
Ray wrote:
You are inserting 6 values into 7 fields, so it fails.
looks like a 6 field table to me
create table if not exists MSFT (date DATE not null, close
DECIMAL(10,2), high DECIMAL(10,2), low
Am I blind, or are those two queries the same?
James Pharaoh wrote:
Hi,
I'm trying to optimize the following query:
SELECT *
FROM user LEFT JOIN history ON user.userid = history.touserid OR
user.userid = history.fromuserid
WHERE user.state = 'ready'
GROUP BY user.userid
This causes a full
You are inserting 6 values into 7 fields, so it fails.
You don't see the failure because you are doing an insert ignore.
You are also inserting numbers with 4 digits right of the decimal, where
you have specified 2.
Mudit Wahal wrote:
Description:
I have a delete statement and an insert
You have some unnecessary indicies.
What happens if you remove them?
Ciprian Trofin wrote:
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE DATABASE test;
USE test;
# Structure for table users :
CREATE TABLE
I use version 2.
Christian Andersson wrote:
Hi there, I have a little question for you in the mysql community..
I was wondering how persons in this community handles changes to the
database when your application that uses the database needs some new
tables, columns, etc...
Do you have an
Since that is exactly how the manual describes it, it must be a feature.
If you have more than one timestamp, they will all get set on an insert,
but only the first will be changed on an update.
Marco Deppe wrote:
Hi,
I was already questioning my sanity, but the problem below is
reproduceable:
You don't.
you use the file as input to the mysql client.
mysql file.sql
Elby Vaz wrote:
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
Thanks,
e.
If your application is opening one database, and then updating
medic.sometable, the update will not be recorded in the bin file.
sam wrote:
I am trying to use replication with 4.0.9.
Changes to the datbase are not being recorded in
the bin file on the master for a DB called Medic
when
WHERE team_member.user_id IS NULL
William R. Mussatto wrote:
Hi,
I got a difficult problem with a SELECT query:
In my application there are two tables, one for all users (user_profile)
one for a user-in-team relation.
I want to know, which user is still not in a speciffic team. Users can
Have you run out of free disk space?
Henning Schulzrinne wrote:
Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond_wait(0xFF345548, 0xFF345558, 0xFF33EDB0) Err#62 ETIME
according to truss. There are no
Any calculation involving a floating point number will be imprecise.
It does not mater what column types are involved.
Octavian Rasnita wrote:
And does anyone know what column type I should use if I want a precise
calculation?
I've even tried with text and blob, but they are not working
What does mysqld.log say?
Manuel Velasco wrote:
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done
You need gnu tar.
Froin Laven wrote:
Solaris 8 (sparc)
gcc 3.2
Configuring from source version mysql-3.23.54a
2 problems:
1. I get a checksum error when untar'ing the tgz file found on any of the
download servers.
2. config.status: error: cannot find input file: readline/Makefile.in
The
Pedro Leite wrote:
Hi,
I'm new to MySql and to this list. I'm confused and lost. I installed MySQL
in a Mandrake box and with no problem at all, just followed the installation
procedures. Then I created a database, tables etc. All just fine. Then I
connected the database with a Domino
401 - 500 of 608 matches
Mail list logo