I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load
MySQL on boot? I don't see a script file that came with the installation.
Thank you.
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
If I BEGIN a transaction and a piece of PHP code containing another
transaction is run, the second BEGIN commits the first transaction for me.
How can I tell if I am in an existing transaction so that I do not issue the
second BEGIN?
Thanks..
Andrew
--
MySQL General Mailing List
For list archi
ALTER TABLE tablename ADD UNIQUE (Column1, Column2);
Best Regards,
Andrew
> Can someone explain how I can make a combination of two fields be a
> unique index.
>
> For example, in my table I have an OrderID field and a LineItems field.
> Individually the fields are not unique but when combined t
rderID in 1 Query... I'm using
MySQL 4.1.4
Best Regards,
Andrew Kuebler
AK Communications, Inc.
Phone: (866) 925-2666 x123 / Fax: 866-925-3296 (Toll-free)
<http://www.akcomm.com>
http://www.akcomm.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: W
I have a MySQL table with Order#'s (Primary Key).
I want to total the number of items per order which I do through an inner
join to the order contents, but then I want to also get a total on the
amounts a customer has been billed to make sure there isn't a customer that
has been shipped somethi
If I use "innodb_file_per_table", how do I properly back-up that table so it
could be imported to another server should something happen to my main
server if I do not have the hot-back-up utility?
If I lock & then copy the table, can I simply use "ALTER TABLE tbl_name
IMPORT TABLESPACE" for it
I know this is not necessarily a MySQL question, but everyone on this
listserv is always so helpful and I was wondering if anyone had any
pointers on how to deduplicate a list of mailing address since there can
be so many inconsistencies on how an address can be written (road vs rd vs
rd., etc). I
Actually, no, it rounds to .01233.
> -Original Message-
> From: Andrew Kuebler [mailto:[EMAIL PROTECTED]
> Can anyone explain why:
>
> SELECT ROUND(.012345, 5)
> -> .01234
>
> Why doesn't mysql round the 5 up to .01235? How do I get it
> to round u
Can anyone explain why:
SELECT ROUND(.012345, 5)
-> .01234
Why doesn't mysql round the 5 up to .01235? How do I get it to round up?
I've tried manipulating ceil, floor, round and truncate and I can't seam
to find an easy way to do this.
I read in the manual that this behavior depends on the C li
Are BLOB column types the only columns that will let you write a NULL
(Hexidecimal 0) and still write beyond that?
CHAR, CHAR BINARY, VARCHAR, and VARCHAR BINARY all seem to truncate the
string and stop at the first null even if I escape the string being
updated.
I don't want to use a BLOB column
If I:
ADD COLUMN Text (BLOB)
And then
INDEX (Text(10))
Will that index be beneficial if I am search for 10 characters only or
anything 10 characters or less? Thanks in advance!
Best Regards,
Andrew
Sql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
I need to store strings encrypted with TripleDES that sometimes contain
unprintable characters (Hexidecimal values under 20). The values do not
seem to properly store in CHAR columns and I don't see any other column
types that might work.
Anyone have any other suggestions?
Thank you in advance!
When I type:
Show keys from [tablename];
I do not see foreign keys listed there and I cannot seem to find any
command that will list foreign keys. Can anyone help?
Also, I notice Innodb tables only store one file unlike MyISAM which
stores 3. Are Innodb tables any slower than MyISAM since they s
In one of my tables, I have an AUTO_INCREMENT column that changes to
"#Deleted" in each column in Access when I add a new record. To read the
data, I just entered, I must close the table and then reopen it. In
another table when I do the same thing, I see the new AUTO_INCREMENT
number come up in th
If I am reading the documentation correctly, MySQL will not maintain a
UNIQUE INDEX across the tables that make-up a merged table. Does anyone
have any tips for maintaining a UNIQUE INDEX across tables that make up
a merged table?
Is there an easier way than running a SELECT statement on all of th
I've upgraded to 4.0.6 and now MyODBC does not function properly when it
used to work fine with 4.0.1. When I try to open a linked table in
Access I get the error:
ODBC--Call Failed
[MySQL][ODBC 3.51 Driver][mysqld-4.0.6*gamma-nt]Access denied for user:
'@(My IP)' to database '(Database name here)
I have the following table; I renamed the columns a & b for easy
reading:
ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
aID INT(9),
bID MEDIUMINT(7),
UNIQUE ab (aID, bID)
INDEX b(bID)
As far as I understand the UNIQUE INDEX also provides the index for aID,
but not bID. Is there any other way to
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a "Duplicate entry" error. No further entries will be inserted. The
only way I know to get around this is to pull the entire column(s) into
memory and
I have a table with 17,168,035 records. I have the following column
types and I read about the following storage requirements for each
column:
(1) INT Column - Should take up 4 bytes each
(1) MEDIUMINT Column- Should take up 3 bytes each
(1) DATE Column - Should take up 3 byte
Currently I'm using 4.0.1 Alpha and I'm thinking of upgrading to 4.0.5
as I want to be able to issue UPDATE queries that span multiple tables.
Is there anything in particular I should know of or be aware of before
installing 4.0.5? What is the proper procedure for upgrading? Should I
first uninstal
If Column1 has a value of "John" And
Column2 has a value of "Doe"
How would I write an UPDATE query to SET Column3 to "John Doe" without
selecting the information and reposting it to the data through an UPDATE
for each and every record?
I've tried:
UPDATE $table SET Column3 = Column1 + " " + Col
I'm running a query to SUM a Decimal field with the configuration of
DECIMAL(6,2) and I get a result looking like: 56.5515009
How is this possible???
Thank you in advance...
Andrew
-
Before posting, please check:
ht
am, but I can see that being a 'bit of a
hassle..
Any help or input is appreciated. Thanks!
Best Regards,
Andrew Kuebler
AK Communications, Inc.
Phone: (866) 925-2666 x123 / Fax: 866-925-3296 (Toll-free)
http://www.akcomm.com
---
I'm trying to extract information from MySQL with Microsoft Access but
it will not pull a query with BIGINT columns correctly. I'm using the
newest ODBC driver, version 3.51.03 and MySQL Server Alpha 4.0.1. I've
installed the ODBC driver, configured the DSN, and can access all other
types of colum
I understand that a query like SELECT... FOR UPDATE will lock other
threads from being able to modify those records in any way, however,
other threads can still read them. I would like to be able to SELECT say
10 records and place a READ and WRITE lock on those rows so that the
next SELECT thread
I've made a few config changes (examples below) in the my.ini except the
server constantly utilizes 66 meg of memory total (Including OS) and I
never see mysql memory usage go any higher than 12-13 meg of memory
usage no matter how much strain I put on the machine. I do not believe
these new setti
I want to select say 100 of 1,000 records and get the highest value for
"id" in that query, however the MAX command always gives me the MAX for
the whole table, not just my query.
Here's my expression:
SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100
No matter what, I will always get
I use Perl/DBI with MySQL and I'm trying to find a way to sort email
addresses by domain. I would assume there is probably an option in MySQL
to strip off the text after the '@' sign that will allow me to sort on.
In Perl:
@fields = split(/@/, $email);
My domain would be displayed as: $fields[1]
Everyone on this list has been very helpful so far. I greatly appreciate
all the help!
I use Perl/DBI with MySQL. Normally to count records, I pull a query
like:
$a = $db->prepare("SELECT * FROM table");
$a->execute;
Then:
$numrows = $a->rows;
to get a total count of records in the table. Is
I want to query records that do not contain empty strings and null
values through a SELECT statement.
IS NOT NULL works for the nulls, but how I select non-empty strings
("")? I tried everything I can think of and even some non-published
statements like name IS NOT '' . I just can't figure i
I want to query records that do not contain empty strings and null
values through a SELECT statement.
IS NOT NULL works for the nulls, but how I select non-empty strings
("")? I tried everything I can think of and even some non-published
statements like name IS NOT '' . I just can't figure i
Hello Everyone.
I'm still fairly a newbie to MySQL, but I could have sworn I read
somewhere that MySQL supported relationships just like Access. I've
searched the entire manual, and cannot find anything on the subject.
Does MySQL support relationships, and if so does anyone know where I can
find
Maybe someone can help me here..
I'm inserting data with an AUTO_INCREMENT column and immediately after I
need to use that new number for a corresponding record in another table.
How am I able to extract that new number quickly? I could run a SELECT
query after the INSERT using the MAX command, b
I know Databases are supposed to be larger than the data normally would
be in straight txt form, but 370% larger?
I'm a newbie to MySQL. I made a new database/table with 2 columns and I
was importing a 24.1 meg TXT into column 2. It's nothing in
particular...just radom txt and words because I wan
34 matches
Mail list logo
