Mysql 4.0.18
++---+--+-+--++
| Field | Type | Null | Key | Default | Extra |
++---+--+-+--++
| id | int(11) | | PRI | NULL |
Under mysql 5.0.18 you can do something like:
// get the current value of the auto_increment counter
mysql select @@auto_increment_offset;
+-+
| @@auto_increment_offset |
+-+
|1105 |
+-+
1 row in set (0.00
Hi Karl,
Your question: can I add a $ when you select a view.
I suggest to include $ sign in the field alias, like:
Select title_id, ytd_sales * price AS `Turnover $` From titles;
HTH, Cor
- Original Message -
From: Karl Larsen [EMAIL PROTECTED]
To: Chris W [EMAIL PROTECTED]
Cc:
pls click this link www.venadsolutions.com and
find new things
--
Thanks Regards,
veerabhadra rao
narra,
+91-988-556-5556
If you are using autoincrement filed you could try this:
ALTER TABLE `my_database`.`my_table` AUTO_INCREMENT = 201;
...or else if it is some stored proc you should find and edit table
where it sotres index/counter data..
Tom Ray [Lists] wrote:
Hey, I have a really simple question (I
On Friday 23 June 2006 09:09, Veerabhadra rao Narra wrote:
pls click this link www.venadsolutions.com and
find new things
This is what I consider as SPAM...
So do not click the link...
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list
Hi Remo, your method works fine on version 4.1 and the one shown for
version 5 does not work here. Nice to know there is a SQL word
AUTO_INCREMENT to do the job.
Karl
Remo Tex wrote:
If you are using autoincrement filed you could try this:
ALTER TABLE `my_database`.`my_table`
Well that works fine, but I want to put a $ sign in front of every
dollar amount. I will do that but I'm not there yet.
Karl
C.R.Vegelin wrote:
Hi Karl,
Your question: can I add a $ when you select a view.
I suggest to include $ sign in the field alias, like:
Select title_id, ytd_sales
Scott, can you expound on what 1 row would be returned, ideally? The
one with the shortest distance? Or a row with the sums of inc_level1
... inc_level7 ?
Looks to me like you're trying to locate all the ZIP codes within a
given radius of (in this case) ZIP 94949 with the query below.
Hi All,
Can some kind soul tell me from where I can download the Embedded
Library version of MySQL?
--
TIA,
Asif
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I got a strange problem.
I run a test-webserver and a MySQL server on the same machine. The code to
connect to the database is:
$db_link = mysql_connect (sql2.dahl-stamnes.net,stmbk,);
This gives me the error:
Warning: mysql_connect(): Client does not support authentication protocol
I assume you are using php. It has to do with how the password in mysql is encrypted. On some accounts, the ones that work, it's
encrypted in the old way that php can use. The default new, php 4 can't use.
Here's the part of the manual that explains it and how to fix it:
On Friday 23 June 2006 15:30, Brent Baisley wrote:
I assume you are using php. It has to do with how the password in mysql is
encrypted. On some accounts, the ones that work, it's encrypted in the
old way that php can use. The default new, php 4 can't use. Here's the
part of the manual that
Hello all,
Just looking for some advice from any of you that have done what I'm
about to do. I'm being forced by management to make a whole lot of
changes to our current MySQL db at one time. Something I'm personnaly
not thrilled with.
Current config:
Redhat 9
MySQL ver 4.0.16
DB Engine
Hi Fredrik, all!
Fredrik Andersson wrote:
Hi all
I have problems getting MySQL autoboot on my RedHat installation. [[...]]
In addition to permissions (see the other posts), there is another
possible problem:
Depending on how your environment is set up, the MySQL server may need
some other
At 02:43 PM 6/22/2006, Bartis, Robert M (Bob) wrote:
If you will excuse my ignorance. I have no immediate need for this, but
have often asked what the pros/cons there are writing a WEB based
interface in PHP vs. say Perl. Do you have any insight into that?
Thanks
Bob
Bob,
Ok, so you
At 02:43 PM 6/22/2006, Bartis, Robert M (Bob) wrote:
If you will excuse my ignorance. I have no immediate need for this, but
have often asked what the pros/cons there are writing a WEB based
interface in PHP vs. say Perl. Do you have any insight into that?
Thanks
Bob
Something else I should
At 15:47 +0200 23/6/06, Jørn Dahl-Stamnes wrote:
Yes, I forgot to say that I was using PHP...
Oh, I think the clue was in the subject line. :-)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Revolution: an abrupt change in the form of misgovernment.
-- Ambrose
Am Freitag, 23. Juni 2006 16:27 schrieb Chris Sansom:
At 15:47 +0200 23/6/06, Jørn Dahl-Stamnes wrote:
Yes, I forgot to say that I was using PHP...
Oh, I think the clue was in the subject line. :-)
ever tried localhost as hostname?
--
Jochen Kaechelin, fvgi242ss, wlanhacking.de
On Friday 23 June 2006 06:18 am, Asif Lodhi wrote:
Hi All,
Can some kind soul tell me from where I can download the Embedded
Library version of MySQL?
I don't see a binary version avaliable, but I know the following configure
option exists:
--with-embedded-server Build the embedded
On 6/23/06, Jørn Dahl-Stamnes [EMAIL PROTECTED] wrote:
On Friday 23 June 2006 15:30, Brent Baisley wrote:
I assume you are using php. It has to do with how the password in mysql is
encrypted. On some accounts, the ones that work, it's encrypted in the
old way that php can use. The default
Hi,
I haven't tried this one, but I think this might help
http://mysql-je.sourceforge.net
Asif Lodhi [EMAIL PROTECTED] wrote: Hi All,
Can some kind soul tell me from where I can download the Embedded
Library version of MySQL?
--
TIA,
Asif
--
MySQL General Mailing List
For list archives:
I am sorry, this in case if your programming in java.
Melvin Zamora [EMAIL PROTECTED] wrote: Hi,
I haven't tried this one, but I think this might help
http://mysql-je.sourceforge.net
Asif Lodhi wrote: Hi All,
Can some kind soul tell me from where I can download the Embedded
Library version
Well I believe I'll need to update mysql since I just realized this
server is using 3.23. Gotta love taking something over from someone and
finding out they weren't very good at the job to begin with.
Karl Larsen wrote:
Hi Remo, your method works fine on version 4.1 and the one shown
for
[This is really OT for a MySQL list - sorry folks.]
Forgive me if I'm telling you what you already know, but IMO the most importing
thing to do when getting into web development is to learn how to build web
sites securely. This might be a good starting point:
I'm trying to load data into a table from a file but I get an error message:
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
This error message isn't very specific as to what is going wrong and I have
no idea what it is about the data file that is wrong. Of course, I
Dear All,
I've been hashing out this query for awhile with no luck as of yet.
Basically the query works if I put a limit of 500 or so but when I do the full
query it takes up so many resource that the database engine is useless.
Here is the query:
SELECT DISTINCT (td.td_id) ,td.venue_id as
Ferindo Middleton wrote:
I'm trying to load data into a table from a file but I get an error
message:
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
This error message isn't very specific as to what is going wrong and I have
no idea what it is about the data file that
Paul Nowosielski wrote:
Dear All,
I've been hashing out this query for awhile with no luck as of yet.
Basically the query works if I put a limit of 500 or so but when I do the full
query it takes up so many resource that the database engine is useless.
Here is the query:
SELECT DISTINCT
Here is your query rephrased a bit. I find this query structure easier to debug, especially when their are lots of joins. This is
also the preferred structure in mysql 5 as I recall.
Notice the ON ? part of the join. You didn't specify anything join condition so your doing a full join, very very
I ammend my previous post.
Paul Nowosielski wrote:
Dear All,
I've been hashing out this query for awhile with no luck as of yet.
Basically the query works if I put a limit of 500 or so but when I do the full
query it takes up so many resource that the database engine is useless.
Here is the
Paul,
SELECT ...
FROM
tourdates td,
tbl_ARTST as art,
artist_tourdate artd ,
tbl_VENUES tv,
tbl_VENUE_CAPACITY tvc ,
tbl_VENUE_AGE_XREF tvax,
tbl_VENUE_AGES tvage
LEFT JOIN tbl_VENUE_CAPACITY ON (tv.ID=tvc.VENUE_ID)
LEFT JOIN tbl_VENUE_AGE_XREF ON (tv.ID=tvax.VENUE_ID)
LEFT JOIN
I guess my general reason for posting this was to ask: Are there any known
issues with the LOAD DATA INFILE comand in MySQL? However, I stripped all
the data in the file (test.tab) down to one record which still wouldn't
load. Here is the command:
mysql LOAD DATA INFILE 'C:/Program Files/Apache
Thank you all so much for your help, here is my solution:
(I'm sure I can do a little more optimization)
SELECT DISTINCT (td.td_id) ,td.venue_id as ven_id, td.td_date as td_date,
art.NAME as art_name,art.WEB as art_url, artd.artist_id as art_id, tv.ID,
tv.NAME as ven_name, tv.ADDR1 ven_add0,
Scott, can you expound on what 1 row would be returned, ideally? The
one with the shortest distance? Or a row with the sums of inc_level1
... inc_level7 ?
Looks to me like you're trying to locate all the ZIP codes within a
given radius of (in this case) ZIP 94949 with the query below.
I'm looking for a simple python program which offers
a graphical interface for entering data
into a simple MySQL table.
Is there a standard, or semi-standard, program for this?
Or can anyone offer a sample program?
If relevant, I'm running Fedora-5 with KDE.
I read of datakiosk, but couldn't
Reading about DBs I am seeing the term selectivity.
What does it mean? Seems like it has something to do with the
distribution or pattern of data in tables(?)
It's coming up in discussions about optimization...
Thanks
--
MySQL General Mailing List
For list archives:
I am trying to build a query to
1) Get all the results from one table, 'images'
2) For each entry in the 'images' table, find the correct title from
the 'playlist' OR 'media' table where images.id = which_table.images_id
images table
id, filename
playlist table
title images_id
media table
Scott, I think you want something like this, then, assuming you still
want to limit by radius from a given ZIP.
SELECT b.zipcode,
sum( b.inc_level1 ), sum( b.inc_level2 ),
FROM zipcodes a, zipcodes b
WHERE a.zipcode = 94949
AND (3956 * (2 *
Hi,
I am trying to use locate() function to get position of a substring in a
text field which on average has 2000 characters and the search substring is
30 -50 characters long. The table has around 2 million records and looking
for a efficient way to do the search. I tried fulltext index but
Hi Chris and Melvin,
Thanks a lot for the quick responses. I have found it. Actually, it
comes bundled with the main distribution. The documentation is in the
main reference manual and the header can be found in the include
directory.
--
Thanks again.
Asif
I don't see a binary version
kevin vicky wrote:
Hi,
I am trying to use locate() function to get position of a substring in a
text field which on average has 2000 characters and the search substring is
30 -50 characters long. The table has around 2 million records and looking
for a efficient way to do the search. I tried
42 matches
Mail list logo