Search Results

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

Page 446/1168 | < Previous Page | 442 443 444 445 446 447 448 449 450 451 452 453  | Next Page >

• Wait 30 seconds in order to allow a new action on PHP and MySQL ???

  - by DomingoSL

  Hello, in my web page a user fill a form who send information to a MySql database. One of the data inputs sent is a date/time, in the format date('l jS \of F Y h:i:s A'); (I can change the format as needed) So when the user submits the form i wanna check if the actual time/date is 30 seconds more than the sent time/date in order to allow or not the submission of the form. Thanks!

  Read the article

• What's the Correct name for a Association table (many to many relationship)

  - by Imran

  What's the Correct or most popular name for a Association table? I've heard Lookup,associative,resolving,mapping and junction table so far? Thank you in advance;-)

  Read the article

• How can i found out if there is transaction open in MySQL?

  - by praksant

  How can i find out if there is transaction open in mySQL? I need to start new one if there is no transaction open, but i don't want to start new one if there is one running, because that would commit that running transaction.

  Read the article

• How do i escape reserve names in a column? MySQL/Create Table

  - by acidzombie24

  I am generating tables from classes in .NET and one problem is a class may have a field name key which is a reserved mysql keyword. How do i escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique) create table if not exists misc_info ( id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL, key TEXT UNIQUE NOT NULL, value TEXT NOT NULL)ENGINE=INNODB;

  Read the article

• The least amount of code possible for this MySQL query?

  - by ddan

  I have a MySQL query that: gets data from three tables linked by unique id's. counts the number of games played in each category, from each user and counts the number of games each user has played that fall under the "fps" category It seems to me that this code could be a lot smaller. How would I go about making this query smaller. http://sqlfiddle.com/#!2/6d211/1 Any help is appreciated even if you just give me links to check out.

  Read the article

• How to quickly re-sort a MySQL table by one of the columns?

  - by Vacilando

  What are the most efficient SQL queries that would take an existing MySQL table and re-sort it by one of the columns? Not a selection, but the whole table should be sorted by one column. Somehow using a temporary table, I guess, but what's the best way?

  Read the article

• Possible to View Value of Script Variable in MySQL Query Browser's Script Window?

  - by Eric J.

  When stepping through a script in MySQL Query Browser's script window, is there any way to view the value of a variable I have just assigned? Specifically I do an update on one line, and then: SET @Num=row_count(); While debugging the script, I would like to be able to know the value of @Num

  Read the article

• Can i insert an image in a MYSQL DB table?

  - by Shinigami

  is there a way to insert pics(not url,the pic)into a MYSQL table made with phpmyadmin? and if there is when i want to get that picture and insert it in the page , what should i do? :)

  Read the article

• mySQL: How many rows in a table before performance is affected?

  - by Industrial

  Hi everybody, Is there a "known limit" for columns & rows in a mySQL table that when passed, it can be safe to say that performance is severely affected? I've think that I had heard that there is a "golden number" that you really dont want to exceed in either columns or rows in a table. - Or is it all about the size of the index and available RAM + CPU on the server? Thanks!

  Read the article

• ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using Password:YES) [duplicate]

  - by sivashanmugam

  This question already has an answer here: MySQL command appends '@localhost' to username 1 answer Mysql - Access denied for user 'root'@'x.x.x.x' [duplicate] 7 answers root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

  Read the article

• can we build ASP.NET MVC based on MYSQL database?

  - by sam

  Hi Guys, Can we build ASP.NET MVC based on MYSQL database? if yes, is there any article availabe? thanks

  Read the article

• Java / MySQL - How to access connection from another class?

  - by Alex

  I'm just getting my head around java (and OOP for that matter), the only thing I am familiar with is MySQL. I need to keep the DB connection open throughout the duration of the application, as well as a server socket. I'm not even sure if they both need separate classes, but here's what I have so far: http://pastebin.com/qzMFFTrY (it wouldn't all go in a code tag) The variable I need is con for line 86.

  Read the article

• Given a Date "03/13/2010", using that in a MYSQL Where Clause?

  - by nobosh

  I would like to pass a MYSQL query via Coldfusion the following date: 03/13/2010 So the query filters against it like so: SELECT * FROM myTable WHERE dateAdded before or on 03/13/2010 I'd also like to be able to take 2 dates as ranges, from: 01/11/2000, to: 03/13/2010 SELECT * FROMT myTable WHERE dateAdded is ON or Between 01/11/2000 through 03/13/2010 thanks

  Read the article

• How to upload 10 Gb of data to MySQL programmatically without crashing like on PHPMyAdmin?

  - by asksuperuser

  I'm very surprised that it seems impossible to upload more than a few megabytes of data to mysql database through PHPMyAdmin whereas I can upload a msaccess table easily up to 2 Gigabytes. So is there any script in php or anything that can allow to do so unlike phpmyadmin ?

  Read the article

• Decrypting an AES encryted column in mysql and adobe flex/flash builder?

  - by user345593

  How do i decrypt an aes encryted column when using flash/flex to display the table data? adobe flex connected using php connection class to mysql for php, we would use aes_decrypt() however i am not sure how i can get flex to do this.

  Read the article

• How do I do this query in MysQL? (datetime)

  - by alex

  Suppose I have a datetime column in MySQL. How do I select all that have a datetime within 2500 seconds of the current datetime? SELECT ALL where current_datetime - that_datetime < 2500 ...

  Read the article

• Oracle 9i installation problem

  - by newb

  I can not set my oracle home name "OraHome92". Everytime I do it the destination path is changed to "E:\oracle\ora92" but I am instructed to install "D:\oracle\ora92". How can I sove this problem? FYI Facing this problem I installed the oracle with the home name OraHome9. And installl was successful. But after that when started to upgrde to Oracle 9i (9.2.0.6), it was unsuccessful. Waiting for your reply

  Read the article

• MySql: make this query faster… is there a way ? PART TWO

  - by robert

  This is part two of the question: http://stackoverflow.com/questions/2913639/mysql-make-this-query-faster-theres-a-way this query still run slowly: SELECT b.id, b.name, c.name FROM bookcorr as a JOIN books as b on b.id = a.books_id = JOIN Library as c on c.id = a.library_id WHERE a.category_id = '2521' AND a.library_id = '4983' ORDER BY b.name ASC LIMIT 0,15 Any suggest ?

  Read the article

• How should I structure my settings table with mysql?

  - by incrediman

  I want to use MySQL to store a bunch of admin settings - what's the best way to structure the table? Like this? Setting _|_ Value setting1 | a setting2 | b setting3 | c setting4 | d setting5 | e Or like this? |--------|_setting1_|_setting2_|_setting3_|_setting4_|_setting5_| Settings | a | b | c | d | e | Or maybe some other way?

  Read the article

• Find the table(column) that a FK links to? MySql

  - by acidzombie24

  I am ok with mysql. when i use desc tablename i can see columns with MUL meaning it is a foreign key. Now my question is, how do i find out exactly what table and column that column is pointing to.

  Read the article

• What data type to use in MySQL to store images?

  - by rajson

  Hi friends, I need to store image and resume of user in the data base. I am using mysql data base and php5. I need to know which data types I should use. And also how do I set a limit (maximum size) for uploaded data.

  Read the article

• How do you query a MySQL table columns highest entry and store it in a variable.

  - by user315819

  How do you query a MySQL table columns highest entry and store it in a variable. Here is what I have but it is not working. $query = "SELECT MAX(date) FROM Records WHERE ips='$currentip'"; $result = mysql_query($query) or die(mysql_error()); echo $result;

  Read the article

• What's the best way to store sensative data in MySQL?

  - by embedded

  I'm managing the MySQL database from PHP scripts. the communication between server and client is secured via SSL. I store user account data which is sensitive. Is there a way to encrypt this data when entered into the DB? What is the best way to protect this sensitive data? Thanks

  Read the article

• Upgrading from MySQL 4.1 to 5.0 - What kind of performance changes (good or bad) can we expect?

  - by user367579

  Currently have approximately 2000 simultaneouse connections. We average approximately 425 reads and writes per second. We have a read to write ration of 3:1. All of our tables are myisam. Can we expect better or worse performance when we go from mysql 4.1.22 to 5.0?

  Read the article

• What’s New in JD Edwards EnterpriseOne Release 9.1

  - by Breanne Cooley

  Oracle JD Edwards EnterpriseOne 9.1 offers customers significant updates to usability and business processes to improve productivity and bolster business value. This release addresses critical user needs, while delivering key enhancements in several areas, including:  New User Experience Release 9.1 offers significant enhancements to the user experience. New Web 2.0 features reduce task time and enable you to access meaningful information. Enhanced Reporting Oracle’s JD Edwards EnterpriseOne One View Reporting is a breakthrough solution that allows business users to create interactive reports - without IT support. Industry Specific Functionality This new release delivers key enhancements for the consumer goods, real estate management and manufacturing and distribution industries. Enhanced Support for Global Operations JD Edwards EnterpriseOne 9.1 supports global operations with several new features, including enhancements that consider the entire ERP business process associated with managing country of origin requirements. Productivity Features This new release offers new more tightly integrated business processes and other productivity advancements like improved data access and enhanced financial controls. Want to find out more? ü Bookmark the JD Edwards EnterpriseOne web page ü Listen to the Podcast: Announcing JD Edwards EnterpriseOne 9.1  ü Watch the Demo: JD Edwards EnterpriseOne 9.1 Features Demo ü Watch the Demo: JD Edwards EnterpriseOne One View Reporting Demo  ü Review the Data Sheet: JD Edwards EnterpriseOne Tools 9.1  New Training JD Edwards EnterpriseOne 9.1 training through Oracle University is designed to help you leverage these usability and productivity enhancements. The curriculum is aligned to the JD Edwards EnterpriseOne products and will teach your team how to efficiently and effectively implement and use your applications. Get started today! View available training and schedules.   -Jim Vonick, Oracle University Market Development Manager 

  Read the article

< Previous Page | 442 443 444 445 446 447 448 449 450 451 452 453  | Next Page >