Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.
Articles & Videos
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.
I have 2 unrelated tables "customers" and "categories"
customers has 2 fields custID and custName
categories has 2 fields catID and CatName
I have a 3rd table custcats that I want to insert Data…
I was given the following code to create some tables in MySQL:
create table vt_staff (
stf_id decimal(6,0) primary key
, stf_name_last varchar(25) not null
I originally used mysqli object oriented way to log users in but am moving over to prepared statements. My problem is that with this code, as long as the email address is in the database, any password…
Could you please help me with displaying the images stored in the database table on a webpage. I have a database table with 8 columns as shown in the picture below. Sometimes each row…
I use 2 and in one sql statement,
but it is not working,
could you please check what's wrong with my code
$sql = "SELECT * FROM siparis where uid = '$uid' and _key = '$siparisno' a…
This is my query:(CODE)Here is the table structure:(CODE)What indexes could be added to increase the performance/speed of the query?
I have the following table :
And I performed the following query :
In the output the key column had value NULL
which is expected as there is not index on user column.
I have the following table :
And i will be performing only the following queries on this table :
The first query can be alternatively thought of as where conversation, user i…
I'm trying to put together a query that as part of the select, it takes the datetime stamp that the row was added and todays date and returns the number of days that have passed.
I want to create single store procedure in php mysql for all operations. Where I want pass all parameters including table name and column name. I don't want to create 100 procedure for my 100…
Using MySQL, how can I get a list of ALL items that have a duplicate `NumericID`?
In this example, it only shows the first matching duplicate.
I need these results to be returned:(CODE)However, "10 Smiles" is included in the results 3 times. Each item should only be included once, and if there is a matc…
I have a MySQL dump file named: "xyz.sql" that is about 10 gigabytes. Is there a way to get the names of the tables from the .sql file from the Linux command line without having to download the file …
I use Ubuntu 14.04.1 Desktop and in PhpMy Admin I see this:
Database client version: libmysql - 5.5.50
But when I do this in the terminal:
I get ver. 5.5.52
Also in S…
sql server 2008 r2
I have an id_column that is varchar(50)
I have this query where I'm trying to pullout data in sequence piece by piece. into a text file.
what is the sql sentence to copy a column to the a new coloumn?
I want to create a copy of a column
when use PhpMyAdmin, I can easily see what content my tables have.
When I use PhpMyAdmin, I double click the table's row, I can edit the table data easliy.
But when I import a table to mysql databas…
I have an old and new database with different config as follows.
Old -`id` varchar(36) CHARACTER SET latin1 NOT NULL,
New - `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
Can I alter the …
We have vtiger crm and MySQL database. We have access to the DB but some table we have not been able to identify. Any EE knows of vtiger tables or some sort of link that would describe them?
Any assistance would be greatly appreciated. BIG THANKS!!!
Delete items that are no longer available in the database:
1) I would like a query to compare the 'Item Number' column fr…
I'm using Ray Paseur PHP Client Registration, Login, Logout and Easy Access Control pages.
I have created a database for my users and I already set their user name and password for t…
Hi All ,
I want to install my sql Db on an ubuntu server. No idea how to do this. Never installed sql. Also how to define below:
/** The name of the database for WordPress */
I have some Pictures stored in a MySQL database. Yeah yeah... I know it's not the best solution, but I didn't have a safe option to put them on a fileserver. Anyway... What is the best way …
I need to adapt this Mysql query, this will be a manual query that I will run from PHPMyAdmin
I want to replace consecutive space by only one -
report summer 2016.p…
Introduction A frequent design pattern question for new PHP developers goes something like this, "How do I handle client registration and login?" It's done in every framework and CMS, and all …
Introduction This article is very old, and while most of its principles are sound, PHP programming has changed a lot in the last decade. For that reason, I've updated this information in another arti…