Hello Moon's Father,
That would be great..if it was in english ;)
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio [EMAIL PROTECTED]
wrote:
Hi,
Does anybody has a tip to install a MySQL
I'm trying to get used to visually mapping out my db design using the SqlYog
SchemaDesigner.
Once I have the PK/FK setup, how can I export that design to SQL code to
create the tables, etc??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Ok, I'm a little new a this, so be gentle!! :)
I was looking into the InnoDB engine for some tables I have, and would like
to use the PK/FK on some of the data.
It appears that the PK/FK is mainly used for updating/deleting data,
correct? I can't use it to retreive data from multiple tables
I am running a MySql server, ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year, nice and quick. Now it seems
like its running slowly. Is there a tool to test the db and/or install and
see if there are any problems???
Or would upgrading help?
Anyone have
I already have a version of MySql 4.1.17 running on a different server, but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
I modified the my.ini file and put it in the \windows directory for
I already have a version of MySql 4.1.17 running on a different server, but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
I modified the my.ini file and put it in the \windows directory for
I already have a version of MySql 4.1.17 running on a different server, but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
I modified the my.ini file and put it in the \windows directory for
I had tried to load a group of records from a Excel spreadsheet, and for
the most part it seems to have worked.
The problem is that I know there were more than 1000 rows of data to be
input, and it stopped at 1000 exactly.
Am I missing something to allow more than 1000 rows to be input?
Steve
Is it possible to remove all trailing and leading spaces for selected
fields once the data has already been loaded?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
default '',
`ProdCarb` varchar(35) NOT NULL default '',
`ProdCarbManu` varchar(6) NOT NULL default '',
`ProdStorage` varchar(30) NOT NULL default '',
PRIMARY KEY (`SpecID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Kevin A. Burton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Steve
I'm curious, why if I enter this code:
select *
from vendor
left outer join model
on vendor.PID=model.VendorID
left outer join specs
on model.Model=specs.ProdModel
where vendor.Vendor='#URL.Vendor#'
do I get the results like:
http://www.scootervilleusa.com/test1.cfm?Vendor=Tank
I simply want 1 row
If you can tell me the command to dump the table format, I'm more than
happy to list it here.
Steve
Rhino wrote:
- Original Message -
From: Steve Grosz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, December 11, 2004 3:57 PM
Subject: Strange results
I'm curious, why if I
'',
`ProdStorage` varchar(30) NOT NULL default '',
PRIMARY KEY (`SpecID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Kevin A. Burton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Steve Grosz wrote:
If you can tell me the command to dump the table format, I'm more than
happy to list
I am kinda new to SQL, and am having a problem trying to get something done.
I'm trying to search for usernames in one of my tables. The name is
stored as firstname lastname.
I wrote my query as
select Cust_ID, Cust_Name
from mailings
where ucase(Name) = ucase(Cust_Name)
When it runs, I get a
, ODBC, etc.) which one and what version is it?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Steve Grosz [EMAIL PROTECTED] wrote on 12/03/2004 12:58:30 PM:
I am kinda new to SQL, and am having a problem trying to get something
done.
I'm trying to search
I am using the MySql Administrator tool to schedule weekly backups on my
databases. I have defined the databases I want backed up and how often,
plus where to store the data. I ran a sample, but it appears that just
the structure is being backed up, not the data in the tables as well.
How do
I am using the MySql Administrator tool to schedule weekly backups on my
databases. I have defined the databases I want backed up and how often,
plus where to store the data. I ran a sample, but it appears that just
the structure is being backed up, not the data in the tables as well.
How do
I had installed MySql on Win2003, and when I check the 'server
information' page, it shows a IP of 127.0.0.1. The IP of the server has
a 192.x.x.x address.
I'm asuming that this might have a problem why I can't telnet to it to
make sure the DB is working??
How can I change this, or do I need
That seems to work fine, but now the problem is that am no longer able
to log in to the Admin utility using root and the server name of db1. I
can get in using a alternate account I created before I made the change
just fine.
Jeff Smelser wrote:
On Tuesday 30 November 2004 01:36 pm, Steve
Ok, I'm new to MySql (or SQL in general). I'm curious what exactly a
stored procedure in MySql is, and what the benefit would be?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm using 4.15 currently, and it seems to be very stable. I noticed
that a v4.17 or something has come out recently.
Is it worth upgrading? Can I just install the new version without
damaging my current databases or are there specified steps? Where would
I find them if there are?
Thanks,
I'm referring to the MySql server v.4.1.5 that I'm using now, as
compared to the newer release of v.4.1.7
Paul DuBois wrote:
At 20:09 -0700 11/22/04, Steve Grosz wrote:
I'm using 4.15 currently, and it seems to be very stable. I noticed
that a v4.17 or something has come out recently
Is there a way to have a select NOT return columns that have either a
'null' or 'n/a' value? I have some shared specs for some products, and
some of the fields aren't used for all products, so I have blank entires
in those columns for those specific products. I'd like to return all
the info
in message
news:[EMAIL PROTECTED]
Hi.
If you send us output of show create table 'table_with_date_field',
and queries, which you use to insert and retrieve date,
may be we will be able to help you.
Steve Grosz [EMAIL PROTECTED] wrote:
Why am I having a problem getting a date field to hold
humble humans to take a guess ...
- Original Message -
From: Steve Grosz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 05, 2004 8:13 AM
Subject: Problem with date field
Why am I having a problem getting a date field to hold date? I will
store
2004-10-15, save
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:
I am just now getting the hang of searching through 2 tables, and
getting the corresponding information using a pri foreign key
(ID1=ID1) kinda thing. How is this done with more than 2 tables?
I had asked on a different forum, but I got some funky select statement
using a left inner join,
I am trying to store images in the longblob text type in one of my
tables, and then display the picture on a Coldfusion MX 6.1 page.
When I try to get it to display, I get the following error:
ByteArray objects cannot be converted to strings.
The error occurred in C:\Web
Where would I find a good online tutorial that would step me through
understanding setting up seperate tables, and the relationships between
then?
Thanks so much!!
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm just getting into the whole MySql (was using access). Is it better
to create a Blob type and insert a image into it, or to create a char
file type and have a directory structure to the specific file?
How big of files to the different Blob's hold? And if I'm using
Coldfusion, will that
Ok, with leaving the : off the end, and just typing telnet web-server2
3306 I get some jibberish on the screen, and a 'connection lost' message
after a few seconds. That's coming from a machine on the same side of
the firewall as the Sql server. For the other IIS server and Coldfusion
server
I am trying to set up a ODBC connection from a Coldfusion server to a
MySql server, both running on Windows2003 Servers. I installed the ODBC
3.51 driver on the Coldfusion server, and am trying to make the connection.
When I go to set up the ODBC link and say 'test data source' I get a
I also get the jibberish, and a connection lost error message. Is it
something in MySql server that I'm not setting up correctly?
Jochem van Dieten wrote:
On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote:
Ok, with leaving the : off the end, and just typing telnet web-server2
3306 I get
So, you're saying its a problem with the password on the root account?
This was a brand new install.
I'm a little confused here.
Steve
Michael Stassen wrote:
See the manual http://dev.mysql.com/doc/mysql/en/Password_hashing.html.
Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection
/Old_client.html which offers
work-arounds.
Michael
Steve Grosz wrote:
So, you're saying its a problem with the password on the root account?
This was a brand new install.
I'm a little confused here.
Steve
Michael Stassen wrote:
See the manual
http://dev.mysql.com/doc/mysql/en
I am new to using MySql. I installed it on a seperate server on
Win2003. That server has a 192.168.x.x address on my network.
I am trying to add a DSN connection from Coldfusion to the database, but
every time I try using the MySql driver/connection type, it says there
doesn't seem to be a
So what, a telnet 192.168.x.x:3306 ?
Eric Bergen wrote:
telnet to it. MySQL will return a 'hello' packet.
-Eric
On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz [EMAIL PROTECTED] wrote:
I am new to using MySql. I installed it on a seperate server on
Win2003. That server has a 192.168.x.x address
-0600, Steve Grosz [EMAIL PROTECTED] wrote:
I am new to using MySql. I installed it on a seperate server on
Win2003. That server has a 192.168.x.x address on my network.
I am trying to add a DSN connection from Coldfusion to the database, but
every time I try using the MySql driver/connection type
I have tried telnet web-server2:3306
Didn't work
Dwalu Z. Khasu wrote:
On Thu, 14 Oct 2004, Steve Grosz wrote:
=If that's the case, its not working, I type a telnet 192.168.x.x:3306
=and get a could not open a connection to the host even though
=Mysql-nt shows as running on the Win2003 server
40 matches
Mail list logo