Skip to content

Instantly share code, notes, and snippets.

@KOUISAmine
Created February 8, 2017 00:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save KOUISAmine/abedc103f1476f551af1b9fbf4cba77b to your computer and use it in GitHub Desktop.
Save KOUISAmine/abedc103f1476f551af1b9fbf4cba77b to your computer and use it in GitHub Desktop.
Simple upload en drag and drop avec MySQLi
--
-- Database: `image`
--
CREATE TABLE `photo` (
`photo_id` int(11) NOT NULL,
`photo_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Indexes pour la table `photo`
--
ALTER TABLE `photo`
ADD PRIMARY KEY (`photo_id`);
--
-- AUTO_INCREMENT pour la table `photo`
--
ALTER TABLE `photo`
MODIFY `photo_id` int(11) NOT NULL AUTO_INCREMENT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment