Search Results

Search found 29197 results on 1168 pages for 'oracle mysql training'.

Page 620/1168 | < Previous Page | 616 617 618 619 620 621 622 623 624 625 626 627  | Next Page >

• Selecting financial values from db stored as text

  - by Midhat

  I have some financial values stored as text in a mysql db. the significance of financial is that negative numbers are stored enclosed in paranthesis. is there a way to automatically get the numeric value associated with that text. (like '5' shoudl be retuned as 5 and '(5)' should be returned as -5)

  Read the article

• How to limit a users uploaded image size using PHP

  - by LiMt

  I was wondering how would you limit an uploaded image size to 5mb using PHP & MySQL.

  Read the article

• Freeradius problem

  - by IceAgeBosna

  Hello my Dear friends! Firstly sorry to my English I am not an expert:) I am using freeradius 2.1.7 and MySQL instaled on Ubuntu server 9.04. Now, the perl script called: "auth.pl" is verifying usersnames, passwords, and updating information. The problem is that on a certain number of connections simply "NAS" - Mikrotik until the next reboot users can not connect. If you need i cann show you auth.pl script

  Read the article

• Free java or flash file browser for photogallery

  - by Christian

  Hi. I'm about to develop a small web gallery, where it's supposed to be possible to upload several pictures at a time and then add some info abut the pictures.So I need a free java or flash local file browser that can pass me some info of the pictures that gets uploaded so that I can create some SQL entries for each picture. The platform for the project will be PHP and MySQL. Any good recommendations?

  Read the article

• What should every PHP programmer know ?

  - by Waseem

  I would to be a PHP/Mysql Programmer what is the technologies that i must know ? Like :- Frameworks IDEs Template Engines Ajax and Css Frameworks please tell me the minimum requirements that i must know , and tell me your favourite things in the previous list ? thanks

  Read the article

• changing value of a primary key in a table and FK in referenced tables

  - by sergiogx

  I wish to change the primary key of a table, and also change the foreign key of the tables that reference it. for example table employee has PK idEmployee = 1 table payroll has FK idEmployee = 1 I want to update employee to idEmployee = 2 and let the table payroll change FK idEmployee automatically. is this posible in mysql? thanks.

  Read the article

• Do all databases use the USE statement to switch databases?

  - by thearchitect

  MySQL uses the USE database_name to change the active database. Does that work on all databases? EDIT: By databases I mean DBMS. Thanks for bringing it to my attention.

  Read the article

• How can use rdlc report with Oracle procedure ?

  - by Sony

  Can any one help to solve creating reports of rdlc using Oracle stored procedure.

  Read the article

• Transmogrify into date from multiple columns

  - by Dave Jarvis

  What is a better way to program the following SQL: str_to_date( concat(convert(D.DAY, CHAR(2)), '-', convert(M.MONTH, CHAR(2)), '-', convert(M.YEAR, CHAR(4))), '%e-%m-%Y' ) as AMOUNT_DATE I want to convert the columns D.DAY, M.MONTH, and M.YEAR to a date field using MySQL. The above works, but seems much more complicated than it needs to be. (If there's an ANSI SQL way to do it, that would be even better.) Thank you!

  Read the article

• Generate table schema inspecting Excel(CSV) and import data

  - by Frank Malina

  How would I go around creating a MYSQL table schema inspecting an Excel(or CSV) file. Are there any ready Python libraries for the task? Column headers would be sanitized to column names. Datatype would be estimated based on the contents of the spreadsheet column. When done, data would be loaded to the table. I have an Excel file of ~200 columns that I want to start normalizing.

  Read the article

• Does column ordering in databases affect performance?

  - by Rhubarb

  I am using Django with MySql. I have a CharField with max length of 64 as the 2nd to last column, and a Boolean as the last column. Will reversing the order of these provide better optimization of space?

  Read the article

• Should $new_link be used in mysql_connect()?

  - by Eddie

  I'm maintaining an inherited site built on Drupal. We are currently experiencing "too many connections" to the database. In the /includes/database.mysql.inc file, @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2) (mysql_connect() documentation) is used to connect to the database. Should $new_link = TRUE be used? My understanding is that it will "always open a new link." Could this be causing the "too many connections"?

  Read the article

• Simple SELECT query problem...

  - by Povylas

  Hi, I have this MySql select query witch seams to have a bug but I am quit "green" so I simple can not see, so maybe you could help? Here is the query: SELECT node_id FROM rate WHERE node_id='".$cat_node_id_string."' LIMIT ".$node_count_star.",".$node_count_end." ORDER BY SUM(amount) GROUP BY node_id Thanks for help in advance...

  Read the article

• How to get the one paramater from list of items in php

  - by Mirage

  I have one field in database table with following lines show_email_icon= show_hits= feed_summary= page_title= show_page_title=1 pageclass_sfx= menu_image=hd_events.png secure=0 All the stuff is stored as text in one field of mysql table Now i want to get the menu_image. How can i get that

  Read the article

• Diffence between "select count(null)" and "select count(1)"

  - by Midhat

  In MySQL Select 1 from mytable and select null from mytable both return the same number of rows. While select count(1) from mytable returns the rowcount and select count(null) from mytable always returns 0. Why?

  Read the article

• Sorting string column containing numbers in SQL?

  - by Ish

  Dear Folks, I am trying to sort string column (containing numbers). // SELECT `name` FROM `mytable` ORDER BY `name` ASC +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 12 --+ +-- a 2 ---+ +-- a 3 ---+ You see natural sorting algorithm of Mysql is placing a 12 after a 1 (which is ok for most apps), But I have unique needs, so I want result should be sorted like this. +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 2 ---+ +-- a 3 ---+ +-- a 12 --+ Is it possible with just SQL, or I have to manipulate result-set at application level? Thanks for reading...

  Read the article

• What is the use of mysql_rollback() function in PHP?

  - by OM The Eternity

  What is the use of mysql_rollback() function in PHP? How is it used? please explain me with some example, PS: Please Do not give me link to the php.net or, mysql site, I dont need AUTHOR language to understand it, I need the Developer way to understand... I hope u understand... Thanks in advance. UPDATE if i have Updated something in a tanle can i Reset the previous value using this function?

  Read the article

• Whats the best way to design this database scenario?

  - by ankimal

  I want to setup 2 MySQL databases which differ in schema in that, one is normalized and the other is flat for quicker reads and writes. The information being stored in both DBs is the same, but the representation is obviously different owing to the different design approaches. I need to find a robust solution to sync information in real time from my normalized version to my flatter version.

  Read the article

• case insensitive for sql LIKE wildcard statement

  - by David Morrow

  sorry if this is a repeat, i looked around some and didnt find what i was after so here goes SELECT * FROM trees WHERE trees.`title` LIKE '%elm%' this works fine, but not if the tree is named Elm or ELM ect... how do i make sql case insensitive for this wild-card search? again apologies if this is repeated. oh, using MySql 5 on apache

  Read the article

• how not to update timestamp field

  - by GOsha

  project is written on php. There is timestamp field in mysql it updates automatically. In one case I don`t need update this field. Can I gibe instruction not to update this field in this queries without getting timestamp value.

  Read the article

• ADO.NET connection string and password with "=" in it

  - by Philippe Leybaert

  How do I build a connection string which includes a passsword having a "=" in it? (I'm connecting to MySql 5.1) For example, let's say the password is "Ge5f8z=6", what would the connection string look like? I tried: Server=DBSERV;Database=mydb;UID=myuser;PWD="Ge5f8z=6"; and Server=DBSERV;Database=mydb;UID=myuser;PWD=Ge5f8z=6;" Both don't work.

  Read the article

• Materiliaze view in oracle

  - by P Sharma

  How to create/refresh materialize view in oracle 10g.

  Read the article

• which RDBMS or other tool provides good SQL syntax error messages?

  - by zzz

  I use MySQL and it gives no meaningful error messages beyond "syntax wrong close to something or other". This is in sharp contrast to the sort of nice, clear error messages we are used to getting from java compiler and similar. So, are there RDBMS or sql validation tools that provide clearer, meaningful error messages?

  Read the article

• how to do multi insert and obtain ids

  - by liysd

  hi, I want to insert some data into a table (id PK autoincrement, val) with use multi insert INSERT INTO tab (val) VALUES (1), (2), (3) Is it possible to obtain a table of last inserted ids? I'm asking becouse I'm not sure if all will in this form: (n, n+1, n+2). I use mysql inodb.

  Read the article

• make VIEW of SHOW TABLE query

  - by cneeds

  Is there a way to make a VIEW of this SHOW TABLE query? SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table" When I save this as a view (using phpMyAdmin) I get #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table"' at line 4 when phpMyAdmin tries to execute this CREATE ALGORITHM = UNDEFINED VIEW `Tables` AS SHOW FULL TABLES FROM `db_name` WHERE `Table_type` = "Base table"

  Read the article

< Previous Page | 616 617 618 619 620 621 622 623 624 625 626 627  | Next Page >