Why am I having a problem getting a date field to hold date? I will store
2004-10-15, save the record. Reopen the record, and there is just
-00-00
What's going on here?
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
Hi List,
Can any one show me the practical query of creating a table which should contain a
column with BLOB Datatype.
--Nikhil.
Hi all
I have just released a utility (under the GPL) that enables SQL to be
incorporated into UNIX/LINUX shell scripts (easier than using psql or
similar with better integration).
For more information see http://www.edlsystems.com/shsql
To download ftp://ftp.edlsystems.com/shsql
(needless to s
OK, thanks. I've reported this as a bug, and another, below. I must
admit, this production release seems flakey:
http://bugs.mysql.com/bug.php?id=6447
On Fri, 2004-11-05 at 04:03, Haitao Jiang wrote:
> Mark
>
> It is a known problem with this feature. So far I am not aware of any
> solution to it
Mark
It is a known problem with this feature. So far I am not aware of any
solution to it. Just want to let you know that you are not alone
having this problem.
Haitao
On Fri, 05 Nov 2004 02:16:49 +, Mark Maunder <[EMAIL PROTECTED]> wrote:
> I keep getting this error when trying to preload
I have a large fulltext index (the MYI file is about 750 Megs) and I've
set my key_buffer_size to 1 Gig. I do:
load index into cache fttest;
and I watch the Mysql process in memory, and it doesn't grow. It just
hangs around 250Megs. Why isn't the index loading into memory?
Thanks,
Mark.
--
MyS
I keep getting this error when trying to preload a fulltext index. I've
checked the block size of the fulltext index using myisamchk (is there
an easier way to find out block size?) and it is 2048. The block size of
the primary key on the same table is 1024. Is that what it means by
"Indexes use di
You could just add a column to the beginning of your table called rowid
and index it.
On Thu, 2004-11-04 at 18:07, Raj Batra wrote:
> Is there any way of identifying each row in a table? I know in Oracble we have rowid
> which remains fixed as long as the table exists. I am trying to search all t
Raj Batra wrote:
Is there any way of identifying each row in a table? I know in Oracble we have rowid which remains fixed as long as the table exists. I am trying to search all the tables in a database and then display the searched information alongwith some sort of row identification.
It sounds
Is there any way of identifying each row in a table? I know in Oracble we have rowid
which remains fixed as long as the table exists. I am trying to search all the tables
in a database and then display the searched information alongwith some sort of row
identification.
--
In my experience, RedHat in their 'wisdom' put mysql.sock in /tmp/ yet
ships their mysql-server.rpm with a my.cnf pointing at
/var/lib/mysql/mysql.sock
Make the necessary change to /etc/my.cnf to point to /tmp/mysql.sock, or
change /etc/rc.d/init.d/mysql to point to /var/lib/mysql/mysql.sock
-
Hi Dan,
There are a number of different variables that can be set. eg. log_bin
etc. These can be set on the command line as
--log_bin= or alternately can be set in your my.cnf file as
log_bin=
The complete set of variables can be found in the manual in section
5.2.3 System Server Variables. If y
hi,
having a hack with the whole imp, horde, webmail thing
have installed the mysql server and client rpms on redhat8 and just
trying to get started.
/usr/bin/mysqladmin -u root password password
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't
Is there a configure option to tell mysql not to put logs in /var/log?
I don't want to run mysql as root if I can avoid it, and my /var/log
directory requires root access.
I tried using --localstatedir=$HOME/mysql-state, but that didn't help.
I determined that mysql wouldn't start up correctly
Anders Green wrote:
There are differences, starting with 4.1.5, with the
user/schema administration, that need to be updated/massaged.
Perhaps that is your problem?
I don't think so, everything works perfectly on my test server, which is
very similar.
Thanks,
Maybe.
:)
Anders
+===
I recently migrated a myisam database to a dual processor AMD Opteron
(see specs below) host and found that tables would sporadically lock and
not release and so all subsequent inserts would be blocked. In this
state, I was unable to nicely restart the server. It would simply give
up. Repairing
There are differences, starting with 4.1.5, with the
user/schema administration, that need to be updated/massaged.
Perhaps that is your problem?
Maybe.
:)
Anders
+===+
|Anders Green Email: [EMAIL PROTECTED] |
|
Can I perform an update on a table using load data infile..?
If I have the following table...
Name Score Rank
John NULL NULL
Susan NULL NULL
And I have a data file that has...
John,95,1
Susan,89,2
Any idea if this can be done?
Thanks,
--
MySQL General Mailing List
For list archives:
It's not a simple question at all.
Your users actually DON'T talk to the database, your PHP application does.
Your users converse with your PHP code. Your web server will have one
layer of authentication just to allow the user to view the pages your site
is composed of. Assume for a second th
The answer is you create one user for the PHP (webserver) process to
use.
Then you keep track of user permissions in your application code. This
probably involves creating your own user table within your own database
and storing users of your site there. Then in the other tables you
associate it
Hello,
a server of us with dozends of databases from our customers is running
mysql 4.0.x and some users are using timestamp-columns in their tables.
If we would switch to 4.1.x immediately, there would be no time for our
customers to check their scripts relying on the older timestamp format
wi
Hello all,
Basic question about creating a database that will be accessed by many users. Do I
create one web user account with no password in the mysql.user table or add each user
to the mysql.user table as they join up to my site? (Lots of books and documentation
says how to create users, the
I also use tinyint(1) unsigned
and I provide a "mysqlBooleanFormat()" function in my application that will
return 1 or 0 for storing the value in the DB
-Original Message-
From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]
Sent: 04 November 2004 20:44
To: [EMAIL PROTECTED]
Subject: Re
Personally I use a tinyint(1) unsigned.
Scott Hamm wrote:
What data type should I use to use True/False type when I create a table?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday 04 November 2004 02:28 pm, Scott Hamm wrote:
> create table account (
> ID int auto_increment,
> Date date,
> Check_Number int(5),
> Bank_Match int enum(0,1),
> Category varchar(20) no null,
> Credit decimal(7,2),
> Debit decimal(7,2),
> Balance decimal(7,2),
> primary key (ID)
> );
It
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 04, 2004 3:15 PM
Subject: True/False data type
> What data type should I use to use True/False type when I create a table?
>
MySQL 4.1.x includes a column type called Boolean whic
[snip]
That page is ambiguous about creating a table with enum...
[/snip]
A teeny-tiny bit more digging and you would have found it...
`Good` enum('true','false') NOT NULL default 'false'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
That page is ambiguous about creating a table with enum...
create table account (
ID int auto_increment,
Date date,
Check_Number int(5),
Bank_Match int enum(0,1),
Category varchar(20) no null,
Credit decimal(7,2),
Debit decimal(7,2),
Balance decimal(7,2),
primary key (ID)
);
Didn't work.
---
[snip]
What data type should I use to use True/False type when I create a
table?
[/snip]
ENUM http://www.mysql.com/enum
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What data type should I use to use True/False type when I create a table?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I've upgraded one of my servers (test) to 4.1.7 this week, all went ok.
Now I'm trying to upgrade another server (production) from 4.1.3 to
4.1.7 and I'm having serious problems. I tried 4.1.6 as well, same problem.
OS: Tao Linux (Red Hat Enterprise Linux 3.0 clone).
First, since I could
Strace the thread to see what it's cycling on. Sending a HUP signal should
shut it down.
Since max is a dynamic binary ie not statically built you might have some
weird operation with your environment.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
>
Nope, You need a key on your SOURCE column to help this query respond.
ALTER TABLE email_table ADD KEY(SOURCE);
Then, try again.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Rob Kudyba <[EMAIL PROTECTED]> wrote on 11/04/2004 02:02:09 PM:
> Wow even the 1st query seems to
Are you linking against an old library binary?
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 03, 2004 10:19 AM
> To: MySQL Listserv
> Subject: Undefined symbols compiling ag
Wow even the 1st query seems to be taking a while...been like 5 minutes.
The DB has "only" around 80,000 records. I do have an index key which is
"email_address_id" so would adding that in the query help speed it up?
Thanks for the quick reply & suggestion...
[EMAIL PROTECTED] wrote:
This query
Rhino wrote:
- Original Message -
From: "Rob Kudyba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 04, 2004 12:26 PM
Subject: constructing a select and excluding duplicates
I am trying to construct a SELECT statement on distinct email addresses.
Our DB has emails
This query will list all of the email addresses where SOURCE='Source1' but
are not listed within any other source
SELECT et1.email_address
FROM email_table et1
LEFT JOIN email_table et2
on et2.email_address = et1.email_address
and et2.SOURCE <> 'Source1'
WHERE et1.SOURCE = 'Source
You should read this page on clusters:
http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Limitations_in_4.1.html
Replication and clustering is different technology.
Replication works great, but there are no algorithms to prevent the same
row being updated on different servers at the same time (in ot
- Original Message -
From: "Rob Kudyba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 04, 2004 12:26 PM
Subject: constructing a select and excluding duplicates
> I am trying to construct a SELECT statement on distinct email addresses.
> Our DB has emails entered b
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database.
Just FYI to everyone replying:
Ed replied to me personally admitti
On Wed, 3 Nov 2004 08:31:18 -0500 (EST), Ed Curtis <[EMAIL PROTECTED]> wrote:
>
> I'm trying to get a slash in a variable into my database and am having
> some trouble. If the variable = "1 1/2" it echoes to the screen correctly
> but it seems to strip the 1/2 off the variable when updating the va
The email addresses from source1 that are also not part of all of the
following sources (source2, source4, and source6).
What I meant was there are addresses that are duplicate and exist in
source 1, source 2, source 3, et. al. I want to only include the
distincts from all of them, in other wor
So what are you really after:
All email addresses that are unique (not multiple-sourced)?
The email addresses from source1 that are duplicated from no other
sources?
The email addresses from source1 that are not from any of the following
sources (source2, source4, or source6)?
The email addresse
The complete error is:
ERROR 1064 (42000) at line 355: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'Purge CHAR(1),
Dehydration CHAR(1),
SomachDistentionCHAR(1),
TissueGa
Thanks, I did have a look at it and it seems that I could use embedded
mysql with no conffiles at all. :-) I like it becouse I would prefer
application configuring mysql based on its own config or status and not
having spread conffiles for each used library. Besides, various
applications using this
I prefer to explicitly declare my INNER JOINs (not to imply them by using
commas to make a list of tables). That way I avoid accidentally creating
any Cartesian products of any tables by leaving out a WHERE condition.
Missing ON conditions are much easier to spot (IMHO).
http://dev.mysql.com/do
I am trying to construct a SELECT statement on distinct email addresses.
Our DB has emails entered by various sources and there are duplicate
addresses based on the source. Using sample table names and sources here
is what I have:
SELECT DISTINCT email_address
FROM 'email_table'
WHERE SOURCE
Aha, what solution would you recommend? I would like some open and free
product working in linux and win, easy to interact with other products
and some relation among tables capabilitie (foreign index,
constraint...).
I focused on sqlite because It seem to match this requirements and it is
alread
Hello Gleb,
> Please read the notes about MySQL on Linux:
>
> http://dev.mysql.com/doc/mysql/en/Linux.html
I don't find anything specific to my problem there, sorry!
My Linux installation seems to be missing something that the
bdb part of MySQL 4.1 needs and which was not needed by v4.0
and b
The attachment describing your tables didn't come through. However,
here's roughly how your SELECT statement might look:
SELECT Order.id_order, Employee.name_employee,
ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order
FROM Order, Employee, ItemsOrder, Unit
WHERE Order.id_order=ItemsO
Hi,
I need to make relationishp between 4 tables in my system.
I just don´t know how to make.
Somebody could help me, please?
The tables are: Order, Employee, ItensOrder and Unit.
My objective: to program a report of Order that appears in the screen the fields (
id_order, name_employee, da
Hi.
You may tell MySQL where the data files are stored in the argc,
when you are calling mysql_server_init. Also you may put other
server variables into this array.
I think, MySQL can do most tasks, which you are looking for.
See:
http://dev.mysql.com/doc/mysql/en/Server_system_varia
At 09:14 AM 11/4/2004, you wrote:
I cannot see in mysql online manual Embedded example
(http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname
telling where de database will be saved in disk. So I suppose it must be
some existing database especified on some configuration file.
Could
Hi.
You may send us fragment of your file, near line 355.
spiv007 <[EMAIL PROTECTED]> wrote:
> Thanks, I go the dump now. but when i go to import the dump:
>
> mysql -D sd2000 -u root < mysqldump.txt
>
> Im getting errors; ERROR 1064 (42000) at line 355: You have an error
> in your
On Thursday 04 November 2004 01:13, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> added to the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/s/mysql/4189d686a90fba48/lists=buddhalinux.com
>
> This confirmation serves t
I cannot see in mysql online manual Embedded example
(http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname
telling where de database will be saved in disk. So I suppose it must be
some existing database especified on some configuration file.
Could be embebbed mysql be a replaceme
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
> Hi,
>
> The following query works out the amount of hours a user has
> been booked for on a particular day:
>
> SELECT
> (SUM(((DATE_FORMAT(B.Booking_End_Date, "%k") * 60 ) +
> DATE_FORMAT(B.Booking_End_Date, "%i")) -
> ((DATE_FORMAT(B.Booking
I just wanted to say that I think it's great that people like Heikki
Tuuri monitor this list and contribute to it.
Kudos to you!
Heikki Tuuri wrote:
Best regards,
Heikki Tuuri
Innobase Oy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Thanks, I go the dump now. but when i go to import the dump:
mysql -D sd2000 -u root < mysqldump.txt
Im getting errors; ERROR 1064 (42000) at line 355: You have an error
in your SQL syntax; check the manual, etc!!!
What does this means?
On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko
<[EMA
Hi,
The following query works out the amount of hours a user has been booked for
on a particular day:
SELECT
(SUM(((DATE_FORMAT(B.Booking_End_Date, "%k") * 60 ) +
DATE_FORMAT(B.Booking_End_Date, "%i")) -
((DATE_FORMAT(B.Booking_Start_Date, "%k") * 60 ) +
DATE_FORMAT(B.Booking_Start_Date, "%i")))
Hi.
> First, how can I detect, on localhost, which port MySQL is using?
Look at my.cnf.
Also see:
http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html
Schalk Neethling <[EMAIL PROTECTED]> wrote:
> Since installing the latest 4.1 version of MySQL I have not been able to
Hi.
select concat(database(),_utf8".",_utf8'table')
works fine. It is not clear for me - what is the problem? You can choose charset
according to your local settings.
Nick Arnett <[EMAIL PROTECTED]> wrote:
> I don't see a way to ask MySQL what the "full" name of a table is... the
Hi.
What operating system do you use? If you use MySQL compiled manually, it may be
helpful to use official binaries of the latest release.
You can look for some clues at the end of the .err log file.
Ginger Cheng <[EMAIL PROTECTED]> wrote:
> Hello, MySQL Gurus,
> I have a mys
Hi.
Send us information about operating sytem and MySQL version you use.
May be it will be helpful to install official binaries with enabled debug support of
the
latest release.
>I am using "INSERT DELAYED ..." to insert log records into a MyISAM table. Recently
>these
>inserts have
Hi.
See:
http://dev.mysql.com/doc/mysql/en/Repair.html
Abaghan Ghahraman <[EMAIL PROTECTED]> wrote:
> hi
> i have a PHP/MYSQL site in witch i have some scripts creating some tables.
> my host crashed several times this week and then many of my already
> created databases corrupted.the er
Hi.
Look at the output of
show variables like '%character_set%';
show variables like '%collat%';
show create table 'your_table';
Are all character_sets and collations the same?
Keith Morris <[EMAIL PROTECTED]> wrote:
> We are in the process of upgrading our installation of MySQ
On 4 Nov 2004 at 0:59, Schalk Neethling wrote:
> Since installing the latest 4.1 version of MySQL I have not been able to
> run phpMyAdmin.
>
> I have since gathered that the current version of phpMyAdmin is not
> compatible. I therefore ran Add/Remove programs on Windows and installed
> 4.0.2
Hello all,
After playing with the idea of 'abandoning ship' in favor of IBM DB2
or Oracle, we deiced to stick with mySQL, due its simplicity and
investment in time and experience we have put into it.
Our company needs a HA solution for ensuring 24x7 operation for the
mySQL server instances. As i
Hi,
I would like to know how to connect to the mysql database using a
DSN in mysql API's. I am using myodbc 3.51 driver.
Used the following API code for the connection
MYSQL *link = mysql_init(NULL);
MYSQL *connectHandle =
mysql_real_connect(link,"localhost","root","","test",0,N
Jerry Swanson wrote:
I want to redirect output of the query to the file in tab delimited
format. Can this be done?
Thanks
Select ... INTO OUTFILE:
http://dev.mysql.com/doc/mysql/en/SELECT.html
or mysql -e (documentation on the same page)
HTH,
Wolfram
--
MySQL General Mailing List
For list archives:
I want to redirect output of the query to the file in tab delimited
format. Can this be done?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I expect using the Master_log_File should be fine since the slave caches the
sqls in its own Relay_Log_File using the IO Thread.
Arvind Gangal
internet: http://www.lastminute.com
do something lastminute.com
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
S
72 matches
Mail list logo
