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 MySQ
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 Wind
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
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]
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
-
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]
lt '',
`ProdCargo` varchar(8) NOT NULL default '',
`ProdWarranty` varchar(35) NOT NULL default '',
`ProdCarb` varchar(35) NOT NULL default '',
`ProdCarbManu` varchar(6) NOT NULL default '',
`ProdStorage` varchar(30) NOT NULL default '
7;,
`ProdColor` mediumtext NOT NULL,
`ProdConsumption` varchar(11) NOT NULL default '',
`ProdOilInject` char(3) NOT NULL default '',
`ProdLoad` varchar(7) NOT NULL default '',
`ProdCargo` varchar(8) NOT NULL default '',
`ProdWarranty` varchar(3
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 re
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
through any kind of library
> (connector/J, 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
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 er
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
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
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
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 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 co
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,
St
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 t
t; example, db description, etc.) would permit
> some 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
t; <[EMAIL PROTECTED]> wrote 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 G
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://
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, an
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:http://lists.mysql.com/[EMAIL
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 Sites\Scooter2\Scooters\V
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 sup
l.com/doc/mysql/en/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
<
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
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 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
message
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 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 sh
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 on my network.
I am trying to add a DSN connection from Coldfusion to the database, but
every time I try us
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 h
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 se
40 matches
Mail list logo
