Use a different connection for each thread. last_insert_id() is isolated per
connection.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why use WinMySqlAdmin to view databases? The MySQL Control Center has a lot more
features and its usage is very straight forward.
If you are referring to the name that you gave it the first time you ran it then I
don't know. I'm curious about how to set it myself.
--
MySQL General Mailing Li
Can you post the code that does the update?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
These are completely different programs so you shouldn't have any problems. I've never
run into mention of any conflicts listed in the MySQL docs. You might check the docs
of the other applications. I know the MSSQL and MySQL can co-exist.
--
MySQL General Mailing List
For list archives: http:
Are you logged on as Administrator?
Is there enough disk space free?
Does it generate the same error if you try re-installing?
Is there an existing installation with the server still running?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Even though Napmarilu and localhost are resolving to the same machine, they are
different host names. MySQL security uses a combination of username and hostname in
the form of: [EMAIL PROTECTED]
That means that [EMAIL PROTECTED] is a different user than [EMAIL PROTECTED] Since you
have the Co
Did you set a password for the root account? MySQL comes with a root user that
(initially) has no password and all privileges. Most setup instructions have you
assign a password to the root account pretty early on.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
It looks like you didn't specify a user. Try this:
mysql -u root -p
It will prompt you for the password that you set up for the root account. After you
enter it you will get a mysql> prompt.
Now type:
create database newdatabase;
This will create a new database called newdatabase. You can l
Just enclose the column name in backticks (upper left key on your keyboard just below
ESC). Be warned that if you do this you will ALWAYS have to refer to this column using
the backticks. It would be MUCH better to remove the space from the name. You might
consider using an underscore instead.
> # If you specify no service name, the server uses the default service name of MySQL
> and the server reads options from the [mysqld] group in the standard option files.
> # If you specify a service name after the --install option, the server ignores the
> [mysqld] option group and instead read
These look like the security permissions for 3 MySQL user entries. The first one is
the administrator account which can do pretty much anything. The second looks like an
account used by a program. The third looks like it can be given to individual users as
it can only looks at records, not chan
Just convert the format of the input in your program before saving the value. In
VB/ASP us can do: replace(255,55,",",".")
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The double quotes have meaning in HTML. You might be confusing the parser. Try
replacing your double quotes with ".
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Char is more efficient when selecting but less efficient when storing (wastes space).
It is a trade off so there really isn't a "right" answer. Do some experimenting and
see what works best for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Did you stop and restart the server while you had the client up? This will break the
client's connection and force it to try and re-establish it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Could you post the contents of you my.cnf (or my.ini) file? What OS are you trying to
run the server on?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Comment out this line:
datadir = c:/SQLData
in the my.ini file in your windows (winnt) folder and remove the my.cnf from your c:\.
Start the server.
The default location of the data folder is c:/mysql/data. You told it to look in
c:/SQLData and it can't find it's security database. Also you s
Stored procedures are MySQL are real new so I don't have much experience with them
yet. The manual does seem to include some good info but I haven't delved too deeply.
MaxDB is actually a separate DB. It is a re-brand of SAP DB. You might look for SAP DB
info. It would probably apply to MaxDB.
Thanks for the correction. I didn't think to check InnoDB's docs. MySQL's docs don't
mention this. Sorry for leading you astray Joshua.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I had the same question a while back and I was told that InnoDB does this
automatically. There are no utilities that I could find.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It sounds like Zeos is checking the value of the number and reducing it's data type if
it can (for efficiency I guess). If cast isn't available in your version of MySQL you
might try Convert().
Here's a manual link:
http://www.mysql.com/doc/en/Cast_Functions.html
--
MySQL General Mailing List
I don't think that Linux uses GUID's. They are a Microsoft construct. I just searched
the MySQL manual and it doesn't mention them. What are you using them for? There may
be an equivilent available.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In our accounting software our users can manage the books for several different
companies with the same program. As such I have to keep a field (in every record) that
designates which company the given record is for and use it for report filtering,
lookups, etc. Had I used a different database
If you are using ADO then the field object has an actualsize property that should give
you your value.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That depends on what programming languages that you know how to use. You could use
PHP, Perl, Python, Java, C++, ASP (if you're on Windows) or many others. All of these
are available for free but you need to know how to use them. If you're looking for a
GUI driven program and you are already fa
First, please be aware that MySQL 5.0 is an alpha release. It is very young and there
may still be some unresolved issues. It is not generally recommended to use alpha
releases in production situations. Besides, anything that can be done in a stored
procedure can be implemented in client side c
To all list readers: I apoligise in advance for the following self serving plug.
I don't have a list of packages but the company I work for offers accounting software
that runs with MySQL on Windows. Email me at [EMAIL PROTECTED] or [EMAIL PROTECTED] if
you want more info.
--
MySQL General
m, but I can't seem to figure out how to get it from only
> one query.
>
> Thanks
>
> Original Message Follows
> From: robert_rowe <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Multiple sums in one query
> Date: Wed, 7 Jan 2004 13:46:02
I would have to agree with you. The kinds of applications you mentioned need every
scrap of speed possible. All I was saying is that stored procedure use is a trade off
of flexibility vs. performance. In many applications the flexibility is more important
than the performance gain and that the
Are you wanting to do this in one query? You could put an order by on your second
query. The first row returned by it should be what you are after.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just copy the database folder to your new server. If they are not corrupt then they
should be accessible from your new server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You have to use Load Data Local. See this section of the manual:
http://www.mysql.com/doc/en/LOAD_DATA.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That depends on what language you are using to return the query results. Visual Basic
is an IsNumeric function. I'm sure other languages have something similiar. What are
you using?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
The concept of n-tier design is mainly one of flexibility. A proper n-tier design
should allow you to change either the front-end, business logic or back end (database)
with no (or minimal) changing of the other layers. This means that the user interface
(front end) is one layer (local exe, web
You could always write your own function to do the escaping for you. This following
link is an example written in VB that you could adapt to whatever language you are
using.
http://www.vbmysql.com/samplecode/stripquote.html
Here is another way of doing it if you can link to the libmySQL.dll (o
Try single quotes around instead of double quotes.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Back to stored procedures for a second. I use them with MSSQL. For certain tasks they
greatly improve performance because I don't have to move all the data client side. For
the vast majority of tasks though stored procedures yeild little performance gain.
I've seen systems that (designed as M
MySQL 5.0 does support triggers. It is still alpha though.
You might try using a timestamp field and polling your tables at intervals. It won't
be real time but it might be close enough.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Direct your developer to www.vbmysql.com. This site is dedicated to supporting
developers who want to use MySQL with VB. We will be happy to help him with anything
he runs into while writing your system for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
I'm lead developer for a company that writes custom software for the mining industry.
We support MSSQL and MySQL. I've found that from a programming aspect (VB + ADO) there
is relatively little difference between MSSQL and MySQL. There is some sight syntax
differences and MySQL versions < 5.0 d
I would greatly appreciate your notes if you are willing to post them. I'm currently
preparing for the core exam.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Null means "no data entered". If Null is allowed and you don't specifically set a
field to a value then it will be Null. If Null is not allowed then the field will be
assigned its default value unless you specifically set it to something during an
insert.
--
MySQL General Mailing List
For lis
If you are using the MyISAM table type and have FTP access to the MySQL data folder
then you can just upload the database folder to your server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Your easiest route would be to make createddate a DATETIME field and update it
yourself when you insert a record. You can then make updateddate a TIMESTAMP and let
MySQL set it to NOW() automatically for you by not specifying it in any of your insert
or update queries. If you made them both tim
What does nvl do? Here is a list of the functions from the MySQL manual:
http://www.mysql.com/doc/en/Function_Index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If your MySQL field is date or datetime then MySQL will store whatever date your put
in the field. If you use a timestamp field then MySQL will set this field to the
current datetime on an insert or update unless you specifically set it to something.
See this section of the manual for more inf
You need to select into dumpfile instead of outfile. See the section of the manual on
select syntax:
http://www.mysql.com/doc/en/SELECT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It sounds like you need to set up your security permissions. See the section of the
manual on grant:
http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This worked for me:
ALTER TABLE `test` CHANGE `somefield` `somefield` enum('new','used') DEFAULT 'new'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Both your client and your server must have the local flag turned on. Check phpMyAdmin
to see if there is an option to turn this on for the client side. I use ADO/ODBC and I
have to create a my.cnf file on the client machine with local infile=1(ON) in the
[client] section and tell the ODBC drive
Just try to access the databases with the permissions that you had previously set up.
If you can then it worked okay. If you can't then use grant to set your permissions up
again.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Issuing this command:
> mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD xx
set your password to xx
You will need to use
mysql -u root -p xx
from the local machine to get access with the root user.
This:
mysql -u root -p
is specifying a blank password.
I beli
One other thing to check is that there are indexes on the fields in the other tables
that you are joining to.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The "correct" entries for your my.cnf will vary depending on which features that you
want to support. There is no standard contents. See the manual for the chapters on
installation, configuration and optimization. Most distributions come with sample cnf
files called: my-huge.cnf, my-large.cnf,
Have you tried this code using:
hostaddr.sin_port :=htons(3306);
I've never done this but the code looks like it is checking the appropriate port on
all machines found. See what happens when you use the MySQL default port.
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
If remote clients will connect directly to your MySQL server then you will need to
open port 3306. If you are only going to access MySQL via server side scripts (PHP)
then you will not need to open this port as the scripts will connect to the localhost.
If you cannot see your web site then it
Here is a link to the MySQL manual. Lots of good info here.
http://www.mysql.com/documentation/mysql/bychapter/index.htm l
The max size of a varchar is 255 characters. You will want to use one of the text data
types if you are going to store long articles. I suggest mediumtext. You can find th
You might consider using Grant instead of editing the permissions table manually.
Follow this link for the appropriate section of the manual:
http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mys
Or you could use a subquery:
SELECT id, image, width, height FROM images
WHERE reference_number=(Select max(id) From images)
ORDER BY image
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One thing that I see is that you are using an alias in your where clause.
>From the manual:
> It is not allowed to use a column alias in a WHERE clause, because the column value
> may not yet be determined when the WHERE clause is executed. See section A.5.4
> Problems with alias.
The other t
This is from the manual. See the 3rd paragraph.
> The REPLACE and IGNORE keywords control handling of input records that duplicate
> existing records on unique key values.
>
> If you specify REPLACE, input rows replace existing rows (in other words rows that
> has the same value for a primary
If you are using the Load Data function then it doesn't matter. Load Data turns
indexing off and then rebuilds them at the end. If you are using normal inserts then
add the indexes after the import.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
62 matches
Mail list logo
