[EMAIL PROTECTED] (Jerry Jones) wrote in
news:[EMAIL PROTECTED]:
I am trying to do an update, where item numbers 1-9 get four 0's added
to the front, 10-99 get three 0's etc.
mysql HELP LPAD
Name: 'LPAD'
Description:
Syntax:
LPAD(str,len,padstr)
Returns the string str, left-padded with the
Thanks! That really seems to do the trick. Amazing. Now, for some
stupid questions: The values 69.1 and 57.3... are you aware of some
documentation or tutorial explaining these values and the math? I'd
like to understand why it works.
Also, I would like to figure out how to, if possible, speed
Hello-
I'm working with an unfamiliar application, trying to figure out where
my data is going.
Is it possible to form a query to select from all the columns in several
tables at once? Something equivalent to:
SELECT FROM * WHERE * = 'john smith';
If that's not possible I'd still like to
boll wrote:
Hello-
I'm working with an unfamiliar application, trying to figure out where
my data is going.
Is it possible to form a query to select from all the columns in
several tables at once? Something equivalent to:
SELECT FROM * WHERE * = 'john smith'; If that's not possible I'd
I've been trying to figure this out using the CURDATE() function, but I keep
getting a syntax error. Below is the code I'm using:
SELECT
`vb_links`.`DateAdded`
FROM
`vb_links`
WHERE DATEDIFF( CURDATE() , `vb_links`.`DateAdded` );
Any thoughts?
-Original Message-
From: Mike Blezien
Ryan Stille wrote:
boll wrote:
Hello-
I'm working with an unfamiliar application, trying to figure out
where my data is going.
Is it possible to form a query to select from all the columns in
several tables at once? Something equivalent to:
SELECT FROM * WHERE * = 'john smith'; If
Hi,
i.e. you want to retrieve all the records of john smith from 3 or 4
tables. is it?
if so, use table alias. domainnames cannot be used directly.--try with
mysql select * from personal p, payroll r,department d where
p.ename=johnsmith or r.ename=johnsmith or d.ename=johnsmith;
Thanks
hi all...
i just wanted to ask here if somebody has experience in pushing the mysql
limits... i might have a job that needs to have a table (or a few tables)
holding about a 100 million records. that's a lot of records is there
any limitation of some kind that wouldn;t allow mysql to handle
Hi,
The limit for the table can be set when you create the table itself.
the MAX_ROWS and AVG_ROW_LENGTH variables (m X n matrix) will decide the
table size.
MAX_ROWS limts the maximum number of rows in that table. The AVG_ROW_LENGTH
variable decides the length of the row. The specified
On 2/3/07, abhishek jain [EMAIL PROTECTED] wrote:
Hi friends,
I am using mysql 5.0.23-nt on windows, i have to store large binary data
in database, i have used setting like max_allowed_packet=16M in mysqld
section of my.ini .
Now i have a poblem that i want to create a setup so that the entry
Hi,
AFAWK, if you modify any of the variables in the .cnf, obviously have to
restart mysql. no other go.
To transmit between client and server you need to configure both the client
and the server. Through .cnf you are configuring the server variable and
for client you can go for either
In the last episode (Feb 05), abhishek jain said:
On 2/3/07, abhishek jain [EMAIL PROTECTED] wrote:
I am using mysql 5.0.23-nt on windows, i have to store large binary data
in database, i have used setting like max_allowed_packet=16M in mysqld
section of my.ini .
Now i have a poblem that i
12 matches
Mail list logo